Changeset 85


Ignore:
Timestamp:
Feb 11, 2009, 6:57:49 AM (16 years ago)
Author:
george
Message:
  • Opraveno: Odkaz na wowhead se nyní zobrazuje podle aktuální vybrané překladové skupiny pokud související informace vůbec existuje. Aktualizace SQL struktury a dat.
  • Odstraněno: Staré nepoužívané úseky kódů.
Location:
trunk
Files:
1 added
5 edited

Legend:

Unmodified
Added
Removed
  • trunk/dictionary.php

    r67 r85  
    5353  <input type="text" value="'.$Search.'" name="search" size="30" />
    5454  <input type="submit" value="Vyhledat" />');
    55 if(Licence(0))
     55if(Licence(LICENCE_USER))
    5656  echo(' <a href="dictionary.php?insert">Vložit slovo</a>');
    5757           
  • trunk/form.php

    r82 r85  
    7272  }
    7373
     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 
    7479  echo('<input type="hidden" name="entry" value="'.$LineAJ['entry'].'" />
    7580    <input type="hidden" name="user" value="'.$User.'" />
     
    7782    <table border="1" cellpadding="1" cellspacing="0">
    7883      <tr>
    79         <th>Číslo textu: <a href="http://www.wowhead.com/?quest='.$LineAJ['entry'].'">'.$LineAJ['entry'].'</a></th>
     84        <th>Číslo textu: '.$WowheadLink.'</th>
    8085        <th>Nepřeložené</th>
    8186        <th>Přeložené</th>
  • trunk/save.php

    r71 r85  
    2020    else $complete = 0;
    2121         
    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.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 4);
    28   }
    29      
    3022  //if(( == '') AND ($complete == 1)) die('Musite zadat název textu');
    3123   
     
    4537        //echo('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
    4638    $Database->SQLCommand('INSERT INTO `'.$Table.'` ('.$Columns.') VALUES ('.$Values.')');
    47         $LastID = mysql_insert_id();
     39          $LastID = mysql_insert_id();
    4840    echo('Překlad <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uložen!<br />');
    4941    WriteLog($TranslationTree[$GroupId]['Name'].' <a href="form.php?group='.$GroupId.'&amp;ID='.$LastID.'">'.$LastID.'</a> uložen! Převzat z: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a>', 1);
     
    5143  {
    5244    $sql = 'UPDATE '.$Table.' SET `Complete` = '.$complete;
    53         foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
     45        foreach($TranslationTree[$GroupId]['Items'] as $GroupItem)
    5446          $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';
    5648        //echo($sql);
    5749    $Database->SQLCommand($sql);
     
    5951    echo('Změny v překladu: <a href="form.php?group='.$GroupId.'&amp;ID='.$TextID.'">'.$TextID.'</a> uloženy!<br />');
    6052    WriteLog('Změny v překladu: '.$entry.' uloženy! <a href="form.php?group='.$GroupId.'&amp;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");
    6453  }
    6554   
  • trunk/sql/data.sql

    r70 r85  
    44--
    55
    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');
     6INSERT 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');
    1820
    1921--
     
    2123--
    2224
    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', '');
     25INSERT 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  
    3636  KEY `Take` (`Take`),
    3737  KEY `Complete` (`Complete`)
    38 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12080 ;
     38) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=12395 ;
    3939
    4040-- --------------------------------------------------------
     
    4747  `ID` int(11) unsigned NOT NULL auto_increment,
    4848  `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 ;
    6562
    6663-- --------------------------------------------------------
     
    7774  `user` int(11) NOT NULL,
    7875  PRIMARY KEY  (`ID`)
    79 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=53 ;
     76) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=52 ;
    8077
    8178-- --------------------------------------------------------
     
    8885  `ID` int(11) unsigned NOT NULL auto_increment,
    8986  `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 ;
    103100
    104101-- --------------------------------------------------------
     
    122119  KEY `Language` (`Language`),
    123120  KEY `Complete` (`Complete`)
    124 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ;
     121) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=212 ;
    125122
    126123-- --------------------------------------------------------
     
    139136  `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL,
    140137  `DBCColumns` text collate utf8_czech_ci NOT NULL,
     138  `WowheadName` varchar(255) collate utf8_czech_ci NOT NULL,
    141139  PRIMARY KEY  (`Id`)
    142140) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ;
     
    168166  `ID` int(11) unsigned NOT NULL auto_increment,
    169167  `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 ;
    183181
    184182-- --------------------------------------------------------
     
    197195  PRIMARY KEY  (`ID`),
    198196  KEY `user` (`user`)
    199 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=12926 ;
     197) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=15390 ;
    200198
    201199-- --------------------------------------------------------
     
    208206  `ID` int(11) unsigned NOT NULL auto_increment,
    209207  `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 ;
    222220
    223221-- --------------------------------------------------------
     
    230228  `ID` int(11) unsigned NOT NULL auto_increment,
    231229  `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 ;
    244242
    245243-- --------------------------------------------------------
     
    255253  `Text` text NOT NULL,
    256254  PRIMARY KEY  (`Id`)
    257 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ;
     255) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=10 ;
    258256
    259257-- --------------------------------------------------------
     
    292290  KEY `Complete` (`Complete`),
    293291  KEY `Language` (`Language`)
    294 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779063 ;
     292) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=16779074 ;
    295293
    296294-- --------------------------------------------------------
     
    314312  KEY `Complete` (`Complete`),
    315313  KEY `Language` (`Language`)
    316 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1737 ;
     314) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1746 ;
    317315
    318316-- --------------------------------------------------------
     
    342340  KEY `entry` (`entry`),
    343341  KEY `User` (`User`),
    344   KEY `Complete` (`Complete`),
    345   KEY `Language` (`Language`)
    346 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10697 ;
     342  KEY `complete` (`Complete`),
     343  KEY `Language` (`Language`)
     344) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=10774 ;
    347345
    348346-- --------------------------------------------------------
     
    367365  KEY `Complete` (`Complete`),
    368366  KEY `Language` (`Language`)
    369 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=380 ;
     367) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=411 ;
    370368
    371369-- --------------------------------------------------------
     
    390388  KEY `Complete` (`Complete`),
    391389  KEY `Language` (`Language`)
    392 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1088 ;
     390) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1120 ;
    393391
    394392-- --------------------------------------------------------
     
    405403  `IP` text character set latin2 collate latin2_czech_cs NOT NULL,
    406404  PRIMARY KEY  (`ID`)
    407 ) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=451 ;
     405) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=454 ;
    408406
    409407-- --------------------------------------------------------
     
    417415  `entry` int(11) NOT NULL,
    418416  `Name` text NOT NULL,
     417  `Description` text NOT NULL,
     418  `ToolTip` text NOT NULL,
    419419  `Rank` text NOT NULL,
    420   `ToolTip` text NOT NULL,
    421   `Description` text NOT NULL,
    422420  `Language` int(11) NOT NULL default '0',
    423421  `User` int(11) NOT NULL,
     
    430428  KEY `Language` (`Language`),
    431429  KEY `Complete` (`Complete`)
    432 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42088 ;
     430) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=42197 ;
    433431
    434432-- --------------------------------------------------------
     
    447445  `Email` text character set latin2 collate latin2_czech_cs NOT NULL,
    448446  `Language` int(11) NOT NULL default '1',
    449   `ExportSetting` text character set utf8 NOT NULL,
     447  `ExportSetting` text collate utf8_czech_ci NOT NULL,
    450448  PRIMARY KEY  (`ID`)
    451 ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=550 ;
     449) ENGINE=MyISAM  DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=553 ;
Note: See TracChangeset for help on using the changeset viewer.