Advertisement
bucur35

Strained Supplies

Aug 24th, 2012
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.48 KB | None | 0 0
  1. /********************
  2. Strained Supplies
  3. ********************/
  4.  
  5. /***********
  6.   Assign
  7. ***********/
  8.  
  9. UPDATE `creature_template` SET `questItem1`=25802 WHERE  `entry`=18466 LIMIT 1;  
  10.  
  11. /***********
  12.    Script
  13.  **********/  
  14.  
  15. DELETE FROM `gameobject_loot_template` WHERE  `entry`=18466 AND `item`=25802 LIMIT 1;
  16. INSERT INTO `gameobject_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`,
  17.  `groupid`, `mincountOrRef`, `maxcount`) VALUES
  18. (18466, 25802, 65, 1, 0, 1, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement