API tools faq
paste
image

Mage Trainers

image
Nov 8th, 2011
262
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 6.31 KB | None | 0 0
raw download clone embed print report
  1. -- DCA
  2. UPDATE item_template SET `maxcount` = "2147483647", `stackable` = "2147483647" WHERE entry=43016;
  3.  
  4.  
  5. -- [5144] - Bink
  6. UPDATE creature_template SET `modelid3` = "0", `minhealth` = "1753", `maxhealth` = "1753", `minmana` = "0", `maxmana` = "0", `armor` = "1979", `mindmg` = "39", `maxdmg` = "59", `attackpower` = "15", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "31", `maxrangedmg` = "47", `rangedattackpower` = "12", `mingold` = "0", `maxgold` = "0" WHERE entry=5144;
  7. DELETE FROM `gossip_menu` WHERE `entry`='4552';
  8. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  9. VALUES
  10. ('4552', '561', '0', '0', '0', '0', '0', '0');
  11. DELETE FROM `gossip_menu_option` WHERE `menu_id`='4552';
  12. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  13. VALUES
  14. ('4552', '1', '3', 'Train me.', '5', '16', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  15. ('4552', '2', '0', 'Learn about Dual Talent Specialization.', '1', '1', '10371', '0', '0', '0', '0', '', '15', '40', '1', '17', '63680', '1', '14', '0', '128'),
  16. ('4552', '3', '0', 'I wish to unlearn my talents.', '1', '1', '4461', '0', '0', '0', '0', '', '15', '10', '1', '14', '0', '128', '0', '0', '0'),
  17. ('4552', '4', '0', 'GOSSIP_OPTION_QUESTGIVER', '2', '2', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  18.  
  19. -- [5145] - Juli Stormkettle
  20. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "4554", `minhealth` = "2769", `maxhealth` = "2769", `minmana` = "0", `maxmana` = "0", `armor` = "2958", `npcflag` = "49", `mindmg` = "60", `maxdmg` = "90", `attackpower` = "22", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "48", `maxrangedmg` = "72", `rangedattackpower` = "18", `mingold` = "0", `maxgold` = "0" WHERE entry=5145;
  21. DELETE FROM `gossip_menu` WHERE `entry`='4554';
  22. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  23. VALUES
  24. ('4554', '561', '0', '0', '0', '0', '0', '0');
  25. DELETE FROM `gossip_menu_option` WHERE `menu_id`='4554';
  26. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  27. VALUES
  28. ('4554', '1', '3', 'Train me.', '5', '16', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  29. ('4554', '2', '0', 'Learn about Dual Talent Specialization.', '1', '1', '10371', '0', '0', '0', '0', '', '15', '40', '1', '17', '63680', '1', '14', '0', '128'),
  30. ('4554', '3', '0', 'I wish to unlearn my talents.', '1', '1', '4461', '0', '0', '0', '0', '', '15', '10', '1', '14', '0', '128', '0', '0', '0');
  31.  
  32. -- [5146] - Nittlebur Sparkfizzle
  33. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "4555", `minhealth` = "4120", `maxhealth` = "4120", `minmana` = "0", `maxmana` = "0", `armor` = "3750", `npcflag` = "49", `mindmg` = "96", `maxdmg` = "144", `attackpower` = "36", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "77", `maxrangedmg` = "115", `rangedattackpower` = "29", `mingold` = "0", `maxgold` = "0" WHERE entry=5146;
  34. DELETE FROM `gossip_menu` WHERE `entry`='4555';
  35. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  36. VALUES
  37. ('4555', '561', '0', '0', '0', '0', '0', '0');
  38. DELETE FROM `gossip_menu_option` WHERE `menu_id`='4555';
  39. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  40. VALUES
  41. ('4555', '1', '3', 'Train me.', '5', '16', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  42. ('4555', '2', '0', 'Learn about Dual Talent Specialization.', '1', '1', '10371', '0', '0', '0', '0', '', '15', '40', '1', '17', '63680', '1', '14', '0', '128'),
  43. ('4555', '3', '0', 'I wish to unlearn my talents.', '1', '1', '4461', '0', '0', '0', '0', '', '15', '10', '1', '14', '0', '128', '0', '0', '0');
  44.  
  45. -- [7312] - Dink
  46. UPDATE creature_template SET `modelid3` = "0", `gossip_menu_id` = "4553", `minhealth` = "1753", `maxhealth` = "1753", `minmana` = "0", `maxmana` = "0", `armor` = "1979", `mindmg` = "39", `maxdmg` = "59", `attackpower` = "15", `baseattacktime` = "1500", `rangeattacktime` = "1500", `unit_flags` = "512", `minrangedmg` = "31", `maxrangedmg` = "47", `rangedattackpower` = "12", `mingold` = "0", `maxgold` = "0" WHERE entry=7312;
  47. DELETE FROM `gossip_menu` WHERE `entry`='4553';
  48. INSERT INTO `gossip_menu` (`entry`, `text_id`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`)
  49. VALUES
  50. ('4553', '561', '0', '0', '0', '0', '0', '0');
  51. DELETE FROM `gossip_menu_option` WHERE `menu_id`='4553';
  52. INSERT INTO `gossip_menu_option` (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  53. VALUES
  54. ('4553', '1', '3', 'Train me.', '5', '16', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0'),
  55. ('4553', '2', '0', 'Learn about Dual Talent Specialization.', '1', '1', '10371', '0', '0', '0', '0', '', '15', '40', '1', '17', '63680', '1', '14', '0', '128'),
  56. ('4553', '3', '0', 'I wish to unlearn my talents.', '1', '1', '4461', '0', '0', '0', '0', '', '15', '10', '1', '14', '0', '128', '0', '0', '0'),
  57. ('4553', '4', '0', 'GOSSIP_OPTION_QUESTGIVER', '2', '2', '0', '0', '0', '0', '0', '', '0', '0', '0', '0', '0', '0', '0', '0', '0');
  58.  
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!