Context Navigation

← Previous Change
Next Change →

Changeset 113 for db

Timestamp:

Oct 27, 2007, 10:23:13 PM (17 years ago)

Author:

hosiplan

Message:

+ Převedl jsem část scritpů na OOP
+ načal jsem poskládání proměnné $Database, která bude sloužit jako hlavní informační středisko
+ malá úprava ve výpisu Questů

Location:

Files:

: 1 added
: 10 edited

check_database.php (modified) (1 diff)
config.sample.php (modified) (1 diff)
functions.php (added)
include/bug_report.php (modified) (1 diff)
include/creep.php (modified) (1 diff)
include/creeps.php (modified) (1 diff)
include/quest.php (modified) (3 diffs)
include/questy.php (modified) (1 diff)
include/uvod.php (modified) (1 diff)
index.php (modified) (7 diffs)
post_read.php (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed

db/check_database.php

-              r109
+              r113
 <?php
+if($vlozeni_souboru == "OK"){
+$Database = array(
+  'class' => array(
+=> "Warrior",
+=> "Paladin",
+=> "Hunter",
+=> "Rogue",
+=> "Priest",
+=> "",
+=> "Shaman",
+=> "Mage",
+=> "Warlock",
+=> "",
+=> "Druid"
+    ),
+  'race' => array(
+=> "Human",
+=> "Orc",
+=> "Dwarf",
+=> "Night Elf",
+=> "Undead",
+=> "Tauren",
+=> "Gnome",
+=> "Troll",
+=> "",
+=> "Blood Elf",
+=> "Dranei"
+    ),
+  'item' => array(
+    'class' => array(
+=> "Consumable",
+=> "Container",
+=> "Weapon",
+=> "Armor",
+=> "Reagent",
+=> "Projectile",
+=> "Trade Goods",
+=> "Recipe",
+=> "Quiver",
+=> "Quest",
+=> "Key",
+=> "Miscellaneous"
+      ),
+    'subclass' => array(
+=> array( // Consumable
+=> "Food",
+=> "Liquid",
+=> "Potion (usable in combat)",
+=> "Scroll (usable in combat)",
+=> "Bandage (usable in combat)",
+=> "Healthstone (usable in combat)",
+=> "Combat Effect (usable in combat)"
+        ),
+=> array( // Weapon
+=> "One Handed Axe",
+=> "Two Handed Axe",
+=> "Bow",
+=> "Rifle",
+=> "One Handed Mace",
+=> "Two Handed Mace",
+=> "Polearm",
+=> "One Handed Sword",
+=> "Two Handed Sword",
+=> "Staff",
+=> "One Handed Exotic",
+=> "Two Handed Exotic",
+=> "Fist Weapon",
+=> "Miscellaneous Weapon",
+=> "Dagger",
+=> "Thrown",
+=> "Spear",
+=> "Crossbow",
+=> "Wand",
+=> "Fishing Pole"
+        ),
+=> array( // Armor
+=> "Miscellaneous",
+=> "Cloth",
+=> "Leather",
+=> "Mail",
+=> "Plate",
+=> "Shield"
+        ),
+=> array( // Projectile
+=> "Arrows",
+=> "Bullets"
+        ),
+=> array( // Trade Goods
+=> "Trade Goods",
+=> "Parts",
+=> "Explosives",
+=> "Devices"
+        ),
+=> array( // Recipe
+=> array("Book"),
+=> array("Pattern","Leatherworking"),
+=> array("Pattern","Tailoring"),
+=> array("Schematic","Engineering"),
+=> array("Plans","Blacksmithing"),
+=> array("Recipe","Cooking"),
+=> array("Recipe","Alchemy"),
+=> array("Manual","First Aid"),
+=> array("Formula","Enchanting"),
+=> array("Fishing","Manual")
+        ),
+=> array( // Quiver
+=> array("Quiver","Arrows"),
+=> array("Ammo Pouch","Bullets")
+        ),
+=> array( // Projectile
+=> "Arrows",
+=> "Bullets"
+        )
+      ),
+    'quality' => array(
+=> array("Grey","Poor"),
+=> array("White","Common"),
+=> array("Green","Uncommon"),
+=> array("Blue","Rare"),
+=> array("Purple","Epic"),
+=> array("Orange","Legendary"),
+=> array("Red","Artifact")
+      ),
+    'type' => array(
+=> "binded",
+=> "Conjured",
+=> "Openable item",
+=> "Shield",
+=> "Totem",
+=> "Mount",
+=> "Wand",
+=> "Ribboned Wrapping Paper",
+=> "Essence",
+=> "Guild Charter",
+=> "PvP Reward Item"
+      ),
+    'equip' => array(
+=> "Head",
+=> "Neck",
+=> "Shoulder",
+=> "Shirt",
+=> "Chest",
+=> "Waist", // Belt
+=> "Legs", // Pants
+=> "Feet", // Boots
+=> "Wrists", // Bracers
+=> "Hands", // Gloves
+=> "Finger", // Ring
+=> "Trinket",
+=> "One Hand",
+=> "Off Hand", // includes Shield
+=> "Bow",
+=> "Back",
+=> "Two Hand",
+=> "Bag", // include Quivers
+=> "Tabard",
+=> "Robe",
+=> "Main Hand",
+=> "Off Hand", // Misc Items
+=> "Tome",
+=> "Ammunition",
+=> "Thrown",
+=> "Gun"
+      ),
+    'AllowableClass' => array(
+=> "Warrior",
+=> "Paladin",
+=> "Hunter",
+=> "Rogue",
+=> "Priest",
+=> "Shaman",
+=> "Mage",
+=> "Warlock",
+=> "Druid"
+      ),
+    'AllowableRace' => array(
+=> "Human",
+=> "Orc",
+=> "Dwarf",
+=> "Night Elf",
+=> "Undead",
+=> "Tauren",
+=> "Gnome",
+=> "Troll",
+=> "Blood elf",
+=> "Draenei"
+      ),
+    'RequiredReputationRank' => array(
+=> "Hated",
+=> "Hostile",
+=> "Unfriendly",
+=> "Neutral",
+=> "Friendly",
+=> "Honored",
+=> "Reverted",
+=> "Exalted",
+      ),
+    'stat_type' => array(
+=> "Mana",
+=> "Health",
+=> "Agility",
+=> "Strength",
+=> "Intellect",
+=> "Spirit",
+=> "Stamina",
+      ),
+    'dmg_type' => array(
+=> "Physical",
+=> "Holy",
+=> "Fire",
+=> "Nature",
+=> "Frost",
+=> "Shadow",
+=> "Arcane"
+      ),
+    'ammo_type' => array(
+=> "Arrows",
+=> "Bullets"
+      ),
+    'spell_charges' => array(
+=> "Infinite charges",
+      'negative' => "Item is expendable",
+      'positive' => "Item is kept when all charges are spent"
+      ),
+    'bonding' => array(
+=> "Binds when Picked Up",
+=> "Binds when Equipped",
+=> "Binds when Used",
+=> "Quest Item"
+      ),
+    'bonding' => array(
+=> "Binds when Picked Up",
+=> "Binds when Equipped",
+=> "Binds when Used",
+=> "Quest Item"
+      ),
+    'LanguageID' => array(
+=> "Orcish",
+=> "Darnassian",
+=> "Taurahe",
+=> "Dwarvish",
+=> "Common",
+=> "Demonic",
+=> "Titan",
+=> "Thelassian",
+=> "Draconic",
+=> "Kalimag",
+=> "Gnomish",
+=> "Troll",
+=> "Gutterspeak"
+      ),
+    'PageMaterial' => array(
+=> "Parchment",
+=> "Stone",
+=> "Marble",
+=> "Silver",
+=> "Bronze"
+      ),
+    'Material' => array(
+=> "Metal",
+=> "Wood",
+=> "Liquid",
+=> "Jewelry",
+=> "Chain",
+=> "Plate",
+=> "Cloth",
+=> "Leather"
+      ),
+    'sheath' => array(
+=> "Two Handed Sword (on the back; tip down)",
+=> "Staff (on the back; tip up)",
+=> "One Handed Sword (on the side)",
+=> "Shield (on the back)",
+=> "Enchanter's Rod",
+=> "Off Hand",
+      ),
+    'BagFamily' => array(
+=> "",
+=> "Arrows",
+=> "Bullets",
+=> "Soul Shards",
+=> "Herbs",
+=> "Enchanting Supp",
+=> "Engineering Supp",
+=> "Keys",
+=> "Gems",
+=> "Mining Supp",
+      )
+    ),
+  'quest' => array(
+    'ZoneOrSort' => array(
+      'negative' => array(
+=> "Epic",
+=> "REUSE - old wailing caverns",
+=> "Seasonal",
+=> "REUSE - old undercity one",
+=> "Herbalism",
+=> "REUSE - old scarlet monastery",
+=> "REUSE - old uldaman",
+=> "Warlock",
+=> "Warrior",
+=> "Shaman",
+=> "Fishing",
+=> "Blacksmithing",
+=> "Paladin",
+=> "Mage",
+=> "Rogue",
+=> "Alchemy",
+=> "Leatherworking",
+=> "Engineering",
+=> "Treasure Map",
+=> "REUSE - old sunken temple",
+=> "Hunter",
+=> "Priest",
+=> "Druid",
+=> "Tailoring",
+=> "Special",
+=> "Cooking",
+=> "First Aid",
+=> "Legendary",
+=> "Darkmoon Faire",
+=> "Ahn'Qiraj War",
+=> "Lunar Festival",
+=> "Reputation",
+        ),
+      'positive' => "SQL:area_table"
+      ),
+    'Type' => array(
+=> "Elite",
+=> "Life",
+=> "PvP",
+=> "Raid",
+=> "Dungeon",
+=> "World Event"
+      ),
+/* =====================================
+RequiredRaces ¶ ??????? need to complete !!!!
+Races required to get the quest. 0 means available for all races.
+Field's value is a decimal value that must be transform to a 8 bits binary in order to be understandable.
+In binary form, each different bit represent a different race. They're assigned as follow :
+     64      32      16      8       4       2       1
+Troll   Gnome   Tauren  Undead  NightElf        Dwarf   Orc     Human
+Example :
+Int field value : 77
+Assigning bits from the left to the right :
+     64      32      16      8       4       2       1
+Troll   Gnome   Tauren  Undead  NightElf        Dwarf   Orc     Human
+       1       0       0       1       1       0       1
+Then, quest is for races : Human, Dwarf, NightElf, Gnome. In other words, add the values in the above table together for the classes you want. Another example: To make a quest for Humans and Dwarves, add 1 and 4 together to get 5.
+===================================== */
+    'SpecialFlags' => array(
+=> "Elite",
+=> "Life",
+=> "PvP",
+=> "Raid",
+=> "Dungeon",
+=> "World Event"
+      )
+/* =====================================
+    * QUEST_SPECIAL_FLAGS_NONE = 0
+    * QUEST_SPECIAL_FLAGS_DELIVER = 1
+    * QUEST_SPECIAL_FLAGS_EXPLORATION = 2
+    * QUEST_SPECIAL_FLAGS_SPEAKTO = 4
+    * QUEST_SPECIAL_FLAGS_KILL_OR_CAST = 8
+    * QUEST_SPECIAL_FLAGS_TIMED = 16
+    * Flag 32 unknown
+    * QUEST_SPECIAL_FLAGS_REPUTATION = 64
+PrevQuestId ¶
+If value > 0: Contains the previous quest id, that must be completed before this quest can be started.
+If value < 0: Contains the parent quest id, that must be active before this quest can be started.
+If quest have many alternative previous quests (race specific quests lead to single not race specific quest) field NextQuestId in previous quests can used for setting this dependence.
+Mangos check completing of PrevQuestId for this quest and completing of all quests that have NextQuestId == this quest id, one completion is enough to allow starting this quest.
+NextQuestId ¶
+If value > 0: Contains the next quest id, if PrevQuestId of that quest is not sufficient.
+If value < 0: Contains the sub quest id, if PrevQuestId of that quest is not sufficient.
+If quest have many alternative next quests (class specific quests lead from single not class specific quest) field PrevQuestId in next quests can used for setting this dependence.
+ExclusiveGroup ¶
+if ExclusiveGroup? > 0
+Allows to define a group of quests of which only one may be chosen and completed.
+E.g. if from quests 1200, 1201 and 1202 only one should be allowed to be chosen, insert 1200 into ExclusiveGroup of all 3 quests.
+if ExclusiveGroup? < 0
+Allows to define a group of quests of which all must be completed and rewarded to start next quest.
+E.g. if quest 1000 dependent from onw of quests 1200, 1201 and 1202 and all this quests have same negative exclusive group then all this quest mustbe completed and rewareded before quest 1000 can be started.
+NextQuestInChain ¶
+Defines quest chains, the details of the entered quest will be automatically opened when this quest is completed.
+Only works when the quest rewarder of this quest is the quest giver of the entered quest.
+srcItem ¶
+Item's ID given by the quest giver at beginning of the quest.
+Items will be deleted when quest is abandoned.
+srcItemCount ¶
+Number of Item given at quest start.
+SrcSpell ¶
+Spell casted on player when quest is started. Can be a buff or a learning spell.
+Title ¶
+Title of the quest.
+Details ¶
+Long quest's description.
+Objectives ¶
+Objectives of the quest.
+If empty, quest is an auto-complete quest that can be immediately finished without accepting it first.
+OfferRewardText ¶
+First text send to the player by the NPC when completing the quest.
+RequestItemsText ¶
+This text ist send to player, yet did not terminate the Quest and speak with NPC again!
+EndText ¶
+This text is indicated to the player, if you open your Questlog and wars send to player ingame. No Change this!
+ObjectiveText1-4 ¶
+Used to define non-standard objective texts.
+ReqItemId1-4 ¶
+Item_template Id of the 1.-4. required item to complete the quest. (if any)
+ReqItemCount1-4 ¶
+Amount of 1.-4. required items.
+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.
+ReqCreatureOrGOId1-4 ¶
+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.
+ReqCreatureOrGOCount1-4 ¶
+Number of kills/casts needed on 1.-4. creature or gameobject.
+ReqSpellCast1-4 ¶
+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.
+RewChoiceItemId1-6 ¶
+Id of the 1.-6. Item available for reward choice.
+RewChoiceItemCount1 ¶
+Number of Charges in the 1.-6. rewarded item available.
+RewItemId1-4 ¶
+.-4. item Id given for reward (no choice).
+RewItemCount1-4 ¶
+Number of RewItem1-4.
+RewRepFaction1-5 ¶
+Faction Id (from Faction.dbc in this case) for which the quest give reputation points.
+RewRepValue1-5 ¶
+Number of gain or lost reputation points for Faction1-5 at quest completion.
+This is special reputation rewarding. Normal reputation reward to quest rewarding creature faction calculated and added automatically.
+RewOrReqMoney ¶
+Money earned by completing the quest (if value > 0). Money quest requirement (if value < 0).
+RewXpOrMoney ¶
+Experience or money (when player's level = maxlevel) given when completing the quest. Only given once for repeatable quests.
+RewSpell ¶
+Spell casted at player when completing the quest. This can be learn spell and player learned some spell in result, or buff spell, for example.
+PointMapId ¶
+MapId of a quest point of interest (POI).
+POI will be shown on the map when quest is active.
+PointX ¶
+X coordinate of quest POI.
+PointY ¶
+Y coordinate of quest POI.
+PointOpt ¶
+!!! Need info here : Feel free to document if you know. !!!
+OfferRewardEmote, RequestItemsEmote ¶
+Emote that creature show at request quest details, show incompleted quest and completing quest
+CompleteScript ¶
+!!! Need info here : Feel free to document if you know. !!!
+Repeatable ¶
+Is quest repeatable? 1 yes 0 no
+===================================== */
+    ),
+  'creep' => array(
+    'type' => array(
+=> "Beast",
+=> "Dragonkin",
+=> "Demon",
+=> "Elemental",
+=> "Giant",
+=> "Undead",
+=> "Humanoid",
+=> "Critter",
+=> "Mechanical",
+=> "Not specified",
+=> "Totem" ),
+    ),
+/* =====================================
+entry ¶
+Creature's id, related to field creature.guid
+modelid ¶
+Graphical model that client must apply on this creature.
+name ¶
+Base name of the creature.
+subname ¶
+Subname of the creature (if any).
+minlevel ¶
+Creature's minimum level. Spawned creature have level in range from minlevel to maxlevel
+maxlevel ¶
+Creature's maximum level. Spawned creature have level in range from minlevel to maxlevel
+minhealth ¶
+Maximum creature's health points for creature level equal minlevel. Spawned creature have health in linear proportion to level position in range minlevel .. maxlevel
+maxhealth ¶
+Maximum creature's health points for creature level equal maxlevel. Spawned creature have health in linear proportion to level position in range minlevel .. maxlevel
+minmana ¶
+Maximum creature's mana points for creature level equal minlevel. Spawned creature have mana in linear proportion to level position in range minlevel .. maxlevel
+maxmana ¶
+Maximum creature's mana points for creature level equal maxlevel. Spawned creature have mana in linear proportion to level position in range minlevel .. maxlevel
+armor ¶
+Creature's armor.
+Faction ¶
+Creature's faction. See: CreatureFaction
+npcflag ¶
+This is way to cliet know how info you see if you clic(RMB) on NPC if is vendor if is auction in fact is menu how you see
+Is what type of NPC it is. Stored in npc_option.npcflag
+enum NPCFlags
+Type    Value   Hex     Comment
+UNIT_NPC_FLAG_NONE      0       0x00000         you can't speak with npc
+UNIT_NPC_FLAG_GOSSIP    1       0x00001         you can only speak with npc
+UNIT_NPC_FLAG_QUESTGIVER        2       0x00002         this npc can give you quest
+UNIT_NPC_FLAG_VENDOR    4       0x00004         vendor..
+UNIT_NPC_FLAG_TAXIVENDOR        8       0x00008         gryfon master and oder fly masters ....
+UNIT_NPC_FLAG_TRAINER   16      0x00010         trainer this npc teatch you some spell
+UNIT_NPC_FLAG_SPIRITHEALER      32      0x00020         ghost in graveyeard(visible only to dead)
+UNIT_NPC_FLAG_SPIRITGUIDE       64      0x00040         ghost in battleground(visible only to dead)
+UNIT_NPC_FLAG_INNKEEPER         128     0x00080         you can give to this npc your heartstone
+UNIT_NPC_FLAG_BANKER    256     0x00100         bank in capital city
+UNIT_NPC_FLAG_PETITIONER        512     0x00200         the guy you get the petitionpaper for signing a Guild
+UNIT_NPC_FLAG_TABARDVENDOR      1024    0x00400         in this guy you can build tabart
+UNIT_NPC_FLAG_BATTLEFIELDPERSON         2048    0x00800         battlemaster ... for Warsong and oder battlegrount this npc give you intro quorte
+UNIT_NPC_FLAG_AUCTIONEER        4096    0x01000         auction house
+UNIT_NPC_FLAG_STABLE    8192    0x02000         stable master for hunter you can keep your pet in stable
+UNIT_NPC_FLAG_ARMORER   16384   0x04000         in this you you can repair your damaget items
+   0x08000         (unused)
+UNIT_NPC_FLAG_GUARD     65536   0x10000         guard directions help (custom flag used at sever side only
+To see flag combinations, just use this tool: http://www.mangosproject.org/~wrs/tools/flags.php ;)
+NPCs with one than one function get their flag by adding the flag values. A trainer that gives quest and sells stuff would have the NPCFLAG 16+2+4=22. It's really that easy ;)
+speed ¶
+Creature's speed.
+rank ¶
+Creature's honnor rank.
+- Normal
+- Elite
+- RareElite?
+- WorldBoss?
+- Rare
+mindmg ¶
+Creature's minimum melee damage.
+maxdmg ¶
+Creature's maximum melee damage.
+dmgschool ¶
+Creature's melee damage spell school (by default 0/SPELL_SCHOOL_NORMAL/physical damage).
+attackpower ¶
+Creature's melee attack power.
+baseattacktime ¶
+Time between each creature's melee attacks.
+rangeattacktime ¶
+Time between each creature's range attacks.
+flags ¶
+!!! Need info here : Feel free to describe if you know !!!
+mount ¶
+Creature's mount model ID ... if the value is equal to zero then creature doesn't have any mount.
+dynamicflags ¶
+!!! Need info here : Feel free to describe if you know !!!
+size ¶
+Creature model size 1 = 100%
+family ¶
+Id      Family
+       Wolf
+       Cat
+       Spider
+       Bear
+       Boar
+       Crocolisk
+       Carrion Bird
+       Crab
+       Gorilla
+      [UNUSED]
+      Raptor
+      Tallstrider
+      [UNUSED]
+      [UNUSED]
+      Felhunter
+      Voidwalker
+      Succubus
+      [UNUSED]
+      Doomguard
+      Scorpid
+      Turtle
+      [UNUSED]
+      Imp
+      Bat
+      Hyena
+      Owl
+      Wind Serpent
+      Remote Control
+      Felguard
+      Dragonhawk
+      Ravager
+      Warp Stalker
+      Sporebat
+      Nether Ray
+      Serpent
+bounding_radius ¶
+Radius from what u can be attacked !
+trainer_type ¶
+    TRAINER_TYPE_CLASS = 0 //Train Spell your class. Must be creature_template.class == player class for training
+    TRAINER_TYPE_MOUNTS = 1 //Train Spell your race (mounts). Must be creature_template.race == player race for training
+    TRAINER_TYPE_TRADESKILLS = 2 //Train Trade skills Mining,Herb, first aid .... Pдayer must known creature_template.trainer_spell for training
+    TRAINER_TYPE_PETS = 3 //Train Pet only for hunter(train hunter train pet) creature_template.class == HUNTER == player class for training
+trainer_spell ¶
+Spell ID. Used for check in case npcflag include trainer flag (16) and trainer_type == TRAINER_TYPE_TRADESKILLS. Player must known trainer_spell to start training
+See : character.class.
+class ¶
+Creature's class, like 'character.class' field. Used for check in case npcflag include trainer flag (16) and trainer_type == TRAINER_TYPE_CLASS or TRAINER_TYPE_PETS
+See : character.class.
+race ¶
+Creature's race, like 'character.race' field. Used for check in case npcflag include trainer flag (16) and trainer_type == TRAINER_TYPE_MOUNTS
+See : character.race.
+minrangedmg ¶
+Minimum creature's range damage.
+maxrangedmg ¶
+Maximum creature's range damage.
+rangedattackpower ¶
+Creature's ranged attack power.
+combat_reach ¶
+The distance from the creature can hit you.
+type ¶
+Id      Type
+       Beast
+       Dragonkin
+       Demon
+       Elemental
+       Giant
+       Undead
+       Humanoid
+       Critter
+       Mechanical
+      Not specified
+      Totem
+civilian ¶
+If is this NPC civilian or not.
+If this is a boolean value (Civilian or not), why is it a int(4) ?
+flag1 ¶
+!!! Need info here : Feel free to describe if you know !!!
+equipmodel1 ¶
+Equipement's model of the first item weared by the creature.
+equipmodel2 ¶
+Equipement's model of the second item weared by the creature.
+equipmodel3 ¶
+Equipement's model of the third item weared by the creature.
+equipinfo1 ¶
+!!! Need info here : Feel free to describe if you know !!!
+equipinfo2 ¶
+!!! Need info here : Feel free to describe if you know !!!
+equipinfo3 ¶
+!!! Need info here : Feel free to describe if you know !!!
+equipslot1 ¶
+!!! Need info here : Feel free to describe if you know !!!
+equipslot2 ¶
+!!! Need info here : Feel free to describe if you know !!!
+equipslot3 ¶
+!!! Need info here : Feel free to describe if you know !!!
+lootid ¶
+Refered to field loot_template.entry
+skinloot ¶
+Type of loot if creature is skinned.
+resistance1 ¶
+holy resitance
+resistance2 ¶
+fire resistance
+resistance3 ¶
+nature resistance
+resistance4 ¶
+frost resistance
+resistance5 ¶
+shadow resistance
+resistance6 ¶
+arcane resistance
+spell1 ¶
+Creature's first spell. ??? refer to game_spell.id ???
+spell2 ¶
+Creature's second spell. ??? refer to game_spell.id ???
+spell3 ¶
+Creature's third spell. ??? refer to game_spell.id ???
+spell4 ¶
+Creature fourth spell. ??? refer to game_spell.id ???
+mingold ¶
+Minimum gold drop.
+maxgold ¶
+Maximum gold drop. 0 = creature don't drop any gold.
+AIName ¶
+Name of the AI function creature uses.
+MovementType? ¶
+Type of default creature movment.
+Id      Type
+       Idle (not move)
+       Random
+       Waypoint
+InhabitType? ¶
+Where creature cat move and attack (bit mask).
+Id      Type
+       Ground
+       Water
+       Ground+Water
+ScriptName? ¶
+Script's name creature uses.
+===================================== */
+  'gameobject' => array(
+    'type' => array(
+=> "Beast",
+=> "Dragonkin",
+=> "Demon",
+=> "Elemental",
+=> "Giant",
+=> "Undead",
+=> "Humanoid",
+=> "Critter",
+=> "Mechanical",
+=> "Not specified",
+=> "Totem" ),
+    )
+/* =====================================
+entry
+ID of your choice ex : 5914 and in game : .addgo 5914
+type:
+Value   Name    Note
+       DOOR
+       BUTTON
+       QUESTGIVER
+       CHEST
+       ?
+       GENERIC
+       TRAP
+       CHAIR
+       SPELL_FOCUS
+       TEXT
+      GOOBER
+      TRANSPORT
+      ?
+      ?       "Battlement Large"
+      ?       do not possess the parameter?
+      MO_TRANSPORT
+      DUEL_FLAG
+      FISHING_BOBBER
+      RITUAL
+      MAILBOX
+      ?
+      ?
+      SPELLCASTER
+      MEETING_STONE
+      FLAGSTAND       (BG_Flag)
+      FISHING_HOLE
+      ?
+      CUSTOM_TELEPORTER       Not supported but sended to client, can create problems in client work.
+      ?
+      BANNER?
+displayId:
+Graphic model's id sent to the client.
+name:
+Object's name.
+faction:
+Object's faction, if any.
+flags:
+!!! Need info here : Feel free to document if you know !!!
+size:
+Object's size must be set because graphic models can be resample.
+sound0 - sound11:
+Data fields specific for different type field values. Each type has unique fields.
+ScriptName?
+Script's name this object uses, if needed.
+Gameobject type 0 ( DOOR ):
+sound0 = State
+sound1 = LockID ( ID from Lock.dbc )
+sound2 = flags ?
+sound3 = flags ?
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 1 ( BUTTON ):
+sound0 = State
+sound1 = LockID ( ID from Lock.dbc )
+sound2 = flags ?
+sound3 = ID gameobject ( Spawned GO type 6 )
+sound4 = State Battleground ?
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 2 ( QUESTGIVER ):
+sound0 = LockID ( ID from Lock.dbc )
+sound1 = QuestLoot? ID (Quest Id to be given)
+sound2 = 0
+sound3 = QuestLoot? ID
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 3 ( CHEST ):
+sound0 = LockID ( ID from Lock.dbc )
+sound1 = LootID
+sound2 = Time
+sound3 = State
+sound4 = MinLoot? ( Min successful loot attempts for Mining Gerbalism etc )
+sound5 = MaxLoot? ( Max successful loot attempts for Mining Gerbalism etc )
+sound6 = QuestLoot? ID
+sound7 = ID gameobject ( Spawned GO type 6 )
+sound8 = QuestID ( Quest complete )
+sound9 = ?
+sound10 = ?
+sound11 = 0
+Gameobject type 5 ( GENERIC ):
+sound0 = State
+sound1 = State
+sound2 = 0
+sound3 = 0
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 6 ( TRAP ):
+sound0 = LockID ( ID from Lock.dbc )
+sound1 = Time
+sound2 = Distance
+sound3 = Spell ID
+sound4 = State ?
+sound5 = Time/Distance ?
+sound6 = Chain Effect
+sound7 = Time/Distance for Chain Effect
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 7 ( CHAIR ):
+sound0 = State
+sound1 = Distance/ State ?
+sound2 = 0
+sound3 = 0
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 8 ( SPELL_FOCUS ):
+sound0 = ID SpellFocusObject.dbc. See SpellFocusObjectID
+sound1 = Distance
+sound2 = ID gameobject ( Spawned GO type 6 )
+sound3 = State ?
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 9 ( TEXT ):
+sound0 = Page ID
+sound1 = 0
+sound2 = ID from PageTextMaterial?.dbc
+sound3 = 0
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 10 ( GOOBER ):
+sound0 = LockID ( ID from Lock.dbc )
+sound1 = flags ?
+sound2 = QuestLoot? ID ?
+sound3 = flags ?
+sound4 = State ?
+sound5 = State ?
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = Spell ID
+sound11 = 0
+Gameobject type 18 ( RITUAL ):
+sound0 = Time ?
+sound1 = Spell ID
+sound2 = Spell ID
+sound3 = 0
+sound4 = ?
+sound5 = ?
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 22 ( SPELLCASTER ):
+sound0 = Spell ID
+sound1 = 0
+sound2 = State ?
+sound3 = 0
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 24 ( FLAGSTAND ):
+sound0 = 0
+sound1 = Spell ID
+sound2 = ?
+sound3 = Spell ID
+sound4 = Spell ID
+sound5 = ?
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+Gameobject type 27 ( CUSTOM_TELEPORTER ):
+sound0 = areatrigger_template.id
+sound1 = 0
+sound2 = 0
+sound3 = 0
+sound4 = 0
+sound5 = 0
+sound6 = 0
+sound7 = 0
+sound8 = 0
+sound9 = 0
+sound10 = 0
+sound11 = 0
+===================================== */
+);
 ?>
-<?php
-  };
-?>

db/config.sample.php

-              r109
+              r113
 );
-$Database = array(
-  'class' => array(
-=> "Warrior",
-=> "Paladin",
-=> "Hunter",
-=> "Rogue",
-=> "Priest",
-=> "",
-=> "Shaman",
-=> "Mage",
-=> "Warlock",
-=> "",
-=> "Druid"
-    ),
-  'race' => array(
-=> "Human",
-=> "Orc",
-=> "Dwarf",
-=> "Night Elf",
-=> "Undead",
-=> "Tauren",
-=> "Gnome",
-=> "Troll",
-=> "",
-=> "Blood Elf",
-=> "Dranei"
-    ),
-  'item' => array(
-=> "",
-=> ""
-    ),
-  'quest' => array(
-=> "",
-=> ""
-    ),
-  'creep' => array(
-    'type' => array(
-=> "Beast",
-=> "Dragonkin",
-=> "Demon",
-=> "Elemental",
-=> "Giant",
-=> "Undead",
-=> "Humanoid",
-=> "Critter",
-=> "Mechanical",
-=> "Not specified",
-=> "Totem" ),
+    )
-);
 ?>

db/include/bug_report.php

-              r109
+              r113
 <?php
 if($vlozeni_souboru == "OK"){
+  if( $id == "bugreport" AND !empty($bug) ){
+    $sql_select = $BasicWiewer->bug($bug);
+  ## ================== Výpis bugu ================== ##
+  if( !empty($sql_select['error']) ){
+    echo $sql_select['error'];  ?>
+  <br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
+  <?php
+    }
+  else{  ?>
+    <table border="0" id="sendbug" cellspacing="0" cellpadding="2">
+      <col width="120px;"><col width="160px;">
+      <tr><td><b>Vlozil:</b></td><td><?php echo preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $sql_select['bug']['nick']); ?></td></tr>
+      <tr><td><b>Vlozeno:</b></td><td><?php echo @date("H:i d.m.Y", $sql_select['bug']['vlozeno']); ?></td></tr>
+      <tr><td><b>Status:</b></td><td><?php echo $sql_select['bug']['opraveno']; ?></td></tr>
+      <tr><td><b>Opravil:</b></td><td><?php echo $sql_select['bug']['opravil_nick']; ?></td></tr>
+      <tr><td><b>Popis Chyby:</b></td><td></td><td></td></tr>
+      <tr><td colspan='3' class="text"><?php echo nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $sql_select['bug']['popis'])); ?></td></tr>
+      <?php if( !empty($sql_select['bug']['popis_opravy']) ){ ?>
+      <tr><td><b>Popis Opravy:</b></td><td></td><td></td></tr>
+      <tr><td colspan='3' class="text"><?php echo nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $sql_select['bug']['popis_opravy'])); ?></td></tr>
+      <?php }; ?>
+    </table>
+  <br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
+      <?php
+      };
+  ## ================== Výpis bugu ================== ##
+    }
+  elseif( $id == "bugreport" AND empty($bug) ){
+    $sql_select = $BasicWiewer->bugs($bug,$limit,20);
+  ## ================== Výpis bugů ================== ##
+  if( !empty($sql_select['error']) ){
+    echo $sql_select['error'];  ?>
+  <br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
+  <?php
+    }
+  else{
+    echo $sql_select['result'];  ?>
+    <br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
+    <?php
+      };
+  ## ================== Výpis bugů ================== ##
+    }
+  elseif( $id == "sendbug" ){
+    $sql_insert = $BasicWiewer->bugSend();
+  ## ================== Vložení bugu ================== ##
+  ?>
+    <?php echo $sql_insert['result']; ?>
+    <p>Příspěvky, které se netýkají chyb v databázi, budou nemilosrdně mazány.</p>
+    <form action="./index.php?id=sendbug" method="post" accept-charset="utf-8">
+      <table id="sendbug" border="0" cellspacing="0" cellpadding="2">
+        <tr><td>
+          <label for="game_nick">Váš nick ve hře:</label></td><td>
+          <input type="text" name="game_nick" id="game_nick" maxlength="50" style="width:300px;">
+        </td></tr><tr><td>
+          <label for="err_type">Typ chyby:</label></td><td>
+          <select name="err_type" id="err_type" style="width:300px;">
+            <option value="q">Buglý Úkol (Quest)</option>
+            <option value="i">Buglá Věc (Item)</option>
+            <option value="c">Buglý Creep (NPC)</option>
+            <option value="g">Buglý Objekt ve hře (Gameobject)</option>
+            <option value="p">Buglá Profese (Profesion)</option>
+            <option value="s">Buglé Kouzlo (Spell)</option>
+            <option value="t">Buglý Talent</option>
+            <option value="o">Jiný</option>
+          </select>
+        </td></tr><tr><td colspan='2'>
+          <label for="typ">Popis chyby:</label></td></tr><tr><td colspan='2'>
+          <textarea name="popis" id="popis" rows="5" cols="50" style="width:474px;height:100px;"></textarea>
+        </td></tr><tr><td align='left' valign='top'>
+          <input type="submit" value="Nahlásit Chybu" name="send"></td><td>
+        </td></tr>
+    </table></form>
+  <?php
+  ## ================== Vložení bugu ================== ##
+    };
+};
 ?>
-<?php if( !empty($sql_select['bug']) AND $id="bugreport" AND !empty($bug) ){ ?>
-  <table border="0" id="sendbug" cellspacing="0" cellpadding="2">
-    <col width="120px;"><col width="160px;">
-    <tr><td><b>Vlozil:</b></td><td><?php echo preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $sql_select['bug']['nick']); ?></td></tr>
-    <tr><td><b>Vlozeno:</b></td><td><?php echo @date("H:i d.m.Y", $sql_select['bug']['vlozeno']); ?></td></tr>
-    <tr><td><b>Status:</b></td><td><?php echo $sql_select['bug']['opraveno']; ?></td></tr>
-    <tr><td><b>Opravil:</b></td><td><?php echo $sql_select['bug']['opravil_nick']; ?></td></tr>
-    <tr><td><b>Popis Chyby:</b></td><td></td><td></td></tr>
-    <tr><td colspan='3' class="text"><?php echo nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $sql_select['bug']['popis'])); ?></td></tr>
-<?php if( !empty($sql_select['bug']['popis_opravy']) ){ ?>
-    <tr><td><b>Popis Opravy:</b></td><td></td><td></td></tr>
-    <tr><td colspan='3' class="text"><?php echo nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $sql_select['bug']['popis_opravy'])); ?></td></tr>
-<?php }; ?>
-  </table>
-<br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
-<?php } elseif( !empty($sql_select['result']) AND $id="bugreport" AND empty($bug) ){ ?>
-  <?php echo $sql_select['result']; ?>
-<br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
-<?php } elseif( $id=="sendbug" ){ ?>
-  <?php echo $sql_insert['result']; ?>
-  <p>Příspěvky, které se netýkají chyb v databázi, budou nemilosrdně mazány.</p>
-  <form action="./index.php?id=sendbug" method="post" accept-charset="utf-8">
-    <table id="sendbug" border="0" cellspacing="0" cellpadding="2">
-      <tr><td>
-        <label for="game_nick">Váš nick ve hře:</label></td><td>
-        <input type="text" name="game_nick" id="game_nick" maxlength="50" style="width:300px;">
-      </td></tr><tr><td>
-        <label for="err_type">Typ chyby:</label></td><td>
-        <select name="err_type" id="err_type" style="width:300px;">
-          <option value="q">Buglý Úkol (Quest)</option>
-          <option value="i">Buglá Věc (Item)</option>
-          <option value="c">Buglý Creep (NPC)</option>
-          <option value="g">Buglý Objekt ve hře (Gameobject)</option>
-          <option value="p">Buglá Profese (Profesion)</option>
-          <option value="s">Buglé Kouzlo (Spell)</option>
-          <option value="t">Buglý Talent</option>
-          <option value="o">Jiný</option>
-        </select>
-      </td></tr><tr><td colspan='2'>
-        <label for="typ">Popis chyby:</label></td></tr><tr><td colspan='2'>
-        <textarea name="popis" id="popis" rows="5" cols="50" style="width:474px;height:100px;"></textarea>
-      </td></tr><tr><td align='left' valign='top'>
-        <input type="submit" value="Nahlásit Chybu" name="send"></td><td>
-      </td></tr>
-  </table></form>
-<?php } elseif( !empty($sql_select['error']) ){ ?>
-  <?php echo $sql_select['error']; ?>
-<br><p><a href="./index.php?id=sendbug">Pokud chcete nějaké chyby nahlásit pokračujte zde.</a></p>
-<?php }; ?>
-<?php
-  };
-?>

db/include/creep.php

-              r110
+              r113
       };
   </script>
+<?php
+  $sql_select = $BasicWiewer->creature($creature);
+?>
 <?php if( empty($sql_select['error']) ){ ?>

db/include/creeps.php

-              r109
+              r113
 <?php
 if($vlozeni_souboru == "OK"){
+?>
+<?php
+  $sql_select = $BasicWiewer->searchCreep($q,$limit,20);
 ?>

db/include/quest.php

-              r82
+              r113
 <?php
 if($vlozeni_souboru == "OK"){
+  $nevyresene=0;
+  $sql_select = $BasicWiewer->quest($quest);
 ?>
 …
     <tr><td width="30%"><table width="100%" border="0" cellspacing="0" cellpadding="0">
       <tr><td>ID Questu: <?php echo $sql_select['quest']['entry']; ?></td></tr>
+      <tr><td>Začíná u:</td></tr>
+      <tr><td style="padding-left:20px;"><?php echo $sql_select['other']['StartNPC']; ?></td></tr>
+      <tr><td>Začíná u: <?php echo $sql_select['other']['StartNPC']; ?></td></tr>
+      <tr><td>Končí u: <?php echo $sql_select['other']['EndNPC']; ?></td></tr>
+<?php if($nevyresene==1){ //nevyřešeno !!!   ?>
       <tr><td>Oblast:</td></tr>
       <tr><td style="padding-left:20px;"><?php echo "???"; ?></td></tr>
+<?php }; ?>
       <tr><td>Level: <?php echo $sql_select['quest']['QuestLevel']; ?></td></tr>
       <tr><td>Počet XP: <?php echo $sql_select['quest']['RewXpOrMoney']; ?></td></tr>
 …
 <?php }; ?>
 <?php $zobrazit=0; if($zobrazit =1){ //nevyřešeno !!!   ?>
+<?php if($nevyresene==1){ //nevyřešeno !!!   ?>
 <?php if( $sql_select['quest']['PrevQuestId']!=0 OR $sql_select['quest']['NextQuestId']!=0 ){ ?>
       <tr><td><b>Návaznost:</b></td></tr>

db/include/questy.php

-              r92
+              r113
 <?php
 if($vlozeni_souboru == "OK"){
+  $sql_select = $BasicWiewer->searchQuest($q,$lvl_d,$lvl_h,$limit,20);
 ?>

db/include/uvod.php

-              r92
+              r113
 klidně pište na ICQ 327671143 nebo na E-mail: HosipLan<!-- spam ochrana -->&#64;<!-- spam ochrana -->seznam.cz</p>
+<?php /*
+// Tohel tady zatím může strašit..
+<h4>Na projektu se podílejí:</h4>
+<?php // test !!!
+<ul id="ucast">
+<li>HosipLan <ul>
+      <li>Základní struktura stránky</li>
+      <li>Základní grafika</li>
+      <li>Hledání questů</li>
+      <li>Základní výpis Questů</li>
+      <li>Základní výpis Creepů</li>
+    </ul></li>
+<li>Bbtrash <ul>
+      <li>Konzultace v nesnázích a psychycká podpora :)</li>
+      <li>Nějaká ta rada ohledně databáze.</li>
+    </ul></li>
+<li>Chronos <ul>
+      <li>Konzultace v nesnázích a psychycká podpora :)</li>
+      <li>Nějaká ta rada ohledně databáze.</li>
+    </ul></li>
+<li>Perihelion <ul>
+      <li>Konzultace v nesnázích a psychycká podpora :)</li>
+      <li>Nějaká ta rada ohledně databáze.</li>
+    </ul></li>
+<li>Borci <ul>
+      <li>Úprava titulního obrázku</li>
+    </ul></li>
+</ul>
+  //$databaseR->resetSelection('class','2','item');
+  //print($databaseR->returnResult()."<br>\n");
-<p>Tímto děkuji všem co se jakkoliv zapojili.</p> */
 ?>

db/index.php

-              r109
+              r113
   if( !empty($session_id) ){ $session = $session_id; };
+/* =========== Security =========== */
+  if( isset($_GET['Database']) OR isset($_POST['Database']) ){ unset($_GET['Database']); unset($_POST['Database']); };
+  if( isset($_GET['DB_read']) OR isset($_POST['DB_read']) ){ unset($_GET['DB_read']); unset($_POST['DB_read']); };
+  if( isset($_GET['Menu']) OR isset($_POST['Menu']) ){ unset($_GET['Menu']); unset($_POST['Menu']); };
+  if( isset($_GET['text']) OR isset($_POST['text']) ){ unset($_GET['text']); unset($_POST['text']); };
+  $klic=array_keys($_POST);
+  for ($i=0;$i<=count($klic)-1;$i++) {
+    $_POST[$klic[$i]]=addslashes($_POST[$klic[$i]]);
+  };
+  $klic=array_keys($_GET);
+  for ($i=0;$i<=count($klic)-1;$i++) {
+    $_GET[$klic[$i]]=addslashes($_GET[$klic[$i]]);
+  };
 /* =========== Config aj. =========== */
   require_once "./config.php";
   require_once "./check_database.php";
+  require_once "./functions.php";
+  $databaseR = new CheckDatabaseArray();
 /* =========== Připojení k Databázi =========== */
 …
 /* =========== Login / Logout =========== */
+  @mysql_select_db($Config['DB_read']['DB_read']['Database_realmd'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>");
+  @mysql_query("SET CHARACTER SET utf8");
+  SwitchDB(2); // nastavení databáze na realmd
   if( !empty($_POST['username']) AND !empty($_POST['pass']) ){
 …
         $login_info = @MySQL_Fetch_Array($sql_user);
+      @mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+        OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>");
+      @mysql_query("SET CHARACTER SET utf8");
+      SwitchDB(3); // nastavení databáze na web
           $sql_active_id_dotaz = @mysql_query("SELECT * FROM `acc_online` WHERE `nick`='".$login_info['username']."' LIMIT 1");
 …
       };
+  @mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>");
+  @mysql_query("SET CHARACTER SET utf8");
+  SwitchDB(3); // nastavení databáze na web
   if( $_GET['id'] == "logout" ){
 …
   $Menu = array_merge($Menu, $Menu_add);
-/* =========== Speciální FCE =========== */
-  function DelNl($str){
-    $str = @str_replace("\n","",$str);
-    $str = @str_replace("\r","",$str);
-    return $str;
-    };
-  function AbsCheck($int){ return (abs($int)==$int)? true : false; };
-  function CheckQuestRace(){
-    return true;
-    };
-  function StranovaniVypisu($sql, $limit, $nastranu, $adresa, $SID){
-    global $text;
-    $pocet_radku = @mysql_num_rows(mysql_query($sql));
-    if( $pocet_radku > 0 ) {
-      $listovani = $pocet_radku/10;
-      $listovani = ceil($listovani);
-      $listovani = $listovani/($nastranu/10);
-      $listovani = ceil($listovani);
-      if( $listovani == 1 ){
-        $navigace = "&lt;&lt; &nbsp; &lt; <b>1</b> &gt; &nbsp; &gt;&gt;";
+        }
-      elseif( $listovani > 1 ){
-        $predchozi = $limit-1;
-        $dalsi = $limit+1;
-        $posledni = $listovani;
-        if( $predchozi < 1 ){ $predchozi = 1; };
-        if( $listovani <= 10 ){
-          for( $i=1; ($i<=10)AND($i<=$listovani) ;$i++ ){
-            if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
-            else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
-            };
-          $navigace['zacatek'] = "<a href=\"index.php".$adresa."&amp;list=1".$SID."\" title=\"".$text['navigation']['start']."\">&lt;&lt;</a>"." &nbsp; ";
-          $navigace['zacatek'] .= "<a href=\"index.php".$adresa."&amp;list=".$predchozi.$SID."\" title=\"".$text['navigation']['previous']."\">&lt;</a> ";
-          $navigace['konec'] = " <a href=\"index.php".$adresa."&amp;list=".$dalsi.$SID."\" title=\"".$text['navigation']['next']."\">&gt;</a>"." &nbsp; ";
-          $navigace['konec'] .= "<a href=\"index.php".$adresa."&amp;list=".$posledni.$SID."\" title=\"".$text['navigation']['end']."\">&gt;&gt;</a>";
-          if( $limit == 1 ){ $navigace['zacatek'] = "&lt;&lt;"." &nbsp; &lt; "; };
-          if( $limit == $listovani ){ $navigace['konec'] = " &gt; &nbsp; &gt;&gt;"; };
+          }
-        else{
-          if( $limit <= 6 ){
-            for( $i=1; ($i<=10) ;$i++ ){
-              if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
-              else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
-              }; $navigace['cisla'] .= " ... ";
+            }
-          elseif( $limit >= 6 AND (($limit+6) <= $listovani) ){
-            $navigace['cisla'] .= " ... ";
-            for( $i=$limit-5; ($i<=$limit+5) ;$i++ ){
-              if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
-              else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
-              }; $navigace['cisla'] .= " ... ";
+            }
-          elseif( ($limit+6) >= $listovani ){
-            $navigace['cisla'] .= " ... ";
-            for( $i=$listovani-10; ($i<=$listovani) ;$i++ ){
-              if($i==$limit){$navigace['cisla'] .= " <b title=\"".$text['navigation']['onpage'].$text['navigation']['number']." $i\">".$i."</b>\n";}
-              else{$navigace['cisla'] .= " <a href=\"index.php".$adresa."&amp;list=".$i.$SID."\" title=\"".$text['navigation']['page'].$text['navigation']['number']." $i\">".$i."</a>\n";};
-              };
-            };
-          $navigace['zacatek'] = "<a href=\"index.php".$adresa."&amp;list=1".$SID."\" title=\"".$text['navigation']['start']."\">&lt;&lt;</a>"." &nbsp; ";
-          $navigace['zacatek'] .= "<a href=\"index.php".$adresa."&amp;list=".$predchozi.$SID."\" title=\"".$text['navigation']['previous']."\">&lt;</a> ";
-          $navigace['konec'] = " <a href=\"index.php".$adresa."&amp;list=".$dalsi.$SID."\" title=\"".$text['navigation']['next']."\">&gt;</a>"." &nbsp; ";
-          $navigace['konec'] .= "<a href=\"index.php".$adresa."&amp;list=".$posledni.$SID."\" title=\"".$text['navigation']['end']."\">&gt;&gt;</a>";
-          if( $limit == 1 ){ $navigace['zacatek'] = "&lt;&lt;"." &nbsp; &lt; "; };
-          if( $limit == $listovani ){ $navigace['konec'] = " &gt; &nbsp; &gt;&gt;"; };
-          };
-        $navigace = $navigace['zacatek'].$navigace['cisla'].$navigace['konec'];
-        };
-      return $navigace;
+      }
-    else{ return FALSE; };
-    };
-  function SQLselect_Strankovani($dotaz, $limit, $nastranu, $adresa, $SID){
-    $navigace = StranovaniVypisu($dotaz, $limit, $nastranu, $adresa, $SID);
-    $dotaz =  @mysql_query($dotaz." LIMIT ".(--$limit*10*($nastranu/10)).", $nastranu ");
-    $vysledek = array( '1'           => $dotaz,
-                       'strankovani' => $navigace );
-    return $vysledek;
-    };
-  function GenerateMenu(){
-    global $Menu;
-    $klice = array_keys($Menu);
-    $klice_count = count($klice);
-    for($i=0; $i <= $klice_count ;$i++){
-        if($Menu[$klice[$i]][0] == 1){
-        if( $inside_submenu == 1 ){ $Generated_Menu .= "          </ul></li>\n"; }
-        elseif( !empty($Generated_Menu) ){ $Generated_Menu .= "</li>\n"; } unset($inside_submenu);
-          $Generated_Menu .= "          <li><a href=\"".$Menu[$klice[$i]][1]."\">".$Menu[$klice[$i]][2]."</a>";
-        $submenu = 1;
+        }
-      elseif($Menu[$klice[$i]][0] == 2){
-        if( $submenu == 1 ){ $Generated_Menu .= "<ul>\n"; }; unset($submenu);
-          $Generated_Menu .= "            <li><a href=\"".$Menu[$klice[$i]][1]."\">".$Menu[$klice[$i]][2]."</a></li>\n";
-        $inside_submenu = 1;
+        }
-      elseif($Menu[$klice[$i]][0] == 3){
-        if( $submenu == 1 ){ $Generated_Menu .= "<ul>"; }; unset($submenu);
-          $Generated_Menu .= "          <li>".$Menu[$klice[$i]][1]."</li>\n";
-        $inside_submenu = 1;
+        }
-      elseif( !empty($Menu[$klice[$i]][0]) AND !empty($Menu[$klice[$i]][1]) AND !empty($Menu[$klice[$i]][2]) ){
-        $Generated_Menu .= "          <li><a href=\"#\">Chyba !!</a>"; }
-      else{ $Generated_Menu .= "          </ul></li>\n"; };
-      };
-    return $Generated_Menu;
-    };
 /* =========== END_TOP =========== */
   $vlozeni_souboru = "OK";
 …
     /* =========== Výchozí databáze =========== */
+    @mysql_select_db($Config['DB_read']['DB_read']['Database_mangos'])
+      OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");
+    SwitchDB(1); // nastavení databáze na mangos
+    switch($id){
+      case 'character': $general_include = "./character.php"; break;
+      default: $general_include = "./hlavni.php"; break;
+      };
     /* =========== Vložení základního souboru =========== */
 …
     require_once "./post_read.php";
+    require_once "./hlavni.php";
+    $BasicWiewer = new BasicWiewer();
+    $BasicWiewer->setPage($id,$SID);
+    require_once $general_include;
   mysql_close(); // odpojíme se od databáze

db/post_read.php

-              r109
+              r113
 if($vlozeni_souboru == "OK"){
+if( !empty($q) AND !empty($id) ){
+  if( $id == "questy" ){
+    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%' ) ORDER BY `entry` ASC", $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\">";
+  class BasicWiewer{
+    var $q; // dotaz na vyhledávání
+    var $id; // současná stránka
+    var $limit; // současná stránka
+    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
+    var $SID; // proměnná obsahující imformaci o přihlášení pro předání na konec každého odkazu
+    // 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 $bug; // GUID Bugu
+    var $creature; // GUID Creepa
+    var $item; // GUID Itemu
+    // nastavuje vstupní hodnoty
+    public function setPage($id,$SID){
+      $this->id = $id;
+      $this->sid = $SID;
+      }
+    public function searchQuest($q,$lvl_d,$lvl_h,$limit,$nastranu){
+      $this->q = $q;
+      $this->lvl_d = $lvl_d;
+      $this->lvl_h = $lvl_h;
+      $this->limit = $limit;
+      $this->nastranu = $nastranu;
+      $this->searchQuests(); // vykonáme hledání
+      return $this->sql_select;
+      }
+    public function searchCreep($q,$limit,$nastranu){
+      $this->q = $q;
+      $this->limit = $limit;
+      $this->nastranu = $nastranu;
+      $this->searchCreeps(); // vykonáme hledání
+      return $this->sql_select;
+      }
+    public function quest($quest){
+      $this->quest = $quest;
+      $this->showQuest(); // získání dat o Questu
+      return $this->sql_select;
+      }
+    public function bugs($bug,$limit,$nastranu){
+      $this->bug = $bug;
+      $this->limit = $limit;
+      $this->nastranu = $nastranu;
+      $this->showBugs(); // vrací všechny chyby i s navigací pro listování
+      return $this->sql_select;
+      }
+    public function bug($bug){
+      $this->bug = $bug;
+      $this->showBug(); // získání dat o konkrétním bugu
+      return $this->sql_select;
+      }
+    public function bugSend(){
+      $this->sendBug();
+      return $this->sql_select;
+      }
+    public function creature($creature){
+      $this->creature = $creature;
+      $this->showCreature(); // získání dat o Creepovy
+      return $this->sql_select;
+      }
+    public function item($item){
+      $this->item = $item;
+      # need to complete !!!
+      return $this->sql_select;
+      }
+    public function myAcc(){
+      $this->showMyAcc(); // získání dat o užvatelově účtu
+      return $this->sql_select;
+      }
+  /* ==================================================
+   * searchQuests()
+   *
+   * Tato funkce vyhledává
+   * v databázi questy
+   *
+  ================================================== */
+    function searchQuests(){
+      if( !empty($this->q) AND $this->id == "questy" ){
+        if( !empty($this->lvl_d) AND !empty($this->lvl_h) ){
+          $where = "(`MinLevel`>='".$this->lvl_d."' AND `MinLevel`<='".$this->lvl_h."') AND ";
+          };
+        $this->sql_select = SQLselect_Strankovani("SELECT * FROM `quest_template` WHERE ( $where`Title` LIKE '%$q%' ) ORDER BY `entry` ASC", $this->limit, $this->nastranu, "?id=questy&amp;q=".$this->q."&amp;lvl_d=".$this->lvl_d."&amp;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";
+          $this->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($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>".$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>";
+                };
+            $this->sql_select['result'] .= "</td>";
+            $this->sql_select['result'] .= "<td>".$result['Objectives']."</td>";
+            $this->sql_select['result'] .= "</tr>\n";
+            };
+          $this->sql_select['result'] .= "</table>\n";
+          }
+        else{
+          $this->sql_select['error'] = "<p>Nebyly nalezeny žádné questy.</p>";
+          };
+        return true;
+        };
+      return false;
+      }
+  /* ==================================================
+   * searchCreeps()
+   *
+   * Tato funkce vyhledává
+   * v databázi creepy
+   *
+  ================================================== */
+    function searchCreeps(){
+      if( !empty($this->q) AND $this->id == "creeps" ){
+          $this->sql_select = SQLselect_Strankovani("SELECT * FROM `creature_template` WHERE ( `name` LIKE '%".$this->q."%' OR `subname` LIKE '%".$this->q."%' ) ORDER BY `entry` ASC", $this->limit, $this->nastranu, "?id=creeps&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 creepa</td><td>Level</td></tr></thead>\n<col><col width=\"70px\">";
+            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>";
+              if( $result['rank'] != 3 ){
+                $this->sql_select['result'] .= "<td align='center'>".$result['minlevel']." - ".$result['maxlevel']."</td>";
+                }
+              else{
+                $this->sql_select['result'] .= "<td align='center'>Boss</td>";
+                };
+              $this->sql_select['result'] .= "</tr>\n";
+              };
+            $this->sql_select['result'] .= "</table>\n";
+            }  else{ $this->sql_select['error'] = "<p>Nebyly nalezeny žádní creepové.</p>"; };
+        return true;
+        };
+      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: $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_NPC['entry']."\"".$sql_select['other']['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);
+              $this->sql_select['other']['SrcItemId'] .= "<a href=\"index.php?item=".$SrcItemId['entry']."\">".$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).   */
+      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>";
+        $sql_select['result'] .= "<td>".$result['MinLevel']."</td>";
+        $sql_select['result'] .= "<td>";
+          }
+        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(){
+      if( is_numeric($this->creature) AND empty($this->id) ){
+        $this->sql_select['sql'] = mysql_query("SELECT * FROM creature_template WHERE `entry`='".$this->creature."' LIMIT 1");
+        if( @mysql_num_rows($this->sql_select['sql']) > 0 ){
+          $this->sql_select['creature'] = MySQL_Fetch_Array($this->sql_select['sql']);
+          $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) ){
+            $sql_select['result'] .= "<a href=\"index.php?creature=".$start_creature['entry']."\">".$start_creature['name']."</a><br>";
+          switch($sql_select['creature']['rank']){
+            case 0: $sql_select['other']['creature_type'] = "Normal"; break;
+            case 1: $sql_select['other']['creature_type'] = "Elite"; break;
+            case 2: $sql_select['other']['creature_type'] = "Rare Elite"; break;
+            case 3: $sql_select['other']['creature_type'] = "World Boss"; break;
+            case 4: $sql_select['other']['creature_type'] = "Rare"; break;
             };
+          $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) ){
+            $sql_select['result'] .= "<a href=\"index.php?gameobject=".$start_gameobject['entry']."\">".$start_gameobject['name']."</a><br>";
+          $questy_dotaz_creature = mysql_query("SELECT * FROM `creature_questrelation` LEFT JOIN `quest_template` ON `creature_questrelation`.`quest` = `quest_template`.`entry` WHERE (`creature_questrelation`.`id` =".$this->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)){
+                $this->sql_select['other']['creature_quests'] .= "<a href=\"index.php?quest=".$quest_NPC['entry']."\">".$quest_NPC['Title']."</a><br>\n";
+              }; };
+          $drop_creature = mysql_query("SELECT * FROM `creature_loot_template` LEFT JOIN `item_template` ON `creature_loot_template`.`item` = `item_template`.`entry` WHERE `creature_loot_template`.`entry`='".$this->sql_select['creature']['lootid']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+            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>";
+                $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>"; };
+          $pickpocket_creature = mysql_query("SELECT * FROM `pickpocketing_loot_template` LEFT JOIN `item_template` ON `pickpocketing_loot_template`.`item` = `item_template`.`entry` WHERE `pickpocketing_loot_template`.`entry`='".$this->sql_select['creature']['pickpocketloot']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+            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>";
+                $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>"; };
+          $skin_creature = mysql_query("SELECT * FROM `skinning_loot_template` LEFT JOIN `item_template` ON `skinning_loot_template`.`item` = `item_template`.`entry` WHERE `skinning_loot_template`.`entry`='".$sql_select['creature']['skinloot']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+            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>";
+                $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>"; };
+            }
+          else{
+            $this->sql_select['error'] = "<p>Creep nebyl nalezen.</p>";
             };
+        $sql_select['result'] .= "</td>";
+        $sql_select['result'] .= "<td>".$result['Objectives']."</td>";
+        $sql_select['result'] .= "</tr>\n";
+        };
+      $sql_select['result'] .= "</table>\n";
+      }  else{ $sql_select['error'] = "<p>Nebyly nalezeny žádné questy.</p>"; };
+    }
+  elseif( $id == "creeps" ){
+    $sql_select = SQLselect_Strankovani("SELECT * FROM `creature_template` WHERE ( `name` LIKE '%$q%' OR `subname` LIKE '%$q%' ) ORDER BY `entry` ASC", $limit, 20, "?id=creeps&amp;q=".$q, $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 creepa</td><td>Level</td></tr></thead>\n<col><col width=\"70px\">";
+      while( $result = MySQL_Fetch_Array($sql_select[1]) ){
+        $sql_select['result'] .= "  <tr valign='top'>";
+        $sql_select['result'] .= "<td><a href=\"index.php?creature=".$result['entry']."\">".$result['name']."</a></td>";
+        if( $result['rank'] != 3 ){
+          $sql_select['result'] .= "<td align='center'>".$result['minlevel']." - ".$result['maxlevel']."</td>";
+          }
+        else{
+          $sql_select['result'] .= "<td align='center'>Boss</td>";
+          };
+        $sql_select['result'] .= "</tr>\n";
+        };
+      $sql_select['result'] .= "</table>\n";
+      }  else{ $sql_select['error'] = "<p>Nebyly nalezeny žádní creepové.</p>"; };
+    };
+  }
+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!</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;
+    switch($sql_select['creature']['rank']){
+      case 0: $sql_select['other']['creature_type'] = "Normal"; break;
+      case 1: $sql_select['other']['creature_type'] = "Elite"; break;
+      case 2: $sql_select['other']['creature_type'] = "Rare Elite"; break;
+      case 3: $sql_select['other']['creature_type'] = "World Boss"; break;
+      case 4: $sql_select['other']['creature_type'] = "Rare"; break;
+      };
+    $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";
+        }; };
+    $drop_creature = mysql_query("SELECT * FROM `creature_loot_template` LEFT JOIN `item_template` ON `creature_loot_template`.`item` = `item_template`.`entry` WHERE `creature_loot_template`.`entry`='".$sql_select['creature']['lootid']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+      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;
+            };
+          $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>";
+          $sql_select['other']['creature_drop'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+        }; } else{ $sql_select['other']['creature_drop'] = "<tr><td colspan='2'>Tento creep nemá žádný drop !</td></tr>"; };
+    $pickpocket_creature = mysql_query("SELECT * FROM `pickpocketing_loot_template` LEFT JOIN `item_template` ON `pickpocketing_loot_template`.`item` = `item_template`.`entry` WHERE `pickpocketing_loot_template`.`entry`='".$sql_select['creature']['pickpocketloot']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+      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;
+            };
+          $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>";
+          $sql_select['other']['creature_pickpocket'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+        }; } else{ $sql_select['other']['creature_pickpocket'] = "<tr><td colspan='2'>Tento creep nemá žádný Pickpocket !</td></tr>"; };
+    $skin_creature = mysql_query("SELECT * FROM `skinning_loot_template` LEFT JOIN `item_template` ON `skinning_loot_template`.`item` = `item_template`.`entry` WHERE `skinning_loot_template`.`entry`='".$sql_select['creature']['skinloot']."' ORDER BY `Quality` DESC, `ChanceOrRef` DESC ");
+      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;
+            };
+          $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>";
+          $sql_select['other']['creature_skin'] .= "<td>".$drop_NPC['ChanceOrRef']."%</td></tr>\n";
+        }; } else{ $sql_select['other']['creature_skin'] = "<tr><td colspan='2'>Tento creep nemá žádný Skin !</td></tr>"; };
+    } else{ $sql_select['error'] = "<p>Creep nebyl nalezen.</p>"; };
+  }
+elseif( $id == "bugreport" AND empty($bug) ){
+  mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");
+  $sql_select = SQLselect_Strankovani("SELECT * FROM `bug_report` ORDER BY `opraveno` ASC, `vlozeno` DESC", $limit, 20, "?id=bugreport", $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>Vloženo</td><td>Chyba</td><td align='right'>Status</td></tr></thead>\n<col width=\"120px\"><col><col width=\"60px\">";
+    while( $result = MySQL_Fetch_Array($sql_select[1]) ){
+      $sql_select['result'] .= "<tr><td valign='top'>";
+      $sql_select['result'] .= "<a href=\"./index.php?id=bugreport&amp;bug=".$result['id']."\">".@date("d.m.Y H:i", $result['vlozeno'])."</a>";
+      $sql_select['result'] .= "</td><td valign='top'>";
+      $sql_select['result'] .= nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $result['popis']));
+      $sql_select['result'] .= "</td><td valign='top' align='right'>";
+      if( $result['opraveno'] == 0 ){
+        $sql_select['result'] .= "<img src=\"img/aff_cross.gif\" alt=\"ne\" height=\"16\" width=\"16\">"; }
+      elseif( $result['opraveno'] == 1 ){
+        $sql_select['result'] .= "<img src=\"img/aff_tick.gif\" alt=\"ne\" height=\"16\" width=\"16\">"; }
+      $sql_select['result'] .= "</td></tr>\n";
+      };
+    $sql_select['result'] .= "</table>\n";
+    } else{ $sql_select['error'] .= "<p>V databázi nejsou záznamy o chybách.</p>"; };
+  }
+elseif( $id == "bugreport" AND !empty($bug) ){
+  mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");
+  $sql_select['sql'] = mysql_query("SELECT * FROM `bug_report` WHERE id=$bug LIMIT 1");
+  if( @mysql_num_rows($sql_select['sql']) > 0 ){
+    $result = MySQL_Fetch_Array($sql_select['sql']);
+      $sql_select['bug'] = $result;
+      if( empty($sql_select['bug']['opravil_nick']) ){
+        $sql_select['bug']['opravil_nick'] = "Zatím nikdo"; };
+      if( $sql_select['bug']['opraveno'] == 0 ){
+        $sql_select['bug']['opraveno'] = "<img src=\"img/aff_cross.gif\" alt=\"ne\" height=\"16\" width=\"16\"> Čeká na vyřízení"; }
+      elseif( $sql_select['bug']['opraveno'] == 1 ){
+        $sql_select['bug']['opraveno'] = "<img src=\"img/aff_tick.gif\" alt=\"ne\" height=\"16\" width=\"16\"> Opraveno"; }
+    } else{ $sql_select['error'] = "<p>V databázi není záznam s touto chybou.</p>"; };
+  }
+elseif( $id == "sendbug" AND isset($_POST['send']) ){
+  mysql_select_db($Config['DB_read']['DB_read']['Database_web'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_web']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");
+  $sql_insert['sql'] = "INSERT INTO `bug_report` (`nick`,`typ`,`vlozeno`,`popis`) VALUES('".$_POST['game_nick']."','".$_POST['err_type']."','".time()."','".$_POST['popis']."')";
+  if( mysql_query($sql_insert['sql']) ){
+    $sql_insert['result'] = "<p>Bug byl uložen do databáze.</p>";
+    }
+  else{ $sql_insert['result'] = "<p>Bug se nepodařilo uložit do databáze.<br>Zkuste to později znovu prosím.</p>"; };
+  }
+elseif( $id == "myacc" ){
+  mysql_select_db($Config['DB_read']['DB_read']['Database_realmd'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_realmd']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");
+  $sql_select['sql'] = mysql_query("SELECT * FROM `account` WHERE `username`='".$user['nick']."' LIMIT 1");
+  $sql_select['result']['acc'] = @mysql_fetch_array($sql_select['sql']);
+  mysql_select_db($Config['DB_read']['DB_read']['Database_mangos'])
+    OR DIE("<p>Nepodařilo se nastavit pracovní databázi ".$Config['DB_read']['DB_read']['Database_mangos']."!</p>");
+    @mysql_query("SET CHARACTER SET utf8");
+  $sql_select['sql'] = mysql_query("SELECT * FROM `character` WHERE `account`='".$sql_select['result']['acc']['id']."' ");
+  $sql_select['result']['char_count'] = @mysql_num_rows($sql_select['sql']);
+  for($i=0;$sql_select['result']['char'][$i] = @mysql_fetch_array($sql_select['sql']) ;$i++){
+    $sql_select['result']['char'][$i]['data'] = explode(" ", $sql_select['result']['char'][$i]['data']);
+    };
+  switch($sql_select['result']['acc']['gmlevel']){
+    case 0: $sql_select['result']['other']['opravneni'] = "Player"; break;
+    case 1: $sql_select['result']['other']['opravneni'] = "Moderator"; break;
+    case 2: $sql_select['result']['other']['opravneni'] = "GameMaster"; break;
+    case 3: $sql_select['result']['other']['opravneni'] = "Administrator"; break;
+    default: $sql_select['result']['other']['opravneni'] = "unknown";
+    };
+  switch($sql_select['result']['acc']['tbc']){
+    case 0: $sql_select['result']['other']['version'] = "Normal"; break;
+    case 1: $sql_select['result']['other']['version'] = "Burning Crusade"; break;
+    };
+  $sql_select['result']['other']['chars'] .= "<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\n";
+  for($i=0; $i < $sql_select['result']['char_count'] ;$i++){
+    $sql_select['result']['other']['chars'] .= "<tr><td>".$sql_select['result']['char'][$i]['name']."</td>";
+    $sql_select['result']['other']['chars'] .= "<td title=\"Level\">".$sql_select['result']['char'][$i]['data'][34]."</td>";
+    $sql_select['result']['other']['chars'] .= "<td title=\"Rasa\">".$Database['race'][$sql_select['result']['char'][$i]['race']]."</td>";
+    $sql_select['result']['other']['chars'] .= "<td title=\"Povolání\">".$Database['class'][$sql_select['result']['char'][$i]['class']]."</td>\n";
+    $sql_select['result']['other']['chars'] .= "<td> - <a href=\"./character.php?char=".$sql_select['result']['char'][$i]['guid']."\">Exportovat</a></td></tr>\n";
+    }; $sql_select['result']['other']['chars'] .= "</table>";
+  };
+        return true;
+        };
+      return false;
+      }
+  /* ==================================================
+   * showBugs()
+   * showBug()
+   * sendBug()
+   *
+   * Tyto funkce jsou určeny pro práci s Bugreporterem
+   * showBugs() - vypisuje všechny bugy
+   * showBug() - vrátí konkrétní bug
+   * sendBug() - odesílá nový bug do databáze
+   *
+  ================================================== */
+    function showBugs(){
+      if( $this->id == "bugreport" AND empty($this->bug) ){
+        SwitchDB(3); // nastavení databáze na web
+        $this->sql_select = SQLselect_Strankovani("SELECT * FROM `bug_report` ORDER BY `opraveno` ASC, `vlozeno` DESC", $this->limit, $this->nastranu, "?id=bugreport", $this->sid);
+        if( @mysql_num_rows($this->sql_select[1]) > 0 ){
+          $this->sql_select['result'] .= "<table width=\"100%\" class=\"search_result\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\n";
+          $this->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\">\n";
+          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'] .= "</td><td valign='top'>";
+            $this->sql_select['result'] .= nl2br(preg_replace(array("(\<)","(\>)"), array("&#60;","&#62;"), $result['popis']));
+            $this->sql_select['result'] .= "</td><td valign='top' align='right'>";
+            if( $result['opraveno'] == 0 ){
+              $this->sql_select['result'] .= "<img src=\"img/aff_cross.gif\" alt=\"ne\" height=\"16\" width=\"16\">"; }
+            elseif( $result['opraveno'] == 1 ){
+              $this->sql_select['result'] .= "<img src=\"img/aff_tick.gif\" alt=\"ne\" height=\"16\" width=\"16\">"; }
+            $this->sql_select['result'] .= "</td></tr>\n";
+            };
+          $this->sql_select['result'] .= "</table>\n";
+          }
+        else{
+          $this->sql_select['error'] .= "<p>V databázi nejsou záznamy o chybách.</p>";
+          };
+        return true;
+        };
+      return false;
+      }
+    function showBug(){
+      if( $this->id == "bugreport" AND !empty($this->bug) ){
+        SwitchDB(3); // nastavení databáze na web
+        $this->sql_select['sql'] = mysql_query("SELECT * FROM `bug_report` WHERE id=".$this->bug." LIMIT 1");
+        if( @mysql_num_rows($this->sql_select['sql']) > 0 ){
+          $this->sql_select['bug'] = MySQL_Fetch_Array($this->sql_select['sql']);
+            if( empty($this->sql_select['bug']['opravil_nick']) ){
+              $this->sql_select['bug']['opravil_nick'] = "Zatím nikdo"; };
+            if( $this->sql_select['bug']['opraveno'] == 0 ){
+              $this->sql_select['bug']['opraveno'] = "<img src=\"img/aff_cross.gif\" alt=\"ne\" height=\"16\" width=\"16\"> Čeká na vyřízení"; }
+            elseif( $this->sql_select['bug']['opraveno'] == 1 ){
+              $this->sql_select['bug']['opraveno'] = "<img src=\"img/aff_tick.gif\" alt=\"ne\" height=\"16\" width=\"16\"> Opraveno"; }
+          }
+        else{
+          $this->sql_select['error'] = "<p>V databázi není záznam s touto chybou.</p>";
+          };
+        return true;
+        };
+      return false;
+      }
+    function sendBug(){
+      global $_POST;
+      if( $this->id == "sendbug" AND isset($_POST['send']) ){
+        SwitchDB(3); // nastavení databáze na web
+        $sql_insert['sql'] = "INSERT INTO `bug_report` (`nick`,`typ`,`vlozeno`,`popis`) VALUES('".$_POST['game_nick']."','".$_POST['err_type']."','".time()."','".$_POST['popis']."')";
+        if( mysql_query($sql_insert['sql']) ){
+          $this->sql_select['result'] = "<p>Bug byl uložen do databáze.</p>";
+          }
+        else{
+          $this->sql_select['result'] = "<p>Bug se nepodařilo uložit do databáze.<br>Zkuste to později znovu prosím.</p>";
+          };
+        return true;
+        };
+      return false;
+      }
+  /* ==================================================
+   * showMyAcc()
+   *
+   * Tato funkce vrací informace o uživatelově účtu
+   *
+  ================================================== */
+    function showMyAcc(){
+      global $user, $Database;
+      if( $this->id == "myacc" ){
+        SwitchDB(2); // nastavení databáze na realmd
+        $sql_select['sql'] = mysql_query("SELECT * FROM `account` WHERE `username`='".$user['nick']."' LIMIT 1");
+        $this->sql_select['result']['acc'] = @mysql_fetch_array($sql_select['sql']);
+        SwitchDB(1); // nastavení databáze na mangos
+        $sql_select['sql'] = mysql_query("SELECT * FROM `character` WHERE `account`='".$this->sql_select['result']['acc']['id']."' ");
+        $this->sql_select['result']['char_count'] = @mysql_num_rows($sql_select['sql']);
+        for($i=0;$this->sql_select['result']['char'][$i] = @mysql_fetch_array($sql_select['sql']) ;$i++){
+          $this->sql_select['result']['char'][$i]['data'] = explode(" ", $this->sql_select['result']['char'][$i]['data']);
+          };
+        switch($this->sql_select['result']['acc']['gmlevel']){
+          case 0: $this->sql_select['result']['other']['opravneni'] = "Player"; break;
+          case 1: $this->sql_select['result']['other']['opravneni'] = "Moderator"; break;
+          case 2: $this->sql_select['result']['other']['opravneni'] = "GameMaster"; break;
+          case 3: $this->sql_select['result']['other']['opravneni'] = "Administrator"; break;
+          default: $this->sql_select['result']['other']['opravneni'] = "unknown";
+          };
+        switch($this->sql_select['result']['acc']['tbc']){
+          case 0: $this->sql_select['result']['other']['version'] = "Normal"; break;
+          case 1: $this->sql_select['result']['other']['version'] = "Burning Crusade"; break;
+          };
+        $this->sql_select['result']['other']['chars'] .= "<table border=\"0\" cellspacing=\"0\" cellpadding=\"2\">\n";
+        for($i=0; $i < $this->sql_select['result']['char_count'] ;$i++){
+          $this->sql_select['result']['other']['chars'] .= "<tr><td>".$this->sql_select['result']['char'][$i]['name']."</td>";
+          $this->sql_select['result']['other']['chars'] .= "<td title=\"Level\">".$this->sql_select['result']['char'][$i]['data'][34]."</td>";
+          $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'] .= "</table>";
+        return true;
+        };
+      return false;
+      }
+    }; // konec třídy
   }; // vložení souboru

Note: See TracChangeset for help on using the changeset viewer.

Context Navigation

Changeset 113 for db

Legend:

Download in other formats: