Facebook

Re: Re: CHP2 Vendor Stuff safest cryptocurrency exchange

From Bruce, 1 Month ago, written in Plain Text.
This paste is a reply to Re: CHP2 Vendor Stuff from Bruce - view diff
URL https://pastebin.pl/view/3807c132
Embed
Download Paste or View Raw
Hits: 220
  1. SELECT sp.ID, sp.SpellName0 FROM spell sp WHERE sp.id IN (293523,93429,293508,293509,293510,293511,293512,293513,293514,93430,293430,293431,293432,293433,293434,293435,293436,93431,293437,293438,293439,293440,293441,93432,293442,293443,293444,93433,293445,293446,991538,293480,293481,293482,293483,293484,293485,293486,991539,293487,293488,293489,293490,293491,293497,293498,991540,293492,293493,293494,293495,293496,293499,293500,991541,293501,293502,293503,293504,293505,293506,293507,991869,293468,293469,293470,293471,293472,293473,293474,991870,293447,293448,293449,293450,293451,293452,293453,991871,293454,293455,293456,293457,293458,293459,293460,991872,293461,293462,293463,293464,293465,293466,293467,991881,293475,293476,293477,293478,293479,991576,991874,991868,293516, 293515,293517,293518,293519,293520,293521,293522);
  2. SELECT * FROM dbc_skill_line_ability WHERE spell IN (293523,93429,293508,293509,293510,293511,293512,293513,293514,93430,293430,293431,293432,293433,293434,293435,293436,93431,293437,293438,293439,293440,293441,93432,293442,293443,293444,93433,293445,293446,991538,293480,293481,293482,293483,293484,293485,293486,991539,293487,293488,293489,293490,293491,293497,293498,991540,293492,293493,293494,293495,293496,293499,293500,991541,293501,293502,293503,293504,293505,293506,293507,991869,293468,293469,293470,293471,293472,293473,293474,991870,293447,293448,293449,293450,293451,293452,293453,991871,293454,293455,293456,293457,293458,293459,293460,991872,293461,293462,293463,293464,293465,293466,293467,991881,293475,293476,293477,293478,293479,991576,991874,991868,293516, 293515,293517,293518,293519,293520,293521,293522);
  3. SELECT spell_id FROM spell_ranks WHERE COMMENT LIKE  '%manastorm%';
  4. #Manastorm Purge-O-Matic
  5. SELECT * FROM item_template WHERE entry IN (439124);
  6. SELECT * FROM spell WHERE id IN (293523);
  7. SELECT * FROM dbc_skill_line_ability WHERE id IN (20530);
  8. #Vendor
  9. SELECT * FROM npc_vendor WHERE item IN (439124);
  10. #Cogsley
  11. SELECT * FROM npc_vendor WHERE item IN (439124);
  12. #Cosmetic Stuff
  13. SELECT * FROM creature_template WHERE entry IN (98486,98485,98484,207016,98483,98481,98482,840069,532578);
  14. SELECT * FROM item_template WHERE entry IN (754706,532580,280760,532578,532572,532573,532575,532576,532577,532579,428236);
  15. SELECT * FROM store_collection_items WHERE itemid IN (754706,280760,532578,532572,532573,532575,532576,532577,532579,428236,532580);
  16. SELECT * FROM npc_vendor WHERE item IN (754706,280760,532578,532572,532573,532575,532576,532577,532579,428236,532580);
  17. SELECT * FROM dbc_item_extended_cost WHERE id IN (4218,4219,4500,4501,4502,4503);
  18. SELECT * FROM spell WHERE id IN (1019250,992089,992088,1019250,800829,800830,992077,23143,992079,992080,992081,992082,992083,992084,992086);
  19. SELECT * FROM dbc_item_display_info WHERE id IN (666667,317370);
  20. SELECT * FROM dbc_skill_line_ability WHERE spell IN (1019250,800829,992077);
  21. SELECT * from dbc_override_spell_data WHERE id IN (310);
  22. SELECT * FROM creature_model_info WHERE displayid IN (58182,80995,91634,73601,91656,89767);
  23. SELECT * FROM dbc_creature_display_info WHERE id =58182;
  24. SELECT * FROM dbc_creature_model_data WHERE id =5359;
  25. #Vendor Area Stuff
  26. SELECT * from creature where guid IN (1434286,1434289);
  27. SELECT * FROM game_event_creature WHERE evententry = 1189;
  28. SELECT * FROM game_event WHERE evententry = 1189;
  29. #Mech Cat Stuff
  30. SELECT * FROM item_template WHERE entry BETWEEN 754699 AND 754707;
  31. SELECT * FROM item_template WHERE entry BETWEEN 428234 AND 428239;
  32. SELECT * FROM store_collection_items WHERE itemid BETWEEN 754699 AND 754707;
  33. SELECT * FROM store_collection_items WHERE itemid BETWEEN 428234 AND 428239;
  34. SELECT * FROM dbc_item_display_info WHERE id IN (305571);
  35. SELECT * FROM spell WHERE id BETWEEN 991785 AND 991793;
  36. SELECT * FROM spell WHERE id BETWEEN 1120802 AND 1120807;
  37. SELECT * FROM dbc_creature_display_info WHERE id BETWEEN 74804 AND 74812;
  38. SELECT * FROM creature_template WHERE entry BETWEEN 404518 AND 404526;
  39. SELECT * FROM dbc_creature_model_data WHERE id IN (9900);
  40. SELECT * FROM creature_model_info WHERE displayid BETWEEN 74804 AND 74812;
  41. SELECT * FROM dbc_spellicon WHERE id IN (16772);
  42. SELECT * FROM dbc_skill_line_ability WHERE spell IN (1120802,1120803,1120804);
  43. SELECT * FROM dbc_spellvisual WHERE id IN (100614);
  44. SELECT * FROM dbc_spell_visual_kit WHERE id IN (105923);
  45. SELECT * FROM dbc_sound_entries WHERE id IN (95987);
  46. #Conditions
  47. SELECT * FROM npc_vendor WHERE entry IN (179539);
  48. SELECT * FROM conditions WHERE sourcegroup = 179539 OR sourceentry = 179539;
  49. SELECT * FROM store_collection_items WHERE itemid IN (339030,439030,439031,439032,439033,439034,339031,539031,539032,539033,339033,439035,439036,339041,439057,439058,439059,439060,439061,439062,439063,339074,439113,439114,439115,439116,439117,339050,439050,439051,439052,439053,439054,439055,439056,339077,439125,439126,439127,439128,439129,439130,339034,439037,439038,439039,439041,439042,439043,439044,339035,439064,439065,439066,439067,439068,439069,439070,339037,439078,439079,439080,439081,439082,439083,439084,339036,439071,439072,439073,439074,439075,439076,439077,339063,439085,439086,439087,439088,439089,439090,439091,339070,439092,439093,439094,439095,439096,439097,439098,339071,439099,439100,439101,439102,439103,439104,439105,339072,439106,439107,439108,439109,439110,439111,439112,339042,439124,339062);
  50. #cogsley
  51. SELECT * FROM npc_vendor WHERE entry IN (80919);
  52. SELECT * FROM conditions WHERE sourcegroup = 80919 OR sourceentry = 80919;
  53. #cogsworth
  54. SELECT * FROM npc_vendor WHERE entry IN (179539);
  55. SELECT * FROM conditions WHERE sourcegroup = 179539 OR sourceentry = 179539;
  56. #vanity setup for all potions
  57. SELECT * FROM store_collection_items WHERE itemid IN (339030,439030,439031,439032,439033,439034,339031,539031,539032,539033,339033,439035,439036,339041,439057,439058,439059,439060,439061,439062,439063,339074,439113,439114,439115,439116,439117,339050,439050,439051,439052,439053,439054,439055,439056,339077,439125,439126,439127,439128,439129,439130,339034,439037,439038,439039,439041,439042,439043,439044,339035,439064,439065,439066,439067,439068,439069,439070,339037,439078,439079,439080,439081,439082,439083,439084,339036,439071,439072,439073,439074,439075,439076,439077,339063,439085,439086,439087,439088,439089,439090,439091,339070,439092,439093,439094,439095,439096,439097,439098,339071,439099,439100,439101,439102,439103,439104,439105,339072,439106,439107,439108,439109,439110,439111,439112,339042,439124,339062);
  58. #pricing for all potions
  59. SELECT * FROM dbc_item_extended_cost WHERE id IN (4393,4394,4395,4396,4397,4398,4399,4400,4401,4402,4403,4404,4405,4406,4407,4408,4409,4410,4411,4412,4413,4414,4415,4416,4417,4418,4419,4420,4421,4422,4423,4424,4425,4426,4427,4428,4429,4430,4431,4432,4433,4434,4435,4436,4437);
  60. #all potions items
  61. SELECT * FROM item_template WHERE entry IN (339030,439030,439031,439032,439033,439034,339031,539031,539032,539033,339033,439035,439036,339041,439057,
  62. 439058,439059,439060,439061,439062,439063,339074,439113,439114,439115,439116,439117,339050,439050,439051,439052,439053,439054,439055,439056,339077,
  63. 439125,439126,439127,439128,439129,439130,339034,439037,439038,439039,439041,439042,439043,439044,339035,439064,439065,439066,439067,439068,439069,
  64. 439070,339037,439078,439079,439080,439081,439082,439083,439084,339036,439071,439072,439073,439074,439075,439076,439077,339063,439085,439086,439087,
  65. 439088,439089,439090,439091,339070,439092,439093,439094,439095,439096,439097,439098,339071,439099,439100,439101,439102,439103,439104,439105,339072,
  66. 439106,439107,439108,439109,439110,439111,439112,339042,339062,439124);
  67. #manastorm and harrison jones reworked
  68. SELECT * FROM creature_template WHERE entry IN (179538,179541);
  69. SELECT * FROM npc_vendor WHERE entry IN (179536,179538);
  70. SELECT * FROM npc_vendor WHERE entry IN (179541,179540);
  71. SELECT * FROM gossip_menu_option WHERE menu_id IN (42200,42201);
  72. SELECT * FROM gossip_menu WHERE entry IN (42200,42201);
  73. SELECT * FROM npc_text WHERE id IN (179538,179541);
  74. SELECT * FROM conditions WHERE sourcegroup IN (179538);
  75. SELECT * FROM conditions WHERE sourcegroup IN (179541);
  76. #fixes to tomes
  77. SELECT entry, NAME, bonding FROM item_template WHERE entry IN (1500126,1500128,1500134,1500135,1500136,1500141,1500147,1500153,1501804);
  78. SELECT entry, NAME, bonding FROM item_template WHERE entry IN (1500127,1500129,1500130,1500131,1500132,1500133,1500138,1500139,1500140,1500154);

Replies to Re: Re: CHP2 Vendor Stuff rss

Title Name Language When
CHP2 Vendor Stuff Bruce text 1 Month ago.
Re: Re: Re: CHP2 Vendor Stuff Bruce text 1 Month ago.

Reply to "Re: Re: CHP2 Vendor Stuff"