Changeset 118 for db/post_read.php

Timestamp:

Nov 4, 2007, 5:38:25 PM (17 years ago)

Author:

hosiplan

Message:

Už ani pořádně nevím :D
+ eventy
+ Návody (zatím bez administarce)
+ Vylepšní přihlášení
+ Malá změna struktuty (stránka hlavni.php nyní obsahuje stránku obsah.php kvůli změnám do budoucna)

Location:

db

Files:

• . (modified) (1 prop)
• post_read.php (modified) (18 diffs)

db

@@ -1 +1 @@
 config.php
+navrh

@@ -1 +1 @@
 config.php
+navrh

db/post_read.php

@@ -1 +1 @@
 <?php
-if($vlozeni_souboru == "OK"){ 
+if (!defined('IN_CODE')){ exit; };
 
   class BasicWiewer{
@@ -6 +6 @@
     var $id; // současná stránka
     var $limit; // současná stránka
+    var $kategorie; // kategorie z nabídky
     var $nastranu = 20; // počet výsledků hledání které budou vypsány
     var $sql_select; // proměnná obsahující všechny výsledky pro výpis
@@ -11 +12 @@
 
     // konkrétní proměnné podle toho s čím pracujme 
-    var $quest; // GUID Questu
     var $lvl_d; // min. lvl u Questu
     var $lvl_h; // max. lvl u Questu
+    var $quest; // GUID Questu
     var $bug; // GUID Bugu
     var $creature; // GUID Creepa
@@ -42 +43 @@
       } 
 
+    public function searchItem($q,$limit,$nastranu){ 
+      $this->q = $q;
+      $this->limit = $limit;
+      $this->nastranu = $nastranu;
+      $this->searchItems(); // vykonáme hledání
+      return $this->sql_select;
+      } 
+
     public function quest($quest){ 
       $this->quest = $quest;
@@ -73 +82 @@
     public function item($item){ 
       $this->item = $item;
-      # need to complete !!!
+      $this->showItem(); // získání dat o Itemu
       return $this->sql_select;
       } 
@@ -82 +91 @@
       } 
 
+    public function guids($kategorie,$guid,$str){ 
+      $this->kategorie = $kategorie;
+      $this->guid = $guid;
+      $this->str = $str;
+      $this->showGuids(); // získání dat o užvatelově účtu
+      return $this->sql_select;
+      } 
+
   /* ==================================================
    * searchQuests()
-   * 
-   * Tato funkce vyhledává 
-   * v databázi questy
+   * showQuest()
+   * startQuest($x)   
+   * 
+   * Tato funkce vrací konkrétní Quest
+   * + provádí pár dalších operací s jeho daty
    * 
   ================================================== */
@@ -105 +124 @@
           while( $result = MySQL_Fetch_Array($this->sql_select[1]) ){ 
             $this->sql_select['result'] .= "  <tr valign='top'>";
-            $this->sql_select['result'] .= "<td><a href=\"index.php?quest=".$result['entry']."\">".$result['Title']."</a></td>";
+            $this->sql_select['result'] .= "<td><a href=\"index.php?quest=".$result['entry'].$this->sid."\">".$result['Title']."</a></td>";
             $this->sql_select['result'] .= "<td>".$result['MinLevel']."</td>";
-            $this->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']." ");
-              while( $start_creature = @MySQL_Fetch_Array($startovni_creature_dotaz) ){ 
-                $this->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']." ");
-              while( $start_gameobject = @MySQL_Fetch_Array($startovni_gameobject_dotaz) ){ 
-                $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>";
+            $this->sql_select['result'] .= "<td>".$this->startQuest($result['entry'])."</td>";
             $this->sql_select['result'] .= "<td>".$result['Objectives']."</td>";
             $this->sql_select['result'] .= "</tr>\n";
@@ -148 +142 @@
       }
 
+    function showQuest(){ 
+
+      if( is_numeric($this->quest) AND empty($this->id) ){ 
+
+        $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='".$this->quest."' LIMIT 1");
+        if( @mysql_num_rows($sql_select['sql']) > 0 ){ 
+          $this->sql_select['quest'] = MySQL_Fetch_Array($sql_select['sql']);
+
+          // 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 =".$this->sql_select['quest']['entry']." ");
+            if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){
+              while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 
+              $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?creature=".$start_NPC['entry'].$this->sid."\">".$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 =".$this->sql_select['quest']['entry']." ");
+            if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){
+              while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ 
+              $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?gameobject=".$start_NPC['entry'].$this->sid."\">".$start_NPC['name']."</a><br>\n";
+              }; }; 
+          $startovni_dotaz_item = mysql_query("SELECT * FROM item_template WHERE startquest='".$this->sql_select['quest']['entry']."' ");
+            if( @mysql_num_rows($startovni_dotaz_item) > 0 ){ 
+              while($start_NPC = @MySQL_Fetch_Array($startovni_dotaz_item)){ 
+              $item_color = $this->itemQuality($start_NPC['Quality'],1);
+              $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?item=".$start_NPC['entry'].$this->sid."\"".$item_color.">".$start_NPC['name']."</a><br>\n";
+              }; }; 
+          if( empty($this->sql_select['other']['StartNPC']) ){ 
+            $this->sql_select['other']['EndNPC'] = "<b>Úkol není kde začít!</b>"; };
+
+          $ukoncovaci_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_involvedrelation ON creature_involvedrelation.id = creature_template.entry WHERE creature_involvedrelation.quest =".$this->sql_select['quest']['entry']." ");
+            if( @mysql_num_rows($ukoncovaci_NPC_dotaz_creature) > 0 ){
+              while($end_NPC = @MySQL_Fetch_Array($ukoncovaci_NPC_dotaz_creature)){ 
+              $this->sql_select['other']['EndNPC'] .= "<a href=\"index.php?creature=".$end_NPC['entry'].$this->sid."\">".$end_NPC['name']."</a><br>\n";
+              }; }; 
+          $ukoncovaci_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_involvedrelation ON gameobject_involvedrelation.id = gameobject_template.entry WHERE gameobject_involvedrelation.quest =".$this->sql_select['quest']['entry']." ");
+            if( @mysql_num_rows($ukoncovaci_NPC_dotaz_gameobject) > 0 ){
+              while($end_NPC = @MySQL_Fetch_Array($ukoncovaci_NPC_dotaz_gameobject)){ 
+              $this->sql_select['other']['EndNPC'] .= "<a href=\"index.php?gameobject=".$end_NPC['entry'].$this->sid."\">".$end_NPC['name']."</a><br>\n";
+              }; }; 
+          if( empty($this->sql_select['other']['EndNPC']) ){ 
+            $this->sql_select['other']['EndNPC'] = "<b>Úkol není kde skončit!</b>"; };
+
+          // Zjištění Oblasti
+          if( AbsCheck($this->sql_select['quest']['ZoneOrSort']) ){  }
+          else{  };
+
+          // Důležitá věc 
+          $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$this->sql_select['quest']['SrcItemId']." LIMIT 1;");
+          if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){
+              $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz);
+              $item_color = $this->itemQuality($SrcItemId['Quality'],1);
+              $this->sql_select['other']['SrcItemId'] .= "<a href=\"index.php?item=".$SrcItemId['entry'].$this->sid."\"".$item_color.">".$SrcItemId['name']."</a><br>\n";
+              };
+
+            $this->sql_select['quest']['PrevQuestId'];
+            $this->sql_select['quest']['NextQuestId'];
+      
+            $this->sql_select['other']['ReqItems']; // ReqItemId1-4.ReqItemCount1-4
+      
+            $this->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. */
+      
+            $this->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. */
+      
+            $this->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. */
+      
+            $this->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. */
+      
+            $this->sql_select['other']['RewChoiceItemId']; // !!! RewChoiceItemCount
+      /*    Id of the 1.-6. Item available for reward choice.  */
+            
+            $this->sql_select['other']['RewItemId']; // !!! RewItemCount
+      /*    1.-4. item Id given for reward (no choice).   */
+            
+  
+          } 
+        else{ 
+          $this->sql_select['error'] = "<p>Quest nebyl nalezen.</p>"; 
+          };
+        return true;
+        };
+
+      return false;
+      }
+    
+    function startQuest($x){
+      $startovni_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_questrelation ON creature_questrelation.id = creature_template.entry WHERE creature_questrelation.quest =".$x." LIMIT 10 ");
+        if( @mysql_num_rows($startovni_dotaz_creature) > 0 ){
+          while($start_NPC = @MySQL_Fetch_Array($startovni_dotaz_creature)){ 
+          $startNPC .= "<a href=\"index.php?creature=".$start_NPC['entry'].$this->sid."\">".$start_NPC['name']."</a><br>\n";
+          }; }; 
+      $startovni_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_questrelation ON gameobject_questrelation.id = gameobject_template.entry WHERE gameobject_questrelation.quest =".$x." LIMIT 10 ");
+        if( @mysql_num_rows($startovni_dotaz_gameobject) > 0 ){
+          while($start_NPC = @MySQL_Fetch_Array($startovni_dotaz_gameobject)){ 
+          $startGO .= "<a href=\"index.php?gameobject=".$start_NPC['entry'].$this->sid."\">".$start_NPC['name']."</a><br>\n";
+          }; }; 
+      $startovni_dotaz_item = mysql_query("SELECT * FROM item_template WHERE startquest='".$x."' LIMIT 10 ");
+        if( @mysql_num_rows($startovni_dotaz_item) > 0 ){ 
+          while($start_NPC = @MySQL_Fetch_Array($startovni_dotaz_item)){ 
+          $item_color = $this->itemQuality($start_NPC['Quality'],1);
+          $startI .= "<a href=\"index.php?item=".$start_NPC['entry'].$this->sid."\"".$item_color.">".$start_NPC['name']."</a><br>\n";
+          }; }; 
+      $StartQuest = $startNPC.$startGO.$startI;
+      if( empty($StartQuest) ){ $StartQuest = "<b>Úkol není kde začít!</b>"; };
+      return $StartQuest;
+      }
+
   /* ==================================================
    * searchCreeps()
-   * 
-   * Tato funkce vyhledává 
-   * v databázi creepy
+   * showCreature()
+   * 
+   * Tato funkce vrací konkrétního Creepa
+   * + provádí pár dalších operací s jeho daty
    * 
   ================================================== */
@@ -167 +283 @@
             while( $result = MySQL_Fetch_Array($this->sql_select[1]) ){ 
               $this->sql_select['result'] .= "  <tr valign='top'>";
-              $this->sql_select['result'] .= "<td><a href=\"index.php?creature=".$result['entry']."\">".$result['name']."</a></td>";
+              $this->sql_select['result'] .= "<td><a href=\"index.php?creature=".$result['entry'].$this->sid."\">".$result['name']."</a></td>";
               if( $result['rank'] != 3 ){
                 $this->sql_select['result'] .= "<td align='center'>".$result['minlevel']." - ".$result['maxlevel']."</td>";
@@ -184 +300 @@
       return false;
       }
-
-  /* ==================================================
-   * showQuest()
-   * 
-   * Tato funkce vrací konkrétní Quest
-   * + provádí pár dalších operací s jeho daty
-   * 
-  ================================================== */
-
-    function showQuest(){ 
-
-      if( is_numeric($this->quest) AND empty($this->id) ){ 
-
-        $sql_select['sql'] = mysql_query("SELECT * FROM quest_template WHERE `entry`='".$this->quest."' LIMIT 1");
-        if( @mysql_num_rows($sql_select['sql']) > 0 ){ 
-          $this->sql_select['quest'] = MySQL_Fetch_Array($sql_select['sql']);
-
-          // 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 =".$this->sql_select['quest']['entry']." ");
-            if( @mysql_num_rows($startovni_NPC_dotaz_creature) > 0 ){
-              while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_creature)){ 
-              $this->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 =".$this->sql_select['quest']['entry']." ");
-            if( @mysql_num_rows($startovni_NPC_dotaz_gameobject) > 0 ){
-              while($start_NPC = @MySQL_Fetch_Array($startovni_NPC_dotaz_gameobject)){ 
-              $this->sql_select['other']['StartNPC'] .= "<a href=\"index.php?gameobject=".$start_NPC['entry']."\">".$start_NPC['name']."</a><br>\n";
-              }; }; 
-          $startovni_dotaz_item = mysql_query("SELECT * FROM item_template WHERE startquest='".$this->sql_select['quest']['entry']."' ");
-            if( @mysql_num_rows($startovni_dotaz_item) > 0 ){ 
-              while($start_NPC = @MySQL_Fetch_Array($startovni_dotaz_item)){ 
-              switch($start_NPC['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']['StartNPC'] .= "<a href=\"index.php?item=".$start_NPC['entry']."\"".$item_color.">".$start_NPC['name']."</a><br>\n";
-              }; }; 
-          if( empty($this->sql_select['other']['StartNPC']) ){ 
-            $this->sql_select['other']['EndNPC'] = "<b>Úkol není kde začít!</b>"; };
-
-          $ukoncovaci_NPC_dotaz_creature = mysql_query("SELECT * FROM creature_template LEFT JOIN creature_involvedrelation ON creature_involvedrelation.id = creature_template.entry WHERE creature_involvedrelation.quest =".$this->sql_select['quest']['entry']." ");
-            if( @mysql_num_rows($ukoncovaci_NPC_dotaz_creature) > 0 ){
-              while($end_NPC = @MySQL_Fetch_Array($ukoncovaci_NPC_dotaz_creature)){ 
-              $this->sql_select['other']['EndNPC'] .= "<a href=\"index.php?creature=".$end_NPC['entry']."\">".$end_NPC['name']."</a><br>\n";
-              }; }; 
-          $ukoncovaci_NPC_dotaz_gameobject = mysql_query("SELECT * FROM gameobject_template LEFT JOIN gameobject_involvedrelation ON gameobject_involvedrelation.id = gameobject_template.entry WHERE gameobject_involvedrelation.quest =".$this->sql_select['quest']['entry']." ");
-            if( @mysql_num_rows($ukoncovaci_NPC_dotaz_gameobject) > 0 ){
-              while($end_NPC = @MySQL_Fetch_Array($ukoncovaci_NPC_dotaz_gameobject)){ 
-              $this->sql_select['other']['EndNPC'] .= "<a href=\"index.php?gameobject=".$end_NPC['entry']."\">".$end_NPC['name']."</a><br>\n";
-              }; }; 
-          if( empty($this->sql_select['other']['EndNPC']) ){ 
-            $this->sql_select['other']['EndNPC'] = "<b>Úkol není kde skončit!</b>"; };
-
-          // Zjištění Oblasti
-          if( AbsCheck($this->sql_select['quest']['ZoneOrSort']) ){  }
-          else{  };
-
-          // Důležitá věc 
-          $SrcItemId_dotaz = mysql_query("SELECT * FROM item_template WHERE entry =".$this->sql_select['quest']['SrcItemId']." LIMIT 1;");
-          if( @mysql_num_rows($SrcItemId_dotaz) > 0 ){
-              $SrcItemId = @MySQL_Fetch_Array($SrcItemId_dotaz);
-              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";
-              };
-
-            $this->sql_select['quest']['PrevQuestId'];
-            $this->sql_select['quest']['NextQuestId'];
-      
-            $this->sql_select['other']['ReqItems']; // ReqItemId1-4.ReqItemCount1-4
-      
-            $this->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. */
-      
-            $this->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. */
-      
-            $this->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. */
-      
-            $this->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. */
-      
-            $this->sql_select['other']['RewChoiceItemId']; // !!! RewChoiceItemCount
-      /*    Id of the 1.-6. Item available for reward choice.  */
-            
-            $this->sql_select['other']['RewItemId']; // !!! RewItemCount
-      /*    1.-4. item Id given for reward (no choice).   */
-            
-  
-          } 
-        else{ 
-          $this->sql_select['error'] = "<p>Quest nebyl nalezen.</p>"; 
-          };
-        return true;
-        };
-
-      return false;
-      }
-
-  /* ==================================================
-   * showCreature()
-   * 
-   * Tato funkce vrací konkrétního Creepa
-   * + provádí pár dalších operací s jeho daty
-   * 
-  ================================================== */
 
     function showCreature(){ 
@@ -334 +319 @@
             if( @mysql_num_rows($questy_dotaz_creature) > 0 ){
               while($quest_NPC = @MySQL_Fetch_Array($questy_dotaz_creature)){ 
-                $this->sql_select['other']['creature_quests'] .= "<a href=\"index.php?quest=".$quest_NPC['entry']."\">".$quest_NPC['Title']."</a><br>\n";
+                $this->sql_select['other']['creature_quests'] .= "<a href=\"index.php?quest=".$quest_NPC['entry'].$this->sid."\">".$quest_NPC['Title']."</a><br>\n";
               }; }; 
       
@@ -340 +325 @@
             if( @mysql_num_rows($drop_creature) > 0 ){ 
               while($drop_NPC = @MySQL_Fetch_Array($drop_creature)){ 
-                switch($drop_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;
-                  }; 
-                $this->sql_select['other']['creature_drop'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry']."\" ".$sql_select['other']['item_color'].">".$drop_NPC['name']."</a></td>";
+                $item_color = $this->itemQuality($drop_NPC['Quality'],1);
+                $this->sql_select['other']['creature_drop'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry'].$this->sid."\" ".$item_color.">".$drop_NPC['name']."</a></td>";
                 $this->sql_select['other']['creature_drop'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
               }; } else{ $this->sql_select['other']['creature_drop'] = "<tr><td colspan='2'>Tento creep nemá žádný drop !</td></tr>"; };
@@ -356 +333 @@
             if( @mysql_num_rows($pickpocket_creature) > 0 ){ 
               while($drop_NPC = @MySQL_Fetch_Array($pickpocket_creature)){ 
-                switch($drop_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;
-                  }; 
-                $this->sql_select['other']['creature_pickpocket'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry']."\" ".$sql_select['other']['item_color'].">".$drop_NPC['name']."</a></td>";
+                $item_color = $this->itemQuality($drop_NPC['Quality'],1);
+                $this->sql_select['other']['creature_pickpocket'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry'].$this->sid."\" ".$item_color.">".$drop_NPC['name']."</a></td>";
                 $this->sql_select['other']['creature_pickpocket'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
               }; } else{ $this->sql_select['other']['creature_pickpocket'] = "<tr><td colspan='2'>Tento creep nemá žádný Pickpocket !</td></tr>"; };
@@ -372 +341 @@
             if( @mysql_num_rows($skin_creature) > 0 ){ 
               while($drop_NPC = @MySQL_Fetch_Array($skin_creature)){ 
-                switch($drop_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;
-                  }; 
-                $this->sql_select['other']['creature_skin'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry']."\" ".$sql_select['other']['item_color'].">".$drop_NPC['name']."</a></td>";
+                $item_color = $this->itemQuality($drop_NPC['Quality'],1);
+                $this->sql_select['other']['creature_skin'] .= "<tr><td><a href=\"index.php?item=".$drop_NPC['entry'].$this->sid."\" ".$item_color.">".$drop_NPC['name']."</a></td>";
                 $this->sql_select['other']['creature_skin'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
               }; } else{ $this->sql_select['other']['creature_skin'] = "<tr><td colspan='2'>Tento creep nemá žádný Skin !</td></tr>"; };
@@ -396 +357 @@
 
   /* ==================================================
+   * searchItems()
+   * showItem()
+   * itemSpellCheck($x)   
+   * itemAttribCheck()   
+   * itemQuality($x)   
+   * 
+   * Tato funkce vrací konkrétní Item
+   * + provádí pár dalších operací s jeho daty
+   * 
+  ================================================== */
+
+    function searchItems(){ 
+
+      if( !empty($this->q) AND $this->id == "items" ){ 
+
+          $this->sql_select = SQLselect_Strankovani("SELECT * FROM `item_template` WHERE ( `name` LIKE '%".$this->q."%' ) ORDER BY `Quality` DESC", $this->limit, $this->nastranu, "?id=items&amp;q=".$this->q, $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";
+            $this->sql_select['result'] .= "<thead><tr><td>Název itemu</td><td>Level</td></tr></thead>\n<col><col width=\"70px\">";
+
+            while( $result = MySQL_Fetch_Array($this->sql_select[1]) ){ 
+              if( $result['RequiredLevel'] == 0 ){ $result['RequiredLevel'] = 1; };
+              $item_color = $this->itemQuality($result['Quality'],1);
+
+              $this->sql_select['result'] .= "  <tr valign='top'>";
+              $this->sql_select['result'] .= "<td><a href=\"index.php?item=".$result['entry'].$this->sid."\" $item_color>".$result['name']."</a></td>";
+              $this->sql_select['result'] .= "<td align='center'>".$result['RequiredLevel']."</td>";
+              $this->sql_select['result'] .= "</tr>\n";
+              };
+
+            $this->sql_select['result'] .= "</table>\n";
+            }  else{ $this->sql_select['error'] = "<p>Nebyly nalezeny žádné itemy.</p>"; };
+        return true;
+        };
+
+      return false;
+      } 
+
+    function showItem(){ 
+      global $databaseR;
+
+      if( is_numeric($this->item) AND empty($this->id) ){ 
+        $this->sql_select['sql'] = mysql_query("SELECT * FROM item_template WHERE `entry`='".$this->item."' LIMIT 1");
+        if( @mysql_num_rows($this->sql_select['sql']) > 0 ){ 
+          $this->sql_select['item'] = MySQL_Fetch_Array($this->sql_select['sql']);
+
+          $item_color = $this->itemQuality($this->sql_select['item']['Quality'],2);
+          $item_content .= "<h2 $item_color>".$this->sql_select['item']['name']."</h2>\n"; // jméno
+          if( $this->sql_select['item']['bonding'] != 0 ){
+            $databaseR->resetSelection('bonding',$this->sql_select['item']['bonding'],'item');
+            $item_content .= "<p>".$databaseR->returnResult()."</p>\n"; // bonding
+            };
+          
+          if( $this->sql_select['item']['class'] == 0 ){
+            # need to complete !!!
+            }
+          elseif( $this->sql_select['item']['class'] == 1 ){
+            # need to complete !!!
+            } // .. 15
+          # need to complete !!!                
+
+          $item_content .= $this->itemBattleCheck();
+          $item_content .= $this->itemAttribCheck();
+          $item_content .= $this->itemSpellCheck();
+
+          $this->sql_select['other']['item_content'] = $item_content;
+
+          $this->sql_select['other']['item_content'] = 
+            "<table id=\"item\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n".
+            "  <tr><td class=\"lefttop\"></td><td class=\"top\"></td><td class=\"righttop\"></td></tr><tr><td class=\"left\"></td><td class=\"item_content\">\n".
+            "  ".$this->sql_select['other']['item_content'].
+            "  </td><td class=\"right\"></td></tr><tr><td class=\"leftbottom\"></td><td class=\"bottom\"></td><td class=\"rightbottom\"></td></tr>\n".
+            "</table>\n";
+
+          // drop 
+          $drop_dotaz_creature = mysql_query("SELECT * FROM `creature_loot_template` LEFT JOIN `creature_template` ON `creature_template`.`lootid` = `creature_loot_template`.`entry` WHERE (`creature_loot_template`.`item` ='".$this->sql_select['item']['entry']."' ) ORDER BY `creature_loot_template`.`ChanceOrRef` DESC ");
+            if( @mysql_num_rows($drop_dotaz_creature) > 0 ){ 
+              while($drop_NPC = @MySQL_Fetch_Array($drop_dotaz_creature)){ 
+                $this->sql_select['other']['item_drop_c'] .= "<tr><td><a href=\"index.php?creature=".$drop_NPC['entry'].$this->sid."\">".$drop_NPC['name']."</a></td>";
+                switch($drop_NPC['rank']){ 
+                  case 0: $creature_type = ""; break;
+                  case 1: $creature_type = " Elite"; break;
+                  case 2: $creature_type = " Rare"; break;
+                  case 3: $creature_type = ""; break;
+                  case 4: $creature_type = " Rare"; break;
+                  };
+                if( $drop_NPC['rank'] != 3 ){  
+                  $this->sql_select['other']['item_drop_c'] .= "<td>".$drop_NPC['minlevel']." - ".$drop_NPC['maxlevel'].$creature_type."</td>\n";
+                  } else{ $this->sql_select['other']['item_drop_c'] .= "<td>Boss</td>"; };
+                $this->sql_select['other']['item_drop_c'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+              }; } else{ $this->sql_select['other']['item_drop_c'] = "<tr><td colspan='3'>Tento předmět nepadá z žádného Creepa !</td></tr>"; };
+
+          $drop_dotaz_gameobject = mysql_query("SELECT * FROM `gameobject_loot_template` LEFT JOIN `gameobject_template` ON `gameobject_template`.`lootid` = `gameobject_loot_template`.`entry` WHERE (`gameobject_loot_template`.`item` =".$this->sql_select['item']['entry']." AND `gameobject_loot_template`.`quest_freeforall`='1' ) ORDER BY `gameobject_loot_template`.`ChanceOrRef` DESC ");
+            if( @mysql_num_rows($drop_dotaz_gameobject) > 0 ){ 
+              while($drop_NPC = @MySQL_Fetch_Array($drop_dotaz_gameobject)){ 
+                $this->sql_select['other']['item_drop_o'] .= "<tr><td><a href=\"index.php?gameobject=".$drop_NPC['entry'].$this->sid."\">".$drop_NPC['name']."</a></td>";
+                $this->sql_select['other']['item_drop_o'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+              }; }  else{ $this->sql_select['other']['item_drop_o'] = "<tr><td colspan='2'>Tento předmět nepadá z žádného Objektu !</td></tr>"; }; 
+
+          // questy 
+          $quest_dotaz_sql = "SELECT * FROM `quest_template` WHERE (  ";
+              $quest_dotaz_sql .= "`SrcItemId` =".$this->sql_select['item']['entry']." ";
+              $quest_dotaz_sql .= "OR `ReqItemId1`=".$this->sql_select['item']['entry']." ";
+              $quest_dotaz_sql .= "OR `ReqItemId2`=".$this->sql_select['item']['entry']." ";
+              $quest_dotaz_sql .= "OR `ReqItemId3`=".$this->sql_select['item']['entry']." ";
+              $quest_dotaz_sql .= "OR `ReqItemId4`=".$this->sql_select['item']['entry']." ";
+              $quest_dotaz_sql .= ") ";
+          $quest_dotaz = mysql_query($quest_dotaz_sql);
+            if( @mysql_num_rows($quest_dotaz) > 0 ){ 
+              while($quest = @MySQL_Fetch_Array($quest_dotaz)){ 
+                $StartQuest = $this->startQuest($quest['entry']);
+
+                $this->sql_select['other']['item_quests'] .= "<tr><td><a href=\"index.php?quest=".$quest['entry'].$this->sid."\">".$quest['Title']."</a></td>";
+                $this->sql_select['other']['item_quests'] .= "<td>".$quest['MinLevel']."</td>";
+                $this->sql_select['other']['item_quests'] .= "<td>".$StartQuest."</td></tr>\n";
+              }; }; 
+          if( empty($this->sql_select['other']['item_quests']) ){ 
+            $this->sql_select['other']['item_quests'] = "<tr><td colspan='3'>Tento předmět nezačíná žádný Quest, ani v žádném není potřebný !</td></tr>"; 
+            }; 
+
+          } 
+        else{ 
+          $this->sql_select['error'] = "<p>Item nebyl nalezen.</p>"; 
+          };
+        return true;
+        };
+
+      return false;
+      }
+
+    function itemSpellCheck(){ 
+      for($x=1; $x<=5 ;$x++){
+        if( $this->sql_select['item']['spellid_'.$x] != 0 ){
+          if( !AbsCheck($this->sql_select['item']['spellcooldown_'.$x]) AND $this->sql_select['item']['spellcharges_'.$x] == 0 ){ $action = "Equip"; }
+          else{ $action = "Use"; };
+          $item_content .= "<p class='green'>$action: Unknown spell ID ".$this->sql_select['item']['spellid_'.$x]."</p>\n";
+          if(AbsCheck($this->sql_select['item']['spellcharges_'.$x]) AND $this->sql_select['item']['spellcharges_'.$x] != 0 ){
+            $item_content .= "<p>Charges: ".$this->sql_select['item']['spellcharges_'.$x]."</p>\n";
+            };
+          };
+        };
+      return $item_content;
+      } 
+
+    function itemAttribCheck(){ 
+      global $databaseR;
+      for($x=1; $x<=10 ;$x++){
+        if( $this->sql_select['item']['stat_type'.$x] != 0 AND $this->sql_select['item']['stat_value'.$x] != 0 ){
+          $databaseR->resetSelection('stat_type',$this->sql_select['item']['stat_type'.$x],'item');
+          if( AbsCheck($this->sql_select['item']['stat_value'.$x]) ){ $num = "+"; } else{ $num = "-"; };
+          $item_content .= "<p>".$num.$this->sql_select['item']['stat_value'.$x]." ".$databaseR->returnResult()."</p>\n";
+          };
+        };
+      $resistances = array("holy","fire","nature","frost","shadow","arcane");
+      for($x=0; $x<count($resistances) ;$x++){ 
+        if( $this->sql_select['item'][$resistances[$x].'_res'] != 0 ){ 
+          if( AbsCheck($this->sql_select['item'][$resistances[$x].'_res']) ){ $num = "+"; } else{ $num = "-"; };
+          $item_content .= "<p>".$num.$this->sql_select['item'][$resistances[$x].'_res']." ".FirstLetter($resistances[$x])." Resistance</p>\n";
+          };
+        };
+      return $item_content;
+      } 
+
+    function itemBattleCheck(){ 
+      global $databaseR;
+      // dmg_min1       dmg_max1        dmg_type1
+      for($x=1; $x<=5 ;$x++){
+        if( $this->sql_select['item']['dmg_min'.$x] != 0 AND $this->sql_select['item']['dmg_max'.$x] != 0 ){
+          if( $this->sql_select['item']['dmg_type'.$x] != 0 ){ 
+            $databaseR->resetSelection('dmg_type',$this->sql_select['item']['dmg_type'.$x],'item'); 
+            $dmg_type = " ".$databaseR->returnResult(); };
+          if( $x>1 ){ $num = "+ "; } else{ unset($num); };
+          $item_content .= "<p>".$num.$this->sql_select['item']['dmg_min'.$x]." - ".$this->sql_select['item']['dmg_max'.$x].$dmg_type." Damage</p>\n";
+          };
+        };
+      return $item_content;
+      } 
+
+    function itemQuality($x,$y){ 
+      if( $y==1 ){ // odkaz
+        switch($x){ 
+          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;
+          }; 
+        } 
+      elseif( $y==2 ){ // barva normálního textu
+        switch($x){ 
+          case 0: $item_color = "class='gray'"; break;
+          case 1: $item_color = "class='white'"; break;
+          case 2: $item_color = "class='green'"; break;
+          case 3: $item_color = "class='blue'"; break;
+          case 4: $item_color = "class='purple'"; break;
+          case 5: $item_color = "class='orange'"; break;
+          case 6: $item_color = "class='red'"; break;
+          }; 
+        };
+      return $item_color;
+      }
+
+  /* ==================================================
    * showBugs() 
    * showBug() 
@@ -419 +585 @@
           while( $result = MySQL_Fetch_Array($this->sql_select[1]) ){ 
             $this->sql_select['result'] .= "<tr><td valign='top'>";
-            $this->sql_select['result'] .= "<a href=\"./index.php?id=bugreport&amp;bug=".$result['id']."\">".@date("d.m.Y H:i", $result['vlozeno'])."</a>";
+            $this->sql_select['result'] .= "<a href=\"./index.php?id=bugreport&amp;bug=".$result['id'].$this->sid."\">".@date("d.m.Y H:i", $result['vlozeno'])."</a>";
             $this->sql_select['result'] .= "</td><td valign='top'>";
             $this->sql_select['result'] .= nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $result['popis']));
@@ -528 +694 @@
           $this->sql_select['result']['other']['chars'] .= "<td title=\"Rasa\">".$Database['race'][$this->sql_select['result']['char'][$i]['race']]."</td>";
           $this->sql_select['result']['other']['chars'] .= "<td title=\"Povolání\">".$Database['class'][$this->sql_select['result']['char'][$i]['class']]."</td>\n";
-          $this->sql_select['result']['other']['chars'] .= "<td> - <a href=\"./character.php?char=".$this->sql_select['result']['char'][$i]['guid']."\">Exportovat</a></td></tr>\n";
+          $this->sql_select['result']['other']['chars'] .= "<td> - <a href=\"./character.php?char=".$this->sql_select['result']['char'][$i]['guid'].$this->sid."\">Exportovat</a></td></tr>\n";
           }; 
+        if( $this->sql_select['result']['char_count'] == 0 ){ 
+          $this->sql_select['result']['other']['chars'] .= "  <tr><td>Na tomto účtu nemáte žádné postavy</td></tr>\n";
+          };
         $this->sql_select['result']['other']['chars'] .= "</table>";
 
@@ -538 +707 @@
       }
 
+  /* ==================================================
+   * showGuids()
+   * 
+   * Tato funkce slouží k práci s návody
+   * 
+  ================================================== */
+
+    function showGuids(){ 
+      global $Database,$_POST,$user;
+      SwitchDB(3); // nastavení databáze na web
+
+      if( isset($_POST['send']) ){
+        $bunky = array("nazev","keywords","obsah","vlozil","vlozil_acc","vlozil_date","kategorie");
+        $hodnoty = array($_POST['nazev'],$_POST['keywords'],$_POST['clanek'],$_POST['podpis'],$user['acc'],time(),$_POST['kategorie']);
+        if(mysql_query("INSERT INTO `data_navody` (`".implode("`,`",$bunky)."`) VALUES ('".implode("','",$hodnoty)."') ")){
+          $this->sql_select['other']['insert'] = "Váš návod byl vložen";
+          }
+        else{ $this->sql_select['other']['insert'] = "Návod se nepodařilo vložit"; };
+        };
+      
+      if( $this->id == "navody" ){ 
+
+        $this->sql_select['other']['kategorie'] = "      <li><a href=\"./index.php?id=navody&amp;kat=".$this->sid."\" title=\"Vše\"><b>Kategorie:</b></a></li>\n";
+        $this->sql_select['other']['f_options'] = "    <option value=\"0\"> - - - </option>\n";
+        $sql_select['kateg'] = mysql_query("SELECT * FROM `data_navody_kategorie` WHERE (`zobrazit`!=0) ORDER BY `poradi` ASC");
+        while( $result = @mysql_fetch_array($sql_select['kateg']) ){
+          $this->sql_select['other']['kategorie'] .= "      <li><a href=\"./index.php?id=navody&amp;kat=".$result['entry'].$this->sid."\">".$result['nazev_kategorie']."(".$result['pocet_navodu'].")</a></li>\n";
+          $this->sql_select['other']['f_options'] .= "    <option value=\"".$result['entry']."\">".$result['nazev_kategorie']."</option>\n";
+          };
+
+        if( !empty($this->kategorie) AND $this->kategorie != 0 ){ 
+          $where = "WHERE ( `data_navody`.`kategorie`='".$this->kategorie."' AND "; 
+          // `nadpis` LIKE '%".$this->q."%' OR `subname` LIKE '%".$this->q."%'
+          } 
+        else{ $where = " LEFT JOIN `data_navody_kategorie` ON `data_navody`.`kategorie` = `data_navody_kategorie`.`entry` WHERE ( "; };
+
+        $sql_select = SQLselect_Strankovani("SELECT * FROM `data_navody` $where `data_navody`.`schvaleno`=1 ) ORDER BY `vlozil_date` DESC, `data_navody`.`kategorie` ASC", $this->limit, $this->nastranu, "?id=navody&amp;kat=".$this->kategorie, $this->sid);
+        $this->sql_select = array_merge($this->sql_select, $sql_select);
+
+        if( @mysql_num_rows($sql_select[1]) > 0 ){  unset($result['nazev_kategorie']);
+          $this->sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" cellspacing=\"0\" cellpadding=\"0\">\n";
+          $this->sql_select['result'] .= "<thead><tr><td>Nadpis</td><td>Vložil</td><td>Vloženo</td></tr></thead>\n<col><col width=\"160px\"><col width=\"140px\">\n";
+
+          while( $result = MySQL_Fetch_Array($sql_select[1]) ){ 
+            if( !empty($result['nazev_kategorie']) ){
+              $result['nazev'] = $result['nazev_kategorie']." - ".$result['nazev'];
+              };
+            $this->sql_select['result'] .= "  <tr valign='top'>";
+            $this->sql_select['result'] .= "<td><a href=\"index.php?navod=".$result['id'].$this->sid."\">".$result['nazev']."</a></td>";
+            $this->sql_select['result'] .= "<td>".$result['vlozil']."</td>";
+            $this->sql_select['result'] .= "<td>".date("H:i d.m.Y" ,$result['vlozil_date'])."</td>";
+            $this->sql_select['result'] .= "</tr>\n";
+            };
+          
+          $this->sql_select['result'] .= "</table>\n";
+          } else{ $this->sql_select['result'] = "<p>Nebyly nalezeny žádné návody.</p>"; };
+
+        return true;
+        } 
+      elseif( !empty($this->guid) ){
+        $sql_select['sql'] = mysql_query("SELECT * FROM `data_navody` WHERE (`id`=".$this->guid.") LIMIT 1");
+        if( @mysql_num_rows($sql_select['sql']) > 0 ){ 
+          $this->sql_select['result'] = MySQL_Fetch_Array($sql_select['sql']);
+          mysql_query("UPDATE `data_navody` SET `precteni`='".++$this->sql_select['result']['precteni']."' WHERE `id`=".$this->guid." LIMIT 1");
+          } else{ $this->sql_select['error'] = "<p>Návod nenalezen !</p>"; };
+
+        return true;
+        };
+
+      return false;
+      }
+
+  /* ==================================================
+   * showEvents()
+   * 
+   * Tato funkce vrací dynamické eventy ve hře
+   * 
+  ================================================== */
+
+    public function showEvents($limit,$nastranu){ 
+
+      $this->limit = $limit;
+      $this->nastranu = $nastranu;
+
+      if( $this->id == "eventy" ){ 
+
+        $this->sql_select = SQLselect_Strankovani("SELECT * FROM `game_event` ORDER BY `entry` ASC", $this->limit, $this->nastranu, "?id=eventy", $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";
+          $this->sql_select['result'] .= "<thead><tr><td>Event</td><td>Počátek</td><td title='Po jakých časových úsecích se událost opakuje'>Perioda</td><td title='Doba trvání'>Trvání</td></tr></thead>\n<col><col width=\"140px\">\n";
+
+          //entry - Entry of the game event     
+          //start - Absolute start date, the event will never start before      
+          //end - Absolute end date, the event will never start afler   
+          //occurence - Delay in minutes between occurences of the event        
+          //length - Length in minutes of the event     description 
+          //description - of the event displayed in console
+
+          while( $result = MySQL_Fetch_Array($this->sql_select[1]) ){ 
+
+            if( $result['occurence'] > 60 ){
+              $hours = $result['occurence']/60;
+              $time = explode(".", $hours);
+              if( $time[1] == 0 OR empty($time[1]) ){ $time[1] = "00"; }
+                else{ $time[1] = $time[1]*60; };
+              if( $time[0] > 23 ){ 
+                $days = $time[0]/24;
+                $days = explode(".", $days);
+                if( $days[1] == 0 OR empty($days[1]) ){ $days[1] = "00"; }
+                  else{ $days[1] = $days[1]*24; };
+                $time[0] = $days[1];
+                } else{ $days[0] = "0"; };
+              $result['occurence'] = $time[0]."h ".$time[1]."m ".$days[0]."d";
+              };
+/*
+            if( $result['length'] > 60 ){
+              $hours = $result['length']/60;
+              $time = explode(".", $hours);
+              if( $time[1] == 0 OR empty($time[1]) ){ $time[1] = "00"; }
+                else{ $time[1] = $time[1]*60; };
+              $result['length'] = $time[0]."h ".$time[1]."m";
+              };
+
+            if( $result['length'] == 0 OR empty($result['length']) ){
+              $result['length'] = "Nedefinované"; };
+/*
+            $time = time();
+            $zacatek_eventu = DatabaseTime2Sec($result['start']);
+            $konec_eventu = DatabaseTime2Sec($result['end']);
+
+            if( $konec_eventu <= $time AND $konec_eventu != 0 AND $result['length'] != "Neustále" ){
+              $probehne_za = "Už neproběhne"; }
+            elseif( $konec_eventu != 0 AND !empty($konec_eventu) AND $result['length'] != "Neustále" ){
+              $time_betwen = $time-$zacatek_eventu; //čas mezi začátkem a tímto okamžikem
+              while( $time_betwen%$result['occurence'] > 1 ){ 
+                $time_betwen = $time_betwen - $result['occurence'];
+                };
+              $time_betwen = abs($time_betwen);
+              $probehne_za = date("m", $time_betwen)."d ".
+                             date("d", $time_betwen)."d ".
+                             date("H", $time_betwen)."h ".
+                             date("i", $time_betwen)."m";
+              }
+            else{
+              $probehne_za = "Právě probíhá";
+              };
+*/
+
+            $this->sql_select['result'] .= "  <tr valign='top'>";
+            $this->sql_select['result'] .= "<td>".$result['description']."</td>";
+            $this->sql_select['result'] .= "<td>".ReorderDate($result['start'])."</td>";
+            $this->sql_select['result'] .= "<td>".$result['occurence']."</td>";
+            $this->sql_select['result'] .= "<td>".$result['length']."m</td>";
+            //$this->sql_select['result'] .= "<td>".$probehne_za."</td>";
+            $this->sql_select['result'] .= "</tr>\n";
+            };
+
+          $this->sql_select['result'] .= "</table>\n";
+          } else{ $this->sql_select['result'] = "<p>Nebyly nalezeny žádné eventy.</p>"; };
+
+        return $this->sql_select;
+        } 
+
+      return false;
+      }
+
 
     }; // konec třídy
 
-  }; // vložení souboru
 ?>

@@ -1 +1 @@
 config.php
+navrh