Advertisement
irhas

Milling_fixes_w/o_reference_AMPM

May 18th, 2013
100
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.06 KB | None | 0 0
  1. -- //MILLING//
  2.  
  3. SET @Whiptail := 52988;
  4. SET @Cinder := 52983;
  5. SET @Azshveil := 52985;
  6. SET @Twijasm := 52987;
  7. SET @Heartblos := 52986;
  8. SET @Stormvine := 52984;
  9.  
  10. DELETE FROM milling_loot_template WHERE entry IN (@Whiptail, @Cinder, @Azshveil, @Twijasm, @Heartblos, @Stormvine);
  11.  
  12. INSERT INTO milling_loot_template VALUES
  13. -- Whiptail, 50% burning embers
  14. (@Whiptail,61979,100,1,0,2,4), -- Ashen Pigment
  15. (@Whiptail,61980,50,1,0,1,3), -- Burning Embers
  16.  
  17. -- Cinderbloom, 25% be
  18. (@Cinder,61979,100,1,0,2,4), -- Ashen Pigment
  19. (@Cinder,61980,25,1,0,1,3), -- Burning Embers
  20.  
  21. -- Azshara's Veil, 25% be
  22. (@Azshveil,61979,100,1,0,2,4), -- Ashen Pigment
  23. (@Azshveil,61980,25,1,0,1,3), -- Burning Embers
  24.  
  25. -- Twilight Jasmine, 50% be
  26. (@Twijasm,61979,100,1,0,2,4), -- Ashen Pigment
  27. (@Twijasm,61980,50,1,0,1,3), -- Burning Embers
  28.  
  29. -- Heartblossom, 25% be
  30. (@Heartblos,61979,100,1,0,2,4), -- Ashen Pigment
  31. (@Heartblos,61980,25,1,0,1,3), -- Burning Embers
  32.  
  33. -- Stormvine, 25% be
  34. (@Stormvine,61979,100,1,0,2,4), -- Ashen Pigment
  35. (@Stormvine,61980,25,1,0,1,3); -- Burning Embers
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement