Changeset 71
- Timestamp:
- Feb 6, 2009, 4:55:48 PM (16 years ago)
- Location:
- trunk
- Files:
-
- 1 added
- 7 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/TranslationList.php
r70 r71 125 125 } 126 126 127 if($Action == 'nocheck')128 {129 echo('<a title="Zobrazit překlady podle vlasního filtru" href="?group='.$GroupId.'&action=filter">Filtr překladů</a> ->130 <a title="Zatím nezkontrolované texty" href="?group='.$GroupId.'&action=nocheck">Nezkontrolované texty</a><br /><br />');131 132 WritePages('?group='.$GroupId.'&action=nocheck', ' WHERE Language <> 0 AND '.$Table.'.Complete = 1133 AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = '.$_SESSION['UserID'].' AND tag.type_translation = 1 AND tag.ID_translation = '.$Table.'.ID)');134 135 WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User136 FROM '.$Table.' WHERE Language <> 0 AND '.$Table.'.Complete = 1137 AND NOT EXISTS(SELECT 1 FROM tag WHERE ID_user = '.$_SESSION['UserID'].' AND tag.type_translation = 1 AND tag.ID_translation = '.$Table.'.ID)', $_SESSION['limitx'].','.$_SESSION['limity'], 'nocheck');138 }139 140 if($Action == 'check')141 {142 echo('<a title="Zobrazit překlady podle vlasního filtru" href="?group='.$GroupId.'&action=filter">Filtr překladů</a> ->143 <a title="Zkontrolované překlady" href="?group='.$GroupId.'&action=check">Zkontrolované překlady</a><br /><br />');144 145 WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User146 FROM '.$Table.' WHERE Language <> 0 AND '.$Table.'.Complete = 1 AND147 EXISTS(SELECT 1 FROM tag WHERE ID_user = '.$_SESSION['UserID'].' AND148 tag.type_translation = 1 AND tag.ID_translation = '.$Table.'.ID)', $_SESSION['limitx'].','.$_SESSION['limity'], 'check');149 }150 151 if($Action == 'admin_check')152 {153 echo('<a title="Zobrazit texty podle vlastního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->154 <a title="Zkontrolované texty" href="?group='.$GroupId.'&action=admin_nocheck">Zkontrolované texty</a><br /><br />');155 156 WritePages('?group='.$GroupId.'&action=nocheck',' WHERE Language <> 0 AND '.$Table.'.Complete = 1 AND admin_check = 1');157 158 WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User159 FROM '.$Table.' WHERE (Language <> 0) AND ('.$Table.'.Complete = 1) AND (admin_check = 1)', $_SESSION['limitx'].','.$_SESSION['limity'], 'admin_check');160 }161 162 if($Action == 'admin_nocheck')163 {164 echo('<a title="Zobrazit texty podle vlasního filtru" href="?group='.$GroupId.'&action=filter">Filtr textů</a> ->165 <a title="Zatím nezkontrolované questy" href="?group='.$GroupId.'&action=admin_nocheck">Nezkontrolované texty</a><br /><br />');166 167 WritePages('?group='.$GroupId.'&action=nocheck', ' WHERE Language <> 0 AND '.$Table.'.Complete = 1 AND admin_check <> 1');168 169 WriteQuests('SELECT *, (SELECT user.user FROM user WHERE user.id = '.$Table.'.user) as User170 FROM '.$Table.' WHERE (Language <> 0) AND ('.$Table.'.Complete = 1) AND (admin_check <> 1)', $_SESSION['limitx'].','.$_SESSION['limity'], 'admin_nocheck');171 }172 173 127 if($Action == 'Translate') 174 128 { … … 254 208 <tr><td><a title="Přeložené texty přihlášeného uživatele" href="?group='.$GroupId.'&action=my">Moje překlady</a></td> 255 209 <td>Přeložené texty přihlášeného uživatele</td></tr>'); 256 echo('<tr><td><a title="Nezkontrolované překlady" href="?group='.$GroupId.'&action=nocheck">Nezkontrolované překlady</a></td></tr>');257 echo('<tr><td><a title="Zkontrolované překlady" href="?group='.$GroupId.'&action=check">Zkontrolované překlady</a></td></tr>');258 210 } 259 211 -
trunk/action.php
r70 r71 15 15 echo('Překlad byl smazán!'); 16 16 WriteLog('Překlad byl smazán! <a href="form.php?group='.$GroupID.'&ID='.$TextID.'">'.$TextID.'</a>', 4); 17 }18 19 if((array_key_exists('Action', $_POST)) and ($_POST['Action'] == 'type_translation') and Licence(LICENCE_MODERATOR))20 {21 if(array_key_exists('1', $_POST)) $check = 1; else $check = 0;22 $ID_translation = $_POST['ID_translation'];23 $type_translation = $_POST['type_translation'];24 $Database->SQLCommand("DELETE FROM tag WHERE ID_user = ".$_SESSION['UserID']." AND ID_translation = $ID_translation AND type_translation = $type_translation");25 $Database->SQLCommand("INSERT INTO `tag` ( `type_translation` , `ID_translation` , `ID_user` , `tag` )26 VALUES ('$type_translation', '$ID_translation', '".$_SESSION['UserID']."', '$check')");27 echo('Překlad označen!');28 WriteLog('Překlad označen: '.$check.' <a href="form.php?group='.$GroupId.'&ID='.$ID_translation.'">'.$ID_translation.'</a>', 5);29 }30 31 if(($Action == 'admin_check') and Licence(LICENCE_ADMIN))32 {33 $ID = $_GET['ID'];34 $admin_check = $_GET['admin_check'];35 $entry = mysql_fetch_array($Database->SQLCommand('SELECT entry FROM '.$Table.' Where ID = '.$ID));36 $Database->SQLCommand('UPDATE '.$Table.' SET admin_check = 0 WHERE entry = '.$entry['entry'].' AND Language <> 0');37 $Database->SQLCommand('UPDATE '.$Table.' SET admin_check = '.$admin_check.' WHERE ID = '.$ID.' AND Language <> 0');38 if($admin_check == 1)39 {40 echo('Překlad byl zkontrolován!');41 WriteLog('Překlad byl zkontrolován! <a href="form.php?group='.$GroupId.'&ID='.$ID.'">'.$ID.'</a>', 4);42 } else43 {44 echo('U překladu bylo zrušeno zkontrolování!');45 WriteLog('U překladu bylo zrušeno zkontrolování! <a href="form.php?group='.$GroupId.'&ID='.$ID.'">'.$ID.'</a>', 4);46 }47 }48 49 if(($Action == 'NotComplete') and Licence(LICENCE_MODERATOR))50 {51 $TextID = $_GET['ID'];52 $Database->SQLCommand('UPDATE '.$Table.' SET Complete = 0 WHERE ID = '.$TextID);53 echo('Překlad byl vrácen k opravě!');54 WriteLog('Překlad byl vrácen k opravě <a href="form.php?group='.$GroupID.'&ID='.$TextID.'">'.$TextID.'</a>', 4);55 17 } 56 18 -
trunk/form.php
r70 r71 20 20 21 21 $User = @$_SESSION['User']; 22 $IDUser = $Database->SQLCommand('SELECT * FROM user W hereid = '.$Line['User']);22 $IDUser = $Database->SQLCommand('SELECT * FROM user WHERE id = '.$Line['User']); 23 23 $LineUser = mysql_fetch_array($IDUser); 24 24 25 echo('Skupina: <strong>'.$TranslationTree[$GroupId]['Name'].'</strong><br />'); 25 26 26 27 if(($Line['Language'] <> 0) and ($LineUser['user'] <> '')) echo('Přeložil: <strong>'.$LineUser['user'].'</strong> <br />'); … … 42 43 } 43 44 44 // kontrolování textů45 $ID_translation = $TextID;46 $type_translation = 1;47 $check = mysql_fetch_array($Database->SQLCommand('SELECT * FROM tag WHERE ID_user = '.$_SESSION['UserID'].' AND ID_translation = '.$ID_translation.' AND type_translation = '.$type_translation));48 echo('<form action="action.php?group='.$GroupId.'" method="post" name="check">');49 if($check['tag'] == 1)50 echo('<input name="0" type="submit" value="Odebrat z vlastního výběru" />');51 else52 echo('<input name="1" type="submit" value="Přidat do vlastního výběru" />');53 echo(' <input type="hidden" name="ID_translation" value="'.$ID_translation.'" />54 <input type="hidden" name="type_translation" value="'.$type_translation.'" />55 </form>');56 if($Line['admin_check'] <> 0)57 {58 echo('<b>Překlad byl zkontrolován adminem</b><br />');59 }60 if(Licence(LICENCE_ADMIN))61 {62 $admin_check = mysql_fetch_array($Database->SQLCommand('SELECT ID FROM '.$Table.' Where entry = '.$Line['entry'].' AND admin_check = 1 AND ID <> '.$TextID));63 if(isset($admin_check['ID']))64 echo('Již byla zkontrolována adminem jiná verze překladu: <a href="form.php?group='.$GroupId.'&ID='.$admin_check['ID'].'">'.$admin_check['ID'].'</a><br />');65 }66 45 $number_version = mysql_fetch_array($Database->SQLCommand('SELECT count(*) FROM '.$Table.' Where entry = '.$Line['entry'].' AND Language <> 0')); 67 46 echo('Počet verzí: <b>'.$number_version['count(*)'].'</b> '); … … 74 53 echo('<input type="submit" value="Uložit do rozepsaných" name="save" Title="Klikněte na uložit pro pozdější dokončení překladu" /> 75 54 <input type="submit" value="Dokončeno" name="End" Title="Klikněte na Dokončeno jesli jsou všechny texty hotové a chcete již publikovat" />'); 76 }77 78 if (Licence(LICENCE_MODERATOR) and ($Line['Language'] <> 0))79 {80 echo('<input type="submit" value="Opravit" name="Repair" Title="Opravit po uživateli chyby (pouze moderátor)" />');81 }82 if(Licence(LICENCE_MODERATOR) and ($Line['Language'] <> 0))83 {84 // echo '<input type="submit" value="Opravit Q" name="Repair"> Klikněte Jestli si přejete opravit chyby v Questu<br>';85 86 echo(' <input type="hidden" name="UserRepair" value="'.$Line['User'].'" />');87 echo(' <a style="color: Red" title="smazat (pouze moderátor)" href="action.php?group='.$GroupId.'&action=delete&delete=1&ID='.$TextID.'">x</a>88 <a style="color: Red" title="Není hotovo (pouze moderátor)" href="action.php?group='.$GroupId.'&action=NotComplete&NotComplete=1&ID='.$TextID.'"><-</a>');89 if(Licence(LICENCE_ADMIN))90 {91 if($Line['admin_check'] <> '1')92 {93 echo(' <a style="color: Green" title="Zkontrolováno (pouze admin)" href="action.php?group='.$GroupId.'&action=admin_check&admin_check=1&ID='.$TextID.'"><b>+</b></a>');94 } else95 {96 echo(' <a style="color: Green" title="Zrušit zkontrolování (pouze admin)" href="action.php?group='.$GroupId.'&action=admin_check&admin_check=0&ID='.$TextID.'"><b>-</b></a>');97 }98 }99 55 } 100 56 … … 128 84 <th>'.$TextItem['Name'].'</th> 129 85 <td width="300">'.htmlspecialchars($LineAJ[$TextItem['Column']]).'</td> 130 <td><textarea rows="8" style="width: 300px; height=100%;" name="'.$TextItem['Column'].'">'.htmlspecialchars($Line[$TextItem['Column']]).'</textarea></td></tr>');86 <td><textarea rows="8" style="width: 300px; height=100%;" id="'.$TextItem['Column'].'" name="'.$TextItem['Column'].'">'.htmlspecialchars($Line[$TextItem['Column']]).'</textarea></td></tr>'); 131 87 } 132 88 echo('</table> -
trunk/includes/global.php
r70 r71 106 106 <a title="Všechny překlady, které jste přeložil" href="TranslationList.php?group='.$Group['Id'].'&action=my">Vlastní</a><br />'); 107 107 } 108 if(Licence(LICENCE_ADMIN))109 {110 echo(' <a title="Nezkontrolované překlady" href="TranslationList.php?group='.$Group['Id'].'&action=nocheck">Nezkontrolované</a><br />');111 echo(' <a title="Zkontrolované překlady" href="TranslationList.php?group='.$Group['Id'].'&action=check">Zkontrolované</a><br />');112 }113 108 echo(' <a title="Sestavit speciální filtr" href="TranslationList.php?group='.$Group['Id'].'&action=filter">Filtr</a><br />'); 114 109 echo('</div>'); … … 149 144 echo('<title>Projekt překládání textů WoW</title> 150 145 </head> 151 <body >');146 <body onload="adjustRows(document.getElementById(\'Details\'));">'); 152 147 153 148 if(!array_key_exists('UserID', $_SESSION)) $_SESSION['UserID'] = ''; -
trunk/save.php
r70 r71 53 53 foreach($TranslationTree[$GroupId]['Items'] as $GroupItem) 54 54 $sql .= ', `'.$GroupItem['Column'].'`="'.@$_POST[$GroupItem['Column']].'"'; 55 $sql .= ', `Language` = '.$Language.', admin_check = 0 56 WHERE ID = '.$TextID.' AND Language <> 0'; 55 $sql .= ', `Language` = '.$Language.' WHERE ID = '.$TextID.' AND Language <> 0'; 57 56 //echo($sql); 58 57 $Database->SQLCommand($sql); -
trunk/sql/structure.sql
r70 r71 39 39 KEY `Take` (`Take`), 40 40 KEY `Complete` (`Complete`) 41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12081 ; 42 43 -- -------------------------------------------------------- 44 45 -- 46 -- Struktura tabulky `client_vote` 47 -- 48 49 CREATE TABLE IF NOT EXISTS `client_vote` ( 50 `ID` int(11) NOT NULL auto_increment, 51 `IDclient` int(11) NOT NULL, 52 `IDuser` int(11) NOT NULL, 53 `vote` int(11) NOT NULL, 54 PRIMARY KEY (`ID`), 55 KEY `IDuser` (`IDuser`), 56 KEY `IDclient` (`IDclient`) 57 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ; 41 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=12080 ; 58 42 59 43 -- -------------------------------------------------------- … … 82 66 KEY `Language` (`Language`) 83 67 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=26294 ; 84 85 -- --------------------------------------------------------86 87 --88 -- Struktura tabulky `creature_vote`89 --90 91 CREATE TABLE IF NOT EXISTS `creature_vote` (92 `ID` int(11) NOT NULL auto_increment,93 `TextId` int(11) NOT NULL,94 `IDuser` int(11) NOT NULL,95 `vote` int(11) NOT NULL,96 PRIMARY KEY (`ID`),97 KEY `IDquest` (`TextId`),98 KEY `IDuser` (`IDuser`)99 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;100 68 101 69 -- -------------------------------------------------------- … … 143 111 144 112 -- 145 -- Struktura tabulky `gameobject_vote` 146 -- 147 148 CREATE TABLE IF NOT EXISTS `gameobject_vote` ( 149 `ID` int(11) NOT NULL auto_increment, 150 `TextId` int(11) NOT NULL, 151 `IDuser` int(11) NOT NULL, 152 `vote` int(11) NOT NULL, 153 PRIMARY KEY (`ID`), 154 KEY `IDquest` (`TextId`), 155 KEY `IDuser` (`IDuser`) 156 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 113 -- Struktura tabulky `gametips` 114 -- 115 116 CREATE TABLE IF NOT EXISTS `gametips` ( 117 `ID` int(11) unsigned NOT NULL auto_increment, 118 `entry` int(11) NOT NULL, 119 `Text` text NOT NULL, 120 `Language` int(11) NOT NULL default '0', 121 `Vote` float NOT NULL, 122 `CountVote` int(11) NOT NULL, 123 `User` int(11) NOT NULL, 124 `Complete` int(11) NOT NULL, 125 `Take` int(11) NOT NULL, 126 `admin_check` int(11) NOT NULL default '0', 127 PRIMARY KEY (`ID`), 128 KEY `entry` (`entry`), 129 KEY `User` (`User`), 130 KEY `Take` (`Take`), 131 KEY `Language` (`Language`), 132 KEY `Complete` (`Complete`) 133 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=132 ; 157 134 158 135 -- -------------------------------------------------------- … … 169 146 `MangosTable` varchar(255) collate utf8_czech_ci NOT NULL, 170 147 `MangosTableIndex` varchar(255) collate utf8_czech_ci NOT NULL, 148 `DBCFileName` varchar(255) collate utf8_czech_ci NOT NULL, 149 `DBCColumns` text collate utf8_czech_ci NOT NULL, 171 150 PRIMARY KEY (`Id`) 172 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1 2;151 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=14 ; 173 152 174 153 -- -------------------------------------------------------- … … 185 164 `MangosColumn` varchar(255) collate utf8_czech_ci NOT NULL, 186 165 `AddonFileName` varchar(255) collate utf8_czech_ci NOT NULL, 166 `DBCColumnIndex` int(11) NOT NULL, 187 167 PRIMARY KEY (`Id`) 188 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=4 2;168 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=47 ; 189 169 190 170 -- -------------------------------------------------------- … … 213 193 KEY `Language` (`Language`) 214 194 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=31370 ; 215 216 -- --------------------------------------------------------217 218 --219 -- Struktura tabulky `item_vote`220 --221 222 CREATE TABLE IF NOT EXISTS `item_vote` (223 `ID` int(11) NOT NULL auto_increment,224 `TextId` int(11) NOT NULL,225 `IDuser` int(11) NOT NULL,226 `vote` int(11) NOT NULL,227 PRIMARY KEY (`ID`),228 KEY `IDquest` (`TextId`),229 KEY `IDuser` (`IDuser`)230 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;231 195 232 196 -- -------------------------------------------------------- … … 245 209 PRIMARY KEY (`ID`), 246 210 KEY `user` (`user`) 247 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12 875 ;211 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=12925 ; 248 212 249 213 -- -------------------------------------------------------- … … 275 239 276 240 -- 277 -- Struktura tabulky `mangos_command_vote`278 --279 280 CREATE TABLE IF NOT EXISTS `mangos_command_vote` (281 `ID` int(11) NOT NULL auto_increment,282 `TextId` int(11) NOT NULL,283 `IDuser` int(11) NOT NULL,284 `vote` int(11) NOT NULL,285 PRIMARY KEY (`ID`),286 KEY `IDquest` (`TextId`),287 KEY `IDuser` (`IDuser`)288 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;289 290 -- --------------------------------------------------------291 292 --293 241 -- Struktura tabulky `mangos_string` 294 242 -- … … 316 264 317 265 -- 318 -- Struktura tabulky `mangos_string_vote` 319 -- 320 321 CREATE TABLE IF NOT EXISTS `mangos_string_vote` ( 322 `ID` int(11) NOT NULL auto_increment, 323 `TextId` int(11) NOT NULL, 324 `IDuser` int(11) NOT NULL, 325 `vote` int(11) NOT NULL, 326 PRIMARY KEY (`ID`), 327 KEY `IDquest` (`TextId`), 328 KEY `IDuser` (`IDuser`) 329 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; 266 -- Struktura tabulky `news` 267 -- 268 269 CREATE TABLE IF NOT EXISTS `news` ( 270 `Id` int(11) NOT NULL auto_increment, 271 `Time` datetime NOT NULL, 272 `User` int(11) NOT NULL, 273 `Text` text NOT NULL, 274 PRIMARY KEY (`Id`) 275 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=6 ; 330 276 331 277 -- -------------------------------------------------------- … … 372 318 373 319 -- 374 -- Struktura tabulky `npc_vote`375 --376 377 CREATE TABLE IF NOT EXISTS `npc_vote` (378 `ID` int(11) NOT NULL auto_increment,379 `IDnpc` int(11) NOT NULL,380 `IDuser` int(11) NOT NULL,381 `vote` int(11) NOT NULL,382 PRIMARY KEY (`ID`),383 KEY `IDuser` (`IDuser`),384 KEY `IDquest` (`IDnpc`)385 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=744 ;386 387 -- --------------------------------------------------------388 389 --390 320 -- Struktura tabulky `page` 391 321 -- … … 409 339 KEY `Language` (`Language`) 410 340 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System' AUTO_INCREMENT=1737 ; 411 412 -- --------------------------------------------------------413 414 --415 -- Struktura tabulky `page_vote`416 --417 418 CREATE TABLE IF NOT EXISTS `page_vote` (419 `ID` int(11) NOT NULL auto_increment,420 `IDpage` int(11) NOT NULL,421 `IDuser` int(11) NOT NULL,422 `vote` int(11) NOT NULL,423 PRIMARY KEY (`ID`),424 KEY `IDuser` (`IDpage`),425 KEY `IDquest` (`IDpage`)426 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=417 ;427 341 428 342 -- -------------------------------------------------------- … … 462 376 463 377 -- 464 -- Struktura tabulky `quests_status`465 --466 467 CREATE TABLE IF NOT EXISTS `quests_status` (468 `ID` int(11) NOT NULL auto_increment,469 `QuestEntry` int(11) NOT NULL,470 `CountQuest` int(11) NOT NULL,471 `State` int(11) NOT NULL,472 PRIMARY KEY (`ID`)473 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;474 475 -- --------------------------------------------------------476 477 --478 -- Struktura tabulky `quests_vote`479 --480 481 CREATE TABLE IF NOT EXISTS `quests_vote` (482 `ID` int(11) NOT NULL auto_increment,483 `TextId` int(11) NOT NULL,484 `IDuser` int(11) NOT NULL,485 `vote` int(11) NOT NULL,486 PRIMARY KEY (`ID`),487 KEY `IDquest` (`TextId`),488 KEY `IDuser` (`IDuser`)489 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3278 ;490 491 -- --------------------------------------------------------492 493 --494 378 -- Struktura tabulky `sd2_eventai_texts` 495 379 -- … … 518 402 519 403 -- 520 -- Struktura tabulky `sd2_eventai_texts_vote`521 --522 523 CREATE TABLE IF NOT EXISTS `sd2_eventai_texts_vote` (524 `ID` int(11) NOT NULL auto_increment,525 `TextId` int(11) NOT NULL,526 `IDuser` int(11) NOT NULL,527 `vote` int(11) NOT NULL,528 PRIMARY KEY (`ID`),529 KEY `IDquest` (`TextId`),530 KEY `IDuser` (`IDuser`)531 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;532 533 -- --------------------------------------------------------534 535 --536 404 -- Struktura tabulky `sd2_script_texts` 537 405 -- … … 556 424 KEY `Language` (`Language`) 557 425 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1088 ; 558 559 -- --------------------------------------------------------560 561 --562 -- Struktura tabulky `sd2_script_texts_vote`563 --564 565 CREATE TABLE IF NOT EXISTS `sd2_script_texts_vote` (566 `ID` int(11) NOT NULL auto_increment,567 `TextId` int(11) NOT NULL,568 `IDuser` int(11) NOT NULL,569 `vote` int(11) NOT NULL,570 PRIMARY KEY (`ID`),571 KEY `IDquest` (`TextId`),572 KEY `IDuser` (`IDuser`)573 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;574 426 575 427 -- -------------------------------------------------------- … … 586 438 `IP` text character set latin2 collate latin2_czech_cs NOT NULL, 587 439 PRIMARY KEY (`ID`) 588 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=449 ; 440 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=451 ; 441 442 -- -------------------------------------------------------- 443 444 -- 445 -- Struktura tabulky `spell` 446 -- 447 448 CREATE TABLE IF NOT EXISTS `spell` ( 449 `ID` int(11) unsigned NOT NULL auto_increment, 450 `entry` int(11) NOT NULL, 451 `Name` text NOT NULL, 452 `Rank` text NOT NULL, 453 `ToolTip` text NOT NULL, 454 `Description` text NOT NULL, 455 `Language` int(11) NOT NULL default '0', 456 `Vote` float NOT NULL, 457 `CountVote` int(11) NOT NULL, 458 `User` int(11) NOT NULL, 459 `Complete` int(11) NOT NULL, 460 `Take` int(11) NOT NULL, 461 `admin_check` int(11) NOT NULL default '0', 462 PRIMARY KEY (`ID`), 463 KEY `entry` (`entry`), 464 KEY `User` (`User`), 465 KEY `Take` (`Take`), 466 KEY `Language` (`Language`), 467 KEY `Complete` (`Complete`) 468 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=42088 ; 589 469 590 470 -- -------------------------------------------------------- … … 618 498 `Email` text character set latin2 collate latin2_czech_cs NOT NULL, 619 499 `Language` int(11) NOT NULL default '1', 620 `ExportSetting` text NOT NULL,500 `ExportSetting` text character set utf8 NOT NULL, 621 501 PRIMARY KEY (`ID`) 622 ) ENGINE=MyISAM DEFAULT CHARSET= latin1 AUTO_INCREMENT=549;502 ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=550 ; -
trunk/style/global.js
r60 r71 10 10 el.display = 'none'; 11 11 } 12 13 function adjustRows(textarea) 14 { 15 if(document.all) 16 { 17 while(textarea.scrollHeight > textarea.clientHeight) 18 textarea.rows++; 19 textarea.scrollTop = 0; 20 } 21 else if(textarea.rows) 22 { 23 textarea.rows = 30; 24 /* 25 var lineBreaks = 50;//countLineBreaks(textarea.value); 26 var rows = parseInt(textarea.rows); 27 var wrap = textarea.getAttribute('wrap'); 28 if(lineBreaks > rows) 29 textarea.rows = ++rows; 30 else if(wrap.toLowerCase() == 'soft' || wrap.toLowerCase() == 'hard') 31 { 32 while(textarea.rows * textarea.cols <= textarea.value.length) 33 { 34 textarea.rows = 4; //++rows; 35 } 36 } 37 */ 38 } 39 }
Note:
See TracChangeset
for help on using the changeset viewer.