Changeset 89 for db/post_read.php

Timestamp:

Sep 30, 2007, 12:28:52 PM (17 years ago)

Author:

hosiplan

Message:

Šmelím config.php takže tu možá teď proběhne pár verzí bez komentáře

File:

• db/post_read.php (modified) (6 diffs)

db/post_read.php

@@ -7 +7 @@
 if( !empty($q) AND !empty($id) ){ 
   if( !empty($lvl_d) AND !empty($lvl_h) ){ $where = "(`MinLevel`>='$lvl_d' AND `MinLevel`<='$lvl_h') AND "; };
-  $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&amp;q=".$q."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID);
+  $sql_select = SQLselect_Strankovani("SELECT * FROM quest_template WHERE ( $where`Title` LIKE '%$q%' )", $limit, 20, "?id=questy&amp;q=".$q."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID, $DB_mangos);
   if( @mysql_num_rows($sql_select[1]) > 0 ){ $i = 0; 
     $sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
@@ -18 +18 @@
       $sql_select['result'] .= "<td>";
 
-        $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']." ");
+        $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);
         while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 
           $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>";
           };
-        $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']." ");
+        $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);
         while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 
           $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>";
@@ -37 +37 @@
   } 
 elseif( !empty($quest) AND empty($id) ){ 
-  $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;");
+  $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;",$DB_mangos);
   if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 
     $result = MySQL_Fetch_Array($sql_select['sql']);
@@ -43 +43 @@
 
     // Zjištění creatur a gameobjectů kde se Quest dá vzít
-    $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']." ");
+    $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);
       if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){
         while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 
         $sql_select['other']['StartNPC'] .= "<a href=\"index.php?creature=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n";
         }; }; 
-    $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']." ");
+    $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);
       if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){
         while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ 
@@ -61 +61 @@
 
     // Důležitá věc 
-    $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;");
+    $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;",$DB_mangos);
     if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){
         $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz);
@@ -107 +107 @@
   }
 elseif( !empty($creature) AND empty($id) ){ 
-  $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;");
+  $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;",$DB_mangos);
   if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 
     $result = MySQL_Fetch_Array($sql_select['sql']);
     $sql_select['creature'] = $result;
 
-    $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 ) ");
+    $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);
       if( @mysql_num_rows($questy_dotaz_creature) > 0 ){
         while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){