Changeset 82 for db/post_read.php

Timestamp:

Sep 29, 2007, 8:25:17 PM (17 years ago)

Author:

hosiplan

Message:

úprava návodu na event na šplhání
A taky bylo zase něco málo vylepšeno a přidáno v prohlížeči databáze

File:

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

db/post_read.php

@@ -5 +5 @@
 <?php
 
-if(array_key_exists('quest', $_GET) AND !empty($id) ){ 
+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 '%$quest%' )", $limit, 20, "?id=questy&amp;quest=".$quest."&amp;lvl_d=".$lvl_d."&amp;lvl_h=".$lvl_h, $SID);
-  if( @mysql_num_rows($sql_select[1]) > "0" ) { $i = "0";
+  $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);
+  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";
     $sql_select['result'] .= "<thead><tr><td>Název úkolu</td><td>Min level</td><td>Úkol zadává</td><td>Úkol</td></tr></thead>\n<col width=\"180px\"><col width=\"70px\">";
 
-    while( $result = @MySQL_Fetch_Array($sql_select[1]) ){ 
+    while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 
       $sql_select['result'] .= "  <tr valign='top'>";
       $sql_select['result'] .= "<td><a href=\"index.php?quest=".$result['entry']."\">".$result['Title']."</a></td>";
@@ -35 +35 @@
     };
   
-  }; 
+  } 
+elseif( !empty($quest) AND empty($id) ){ 
+  $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='$quest' LIMIT 1;");
+  if( @mysql_num_rows($sql_select['sql']) > 0 ){ $i = 0; 
+    $result = MySQL_Fetch_Array($sql_select['sql']);
+    $sql_select['quest'] = $result;
+
+    // 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']." ");
+      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']." ");
+      if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){
+        while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ 
+        $sql_select['other']['StartNPC'] .= "<a href=\"index.php?gameobject=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n";
+        }; }; 
+    if( empty($sql_select['other']['StartNPC']) ){ 
+      $sql_select['other']['StartNPC'] = "<b>Úkol není kde začít!<br> Nahlaste to prosím adminovy!</b>"; }
+
+    // Zjištění Oblasti
+    if( AbsCheck($sql_select['quest']['ZoneOrSort']) ){ }
+    else{  };
+
+    // Důležitá věc 
+    $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$sql_select['quest']['SrcItemId']." LIMIT 1;");
+    if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){
+        $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz);
+        $sql_select['other']['SrcItemId'] .= "<a href=\"index.php?item=".$SrcItemId['entry']."\">".$SrcItemId['name']."</a><br>\n";
+        };
+
+      $sql_select['quest']['PrevQuestId'];
+      $sql_select['quest']['NextQuestId'];
+
+      $sql_select['other']['ReqItems']; // ReqItemId1-4.ReqItemCount1-4
+
+      $sql_select['other']['ReqSource']; // ??
+/*        ReqSourceId1-4 
+      These fields are used in core quest-drop logic. They allow players to get quest drops which are not quest delivery items (ReqItem stand for this), but needed to create quest delivery by player or needed to cast ReqSpellCasts. ReqSourceId1 is the item_template id of a source item for creation of ReqItemX or casting of ReqSpellCastX. X is the value of ReqSourceRef1. Only items which have a quest drop chance (having QuestChance > 0 in *_loot_template) should be used as sources here.
+      The same for ReqSourceId2-4
+      You may define 1, 2, 3 or even all 4 sources for the same ReqItem/ReqSpellCast or use 4 sources for 4 ReqItems/ReqSpellCasts.
+          ReqSourceCount1-4 
+      Amount of ReqSourceId items the player may gather per unfinished ReqItemId or ReqSpellCast.
+      So ReqSourceId1 items will drop up to a total amount of (ReqItemCount(ReqSourceRef1) - already owned ReqItemId(ReqSourceRef1)) * ReqSourceCount1. Same for ReqSpellCast objectives.
+          ReqSourceRef1-4 
+      Should be 0 or 1..4. See ReqSourceId description. */
+
+      $sql_select['other']['ReqCreatureOrGOId']; // need to kill/cast
+/*    Value > 0: 1.-4. required creature_template ID the player needs to kill/cast on in order to complete the quest.
+      Value < 0: 1.-4. required gameobject_template ID the player needs to cast on in order to complete the quest.
+      If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. */
+
+      $sql_select['other']['ReqSpellCast']; 
+/*    Spell ID of Spell that needs to be cast in order to fulfill a quest objective.
+      If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. */
+
+      $sql_select['other']['ReqSpellCast']; 
+/*    Spell ID of Spell that needs to be cast in order to fulfill a quest objective.
+      If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed. */
+
+      $sql_select['other']['RewChoiceItemId']; // !!! RewChoiceItemCount
+/*    Id of the 1.-6. Item available for reward choice.  */
+      
+      $sql_select['other']['RewItemId']; // !!! RewItemCount
+/*    1.-4. item Id given for reward (no choice).   */
+      
+
+    } else{ $sql_select['error'] = "<p>Quest nebyl nalezen.</p>"; };
+  
+  }
+elseif( !empty($creature) AND empty($id) ){ 
+  $sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='$creature' LIMIT 1;");
+  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 ) ");
+      if( @mysql_num_rows($questy_dotaz_creature) > 0 ){
+        while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){ 
+          $sql_select['other']['creature_quests'] .= "<a href=\"index.php?quest=".$quest_NPC['entry']."\">".$quest_NPC['Title']."</a><br>\n";
+        }; }; 
+
+    } else{ $sql_select['error'] = "<p>Creep nebyl nalezen.</p>"; };
+  
+  };
+
 
 ?>