Changeset 113 for db/check_database.php


Ignore:
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ů

File:
1 edited

Legend:

Unmodified
Added
Removed
  • db/check_database.php

    r109 r113  
    11<?php
    2 if($vlozeni_souboru == "OK"){
     2
     3$Database = array(
     4  'class' => array(
     5    1 => "Warrior",
     6    2 => "Paladin",
     7    3 => "Hunter",
     8    4 => "Rogue",
     9    5 => "Priest",
     10    6 => "",
     11    7 => "Shaman",
     12    8 => "Mage",
     13    9 => "Warlock",
     14    10 => "",
     15    11 => "Druid"
     16    ),
     17  'race' => array(
     18    1 => "Human",
     19    2 => "Orc",
     20    3 => "Dwarf",
     21    4 => "Night Elf",
     22    5 => "Undead",
     23    6 => "Tauren",
     24    7 => "Gnome",
     25    8 => "Troll",
     26    9 => "",
     27    10 => "Blood Elf",
     28    11 => "Dranei"
     29    ),
     30  'item' => array(
     31    'class' => array(
     32      0 => "Consumable",
     33      1 => "Container",
     34      2 => "Weapon",
     35      4 => "Armor",
     36      5 => "Reagent",
     37      6 => "Projectile",
     38      7 => "Trade Goods",
     39      9 => "Recipe",
     40      11 => "Quiver",
     41      12 => "Quest",
     42      13 => "Key",
     43      15 => "Miscellaneous"
     44      ),
     45    'subclass' => array(
     46      0 => array( // Consumable
     47        1 => "Food",
     48        2 => "Liquid",
     49        3 => "Potion (usable in combat)",
     50        4 => "Scroll (usable in combat)",
     51        5 => "Bandage (usable in combat)",
     52        6 => "Healthstone (usable in combat)",
     53        7 => "Combat Effect (usable in combat)"
     54        ),
     55      2 => array( // Weapon
     56        0 => "One Handed Axe",
     57        1 => "Two Handed Axe",
     58        2 => "Bow",
     59        3 => "Rifle",
     60        4 => "One Handed Mace",
     61        5 => "Two Handed Mace",
     62        6 => "Polearm",
     63        7 => "One Handed Sword",
     64        8 => "Two Handed Sword",
     65        10 => "Staff",
     66        11 => "One Handed Exotic",
     67        12 => "Two Handed Exotic",
     68        13 => "Fist Weapon",
     69        14 => "Miscellaneous Weapon",
     70        15 => "Dagger",
     71        16 => "Thrown",
     72        17 => "Spear",
     73        18 => "Crossbow",
     74        19 => "Wand",
     75        20 => "Fishing Pole"
     76        ),
     77      4 => array( // Armor
     78        0 => "Miscellaneous",
     79        1 => "Cloth",
     80        2 => "Leather",
     81        3 => "Mail",
     82        4 => "Plate",
     83        6 => "Shield"
     84        ),
     85      6 => array( // Projectile
     86        2 => "Arrows",
     87        3 => "Bullets"
     88        ),
     89      7 => array( // Trade Goods
     90        0 => "Trade Goods",
     91        1 => "Parts",
     92        2 => "Explosives",
     93        3 => "Devices"
     94        ),
     95      9 => array( // Recipe
     96        0 => array("Book"),
     97        1 => array("Pattern","Leatherworking"),
     98        2 => array("Pattern","Tailoring"),
     99        3 => array("Schematic","Engineering"),
     100        4 => array("Plans","Blacksmithing"),
     101        5 => array("Recipe","Cooking"),
     102        6 => array("Recipe","Alchemy"),
     103        7 => array("Manual","First Aid"),
     104        8 => array("Formula","Enchanting"),
     105        9 => array("Fishing","Manual")
     106        ),
     107      11 => array( // Quiver
     108        2 => array("Quiver","Arrows"),
     109        3 => array("Ammo Pouch","Bullets")
     110        ),
     111      13 => array( // Projectile
     112        2 => "Arrows",
     113        3 => "Bullets"
     114        )
     115      ),
     116    'quality' => array(
     117      0 => array("Grey","Poor"),
     118      1 => array("White","Common"),
     119      2 => array("Green","Uncommon"),
     120      3 => array("Blue","Rare"),
     121      4 => array("Purple","Epic"),
     122      5 => array("Orange","Legendary"),
     123      6 => array("Red","Artifact")
     124      ),
     125    'type' => array(
     126      1 => "binded",
     127      2 => "Conjured",
     128      4 => "Openable item",
     129      16 => "Shield",
     130      32 => "Totem",
     131      64 => "Mount",
     132      256 => "Wand",
     133      512 => "Ribboned Wrapping Paper",
     134      1024 => "Essence",
     135      8192 => "Guild Charter",
     136      32768 => "PvP Reward Item"
     137      ),
     138    'equip' => array(
     139      1 => "Head",
     140      2 => "Neck",
     141      3 => "Shoulder",
     142      4 => "Shirt",
     143      5 => "Chest",
     144      6 => "Waist", // Belt
     145      7 => "Legs", // Pants
     146      8 => "Feet", // Boots
     147      9 => "Wrists", // Bracers
     148      10 => "Hands", // Gloves
     149      11 => "Finger", // Ring
     150      12 => "Trinket",
     151      13 => "One Hand",
     152      14 => "Off Hand", // includes Shield
     153      15 => "Bow",
     154      16 => "Back",
     155      17 => "Two Hand",
     156      18 => "Bag", // include Quivers
     157      19 => "Tabard",
     158      20 => "Robe",
     159      21 => "Main Hand",
     160      22 => "Off Hand", // Misc Items
     161      23 => "Tome",
     162      24 => "Ammunition",
     163      25 => "Thrown",
     164      26 => "Gun"
     165      ),
     166    'AllowableClass' => array(
     167      1 => "Warrior",
     168      2 => "Paladin",
     169      4 => "Hunter",
     170      8 => "Rogue",
     171      16 => "Priest",
     172      64 => "Shaman",
     173      128 => "Mage",
     174      256 => "Warlock",
     175      1024 => "Druid"
     176      ),
     177    'AllowableRace' => array(
     178      1 => "Human",
     179      2 => "Orc",
     180      4 => "Dwarf",
     181      8 => "Night Elf",
     182      16 => "Undead",
     183      32 => "Tauren",
     184      64 => "Gnome",
     185      128 => "Troll",
     186      512 => "Blood elf",
     187      1024 => "Draenei"
     188      ),
     189    'RequiredReputationRank' => array(
     190      0 => "Hated",
     191      1 => "Hostile",
     192      2 => "Unfriendly",
     193      3 => "Neutral",
     194      4 => "Friendly",
     195      5 => "Honored",
     196      6 => "Reverted",
     197      7 => "Exalted",
     198      ),
     199    'stat_type' => array(
     200      0 => "Mana",
     201      1 => "Health",
     202      3 => "Agility",
     203      4 => "Strength",
     204      5 => "Intellect",
     205      6 => "Spirit",
     206      7 => "Stamina",
     207      ),
     208    'dmg_type' => array(
     209      0 => "Physical",
     210      1 => "Holy",
     211      2 => "Fire",
     212      3 => "Nature",
     213      4 => "Frost",
     214      5 => "Shadow",
     215      6 => "Arcane"
     216      ),
     217    'ammo_type' => array(
     218      2 => "Arrows",
     219      3 => "Bullets"
     220      ),
     221    'spell_charges' => array(
     222      0 => "Infinite charges",
     223      'negative' => "Item is expendable",
     224      'positive' => "Item is kept when all charges are spent"
     225      ),
     226    'bonding' => array(
     227      1 => "Binds when Picked Up",
     228      2 => "Binds when Equipped",
     229      3 => "Binds when Used",
     230      4 => "Quest Item"
     231      ),
     232    'bonding' => array(
     233      1 => "Binds when Picked Up",
     234      2 => "Binds when Equipped",
     235      3 => "Binds when Used",
     236      4 => "Quest Item"
     237      ),
     238    'LanguageID' => array(
     239      1 => "Orcish",
     240      2 => "Darnassian",
     241      3 => "Taurahe",
     242      6 => "Dwarvish",
     243      7 => "Common",
     244      8 => "Demonic",
     245      9 => "Titan",
     246      10 => "Thelassian",
     247      11 => "Draconic",
     248      12 => "Kalimag",
     249      13 => "Gnomish",
     250      14 => "Troll",
     251      33 => "Gutterspeak"
     252      ),
     253    'PageMaterial' => array(
     254      1 => "Parchment",
     255      2 => "Stone",
     256      3 => "Marble",
     257      4 => "Silver",
     258      5 => "Bronze"
     259      ),
     260    'Material' => array(
     261      1 => "Metal",
     262      2 => "Wood",
     263      3 => "Liquid",
     264      4 => "Jewelry",
     265      5 => "Chain",
     266      6 => "Plate",
     267      7 => "Cloth",
     268      8 => "Leather"
     269      ),
     270    'sheath' => array(
     271      1 => "Two Handed Sword (on the back; tip down)",
     272      2 => "Staff (on the back; tip up)",
     273      3 => "One Handed Sword (on the side)",
     274      4 => "Shield (on the back)",
     275      5 => "Enchanter's Rod",
     276      7 => "Off Hand",
     277      ),
     278    'BagFamily' => array(
     279      0 => "",
     280      1 => "Arrows",
     281      2 => "Bullets",
     282      3 => "Soul Shards",
     283      6 => "Herbs",
     284      7 => "Enchanting Supp",
     285      8 => "Engineering Supp",
     286      9 => "Keys",
     287      10 => "Gems",
     288      12 => "Mining Supp",
     289      )
     290    ),
     291  'quest' => array(
     292    'ZoneOrSort' => array(
     293      'negative' => array(
     294        1 => "Epic",
     295        21 => "REUSE - old wailing caverns",
     296        22 => "Seasonal",
     297        23 => "REUSE - old undercity one",
     298        24 => "Herbalism",
     299        25 => "REUSE - old scarlet monastery",
     300        41 => "REUSE - old uldaman",
     301        61 => "Warlock",
     302        81 => "Warrior",
     303        82 => "Shaman",
     304        101 => "Fishing",
     305        121 => "Blacksmithing",
     306        141 => "Paladin",
     307        161 => "Mage",
     308        162 => "Rogue",
     309        181 => "Alchemy",
     310        182 => "Leatherworking",
     311        201 => "Engineering",
     312        221 => "Treasure Map",
     313        241 => "REUSE - old sunken temple",
     314        261 => "Hunter",
     315        262 => "Priest",
     316        263 => "Druid",
     317        264 => "Tailoring",
     318        284 => "Special",
     319        304 => "Cooking",
     320        324 => "First Aid",
     321        344 => "Legendary",
     322        364 => "Darkmoon Faire",
     323        365 => "Ahn'Qiraj War",
     324        366 => "Lunar Festival",
     325        367 => "Reputation",
     326        ),
     327      'positive' => "SQL:area_table"
     328      ),
     329    'Type' => array(
     330      1 => "Elite",
     331      21 => "Life",
     332      41 => "PvP",
     333      62 => "Raid",
     334      81 => "Dungeon",
     335      82 => "World Event"
     336      ),
     337/* =====================================
     338
     339RequiredRaces ¶ ??????? need to complete !!!!
     340
     341Races required to get the quest. 0 means available for all races.
     342Field's value is a decimal value that must be transform to a 8 bits binary in order to be understandable.
     343In binary form, each different bit represent a different race. They're assigned as follow :
     344128     64      32      16      8       4       2       1
     345Troll   Gnome   Tauren  Undead  NightElf        Dwarf   Orc     Human
     346
     347Example :
     348Int field value : 77
     349Assigning bits from the left to the right :
     350128     64      32      16      8       4       2       1
     351Troll   Gnome   Tauren  Undead  NightElf        Dwarf   Orc     Human
     3520       1       0       0       1       1       0       1
     353
     354Then, 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.
     355
     356===================================== */
     357    'SpecialFlags' => array(
     358      1 => "Elite",
     359      21 => "Life",
     360      41 => "PvP",
     361      62 => "Raid",
     362      81 => "Dungeon",
     363      82 => "World Event"
     364      )
     365/* =====================================
     366
     367    * QUEST_SPECIAL_FLAGS_NONE = 0
     368    * QUEST_SPECIAL_FLAGS_DELIVER = 1
     369    * QUEST_SPECIAL_FLAGS_EXPLORATION = 2
     370    * QUEST_SPECIAL_FLAGS_SPEAKTO = 4
     371    * QUEST_SPECIAL_FLAGS_KILL_OR_CAST = 8
     372    * QUEST_SPECIAL_FLAGS_TIMED = 16
     373    * Flag 32 unknown
     374    * QUEST_SPECIAL_FLAGS_REPUTATION = 64
     375
     376PrevQuestId ¶
     377
     378If value > 0: Contains the previous quest id, that must be completed before this quest can be started.
     379If value < 0: Contains the parent quest id, that must be active before this quest can be started.
     380If 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.
     381Mangos 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.
     382NextQuestId ¶
     383
     384If value > 0: Contains the next quest id, if PrevQuestId of that quest is not sufficient.
     385If value < 0: Contains the sub quest id, if PrevQuestId of that quest is not sufficient.
     386If 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.
     387ExclusiveGroup ¶
     388
     389if ExclusiveGroup? > 0
     390
     391Allows to define a group of quests of which only one may be chosen and completed.
     392E.g. if from quests 1200, 1201 and 1202 only one should be allowed to be chosen, insert 1200 into ExclusiveGroup of all 3 quests.
     393
     394if ExclusiveGroup? < 0
     395
     396Allows to define a group of quests of which all must be completed and rewarded to start next quest.
     397E.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.
     398NextQuestInChain ¶
     399
     400Defines quest chains, the details of the entered quest will be automatically opened when this quest is completed.
     401Only works when the quest rewarder of this quest is the quest giver of the entered quest.
     402srcItem ¶
     403
     404Item's ID given by the quest giver at beginning of the quest.
     405Items will be deleted when quest is abandoned.
     406srcItemCount ¶
     407
     408Number of Item given at quest start.
     409SrcSpell ¶
     410
     411Spell casted on player when quest is started. Can be a buff or a learning spell.
     412Title ¶
     413
     414Title of the quest.
     415Details ¶
     416
     417Long quest's description.
     418Objectives ¶
     419
     420Objectives of the quest.
     421If empty, quest is an auto-complete quest that can be immediately finished without accepting it first.
     422OfferRewardText ¶
     423
     424First text send to the player by the NPC when completing the quest.
     425RequestItemsText ¶
     426
     427This text ist send to player, yet did not terminate the Quest and speak with NPC again!
     428EndText ¶
     429
     430This text is indicated to the player, if you open your Questlog and wars send to player ingame. No Change this!
     431ObjectiveText1-4 ¶
     432
     433Used to define non-standard objective texts.
     434ReqItemId1-4 ¶
     435
     436Item_template Id of the 1.-4. required item to complete the quest. (if any)
     437ReqItemCount1-4 ¶
     438
     439Amount of 1.-4. required items.
     440ReqSourceId1-4 ¶
     441
     442These 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.
     443
     444The same for ReqSourceId2-4
     445You may define 1, 2, 3 or even all 4 sources for the same ReqItem/ReqSpellCast or use 4 sources for 4 ReqItems/ReqSpellCasts.
     446ReqSourceCount1-4 ¶
     447
     448Amount of ReqSourceId items the player may gather per unfinished ReqItemId or ReqSpellCast.
     449So ReqSourceId1 items will drop up to a total amount of (ReqItemCount(ReqSourceRef1) - already owned ReqItemId(ReqSourceRef1)) * ReqSourceCount1. Same for ReqSpellCast objectives.
     450ReqSourceRef1-4 ¶
     451
     452Should be 0 or 1..4. See ReqSourceId description.
     453ReqCreatureOrGOId1-4 ¶
     454
     455Value > 0: 1.-4. required creature_template ID the player needs to kill/cast on in order to complete the quest.
     456Value < 0: 1.-4. required gameobject_template ID the player needs to cast on in order to complete the quest.
     457If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed.
     458ReqCreatureOrGOCount1-4 ¶
     459
     460Number of kills/casts needed on 1.-4. creature or gameobject.
     461ReqSpellCast1-4 ¶
     462
     463Spell ID of Spell that needs to be cast in order to fulfill a quest objective.
     464If ReqSpellCastN > 0 then at ReqCreatureOrGOIdN must be casted spell ReqSpellCastN, if ReqSpellCastN = 0 then it must be killed.
     465RewChoiceItemId1-6 ¶
     466
     467Id of the 1.-6. Item available for reward choice.
     468RewChoiceItemCount1 ¶
     469
     470Number of Charges in the 1.-6. rewarded item available.
     471RewItemId1-4 ¶
     472
     4731.-4. item Id given for reward (no choice).
     474RewItemCount1-4 ¶
     475
     476Number of RewItem1-4.
     477RewRepFaction1-5 ¶
     478
     479Faction Id (from Faction.dbc in this case) for which the quest give reputation points.
     480RewRepValue1-5 ¶
     481
     482Number of gain or lost reputation points for Faction1-5 at quest completion.
     483This is special reputation rewarding. Normal reputation reward to quest rewarding creature faction calculated and added automatically.
     484RewOrReqMoney ¶
     485
     486Money earned by completing the quest (if value > 0). Money quest requirement (if value < 0).
     487RewXpOrMoney ¶
     488
     489Experience or money (when player's level = maxlevel) given when completing the quest. Only given once for repeatable quests.
     490RewSpell ¶
     491
     492Spell casted at player when completing the quest. This can be learn spell and player learned some spell in result, or buff spell, for example.
     493PointMapId ¶
     494
     495MapId of a quest point of interest (POI).
     496POI will be shown on the map when quest is active.
     497PointX ¶
     498
     499X coordinate of quest POI.
     500PointY ¶
     501
     502Y coordinate of quest POI.
     503PointOpt ¶
     504
     505!!! Need info here : Feel free to document if you know. !!!
     506OfferRewardEmote, RequestItemsEmote ¶
     507
     508Emote that creature show at request quest details, show incompleted quest and completing quest
     509CompleteScript ¶
     510
     511!!! Need info here : Feel free to document if you know. !!!
     512Repeatable ¶
     513
     514Is quest repeatable? 1 yes 0 no
     515
     516===================================== */
     517    ),
     518  'creep' => array(
     519    'type' => array(
     520      1 => "Beast",
     521      2 => "Dragonkin",
     522      3 => "Demon",
     523      4 => "Elemental",
     524      5 => "Giant",
     525      6 => "Undead",
     526      7 => "Humanoid",
     527      8 => "Critter",
     528      9 => "Mechanical",
     529      10 => "Not specified",
     530      11 => "Totem" ),
     531    ),
     532/* =====================================
     533
     534entry ¶
     535
     536Creature's id, related to field creature.guid
     537modelid ¶
     538
     539Graphical model that client must apply on this creature.
     540name ¶
     541
     542Base name of the creature.
     543subname ¶
     544
     545Subname of the creature (if any).
     546minlevel ¶
     547
     548Creature's minimum level. Spawned creature have level in range from minlevel to maxlevel
     549maxlevel ¶
     550
     551Creature's maximum level. Spawned creature have level in range from minlevel to maxlevel
     552minhealth ¶
     553
     554Maximum creature's health points for creature level equal minlevel. Spawned creature have health in linear proportion to level position in range minlevel .. maxlevel
     555maxhealth ¶
     556
     557Maximum creature's health points for creature level equal maxlevel. Spawned creature have health in linear proportion to level position in range minlevel .. maxlevel
     558minmana ¶
     559
     560Maximum creature's mana points for creature level equal minlevel. Spawned creature have mana in linear proportion to level position in range minlevel .. maxlevel
     561maxmana ¶
     562
     563Maximum creature's mana points for creature level equal maxlevel. Spawned creature have mana in linear proportion to level position in range minlevel .. maxlevel
     564armor ¶
     565
     566Creature's armor.
     567Faction ¶
     568
     569Creature's faction. See: CreatureFaction
     570npcflag ¶
     571
     572This 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
     573Is what type of NPC it is. Stored in npc_option.npcflag
     574
     575enum NPCFlags
     576Type    Value   Hex     Comment
     577UNIT_NPC_FLAG_NONE      0       0x00000         you can't speak with npc
     578UNIT_NPC_FLAG_GOSSIP    1       0x00001         you can only speak with npc
     579UNIT_NPC_FLAG_QUESTGIVER        2       0x00002         this npc can give you quest
     580UNIT_NPC_FLAG_VENDOR    4       0x00004         vendor..
     581UNIT_NPC_FLAG_TAXIVENDOR        8       0x00008         gryfon master and oder fly masters ....
     582UNIT_NPC_FLAG_TRAINER   16      0x00010         trainer this npc teatch you some spell
     583UNIT_NPC_FLAG_SPIRITHEALER      32      0x00020         ghost in graveyeard(visible only to dead)
     584UNIT_NPC_FLAG_SPIRITGUIDE       64      0x00040         ghost in battleground(visible only to dead)
     585UNIT_NPC_FLAG_INNKEEPER         128     0x00080         you can give to this npc your heartstone
     586UNIT_NPC_FLAG_BANKER    256     0x00100         bank in capital city
     587UNIT_NPC_FLAG_PETITIONER        512     0x00200         the guy you get the petitionpaper for signing a Guild
     588UNIT_NPC_FLAG_TABARDVENDOR      1024    0x00400         in this guy you can build tabart
     589UNIT_NPC_FLAG_BATTLEFIELDPERSON         2048    0x00800         battlemaster ... for Warsong and oder battlegrount this npc give you intro quorte
     590UNIT_NPC_FLAG_AUCTIONEER        4096    0x01000         auction house
     591UNIT_NPC_FLAG_STABLE    8192    0x02000         stable master for hunter you can keep your pet in stable
     592UNIT_NPC_FLAG_ARMORER   16384   0x04000         in this you you can repair your damaget items
     593        32768   0x08000         (unused)
     594UNIT_NPC_FLAG_GUARD     65536   0x10000         guard directions help (custom flag used at sever side only
     595
     596
     597To see flag combinations, just use this tool: http://www.mangosproject.org/~wrs/tools/flags.php ;)
     598
     599NPCs 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 ;)
     600speed ¶
     601
     602Creature's speed.
     603rank ¶
     604
     605Creature's honnor rank.
     6060 - Normal
     6071 - Elite
     6082 - RareElite?
     6093 - WorldBoss?
     6104 - Rare
     611
     612mindmg ¶
     613
     614Creature's minimum melee damage.
     615maxdmg ¶
     616
     617Creature's maximum melee damage.
     618dmgschool ¶
     619
     620Creature's melee damage spell school (by default 0/SPELL_SCHOOL_NORMAL/physical damage).
     621attackpower ¶
     622
     623Creature's melee attack power.
     624baseattacktime ¶
     625
     626Time between each creature's melee attacks.
     627rangeattacktime ¶
     628
     629Time between each creature's range attacks.
     630flags ¶
     631
     632!!! Need info here : Feel free to describe if you know !!!
     633mount ¶
     634
     635Creature's mount model ID ... if the value is equal to zero then creature doesn't have any mount.
     636dynamicflags ¶
     637
     638!!! Need info here : Feel free to describe if you know !!!
     639size ¶
     640
     641Creature model size 1 = 100%
     642family ¶
     643Id      Family
     6441       Wolf
     6452       Cat
     6463       Spider
     6474       Bear
     6485       Boar
     6496       Crocolisk
     6507       Carrion Bird
     6518       Crab
     6529       Gorilla
     65310      [UNUSED]
     65411      Raptor
     65512      Tallstrider
     65613      [UNUSED]
     65714      [UNUSED]
     65815      Felhunter
     65916      Voidwalker
     66017      Succubus
     66118      [UNUSED]
     66219      Doomguard
     66320      Scorpid
     66421      Turtle
     66522      [UNUSED]
     66623      Imp
     66724      Bat
     66825      Hyena
     66926      Owl
     67027      Wind Serpent
     67128      Remote Control
     67229      Felguard
     67330      Dragonhawk
     67431      Ravager
     67532      Warp Stalker
     67633      Sporebat
     67734      Nether Ray
     67835      Serpent
     679bounding_radius ¶
     680
     681Radius from what u can be attacked !
     682trainer_type ¶
     683
     684
     685    TRAINER_TYPE_CLASS = 0 //Train Spell your class. Must be creature_template.class == player class for training
     686    TRAINER_TYPE_MOUNTS = 1 //Train Spell your race (mounts). Must be creature_template.race == player race for training
     687    TRAINER_TYPE_TRADESKILLS = 2 //Train Trade skills Mining,Herb, first aid .... Pдayer must known creature_template.trainer_spell for training
     688    TRAINER_TYPE_PETS = 3 //Train Pet only for hunter(train hunter train pet) creature_template.class == HUNTER == player class for training
     689
     690
     691trainer_spell ¶
     692
     693Spell 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
     694See : character.class.
     695class ¶
     696
     697Creature'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
     698See : character.class.
     699race ¶
     700
     701Creature's race, like 'character.race' field. Used for check in case npcflag include trainer flag (16) and trainer_type == TRAINER_TYPE_MOUNTS
     702See : character.race.
     703minrangedmg ¶
     704
     705Minimum creature's range damage.
     706maxrangedmg ¶
     707
     708Maximum creature's range damage.
     709rangedattackpower ¶
     710
     711Creature's ranged attack power.
     712combat_reach ¶
     713
     714The distance from the creature can hit you.
     715type ¶
     716Id      Type
     7171       Beast
     7182       Dragonkin
     7193       Demon
     7204       Elemental
     7215       Giant
     7226       Undead
     7237       Humanoid
     7248       Critter
     7259       Mechanical
     72610      Not specified
     72711      Totem
     728civilian ¶
     729
     730If is this NPC civilian or not.
     731
     732If this is a boolean value (Civilian or not), why is it a int(4) ?
     733flag1 ¶
     734
     735!!! Need info here : Feel free to describe if you know !!!
     736equipmodel1 ¶
     737
     738Equipement's model of the first item weared by the creature.
     739equipmodel2 ¶
     740
     741Equipement's model of the second item weared by the creature.
     742equipmodel3 ¶
     743
     744Equipement's model of the third item weared by the creature.
     745equipinfo1 ¶
     746
     747!!! Need info here : Feel free to describe if you know !!!
     748equipinfo2 ¶
     749
     750!!! Need info here : Feel free to describe if you know !!!
     751equipinfo3 ¶
     752
     753!!! Need info here : Feel free to describe if you know !!!
     754equipslot1 ¶
     755
     756!!! Need info here : Feel free to describe if you know !!!
     757equipslot2 ¶
     758
     759!!! Need info here : Feel free to describe if you know !!!
     760equipslot3 ¶
     761
     762!!! Need info here : Feel free to describe if you know !!!
     763lootid ¶
     764
     765Refered to field loot_template.entry
     766skinloot ¶
     767
     768Type of loot if creature is skinned.
     769resistance1 ¶
     770
     771holy resitance
     772resistance2 ¶
     773
     774fire resistance
     775resistance3 ¶
     776
     777nature resistance
     778resistance4 ¶
     779
     780frost resistance
     781resistance5 ¶
     782
     783shadow resistance
     784resistance6 ¶
     785
     786arcane resistance
     787spell1 ¶
     788
     789Creature's first spell. ??? refer to game_spell.id ???
     790spell2 ¶
     791
     792Creature's second spell. ??? refer to game_spell.id ???
     793spell3 ¶
     794
     795Creature's third spell. ??? refer to game_spell.id ???
     796spell4 ¶
     797
     798Creature fourth spell. ??? refer to game_spell.id ???
     799mingold ¶
     800
     801Minimum gold drop.
     802maxgold ¶
     803
     804Maximum gold drop. 0 = creature don't drop any gold.
     805AIName ¶
     806
     807Name of the AI function creature uses.
     808MovementType? ¶
     809
     810Type of default creature movment.
     811Id      Type
     8120       Idle (not move)
     8131       Random
     8142       Waypoint
     815InhabitType? ¶
     816
     817Where creature cat move and attack (bit mask).
     818Id      Type
     8191       Ground
     8202       Water
     8213       Ground+Water
     822ScriptName? ¶
     823
     824Script's name creature uses.
     825
     826===================================== */
     827  'gameobject' => array(
     828    'type' => array(
     829      1 => "Beast",
     830      2 => "Dragonkin",
     831      3 => "Demon",
     832      4 => "Elemental",
     833      5 => "Giant",
     834      6 => "Undead",
     835      7 => "Humanoid",
     836      8 => "Critter",
     837      9 => "Mechanical",
     838      10 => "Not specified",
     839      11 => "Totem" ),
     840    )
     841/* =====================================
     842
     843entry
     844ID of your choice ex : 5914 and in game : .addgo 5914
     845
     846type:
     847Value   Name    Note
     8480       DOOR   
     8491       BUTTON 
     8502       QUESTGIVER     
     8513       CHEST   
     8524       ?       
     8535       GENERIC         
     8546       TRAP   
     8557       CHAIR   
     8568       SPELL_FOCUS     
     8579       TEXT   
     85810      GOOBER 
     85911      TRANSPORT       
     86012      ?       
     86113      ?       "Battlement Large"
     86214      ?       do not possess the parameter?
     86315      MO_TRANSPORT   
     86416      DUEL_FLAG       
     86517      FISHING_BOBBER 
     86618      RITUAL 
     86719      MAILBOX         
     86820      ?       
     86921      ?       
     87022      SPELLCASTER     
     87123      MEETING_STONE   
     87224      FLAGSTAND       (BG_Flag)
     87325      FISHING_HOLE   
     87426      ?       
     87527      CUSTOM_TELEPORTER       Not supported but sended to client, can create problems in client work.
     87628      ?       
     87729      BANNER?         
     878
     879displayId:
     880Graphic model's id sent to the client.
     881
     882name:
     883Object's name.
     884
     885faction:
     886Object's faction, if any.
     887
     888flags:
     889!!! Need info here : Feel free to document if you know !!!
     890
     891size:
     892Object's size must be set because graphic models can be resample.
     893
     894sound0 - sound11:
     895Data fields specific for different type field values. Each type has unique fields.
     896
     897ScriptName?
     898Script's name this object uses, if needed.
     899
     900Gameobject type 0 ( DOOR ):
     901sound0 = State
     902sound1 = LockID ( ID from Lock.dbc )
     903sound2 = flags ?
     904sound3 = flags ?
     905sound4 = 0
     906sound5 = 0
     907sound6 = 0
     908sound7 = 0
     909sound8 = 0
     910sound9 = 0
     911sound10 = 0
     912sound11 = 0
     913
     914Gameobject type 1 ( BUTTON ):
     915sound0 = State
     916sound1 = LockID ( ID from Lock.dbc )
     917sound2 = flags ?
     918sound3 = ID gameobject ( Spawned GO type 6 )
     919sound4 = State Battleground ?
     920sound5 = 0
     921sound6 = 0
     922sound7 = 0
     923sound8 = 0
     924sound9 = 0
     925sound10 = 0
     926sound11 = 0
     927
     928Gameobject type 2 ( QUESTGIVER ):
     929sound0 = LockID ( ID from Lock.dbc )
     930sound1 = QuestLoot? ID (Quest Id to be given)
     931sound2 = 0
     932sound3 = QuestLoot? ID
     933sound4 = 0
     934sound5 = 0
     935sound6 = 0
     936sound7 = 0
     937sound8 = 0
     938sound9 = 0
     939sound10 = 0
     940sound11 = 0
     941
     942Gameobject type 3 ( CHEST ):
     943sound0 = LockID ( ID from Lock.dbc )
     944sound1 = LootID
     945sound2 = Time
     946sound3 = State
     947sound4 = MinLoot? ( Min successful loot attempts for Mining Gerbalism etc )
     948sound5 = MaxLoot? ( Max successful loot attempts for Mining Gerbalism etc )
     949sound6 = QuestLoot? ID
     950sound7 = ID gameobject ( Spawned GO type 6 )
     951sound8 = QuestID ( Quest complete )
     952sound9 = ?
     953sound10 = ?
     954sound11 = 0
     955
     956Gameobject type 5 ( GENERIC ):
     957sound0 = State
     958sound1 = State
     959sound2 = 0
     960sound3 = 0
     961sound4 = 0
     962sound5 = 0
     963sound6 = 0
     964sound7 = 0
     965sound8 = 0
     966sound9 = 0
     967sound10 = 0
     968sound11 = 0
     969
     970Gameobject type 6 ( TRAP ):
     971sound0 = LockID ( ID from Lock.dbc )
     972sound1 = Time
     973sound2 = Distance
     974sound3 = Spell ID
     975sound4 = State ?
     976sound5 = Time/Distance ?
     977sound6 = Chain Effect
     978sound7 = Time/Distance for Chain Effect
     979sound8 = 0
     980sound9 = 0
     981sound10 = 0
     982sound11 = 0
     983
     984Gameobject type 7 ( CHAIR ):
     985sound0 = State
     986sound1 = Distance/ State ?
     987sound2 = 0
     988sound3 = 0
     989sound4 = 0
     990sound5 = 0
     991sound6 = 0
     992sound7 = 0
     993sound8 = 0
     994sound9 = 0
     995sound10 = 0
     996sound11 = 0
     997
     998Gameobject type 8 ( SPELL_FOCUS ):
     999sound0 = ID SpellFocusObject.dbc. See SpellFocusObjectID
     1000sound1 = Distance
     1001sound2 = ID gameobject ( Spawned GO type 6 )
     1002sound3 = State ?
     1003sound4 = 0
     1004sound5 = 0
     1005sound6 = 0
     1006sound7 = 0
     1007sound8 = 0
     1008sound9 = 0
     1009sound10 = 0
     1010sound11 = 0
     1011
     1012Gameobject type 9 ( TEXT ):
     1013sound0 = Page ID
     1014sound1 = 0
     1015sound2 = ID from PageTextMaterial?.dbc
     1016sound3 = 0
     1017sound4 = 0
     1018sound5 = 0
     1019sound6 = 0
     1020sound7 = 0
     1021sound8 = 0
     1022sound9 = 0
     1023sound10 = 0
     1024sound11 = 0
     1025
     1026Gameobject type 10 ( GOOBER ):
     1027sound0 = LockID ( ID from Lock.dbc )
     1028sound1 = flags ?
     1029sound2 = QuestLoot? ID ?
     1030sound3 = flags ?
     1031sound4 = State ?
     1032sound5 = State ?
     1033sound6 = 0
     1034sound7 = 0
     1035sound8 = 0
     1036sound9 = 0
     1037sound10 = Spell ID
     1038sound11 = 0
     1039
     1040Gameobject type 18 ( RITUAL ):
     1041sound0 = Time ?
     1042sound1 = Spell ID
     1043sound2 = Spell ID
     1044sound3 = 0
     1045sound4 = ?
     1046sound5 = ?
     1047sound6 = 0
     1048sound7 = 0
     1049sound8 = 0
     1050sound9 = 0
     1051sound10 = 0
     1052sound11 = 0
     1053
     1054Gameobject type 22 ( SPELLCASTER ):
     1055sound0 = Spell ID
     1056sound1 = 0
     1057sound2 = State ?
     1058sound3 = 0
     1059sound4 = 0
     1060sound5 = 0
     1061sound6 = 0
     1062sound7 = 0
     1063sound8 = 0
     1064sound9 = 0
     1065sound10 = 0
     1066sound11 = 0
     1067
     1068Gameobject type 24 ( FLAGSTAND ):
     1069sound0 = 0
     1070sound1 = Spell ID
     1071sound2 = ?
     1072sound3 = Spell ID
     1073sound4 = Spell ID
     1074sound5 = ?
     1075sound6 = 0
     1076sound7 = 0
     1077sound8 = 0
     1078sound9 = 0
     1079sound10 = 0
     1080sound11 = 0
     1081
     1082Gameobject type 27 ( CUSTOM_TELEPORTER ):
     1083sound0 = areatrigger_template.id
     1084sound1 = 0
     1085sound2 = 0
     1086sound3 = 0
     1087sound4 = 0
     1088sound5 = 0
     1089sound6 = 0
     1090sound7 = 0
     1091sound8 = 0
     1092sound9 = 0
     1093sound10 = 0
     1094sound11 = 0
     1095
     1096===================================== */
     1097);
     1098
    31099?>
    4 
    5 
    6 
    7 <?php
    8   };
    9 ?>
Note: See TracChangeset for help on using the changeset viewer.