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

Pelf blackwing descent sql (fix)

By: a guest on May 8th, 2012  |  syntax: SQL  |  size: 1.28 KB  |  hits: 42  |  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. DELETE FROM `gameobject` WHERE `id`=24388 AND `map`=669;
  2. DELETE FROM `gameobject` WHERE `id`=202211 AND `map`=669;
  3. DELETE FROM `gameobject` WHERE `id`=205079 AND `map`=669;
  4. DELETE FROM `gameobject` WHERE `id`=207207 AND `map`=669;
  5. DELETE FROM `gameobject` WHERE `id`=185216 AND `map`=669;
  6. DELETE FROM `gameobject` WHERE `id`=185217 AND `map`=669;
  7. DELETE FROM `gameobject` WHERE `id`=185218 AND `map`=669;
  8. UPDATE `creature_template` SET `modelid1`=30890, `modelid2`=0, `modelid3`=0 WHERE `entry`=49973;
  9. UPDATE `creature_template` SET `modelid1`=30890, `modelid2`=0, `modelid3`=0 WHERE `entry`=49985;
  10. UPDATE `creature_template` SET `modelid1`=30890, `modelid2`=0, `modelid3`=0 WHERE `entry`=49979;
  11. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=41445;
  12. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42958;
  13. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42947;
  14. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42960;
  15. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42949;
  16. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42951;
  17. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42954;
  18. UPDATE `creature_template` SET `IconName`='Interact' WHERE `entry`=42956;
create a new version of this paste RAW Paste Data