API tools faq
paste
Advertisement
Guest User

Petto

a guest
Mar 1st, 2015
198
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 6.49 KB | None | 0 0
raw download clone embed print report
  1. -----
  2. SELECT * FROM creature_template WHERE entry = 7784;
  3. -----
  4. "entry" "difficulty_entry_1"    "difficulty_entry_2"    "difficulty_entry_3"    "KillCredit1"   "KillCredit2"   "modelid1"  "modelid2"  "modelid3"  "modelid4"  "name"  "subname"   "IconName"  "gossip_menu_id"    "minlevel"  "maxlevel"  "exp"   "faction_A" "faction_H" "npcflag"   "speed_walk"    "speed_run" "scale" "rank"  "mindmg"    "maxdmg"    "dmgschool" "attackpower"   "dmg_multiplier"    "baseattacktime"    "rangeattacktime"   "unit_class"    "unit_flags"    "dynamicflags"  "family"    "trainer_type"  "trainer_spell" "trainer_class" "trainer_race"  "minrangedmg"   "maxrangedmg"   "rangedattackpower" "type"  "type_flags"    "lootid"    "pickpocketloot"    "skinloot"  "resistance1"   "resistance2"   "resistance3"   "resistance4"   "resistance5"   "resistance6"   "spell1"    "spell2"    "spell3"    "spell4"    "spell5"    "spell6"    "spell7"    "spell8"    "PetSpellDataId"    "VehicleId" "mingold"   "maxgold"   "AIName"    "MovementType"  "InhabitType"   "Health_mod"    "Mana_mod"  "Armor_mod" "RacialLeader"  "questItem1"    "questItem2"    "questItem3"    "questItem4"    "questItem5"    "questItem6"    "movementId"    "RegenHealth"   "equipment_id"  "mechanic_immune_mask"  "flags_extra"   "ScriptName"    "WDBVerified"
  5. "7784"  "0" "0" "0" "0" "0" "6909"  "0" "0" "0" "Homing Robot OOX-17/TN"    \N  \N  "0" "42"    "42"    "0" "35"    "35"    "3" "1,05"  "1,14286"   "1" "0" "62"    "83"    "0" "152"   "1" "2000"  "0" "1" "768"   "8" "0" "0" "0" "0" "0" "43"    "63"    "15"    "9" "4096"  "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" ""  "0" "1" "1,2"   "1" "1" "0" "0" "0" "0" "0" "0" "0" "94"    "1" "0" "16384" "0" "npc_OOX17" "12340"
  6. ----------
  7.  
  8. SELECT * FROM smart_scripts WHERE entryorguid = 7784;
  9. /* Affected rows: 0  Nalezené řádky: 0  Varování: 0  Doba vykonávání 1 query: 0,031 sec. */
  10.  
  11. ----------
  12.  
  13. -----
  14. SELECT * FROM quest_template WHERE entry = 648;
  15. -----
  16. "entry" "Method"    "ZoneOrSort"    "SkillOrClassMask"  "MinLevel"  "MaxLevel"  "QuestLevel"    "Type"  "RequiredRaces" "RequiredSkillValue"    "RepObjectiveFaction"   "RepObjectiveValue" "RepObjectiveFaction2"  "RepObjectiveValue2"    "RequiredMinRepFaction" "RequiredMinRepValue"   "RequiredMaxRepFaction" "RequiredMaxRepValue"   "SuggestedPlayers"  "LimitTime" "QuestFlags"    "SpecialFlags"  "CharTitleId"   "PlayersSlain"  "BonusTalents"  "RewardArenaPoints" "PrevQuestId"   "NextQuestId"   "ExclusiveGroup"    "NextQuestInChain"  "RewXPId"   "SrcItemId" "SrcItemCount"  "SrcSpell"  "Title" "Details"   "Objectives"    "OfferRewardText"   "RequestItemsText"  "EndText"   "CompletedText" "ObjectiveText1"    "ObjectiveText2"    "ObjectiveText3"    "ObjectiveText4"    "ReqItemId1"    "ReqItemId2"    "ReqItemId3"    "ReqItemId4"    "ReqItemId5"    "ReqItemId6"    "ReqItemCount1" "ReqItemCount2" "ReqItemCount3" "ReqItemCount4" "ReqItemCount5" "ReqItemCount6" "ReqSourceId1"  "ReqSourceId2"  "ReqSourceId3"  "ReqSourceId4"  "ReqSourceCount1"   "ReqSourceCount2"   "ReqSourceCount3"   "ReqSourceCount4"   "ReqCreatureOrGOId1"    "ReqCreatureOrGOId2"    "ReqCreatureOrGOId3"    "ReqCreatureOrGOId4"    "ReqCreatureOrGOCount1" "ReqCreatureOrGOCount2" "ReqCreatureOrGOCount3" "ReqCreatureOrGOCount4" "ReqSpellCast1" "ReqSpellCast2" "ReqSpellCast3" "ReqSpellCast4" "RewChoiceItemId1"  "RewChoiceItemId2"  "RewChoiceItemId3"  "RewChoiceItemId4"  "RewChoiceItemId5"  "RewChoiceItemId6"  "RewChoiceItemCount1"   "RewChoiceItemCount2"   "RewChoiceItemCount3"   "RewChoiceItemCount4"   "RewChoiceItemCount5"   "RewChoiceItemCount6"   "RewItemId1"    "RewItemId2"    "RewItemId3"    "RewItemId4"    "RewItemCount1" "RewItemCount2" "RewItemCount3" "RewItemCount4" "RewRepFaction1"    "RewRepFaction2"    "RewRepFaction3"    "RewRepFaction4"    "RewRepFaction5"    "RewRepValueId1"    "RewRepValueId2"    "RewRepValueId3"    "RewRepValueId4"    "RewRepValueId5"    "RewRepValue1"  "RewRepValue2"  "RewRepValue3"  "RewRepValue4"  "RewRepValue5"  "RewHonorAddition"  "RewHonorMultiplier"    "unk0"  "RewOrReqMoney" "RewMoneyMaxLevel"  "RewSpell"  "RewSpellCast"  "RewMailTemplateId" "RewMailDelaySecs"  "PointMapId"    "PointX"    "PointY"    "PointOpt"  "DetailsEmote1" "DetailsEmote2" "DetailsEmote3" "DetailsEmote4" "DetailsEmoteDelay1"    "DetailsEmoteDelay2"    "DetailsEmoteDelay3"    "DetailsEmoteDelay4"    "IncompleteEmote"   "CompleteEmote" "OfferRewardEmote1" "OfferRewardEmote2" "OfferRewardEmote3" "OfferRewardEmote4" "OfferRewardEmoteDelay1"    "OfferRewardEmoteDelay2"    "OfferRewardEmoteDelay3"    "OfferRewardEmoteDelay4"    "RewSkillLineId"    "RewSkillPoints"    "RewRepMask"    "QuestGiverPortrait"    "QuestTurnInPortrait"   "RewCurrencyId1"    "RewCurrencyCount1" "RewCurrencyId2"    "RewCurrencyCount2" "RewCurrencyId3"    "RewCurrencyCount3" "RewCurrencyId4"    "RewCurrencyCount4" "ReqCurrencyId1"    "ReqCurrencyCount1" "ReqCurrencyId2"    "ReqCurrencyCount2" "ReqCurrencyId3"    "ReqCurrencyCount3" "ReqCurrencyId4"    "ReqCurrencyCount4" "QuestGiverPortraitText"    "QuestGiverPortraitUnk" "QuestTurnInPortraitText"   "QuestTurnInPortraitUnk"    "SoundAccept"   "SoundTurnIn"   "RequiredSpell" "StartScript"   "CompleteScript"    "WDBVerified"
  17. "648"   "2" "440"   "0" "43"    "0" "48"    "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "351"   "3721"  "0" "0" "8" "0" "0" "0" "Rescue OOX-17/TN!" "The gnome's voice crackles once again from the robot:$B$B""I need to move OOX-17/TN to an open, safe place so it can begin a lengthy take-off procedure.  It has built-in cloaking, but I need time on my end to make it operational again.  I need you to escort the robot from its current location to, let's say, near the Caverns of Time!  That should be a perfect place, and long enough, to get things on line!""$B$B""Escort it safely and then come talk to me in Booty Bay!  Oglethorpe Obnoticus - out!""" "Escort OOX-17/TN to safety, then report to Oglethorpe Obnoticus in Booty Bay." "Oh, YOU'RE the great savior of OOX-17/TN! I cannot even begin to express my thanks for your assistance! My homing robot series needs more developing, but your recovery has saved me countless hours of rebuilding time, as well as many gold pieces in rebinding costs!$b$bPlease, take your choice of any of these items I have. Hopefully, you will make good use of one of them. Thank you again for your generous assistance, my robots and I are in your debt!"  \N  "Return to Oglethorpe Obnoticus at Booty Bay in Stranglethorn Vale."    "Escort OOX-17/TN to safety"    ""  ""  ""  ""  "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "9643"  "9644"  "0" "0" "0" "0" "1" "1" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "21"    "87"    "0" "0" "0" "6" "-6"    "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "75600" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" "0" ""  ""  ""  ""  "890"   "878"   "0" "0" "0" "1"
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!