diff options
| -rw-r--r-- | application/layouts/default.phtml | 28 | ||||
| -rw-r--r-- | pbs-data.sql | 72 |
2 files changed, 4 insertions, 96 deletions
diff --git a/application/layouts/default.phtml b/application/layouts/default.phtml index 3b15a03..3fb177d 100644 --- a/application/layouts/default.phtml +++ b/application/layouts/default.phtml @@ -21,33 +21,13 @@ echo $this->headScript()."\n"; <body> <div id='sidepannel'> <div id="logo"><div id="logo-bar-gray"></div></div> - <div id="sidepannel-top"> - <h1>default</h1> + <div id="sidepannel-top"> <ul> <li>Controller: <ul> - <li><a href='/dev/person'>Person</a></li> - <li><a href='/dev/group'>Group</a></li> - <li><a href='/dev/role'>Role</a></li> - <li><a href='/dev/bootiso'>BootIso</a></li> - <li><a href='/dev/bootmenu'>BootMenu</a></li> - <li><a href='/dev/config'>Config</a></li> - <li><a href='/dev/bootos'>BootOs</a></li> - <li><a href='/dev/client'>Client</a></li> - <li><a href='/dev/filter'>Filter</a></li> - <li><a href='/dev/pool'>Pool</a></li> - <li><a href='/dev/session'>Session</a></li> - <?php if (!Zend_Auth::getInstance()->hasIdentity()) {?> - <li><a href='/dev/auth/login'>Login</a></li> - <li><a href='/dev/auth/register'>Register</a></li> - <?php - } else {?> - <li><a href='/dev/auth/delete'>Account Löschen</a></li> - <li><a href='/dev/auth/logout'>Logout</a></li> - <?php - } - ?> - </ul> + <li><a href='/dev'>Dev</a></li> + <li><a href='/user'>User</a></li> + <li><a href='/fbgui'>fbgui</a></li> </li> </ul> diff --git a/pbs-data.sql b/pbs-data.sql deleted file mode 100644 index 5035bfa..0000000 --- a/pbs-data.sql +++ /dev/null @@ -1,72 +0,0 @@ -USE pbs; -SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; - --- Insert example data for filters -INSERT INTO `pbs`.`pbs_group` (`groupID` ,`title` ,`description`)VALUES (NULL , 'testgruppe1', NULL); -INSERT INTO `pbs`.`pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES (NULL, 'Mr.Test', 'te', 'st', NULL, NULL, NULL, NULL, NULL, '', '', 'test', '', ''); -INSERT INTO `pbs`.`pbs_role` (`roleID`, `groupID`, `title`, `description`) VALUES (NULL, '1', 'Testrolle', NULL); -INSERT INTO `pbs`.`pbs_membership` (`membershipID`, `groupID`, `roleID`, `personID`) VALUES (NULL, '1', '1', '1'); - -INSERT INTO `pbs`.`pbs_bootmenu` (`bootmenuID`, `membershipID`, `groupID`, `title`, `created`) VALUES (NULL, '1', '1', 'Bootmenu 1', UNIX_TIMESTAMP()); -INSERT INTO `pbs`.`pbs_bootmenu` (`bootmenuID`, `membershipID`, `groupID`, `title`, `created`) VALUES (NULL, '1', '1', 'Bootmenu 2', UNIX_TIMESTAMP()); -INSERT INTO `pbs`.`pbs_bootmenu` (`bootmenuID`, `membershipID`, `groupID`, `title`, `created`) VALUES (NULL, '1', '1', 'Bootmenu 3', UNIX_TIMESTAMP()); - -INSERT INTO `pbs`.`pbs_filter` (`filterID`, `membershipID`, `groupID`, `bootmenuID`, `title`, `description`, `created`, `priority`) VALUES (NULL, '1', '1', '1', 'Filter 1', NULL, UNIX_TIMESTAMP(), '1'); -INSERT INTO `pbs`.`pbs_filter` (`filterID`, `membershipID`, `groupID`, `bootmenuID`, `title`, `description`, `created`, `priority`) VALUES (NULL, '1', '1', '2', 'Filter 2', NULL, UNIX_TIMESTAMP(), '5'); -INSERT INTO `pbs`.`pbs_filter` (`filterID`, `membershipID`, `groupID`, `bootmenuID`, `title`, `description`, `created`, `priority`) VALUES (NULL, '1', '1', '2', 'Filter 3', NULL, UNIX_TIMESTAMP(), '9'); - -INSERT INTO `pbs_filterentries` (`filterentriesID`, `filterID`, `filtertypeID`, `filtervalue`, `filtervalue2`) VALUES -(1, 1, 1, '100.100.100.100', '200.200.200.200'), -(3, 1, 7, '08-00', '22-00'), -(4, 2, 7, '08-00', '19-00'), -(5, 3, 7, '12-00', '18-00'), -(6, 3, 2, '00:1e:0b:27:f4:00', '00:1e:0b:27:f4:f0'); - --- Inser example data for clients and pools -INSERT INTO `pbs_client` (`clientID`, `macadress`, `hardwarehash`) VALUES -(1, '00:1e:0b:27:f4:99', 'ea9b82d9de911bc2d3cd23f53a6cab48'), -(2, '00:10:0a:25:44:69', '1e2b1599710fbbef0dc789e8cfe12455'), -(3, '01:50:2a:24:42:60', '8f6209ca3d6b35e223a11c249d1b69fc'), -(4, '04:34:26:9a:92:90', 'e17ab09f3586464f19629e2e8b1e9a9d'), -(5, '44:74:26:9a:92:90', '9bf70279d283b85440c2031c19bb6812'), -(6, '64:24:26:9a:92:90', 'ad3bce4464a6267441ec144744439c7e'), -(7, '84:94:26:9a:92:90', 'e8d7e80d79f224771b7a3a0af4e02748'), -(8, 'b4:84:26:9a:92:90', 'ded66ce272f384e9e386c1b57ded3e4d'), -(9, '24:64:26:9a:92:90', '695610ee509c060b1fca9c8011529af4'), -(10, '84:34:26:9a:92:90', 'a3562c8cad2a4fa4fc11656025dc911b'); - -INSERT INTO `pbs`.`pbs_pool` (`poolID`, `title`, `description`, `location`) VALUES -(1, 'Pool 1', 'Description 1', 'Keller'), -(2, 'Pool 2', 'Description 2', 'Keller'), -(3, 'Pool 3', 'description 3', 'Keller'); - - -INSERT INTO `pbs_poolentries` (`poolentriesID`, `poolID`, `clientID`) VALUES -(1, 1, 1), -(2, 1, 2), -(3, 1, 3), -(4, 1, 4), -(5, 1, 5), -(6, 2, 6), -(7, 2, 7), -(8, 2, 8), -(9, 3, 9), -(10, 3, 10); - --- Insert Data for Sessions -INSERT INTO `pbs`.`pbs_config` (`configID`, `title`, `groupID`, `membershipID`, `shellscript`, `created`) VALUES -(NULL, 'Config 1', '1', '1', 'Shellscirpt', UNIX_TIMESTAMP()); - -INSERT INTO `pbs`.`pbs_bootos` (`bootosID`, `configID`, `groupID`, `membershipID`, `title`, `description`, `path_init`, `path_kernel`, `defaultkcl`, `created`, `expires`, `public`) VALUES -(1, 1, 1, 1, 'BootOS 1', 'Description', '', '', '', '', NULL, 0); - -INSERT INTO `pbs_bootiso` (`bootisoID`, `title`, `membershipID`, `groupID`, `path`, `serialnumber`, `created`, `expires`, `public`) VALUES -(1, 'BootISO 1', 1, 1, '', 1337, '', NULL, 1), -(2, 'BootISO 2', 1, 1, '', 1337, '', NULL, 1); - -INSERT INTO `pbs_person` (`personID`, `title`, `name`, `firstname`, `street`, `housenumber`, `city`, `postalcode`, `logindate`, `registerdate`, `email`, `login`, `password`, `password_salt`) VALUES -(3, '1', '2', '3', '4', '5', '6', '7', NULL, '1299612370', 'test', NULL, '4207acba08cadccc397e2302a55b339a', 'f21ee663b17bcefc6868694dffda602a'); - -INSERT INTO `pbs`.`pbs_session` (`sessionID`, `clientID`, `bootosID`, `bootisoID`, `time`, `ip`, `ip6`) VALUES (NULL, '1', '1', '1', UNIX_TIMESTAMP(), '1.1.1.2', NULL); - - |