API tools faq
paste
Advertisement
NeonixHD

Untitled

NeonixHD
Mar 13th, 2016
143
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.65 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM `npc_vendor` WHERE (entry = 900001);
  2. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38373, 0, 0, 0, 0);
  3. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38374, 0, 0, 0, 0);
  4. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38925, 0, 0, 0, 0);
  5. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38953, 0, 0, 0, 0);
  6. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38954, 0, 0, 0, 0);
  7. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38961, 0, 0, 0, 0);
  8. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38978, 0, 0, 0, 0);
  9. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38979, 0, 0, 0, 0);
  10. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38980, 0, 0, 0, 0);
  11. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38986, 0, 0, 0, 0);
  12. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38990, 0, 0, 0, 0);
  13. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38993, 0, 0, 0, 0);
  14. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 39001, 0, 0, 0, 0);
  15. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 39003, 0, 0, 0, 0);
  16. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 39004, 0, 0, 0, 0);
  17. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 41602, 0, 0, 0, 0);
  18. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 41611, 0, 0, 0, 0);
  19. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 43987, 0, 0, 0, 0);
  20. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44133, 0, 0, 0, 0);
  21. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44135, 0, 0, 0, 0);
  22. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44136, 0, 0, 0, 0);
  23. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44149, 0, 0, 0, 0);
  24. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44455, 0, 0, 0, 0);
  25. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44458, 0, 0, 0, 0);
  26. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44465, 0, 0, 0, 0);
  27. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44467, 0, 0, 0, 0);
  28. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44469, 0, 0, 0, 0);
  29. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44470, 0, 0, 0, 0);
  30. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44493, 0, 0, 0, 0);
  31. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44815, 0, 0, 0, 0);
  32. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44946, 0, 0, 0, 0);
  33. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44947, 0, 0, 0, 0);
  34. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 45056, 0, 0, 0, 0);
  35. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 46098, 0, 0, 0, 0);
  36. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 50368, 0, 0, 0, 0);
  37. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 50369, 0, 0, 0, 0);
  38. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38837, 0, 0, 0, 0);
  39. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 44457, 0, 0, 0, 0);
  40. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES (900001, 0, 38975, 0, 0, 0, 0);
  41.  
  42.  
  43.  
  44. DELETE FROM `npc_vendor` WHERE (entry = 900021);
  45. INSERT INTO `npc_vendor` (`entry`, `slot`, `item`, `maxcount`, `incrtime`, `ExtendedCost`, `VerifiedBuild`) VALUES
  46. (900021, 0, 43869, 0, 0, 0, 0),
  47. (900021, 0, 41103, 0, 0, 0, 0),
  48. (900021, 0, 45780, 0, 0, 0, 0),
  49. (900021, 0, 50077, 0, 0, 0, 0),
  50. (900021, 0, 43674, 0, 0, 0, 0),
  51. (900021, 0, 43332, 0, 0, 0, 0),
  52. (900021, 0, 40919, 0, 0, 0, 0),
  53. (900021, 0, 50125, 0, 0, 0, 0),
  54. (900021, 0, 41542, 0, 0, 0, 0),
  55. (900021, 0, 45806, 0, 0, 0, 0),
  56. (900021, 0, 41540, 0, 0, 0, 0),
  57. (900021, 0, 49084, 0, 0, 0, 0),
  58. (900021, 0, 43396, 0, 0, 0, 0),
  59. (900021, 0, 43432, 0, 0, 0, 0),
  60. (900021, 0, 40921, 0, 0, 0, 0),
  61. (900021, 0, 43378, 0, 0, 0, 0),
  62. (900021, 0, 43397, 0, 0, 0, 0),
  63. (900021, 0, 43423, 0, 0, 0, 0),
  64. (900021, 0, 43422, 0, 0, 0, 0),
  65. (900021, 0, 43421, 0, 0, 0, 0),
  66. (900021, 0, 45790, 0, 0, 0, 0);
  67.  
  68.  
  69.  
  70. DELETE FROM `creature_template` WHERE (entry = 900022);
  71. INSERT INTO `creature_template` (`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`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `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`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES (900022, 0, 0, 0, 0, 0, 19314, 0, 0, 0, 'Edward', 'Vendeur de composants', '', 0, 75, 75, 0, 2007, 128, 1, 1, 1, 0, 0, 2000, 2000, 1, 1, 1, 32768, 2048, 0, 0, 0, 0, 0, 0, 7, 4096, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 3, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 0, '', 12340);
  72.  
  73.  
  74.  
  75. DELETE FROM `creature_text` WHERE entry = 900022 AND groupid = 0 AND id = 0;
  76. INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES (900022, 0, 0, 'Je vend des composants pour metier et plein d''autre. Alex ma maman elle vend des glyphes aussi si vous voulez', 12, 0, 100, 0, 2, 0, 214003, 0, 'Vendeur de composants custom');
  77.  
  78.  
  79.  
  80. DELETE FROM `smart_scripts` WHERE entryorguid = 900022 AND source_type = 0 AND id = 0 AND link = 0;
  81. INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900022, 0, 0, 0, 1, 0, 100, 0, 15000, 15000, 300000, 300000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK vendeur de composants custom');
  82.  
  83.  
  84.  
  85. DELETE FROM `smart_scripts` WHERE entryorguid = 900000 AND source_type = 0 AND id = 0 AND link = 0;
  86. INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900000, 0, 0, 0, 1, 0, 100, 0, 40000, 40000, 300000, 300000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK vendeuse de gemmes custom');
  87.  
  88.  
  89.  
  90. DELETE FROM `creature_text` WHERE entry = 900002 AND groupid = 0 AND id = 0;
  91. INSERT INTO creature_text (entry, groupid, id, text, type, language, probability, emote, duration, sound, BroadcastTextId, TextRange, comment) VALUES (900002, 0, 0, 'En effet Edward et d''ailleurs, les meilleurs glyphes, c''est ici !', 12, 0, 100, 0, 2, 0, 214001, 0, 'Vendeur de glyphes custom');
  92.  
  93.  
  94. DELETE FROM `smart_scripts` WHERE entryorguid = 900002 AND source_type = 0 AND id = 0 AND link = 0;
  95. INSERT INTO smart_scripts (entryorguid, source_type, id, link, event_type, event_phase_mask, event_chance, event_flags, event_param1, event_param2, event_param3, event_param4, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_x, target_y, target_z, target_o, comment) VALUES (900002, 0, 0, 0, 1, 0, 100, 0, 20000, 20000, 300000, 300000, 1, 0, 2000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'TALK vendeur de glyphes 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!