API tools faq
paste
Advertisement
slp13at420

chain quest-1hd sword

slp13at420
Jan 31st, 2013
104
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 20.94 KB | None | 0 0
raw download clone embed print report
  1. -- QUESTS
  2. -- Created by BlackWolf with wow-v for
  3. -- blackwolfsden.dyndns-free.com
  4. -- ty Grumbo
  5. DELETE FROM `quests` WHERE `entry`>'30000'-1 AND `entry`<'30007'+1;
  6. INSERT INTO `quests` (`entry`, `ZoneId`, `sort`, `MinLevel`, `questlevel`, `Type`, `RequiredRaces`, `RequiredClass`, `srcItem`, `SrcItemCount`, `Title`, `Details`, `Objectives`, `CompletionText`, `IncompleteText`, `ReqItemId1`, `ReqItemId2`, `ReqItemId3`, `ReqItemId4`, `ReqItemId5`, `ReqItemId6`, `ReqItemCount1`, `ReqItemCount2`, `ReqItemCount3`, `ReqItemCount4`, `ReqItemCount5`, `ReqItemCount6`, `ReqKillMobOrGOId1`, `ReqKillMobOrGOId2`, `ReqKillMobOrGOId3`, `ReqKillMobOrGOId4`, `ReqKillMobOrGOCount1`, `ReqKillMobOrGOCount2`, `ReqKillMobOrGOCount3`, `ReqKillMobOrGOCount4`, `RewChoiceItemId1`, `RewChoiceItemId2`, `RewChoiceItemId3`, `RewChoiceItemId4`, `RewChoiceItemId5`, `RewChoiceItemId6`, `RewChoiceItemCount1`, `RewChoiceItemCount2`, `RewChoiceItemCount3`, `RewChoiceItemCount4`, `RewChoiceItemCount5`, `RewChoiceItemCount6`, `RewItemId1`, `RewItemId2`, `RewItemId3`, `RewItemId4`, `RewItemCount1`, `RewItemCount2`, `RewItemCount3`, `RewItemCount4`, `RewMoney`, `RewXP`, `RewardMoneyAtMaxLevel`, `RequiredQuest1`, `RequiredQuest2`, `RequiredQuest3`, `RequiredQuest4`, `IsRepeatable`, `bonushonor`, `rewardtalents`, `suggestedplayers`, `RequiredTradeskill`, `RequiredTradeskillValue`, `RequiredRepFaction`, `RequiredRepValue`, `RewRepFaction1`, `RewRepFaction2`, `RewRepFaction3`, `RewRepFaction4`, `RewRepFaction5`, `RewRepFaction6`, `RewRepValue1`, `RewRepValue2`, `RewRepValue3`, `RewRepValue4`, `RewRepValue5`, `RewRepValue6`, `rewardtitleid`, `CastSpell`, `RewRepLimit`, `EndText`, `ObjectiveText1`, `ObjectiveText2`, `ObjectiveText3`, `ObjectiveText4`, `RequiredOneOfQuest`, `RemoveQuests`)
  7. VALUES
  8. ('30000', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor Part 1', 'Greatings traveler. you seek the knowledge of the Dragons Razor. these weapons were first forged by the ethereal blacksmiths for an ancient group of Shadow Warriors who swore an oath to watchover and protect the realm of the living. altho the Warriors past long ago the wisdom of forging these swords is still handed down sacredly to only the most worthy of the ethreal blacksmiths. I am lucky enough to be one of the chosen. I can reforge your sword to be stronger just bring me what i ask for.', 'bring me your Gold Dragons Razor, 25 Mulgor bone dust, and 3 Imprisoned Ruthless Demon Spirits.', 'ahhh yes you have brought me what i need. now to do my thing .... here you go.. care for this weapon there are not many left in this realm.', 'Bring me what I asked for.', '61104', '140000', '140003', '0', '0', '0', '1', '25', '3', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61105', '0', '0', '0', '1', '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', '', '', '', '', '', '', ''),
  9. ('30001', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 2', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor I, 40 Mulgor bone dust, and 15 Captured Spirits, 4 Imprisoned Ruthless Demon Spirits, and 2 Imprisoned Ruthless Elemental Spirits.', 'ahhh yes you have brought me what i need. now to do my thing .... did you know the mulgor bone dust has special proerties that when worked into the metal it bonds to it and makes it lighter and stronger. the blah blah blah when worked into the blade makes it sharper...... ok here you go be careful shes sharp..', 'Bring me what I asked for.', '61105', '140000', '140001', '140003', '140004', '0', '1', '40', '15', '4', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61106', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30000', '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', '', '', '', '', '', '', ''),
  10. ('30002', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 3', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor II, plus these items.', 'ahhh yes you have brought me what i need. now to do my thing .... see how i work the dust into the blade.. as you work it in you will fell the metal change , get denser and lighter.. ok ther you go.. she should do whell in battle for you.', 'Bring me what I asked for.', '61106', '140001', '140004', '0', '0', '0', '1', '40', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61107', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30001', '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', '', '', '', '', '', '', ''),
  11. ('30003', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 4', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor III, plus these items.', 'ahhh yes you have brought me what i need. now to do my thing .... see how i work the dust into the blade.. as you work in the bone dust you will feel the metal change , get denser and lighter.. ok ther you go.. she should do whell in battle for you.', 'Bring me what I asked for.', '61107', '140001', '140002', '140004', '140005', '140006', '1', '45', '30', '5', '2', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61108', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30002', '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', '', '', '', '', '', '', ''),
  12. ('30004', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 5', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor IV, plus these items.', 'ahhh yes you have brought me what i need. now to do my thing .... see how i work the dust into the blade.. as you work in the bone dust you will feel the metal change , get denser and lighter.. ok ther you go.. she should do whell in battle for you.', 'Bring me what I asked for.', '61108', '140002', '140005', '140006', '140007', '140008', '1', '60', '15', '2', '2', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61109', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30003', '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', '', '', '', '', '', '', ''),
  13. ('30005', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 6', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor V, plus these items.', 'ahhh yes you have brought me what i need. now to do my thing .... see how i work the dust into the blade.. as you work in the bone dust you will feel the metal change , get denser and lighter.. ok ther you go.. she should do whell in battle for you.', 'Bring me what I asked for.', '61109', '140000', '140002', '140003', '140004', '140005', '1', '100', '80', '20', '10', '10', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61110', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30004', '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', '', '', '', '', '', '', ''),
  14. ('30006', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 7', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor VI, plus these items.', 'ahhh yes you have brought me what i need. now to do my thing .... see how i work the dust into the blade.. as you work in the bone dust you will feel the metal change , get denser and lighter.. ok ther you go.. she should do whell in battle for you.', 'Bring me what I asked for.', '61110', '140000', '140001', '140002', '140003', '140005', '1', '200', '120', '100', '30', '20', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61111', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30005', '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', '', '', '', '', '', '', ''),
  15. ('30007', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'The Life of the Dragons Razor part 8', 'Ahhh you return. I see you wish that i resmith it stronger. bring me the items i need and i will do this for you.', 'bring me your Gold Dragons Razor VII, plus these items.', 'ahhh yes you have brought me what i need. now to do my thing .... see how i work the dust into the blade.. as you work in the bone dust you will feel the metal change , get denser and lighter.. ok ther you go.. she should do whell in battle for you.', 'Bring me what I asked for.', '61111', '140006', '140007', '140008', '0', '0', '1', '2', '2', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '61112', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '30006', '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', '', '', '', '', '', '', '');
  16.  
  17. DELETE FROM `Creature_quest_starter` WHERE `id`='50300';
  18. INSERT INTO `creature_quest_starter` (`id`, `quest`) VALUES
  19. ('50300', '30000'),
  20. ('50300', '30001'),
  21. ('50300', '30002'),
  22. ('50300', '30003'),
  23. ('50300', '30004'),
  24. ('50300', '30005'),
  25. ('50300', '30006'),
  26. ('50300', '30007');
  27.  
  28. DELETE FROM `Creature_quest_finisher` WHERE `id`='50300';
  29. INSERT INTO `creature_quest_finisher` (`id`, `quest`) VALUES
  30. ('50300', '30000'),
  31. ('50300', '30001'),
  32. ('50300', '30002'),
  33. ('50300', '30003'),
  34. ('50300', '30004'),
  35. ('50300', '30005'),
  36. ('50300', '30006'),
  37. ('50300', '30007');
  38.  
  39. -- QUEST GIVEr AND MOBS
  40. DELETE FROM `creature_names` WHERE `entry`>'50300'-1 AND `entry`<'50307'+1;
  41. INSERT INTO `creature_names` (`entry`, `name`, `subname`, `info_str`, `flags1`, `type`, `family`, `rank`, `killcredit1`, `killcredit2`, `male_displayid`, `female_displayid`, `male_displayid2`, `female_displayid2`, `unknown_float1`, `unknown_float2`, `leader`, `questitem1`, `questitem2`, `questitem3`, `questitem4`, `questitem5`, `questitem6`, `waypointid`) VALUES
  42. ('50300', 'Gold Dragons Razor Smith', 'Ethereal Blacksmith', 'Quest', 0, 10, 0, 0, 0, 0, 14334, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  43. ('50301', 'Bestial Demon', 'Mulgor', '', 0, 3, 0, 0, 0, 0, 20607, 21447, 16480, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  44. ('50302', 'Spiritual Element', 'Raging Spirits', '', 0, 4, 0, 0, 0, 0, 4716, 453, 525, 647, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  45. ('50303', 'Vampiric Civilian', 'Vampiric City', '', 0, 10, 0, 0, 0, 0, 3122, 2054, 4942, 262, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  46. ('50304', 'Ruthless Demon', 'Mulgor', '', 0, 3, 0, 1, 0, 0, 19338, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  47. ('50305', 'Ruthless Spirit', 'Raging Spirits', '', 0, 4, 0, 1, 0, 0, 8824, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  48. ('50306', 'Ruthless Vampire', 'Vampiric City', '', 0, 6, 0, 1, 0, 0, 31165, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0),
  49. ('50307', 'Nocturnus', 'The Shadow Arena', '', 0, 10, 0, 3, 0, 0, 24307, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0);
  50.  
  51.  
  52. DELETE FROM `creature_proto` WHERE `entry`>'50300'-1 AND `entry`<'50307'+1;
  53. INSERT INTO `creature_proto` (`entry`, `minlevel`, `maxlevel`, `faction`, `minhealth`, `maxhealth`, `mana`, `scale`, `npcflags`, `attacktime`, `attacktype`, `mindamage`, `maxdamage`, `can_ranged`, `rangedattacktime`, `rangedmindamage`, `rangedmaxdamage`, `respawntime`, `armor`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `combat_reach`, `bounding_radius`, `auras`, `boss`, `money`, `invisibility_type`, `walk_speed`, `run_speed`, `fly_speed`, `extra_a9_flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `spell_flags`, `modImmunities`, `isTrainingDummy`, `guardtype`, `summonguard`, `spelldataid`, `vehicleid`, `rooted`) VALUES
  54. ('50300', 1, 1, 7, 0, 0, 0, 1, 3, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '0', 0, 0, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  55. ('50301', 80, 80, 168, 150000, 200000, 30000, 1, 0, 1000, 0, 4, 5, 0, 0, 0, 0, 900000, 100, 10, 10, 10, 10, 10, 10, 0, 0, '0', 0, 2000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  56. ('50302', 80, 85, 168, 300000, 350000, 30000, 1, 0, 2500, 0, 100, 1000, 0, 0, 0, 0, 1200000, 100, 20, 20, 20, 20, 20, 20, 0, 0, '0', 0, 5000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  57. ('50303', 80, 85, 168, 600000, 700000, 90000, 1, 0, 2500, 0, 5000, 1000, 0, 0, 0, 0, 1800000, 400, 50, 50, 50, 50, 50, 50, 0, 0, '0', 1, 10000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  58. ('50304', 80, 83, 168, 400000, 60000, 19000, 0.5, 0, 2900, 0, 200, 2000, 0, 0, 0, 0, 1200000, 400, 40, 40, 40, 40, 40, 40, 0, 0, '0', 1, 9000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  59. ('50305', 80, 90, 168, 800000, 900000, 94000, 0.8, 0, 2700, 0, 2000, 5000, 0, 0, 0, 0, 1800000, 400, 40, 40, 40, 40, 40, 40, 0, 0, '0', 1, 90000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  60. ('50306', 80, 90, 168, 1000000, 1500000, 290000, 0.5, 0, 2700, 0, 4000, 8000, 0, 0, 0, 0, 1800000, 900, 40, 40, 40, 40, 40, 40, 0, 0, '0', 1, 130000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  61. ('50307', 90, 100, 168, 19000000, 25000000, 2908911, 1, 0, 2700, 0, 15000, 40000, 0, 0, 0, 0, 7200000, 5000, 300, 300, 300, 300, 300, 300, 0, 0, '0', 1, 400000000, 0, 2.5, 8, 14, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  62.  
  63.  
  64. -- DROP ITEMS
  65. DELETE FROM `items` WHERE `entry`>'140000'-1 AND `entry`<'140010'+1;
  66. INSERT INTO `items` (`entry`, `class`, `subclass`, `field4`, `name1`, `displayid`, `quality`, `flags`, `flags2`, `buyprice`, `sellprice`, `inventorytype`, `allowableclass`, `allowablerace`, `itemlevel`, `requiredlevel`, `RequiredSkill`, `RequiredSkillRank`, `RequiredSpell`, `RequiredPlayerRank1`, `RequiredPlayerRank2`, `RequiredFaction`, `RequiredFactionStanding`, `Unique`, `maxcount`, `ContainerSlots`, `itemstatscount`, `stat_type1`, `stat_value1`, `stat_type2`, `stat_value2`, `stat_type3`, `stat_value3`, `stat_type4`, `stat_value4`, `stat_type5`, `stat_value5`, `stat_type6`, `stat_value6`, `stat_type7`, `stat_value7`, `stat_type8`, `stat_value8`, `stat_type9`, `stat_value9`, `stat_type10`, `stat_value10`, `ScaledStatsDistributionId`, `ScaledStatsDistributionFlags`, `dmg_min1`, `dmg_max1`, `dmg_type1`, `dmg_min2`, `dmg_max2`, `dmg_type2`, `armor`, `holy_res`, `fire_res`, `nature_res`, `frost_res`, `shadow_res`, `arcane_res`, `delay`, `ammo_type`, `range`, `spellid_1`, `spelltrigger_1`, `spellcharges_1`, `spellcooldown_1`, `spellcategory_1`, `spellcategorycooldown_1`, `spellid_2`, `spelltrigger_2`, `spellcharges_2`, `spellcooldown_2`, `spellcategory_2`, `spellcategorycooldown_2`, `spellid_3`, `spelltrigger_3`, `spellcharges_3`, `spellcooldown_3`, `spellcategory_3`, `spellcategorycooldown_3`, `spellid_4`, `spelltrigger_4`, `spellcharges_4`, `spellcooldown_4`, `spellcategory_4`, `spellcategorycooldown_4`, `spellid_5`, `spelltrigger_5`, `spellcharges_5`, `spellcooldown_5`, `spellcategory_5`, `spellcategorycooldown_5`, `bonding`, `description`, `page_id`, `page_language`, `page_material`, `quest_id`, `lock_id`, `lock_material`, `sheathID`, `randomprop`, `randomsuffix`, `block`, `itemset`, `MaxDurability`, `ZoneNameID`, `mapid`, `bagfamily`, `TotemCategory`, `socket_color_1`, `unk201_3`, `socket_color_2`, `unk201_5`, `socket_color_3`, `unk201_7`, `socket_bonus`, `GemProperties`, `ReqDisenchantSkill`, `ArmorDamageModifier`, `existingduration`, `ItemLimitCategoryId`, `HolidayId`) VALUES
  67. (140000, 0, 8, -1, 'Mulgor Bone Dust', 6396, 4, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used for gear upgrades.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  68. (140001, 0, 8, -1, 'Captured Spirit', 17896, 4, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used for gear upgrades.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  69. (140002, 0, 8, -1, 'Vampiric Claw', 40803, 4, 0, 0, 0, 0, 0, -1, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Used for gear upgrades.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  70. (140003, 0, 8, -1, 'Imprisoned Ruthless Demon Spirit', 7045, 5, 0, 0, 0, 0, 0, -1, -1, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Unique Upgrade Material', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  71. (140004, 0, 8, -1, 'Imprisoned Ruthless Elemental Spirit', 7045, 5, 0, 0, 0, 0, 0, -1, -1, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Unique Upgrade Material', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  72. (140005, 0, 8, -1, 'Imprisoned Ruthless Vampiric Spirit', 7045, 5, 0, 0, 0, 0, 0, -1, -1, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'Unique Upgrade Material', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  73. (140006, 0, 8, -1, 'Hand Of Nocturnus', 3146, 6, 0, 0, 0, 0, 0, -1, -1, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Power of the flame lies within.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  74. (140007, 0, 8, -1, 'Head Of Nocturnus', 7104, 6, 0, 0, 0, 0, 0, -1, -1, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Power of the flame lies within.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  75. (140008, 0, 8, -1, 'Heart Of Nocturnus', 3422, 6, 0, 0, 0, 0, 0, -1, -1, 0, 80, 0, 0, 0, 0, 0, 0, 0, 0, 9999999, 0, 10, 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, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Power of the flame lies within.', 0, 0, 0, 0, 0, -1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  76.  
  77. DELETE FROM `loot_items` WHERE `entryid`>'50301'-1 AND `entryid`<'50310'+1;
  78. -- INSERT INTO `loot_items` (`entryid`, `itemid`, `normal10percentchance`, `normal25percentchance`, `heroic10percentchance`, `heroic25percentchance`, `mincount`, `maxcount`) VALUES
  79. -- (50301, 140000, 100, 0, 0, 0, 1, 1),
  80. -- (50302, 140001, 100, 0, 0, 0, 1, 1),
  81. -- (50303, 140002, 70, 0, 0, 0, 1, 1),
  82. -- (50304, 140003, 100, 0, 0, 0, 1, 1),
  83. -- (50305, 140004, 100, 0, 0, 0, 1, 1),
  84. -- (50306, 140005, 100, 0, 0, 0, 1, 1),
  85. -- (50306, 140002, 70, 0, 0, 0, 1, 1),
  86. -- (50307, 140006, 100, 0, 0, 0, 1, 1),
  87. -- (50307, 140007, 100, 0, 0, 0, 1, 1),
  88. -- (50307, 140008, 100, 0, 0, 0, 1, 1),
  89. -- (50308, 140007, 100, 0, 0, 0, 1, 1),
  90. -- (50309, 140008, 100, 0, 0, 0, 1, 1),
  91. -- (50310, 140009, 100, 0, 0, 0, 1, 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!