Changeset 18
- Timestamp:
- Oct 21, 2008, 4:15:52 PM (16 years ago)
- Files:
-
- 8 edited
Legend:
- Unmodified
- Added
- Removed
-
base.php
r17 r18 5 5 global $Database, $Types, $Config; 6 6 7 //if(!CheckPermission('Read', $List['Id'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 7 if(!CheckPermission('Read', $List['ItemId'])) 8 { 9 if($Column != '') return(''); 10 else return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 11 } 8 12 9 13 if($Title == '') $Output = '<div>'.$List['Title'].'</div>'; … … 33 37 if(array_key_exists('OrderColumn', $_GET)) 34 38 { 35 if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse orde d39 if($_SESSION['OrderColumn'] == $_GET['OrderColumn']) // Same column => reverse order 36 40 $_SESSION['OrderDirection'] = ($_SESSION['OrderDirection'] + 1) % 2; 37 41 if($_SESSION['OrderTable'] != $List['TableName']) // Different table => set ascending order … … 65 69 } 66 70 } 67 $Output .= '<td><a href="?Action=ViewItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a> <a href="?Action=EditItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'"><img border="0" src="images/edit.png" alt="Editovat" title="Editovat"></a> <a href="?Action=DeleteItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'"><img border="0" src="images/delete.png" alt="Smazat" title="Smazat"></a></td></tr>'; 71 $Output .= '<td>'; 72 if(CheckPermission('Read', $List['ItemId'])) $Output .= '<a href="?Action=ViewItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a>'; 73 if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=EditItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'"><img border="0" src="images/edit.png" alt="Editovat" title="Editovat"></a>'; 74 if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=DeleteItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'"><img border="0" src="images/delete.png" alt="Smazat" title="Smazat"></a>'; 75 $Output .= '</td></tr>'; 68 76 } 69 77 $Output .= '</table>'; 70 78 $PageList = PagesList($Page, $TotalItemCount); 71 79 if(strlen($PageList) != 0) $Output .= $PageList.'<br />'; 72 $Output .= ' <a href="?Action=AddItem&Table='.$List['TableName'].$ColumnSelection.'">Přidat</a> '.$FullListLink;80 if(CheckPermission('Write', $List['ItemId'])) $Output .= ' <a href="?Action=AddItem&Table='.$List['TableName'].$ColumnSelection.'">Přidat</a> '.$FullListLink; 73 81 return($Output); 74 82 } … … 86 94 $Output .= '<th><a href="?OrderColumn='.$Item['Name'].'">'.$Item['TextBefore'].'</a></th>'; 87 95 } 88 $Output .= '<th><a href="?OrderColumn=Author">Autor</a></th><th><a href="?OrderColumn=CreationTime">Čas vytvoření</a></th><th> Akce</th></tr>';96 $Output .= '<th><a href="?OrderColumn=Author">Autor</a></th><th><a href="?OrderColumn=CreationTime">Čas vytvoření</a></th><th><a href="?OrderColumn=CreationTime">Čas odstranění</a></th><th>Akce</th></tr>'; 89 97 90 98 $Where = ' AND (ItemId='.$Id.')'; … … 127 135 } 128 136 } 129 echo($TypeNames['PointerOneToUser']); 130 $Item = array('Name' => 'Author', 'Type' => $TypeNames['PointerOneToUser']); 137 //print_r($TypeNames); 138 //print_r($Types); 139 $Item = array('Name' => 'Author', 'Type' => $TypeNames['PointerToUser']); 140 //print_r($Item); 131 141 $ItemType = explode('|', $Types[$Item['Type']]['Parameters']); 132 142 $Type = $Types[$ItemType[0]]; … … 136 146 $Output .= '<td>'.$Value.'</td>'; 137 147 138 $Output .= '<td>'.$DbRow['CreationTime'].'</td> ';148 $Output .= '<td>'.$DbRow['CreationTime'].'</td><td>'.$DbRow['DeletionTime'].'</td>'; 139 149 $Output .= '<td><a href="?Action=ViewItem&Table='.$List['TableName'].'&Item='.$DbRow['Id'].'"><img border="0" src="images/view.png" alt="Zobrazit" title="Zobrazit"></a></td></tr>'; 140 150 } … … 149 159 global $Database, $Types; 150 160 161 if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 151 162 $DbResult = $Database->select($List['TableName'], '*', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1'); 152 163 while($DbRow = $DbResult->fetch_array()) … … 184 195 global $Database, $Types, $System, $LogActionType; 185 196 197 if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 186 198 $DbResult = $Database->select($List['TableName'], '*', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1'); 187 199 while($DbRow = $DbResult->fetch_array()) … … 220 232 global $Database, $Types; 221 233 234 if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 222 235 $DefinitionItems = array(); 223 236 $AfterTableOutput = ''; … … 260 273 global $Database, $Types, $System, $LogActionType; 261 274 275 if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 262 276 $DefinitionItems = array(); 263 277 $AfterTableOutput = ''; … … 298 312 global $Database, $Types, $Lists; 299 313 314 if(!CheckPermission('Read', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 300 315 $Output = ''; 301 316 $DbResult = $Database->select($List['TableName'], '*', 'ItemId='.$Id.' ORDER BY Id DESC LIMIT 1'); … … 317 332 ); 318 333 $Output .= $Form->ShowReadOnlyForm(); 319 $Output .= '<a href="?Action=EditItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'">Editovat</a> ';334 if(CheckPermission('Write', $List['ItemId'])) $Output .= '<a href="?Action=EditItem&Table='.$List['TableName'].'&Item='.$DbRow['ItemId'].'">Editovat</a> '; 320 335 321 336 if(($Column != '') and ($ColumnValue != 0)) … … 344 359 global $Database, $Lists, $System, $LogActionType; 345 360 361 if(!CheckPermission('Write', $List['ItemId'])) return(SystemMessage('Řízení přístupu', 'Nemáte dostatečná oprávnění')); 346 362 $System->Modules['Log']->Add($List['Id'], $Id, $LogActionType['Delete']); 347 363 $System->Modules['DatabaseList']->DeleteItem($List['TableName'], $Id); … … 359 375 while($DbRow = $DbResult->fetch_assoc()) 360 376 { 361 $ Output .= '<strong>'.$DbRow['Name'].'</strong><br />';377 $Group = ''; 362 378 $DbResult2 = $Database->query('SELECT t1.* FROM `SystemList` AS t1 LEFT JOIN `SystemList` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND (t1.DeletionTime IS NULL) AND (t1.`Menu` = '.$DbRow['ItemId'].')'); 363 379 while($DbRow2 = $DbResult2->fetch_assoc()) 364 380 { 365 //if(($List['System'] == $System) and ($List['VisibleInMenu'] == 1))366 //if(CheckPermission('Read', $List['Id']))367 $Output .= '<a href="?Action=ShowList&Table='.$DbRow2['TableName'].'">'.$DbRow2['Title'].'</a><br />';368 }369 $Output .='<br />';381 if(CheckPermission('Read', $DbRow2['ItemId'])) 382 $Group .= '<a href="?Action=ShowList&Table='.$DbRow2['TableName'].'">'.$DbRow2['Title'].'</a><br />'; 383 } 384 if($Group != '') 385 $Output .= '<strong>'.$DbRow['Name'].'</strong><br />'.$Group.'<br />'; 370 386 } 371 387 $Output .= '<br />'; … … 440 456 $List = array( 441 457 'Id' => $DbRow['Id'], 458 'ItemId' => $DbRow['ItemId'], 442 459 'TableName' => $DbRow['TableName'], 443 460 'Title' => $DbRow['Title'], 444 'System' => $DbRow['System'],445 'VisibleInMenu' => $DbRow['VisibleInMenu'],446 461 'Items' => $Items, 447 462 ); … … 513 528 global $Database, $System; 514 529 515 $DbResult = $Database->query('SELECT t1.* FROM `Permission` AS t1 LEFT JOIN `Permission` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND t1.PermissionGroup = (SELECT PermissionGroup.Id FROM PermissionGroup WHERE PermissionGroup.Id=(SELECT User.PermissionGroup FROM User WHERE User.ItemId='.$System->Modules['User']->User['Id'].' ORDER BY User.Id DESC LIMIT 1) ORDER BY PermissionGroup.Id DESC LIMIT 1) AND t1.DeletionTime IS NULL AND t1.List='.$ListId); 530 $Result = FALSE; 531 //return(TRUE); 532 $DbResult = $Database->query('SELECT t1.* FROM `Permission` AS t1 LEFT JOIN `Permission` AS t2 ON t1.ItemId=t2.ItemId AND t1.Id < t2.Id WHERE (t2.ItemId IS NULL) AND t1.PermissionGroup = (SELECT PermissionGroup.Id FROM PermissionGroup WHERE PermissionGroup.Id=(SELECT User.PermissionGroup FROM User WHERE User.ItemId='.$System->Modules['User']->User['ItemId'].' ORDER BY User.Id DESC LIMIT 1) ORDER BY PermissionGroup.Id DESC LIMIT 1) AND t1.DeletionTime IS NULL AND t1.List='.$ListId); 516 533 if($DbResult->num_rows > 0) 517 534 { … … 519 536 switch($DbRow['Right']) 520 537 { 521 case 0: return(array('Read' => FALSE, 'Write' => FALSE)); 522 case 1: return(array('Read' => TRUE, 'Write' => FALSE)); 523 case 2: return(array('Read' => TRUE, 'Write' => TRUE)); 524 } 525 } 538 case 0: $Privileges = array('Read' => FALSE, 'Write' => FALSE); break; 539 case 1: $Privileges = array('Read' => TRUE, 'Write' => FALSE); break; 540 case 2: $Privileges = array('Read' => TRUE, 'Write' => TRUE); break; 541 } 542 $Result = $Privileges[$Right]; 543 } 544 //print_r($Privileges); 545 //echo($DbRow['Right'].' '.$Result.'<br>'); 546 return($Result); 526 547 } 527 548 -
index.php
r16 r18 39 39 if($_GET['Action'] == 'Login') 40 40 { 41 $Output .= $this->SystemMessage('Přihlášení', $this->System->Modules['User']->Login($_POST['UserName'], $_POST['Password'])); 41 $Form = new Form(); 42 $Form->Definition = $FormUserLogin; 43 $Form->LoadValuesFromForm(); 44 $Output .= $this->SystemMessage('Přihlášení', $this->System->Modules['User']->Login($Form->Values['UserName'], $Form->Values['Password'])); 42 45 } else 43 46 if($_GET['Action'] == 'Logout') … … 73 76 if($this->System->Modules['User']->User['Id'] == 0) 74 77 { 75 if(!array_key_exists('Action', $_GET))78 //if(!array_key_exists('Action', $_GET)) 76 79 { 77 80 $Output .= '<a href="'.$this->System->Config['Web']['RootFolder'].'/?Action=LoginForm">Přihlášení</a><br /><a href="'.$this->System->Config['Web']['RootFolder'].'/?Action=UserRegister">Registrace</a>'; -
sql/demo_database.sql
r11 r18 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Pondělí 13. října 2008, 08:006 -- Vygenerováno: Úterý 21. října 2008, 16:14 7 7 -- Verze MySQL: 5.0.51 8 8 -- Verze PHP: 5.2.6 … … 39 39 `HostList` int(11) NOT NULL, 40 40 PRIMARY KEY (`Id`) 41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 9;41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ; 42 42 43 43 -- … … 53 53 (6, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-09 14:04:59', NULL, 'kk', '', '', '', '', '', '', '', '', 0), 54 54 (7, 2, 0, '2008-10-09 14:09:48', NULL, '2008-10-09 14:09:48', NULL, 'kk', 'sss', '', '', '', '', '', '', '', 0), 55 (8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', '2008-10-13 07:56:32', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0); 55 (8, 2, 5, '2008-10-09 14:43:13', NULL, '2008-10-09 14:43:13', '2008-10-13 07:56:32', 'Ahoj', 'sss', '', '', '', '', '', '', '', 0), 56 (9, 5, 5, '2008-10-19 20:00:47', NULL, '2008-10-19 20:00:47', NULL, 'Czfree', '10.0.0.0', '255.0.0.0', '', '', '', 'czf', 'czfree', '', 0); 56 57 57 58 -- -------------------------------------------------------- … … 77 78 `PurcheasedFrom` int(11) NOT NULL, 78 79 PRIMARY KEY (`Id`) 79 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 5;80 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=17 ; 80 81 81 82 -- … … 97 98 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Edimax gigabit switch 8-port', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 750, 2, 'EDW8-423423-333', 9), 98 99 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VoIP adaptér Zyxel VO-112', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 1342, 2, 'ZXS422Z33', 9), 99 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9); 100 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IP kamera Vivotek IP-224', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3744, 2, 'VOWW623335', 9), 101 (15, 9, 5, '2008-10-14 07:20:25', NULL, '2008-10-14 07:20:25', '2008-10-16 12:24:44', 'Všesměrová anténa Omni 10 dBi', '2001-01-01 00:00:00', '2066-01-01 00:00:00', 1043, 2, 'OMNI123533', 9), 102 (16, 9, 5, '2008-10-16 12:24:44', NULL, '2008-10-16 12:24:44', NULL, 'Všesměrová anténa Omni 10 dBi', '2001-01-01 00:00:00', '2066-01-01 00:00:00', 1050, 2, 'OMNI123533', 9); 100 103 101 104 -- -------------------------------------------------------- … … 130 133 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vedlejší účet', 'Komerční banka', '5543332', '0400', 2, 2), 131 134 (3, 3, 4, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Pomocný - vedení zdarma', 'Mbank', '24522266', '0156', 1, 2); 135 136 -- -------------------------------------------------------- 137 138 -- 139 -- Struktura tabulky `CableTV` 140 -- 141 142 CREATE TABLE IF NOT EXISTS `CableTV` ( 143 `Id` int(11) NOT NULL auto_increment, 144 `Name` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL, 145 `Frequency` int(11) NOT NULL default '0', 146 `Norm` varchar(8) character set utf8 collate utf8_czech_ci NOT NULL, 147 `Homepage` varchar(255) character set utf8 collate utf8_czech_ci NOT NULL, 148 `Language` varchar(32) character set utf8 collate utf8_czech_ci NOT NULL, 149 `ShortName` varchar(16) character set utf8 collate utf8_czech_ci NOT NULL, 150 `ItemId` int(11) NOT NULL, 151 `Author` int(11) NOT NULL, 152 `ValidTimeFrom` datetime default NULL, 153 `ValidTimeTo` datetime default NULL, 154 `CreationTime` datetime default NULL, 155 `DeletionTime` datetime default NULL, 156 PRIMARY KEY (`Id`) 157 ) ENGINE=MyISAM DEFAULT CHARSET=latin2 AUTO_INCREMENT=25 ; 158 159 -- 160 -- Vypisuji data pro tabulku `CableTV` 161 -- 162 163 INSERT INTO `CableTV` (`Id`, `Name`, `Frequency`, `Norm`, `Homepage`, `Language`, `ShortName`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES 164 (1, 'STV 1', 49218, 'pal-bg', 'http://www.stv.sk/', 'slovensky', 'stv1', 1, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 165 (2, 'Galaxie Sport', 230687, 'pal-bg', 'http://www.galaxie-sport.cz/', 'česky', 'galaxia_sport', 2, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 166 (3, 'STV 2', 76650, 'pal-bg', 'http://www.stv.sk/', 'slovensky', 'stv2', 3, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 167 (4, 'TVN', 150937, 'pal-bg', 'http://tvn.pl/', 'polsky', 'tvn', 4, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 168 (5, 'CNN', 158718, 'pal-bg', 'http://www.cnn.com/', 'anglicky', 'cnn', 5, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 169 (6, 'Nova', 175381, 'pal-dk', 'http://www.nova.cz/', 'česky', 'nova', 6, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 170 (7, 'Prima', 190781, 'pal-dk', 'http://www.iprima.cz/', 'česky', 'prima', 7, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 171 (8, 'JOJ', 198718, 'pal-bg', 'http://www.joj.sk/', 'slovensky', 'joj', 8, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 172 (9, 'ČT2', 206937, 'pal-dk', 'http://www.ceskatelevize.cz/', 'česky', 'ct2', 9, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 173 (10, 'Infokanál', 214843, 'pal-bg', '', 'česky', 'infokanal', 10, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 174 (11, 'ČT1', 223125, 'pal-dk', 'http://www.ceskatelevize.cz/', 'česky', 'ct1', 11, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 175 (12, 'Markíza', 58781, 'pal-bg', 'http://www.markiza.sk/', 'slovenky', 'markiza', 12, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 176 (13, 'Discovery', 237781, 'pal-bg', 'http://www.discoverychannel.cz/', 'česky', 'discovery', 13, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 177 (14, 'Eurosport', 470781, 'pal-bg', 'http://www.eurosport.cz/', 'česky', 'eurosport', 14, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 178 (15, 'DSF', 486718, 'pal-bg', 'http://www.dsf.de/', 'německy', 'dsf', 15, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 179 (16, 'VIVA 1', 502718, 'pal-bg', 'http://www.viva.tv/', 'německy', 'viva1', 16, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 180 (17, 'VIVA 2', 518718, 'pal-bg', 'http://www.viva.tv/', 'německy', 'viva2', 17, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 181 (18, 'MTV', 534718, 'pal-bg', 'http://www.mtv.tv/', 'německy', 'mtv', 18, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 182 (19, 'ZDF', 550718, 'pal-bg', 'http://www.zdf.de/', 'německy', 'zdf', 19, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 183 (20, 'Noe', 244781, 'pal-bg', 'http://www.tvnoe.cz/', 'česky', 'noe', 20, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 184 (21, 'RTL', 166718, 'pal-bg', 'http://www.rtl.de/', 'německy', 'rtl', 21, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 185 (22, 'NOVA Cinema', 252250, 'pal-bg', 'http://novacinema.nova.cz/', 'česky', 'nova_cinema', 22, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 186 (23, 'ČT 24', 273250, 'pal-bg', 'http://www.ct24.cz/', 'česky', 'ct24', 23, 5, NULL, NULL, '2008-10-21 16:05:26', NULL), 187 (24, 'ČT 4 Sport', 280250, 'pal-bg', 'http://www.ct24.cz/sport/', 'česky', 'ct4sport', 24, 5, NULL, NULL, '2008-10-21 16:05:26', NULL); 132 188 133 189 -- -------------------------------------------------------- … … 152 208 `Type` int(11) NOT NULL, 153 209 `InsertedByUser` int(11) NOT NULL, 154 PRIMARY KEY (`Id`) 155 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 210 `Document` int(11) NOT NULL, 211 PRIMARY KEY (`Id`) 212 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ; 156 213 157 214 -- … … 159 216 -- 160 217 161 INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`) VALUES 162 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1), 163 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11), 164 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11), 165 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11); 218 INSERT INTO `FinanceTransaction` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Description`, `Amount`, `SourceSubject`, `TargetSubject`, `Time`, `Type`, `InsertedByUser`, `Document`) VALUES 219 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit 2008/05', 360, 2, 11, '0000-00-00 00:00:00', 0, 1, 0), 220 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Zřízení přípojky', 4300, 10, 11, '0000-00-00 00:00:00', 1, 11, 0), 221 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '0000-00-00 00:00:00', 0, 11, 0), 222 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '0000-00-00 00:00:00', 0, 11, 0), 223 (31, 2, 5, '2008-10-14 09:20:19', NULL, '2008-10-14 09:20:19', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 4), 224 (30, 2, 5, '2008-10-14 09:17:42', NULL, '2008-10-14 09:17:42', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 0), 225 (29, 2, 5, '2008-10-14 09:16:57', NULL, '2008-10-14 09:16:57', NULL, 'Zřízení přípojky', 4300, 10, 11, '1900-01-01 00:00:00', 1, 11, 0), 226 (28, 3, 5, '2008-10-14 09:16:34', NULL, '2008-10-14 09:16:34', NULL, 'Internet 8 Mbit 2008/05', 750, 8, 11, '1900-01-01 00:00:00', 0, 11, 3), 227 (27, 4, 5, '2008-10-14 09:16:00', NULL, '2008-10-14 09:16:00', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 2), 228 (26, 4, 5, '2008-10-14 09:07:57', NULL, '2008-10-14 09:07:57', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0), 229 (25, 4, 5, '2008-10-14 09:05:45', NULL, '2008-10-14 09:05:45', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0), 230 (24, 4, 5, '2008-10-14 09:03:32', NULL, '2008-10-14 09:03:32', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 1), 231 (23, 4, 5, '2008-10-14 09:02:31', NULL, '2008-10-14 09:02:31', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0), 232 (22, 4, 5, '2008-10-14 09:01:39', NULL, '2008-10-14 09:01:39', NULL, 'Vrácení přeplatku', 231, 11, 8, '1900-01-01 00:00:00', 0, 11, 0); 166 233 167 234 -- -------------------------------------------------------- … … 189 256 `Member` int(11) NOT NULL, 190 257 `Area` int(11) NOT NULL, 191 PRIMARY KEY (`Id`) 192 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=10 ; 258 `SubHostList` int(11) NOT NULL, 259 PRIMARY KEY (`Id`) 260 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ; 193 261 194 262 -- … … 196 264 -- 197 265 198 INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`) VALUES 199 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0), 200 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0), 201 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2), 202 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4), 203 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2), 204 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1), 205 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0), 206 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0), 207 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0); 266 INSERT INTO `Host` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `DomainName`, `NetBIOSName`, `LocalIPAddress`, `PublicIPAddress`, `LastOnlineDate`, `Type`, `Interface`, `ParentHost`, `Member`, `Area`, `SubHostList`) VALUES 267 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'george', 'GEORGE', '192.168.0.23', '', '0000-00-00', 1, 0, 4, 0, 0, 0), 268 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'stroj', 'STROJ', '192.168.1.44', '33.66.44.77', '0000-00-00', 5, 0, 0, 0, 0, 0), 269 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'telefon', 'TELEFON', '192.168.1.45', '', '0000-00-00', 2, 0, 4, 1, 2, 0), 270 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'router-inet', 'ROUTER-INET', '192.168.0.2', '77.33.55.12', '0000-00-00', 4, 0, 1, 1, 4, 0), 271 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'muhehe', 'MUHEHE', '192.168.0.4', '', '0000-00-00', 1, 0, 1, 1, 2, 0), 272 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'jonny', 'JONNY', '192.168.0.6', '', '0000-00-00', 1, 0, 1, 1, 1, 0), 273 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 20:01:24', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '0000-00-00', 6, 0, 0, 0, 0, 0), 274 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'www', 'WWW', '192.168.0.7', '34.22.1.4', '0000-00-00', 5, 0, 0, 0, 0, 0), 275 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'peklo', 'PEKLO', '192.168.66.66', '', '0000-00-00', 7, 0, 4, 2, 0, 0), 276 (10, 1, 5, '2008-10-13 13:52:04', NULL, '2008-10-13 13:52:04', NULL, 'george', 'GEORGE', '192.168.0.23', '', '1900-01-01', 1, 0, 4, 1, 4, 0), 277 (11, 7, 5, '2008-10-19 20:01:24', NULL, '2008-10-19 20:01:24', '2008-10-19 20:03:14', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0), 278 (12, 7, 5, '2008-10-19 20:03:14', NULL, '2008-10-19 20:03:14', '2008-10-19 20:03:19', 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 5, 0), 279 (13, 7, 5, '2008-10-19 20:03:19', NULL, '2008-10-19 20:03:19', NULL, 'laserovka-samsung', 'LASEROVKA-SAMSUNG', '192.168.12.4', '', '1900-01-01', 6, 0, 4, 2, 2, 0); 208 280 209 281 -- -------------------------------------------------------- … … 226 298 `Host` int(11) NOT NULL, 227 299 `MAC` varchar(255) collate utf8_czech_ci NOT NULL, 228 PRIMARY KEY (`Id`) 229 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 300 `ParentHost` int(11) NOT NULL, 301 PRIMARY KEY (`Id`) 302 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ; 230 303 231 304 -- … … 233 306 -- 234 307 235 INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `Area`, `Host`, `MAC`) VALUES 236 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Kabel', 2, 0, 1, '00:00:00:00:00:00'), 237 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F'), 238 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26'), 239 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'eth0', 2, 0, 6, '45:00:12:54:FE:C2'); 308 INSERT INTO `Interface` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Type`, `Area`, `Host`, `MAC`, `ParentHost`) VALUES 309 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 19:13:18', 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 0), 310 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 19:13:33', 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F', 0), 311 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Bezdrát', 0, 0, 5, '00:00:00:A5:53:26', 0), 312 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-19 20:07:04', 'eth0', 2, 0, 6, '45:00:12:54:FE:C2', 0), 313 (5, 1, 5, '2008-10-19 19:13:18', NULL, '2008-10-19 19:13:18', '2008-10-19 19:13:25', 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 1), 314 (6, 1, 5, '2008-10-19 19:13:25', NULL, '2008-10-19 19:13:25', NULL, 'Kabel', 2, 0, 1, '00:00:00:00:00:00', 2), 315 (7, 2, 5, '2008-10-19 19:13:33', NULL, '2008-10-19 19:13:33', NULL, 'eth0', 3, 0, 3, 'A5:00:00:11:CD:2F', 8), 316 (8, 4, 5, '2008-10-19 20:07:04', NULL, '2008-10-19 20:07:04', NULL, 'eth0', 2, 0, 6, '45:00:12:54:FE:C2', 4); 240 317 241 318 -- -------------------------------------------------------- … … 255 332 `Subject` int(11) NOT NULL, 256 333 `ResponsibleUser` int(11) NOT NULL, 257 `MapPositionX` int(11) NOT NULL,258 `MapPositionY` int(11) NOT NULL,259 334 `FamilyMemberCount` int(11) NOT NULL, 260 335 `MembershipDate` date NOT NULL, … … 263 338 `Tariff` int(11) NOT NULL, 264 339 `UserList` int(11) NOT NULL, 265 PRIMARY KEY (`Id`) 266 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=7 ; 340 `GPS` int(11) NOT NULL, 341 PRIMARY KEY (`Id`) 342 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=37 ; 267 343 268 344 -- … … 270 346 -- 271 347 272 INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Subject`, `ResponsibleUser`, `MapPositionX`, `MapPositionY`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`) VALUES 273 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 2, 1, 123, 567, 3, '0000-00-00', 2, 0, 3, 0), 274 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 3, 6, 123, 123, 2, '0000-00-00', 2, 0, 4, 0), 275 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 7, 8, 0, 0, 0, '0000-00-00', 2, 0, 2, 0), 276 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 8, 11, 0, 0, 0, '0000-00-00', 2, 0, 3, 0), 277 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 1, 32423, 21, 2, '0000-00-00', 1, 0, 3, 0), 278 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 12, 12, 2, 1, '0000-00-00', 3, 0, 1, 0); 348 INSERT INTO `Member` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Subject`, `ResponsibleUser`, `FamilyMemberCount`, `MembershipDate`, `MemberState`, `HostList`, `Tariff`, `UserList`, `GPS`) VALUES 349 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:11:56', 2, 1, 3, '0000-00-00', 2, 0, 3, 0, 0), 350 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:13:08', 3, 6, 2, '0000-00-00', 2, 0, 4, 0, 0), 351 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:18:03', 7, 8, 0, '0000-00-00', 2, 0, 2, 0, 0), 352 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-21 10:20:38', 8, 11, 0, '0000-00-00', 2, 0, 3, 0, 0), 353 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 10, 1, 2, '0000-00-00', 1, 0, 3, 0, 0), 354 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', 12, 12, 1, '0000-00-00', 3, 0, 1, 0, 0), 355 (7, 3, 5, '2008-10-21 10:18:03', '0000-00-00 00:00:00', '2008-10-21 10:18:03', '0000-00-00 00:00:00', 7, 8, 0, '1900-01-01', 2, 0, 2, 0, 0), 356 (8, 4, 5, '2008-10-21 10:20:38', '0000-00-00 00:00:00', '2008-10-21 10:20:38', '2008-10-21 10:21:01', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 3), 357 (9, 4, 5, '2008-10-21 10:21:01', '0000-00-00 00:00:00', '2008-10-21 10:21:01', '2008-10-21 10:22:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 4), 358 (10, 4, 5, '2008-10-21 10:22:36', '0000-00-00 00:00:00', '2008-10-21 10:22:36', '2008-10-21 10:30:03', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 5), 359 (11, 4, 5, '2008-10-21 10:30:03', '0000-00-00 00:00:00', '2008-10-21 10:30:03', '2008-10-21 10:35:47', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 6), 360 (12, 4, 5, '2008-10-21 10:35:47', '0000-00-00 00:00:00', '2008-10-21 10:35:47', '2008-10-21 10:36:21', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 7), 361 (13, 4, 5, '2008-10-21 10:36:21', '0000-00-00 00:00:00', '2008-10-21 10:36:21', '2008-10-21 10:36:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 8), 362 (14, 4, 5, '2008-10-21 10:36:36', '0000-00-00 00:00:00', '2008-10-21 10:36:36', '2008-10-21 10:38:25', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 9), 363 (15, 4, 5, '2008-10-21 10:38:25', '0000-00-00 00:00:00', '2008-10-21 10:38:25', '2008-10-21 10:39:52', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 10), 364 (16, 4, 5, '2008-10-21 10:39:52', '0000-00-00 00:00:00', '2008-10-21 10:39:52', '2008-10-21 10:39:57', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 11), 365 (17, 4, 5, '2008-10-21 10:39:57', '0000-00-00 00:00:00', '2008-10-21 10:39:57', '2008-10-21 11:40:16', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 12), 366 (18, 4, 5, '2008-10-21 11:40:16', '0000-00-00 00:00:00', '2008-10-21 11:40:16', '2008-10-21 11:41:33', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 13), 367 (19, 4, 5, '2008-10-21 11:41:33', '0000-00-00 00:00:00', '2008-10-21 11:41:33', '2008-10-21 11:41:42', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 14), 368 (20, 4, 5, '2008-10-21 11:41:42', '0000-00-00 00:00:00', '2008-10-21 11:41:42', '2008-10-21 11:41:50', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 15), 369 (21, 4, 5, '2008-10-21 11:41:50', '0000-00-00 00:00:00', '2008-10-21 11:41:50', '2008-10-21 11:41:54', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 16), 370 (22, 4, 5, '2008-10-21 11:41:54', '0000-00-00 00:00:00', '2008-10-21 11:41:54', '2008-10-21 11:42:30', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 17), 371 (23, 4, 5, '2008-10-21 11:42:30', '0000-00-00 00:00:00', '2008-10-21 11:42:30', '2008-10-21 11:42:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 18), 372 (24, 4, 5, '2008-10-21 11:42:36', '0000-00-00 00:00:00', '2008-10-21 11:42:36', '2008-10-21 11:42:41', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 19), 373 (25, 4, 5, '2008-10-21 11:42:41', '0000-00-00 00:00:00', '2008-10-21 11:42:41', '2008-10-21 11:47:30', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 20), 374 (26, 4, 5, '2008-10-21 11:47:30', '0000-00-00 00:00:00', '2008-10-21 11:47:30', '2008-10-21 11:47:39', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 21), 375 (27, 4, 5, '2008-10-21 11:47:39', '0000-00-00 00:00:00', '2008-10-21 11:47:39', '2008-10-21 11:49:23', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 22), 376 (28, 4, 5, '2008-10-21 11:49:23', '0000-00-00 00:00:00', '2008-10-21 11:49:23', '2008-10-21 11:53:36', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 23), 377 (29, 4, 5, '2008-10-21 11:53:36', '0000-00-00 00:00:00', '2008-10-21 11:53:36', '2008-10-21 11:53:42', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 24), 378 (30, 4, 5, '2008-10-21 11:53:42', '0000-00-00 00:00:00', '2008-10-21 11:53:42', '2008-10-21 11:56:52', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 25), 379 (31, 4, 5, '2008-10-21 11:56:52', '0000-00-00 00:00:00', '2008-10-21 11:56:52', '2008-10-21 12:04:01', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 26), 380 (32, 4, 5, '2008-10-21 12:04:01', '0000-00-00 00:00:00', '2008-10-21 12:04:01', '2008-10-21 12:05:49', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 27), 381 (33, 4, 5, '2008-10-21 12:05:49', '0000-00-00 00:00:00', '2008-10-21 12:05:49', '2008-10-21 12:07:48', 8, 11, 0, '1900-01-01', 2, 0, 3, 0, 28), 382 (34, 4, 5, '2008-10-21 12:07:48', '0000-00-00 00:00:00', '2008-10-21 12:07:48', '0000-00-00 00:00:00', 8, 11, 6, '2000-01-01', 2, 0, 3, 0, 29), 383 (35, 7, 28, '2008-10-21 15:53:47', '0000-00-00 00:00:00', '2008-10-21 15:53:47', '0000-00-00 00:00:00', 15, 1, 0, '1900-01-01', 2, 0, 2, 0, 30), 384 (36, 8, 28, '2008-10-21 15:54:04', '0000-00-00 00:00:00', '2008-10-21 15:54:04', '0000-00-00 00:00:00', 0, 0, 0, '0000-00-00', 0, 0, 0, 0, 31); 279 385 280 386 -- -------------------------------------------------------- … … 318 424 319 425 -- 426 -- Struktura tabulky `NewsGroup` 427 -- 428 429 CREATE TABLE IF NOT EXISTS `NewsGroup` ( 430 `Id` int(11) NOT NULL auto_increment, 431 `ItemId` int(11) NOT NULL, 432 `Author` int(11) NOT NULL, 433 `ValidTimeFrom` datetime default NULL, 434 `ValidTimeTo` datetime default NULL, 435 `CreationTime` datetime default NULL, 436 `DeletionTime` datetime default NULL, 437 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 438 `NewsItems` int(11) NOT NULL, 439 PRIMARY KEY (`Id`) 440 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=9 ; 441 442 -- 443 -- Vypisuji data pro tabulku `NewsGroup` 444 -- 445 446 INSERT INTO `NewsGroup` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `NewsItems`) VALUES 447 (1, 1, 28, '2008-10-21 14:51:50', NULL, '2008-10-21 14:51:50', NULL, 'Různé informace', 0), 448 (2, 2, 28, '2008-10-21 14:52:11', NULL, '2008-10-21 14:52:11', NULL, 'Bazar', 0), 449 (3, 3, 28, '2008-10-21 14:52:25', NULL, '2008-10-21 14:52:25', NULL, 'Dění v obci', 0), 450 (4, 4, 28, '2008-10-21 14:52:39', NULL, '2008-10-21 14:52:39', NULL, 'Správa sítě - oznámení', 0), 451 (5, 5, 28, '2008-10-21 14:52:53', NULL, '2008-10-21 14:52:53', NULL, 'Správa sítě - změny zařízení', 0), 452 (6, 6, 28, '2008-10-21 14:53:07', NULL, '2008-10-21 14:53:07', NULL, 'Multimediální archív', 0), 453 (7, 7, 28, '2008-10-21 14:53:51', NULL, '2008-10-21 14:53:51', NULL, 'Správa sítě - výpadky', 0), 454 (8, 8, 28, '2008-10-21 14:58:03', NULL, '2008-10-21 14:58:03', NULL, 'Sport', 0); 455 456 -- -------------------------------------------------------- 457 458 -- 459 -- Struktura tabulky `NewsItem` 460 -- 461 462 CREATE TABLE IF NOT EXISTS `NewsItem` ( 463 `Id` int(11) NOT NULL auto_increment, 464 `ItemId` int(11) NOT NULL, 465 `Author` int(11) NOT NULL, 466 `ValidTimeFrom` datetime default NULL, 467 `ValidTimeTo` datetime default NULL, 468 `CreationTime` datetime default NULL, 469 `DeletionTime` datetime default NULL, 470 `Title` varchar(255) collate utf8_czech_ci NOT NULL, 471 `Content` varchar(255) collate utf8_czech_ci NOT NULL, 472 `NewsGroup` int(11) NOT NULL, 473 `Enclosure` int(11) NOT NULL, 474 PRIMARY KEY (`Id`) 475 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 476 477 -- 478 -- Vypisuji data pro tabulku `NewsItem` 479 -- 480 481 INSERT INTO `NewsItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Title`, `Content`, `NewsGroup`, `Enclosure`) VALUES 482 (1, 1, 28, '2008-10-21 14:57:33', NULL, '2008-10-21 14:57:33', NULL, 'Ukončovačka', '!!!POZOR!!! V sobotu 25.10.2008 \\UKONČOVACÍ AKCE\\ v kasíně. Rum + kofola 25Kč Vodka + fanta 25Kč Vodka + džus 25Kč', 1, 0), 483 (2, 2, 28, '2008-10-21 14:58:16', NULL, '2008-10-21 14:58:16', NULL, 'Fotbalové utkání', 'dsdada', 8, 0), 484 (3, 3, 28, '2008-10-21 15:57:44', NULL, '2008-10-21 15:57:44', NULL, 'Čistota', 'Na 1100 speciálně školených pracovníků je připraveno přesvědčit Vás o významu slova čistota.', 1, 0), 485 (4, 4, 28, '2008-10-21 15:58:31', NULL, '2008-10-21 15:58:31', NULL, 'Hokej v 15:00(19.10)', 'Zitra v nedeli 19.10 v 15:00 hod. si p pridte zahrat jako kazdy tyden hokej .Dnes(sobota)jsme si byli zapinkat.tak pridte at je nas co nejvic Aktualni vysledky poctu lidi na hristi najdete na web kamere .Sportu zdar a hokeji zvlast', 8, 0), 486 (5, 5, 28, '2008-10-21 15:59:35', NULL, '2008-10-21 15:59:35', NULL, 'Apokalipsa', 'Přírodní živel zničil celou síť.', 7, 0); 487 488 -- -------------------------------------------------------- 489 490 -- 491 -- Struktura tabulky `Permission` 492 -- 493 494 CREATE TABLE IF NOT EXISTS `Permission` ( 495 `Id` int(11) NOT NULL auto_increment, 496 `ItemId` int(11) NOT NULL, 497 `Author` int(11) NOT NULL, 498 `ValidTimeFrom` datetime default NULL, 499 `ValidTimeTo` datetime default NULL, 500 `CreationTime` datetime default NULL, 501 `DeletionTime` datetime default NULL, 502 `List` int(11) NOT NULL, 503 `Item` int(11) NOT NULL, 504 `Right` int(11) NOT NULL, 505 `PermissionGroup` int(11) NOT NULL, 506 PRIMARY KEY (`Id`) 507 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ; 508 509 -- 510 -- Vypisuji data pro tabulku `Permission` 511 -- 512 513 INSERT INTO `Permission` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `List`, `Item`, `Right`, `PermissionGroup`) VALUES 514 (1, 1, 5, '2008-10-13 10:45:28', NULL, '2008-10-13 10:45:28', '2008-10-13 13:17:44', 1, 0, 0, 7), 515 (2, 2, 5, '2008-10-13 10:47:10', NULL, '2008-10-13 10:47:10', NULL, 1, 0, 2, 2), 516 (3, 3, 5, '2008-10-13 10:49:22', NULL, '2008-10-13 10:49:22', NULL, 2, 0, 2, 2), 517 (4, 4, 5, '2008-10-13 11:08:44', NULL, '2008-10-13 11:08:44', NULL, 3, 0, 2, 2), 518 (5, 5, 5, '2008-10-13 11:10:14', NULL, '2008-10-13 11:10:14', NULL, 4, 0, 2, 2), 519 (6, 6, 0, '2008-10-13 12:43:44', NULL, '2008-10-13 12:43:44', '2008-10-13 13:17:41', 7, 0, 2, 2), 520 (7, 7, 0, '2008-10-13 12:43:59', NULL, '2008-10-13 12:43:59', '2008-10-13 13:17:40', 7, 0, 2, 2), 521 (8, 8, 0, '2008-10-13 12:45:14', NULL, '2008-10-13 12:45:14', '2008-10-13 13:17:38', 7, 0, 2, 2), 522 (9, 9, 0, '2008-10-13 12:48:25', NULL, '2008-10-13 12:48:25', NULL, 7, 0, 2, 2), 523 (10, 10, 0, '2008-10-13 12:50:52', NULL, '2008-10-13 12:50:52', '2008-10-13 13:17:35', 7, 0, 2, 2), 524 (11, 11, 0, '2008-10-13 12:58:32', NULL, '2008-10-13 12:58:32', NULL, 8, 0, 2, 2), 525 (12, 12, 5, '2008-10-13 13:00:34', NULL, '2008-10-13 13:00:34', NULL, 9, 0, 2, 2), 526 (13, 9, 5, '2008-10-13 13:04:26', NULL, '2008-10-13 13:04:26', NULL, 7, 0, 2, 2), 527 (14, 9, 5, '2008-10-13 13:19:17', NULL, '2008-10-13 13:19:17', '2008-10-13 13:19:27', 7, 0, 2, 2), 528 (15, 13, 5, '2008-10-13 14:05:54', NULL, '2008-10-13 14:05:54', NULL, 8, 0, 1, 5), 529 (16, 14, 5, '2008-10-13 14:06:21', NULL, '2008-10-13 14:06:21', NULL, 2, 0, 1, 5), 530 (17, 15, 5, '2008-10-21 07:06:14', NULL, '2008-10-21 07:06:14', NULL, 1, 0, 2, 1), 531 (18, 16, 5, '2008-10-21 08:10:57', NULL, '2008-10-21 08:10:57', NULL, 21, 0, 2, 1), 532 (19, 17, 5, '2008-10-21 08:51:03', NULL, '2008-10-21 08:51:03', NULL, 7, 0, 0, 1), 533 (20, 18, 5, '2008-10-21 12:44:55', NULL, '2008-10-21 12:44:55', '2008-10-21 13:14:45', 8, 0, 1, 1), 534 (21, 19, 5, '2008-10-21 12:57:35', NULL, '2008-10-21 12:57:35', '2008-10-21 12:58:43', 3, 0, 0, 1), 535 (22, 20, 5, '2008-10-21 12:57:54', NULL, '2008-10-21 12:57:54', '2008-10-21 12:58:23', 20, 0, 0, 1), 536 (23, 21, 5, '2008-10-21 12:58:11', NULL, '2008-10-21 12:58:11', NULL, 14, 0, 2, 1), 537 (24, 20, 5, '2008-10-21 12:58:23', NULL, '2008-10-21 12:58:23', '2008-10-21 13:11:11', 20, 0, 2, 1), 538 (25, 19, 5, '2008-10-21 12:58:43', NULL, '2008-10-21 12:58:43', NULL, 3, 0, 2, 1), 539 (26, 22, 5, '2008-10-21 12:58:54', NULL, '2008-10-21 12:58:54', NULL, 11, 0, 2, 1), 540 (27, 23, 5, '2008-10-21 12:59:08', NULL, '2008-10-21 12:59:08', NULL, 19, 0, 2, 1), 541 (28, 24, 5, '2008-10-21 12:59:15', NULL, '2008-10-21 12:59:15', NULL, 18, 0, 2, 1), 542 (29, 20, 5, '2008-10-21 13:11:11', NULL, '2008-10-21 13:11:11', NULL, 20, 0, 1, 1), 543 (30, 25, 5, '2008-10-21 13:14:20', NULL, '2008-10-21 13:14:20', NULL, 4, 0, 2, 1), 544 (31, 18, 5, '2008-10-21 13:14:45', NULL, '2008-10-21 13:14:45', '2008-10-21 13:18:52', 8, 0, 0, 1), 545 (32, 26, 5, '2008-10-21 13:18:17', NULL, '2008-10-21 13:18:17', '2008-10-21 13:18:39', 0, 0, 0, 1), 546 (33, 26, 5, '2008-10-21 13:18:39', NULL, '2008-10-21 13:18:39', NULL, 5, 0, 1, 1), 547 (34, 18, 5, '2008-10-21 13:18:52', NULL, '2008-10-21 13:18:52', NULL, 8, 0, 1, 1), 548 (35, 27, 5, '2008-10-21 13:19:36', NULL, '2008-10-21 13:19:36', NULL, 13, 0, 2, 1), 549 (36, 28, 5, '2008-10-21 13:48:35', NULL, '2008-10-21 13:48:35', NULL, 7, 0, 1, 5), 550 (37, 29, 5, '2008-10-21 13:49:05', NULL, '2008-10-21 13:49:05', '2008-10-21 14:36:27', 21, 0, 1, 5), 551 (38, 30, 5, '2008-10-21 13:49:48', NULL, '2008-10-21 13:49:48', NULL, 15, 0, 1, 1), 552 (39, 29, 28, '2008-10-21 14:36:27', NULL, '2008-10-21 14:36:27', NULL, 21, 0, 0, 5), 553 (40, 31, 28, '2008-10-21 14:45:36', NULL, '2008-10-21 14:45:36', NULL, 23, 0, 2, 1), 554 (41, 32, 28, '2008-10-21 14:54:31', NULL, '2008-10-21 14:54:31', NULL, 22, 0, 2, 1), 555 (42, 33, 28, '2008-10-21 16:09:19', NULL, '2008-10-21 16:09:19', NULL, 24, 0, 1, 1); 556 557 -- -------------------------------------------------------- 558 559 -- 560 -- Struktura tabulky `PermissionGroup` 561 -- 562 563 CREATE TABLE IF NOT EXISTS `PermissionGroup` ( 564 `Id` int(11) NOT NULL auto_increment, 565 `ItemId` int(11) NOT NULL, 566 `Author` int(11) NOT NULL, 567 `ValidTimeFrom` datetime default NULL, 568 `ValidTimeTo` datetime default NULL, 569 `CreationTime` datetime default NULL, 570 `DeletionTime` datetime default NULL, 571 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 572 `PermissionList` int(11) NOT NULL, 573 `UserList` int(11) NOT NULL, 574 PRIMARY KEY (`Id`) 575 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; 576 577 -- 578 -- Vypisuji data pro tabulku `PermissionGroup` 579 -- 580 581 INSERT INTO `PermissionGroup` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `PermissionList`, `UserList`) VALUES 582 (1, 1, 5, '2008-10-13 09:54:31', NULL, '2008-10-13 09:54:31', NULL, 'Administrátor', 0, 0), 583 (2, 1, 5, '2008-10-13 09:55:09', NULL, '2008-10-13 09:55:09', NULL, 'Systémoví správci', 0, 0), 584 (3, 2, 5, '2008-10-13 09:55:23', NULL, '2008-10-13 09:55:23', NULL, 'Správci sítě', 0, 0), 585 (4, 3, 5, '2008-10-13 09:55:39', NULL, '2008-10-13 09:55:39', NULL, 'Klienti', 0, 0), 586 (5, 3, 5, '2008-10-13 09:55:56', NULL, '2008-10-13 09:55:56', NULL, 'Zástupci subjektů', 0, 0), 587 (6, 4, 5, '2008-10-13 09:56:13', NULL, '2008-10-13 09:56:13', NULL, 'Připojení uživatelé', 0, 0), 588 (7, 5, 5, '2008-10-13 09:56:20', NULL, '2008-10-13 09:56:20', NULL, 'Ostatní', 0, 0); 589 590 -- -------------------------------------------------------- 591 592 -- 320 593 -- Struktura tabulky `Subject` 321 594 -- … … 341 614 `MemberList` int(11) NOT NULL, 342 615 PRIMARY KEY (`Id`) 343 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 18;616 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=22 ; 344 617 345 618 -- … … 360 633 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Fantomas', 'Tajná 10', 'Pod vodou', '11223', '', '', '', 0, 0, '', 0), 361 634 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0), 362 (14, 14, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0), 363 (15, 15, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0), 364 (16, 16, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0), 365 (17, 17, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0); 366 367 -- -------------------------------------------------------- 368 369 -- 370 -- Struktura tabulky `SystemList` 371 -- 372 373 CREATE TABLE IF NOT EXISTS `SystemList` ( 374 `Id` int(11) NOT NULL auto_increment, 375 `ItemId` int(11) NOT NULL, 376 `Author` int(11) NOT NULL, 377 `ValidTimeFrom` datetime default NULL, 378 `ValidTimeTo` datetime default NULL, 379 `CreationTime` datetime default NULL, 380 `DeletionTime` datetime default NULL, 381 `TableName` varchar(255) collate utf8_czech_ci NOT NULL, 382 `Title` varchar(255) collate utf8_czech_ci NOT NULL, 383 `System` tinyint(1) NOT NULL, 384 `Items` varchar(255) collate utf8_czech_ci NOT NULL, 385 `VisibleInMenu` int(11) NOT NULL default '1', 386 PRIMARY KEY (`Id`) 387 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ; 388 389 -- 390 -- Vypisuji data pro tabulku `SystemList` 391 -- 392 393 INSERT INTO `SystemList` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `TableName`, `Title`, `System`, `Items`, `VisibleInMenu`) VALUES 394 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'User', 'Uživatelé', 0, '', 1), 395 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Host', 'Zařízení', 0, '', 1), 396 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Subject', 'Finanční subjekty', 0, '', 1), 397 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Členové sítě', 0, '', 1), 398 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Area', 'Oblasti', 0, '', 1), 399 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Interface', 'Rozhraní zařízení', 0, '', 1), 400 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Asset', 'Majetek', 0, '', 1), 401 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Tariff', 'Tarify', 0, '', 1), 402 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberReport', 'Hlášení členů', 0, '', 1), 403 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankAccount', 'Bankovní účty', 0, '', 1), 404 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SystemType', 'Definice typů', 1, '', 1), 405 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FinanceTransaction', 'Platební operace', 0, '', 1), 406 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SystemList', 'Definice tabulek', 1, '', 1), 407 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SystemListItem', 'Definice položek formulářů', 1, '', 0), 408 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UserOnline', 'Přihlášení uživatelé', 1, '', 1), 409 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'History', 'Historie záznamů', 1, '', 0), 410 (28, 8, 5, '2008-10-12 21:44:42', '0000-00-00 00:00:00', '2008-10-12 21:44:42', NULL, 'Tariff', 'Tarify', 0, '', 0), 411 (27, 8, 5, '2008-10-12 21:44:31', '0000-00-00 00:00:00', '2008-10-12 21:44:31', NULL, 'Tariff', 'Tarify', 0, '', 0), 412 (26, 17, 5, '2008-10-12 18:38:17', '0000-00-00 00:00:00', '2008-10-12 18:38:17', NULL, 'Test', 'Testovací tabulka', 0, '', 1), 413 (29, 8, 5, '2008-10-12 21:48:28', '0000-00-00 00:00:00', '2008-10-12 21:48:28', NULL, 'Tariff', 'Tarify', 0, '', 0), 414 (30, 8, 5, '2008-10-12 21:48:33', '0000-00-00 00:00:00', '2008-10-12 21:48:33', NULL, 'Tariff', 'Tarify', 0, '', 0), 415 (31, 8, 5, '2008-10-13 07:25:43', '0000-00-00 00:00:00', '2008-10-13 07:25:43', NULL, 'Tariff', 'Tarify', 0, '', 1); 416 417 -- -------------------------------------------------------- 418 419 -- 420 -- Struktura tabulky `SystemListItem` 421 -- 422 423 CREATE TABLE IF NOT EXISTS `SystemListItem` ( 424 `Id` int(11) NOT NULL auto_increment, 425 `ItemId` int(11) NOT NULL, 426 `Author` int(11) NOT NULL, 427 `ValidTimeFrom` datetime default NULL, 428 `ValidTimeTo` datetime default NULL, 429 `CreationTime` datetime default NULL, 430 `DeletionTime` datetime default NULL, 431 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 432 `TextBefore` varchar(255) collate utf8_czech_ci NOT NULL, 433 `TextAfter` varchar(255) collate utf8_czech_ci NOT NULL, 434 `Type` varchar(255) collate utf8_czech_ci NOT NULL, 435 `Help` varchar(255) collate utf8_czech_ci NOT NULL, 436 `Default` varchar(255) collate utf8_czech_ci NOT NULL, 437 `Required` tinyint(1) NOT NULL default '1', 438 `Editable` tinyint(1) NOT NULL default '1', 439 `VisibleInList` tinyint(1) NOT NULL default '0', 440 `VisibleInPointer` tinyint(1) NOT NULL default '0', 441 `List` int(11) NOT NULL, 442 PRIMARY KEY (`Id`) 443 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ; 444 445 -- 446 -- Vypisuji data pro tabulku `SystemListItem` 447 -- 448 449 INSERT INTO `SystemListItem` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `TextBefore`, `TextAfter`, `Type`, `Help`, `Default`, `Required`, `Editable`, `VisibleInList`, `VisibleInPointer`, `List`) VALUES 450 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FirstName', 'Jméno', '', '3', 'Zadejte jméno', '', 1, 1, 1, 1, 1), 451 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SecondName', 'Příjmení', '', '3', 'Zadejte příjmení', '', 1, 1, 1, 1, 1), 452 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Email', 'E-mail', '', '3', 'Zadejte emailovou adresu', '', 1, 1, 1, 0, 1), 453 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ICQ', 'ICQ', '', '1', 'Zadejte kontaktní číslo textového komunikačního programu ICQ.', '', 0, 1, 0, 0, 1), 454 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Sex', 'Pohlaví', '', '5', 'Vyberte pohlaví osoby', '', 0, 1, 0, 0, 1), 455 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BirthDay', 'Datum narození', '', '2', 'Vyberte datum narození', '', 0, 1, 0, 0, 1), 456 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DomainName', 'Doménové jméno', '', '3', 'Zadejte jméno počítače v doméně', '', 1, 1, 1, 1, 2), 457 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'NetBIOSName', 'NetBIOSové jméno', '', '3', 'Zadejte jméno počítače v rámci protokolů NetBIOS a sdílení souborů', '', 0, 1, 0, 0, 2), 458 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LocalIPAddress', 'Místní IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci místní sítě', '', 1, 1, 1, 0, 2), 459 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PublicIPAddress', 'Veřejná IP adresa', '', '3', 'Zadejte síťovou adresu používanou v rámci Internetu', '', 0, 1, 1, 0, 2), 460 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LastOnlineDate', 'Naposledy online', '', '2', 'Čas posledního úspěšného měření dostupnosti počítače', '', 0, 0, 0, 0, 2), 461 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Jméno', '', '3', 'Jméno subjektu', '', 1, 1, 1, 1, 3), 462 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AddressStreet', 'Ulice', '', '3', 'Ulice', '', 1, 1, 1, 0, 3), 463 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AddressTown', 'Město', '', '3', 'Město', '', 1, 1, 1, 0, 3), 464 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AddressZIP', 'PSČ', '', '3', '', '', 1, 1, 1, 0, 3), 465 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IC', 'IČ', '', '3', 'Identifikační číslo subjektu', '', 0, 1, 0, 0, 3), 466 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DIC', 'DIČ', '', '3', 'Daňové identifikační číslo', '', 0, 1, 0, 0, 3), 467 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MapPositionX', 'Horizontálně pozice', '', '1', 'Vodorovná pozice na mapě', '', 0, 1, 0, 0, 4), 468 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MapPositionY', 'Vertikální pozice', '', '1', 'Svislá pozice na mapě', '', 0, 1, 0, 0, 4), 469 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MembershipDate', 'Začátek členství', '', '2', 'Datum přípojení do sítě', '', 0, 1, 0, 0, 4), 470 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FamilyMemberCount', 'Osob v rodině', '', '1', 'Počet osob v připojené domácnosti', '', 0, 1, 0, 0, 4), 471 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ResponsibleUser', 'Zodpovědný uživatel', '', '37', '', '', 1, 1, 1, 1, 4), 472 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Subject', 'Subjekt', '', '33', '', '', 1, 1, 0, 0, 4), 473 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Druh', '', '7', '', '1', 0, 1, 1, 0, 2), 474 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Phone', 'Telefón', '', '3', '', '', 0, 1, 0, 0, 1), 475 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Notice', 'Poznámka', '', '3', '', '', 0, 1, 0, 0, 3), 476 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberState', 'Stav připojení', '', '6', '', '', 1, 1, 1, 0, 4), 477 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostList', 'Registrované zařízení', '', '23', '', '', 0, 1, 0, 0, 4), 478 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 5), 479 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'NetworkIPAddress', 'Adresa sítě', '', '3', '', '', 1, 1, 1, 0, 5), 480 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IPAddressMask', 'Maska sítě', '', '3', '', '', 1, 1, 1, 0, 5), 481 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DNSPrimary', 'Primární DNS server', '', '3', '', '', 0, 1, 0, 0, 5), 482 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DNSSecondary', 'Sukundární DNS server', '', '3', '', '', 0, 1, 0, 0, 5), 483 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DHCP', 'DHCP server', '', '3', '', '', 0, 1, 0, 0, 5), 484 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Domain', 'Doména', '', '3', '', '', 0, 1, 0, 0, 5), 485 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Workgroup', 'Pracovní skupina', '', '3', '', '', 0, 1, 0, 0, 5), 486 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'WINS', 'WINS server', '', '3', '', '', 0, 1, 0, 0, 5), 487 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 6), 488 (39, 39, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Typ', '', '8', '', '', 1, 1, 1, 0, 6), 489 (40, 40, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Host', 'Zařízení', '', '31', 'Vyberte zařízení, ke kterému patří toto rozhraní.', '', 1, 1, 1, 0, 6), 490 (41, 41, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ParentHost', 'Připojeno k bodu', '', '31', '', '', 1, 1, 1, 0, 6), 491 (42, 42, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Interface', 'Rozhraní', '', '24', '', '', 0, 1, 0, 0, 2), 492 (43, 43, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MAC', 'Fyzická adresa', '', '3', 'Zadejte fyzickou adresu síťové karty též nazývanou MAC adresa.', '', 1, 1, 0, 0, 6), 493 (44, 44, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ParentHost', 'Nadřazený uzel', '', '31', '', '', 0, 1, 0, 0, 2), 494 (45, 45, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SubHostList', 'Připojené zařízení', '', '38', 'Seznam podřízených zařízení ve virtuálním stromu propojení.', '', 0, 1, 0, 0, 2), 495 (46, 46, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 7), 496 (47, 47, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeEnlistment', 'Čas zařazení', '', '2', '', '', 1, 1, 0, 0, 7), 497 (48, 48, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeElimination', 'Čas vyřazení', '', '2', '', '', 0, 1, 0, 0, 7), 498 (49, 49, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Price', 'Pořizovací cena', '', '1', '', '', 1, 1, 1, 0, 7), 499 (50, 50, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'State', 'Stav', '', '9', '', '', 1, 1, 1, 0, 7), 500 (51, 51, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SerialNumber', 'Sériové číslo', '', '3', '', '', 0, 1, 0, 0, 7), 501 (52, 52, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PurcheasedFrom', 'Zakoupeno od', '', '33', '', '', 0, 1, 0, 0, 7), 502 (53, 53, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PurcheasedAsset', 'Nakoupené zboží', '', '21', '', '', 0, 1, 0, 0, 3), 503 (54, 54, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Člen', '', '32', '', '', 0, 1, 0, 0, 1), 504 (113, 113, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ValidFromTime', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 4), 505 (57, 57, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Price', 'Cena', '', '1', '', '', 1, 1, 1, 0, 8), 506 (56, 56, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 8), 507 (58, 58, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MinUploadSpeed', 'Minimální odchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8), 508 (59, 59, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MaxUploadSpeed', 'Maximální odchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8), 509 (60, 60, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MinDownloadSpeed', 'Minimální příchozí rychlost', '', '1', '', '', 1, 1, 0, 0, 8), 510 (61, 61, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MaxDownloadSpeed', 'Max příchozí rychlost', '', '1', '', '', 1, 1, 1, 0, 8), 511 (62, 62, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UserName', 'Uživatelské jméno', '', '3', '', '', 1, 1, 0, 0, 1), 512 (63, 63, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Password', 'Heslo', '', '15', '', '', 1, 1, 0, 0, 1), 513 (64, 64, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Členové', '', '26', '', '', 0, 1, 0, 0, 8), 514 (65, 65, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Tariff', 'Tarif', '', '36', '', '', 1, 1, 1, 0, 4), 515 (66, 66, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Vlastník', '', '32', '', '', 0, 1, 0, 0, 2), 516 (67, 67, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'WWW', 'Internetové stránky', '', '18', '', '', 0, 1, 0, 0, 3), 517 (68, 68, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Text', 'Text zprávy', '', '3', '', '', 1, 1, 1, 1, 9), 518 (69, 69, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Date', 'Datum', '', '2', '', '', 1, 1, 1, 0, 9), 519 (70, 70, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Member', 'Člen', '', '32', '', '', 1, 1, 1, 0, 9), 520 (71, 71, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Typ zprávy', '', '10', '', '', 1, 1, 1, 0, 9), 521 (72, 72, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ReportList', 'Záznamy', '', '27', '', '', 0, 1, 0, 0, 4), 522 (73, 73, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Creator', 'Vložil', '', '37', '', '', 1, 1, 0, 0, 9), 523 (74, 74, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Označení', '', '3', '', '', 1, 1, 1, 1, 10), 524 (75, 75, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankName', 'Jméno banky', '', '3', '', '', 1, 1, 0, 0, 10), 525 (76, 76, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Number', 'Identifikační číslo', '', '3', '', '', 1, 1, 1, 0, 10), 526 (77, 77, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankCode', 'Kód banky', '', '3', '', '', 1, 1, 1, 0, 10), 527 (78, 78, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'User', 'Registroval', '', '37', '', '', 0, 1, 0, 0, 10), 528 (79, 79, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Typ', '', '11', '', '', 1, 1, 1, 0, 10), 529 (80, 80, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberList', 'Členství', '', '25', '', '', 0, 1, 0, 0, 3), 530 (81, 81, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Systémové jméno typu', '', '3', 'Jméno by mělo obsahovat pouze velké a malé písmena. V podsložece types projektu jsou umístěny výkonné soubory pro jednotlivé typy.', 'Name', 1, 1, 1, 1, 11), 531 (82, 82, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ParentType', 'Rodičovský typ', '', '35', '', '', 1, 1, 1, 0, 11), 532 (83, 83, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Parameters', 'Parametry typu', '', '3', '', 'Parametry zadávejte jako řetězce oddělené symblem "|".', 0, 1, 0, 0, 11), 533 (84, 84, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'System', 'Systémový', '', '4', '', '0', 1, 1, 0, 0, 11), 534 (88, 88, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 11), 535 (89, 89, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Description', 'Popis', '', '3', '', '', 1, 1, 1, 0, 12), 536 (90, 90, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Amount', 'Částka', '', '16', '', '', 1, 1, 1, 0, 12), 537 (91, 91, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Time', 'Čas', '', '2', '', '', 1, 1, 1, 0, 12), 538 (92, 92, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SourceSubject', 'Zdrojový subjekt', '', '33', '', '', 1, 1, 1, 0, 12), 539 (93, 93, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TargetSubject', 'Cílový subjekt', '', '33', '', '', 1, 1, 1, 0, 12), 540 (94, 94, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Type', '', '15', '', '', 1, 1, 0, 0, 12), 541 (95, 95, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'InsertedByUser', 'Vložil', '', '37', '', '', 0, 0, 0, 0, 12), 542 (96, 96, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'DbDataType', 'Datový typ v databázi', '', '3', '', '', 1, 1, 0, 0, 11), 543 (97, 97, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TableName', 'Jméno tabulky', '', '3', 'Zadejte jméno tabulky v databázi, která bude použita pro uchování informací.', '', 1, 1, 1, 0, 13), 544 (98, 98, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Title', 'Název seznamu', '', '3', 'Zadejte nadpis seznamu.', '', 1, 1, 1, 1, 13), 545 (99, 99, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VisibleInMenu', 'Viditelné v menu', '', '4', 'Zobrazovat tuto tabulku v hlavním menu', '', 1, 1, 0, 0, 13), 546 (100, 100, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Items', 'Položky', '', '28', 'Definujte potřebné položky pro seznam.', '', 1, 1, 0, 0, 13), 547 (101, 101, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Name', 'Jméno sloupce', '', '3', 'Jméno sloupce tabulky v databázi', '', 1, 1, 1, 0, 14), 548 (102, 102, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TextBefore', 'Text před hodnotou', '', '3', 'Oznčení položky umístěné před zobrazenou hodnotou.', '', 1, 1, 1, 1, 14), 549 (103, 103, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TextAfter', 'Text za hodnotou', '', '3', 'Tento text většinou obsahuje jednotky použité veličiny.', '', 1, 1, 0, 0, 14), 550 (104, 104, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Type', 'Type', '', '35', 'Typ dat položky', '', 1, 1, 1, 0, 14), 551 (105, 105, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Help', 'Nápověda', '', '3', 'Textová nápověda zobrazovaná jako pomůcka při editaci hodnoty.', '', 1, 1, 0, 0, 14), 552 (106, 106, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Required', 'Požadováno', '', '4', 'Určuje zda je nutné danou položku vyplnit.', '', 1, 1, 0, 0, 14), 553 (107, 107, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Editable', 'Editovatelné', '', '4', 'Určuje zda je možné danou položku ručně editovat nebo zda je měněna automaticky systémem.', '', 1, 1, 0, 0, 14), 554 (108, 108, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VisibleInList', 'Viditelné v seznamu', '', '4', 'Určuje viditelnost této položky v seznamu', '', 1, 1, 0, 0, 14), 555 (109, 109, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'VisibleInPointer', 'Viditelné v odkazech', '', '4', 'Určuje viditelnost této položky v názvech odkazů na tuto položku', '', 1, 1, 0, 0, 14), 556 (110, 110, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Area', 'Umístění', '', '30', 'Vyberte oblast, do které toto zařízení patří.', '', 0, 1, 0, 0, 2), 557 (111, 111, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostList', 'Seznam zařízení', '', '22', '', '', 0, 1, 0, 0, 5), 558 (112, 112, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'UserList', 'Uživatelů', '', '29', '', '', 0, 1, 0, 0, 4), 559 (114, 114, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ValidToTime', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 4), 560 (115, 115, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'User', 'Uživatel', '', '37', '', '', 1, 0, 1, 1, 15), 561 (116, 116, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LoginTime', 'Čas přihlášení', '', '2', '', '', 0, 0, 0, 0, 15), 562 (117, 117, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ActivityTime', 'Naposledy aktivní', '', '2', '', '', 0, 0, 0, 0, 15), 563 (118, 118, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'SessionId', 'Identifikace spojení', '', '3', '', '', 0, 0, 0, 0, 15), 564 (119, 119, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IpAddress', 'IP adresa', '', '3', '', '', 0, 0, 0, 0, 15), 565 (120, 120, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostName', 'Jméno počítače', '', '3', '', '', 0, 0, 1, 0, 15), 566 (121, 121, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Locked', 'Zamčeno', '', '4', '', '', 0, 0, 0, 0, 1), 567 (122, 122, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'RegistrationTime', 'Čas registrace', '', '2', '', '', 0, 0, 0, 0, 1), 568 (123, 123, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LastLoginTime', 'Čas posledního přihlášení', '', '2', '', '', 0, 0, 0, 0, 1), 569 (124, 124, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'LastIpAddress', 'Poslední IP adresa', '', '3', '', '', 0, 0, 0, 0, 1), 570 (125, 125, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Author', 'Autor', '', '37', '', '', 1, 0, 0, 0, 16), 571 (126, 126, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeCreation', 'Čas vytvoření', '', '2', '', '', 1, 0, 0, 0, 16), 572 (127, 127, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeValidFrom', 'Platnost od', '', '2', '', '', 1, 1, 0, 0, 16), 573 (128, 128, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'TimeValidTo', 'Platnost do', '', '2', '', '', 1, 1, 0, 0, 16), 574 (129, 129, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ListId', 'Odkazovaná tabulka', '', '34', '', '', 1, 1, 0, 0, 16), 575 (130, 130, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PermanentId', 'Trvalá identifikace', '', '1', '', '', 1, 1, 0, 0, 16), 576 (133, 132, 5, '2008-10-12 17:48:27', '0000-00-00 00:00:00', '2008-10-12 17:48:27', NULL, 'List', 'Rodičovský seznam', '', '34', '', '', 1, 0, 0, 0, 14), 577 (142, 133, 5, '2008-10-12 18:39:09', '0000-00-00 00:00:00', '2008-10-12 18:39:09', NULL, 'Name', 'Jméno', '', '3', '', '', 1, 1, 1, 1, 26); 578 579 -- -------------------------------------------------------- 580 581 -- 582 -- Struktura tabulky `SystemType` 583 -- 584 585 CREATE TABLE IF NOT EXISTS `SystemType` ( 586 `Id` int(11) NOT NULL auto_increment, 587 `ItemId` int(11) NOT NULL, 588 `Author` int(11) NOT NULL, 589 `ValidTimeFrom` datetime default NULL, 590 `ValidTimeTo` datetime default NULL, 591 `CreationTime` datetime default NULL, 592 `DeletionTime` datetime default NULL, 593 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 594 `Description` varchar(255) collate utf8_czech_ci NOT NULL, 595 `ParentType` int(255) NOT NULL, 596 `Parameters` varchar(255) collate utf8_czech_ci NOT NULL, 597 `System` tinyint(1) NOT NULL default '0', 598 `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL, 599 PRIMARY KEY (`Id`), 600 UNIQUE KEY `Name` (`Name`) 601 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=39 ; 602 603 -- 604 -- Vypisuji data pro tabulku `SystemType` 605 -- 606 607 INSERT INTO `SystemType` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Description`, `ParentType`, `Parameters`, `System`, `DbDataType`) VALUES 608 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Integer', 'Číslo', 0, '', 1, 'INT'), 609 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Date', 'Datum', 0, '', 1, 'DATE'), 610 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'String', 'Řetězec', 0, '', 1, 'VARCHAR(255)'), 611 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Boolean', 'Logická hodnota', 0, '', 1, 'BOOL'), 612 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Sex', 'Pohlaví', 14, 'Muž|Žena', 0, ''), 613 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberState', 'Stav člena', 14, 'Neznámý stav|Zájemce o připojení|Připojen|Trvale odpojen', 0, ''), 614 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'HostType', 'Typ zařízení', 14, 'Nezařazeno|Osobní počítač|VoIP zařízení|IPTV zařízení|Směrovač|Server|Tiskárna/Skener/Kopírka|Jiné', 0, ''), 615 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'InterfaceType', 'Typ rozhraní', 14, 'Jiný|Ethernet 10 Mbit/s|Ethernet 100 Mbit/s|Ethernet 1 Gbit/s|Wifi 2,4 GHz 802.11b 11 Mbit/s|Wifi 2,4 GHz 802.11g 54 Mbit/s|Wifi 5 GHz 802.11a 54 Mbit/s|Optika 100 Mbit/s|Optika 1 Gbit/s', 0, ''), 616 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'AssetState', 'Stav majetku', 14, 'Neznámý|Na skladě|Používáno|V reklamaci|Vyřazeno', 0, ''), 617 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'MemberReportType', 'Typ hlášení člena', 14, 'Jiné|Hlášení závady|Požadavek na změnu|Poznámka správce', 0, ''), 618 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'BankAccountType', 'Typ účtu', 14, 'Neurčeno|Běžný účet|Spořící účet', 0, ''), 619 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToOne', 'Ukazatel na jednu položku', 0, '', 1, 'INT'), 620 (13, 13, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToMany', 'Ukazatel na více položek', 0, '', 1, 'INT'), 621 (14, 14, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Enumeration', 'Výčet', 0, '', 0, 'INT'), 622 (15, 15, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Password', 'Heslo', 0, '', 1, ''), 623 (16, 16, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Float', 'Desetinné číslo', 0, '', 1, 'FLOAT'), 624 (17, 17, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'FinanceTransactionType', 'Typ finanční transakce', 14, 'Bankovní převod|Osobní platba', 0, ''), 625 (18, 18, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hyperlink', 'Internetový odkaz', 0, '', 0, 'VARCHAR(255)'), 626 (19, 19, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'IPv4Address', 'IP adresa v4', 0, '', 0, 'VARCHAR(16)'), 627 (20, 20, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Hidden', 'Skrytá položka formuláře', 0, '', 1, 'VARCHAR(255)'), 628 (21, 21, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:01:23', NULL, 'PointerToAssetPurcheasedFrom', '', 13, 'Asset|PurcheasedFrom', 0, ''), 629 (22, 22, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:02:00', NULL, 'PointerToHostArea', '', 13, 'Host|Area', 0, ''), 630 (23, 23, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:04:28', NULL, 'PointerToHostMember', '', 13, 'Host|Member', 0, ''), 631 (24, 24, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:05:47', NULL, 'PointerToInterfaceHost', '', 13, 'Interface|Host', 0, ''), 632 (25, 25, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', NULL, 'PointerToMemberSubject', '', 13, 'Member|Subject', 0, ''), 633 (26, 26, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:07:15', NULL, 'PointerToMemberTariff', '', 13, 'Member|Tariff', 0, ''), 634 (27, 27, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToMemberReportMember', '', 13, 'MemberReport|Member ', 0, ''), 635 (28, 28, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToSystemListItemList', '', 13, 'SystemListItem|List', 0, ''), 636 (29, 29, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', NULL, 'PointerToUserMember', '', 13, 'User|Member', 0, ''), 637 (30, 30, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:09:55', NULL, 'PointerToArea', '', 12, 'Area', 0, ''), 638 (31, 31, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerOneToHost', '', 12, 'Host', 0, ''), 639 (32, 32, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToMember', '', 12, 'Member', 0, ''), 640 (33, 33, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:11:14', NULL, 'PointerToSubject', '', 12, 'Subject', 0, ''), 641 (34, 34, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:12:37', NULL, 'PointerToSystemList', '', 12, 'SystemList', 0, ''), 642 (35, 35, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToSystemType', '', 12, 'SystemType', 0, ''), 643 (36, 36, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', NULL, 'PointerToTariff', '', 12, 'Tariff', 0, ''), 644 (37, 37, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '2008-10-12 19:13:41', NULL, 'PointerToUser', '', 12, 'User', 0, ''), 645 (38, 38, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'PointerToHostParentHost', '', 13, 'Host|ParentHost', 0, ''); 646 647 -- -------------------------------------------------------- 648 649 -- 650 -- Struktura tabulky `Tariff` 651 -- 652 653 CREATE TABLE IF NOT EXISTS `Tariff` ( 654 `Id` int(11) NOT NULL auto_increment, 655 `ItemId` int(11) NOT NULL, 656 `Author` int(11) NOT NULL, 657 `ValidTimeFrom` datetime default NULL, 658 `ValidTimeTo` datetime default NULL, 659 `CreationTime` datetime default NULL, 660 `DeletionTime` datetime default NULL, 661 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 662 `Price` float NOT NULL, 663 `MinUploadSpeed` int(11) NOT NULL, 664 `MaxUploadSpeed` int(11) NOT NULL, 665 `MinDownloadSpeed` int(11) NOT NULL, 666 `MaxDownloadSpeed` int(11) NOT NULL, 667 `MemberList` int(11) NOT NULL, 668 PRIMARY KEY (`Id`) 669 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=6 ; 670 671 -- 672 -- Vypisuji data pro tabulku `Tariff` 673 -- 674 675 INSERT INTO `Tariff` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `Name`, `Price`, `MinUploadSpeed`, `MaxUploadSpeed`, `MinDownloadSpeed`, `MaxDownloadSpeed`, `MemberList`) VALUES 676 (1, 1, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 512 kbit', 190, 31, 512, 31, 512, 0), 677 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 1 Mbit', 260, 62, 1024, 62, 1024, 0), 678 (3, 3, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 2 Mbit', 360, 124, 2048, 124, 2048, 0), 679 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 4 Mbit', 520, 249, 4096, 249, 4096, 0), 680 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'Internet 8 Mbit', 750, 497, 8192, 497, 8192, 0); 681 682 -- -------------------------------------------------------- 683 684 -- 685 -- Struktura tabulky `Test` 686 -- 687 688 CREATE TABLE IF NOT EXISTS `Test` ( 689 `Id` int(11) NOT NULL auto_increment, 690 `ItemId` int(11) NOT NULL, 691 `Author` int(11) NOT NULL, 692 `ValidTimeFrom` datetime default NULL, 693 `ValidTimeTo` datetime default NULL, 694 `CreationTime` datetime default NULL, 695 `DeletionTime` datetime default NULL, 696 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 697 PRIMARY KEY (`Id`) 698 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 ; 699 700 -- 701 -- Vypisuji data pro tabulku `Test` 702 -- 703 704 705 -- -------------------------------------------------------- 706 707 -- 708 -- Struktura tabulky `User` 709 -- 710 711 CREATE TABLE IF NOT EXISTS `User` ( 712 `Id` int(11) NOT NULL auto_increment, 713 `ItemId` int(11) NOT NULL, 714 `Author` int(11) NOT NULL, 715 `ValidTimeFrom` datetime default NULL, 716 `ValidTimeTo` datetime default NULL, 717 `CreationTime` datetime default NULL, 718 `DeletionTime` datetime default NULL, 719 `UserName` varchar(255) collate utf8_czech_ci NOT NULL, 720 `Password` varchar(255) collate utf8_czech_ci NOT NULL, 721 `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 722 `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 723 `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 724 `ICQ` int(11) NOT NULL, 725 `Sex` int(11) NOT NULL default '0', 726 `BirthDay` date NOT NULL, 727 `Phone` varchar(255) collate utf8_czech_ci NOT NULL, 728 `Member` int(11) NOT NULL, 729 `RegistrationTime` datetime NOT NULL, 730 `LastLoginTime` datetime NOT NULL, 731 `Locked` tinyint(1) NOT NULL, 732 `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL, 733 PRIMARY KEY (`Id`) 734 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=13 ; 735 736 -- 737 -- Vypisuji data pro tabulku `User` 738 -- 739 740 INSERT INTO `User` (`Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`, `UserName`, `Password`, `FirstName`, `SecondName`, `Email`, `ICQ`, `Sex`, `BirthDay`, `Phone`, `Member`, `RegistrationTime`, `LastLoginTime`, `Locked`, `LastIpAddress`) VALUES 741 (1, 1, 5, NULL, NULL, '2008-10-13 07:50:41', NULL, '', 'fdsfsdfsd', 'Alfons', 'Much', 'mucha@all.cz', 89, 0, '0000-00-00', '', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 742 (2, 2, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Petr', 'Hrubý', 'hrubos@nevim.cz', 23, 0, '0000-00-00', '123456789', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 743 (4, 4, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'ferda', '123', 'Ferda', 'Mravenec', 'ferda@mraveniste.cz', 1, 0, '0000-00-00', '', 2, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 744 (5, 5, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'obivan', '4217be89cdd8f9dbb59fa5851dd3a0408b9a5a81', 'Obivan', 'Kenoby', 'kenoby@mail.universe', 233, 0, '0000-00-00', '', 6, '0000-00-00 00:00:00', '2008-10-13 06:55:32', 0, ''), 745 (6, 6, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Mistr', 'Joda', 'joda@mistr.shadow', 300, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 746 (7, 7, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Petr', 'Slovák', 'slovak@zdarma.cz', 34, 0, '0000-00-00', '', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 747 (8, 8, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Alena', 'Kocourková', 'alena.kocourkova@centrum.cz', 32, 1, '0000-00-00', '223344556', 7, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 748 (9, 9, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Jonny', 'Hurikán', 'storm@atlas.cz', 16, 0, '0000-00-00', '224556778', 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 749 (10, 10, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Smrťák', 'Krutý', 'smrt@peklo.cz', 111222333, 0, '0000-00-00', '', 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 750 (11, 11, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, '', '', 'Karel', 'Nejedlý', 'starosta@obec-milosice.cz', 0, 0, '0000-00-00', '443666333', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''), 751 (12, 12, 5, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL, 'fantomas', 'dsds', 'Fantomas', 'Tajemný', 'fantom@fantom.com', 0, 0, '0000-00-00', '', 12, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, ''); 752 753 -- -------------------------------------------------------- 754 755 -- 756 -- Struktura tabulky `UserOnline` 757 -- 758 759 CREATE TABLE IF NOT EXISTS `UserOnline` ( 760 `User` int(11) NOT NULL, 761 `LoginTime` datetime NOT NULL, 762 `ActivityTime` datetime NOT NULL, 763 `SessionId` varchar(255) collate utf8_czech_ci NOT NULL, 764 `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL, 765 `HostName` varchar(255) collate utf8_czech_ci NOT NULL, 766 `Id` int(11) NOT NULL auto_increment, 767 `ItemId` int(11) NOT NULL, 768 `Author` int(11) NOT NULL, 769 `ValidTimeFrom` datetime default NULL, 770 `ValidTimeTo` datetime default NULL, 771 `CreationTime` datetime default NULL, 772 `DeletionTime` datetime default NULL, 773 PRIMARY KEY (`Id`), 774 KEY `User` (`User`) 775 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=12 ; 776 777 -- 778 -- Vypisuji data pro tabulku `UserOnline` 779 -- 780 781 INSERT INTO `UserOnline` (`User`, `LoginTime`, `ActivityTime`, `SessionId`, `IpAddress`, `HostName`, `Id`, `ItemId`, `Author`, `ValidTimeFrom`, `ValidTimeTo`, `CreationTime`, `DeletionTime`) VALUES 782 (5, '2008-10-13 06:39:23', '2008-10-13 07:59:09', 'otgr2r8jjukmnng2rr49oi49p4', '192.168.0.23', 'george-nb.zdechov.net', 11, 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', '0000-00-00 00:00:00', NULL); 635 (14, 13, 5, '2008-10-11 22:38:49', '0000-00-00 00:00:00', '2008-10-11 22:38:49', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0), 636 (15, 13, 5, '2008-10-11 22:41:56', '0000-00-00 00:00:00', '2008-10-11 22:41:56', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, '', 0), 637 (16, 13, 5, '2008-10-11 22:46:30', '0000-00-00 00:00:00', '2008-10-11 22:46:30', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0), 638 (17, 13, 5, '2008-10-11 22:47:36', '0000-00-00 00:00:00', '2008-10-11 22:47:36', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0), 639 (18, 13, 5, '2008-10-13 08:46:07', NULL, '2008-10-13 08:46:07', NULL, 'Czech computer', 'Pod disketou 44', 'Mechanika', '35555', '424234234', 'CZ423423423', 'Prodejce výpočetní techniky', 0, 0, 'http://www.czechcomputer.cz/', 0), 640 (19, 14, 5, '2008-10-21 13:02:40', NULL, '2008-10-21 13:02:40', '2008-10-21 13:02:59', 'Alza', 'Pod vodou 12', 'Praha', '12012', '2312312', 'CZ34523423', '(please note if any errors come up you have not followed this guide properly also make sure your web server is on if you are running XAMPP start the top 2 \\APACHE\\ and \\MYSQL\\ tabs)', 0, 0, 'http://www.alza.cz/', 0), 641 (20, 14, 5, '2008-10-21 13:02:59', NULL, '2008-10-21 13:02:59', NULL, 'Alza', 'Pod vodou 12', 'Praha', '12012', '2312312', 'CZ34523423', 'As the name of topic says i''m wondering will the ACE problems be fixed for windows (of any distro) users ? Because i didn''t see nothing that gives hope for the past few days .I know it is not a easy way to fix it but i have a strange feeling that for us a', 0, 0, 'http://www.alza.cz/', 0), 642 (21, 15, 28, '2008-10-21 15:51:24', NULL, '2008-10-21 15:51:24', NULL, 'Kačer Skrblík', 'U trezoru', 'Kačerov', '123', '442342343', '55252345252', '', 0, 0, '', 0); 643 644 -- -------------------------------------------------------- 645 646 -- 647 -- Struktura tabulky `SystemFile` 648 -- 649 650 CREATE TABLE IF NOT EXISTS `SystemFile` ( 651 `Id` int(11) NOT NULL auto_increment, 652 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 653 `Content` mediumblob NOT NULL, 654 PRIMARY KEY (`Id`) 655 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 656 657 -- 658 -- Vypisuji data pro tabulku `SystemFile` 659 -- 660 -
sql/system_structure.sql
r11 r18 4 4 -- 5 5 -- Počítač: localhost 6 -- Vygenerováno: Pondělí 13. října 2008, 08:006 -- Vygenerováno: Úterý 21. října 2008, 16:14 7 7 -- Verze MySQL: 5.0.51 8 8 -- Verze PHP: 5.2.6 … … 17 17 18 18 -- 19 -- Struktura tabulky `Permission` 20 -- 21 22 CREATE TABLE IF NOT EXISTS `Permission` ( 23 `Id` int(11) NOT NULL auto_increment, 24 `ItemId` int(11) NOT NULL, 25 `Author` int(11) NOT NULL, 26 `ValidTimeFrom` datetime default NULL, 27 `ValidTimeTo` datetime default NULL, 28 `CreationTime` datetime default NULL, 29 `DeletionTime` datetime default NULL, 30 `List` int(11) NOT NULL, 31 `Item` int(11) NOT NULL, 32 `Right` int(11) NOT NULL, 33 `PermissionGroup` int(11) NOT NULL, 34 PRIMARY KEY (`Id`) 35 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=43 ; 36 37 -- -------------------------------------------------------- 38 39 -- 40 -- Struktura tabulky `PermissionGroup` 41 -- 42 43 CREATE TABLE IF NOT EXISTS `PermissionGroup` ( 44 `Id` int(11) NOT NULL auto_increment, 45 `ItemId` int(11) NOT NULL, 46 `Author` int(11) NOT NULL, 47 `ValidTimeFrom` datetime default NULL, 48 `ValidTimeTo` datetime default NULL, 49 `CreationTime` datetime default NULL, 50 `DeletionTime` datetime default NULL, 51 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 52 `PermissionList` int(11) NOT NULL, 53 `UserList` int(11) NOT NULL, 54 PRIMARY KEY (`Id`) 55 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=8 ; 56 57 -- -------------------------------------------------------- 58 59 -- 60 -- Struktura tabulky `SystemFile` 61 -- 62 63 CREATE TABLE IF NOT EXISTS `SystemFile` ( 64 `Id` int(11) NOT NULL auto_increment, 65 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 66 `Content` mediumblob NOT NULL, 67 PRIMARY KEY (`Id`) 68 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 69 70 -- -------------------------------------------------------- 71 72 -- 73 -- Struktura tabulky `SystemGPS` 74 -- 75 76 CREATE TABLE IF NOT EXISTS `SystemGPS` ( 77 `Id` int(11) NOT NULL auto_increment, 78 `Longitude` double NOT NULL, 79 `Latitude` double NOT NULL, 80 PRIMARY KEY (`Id`) 81 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=32 ; 82 83 -- -------------------------------------------------------- 84 85 -- 19 86 -- Struktura tabulky `SystemList` 20 87 -- … … 30 97 `TableName` varchar(255) collate utf8_czech_ci NOT NULL, 31 98 `Title` varchar(255) collate utf8_czech_ci NOT NULL, 32 `System` tinyint(1) NOT NULL,33 99 `Items` varchar(255) collate utf8_czech_ci NOT NULL, 34 ` VisibleInMenu` int(11) NOT NULL default '1',35 PRIMARY KEY (`Id`) 36 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 32;100 `Menu` int(11) NOT NULL, 101 PRIMARY KEY (`Id`) 102 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=75 ; 37 103 38 104 -- -------------------------------------------------------- … … 62 128 `List` int(11) NOT NULL, 63 129 PRIMARY KEY (`Id`) 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=143 ; 130 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=184 ; 131 132 -- -------------------------------------------------------- 133 134 -- 135 -- Struktura tabulky `SystemLog` 136 -- 137 138 CREATE TABLE IF NOT EXISTS `SystemLog` ( 139 `Id` int(11) NOT NULL auto_increment, 140 `ItemId` int(11) NOT NULL, 141 `Author` int(11) NOT NULL, 142 `ValidTimeFrom` datetime default NULL, 143 `ValidTimeTo` datetime default NULL, 144 `CreationTime` datetime default NULL, 145 `DeletionTime` datetime default NULL, 146 `User` int(11) NOT NULL, 147 `List` int(11) NOT NULL, 148 `Item` int(11) NOT NULL, 149 `Action` int(11) NOT NULL, 150 PRIMARY KEY (`Id`) 151 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=238 ; 152 153 -- -------------------------------------------------------- 154 155 -- 156 -- Struktura tabulky `SystemMenu` 157 -- 158 159 CREATE TABLE IF NOT EXISTS `SystemMenu` ( 160 `Id` int(11) NOT NULL auto_increment, 161 `ItemId` int(11) NOT NULL, 162 `Author` int(11) NOT NULL, 163 `ValidTimeFrom` datetime default NULL, 164 `ValidTimeTo` datetime default NULL, 165 `CreationTime` datetime default NULL, 166 `DeletionTime` datetime default NULL, 167 `Name` varchar(255) collate utf8_czech_ci NOT NULL, 168 `SystemListItems` int(11) NOT NULL, 169 PRIMARY KEY (`Id`) 170 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=5 ; 65 171 66 172 -- -------------------------------------------------------- … … 84 190 `System` tinyint(1) NOT NULL default '0', 85 191 `DbDataType` varchar(255) collate utf8_czech_ci NOT NULL, 192 PRIMARY KEY (`Id`) 193 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=57 ; 194 195 -- -------------------------------------------------------- 196 197 -- 198 -- Struktura tabulky `User` 199 -- 200 201 CREATE TABLE IF NOT EXISTS `User` ( 202 `Id` int(11) NOT NULL auto_increment, 203 `ItemId` int(11) NOT NULL, 204 `Author` int(11) NOT NULL, 205 `ValidTimeFrom` datetime default NULL, 206 `ValidTimeTo` datetime default NULL, 207 `CreationTime` datetime default NULL, 208 `DeletionTime` datetime default NULL, 209 `UserName` varchar(255) collate utf8_czech_ci NOT NULL, 210 `Password` varchar(255) collate utf8_czech_ci NOT NULL, 211 `FirstName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 212 `SecondName` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 213 `Email` varchar(255) character set ucs2 collate ucs2_czech_ci NOT NULL, 214 `ICQ` int(11) NOT NULL, 215 `Sex` int(11) NOT NULL default '0', 216 `BirthDay` date NOT NULL, 217 `Phone` varchar(255) collate utf8_czech_ci NOT NULL, 218 `Member` int(11) NOT NULL, 219 `RegistrationTime` datetime NOT NULL, 220 `LastLoginTime` datetime NOT NULL, 221 `Locked` tinyint(1) NOT NULL, 222 `LastIpAddress` varchar(255) collate utf8_czech_ci NOT NULL, 223 `PermissionGroup` int(11) NOT NULL, 224 PRIMARY KEY (`Id`) 225 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=36 ; 226 227 -- -------------------------------------------------------- 228 229 -- 230 -- Struktura tabulky `UserOnline` 231 -- 232 233 CREATE TABLE IF NOT EXISTS `UserOnline` ( 234 `User` int(11) NOT NULL, 235 `LoginTime` datetime NOT NULL, 236 `ActivityTime` datetime NOT NULL, 237 `SessionId` varchar(255) collate utf8_czech_ci NOT NULL, 238 `IpAddress` varchar(16) collate utf8_czech_ci NOT NULL, 239 `HostName` varchar(255) collate utf8_czech_ci NOT NULL, 240 `Id` int(11) NOT NULL auto_increment, 241 `ItemId` int(11) NOT NULL, 242 `Author` int(11) NOT NULL, 243 `ValidTimeFrom` datetime default NULL, 244 `ValidTimeTo` datetime default NULL, 245 `CreationTime` datetime default NULL, 246 `DeletionTime` datetime default NULL, 86 247 PRIMARY KEY (`Id`), 87 UNIQUE KEY `Name` (`Name`)88 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT= 39;248 KEY `User` (`User`) 249 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=28 ; -
types/GPS.php
r17 r18 20 20 global $Database; 21 21 22 $DbResult = $Database->query('SELECT * FROM `SystemGPS` WHERE `Id`='.$Item['Value']); 23 if($DbResult->num_rows > 0) 22 if($Item['Value'] != '') 24 23 { 25 $DbRow = $DbResult->fetch_assoc(); 24 $DbResult = $Database->query('SELECT * FROM `SystemGPS` WHERE `Id`='.$Item['Value']); 25 if($DbResult->num_rows > 0) 26 { 27 $DbRow = $DbResult->fetch_assoc(); 28 } else $DbRow = array('Longitude' => 0, 'Latitude' => 0); 26 29 } else $DbRow = array('Longitude' => 0, 'Latitude' => 0); 27 30 $Value = TypeGPSExplode($DbRow['Latitude']); -
types/Password.php
r11 r18 1 1 <?php 2 3 // SHA1 hash used 2 4 3 5 function TypePasswordOnView($Item) 4 6 { 5 7 $Output = ''; 6 for($I = 0; $I < strlen($Item['Value']); $I++)8 for($I = 0; $I < 6; $I++) 7 9 $Output .= '*'; 8 10 return($Output); … … 11 13 function TypePasswordOnEdit($Item) 12 14 { 13 $Output = '<input type="password" name="'.$Item['Name'].'" value=" '.$Item['Value'].'">';15 $Output = '<input type="password" name="'.$Item['Name'].'" value="">'; 14 16 return($Output); 15 17 } … … 17 19 function TypePasswordOnLoad($Item) 18 20 { 19 return($_POST[$Item['Name']]); 21 global $Database; 22 23 if(!array_key_exists('SourceItemId', $Item)) $Result = sha1($_POST[$Item['Name']]); 24 else 25 { 26 $DbRestult = $Database->query('SELECT '.$Item['Name'].' FROM '.$Item['SourceTable'].' WHERE Id='.$Item['SourceItemId']); 27 if($DbResult->num_rows > 0) 28 { 29 $DbRow = $DbResult->fetch_assoc(); 30 if($_POST[$Item['Name']] == '') $Result = $DbRow[$Item['Name']]; 31 else $Result = sha1($_POST[$Item['Name']]); 32 } else $Result = sha1($_POST[$Item['Name']]); 33 } 34 return($Result); 20 35 } 21 36 -
types/PointerOneToOne.php
r15 r18 34 34 if($DbResult->num_rows > 0) 35 35 { 36 $Result = array( );36 $Result = array(array('Name' => 'Žádný', 'Id' => 0, 'ItemId' => 0)); 37 37 while($DbRow = $DbResult->fetch_assoc()) 38 38 $Result[] = $DbRow; -
user.php
r15 r18 41 41 $SID = session_id(); 42 42 // Lookup user record 43 $Query = $this->Database->select($this->TableUserOnline, '*', ' SessionId="'.$SID.'"');43 $Query = $this->Database->select($this->TableUserOnline, '*', '`SessionId`="'.$SID.'"'); 44 44 if($Query->num_rows > 0) 45 45 { 46 46 // Refresh time of last access 47 $this->Database->update($this->TableUserOnline, ' SessionId="'.$SID.'"', array('ActivityTime' => 'NOW()'));47 $this->Database->update($this->TableUserOnline, '`SessionId`="'.$SID.'"', array('ActivityTime' => 'NOW()')); 48 48 } else $this->Database->insert($this->TableUserOnline, array('SessionId' => $SID, 'User' => 0, 'LoginTime' => 'NOW()', 'ActivityTime' => 'NOW()', 'IpAddress' => GetRemoteAddress(), 'HostName' => gethostbyaddr(GetRemoteAddress()))); 49 49 //echo($this->Database->LastQuery); … … 54 54 if($Row['User'] != 0) 55 55 { 56 $Query = $this->Database->select($this->TableUser, '*', "Id=".$Row['User'].""); 57 $this->User = $Query->fetch_array(); 56 $Query = $this->Database->query('SELECT * FROM `'.$this->TableUser.'` WHERE `ItemId`='.$Row['User'].' ORDER BY `Id` DESC LIMIT 1'); 57 $this->User = $Query->fetch_assoc(); 58 //print_r($this->User); 58 59 $Result = USER_LOGGED; 59 } else 60 { 61 $Query = $this->Database->select($this->TableUser, '*', " Id=0");62 $this->User = $Query->fetch_a rray();60 } else 61 { 62 $Query = $this->Database->select($this->TableUser, '*', "`ItemId`=0"); 63 $this->User = $Query->fetch_assoc(); 63 64 $Result = USER_NOT_LOGGED; 64 65 } 65 66 66 67 // Odeber neaktivní uživatele 67 $DbResult = $this->Database->select($this->TableUserOnline, 'User', ' ActivityTime< DATE_SUB(NOW(), INTERVAL '.USER_TIMEOUT.' SECOND)');68 while($DbRow = $DbResult->fetch_a rray())69 { 70 $this->Database->delete($this->TableUserOnline, ' User='.$DbRow['User']);68 $DbResult = $this->Database->select($this->TableUserOnline, 'User', '`ActivityTime` < DATE_SUB(NOW(), INTERVAL '.USER_TIMEOUT.' SECOND)'); 69 while($DbRow = $DbResult->fetch_assoc()) 70 { 71 $this->Database->delete($this->TableUserOnline, '`User`='.$DbRow['User']); 71 72 //$this->System->Modules['Log']->Add('User', 'Logout'); 72 73 } … … 94 95 else 95 96 { 96 $this->Database->insert($this->TableUser, array('Name' => $Nick, 'FirstName' => $FirstName, 'SecondName' => $SecondName, 'Password' => sha1($Password), 'Email' => $Email, 'RegistrationTime' => 'NOW()', 'Locked' => 1));97 $this->Database->insert($this->TableUser, array('Name' => $Nick, 'FirstName' => $FirstName, 'SecondName' => $SecondName, 'Password' => $Password, 'Email' => $Email, 'RegistrationTime' => 'NOW()', 'Locked' => 1)); 97 98 $UserId = $this->Database->insert_id; 98 99 99 100 $Subject = FromUTF8('Registrace nového účtu', 'iso2'); 100 $Message = 'Provedli jste registraci nového účtu na serveru <a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'">http://'.$Config['Web']['Host'].$Config['Web']['RootFolder']."</a>.<br>\nPokud jste tak neučinili, měli by jste tento email ignorovat.<br><br>\n\nVáš účet je: ".$Nick."\n<br>Pro dokončení registrace klikněte na ".'<a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'/?Action=UserRegisterConfirm&User='.$UserId.'&H='. sha1($Password).'">tento odkaz</a>.'."\n<br> \n\n<br><br>Na tento email neodpovídejte.";101 $Message = 'Provedli jste registraci nového účtu na serveru <a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'">http://'.$Config['Web']['Host'].$Config['Web']['RootFolder']."</a>.<br>\nPokud jste tak neučinili, měli by jste tento email ignorovat.<br><br>\n\nVáš účet je: ".$Nick."\n<br>Pro dokončení registrace klikněte na ".'<a href="http://'.$Config['Web']['Host'].$Config['Web']['RootFolder'].'/?Action=UserRegisterConfirm&User='.$UserId.'&H='.$Password.'">tento odkaz</a>.'."\n<br> \n\n<br><br>Na tento email neodpovídejte."; 101 102 $AdditionalHeaders = "To: ".$Nick." <".$Email.">\n"."From: ".FromUTF8($Config['Web']['Title'], 'iso2')." <noreplay@zdechov.net>\n"."MIME-Version: 1.0\n"."Content-type: text/html; charset=utf-8"; 102 103 mail($Email, $Subject, $Message, $AdditionalHeaders); … … 133 134 { 134 135 $Row = $Query->fetch_array(); 135 if($Row['Password'] != sha1($Password)) $Result = BAD_PASSWORD;136 if($Row['Password'] != $Password) $Result = BAD_PASSWORD; 136 137 else if($Row['Locked'] == 1) $Result = ACCOUNT_LOCKED; 137 else 138 else 138 139 { 139 140 $this->Database->update($this->TableUser, 'Id='.$Row['Id'], array('LastLoginTime' => 'NOW()')); 140 $this->Database->update($this->TableUserOnline, 'SessionId="'.$SID.'"', array('User' => $Row['I d']));141 $this->Database->update($this->TableUserOnline, 'SessionId="'.$SID.'"', array('User' => $Row['ItemId'], 'ItemId' => $Row['ItemId'])); 141 142 // načtení stavu stromu 142 143 $Result = USER_LOGGED_IN; … … 188 189 if(($NewPassword == $NewPassword2) and ($Hash == $Row['Password'])) 189 190 { 190 $this->Database->update($this->TableUser, 'Id='.$Row['Id'], array('Password' => sha1($NewPassword), 'Locked' => 0));191 $this->Database->update($this->TableUser, 'Id='.$Row['Id'], array('Password' => $NewPassword, 'Locked' => 0)); 191 192 $Output = USER_PASSWORD_RECOVERY_CONFIRMED; 192 193 //$this->System->Modules['Log']->NewRecord('User', 'PasswordRecoveryConfirm', 'UserName='.$Row['Name']);
Note:
See TracChangeset
for help on using the changeset viewer.