Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Směska1

By: Drujd on May 2nd, 2012  |  syntax: SQL  |  size: 2.52 KB  |  hits: 20  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. UPDATE creature_onkill_reputation SET maxstanding1 = 4, rewonkillrepvalue1 = 5 WHERE creature_id = 11746;
  2. UPDATE creature_onkill_reputation SET maxstanding1 = 4, rewonkillrepvalue1 = 5 WHERE creature_id = 11744;
  3. UPDATE creature_onkill_reputation SET maxstanding1 = 4, rewonkillrepvalue1 = 5 WHERE creature_id = 7032;
  4. UPDATE creature_onkill_reputation SET maxstanding1 = 5, rewonkillrepvalue1 = 15 WHERE creature_id = 9017;
  5. UPDATE creature_onkill_reputation SET maxstanding1 = 5, rewonkillrepvalue1 = 25 WHERE creature_id = 14478;
  6. UPDATE creature_onkill_reputation SET maxstanding1 = 5, rewonkillrepvalue1 = 50 WHERE creature_id = 9816;
  7. UPDATE creature_onkill_reputation SET maxstanding1 = 5, rewonkillrepvalue1 = 20 WHERE creature_id IN (11668,12101,11673,11658);
  8. UPDATE creature_onkill_reputation SET maxstanding1 = 5, rewonkillrepvalue1 = 40 WHERE creature_id IN (11666,11667,12076,12100,11659);
  9. UPDATE creature_onkill_reputation SET maxstanding1 = 6, rewonkillrepvalue1 = 100 WHERE creature_id IN (12118,11982,12259,12057,12056,12264,12098);
  10. UPDATE creature_onkill_reputation SET maxstanding1 = 7, rewonkillrepvalue1 = 150 WHERE creature_id IN (11988);
  11. UPDATE creature_onkill_reputation SET maxstanding1 = 7, rewonkillrepvalue1 = 200 WHERE creature_id IN (11502);
  12.  
  13.  
  14. UPDATE creature_template SET faction_A = 76, faction_H = 76 WHERE entry = 32856;
  15. UPDATE creature_loot_template SET chanceorquestchance = -78 WHERE item = 12366 AND entry = 7457;  
  16. UPDATE creature_loot_template SET chanceorquestchance = -43 WHERE item = 12366 AND entry = 7458;
  17. UPDATE creature_loot_template SET chanceorquestchance = -48 WHERE item = 12366 AND entry = 7459;
  18. UPDATE creature_loot_template SET chanceorquestchance = -47 WHERE item = 12366 AND entry = 7460;
  19. UPDATE creature_loot_template SET chanceorquestchance = -71 WHERE item = 64586 AND entry = 48960;
  20. UPDATE prospecting_loot_template SET chanceorquestchance = '1.3' WHERE item = 52190 AND entry = 53038;
  21. UPDATE prospecting_loot_template SET chanceorquestchance = 7 WHERE item = 52190 AND entry = 52183;
  22.  
  23. UPDATE creature_template SET modelid1= 24741 WHERE entry = 8303;
  24. INSERT INTO creature_model_info (modelid, bounding_radius, combat_reach, gender, modelid_other_gender) VALUES (37577, 1, 1, 2, 0);
  25. UPDATE creature_template SET modelid1= 37577 WHERE entry = 2931;
  26. UPDATE quest_template SET MinLevel = 255 WHERE entry =1368;
  27. UPDATE creature_loot_template SET chanceorquestchance = -10 WHERE item = 28668 AND entry =17133;
  28. UPDATE creature_loot_template SET chanceorquestchance = -51 WHERE item = 28665 AND entry =19201;
create a new version of this paste RAW Paste Data