Guest User

Untitled

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