Changeset 92 for db/post_read.php
- Timestamp:
- Sep 30, 2007, 6:34:12 PM (17 years ago)
- Location:
- db
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
db
-
Property svn:ignore
set to
config.php
-
Property svn:ignore
set to
-
db/post_read.php
r89 r92 7 7 if( !empty($q) AND !empty($id) ){ 8 8 if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; }; 9 $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&q=".$q."&lvl_d=".$lvl_d."&lvl_h=".$lvl_h, $SID , $DB_mangos);9 $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&q=".$q."&lvl_d=".$lvl_d."&lvl_h=".$lvl_h, $SID); 10 10 if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 11 11 $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n"; … … 18 18 $sql_select['result'] .= "<td>"; 19 19 20 $startovni_creature_dotaz = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$result['entry']." " ,$DB_mangos);20 $startovni_creature_dotaz = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$result['entry']." "); 21 21 while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 22 22 $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>"; 23 23 }; 24 $startovni_gameobject_dotaz = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$result['entry']." " ,$DB_mangos);24 $startovni_gameobject_dotaz = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$result['entry']." "); 25 25 while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 26 26 $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>"; … … 33 33 34 34 $sql_select['result'] .= "</table>\n"; 35 } ;35 } else{ $sql_select['error'] = "<p>Nebyly nalezeny žádné questy.</p>"; }; 36 36 37 37 } 38 38 elseif( !empty($quest) AND empty($id) ){ 39 $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;" ,$DB_mangos);39 $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;"); 40 40 if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 41 41 $result = MySQL_Fetch_Array($sql_select['sql']); … … 43 43 44 44 // Zjištění creatur a gameobjectů kde se Quest dá vzít 45 $startovni_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$sql_select['quest']['entry']." " ,$DB_mangos);45 $startovni_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$sql_select['quest']['entry']." "); 46 46 if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){ 47 47 while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 48 48 $sql_select['other']['StartNPC'] .= "<a href=\"index.php?creature=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n"; 49 49 }; }; 50 $startovni_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$sql_select['quest']['entry']." " ,$DB_mangos);50 $startovni_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$sql_select['quest']['entry']." "); 51 51 if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){ 52 52 while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ … … 54 54 }; }; 55 55 if( empty($sql_select['other']['StartNPC']) ){ 56 $sql_select['other']['StartNPC'] = "<b>Úkol není kde začít!< br> Nahlaste to prosím adminovy!</b>"; }56 $sql_select['other']['StartNPC'] = "<b>Úkol není kde začít!</b>"; } 57 57 58 58 // Zjištění Oblasti … … 61 61 62 62 // Důležitá věc 63 $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;" ,$DB_mangos);63 $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;"); 64 64 if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){ 65 65 $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz); … … 107 107 } 108 108 elseif( !empty($creature) AND empty($id) ){ 109 $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;" ,$DB_mangos);109 $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;"); 110 110 if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 111 111 $result = MySQL_Fetch_Array($sql_select['sql']); 112 112 $sql_select['creature'] = $result; 113 113 114 $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$sql_select['creature']['entry']." AND `quest_template`.`PrevQuestId`=0 ) " ,$DB_mangos);114 $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$sql_select['creature']['entry']." AND `quest_template`.`PrevQuestId`=0 ) "); 115 115 if( @mysql_num_rows($questy_dotaz_creature) > 0 ){ 116 116 while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){ … … 119 119 120 120 } else{ $sql_select['error'] = "<p>Creep nebyl nalezen.</p>"; }; 121 122 } 123 elseif( $id == "bugreport" AND empty($bug) ){ 124 $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']); 125 if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; 126 127 $sql_select = SQLselect_Strankovani("SELECT * FROM `bug_report` ORDER BY `opraveno` ASC, `vlozeno` DESC", $limit, 20, "?id=bugreport", $SID); 128 if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 129 $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n"; 130 $sql_select['result'] .= "<thead><tr><td>Vloženo</td><td>Chyba</td><td align='right'>Status</td></tr></thead>\n<col width=\"120px\"><col><col width=\"60px\">"; 131 132 while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 133 $sql_select['result'] .= "<tr><td valign='top'>"; 134 $sql_select['result'] .= "<a href=\"./index.php?id=bugreport&bug=".$result['id']."\">".@date("d.m.Y H:i", $result['vlozeno'])."</a>"; 135 $sql_select['result'] .= "</td><td valign='top'>"; 136 $sql_select['result'] .= nl2br(htmlentities($result['popis'])); 137 $sql_select['result'] .= "</td><td valign='top' align='right'>"; 138 if( $result['opraveno'] == 0 ){ 139 $sql_select['result'] .= "<img src=\"img/aff_cross.gif\" alt=\"ne\" height=\"16\" width=\"16\">"; } 140 elseif( $result['opraveno'] == 1 ){ 141 $sql_select['result'] .= "<img src=\"img/aff_tick.gif\" alt=\"ne\" height=\"16\" width=\"16\">"; } 142 $sql_select['result'] .= "</td></tr>\n"; 143 }; 144 145 $sql_select['result'] .= "</table>\n"; 146 147 } else{ $sql_select['error'] .= "<p>V databázi nejsou záznamy o chybách.</p>"; }; 148 149 } 150 elseif( $id == "bugreport" AND !empty($bug) ){ 151 $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']); 152 if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; 153 154 $sql_select['sql'] = mysql_query("SELECT * FROM `bug_report` WHERE id=$bug LIMIT 1"); 155 if( @mysql_num_rows($sql_select['sql']) > 0 ){ 156 $result = MySQL_Fetch_Array($sql_select['sql']); 157 $sql_select['bug'] = $result; 158 if( empty($sql_select['bug']['opravil_nick']) ){ 159 $sql_select['bug']['opravil_nick'] = "Zatím nikdo"; }; 160 if( $sql_select['bug']['opraveno'] == 0 ){ 161 $sql_select['bug']['opraveno'] = "<img src=\"img/aff_cross.gif\" alt=\"ne\" height=\"16\" width=\"16\"> Čeká na vyřízení"; } 162 elseif( $sql_select['bug']['opraveno'] == 1 ){ 163 $sql_select['bug']['opraveno'] = "<img src=\"img/aff_tick.gif\" alt=\"ne\" height=\"16\" width=\"16\"> Opraveno"; } 164 } else{ $sql_select['error'] = "<p>V databázi není záznam s touto chybou.</p>"; }; 165 166 } 167 elseif( $id == "sendbug" ANd isset($_POST['send']) ){ 168 $DB_web = mysql_select_db($Config['DB_read']['DB_read']['Database_web']); 169 if( !$DB_web ){ DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>"); }; 170 171 $sql_insert['sql'] = "INSERT INTO `bug_report` (`nick`,`typ`,`vlozeno`,`popis`) VALUES('".$_POST['game_nick']."','".$_POST['err_type']."','".time()."','".$_POST['popis']."')"; 172 if( mysql_query($sql_insert['sql']) ){ 173 $sql_insert['result'] = "<p>Bug byl uložen do databáze.</p>"; 174 } 175 else{ $sql_insert['result'] = "<p>Bug se nepodařilo uložit do databáze.<br>Zkuste to později znovu prosím.</p>"; }; 121 176 122 177 };
Note:
See TracChangeset
for help on using the changeset viewer.