Advertisement
Guest User

Legend of the Bengal Tiger

a guest
Feb 10th, 2015
425
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.58 KB | None | 0 0
  1. /*Fix Items that require "Tiger Riding" skill to normal Riding Skill & make them BoP*/
  2. REPLACE INTO `item_template` (`entry`, `RequiredSkill`, `RequiredSkillRank`, `bonding`) VALUES (8627, 762, 75, 3);
  3. REPLACE INTO `item_template` (`entry`, `RequiredSkill`, `RequiredSkillRank`, `bonding`) VALUES (8630, 762, 75, 3);
  4. REPLACE INTO `item_template` (`entry`, `RequiredSkill`, `RequiredSkillRank`, `bonding`) VALUES (8633, 762, 75, 3);
  5.  
  6. /*Add Vendor Flag (npcflag 128) for vendor to "World Mount Vendor" (NPC 7747)*/
  7. REPLACE INTO `creature_template` (`entry`, `npcflag`) VALUES (7747, 128);
  8.  
  9. /*Adds Items to "World Mount Vendor" (NPC 7747)*/
  10. INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8627);
  11. INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8628);
  12. INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8630);
  13. INSERT INTO `npc_vendor` (`entry`, `item`) VALUES (7747, 8633);
  14.  
  15. /*Spawn "World Mount Vendor" (NPC 7747) in the Cave*/
  16. INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES (5000000, 7747, 0, 1, 1, 0, 0, -12833.5, -1377.17, 112.917, 3.74826, 300, 0, 0, 198, 0, 0, 0, 0, 0, 0);
  17.  
  18. /*Create a .tele command called "BengalTigerCave"*/
  19. INSERT INTO `game_tele` (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES (10000, -12836.4, -1379.02, 112.721, 0.871346, 0, 'BengalTigerCave');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement