Changeset 114 for db

Timestamp:

Oct 27, 2007, 10:36:03 PM (17 years ago)

Author:

hosiplan

Message:

+ chyba ve vyhledávání, opravil jsem ji

Location:

db

Files:

• include/quest.php (modified) (2 diffs)
• post_read.php (modified) (4 diffs)

db/include/quest.php

@@ -20 +20 @@
 <?php if( !empty($sql_select['other']['SrcItemId']) ){ ?>
       <tr><td>Důležitá věc:</td></tr>
-      <tr><td style="padding-left:20px;"><?php echo $sql_select['quest']['SrcItemCount']."x ".$sql_select['other']['SrcItemId']; ?></td></tr>
+      <tr><td style="padding-left:10px;"><?php echo $sql_select['quest']['SrcItemCount']."x ".$sql_select['other']['SrcItemId']; ?></td></tr>
 <?php }; ?>
 
@@ -34 +34 @@
 <?php if( !empty($sql_select['other']['ReqItems']) ){ ?>
       <tr><td>Věci vyžadované pro splnění:</td></tr>
-      <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['ReqItems']; ?></td></tr>
+      <tr><td style="padding-left:10px;"><?php echo $sql_select['other']['ReqItems']; ?></td></tr>
 <?php }; if( !empty($sql_select['other']['ReqSource']) ){ ?>
       <tr><td>Unknown:</td></tr>
-      <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['ReqSource']; ?></td></tr>
+      <tr><td style="padding-left:10px;"><?php echo $sql_select['other']['ReqSource']; ?></td></tr>
 <?php }; if( !empty($sql_select['other']['ReqCreatureOrGOId']) ){ ?>
       <tr><td>Věci vyžadované pro splnění:</td></tr>
-      <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['ReqCreatureOrGOId']; ?></td></tr>
+      <tr><td style="padding-left:10px;"><?php echo $sql_select['other']['ReqCreatureOrGOId']; ?></td></tr>
 <?php }; ?>
     </table></td><td width="70%" style="padding-bottom:20px;"><table width="100%" border="0" cellspacing="0" cellpadding="0">

db/post_read.php

@@ -98 +98 @@
           };
 
-        $this->sql_select = SQLselect_Strankovani("SELECT * FROM `quest_template` WHERE ( $where`Title` LIKE '%$q%' ) ORDER BY `entry` ASC", $this->limit, $this->nastranu, "?id=questy&q=".$this->q."&lvl_d=".$this->lvl_d."&lvl_h=".$this->lvl_h, $this->sid);
+        $this->sql_select = SQLselect_Strankovani("SELECT * FROM `quest_template` WHERE ( $where`Title` LIKE '%".$this->q."%' ) ORDER BY `entry` ASC", $this->limit, $this->nastranu, "?id=questy&q=".$this->q."&lvl_d=".$this->lvl_d."&lvl_h=".$this->lvl_h, $this->sid);
         if( @mysql_num_rows($this->sql_select[1]) > 0 ){ 
           $this->sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" cellspacing=\"0\" cellpadding=\"0\">\n";
@@ -117 +117 @@
                 $this->sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>";
                 };
+              $startovni_dotaz_item = mysql_query("SELECT * FROM item_template WHERE startquest='".$result['entry']."' ");
+                if( @mysql_num_rows($startovni_dotaz_item) > 0 ){ 
+                  while($start_item = @MySQL_Fetch_Array($startovni_dotaz_item)){ 
+                  switch($start_item['Quality']){ 
+                    case 0: $sql_select['other']['item_color'] = "class=\"graylink\""; break;
+                    case 1: $sql_select['other']['item_color'] = "class=\"whitelink\""; break;
+                    case 2: $sql_select['other']['item_color'] = "class=\"greenlink\""; break;
+                    case 3: $sql_select['other']['item_color'] = "class=\"bluelink\""; break;
+                    case 4: $sql_select['other']['item_color'] = "class=\"purplelink\""; break;
+                    case 5: $sql_select['other']['item_color'] = "class=\"orangelink\""; break;
+                    case 6: $sql_select['other']['item_color'] = "class=\"redlink\""; break;
+                    }; 
+                  $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?item=".$start_item['entry']."\"".$sql_select['other']['item_color'].">".$start_item['name']."</a><br>\n";
+                  }; }; 
 
             $this->sql_select['result'] .= "</td>";
@@ -202 +216 @@
               while($start_NPC = @MySQL_Fetch_Array($startovni_dotaz_item)){ 
               switch($start_NPC['Quality']){ 
-                case 0: $sql_select['other']['item_color'] = "class=\"graylink\""; break;
-                case 1: $sql_select['other']['item_color'] = "class=\"whitelink\""; break;
-                case 2: $sql_select['other']['item_color'] = "class=\"greenlink\""; break;
-                case 3: $sql_select['other']['item_color'] = "class=\"bluelink\""; break;
-                case 4: $sql_select['other']['item_color'] = "class=\"purplelink\""; break;
-                case 5: $sql_select['other']['item_color'] = "class=\"orangelink\""; break;
-                case 6: $sql_select['other']['item_color'] = "class=\"redlink\""; break;
+                case 0: $item_color = "class=\"graylink\""; break;
+                case 1: $item_color = "class=\"whitelink\""; break;
+                case 2: $item_color = "class=\"greenlink\""; break;
+                case 3: $item_color = "class=\"bluelink\""; break;
+                case 4: $item_color = "class=\"purplelink\""; break;
+                case 5: $item_color = "class=\"orangelink\""; break;
+                case 6: $item_color = "class=\"redlink\""; break;
                 }; 
-              $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?item=".$start_NPC['entry']."\"".$sql_select['other']['item_color'].">".$start_NPC['name']."</a><br>\n";
+              $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?item=".$start_NPC['entry']."\"".$item_color.">".$start_NPC['name']."</a><br>\n";
               }; }; 
           if( empty($this->sql_select['other']['StartNPC']) ){ 
@@ -236 +250 @@
           if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){
               $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz);
-              $this->sql_select['other']['SrcItemId'] .= "<a href=\"index.php?item=".$SrcItemId['entry']."\">".$SrcItemId['name']."</a><br>\n";
+              switch($SrcItemId['Quality']){ 
+                case 0: $item_color = "class=\"graylink\""; break;
+                case 1: $item_color = "class=\"whitelink\""; break;
+                case 2: $item_color = "class=\"greenlink\""; break;
+                case 3: $item_color = "class=\"bluelink\""; break;
+                case 4: $item_color = "class=\"purplelink\""; break;
+                case 5: $item_color = "class=\"orangelink\""; break;
+                case 6: $item_color = "class=\"redlink\""; break;
+                }; 
+              $this->sql_select['other']['SrcItemId'] .= "<a href=\"index.php?item=".$SrcItemId['entry']."\"".$item_color.">".$SrcItemId['name']."</a><br>\n";
               };