Advertisement
irhas

Skill_fishing_base_level_fix_AMPM

May 19th, 2013
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 1.08 KB | None | 0 0
  1. -- //FISHING LEVEL
  2. SET @level := 1; -- valuenya di isi sendiri, diisi 1 berarti fishing skill 1 udah bisa mancing di hyjal,deepholm,twilight, dan map-map baru cata.
  3.  
  4. -- Prevent loading core warnings (areaID are properly defined)
  5. -- Hyjal
  6. DELETE FROM skill_fishing_base_level WHERE entry=616;
  7. INSERT INTO skill_fishing_base_level VALUES
  8. (616,@level);
  9. -- Deepholm
  10. DELETE FROM skill_fishing_base_level WHERE entry=5042;
  11. INSERT INTO skill_fishing_base_level VALUES
  12. (5042,@level);
  13. -- Uldum
  14. DELETE FROM skill_fishing_base_level WHERE entry=5034;
  15. INSERT INTO skill_fishing_base_level VALUES
  16. (5034,@level);
  17. -- Tolbarad
  18. DELETE FROM skill_fishing_base_level WHERE entry IN (5095,5389);
  19. INSERT INTO skill_fishing_base_level VALUES
  20. (5095,@level),
  21. (5389,@level);
  22. -- Vash'jir
  23. DELETE FROM skill_fishing_base_level WHERE entry IN (5144,5145,5146,4815);
  24. INSERT INTO skill_fishing_base_level VALUES
  25. (5144,@level),
  26. (5145,@level),
  27. (5146,@level),
  28. (4815,@level);
  29. -- Twilight Highlands
  30. DELETE FROM skill_fishing_base_level WHERE entry=4922;
  31. INSERT INTO skill_fishing_base_level VALUES
  32. (4922,@level);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement