API tools faq
paste
image

WV misc.

image
Dec 21st, 2011
231
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.82 KB | None | 0 0
raw download clone embed print report
  1. -- IRONFORGE PART
  2. -- GYPSY WAGON
  3. INSERT INTO gameobject (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  4. VALUES
  5. ('42038', '178666', '0', '1', '1', '-4924.69', '-983.046', '501.461', '-0.314159', '0', '0', '-0.156434', '0.987688', '180', '100', '1');
  6.  
  7. -- VENDOR SPAWN n TEMPLATE
  8. UPDATE `creature` SET `position_x`='-4923.96', `position_y`='-980.013', `position_z`='501.554', `orientation`='0.994838' WHERE `id`='13433';
  9. UPDATE `creature` SET `position_x`='-4926.36', `position_y`='-979.266', `position_z`='501.56', `orientation`='1.6057' WHERE `id`='13434';
  10. UPDATE creature_template SET `modelid3` = "0", `armor` = "1187", `mindmg` = "29", `maxdmg` = "43", `attackpower` = "11", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "4608", `minrangedmg` = "23", `maxrangedmg` = "34", `rangedattackpower` = "9" WHERE entry=13433;
  11. UPDATE creature_template SET `modelid3` = "0", `armor` = "1187", `faction_A` = "35", `faction_H` = "35", `mindmg` = "29", `maxdmg` = "43", `attackpower` = "11", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "4608", `minrangedmg` = "23", `maxrangedmg` = "34", `rangedattackpower` = "9" WHERE entry=13434;
  12.  
  13. -- MISSING ROPE LINE SPAWN
  14. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  15. VALUES
  16. ('178765', '0', '1', '1', '-4917.81', '-968.167', '501.477', '-1.39626', '0', '0', '-0.642786', '0.766046', '180', '100', '1'),
  17. ('178765', '0', '1', '1', '-4919.54', '-971.751', '501.473', '-1.79769', '0', '0', '-0.782608', '0.622514', '180', '100', '1');
  18.  
  19. -- ORGRIMMAR PART
  20. -- GYPSY WAGON
  21. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  22. VALUES
  23. ('2061', '530', '1', '1', '-3175.58', '-12384.2', '14.3405', '2.17318', '0', '0', '0.885045', '0.465506', '120', '100', '1');
  24. -- WAGON LIGHTS
  25. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  26. VALUES
  27. ('178438', '1', '1', '1', '1653.82', '-4433.39', '20.1792', '1.93731', '0', '0', '0.824125', '0.566409', '180', '100', '1'),
  28. ('178438', '1', '1', '1', '1650.75', '-4432.93', '20.0794', '-2.79253', '0', '0', '-0.984808', '0.173647', '180', '100', '1'),
  29. ('178438', '1', '1', '1', '1651.82', '-4428', '19.5231', '-1.22173', '0', '0', '-0.573576', '0.819152', '180', '100', '1'),
  30. ('178551', '1', '1', '1', '1655.83', '-4431.12', '20.1236', '0.349066', '0', '0', '0.173648', '0.984808', '180', '100', '1');
  31. -- WAGON PRESENTS
  32. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  33. VALUES
  34. ('178428', '1', '1', '1', '1653.8', '-4430.6', '19.2086', '1.5708', '0', '0', '0.707108', '0.707106', '180', '100', '1'),
  35. ('178432', '1', '1', '1', '1651.98', '-4431.05', '19.2049', '-0.872665', '0', '0', '-0.422618', '0.906308', '180', '100', '1'),
  36. ('178430', '1', '1', '1', '1652.97', '-4430.76', '19.2047', '-3.05433', '0', '0', '-0.999048', '0.0436174', '180', '100', '1');
  37.  
  38. -- VENDOR SPAWN n TEMPLATE
  39. UPDATE `creature` SET `position_x`='1622.48', `position_y`='-4415', `position_z`='14.546', `orientation`='4.068' WHERE `id`='13418';
  40. UPDATE `creature` SET `position_x`='1626.15', `position_y`='-4412', `position_z`='15.218', `orientation`='0.148' WHERE `id`='13420';
  41. UPDATE creature_template SET `modelid3` = "0", `armor` = "1187", `faction_A` = "35", `faction_H` = "35", `mindmg` = "29", `maxdmg` = "43", `attackpower` = "11", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "4608", `minrangedmg` = "23", `maxrangedmg` = "34", `rangedattackpower` = "9" WHERE entry=13418;
  42. UPDATE creature_template SET `modelid3` = "0", `armor` = "1187", `faction_A` = "35", `faction_H` = "35", `mindmg` = "29", `maxdmg` = "43", `attackpower` = "11", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "4608", `minrangedmg` = "23", `maxrangedmg` = "34", `rangedattackpower` = "9" WHERE entry=13420;
  43.  
  44. -- GREAT-FATHER WINTER SPAWN n TEMPLATE
  45. UPDATE `creature` SET `position_x`='1656.22', `position_y`='-4433.43', `position_z`='17.4137', `orientation`='2.13277' WHERE `id`='13445';
  46. UPDATE creature_template SET `modelid3` = "0", `armor` = "1179", `mindmg` = "42", `maxdmg` = "56", `attackpower` = "102", `baseattacktime` = "2000", `rangeattacktime` = "0", `unit_flags` = "768", `minrangedmg` = "29", `maxrangedmg` = "42", `rangedattackpower` = "9" WHERE entry=13445;
  47.  
  48.  
  49. -- UNDERCITY PART
  50. -- VENDOR SPAWN n TEMPLATE
  51. DELETE FROM `creature` WHERE `id`='13430';
  52. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`)
  53. VALUES
  54. ('13429', '0', '1', '1', '0', '0', '1629.23', '218.479', '-43.0193', '2.21657', '180', '0', '0', '690', '0', '0', '0'),
  55. ('13430', '0', '1', '1', '0', '0', '1630.85', '219.424', '-43.0193', '2.16421', '180', '0', '0', '1300', '0', '0', '0');
  56. UPDATE creature_template SET `modelid3` = "0", `armor` = "1179", `faction_A` = "35", `faction_H` = "35", `mindmg` = "42", `maxdmg` = "56", `attackpower` = "102", `baseattacktime` = "2000", `rangeattacktime` = "0", `unit_flags` = "4608", `minrangedmg` = "29", `maxrangedmg` = "42", `rangedattackpower` = "9" WHERE entry=13429;
  57. UPDATE creature_template SET `modelid3` = "0", `armor` = "1179", `faction_A` = "35", `faction_H` = "35", `npcflag` = "131", `mindmg` = "42", `maxdmg` = "56", `attackpower` = "102", `baseattacktime` = "2000", `rangeattacktime` = "0", `unit_flags` = "4608", `minrangedmg` = "29", `maxrangedmg` = "42", `rangedattackpower` = "9" WHERE entry=13430;
  58.  
  59. UPDATE `creature` SET `position_x`='1635.4', `position_y`='223.331', `position_z`='-43.0198', `orientation`='2.84489' WHERE `id`='6741';
  60.  
  61. -- CHRISTMAS TREE
  62. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`)
  63. VALUES
  64. ('178647', '0', '1', '1', '1646.51', '218.251', '-43.1031', '2.82743', '0', '0', '0.987688', '0.156436', '180', '100', '1');
  65.  
  66. DELETE FROM creature WHERE id=13432;
  67. UPDATE `creature` SET `position_x`='-8823.24', `position_y`='543.75', `position_z`='96.7631', `orientation`='2.89725' WHERE `id`='15732';
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!