Guest User

Untitled

a guest
Jun 18th, 2018
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.65 KB | None | 0 0
  1.    1. -- Pool quests from The Rokk (24393)
  2.    2.  
  3.    3. SET @pool_id := XY;
  4.    4.  
  5.    5. DELETE FROM `pool_template` WHERE `entry` = @pool_id;
  6.    6. INSERT INTO `pool_template` (`entry`, `max_limit`, `description`) VALUES
  7.    7. (@pool_id, 1, 'The Rokk <Master of Cooking> - Daily Quests');
  8.    8.  
  9.    9. DELETE FROM `pool_quest` WHERE `entry` IN (11380, 11377, 11381, 11379) AND `pool_entry` = @pool_id;
  10.   10. INSERT INTO `pool_quest` (`entry`, `pool_entry`, `description`) VALUES
  11.   11. (11380, @pool_id, 'Manalicious'),
  12.   12. (11377, @pool_id, 'Revenge is Tasty'),
  13.   13. (11381, @pool_id, 'Soup for the Soul'),
  14.   14. (11379, @pool_id, 'Super Hot Stew');
Add Comment
Please, Sign In to add comment