Changeset 85
- Timestamp:
- Feb 11, 2009, 6:57:49 AM (16 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 5 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/dictionary.php
r67 r85 53 53 <input type="text" value="'.$Search.'" name="search" size="30" /> 54 54 <input type="submit" value="Vyhledat" />'); 55 if(Licence( 0))55 if(Licence(LICENCE_USER)) 56 56 echo(' <a href="dictionary.php?insert">Vložit slovo</a>'); 57 57 -
trunk/form.php
r82 r85 72 72 } 73 73 74 if($TranslationTree[$GroupId]['WowheadName'] != '') 75 $WowheadLink = '<a href="http://www.wowhead.com/?'.$TranslationTree[$GroupId]['WowheadName']. 76 '='.$LineAJ['entry'].'">'.$LineAJ['entry'].'</a>'; 77 eůse $WowheadLink = $LineAJ['entry']; 78 74 79 echo('<input type="hidden" name="entry" value="'.$LineAJ['entry'].'" /> 75 80 <input type="hidden" name="user" value="'.$User.'" /> … … 77 82 <table border="1" cellpadding="1" cellspacing="0"> 78 83 <tr> 79 <th>Číslo textu: <a href="http://www.wowhead.com/?quest='.$LineAJ['entry'].'">'.$LineAJ['entry'].'</a></th>84 <th>Číslo textu: '.$WowheadLink.'</th> 80 85 <th>Nepřeložené</th> 81 86 <th>Přeložené</th> -
trunk/save.php
r71 r85 20 20 else $complete = 0; 21 21 22 if(array_key_exists('Repair', $_POST) and Licence(1))23 {24 $Line = mysql_fetch_array($Database->SQLCommand('SELECT user FROM '.$Table.' Where ID = '.$TextID));25 $UserID = $Line['user'];26 $complete = 1;27 WriteLog($TranslationTree[$GroupId]['Name'].' '.$entry.' Opraven moderátorem! <a href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a>', 4);28 }29 30 22 //if(( == '') AND ($complete == 1)) die('Musite zadat název textu'); 31 23 … … 45 37 //echo('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')'); 46 38 $Database->SQLCommand('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')'); 47 $LastID = mysql_insert_id();39 $LastID = mysql_insert_id(); 48 40 echo('Překlad <a href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a> uložen!<br />'); 49 41 WriteLog($TranslationTree[$GroupId]['Name'].' <a href="form.php?group='.$GroupId.'&ID='.$LastID.'">'.$LastID.'</a> uložen! Převzat z: <a href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a>', 1); … … 51 43 { 52 44 $sql = 'UPDATE '.$Table.' SET `Complete` = '.$complete; 53 foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)45 foreach($TranslationTree[$GroupId]['Items'] as $GroupItem) 54 46 $sql .= ', `'.$GroupItem['Column'].'`="'.@$_POST[$GroupItem['Column']].'"'; 55 $sql .= ', `Language` = '.$Language.' WHERE ID = '.$TextID.' AND Language <> 0';47 $sql .= ', `Language` = '.$Language.' WHERE ID = '.$TextID.' AND Language <> 0'; 56 48 //echo($sql); 57 49 $Database->SQLCommand($sql); … … 59 51 echo('Změny v překladu: <a href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a> uloženy!<br />'); 60 52 WriteLog('Změny v překladu: '.$entry.' uloženy! <a href="form.php?group='.$GroupId.'&ID='.$TextID.'">'.$TextID.'</a>', 1); 61 $type_translation = 1;62 $ID_translation = $TextID;63 $Database->SQLCommand("DELETE FROM tag WHERE ID_translation = $ID_translation AND type_translation = $type_translation");64 53 } 65 54 -
trunk/sql/data.sql
r70 r85 4 4 -- 5 5 6 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`) VALUES 7 (1, 'Výpravy', 'quests', 'mangos', 'quest_template', 'entry'), 8 (2, 'Texty knížek', 'page', 'mangos', 'page_text', 'entry'), 9 (3, 'Slova NPC', 'npc', 'mangos', 'npc_text', 'ID'), 10 (4, 'Názvy věcí', 'item', 'mangos', 'item_template', 'entry'), 11 (5, 'Názvy herních objektů', 'gameobject', 'mangos', 'gameobject_template', 'entry'), 12 (6, 'Jména bytostí', 'creature', 'mangos', 'creature_template', 'entry'), 13 (7, 'Zprávy MaNGOSu', 'mangos_string', 'mangos', 'mangos_string', 'entry'), 14 (8, 'Popis GM příkazů', 'mangos_command', 'mangos', 'command', 'entry'), 15 (9, 'Klient', 'client', '', '', ''), 16 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'scriptdev2', 'script_texts', 'entry'), 17 (11, 'Texty EventAI', 'sd2_eventai_texts', 'scriptdev2', 'eventai_texts', 'entry'); 6 INSERT INTO `group` (`Id`, `Name`, `TablePrefix`, `MangosDatabase`, `MangosTable`, `MangosTableIndex`, `DBCFileName`, `DBCColumns`, `WowheadName`) VALUES 7 (1, 'Výpravy', 'quests', 'realm2_mangos', 'quest_template', 'entry', '', '', 'quest'), 8 (2, 'Texty knížek', 'page', 'realm2_mangos', 'page_text', 'entry', '', '', ''), 9 (3, 'Slova NPC', 'npc', 'realm2_mangos', 'npc_text', 'ID', '', '', ''), 10 (4, 'Názvy věcí', 'item', 'realm2_mangos', 'item_template', 'entry', '', '', 'item'), 11 (5, 'Názvy herních objektů', 'gameobject', 'realm2_mangos', 'gameobject_template', 'entry', '', '', 'gameobject'), 12 (6, 'Jména bytostí', 'creature', 'realm2_mangos', 'creature_template', 'entry', '', '', 'npc'), 13 (7, 'Zprávy MaNGOSu', 'mangos_string', 'realm2_mangos', 'mangos_string', 'entry', '', '', ''), 14 (8, 'Popis GM příkazů', 'mangos_command', 'realm2_mangos', 'command', 'entry', '', '', ''), 15 (9, 'Klient', 'client', '', '', '', '', '', ''), 16 (10, 'Texty skriptů ScriptDev2', 'sd2_script_texts', 'realm2_scriptdev2', 'script_texts', 'entry', '', '', ''), 17 (11, 'Texty EventAI', 'sd2_eventai_texts', 'realm2_scriptdev2', 'eventai_texts', 'entry', '', '', ''), 18 (12, 'Herní tipy', 'gametips', '', '', '', 'GameTips', 'usuuuuuuuuuuuuuuuu', ''), 19 (13, 'Kouzla', 'spell', '', '', '', 'Spell', 'uuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuusssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssssuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuu', 'spell'); 18 20 19 21 -- … … 21 23 -- 22 24 23 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `MangosColumn`, `AddonFileName`) VALUES 24 (1, 1, 'Titulek', 'Title', 'Title', ''), 25 (2, 1, 'Detaily', 'Details', 'Details', 'QuestDescription'), 26 (3, 1, 'Úkol', 'Objectives', 'Objectives', 'QuestObjective'), 27 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 'OfferRewardText', 'QuestReward'), 28 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 'RequestItemsText', 'QuestProgress'), 29 (6, 1, 'Závěrečný text', 'EndText', 'EndText', ''), 30 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 'ObjectiveText1', ''), 31 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 'ObjectiveText2', ''), 32 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 'ObjectiveText3', ''), 33 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 'ObjectiveText4', ''), 34 (11, 2, 'Obsah', 'Text', 'Text', 'BookPage'), 35 (12, 3, 'Text 0.0', 'Text0_0', 'Text0_0', 'NPCText'), 36 (13, 3, 'Text 0.1', 'Text0_1', 'Text0_1', 'NPCAction'), 37 (14, 3, 'Text 1.0', 'Text1_0', 'Text1_0', ''), 38 (15, 3, 'Text 1.1', 'Text1_1', 'Text1_1', ''), 39 (16, 3, 'Text 2.0', 'Text2_0', 'Text2_0', ''), 40 (17, 3, 'Text 2.1', 'Text2_1', 'Text2_1', ''), 41 (18, 3, 'Text 3.0', 'Text3_0', 'Text3_0', ''), 42 (19, 3, 'Text 3.1', 'Text3_1', 'Text3_1', ''), 43 (20, 3, 'Text 4.0', 'Text4_0', 'Text4_0', ''), 44 (21, 3, 'Text 4.1', 'Text4_1', 'Text4_1', ''), 45 (22, 3, 'Text 5.0', 'Text5_0', 'Text5_0', ''), 46 (23, 3, 'Text 5.1', 'Text5_1', 'Text5_1', ''), 47 (24, 3, 'Text 6.0', 'Text6_0', 'Text6_0', ''), 48 (25, 3, 'Text 6.1', 'Text6_1', 'Text6_1', ''), 49 (26, 3, 'Text 7.0', 'Text7_0', 'Text7_0', ''), 50 (27, 3, 'Text 7.1', 'Text7_1', 'Text7_1', ''), 51 (28, 4, 'Jméno', 'Name', 'Name', ''), 52 (29, 4, 'Popis', 'Description', 'Description', ''), 53 (30, 5, 'Jméno', 'Name', 'Name', ''), 54 (31, 5, 'Popisek', 'castbarcaption', 'castbarcaption', ''), 55 (32, 6, 'Jméno', 'name', 'name', ''), 56 (33, 6, 'Druhé jméno', 'subname', 'subname', ''), 57 (34, 7, 'Obsah', 'content_default', 'content_default', ''), 58 (35, 8, 'Nápověda', 'help', 'help', ''), 59 (36, 9, 'Text', 'Text', '', ''), 60 (38, 10, 'Výchozí obsah', 'content_default', 'content_default', ''), 61 (39, 10, 'Komentář', 'comment', 'comment', ''), 62 (40, 11, 'Výchozí obsah', 'content_default', 'content_default', ''), 63 (41, 11, 'Komentář', 'comment', 'comment', ''); 25 INSERT INTO `group_item` (`Id`, `Group`, `Name`, `Column`, `MangosColumn`, `AddonFileName`, `DBCColumnIndex`) VALUES 26 (1, 1, 'Titulek', 'Title', 'Title', '', 0), 27 (2, 1, 'Detaily', 'Details', 'Details', 'QuestDescription', 0), 28 (3, 1, 'Úkol', 'Objectives', 'Objectives', 'QuestObjective', 0), 29 (4, 1, 'Text slíbené odměny', 'OfferRewardText', 'OfferRewardText', 'QuestReward', 0), 30 (5, 1, 'Popis požadovaných předmětů', 'RequestItemsText', 'RequestItemsText', 'QuestProgress', 0), 31 (6, 1, 'Závěrečný text', 'EndText', 'EndText', '', 0), 32 (7, 1, 'Text úkolu 1', 'ObjectiveText1', 'ObjectiveText1', '', 0), 33 (8, 1, 'Text úkolu 2', 'ObjectiveText2', 'ObjectiveText2', '', 0), 34 (9, 1, 'Text úkolu 3', 'ObjectiveText3', 'ObjectiveText3', '', 0), 35 (10, 1, 'Text úkolu 4', 'ObjectiveText4', 'ObjectiveText4', '', 0), 36 (11, 2, 'Obsah', 'Text', 'Text', 'BookPage', 0), 37 (12, 3, 'Text 0.0', 'Text0_0', 'Text0_0', 'NPCText', 0), 38 (13, 3, 'Text 0.1', 'Text0_1', 'Text0_1', 'NPCAction', 0), 39 (14, 3, 'Text 1.0', 'Text1_0', 'Text1_0', '', 0), 40 (15, 3, 'Text 1.1', 'Text1_1', 'Text1_1', '', 0), 41 (16, 3, 'Text 2.0', 'Text2_0', 'Text2_0', '', 0), 42 (17, 3, 'Text 2.1', 'Text2_1', 'Text2_1', '', 0), 43 (18, 3, 'Text 3.0', 'Text3_0', 'Text3_0', '', 0), 44 (19, 3, 'Text 3.1', 'Text3_1', 'Text3_1', '', 0), 45 (20, 3, 'Text 4.0', 'Text4_0', 'Text4_0', '', 0), 46 (21, 3, 'Text 4.1', 'Text4_1', 'Text4_1', '', 0), 47 (22, 3, 'Text 5.0', 'Text5_0', 'Text5_0', '', 0), 48 (23, 3, 'Text 5.1', 'Text5_1', 'Text5_1', '', 0), 49 (24, 3, 'Text 6.0', 'Text6_0', 'Text6_0', '', 0), 50 (25, 3, 'Text 6.1', 'Text6_1', 'Text6_1', '', 0), 51 (26, 3, 'Text 7.0', 'Text7_0', 'Text7_0', '', 0), 52 (27, 3, 'Text 7.1', 'Text7_1', 'Text7_1', '', 0), 53 (28, 4, 'Jméno', 'Name', 'Name', '', 0), 54 (29, 4, 'Popis', 'Description', 'Description', '', 0), 55 (30, 5, 'Jméno', 'Name', 'Name', '', 0), 56 (31, 5, 'Popisek', 'castbarcaption', 'castbarcaption', '', 0), 57 (32, 6, 'Jméno', 'name', 'name', '', 0), 58 (33, 6, 'Druhé jméno', 'subname', 'subname', '', 0), 59 (34, 7, 'Obsah', 'content_default', 'content_default', '', 0), 60 (35, 8, 'Nápověda', 'help', 'help', '', 0), 61 (36, 9, 'Text', 'Text', '', '', 0), 62 (38, 10, 'Výchozí obsah', 'content_default', 'content_default', 'Creature', 0), 63 (39, 10, 'Komentář', 'comment', 'comment', '', 0), 64 (40, 11, 'Výchozí obsah', 'content_default', 'content_default', 'Creature', 0), 65 (41, 11, 'Komentář', 'comment', 'comment', '', 0), 66 (42, 12, 'Text', 'Text', '', '', 1), 67 (43, 13, 'Název', 'Name', '', '', 139), 68 (46, 13, 'Popis', 'Description', '', '', 173), 69 (44, 13, 'Hodnost', 'Rank', '', '', 156), 70 (45, 13, 'Popisek', 'ToolTip', '', '', 190); -
trunk/sql/structure.sql
r73 r85 36 36 KEY `Take` (`Take`), 37 37 KEY `Complete` (`Complete`) 38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12 080;38 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12395 ; 39 39 40 40 -- -------------------------------------------------------- … … 47 47 `ID` int(11) unsigned NOT NULL auto_increment, 48 48 `entry` int(11) NOT NULL, 49 `name` varchar(255) NOT NULL, 50 `subname` varchar(255) NOT NULL, 51 `Language` int(11) NOT NULL default '0', 52 `Vote` float NOT NULL, 53 `CountVote` int(11) NOT NULL, 54 `User` int(11) NOT NULL, 55 `Complete` int(11) NOT NULL, 56 `Take` int(11) NOT NULL, 57 `admin_check` int(11) NOT NULL default '0', 58 PRIMARY KEY (`ID`), 59 KEY `entry` (`entry`), 60 KEY `User` (`User`), 61 KEY `Take` (`Take`), 62 KEY `Complete` (`Complete`), 63 KEY `Language` (`Language`) 64 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26294 ; 49 `name` text NOT NULL, 50 `subname` text NOT NULL, 51 `Language` int(11) NOT NULL default '0', 52 `User` int(11) NOT NULL, 53 `Complete` int(11) NOT NULL, 54 `Take` int(11) NOT NULL, 55 PRIMARY KEY (`ID`), 56 KEY `entry` (`entry`), 57 KEY `User` (`User`), 58 KEY `Take` (`Take`), 59 KEY `Complete` (`Complete`), 60 KEY `Language` (`Language`) 61 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=52717 ; 65 62 66 63 -- -------------------------------------------------------- … … 77 74 `user` int(11) NOT NULL, 78 75 PRIMARY KEY (`ID`) 79 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 3;76 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ; 80 77 81 78 -- -------------------------------------------------------- … … 88 85 `ID` int(11) unsigned NOT NULL auto_increment, 89 86 `entry` int(11) NOT NULL, 90 `Name` varchar(255)NOT NULL,91 `castbarcaption` varchar(255)NOT NULL,92 `Language` int(11) NOT NULL default '0', 93 `User` int(11) NOT NULL, 94 `Complete` int(11) NOT NULL, 95 `Take` int(11) NOT NULL, 96 PRIMARY KEY (`ID`), 97 KEY `entry` (`entry`), 98 KEY `User` (`User`), 99 KEY `Take` (`Take`), 100 KEY `Complete` (`Complete`), 101 KEY `Language` (`Language`) 102 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 17823;87 `Name` text NOT NULL, 88 `castbarcaption` text NOT NULL, 89 `Language` int(11) NOT NULL default '0', 90 `User` int(11) NOT NULL, 91 `Complete` int(11) NOT NULL, 92 `Take` int(11) NOT NULL, 93 PRIMARY KEY (`ID`), 94 KEY `entry` (`entry`), 95 KEY `User` (`User`), 96 KEY `Take` (`Take`), 97 KEY `Complete` (`Complete`), 98 KEY `Language` (`Language`) 99 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=35957 ; 103 100 104 101 -- -------------------------------------------------------- … … 122 119 KEY `Language` (`Language`), 123 120 KEY `Complete` (`Complete`) 124 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 132 ;121 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ; 125 122 126 123 -- -------------------------------------------------------- … … 139 136 `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL, 140 137 `DBCColumns` text collate utf8_czech_ci NOT NULL, 138 `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL, 141 139 PRIMARY KEY (`Id`) 142 140 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ; … … 168 166 `ID` int(11) unsigned NOT NULL auto_increment, 169 167 `entry` int(11) NOT NULL, 170 `Name` varchar(255)NOT NULL,171 `Description` varchar(255)NOT NULL,172 `Language` int(11) NOT NULL default '0', 173 `User` int(11) NOT NULL, 174 `Complete` int(11) NOT NULL, 175 `Take` int(11) NOT NULL, 176 PRIMARY KEY (`ID`), 177 KEY `entry` (`entry`), 178 KEY `User` (`User`), 179 KEY `Take` (`Take`), 180 KEY `Complete` (`Complete`), 181 KEY `Language` (`Language`) 182 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 31370;168 `Name` text NOT NULL, 169 `Description` text NOT NULL, 170 `Language` int(11) NOT NULL default '0', 171 `User` int(11) NOT NULL, 172 `Complete` int(11) NOT NULL, 173 `Take` int(11) NOT NULL, 174 PRIMARY KEY (`ID`), 175 KEY `entry` (`entry`), 176 KEY `User` (`User`), 177 KEY `Take` (`Take`), 178 KEY `Complete` (`Complete`), 179 KEY `Language` (`Language`) 180 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=62921 ; 183 181 184 182 -- -------------------------------------------------------- … … 197 195 PRIMARY KEY (`ID`), 198 196 KEY `user` (`user`) 199 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 2926;197 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=15390 ; 200 198 201 199 -- -------------------------------------------------------- … … 208 206 `ID` int(11) unsigned NOT NULL auto_increment, 209 207 `entry` int(11) NOT NULL, 210 `help` varchar(255)NOT NULL,211 `Language` int(11) NOT NULL default '0', 212 `User` int(11) NOT NULL, 213 `Complete` int(11) NOT NULL, 214 `Take` int(11) NOT NULL, 215 PRIMARY KEY (`ID`), 216 KEY `entry` (`entry`), 217 KEY `User` (`User`), 218 KEY `Take` (`Take`), 219 KEY `Complete` (`Complete`), 220 KEY `Language` (`Language`) 221 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1;208 `help` text NOT NULL, 209 `Language` int(11) NOT NULL default '0', 210 `User` int(11) NOT NULL, 211 `Complete` int(11) NOT NULL, 212 `Take` int(11) NOT NULL, 213 PRIMARY KEY (`ID`), 214 KEY `entry` (`entry`), 215 KEY `User` (`User`), 216 KEY `Take` (`Take`), 217 KEY `Complete` (`Complete`), 218 KEY `Language` (`Language`) 219 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=259 ; 222 220 223 221 -- -------------------------------------------------------- … … 230 228 `ID` int(11) unsigned NOT NULL auto_increment, 231 229 `entry` int(11) NOT NULL, 232 `content_default` varchar(255)NOT NULL,233 `Language` int(11) NOT NULL default '0', 234 `User` int(11) NOT NULL, 235 `Complete` int(11) NOT NULL, 236 `Take` int(11) NOT NULL, 237 PRIMARY KEY (`ID`), 238 KEY `entry` (`entry`), 239 KEY `User` (`User`), 240 KEY `Take` (`Take`), 241 KEY `Complete` (`Complete`), 242 KEY `Language` (`Language`) 243 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 680;230 `content_default` text NOT NULL, 231 `Language` int(11) NOT NULL default '0', 232 `User` int(11) NOT NULL, 233 `Complete` int(11) NOT NULL, 234 `Take` int(11) NOT NULL, 235 PRIMARY KEY (`ID`), 236 KEY `entry` (`entry`), 237 KEY `User` (`User`), 238 KEY `Take` (`Take`), 239 KEY `Complete` (`Complete`), 240 KEY `Language` (`Language`) 241 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1887 ; 244 242 245 243 -- -------------------------------------------------------- … … 255 253 `Text` text NOT NULL, 256 254 PRIMARY KEY (`Id`) 257 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 6;255 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ; 258 256 259 257 -- -------------------------------------------------------- … … 292 290 KEY `Complete` (`Complete`), 293 291 KEY `Language` (`Language`) 294 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=167790 63;292 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779074 ; 295 293 296 294 -- -------------------------------------------------------- … … 314 312 KEY `Complete` (`Complete`), 315 313 KEY `Language` (`Language`) 316 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=17 37;314 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1746 ; 317 315 318 316 -- -------------------------------------------------------- … … 342 340 KEY `entry` (`entry`), 343 341 KEY `User` (`User`), 344 KEY ` Complete` (`Complete`),345 KEY `Language` (`Language`) 346 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 697;342 KEY `complete` (`Complete`), 343 KEY `Language` (`Language`) 344 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10774 ; 347 345 348 346 -- -------------------------------------------------------- … … 367 365 KEY `Complete` (`Complete`), 368 366 KEY `Language` (`Language`) 369 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT= 380;367 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ; 370 368 371 369 -- -------------------------------------------------------- … … 390 388 KEY `Complete` (`Complete`), 391 389 KEY `Language` (`Language`) 392 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 088;390 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1120 ; 393 391 394 392 -- -------------------------------------------------------- … … 405 403 `IP` text character set latin2 collate latin2_czech_cs NOT NULL, 406 404 PRIMARY KEY (`ID`) 407 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=45 1;405 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=454 ; 408 406 409 407 -- -------------------------------------------------------- … … 417 415 `entry` int(11) NOT NULL, 418 416 `Name` text NOT NULL, 417 `Description` text NOT NULL, 418 `ToolTip` text NOT NULL, 419 419 `Rank` text NOT NULL, 420 `ToolTip` text NOT NULL,421 `Description` text NOT NULL,422 420 `Language` int(11) NOT NULL default '0', 423 421 `User` int(11) NOT NULL, … … 430 428 KEY `Language` (`Language`), 431 429 KEY `Complete` (`Complete`) 432 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 088;430 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42197 ; 433 431 434 432 -- -------------------------------------------------------- … … 447 445 `Email` text character set latin2 collate latin2_czech_cs NOT NULL, 448 446 `Language` int(11) NOT NULL default '1', 449 `ExportSetting` text c haracter set utf8NOT NULL,447 `ExportSetting` text collate utf8_czech_ci NOT NULL, 450 448 PRIMARY KEY (`ID`) 451 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=55 0;449 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=553 ;
Note:
See TracChangeset
for help on using the changeset viewer.