- Timestamp:
- Feb 7, 2008, 5:27:54 PM (17 years ago)
- Location:
- quests
- Files:
-
- 75 added
- 12 edited
Legend:
- Unmodified
- Added
- Removed
-
quests/ListQuests.php
r250 r295 144 144 <a Title="Pøelo¾ené questy, mù¾ete zde hlasovat, nebo opravovat Quest" href="ListQuests.php?Translate">Pøelo¾ené questy</a><br><br>'; 145 145 146 WritePages('ListQuests.php?Translate', "WHERE quests.Language = '1'AND quests.Complete = '1'");146 WritePages('ListQuests.php?Translate', "WHERE quests.Language <> 0 AND quests.Complete = '1'"); 147 147 148 148 WriteQuests("SELECT *, (SELECT user.user FROM user WHERE user.id = quests.user) as User FROM 149 quests WHERE quests.Language = '1'AND quests.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');149 quests WHERE quests.Language <> 0 AND quests.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate'); 150 150 } 151 151 -
quests/TODO.txt
r263 r295 26 26 - search mono order by hotovo 27 27 - npc_text hotovo 28 - odkaz na questy v formuláøi se stejnám entry horovo 29 - quest je nepøeloen ve statistice ve formu hotovo 30 - pokyny hlasování hotovo 28 31 - Rozdìlení pomocí ras 29 32 - mení známka za nedokonèený quest … … 33 36 - jiné texty ne questy - hlavní texty 34 37 ( page_text, - prioritnì quest_end_scripts, quest_start_scripts) 35 - pokyny hlasování hotovo 36 - odkaz na questy v formuláøi se stejnám entry horovo 37 - quest je nepøeloen ve statistice ve formu hotovo 38 - vyzkouet hlasování, podmínka user jebu na to 38 -
quests/action.php
r263 r295 21 21 if ($shoutbox == '') { 22 22 echo '<form action="action.php?shoutbox=1" method="post"> 23 U µivatel: ';23 U¾ivatel: '; 24 24 if (Licence(0)) echo '<b>'.$_SESSION['User'].'</b><br />'; else echo '<input type="text" name="user"><br />'; 25 25 echo 'Text zprávy: <input type="text" name="text" size="50"> 26 <input type="submit" value="Ulo µit"><br />26 <input type="submit" value="Ulo¾it"><br /> 27 27 </form>'; 28 28 } else { … … 30 30 $user = $_POST['user']; 31 31 $Line = mysql_fetch_array($Database->SQLCommand("SELECT * FROM user WHERE user = '$user'")); 32 if ((!$Line) or ($user == '')) {} else die('Toto jméno je registrováno nemù µete psát za nìj. Pokud jste '.$user.' pak se pøihlaste.');32 if ((!$Line) or ($user == '')) {} else die('Toto jméno je registrováno nemù¾ete psát za nìj. Pokud jste '.$user.' pak se pøihlaste.'); 33 33 } 34 34 $text = $_POST['text']; 35 35 $Database->SQLCommand("INSERT INTO `shoutbox` ( `user` , `text` , `date` , `IP` ) 36 36 VALUES ( '$user', '$text', now(), '".$_SERVER['REMOTE_ADDR']."');"); 37 echo 'Zpráva vloµena!'; 37 echo 'Zpráva vlo¾ena!<br>Budete pøesmìrováni...'; 38 echo ' 39 <script type="text/javascript" language="JavaScript" charset="iso-8859-2"> 40 setTimeout("parent.location.href=\'index.php\'",1000) 41 </script>'; 42 38 43 } 39 44 } -
quests/includes/global.php
r286 r295 128 128 } 129 129 echo ' <a Title="Sestavit speciální fitr" href="page_list.php?filter">Filtr page_text ...</a><br>'; 130 echo '</div> 131 132 133 <br />'; 130 echo '</div>'; 131 132 //client rolovací menu 133 /* echo '<div id="client_menu1" style="background-color: #ffff66; margin: 5px 0px 0px 0px;" onMouseMove="show(client_menu)" onmouseout="hide(client_menu)"> 134 <a href="client_list.php?filter">client_texty</a></div> 135 136 <div id="client_menu" onMouseMove="show(client_menu)" onmouseout="hide(client_menu)" style="display: none; background-color: #ffffcc;"> 137 <a Title="Zde mù¾ete zaèít pøekládat client_texty" href="client_list.php?notran">Nepøelo¾ené client_text</a><br> 138 <a Title="Ve¹keré pøelo¾ené client_texty" href="client_list.php?Translate">Pøelo¾ené client_text</a><br> 139 '; 140 if (Licence(0)) { 141 echo ' <a Title="Nedokonèené client_texty" href="client_list.php?mydevelop">Rozepsané client_text</a><br> 142 <a Title="V¹echny client_texty, které bych mìl je¹tì oznámkovat" href="client_list.php?my">Moje client_text</a><br> 143 <a Title="client_texty, které jsem je¹tì neoznámkoval" href="client_list.php?notvote">Neznámkované client</a><br>'; 144 } 145 echo ' <a Title="Sestavit speciální fitr" href="client_list.php?filter">Filtr client_text ...</a><br>'; 146 echo '</div>'; 147 148 */ 149 150 echo '<br />'; 134 151 135 152 /* echo '<a Title="Pøelo¾ené quest, mù¾ete zde hlasovat, nebo opravovat Quest" href="ListQuests.php?Translate">Pøelo¾ené questy</a><br />'; … … 145 162 echo '<a href="priorite.php" Title="Naètení priority questù (Admin only)">Priorita</a><br />'; 146 163 echo '<a href="log.php" Title="Log dìní (Admin only)">Log</a><br>'; 147 echo '<a href="https://wow.zdechov.net/mysql/">Database</a><br>'; 164 // echo '<a href="client_files/generate_SQL.php" Title="Generování clientských souborù (Admin only)">Generování C.S.</a><br>'; 165 echo '<a href="https://wow.zdechov.net/mysql/" Title="PHP my admin (Admin only)">Database</a><br>'; 148 166 echo '<br>'; 149 167 } … … 191 209 $ID = $Database->SQLCommand("SELECT * FROM shoutbox ORDER BY ID DESC LIMIT 10"); 192 210 while ($Line = mysql_fetch_array($ID)) 193 echo '<tr><td><s mall><b>'.$Line['user'].'</b>: '.$Line['text'].'</small></td></tr>';211 echo '<tr><td><span style="font-size: 10"><b>'.$Line['user'].'</b>: '.$Line['text'].'</span></td></tr>'; 194 212 echo '</table> 195 213 -
quests/includes/global_function.php
r280 r295 64 64 array('5','Hlasování', 'yellowgreen', 'Pøihlá¹ení u¾ivatelù'), 65 65 array('6','Npc_text', 'tomato', 'Operace s NPC_texty'), 66 array('7','Page_text', 'aqua', 'Operace s page_texty'), 67 array('8','Client_text', 'black', 'Operace s clien_texty'), 66 68 ); 67 69 … … 105 107 ); 106 108 109 $client_files = array( 110 '0' => 'LocalizationStrings', 111 '1' => 'SpellBufDescription_1', 112 '2' => 'SpellDescription_1', 113 '3' => 'SpellDescription_2', 114 '4' => 'SpellDescription_3', 115 '5' => 'SpellDescription_4', 116 '6' => 'tallent', 117 ); 118 $client_text = array( 119 '0' => 'text', 120 ); 121 107 122 ?> -
quests/npc_list.php
r259 r295 120 120 <a Title="Pøelo¾ené npc_texty, mù¾ete zde hlasovat, nebo opravovat npc_texty" href="npc_list.php?Translate">Pøelo¾ené npc_texty</a><br><br>'; 121 121 122 WritePages('npc_list.php?Translate', "WHERE npc_text.Language = '1'AND npc_text.Complete = '1'");122 WritePages('npc_list.php?Translate', "WHERE npc_text.Language <> 0 AND npc_text.Complete = '1'"); 123 123 124 124 Write_npc_text("SELECT *, (SELECT user.user FROM user WHERE user.id = npc_text.user) as User FROM 125 npc_text WHERE npc_text.Language = '1'AND npc_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');125 npc_text WHERE npc_text.Language <> 0 AND npc_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate'); 126 126 } 127 127 -
quests/npc_save.php
r263 r295 55 55 echo 'Zmìny v Npc_textu: '.$entry.' ulo¾eny!<br />'; 56 56 WriteLog('Zmìny v npc_textu: '.$entry.' ulo¾eny! 57 <a href="npc_form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>', 1);57 <a href="npc_form.php?ID='.$npc_ID.'">'.$npc_ID.'</a>', 6); 58 58 $Database->SQLCommand("DELETE FROM `npc_vote` WHERE `npc_vote`.`IDnpc` = ".$npc_ID); 59 59 } -
quests/page_list.php
r280 r295 120 120 <a Title="Pøelo¾ené page_texty, mù¾ete zde hlasovat, nebo opravovat page_texty" href="page_list.php?Translate">Pøelo¾ené page_texty</a><br><br>'; 121 121 122 WritePages('page_list.php?Translate', "WHERE page_text.Language = '1'AND page_text.Complete = '1'");122 WritePages('page_list.php?Translate', "WHERE page_text.Language <> 0 AND page_text.Complete = '1'"); 123 123 124 124 Write_page_text("SELECT *, (SELECT user.user FROM user WHERE user.id = page_text.user) as User FROM 125 page_text WHERE page_text.Language = '1'AND page_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate');125 page_text WHERE page_text.Language <> 0 AND page_text.Complete = '1'", $_SESSION['limitx'].','.$_SESSION['limity'], 'Translate'); 126 126 } 127 127 -
quests/page_save.php
r280 r295 44 44 45 45 echo 'page_text: '.$entry.' ulo¾en!<br />'; 46 WriteLog('page_text: '.$entry.' ulo¾en! Pøevzat z: <a href="page_form.php?ID='.$page_ID.'">Aj page_text'.$page_ID.'</a>', 6);46 WriteLog('page_text: '.$entry.' ulo¾en! Pøevzat z: <a href="page_form.php?ID='.$page_ID.'">Aj page_text'.$page_ID.'</a>', 7); 47 47 } else { 48 48 $sql = "UPDATE page_text SET "; … … 55 55 echo 'Zmìny v page_textu: '.$entry.' ulo¾eny!<br />'; 56 56 WriteLog('Zmìny v page_textu: '.$entry.' ulo¾eny! 57 <a href="page_form.php?ID='.$page_ID.'">'.$page_ID.'</a>', 1);57 <a href="page_form.php?ID='.$page_ID.'">'.$page_ID.'</a>', 7); 58 58 $Database->SQLCommand("DELETE FROM `page_vote` WHERE `page_vote`.`IDpage` = ".$page_ID); 59 59 } -
quests/statistic.php
r293 r295 6 6 7 7 <b>Statistika:</b><br> 8 <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika pøekladu úkolù" style="margin: 5px 0px 0px 0px;"><br /> 9 <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika pøekladu NPC_textù" style="margin: 5px 0px 0px 0px;"><br /> 10 <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika pøekladu page_textù" style="margin: 5px 0px 0px 0px;"><br /> 8 <img alt="quests" src="img_statistic.php?TypeText=quests" title="statistika pøekladu úkolù" style="margin: 2px 0px 0px 0px;"><br /> 9 <img alt="npc_text" src="img_statistic.php?TypeText=npc_text" title="statistika pøekladu NPC_textù" style="margin: 2px 0px 0px 0px;"><br /> 10 <img alt="page_text" src="img_statistic.php?TypeText=page_text" title="statistika pøekladu page_textù" style="margin: 2px 0px 0px 0px;"><br /> 11 <?php // <img alt="page_text" src="img_statistic.php?TypeText=client_text" title="statistika pøekladu client_textù" style="margin: 2px 0px 0px 0px;"><br /> 12 ?> 11 13 12 14 <br> … … 36 38 37 39 echo '<tr><th><a href="statistic.php?order=user&desc='.$desc.'">Jméno</a></th> 38 <th><a href="statistic.php?order=NumberTranslate&desc='.$desc.'" Title="Poèet pøelo¾ených questù">Pøelo¾ených</a></th>39 <th><a href="statistic.php?order=Vote&desc='.$desc.'" Title="Prùmìrná známka questù">Prùmìrná známka</a></th>40 <th><a href="statistic.php?order=NumberTranslate&desc='.$desc.'" Title="Poèet pøelo¾ených textù">Pøelo¾ených</a></th> 41 <th><a href="statistic.php?order=Vote&desc='.$desc.'" Title="Prùmìrná známka textù">Prùmìrná známka</a></th> 40 42 <th><a href="statistic.php?order=GM&desc='.$desc.'">Oprávnìní</a></th> 41 43 <th><a href="statistic.php?order=LastLogin&desc='.$desc.'">Poslední pøipojení</a></th></tr>'; … … 57 59 $ID = $Database->SQLCommand(" 58 60 SELECT ID,user, LastLogin, GM, ( 59 (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1 AND Language <> 0) + 60 (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) + 61 (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) 61 (SELECT count(*) FROM `quests` WHERE User = user.ID AND Complete = 1 AND Language <> 0) 62 + (SELECT count(*) FROM `npc_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) 63 + (SELECT count(*) FROM `page_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) 64 + (SELECT count(*) FROM `client_text` WHERE User = user.ID AND Complete = 1 AND Language <> 0) 62 65 ) as NumberTranslate, ( 63 66 IFNULL((SELECT sum(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0),0) 64 67 + IFNULL((SELECT sum(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0) 65 68 + IFNULL((SELECT sum(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0) 69 + IFNULL((SELECT sum(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0),0) 66 70 ) / ( 67 71 (SELECT count(Vote) AS Vote FROM `quests` WHERE User = user.ID AND Complete =1 AND Language <> 0) 68 72 + (SELECT count(Vote) AS Vote FROM `page_text` WHERE User = user.ID AND Complete =1 AND Language <> 0) 69 73 + (SELECT count(Vote) AS Vote FROM `npc_text` WHERE User = user.ID AND Complete =1 AND Language <> 0) 74 + (SELECT count(Vote) AS Vote FROM `client_text` WHERE User = user.ID AND Complete =1 AND Language <> 0) 70 75 ) AS Vote 71 76 FROM `user` ORDER BY $order $desc"); -
quests/structure/npc_vote.sql
r251 r295 10 10 PRIMARY KEY (`ID`), 11 11 KEY `IDuser` (`IDuser`), 12 KEY `ID quest` (`IDnpc`)12 KEY `IDnpc` (`IDnpc`) 13 13 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=85 ; 14 14 -
quests/structure/page_vote.sql
r280 r295 11 11 PRIMARY KEY (`ID`), 12 12 KEY `IDuser` (`IDpage`), 13 KEY `ID quest` (`IDpage`)13 KEY `IDpage` (`IDpage`) 14 14 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=88 ;
Note:
See TracChangeset
for help on using the changeset viewer.