API tools faq
paste
Advertisement
irhas

Fishing_daily_quests_both-side_AMPM(on progress)

irhas
May 22nd, 2013
139
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 12.50 KB | None | 0 0
raw download clone embed print report
  1. --//DAILY FISHING QUESTS (horde side)
  2.  
  3. -- ORGRIMMAR
  4. -- No Dumping Allowed (http://www.wowhead.com/quest=26556)
  5. DELETE FROM fishing_loot_template WHERE entry=5332 AND item=58945;
  6. INSERT INTO fishing_loot_template VALUES (5332,58945,-100,1,0,1,1);
  7. -- A Staggering Effort (http://www.wowhead.com/quest=26557)
  8. DELETE FROM fishing_loot_template WHERE entry=5171 AND item=58946;
  9. INSERT INTO fishing_loot_template VALUES (5171,58946,-100,1,0,1,1);
  10. DELETE FROM conditions WHERE SourceEntry=58946; -- Harus punya buff stag eye bait baru bisa mancing ikan quest.
  11. insert into `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) values('3','5171','58946','0','0','1','0','80868','0','0','0','0','0','','Sandy Carp can only be fished if player has been buffed by Stag Eye Bait spell');
  12. -- A Furious Catch (http://www.wowhead.com/quest=26588)
  13. DELETE FROM fishing_loot_template WHERE entry IN (814,815) AND item=58951;
  14. INSERT INTO fishing_loot_template VALUES
  15. (814,58951,-100,1,0,1,1), -- durotar
  16. (815,58951,-100,1,0,1,1); -- northern barrens
  17. -- A Golden Opportunity (http://www.wowhead.com/quest=26572)
  18. UPDATE creature_template SET unit_flags=0,unit_flags2=0,dynamicflags=0 WHERE entry=43331; -- fish nya jadi attackable, karena item questnya bug.
  19.  
  20. -- UNDERCITY
  21. -- Fish Head (http://www.wowhead.com/quest=29317)
  22. DELETE FROM fishing_loot_template WHERE entry=1497 AND item=69901;
  23. INSERT INTO fishing_loot_template VALUES (1497,69901,-100,1,0,1,1);
  24. -- Tadpole Terror (http://www.wowhead.com/quest=29319)
  25. DELETE FROM fishing_loot_template WHERE entry=810 AND item=69905;
  26. INSERT INTO fishing_loot_template VALUES (810,69905,-100,1,0,1,1);
  27. -- Like Pike? (http://www.wowhead.com/quest=29320)
  28. UPDATE gameobject_template SET flags=0 WHERE entry=208828; -- Corpse worm moundnya biar bisa di target.
  29. DELETE FROM fishing_loot_template WHERE entry=162 AND item=69909;
  30. INSERT INTO fishing_loot_template VALUES (162,69909,-100,1,0,1,1);
  31. DELETE FROM conditions WHERE SourceEntry=69909; -- Harus punya buff corpse worm bait baru bisa mancing ikan quest.
  32. insert into `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) values('3','162','69909','0','0','1','0','99315','0','0','0','0','0','','Corpse-Fed Pike can only be fished if player has been buffed by Corpse Worm Bait spell');
  33. -- Time for Slime (http://www.wowhead.com/quest=29322)
  34. DELETE FROM smart_scripts WHERE entryorguid=53517; -- smartscripts for Squirming Slime (http://www.wowhead.com/npc=53517/)
  35. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  36. ('53517','0','0','1','64','0','100','0','0','0','0','0','85','99328','2','0','0','0','0','7','0','0','0','0','0','0','0','Squirming Slime - On Gossip Hello - Cast Time for Slime: Create Slime Mold'),
  37. ('53517','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Squirming Slime - On Gossip Hello - Close Gossip'),
  38. ('53517','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Squirming Slime - On Gossip Hello - Set Npcflag None'),
  39. ('53517','0','3','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Squirming Slime - On Gossip Hello - Forced Despawn');
  40. UPDATE creature_template SET IconName='LootAll', npcflag=1, unit_flags=768, dynamicflags=8, AIName='SmartAI' WHERE entry=53517;
  41.  
  42. -- THUNDERBLUFF
  43. -- Pond Predators (http://www.wowhead.com/quest=29345)
  44. DELETE FROM fishing_loot_template WHERE entry=1638 AND item=69934;
  45. INSERT INTO fishing_loot_template VALUES (1638,69934,-100,1,0,1,1);
  46. -- The Ring's the Thing (http://www.wowhead.com/quest=29346)
  47. DELETE FROM fishing_loot_template WHERE entry=2197 AND item=69956;
  48. INSERT INTO fishing_loot_template VALUES (2197,69956,-100,1,0,1,1);
  49. -- The Race to Restock (http://www.wowhead.com/quest=29348)
  50. DELETE FROM fishing_loot_template WHERE entry=223 AND item IN (69964,69967);
  51. INSERT INTO fishing_loot_template VALUES
  52. (223,69964,-100,1,0,1,1),
  53. (223,69967,-100,1,0,1,1);
  54. -- Craving Crayfish (http://www.wowhead.com/quest=29349)
  55. DELETE FROM smart_scripts WHERE entryorguid=53561;
  56. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  57. ('53561','0','0','1','64','0','100','0','0','0','0','0','85','99473','2','0','0','0','0','7','0','0','0','0','0','0','0','Stonebull Crayfish - On Gossip Hello - Cast Craving Crayfish: Create Stonebull Crayfish'),
  58. ('53561','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Stonebull Crayfish - On Gossip Hello - Close Gossip'),
  59. ('53561','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Stonebull Crayfish - On Gossip Hello - Set Npcflag None'),
  60. ('53561','0','3','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Stonebull Crayfish - On Gossip Hello - Forced Despawn');
  61. UPDATE creature_template SET IconName='LootAll', faction_A=190, faction_H=190, npcflag=1, unit_flags=768, dynamicflags=8, questItem1=0, AIName='SmartAI'  WHERE entry=53561;
  62. DELETE FROM fishing_loot_template WHERE entry=223 AND item=69977;
  63. INSERT INTO fishing_loot_template VALUES (223,69977,-100,1,0,1,1);
  64.  
  65.  
  66. --//DAILY FISHING QUESTS (alliance side)
  67.  
  68. -- STORMWIND
  69. -- Hitting a Walleye (http://www.wowhead.com/quest=26414)
  70. DELETE FROM fishing_loot_template WHERE entry=5314 AND item=58503;
  71. INSERT INTO fishing_loot_template VALUES (5314,58503,-100,1,0,1,1);
  72. -- Thunder Falls (http://www.wowhead.com/quest=26536)
  73. DELETE FROM fishing_loot_template WHERE entry=61 AND item=58899;
  74. INSERT INTO fishing_loot_template VALUES (61,58899,-100,1,0,1,1);
  75. -- Diggin' For Worms (http://www.wowhead.com/quest=26420)
  76. DELETE FROM fishing_loot_template WHERE entry=5316 AND item=58787;
  77. INSERT INTO fishing_loot_template VALUES (5316,58787,-100,1,0,1,1);
  78. DELETE FROM conditions WHERE SourceEntry=58787; -- Harus punya buff worm bait baru bisa mancing ikan quest.
  79. insert into `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) values('3','5316','58787','0','0','1','0','80534','0','0','0','0','0','','Crystal Bass can only be fished if player has been buffed by Worm Bait spell');
  80. -- Big Gulp (http://www.wowhead.com/quest=26488)
  81. DELETE FROM fishing_loot_template WHERE entry=1617 AND item=58856;
  82. INSERT INTO fishing_loot_template VALUES (1617,58856,-100,1,0,1,1);
  83.  
  84. -- DARNASSUS
  85. -- The Sister's Pendant (http://www.wowhead.com/quest=29324)
  86. DELETE FROM fishing_loot_template WHERE entry=1657 AND item=69914;
  87. INSERT INTO fishing_loot_template VALUES (1657,69914,-100,1,0,1,1);
  88. -- An Old Favorite (http://www.wowhead.com/quest=29359)
  89. DELETE FROM fishing_loot_template WHERE entry=702 AND item=69987;
  90. INSERT INTO fishing_loot_template VALUES (702,69987,-100,1,0,1,1);
  91. -- Stocking Up (http://www.wowhead.com/quest=29323)
  92. DELETE FROM fishing_loot_template WHERE entry=1657 AND item=69912;
  93. INSERT INTO fishing_loot_template VALUES (1657,69912,-100,1,0,1,1);
  94. -- A Slippery Snack (http://www.wowhead.com/quest=29325)
  95. DELETE FROM creature WHERE id=53522; -- belum di spawnin Baby Octopusnya.
  96. insert into `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`) values
  97. ('53522','1','1','1','0','0','8458.62','737.44','-13.6763','2.17209','60','10','0','102','0','1','0','0','0'),
  98. ('53522','1','1','1','0','0','8411.91','770.444','-13.5545','2.69439','60','10','0','102','0','1','0','0','0'),
  99. ('53522','1','1','1','0','0','8370.85','769.601','-14.0358','2.94541','60','10','0','102','0','1','0','0','0'),
  100. ('53522','1','1','1','0','0','8380.19','811.638','-13.5617','2.9729','60','10','0','102','0','1','0','0','0'),
  101. ('53522','1','1','1','0','0','8346.58','816.939','-14.0358','2.9729','60','10','0','102','0','1','0','0','0'),
  102. ('53522','1','1','1','0','0','8323.32','802.015','-14.0354','3.80315','60','10','0','102','0','1','0','0','0'),
  103. ('53522','1','1','1','0','0','8294.14','785.569','-14.0359','3.35427','60','10','0','102','0','1','0','0','0'),
  104. ('53522','1','1','1','0','0','8275.38','802.611','-14.0353','2.36202','60','10','0','102','0','1','0','0','0'),
  105. ('53522','1','1','1','0','0','8223.51','795.656','-13.9642','1.67352','60','10','0','102','0','1','0','0','0'),
  106. ('53522','1','1','1','0','0','8211.05','827.412','-14.6797','2.20002','60','10','0','102','0','1','0','0','0'),
  107. ('53522','1','1','1','0','0','8199.12','832.157','-14.1429','2.72652','60','10','0','102','0','1','0','0','0'),
  108. ('53522','1','1','1','0','0','8203.23','849.075','-12.7963','1.30002','60','10','0','102','0','1','0','0','0'),
  109. ('53522','1','1','1','0','0','8218.16','846.465','-6.72232','6.22871','60','10','0','102','0','1','0','0','0'),
  110. ('53522','1','1','1','0','0','8226.6','813.963','-15.3089','5.41975','60','10','0','102','0','1','0','0','0'),
  111. ('53522','1','1','1','0','0','8262.34','811.962','-12.6631','0.577769','60','10','0','102','0','1','0','0','0'),
  112. ('53522','1','1','1','0','0','8314.01','818.843','-13.352','1.14325','60','10','0','102','0','1','0','0','0'),
  113. ('53522','1','1','1','0','0','8335.54','798.687','-14.0359','5.60607','60','10','0','102','0','1','0','0','0'),
  114. ('53522','1','1','1','0','0','8390.92','789.366','-14.0361','5.39008','60','10','0','102','0','1','0','0','0');
  115. DELETE FROM smart_scripts WHERE entryorguid=53522;
  116. INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES
  117. ('53522','0','0','1','64','0','100','0','0','0','0','0','85','99340','2','0','0','0','0','7','0','0','0','0','0','0','0','Baby Octopus - On Gossip Hello - Cast Pickup Baby Octopus'),
  118. ('53522','0','1','2','61','0','100','0','0','0','0','0','72','0','0','0','0','0','0','7','0','0','0','0','0','0','0','Baby Octopus - On Gossip Hello - Close Gossip'),
  119. ('53522','0','2','3','61','0','100','0','0','0','0','0','81','0','0','0','0','0','0','1','0','0','0','0','0','0','0','Baby Octopus - On Gossip Hello - Set Npcflag None'),
  120. ('53522','0','3','0','61','0','100','0','0','0','0','0','41','120','0','0','0','0','0','1','0','0','0','0','0','0','0','Baby Octopus - On Gossip Hello - Forced Despawn');
  121. UPDATE creature_template SET IconName='LootAll', faction_A=190, faction_H=190, npcflag=1, unit_flags=768, dynamicflags=8, questItem1=0, AIName='SmartAI'  WHERE entry=53522;
  122.  
  123. -- IRONFORGE
  124. -- Cold Water Fishing (http://www.wowhead.com/quest=29342)
  125. DELETE FROM fishing_loot_template WHERE entry=212 AND item=69931;
  126. INSERT INTO fishing_loot_template VALUES (212,69931,-100,1,0,1,1);
  127. -- Fish fer Squirky (http://www.wowhead.com/quest=29344)
  128. -- Live Bait (http://www.wowhead.com/quest=29347)
  129. -- One fer the Ages (http://www.wowhead.com/quest=29343)
  130. DELETE FROM fishing_loot_template WHERE entry=4679 AND item=69932;
  131. INSERT INTO fishing_loot_template VALUES (4679,69932,-100,1,0,1,1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!