Trinitycore: DB/Event: Stranglethorn Vale Fishing Extravaganza - Cosmetics

[schell244]

Description:
Stranglethorn Vale Fishing Extravaganza:
https://de.classic.wowhead.com/guides/wow-classic-stranglethorn-vale-fishing-extravaganza

• spawn location of event/quest npc's are incorrect - reference https://www.youtube.com/watch?v=sQVU81yKZIs
  https://classic.wowhead.com/npc=15077/riggle-bassbait
  https://classic.wowhead.com/npc=15079/fishbot-5000
  https://classic.wowhead.com/npc=15078/jang

• master-angler quest can only be completed by one player each week, currently there seems to be no limit
  https://classic.wowhead.com/quest=8193/master-angler

• some map wide announcements from [riggle bassbait] are missing

I found some related broadcast texts (did not check what's currently used):

map wide broadcasted:
10608 = Let the Fishing Tournament BEGIN! (at 2pm server time when event starts)
10609 = And the Tastyfish have gone for the week!   I will remain for another hour to allow you to turn in your fish! (when pools become unavailable at 4pm) 
10610 = We have a winner!  $n has won FIRST PLACE in the tournament! (when master-angler quest is turned in)

some more related texts:
10600 = We already have all our winners for today's contest, but Jang is willing to purchase any Tastyfish that you have fished up! There's always next Sunday for you to show your angling skill! 
10475 = Welcome to the Booty Bay fishing contest where each week we reward the finest fishermen in all of Azeroth.
When the fishing tournament begins, you will be able to catch tastyfish from any fishing node in Stranglethorn.

events ids: (.event start x)
Stranglethorn Fishing Extravaganza Announce: 14
Stranglethorn Fishing Extravaganza Fishing Pools: 15
Stranglethorn Fishing Extravaganza Turn-ins: 62

linked issue: https://github.com/TrinityCore/TrinityCore/issues/25409

Branch(es):
3.3.5

TC rev. hash/commit:
TrinityCore rev. 3b1e911da355 2020-09-06 01:40:00 +0200 (3.3.5 branch) (Win64, Release, Static)

Operating system:
Win10

[illfated]

Could also mention that the drop rate for very rare fish (3 different ones) seems to be less than on retail (from my experience 2006-2010 when I got a rare fish in ≈ 50% of the times I participated in the contest).

[dr-j]

I will look for my sql script for this and kalu’ak fishing derby event with all announcements but it involves adding yet another custom game event for both of these which gets stopped once main quest has been turned which disables further turn ins of that quest and then only allows quest for lesser prize to be taken after that as long as turn in event is still running

[dr-j]

I have a feeling there may still be something missing from here or I may have appended it elsewhere cough also event ids will need changing in below script
~~~sql
UPDATE creature_template SET AIName='SmartAI' WHERE entry=38294;
DELETE FROM smart_scripts WHERE entryorguid IN(3829400,3829401) AND source_type=9;

DELETE FROM smart_scripts WHERE entryorguid=38294 AND source_type=0;
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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, cus_target_param1, comment) VALUES
(38294, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Reset - Set Active'),
(38294, 0, 1, 6, 68, 0, 100, 0, 64, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Event Started - Say Line 0'),
(38294, 0, 2, 0, 69, 0, 100, 0, 64, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Event Ended - Say Line 2'),
(38294, 0, 3, 4, 20, 0, 100, 0, 24803, 0, 0, 0, 0, 111, 222, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Quest Returned - Stop Event'),
(38294, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Quest Returned - Say Line 1'),
(38294, 0, 5, 0, 11, 0, 100, 0, 0, 0, 0, 0, 0, 80, 3829400, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Spawn - Run Script'),
(38294, 0, 6, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 80, 3829401, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - On Event Started - Run Script 2'),
(3829400, 9, 0, 0, 0, 0, 100, 0, 2400000, 2400000, 0, 0, 0, 1, 3, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - Script - Say Line 3'),
(3829400, 9, 1, 0, 0, 0, 100, 0, 600000, 600000, 0, 0, 0, 1, 4, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - Script - Say Line 4'),
(3829400, 9, 2, 0, 0, 0, 100, 0, 300000, 300000, 0, 0, 0, 1, 5, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - Script - Say Line 5'),
(3829401, 9, 0, 0, 0, 0, 100, 0, 3000000, 3000000, 0, 0, 0, 1, 6, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - Script 2 - Say Line 6'),
(3829401, 9, 1, 0, 0, 0, 100, 0, 300000, 300000, 0, 0, 0, 1, 7, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Elder Clearwater - Script 2 - Say Line 7');

DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceGroup=0 AND SourceEntry IN(24803,24806);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19, 0, 24803, 0, 0, 12, 0, 222, 0, 0, 0, 0, 0, '', 'Kaluak fishing deby'),
(19, 0, 24806, 0, 0, 12, 0, 222, 0, 0, 1, 0, 0, '', 'Better Luck Next time');

UPDATE quest_template_addon SET ExclusiveGroup='24803' WHERE IDIN(24803,24806);

DELETE FROM creature_text WHERE CreatureID=38294;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(38294, 0, 0, "The Kalu'ak Fishing Derby has begun! The first person to bring a blacktip shark to me in Dalaran will be declared the winner! Blacktip sharks can be caught anywhere you can catch a pygmy suckerfish.", 14, 0, 100, 0, 0, 0, 38218, 3, 'Elder Clearwater'),
(38294, 1, 0, "$n has won the Kalu'ak Fishing Derby!", 14, 0, 100, 0, 0, 0, 38219, 3, 'Elder Clearwater'),
(38294, 2, 0, "The Kalu'ak Fishing Derby has ended! If you caught a shark, please bring it to me within the hour.", 14, 0, 100, 0, 0, 0, 38222, 3, 'Elder Clearwater'),
(38294, 3, 0, "The Kalu'ak Fishing Derby starts in 20 minutes!", 14, 0, 100, 0, 0, 0, 38215, 3, 'Elder Clearwater'),
(38294, 4, 0, "The Kalu'ak Fishing Derby starts in 10 minutes!", 14, 0, 100, 0, 0, 0, 38216, 3, 'Elder Clearwater'),
(38294, 5, 0, "The Kalu'ak Fishing Derby starts in 5 minutes!", 14, 0, 100, 0, 0, 0, 38217, 3, 'Elder Clearwater'),
(38294, 6, 0, "Only 10 minutes remain before the Kalu'ak Fishing Derby ends!", 14, 0, 100, 0, 0, 0, 38220, 3, 'Elder Clearwater'),
(38294, 7, 0, "The Kalu'ak Fishing Derby ends in 5 minutes!", 14, 0, 100, 0, 0, 0, 38221, 3, 'Elder Clearwater');

DELETE FROM game_event WHERE eventEntry=222;
INSERT INTO game_event (eventEntry, start_time, end_time, occurence, length, holiday, holidayStage, description, world_event, announce) VALUES
(222, '2016-10-29 14:00:00', '2030-12-31 06:00:00', 10080, 180, 424, 0, 'Kalu\'ak Fishing Derby Fishing Pools (Main Prize Available)', 0, 2);
`` UPDATEcreature_templateSETAIName='SmartAI' WHEREentry`=15077;

DELETE FROM smart_scripts WHERE entryorguid=15077 AND source_type=0;
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, event_param5, action_type, action_param1, action_param2, action_param3, action_param4, action_param5, action_param6, target_type, target_param1, target_param2, target_param3, target_param4, target_x, target_y, target_z, target_o, cus_target_param1, comment) VALUES
(15077, 0, 0, 0, 25, 0, 100, 0, 0, 0, 0, 0, 0, 48, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Riggle Bassbait - On Reset - Set Active'),
(15077, 0, 1, 0, 68, 0, 100, 0, 64, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Riggle Bassbait - On Event Started - Say Line 0'),
(15077, 0, 2, 0, 69, 0, 100, 0, 64, 0, 0, 0, 0, 1, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Riggle Bassbait - On Event Ended - Say Line 2'),
(15077, 0, 3, 4, 20, 0, 100, 0, 8193, 0, 0, 0, 0, 111, 223, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Riggle Bassbait - On Quest Returned - Stop Event'),
(15077, 0, 4, 0, 61, 0, 100, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'Riggle Bassbait - On Quest Returned - Say Line 1');

DELETE FROM conditions WHERE SourceTypeOrReferenceId=19 AND SourceGroup=0 AND SourceEntry IN(8193);
INSERT INTO conditions (SourceTypeOrReferenceId, SourceGroup, SourceEntry, SourceId, ElseGroup, ConditionTypeOrReference, ConditionTarget, ConditionValue1, ConditionValue2, ConditionValue3, NegativeCondition, ErrorType, ErrorTextId, ScriptName, Comment) VALUES
(19, 0, 8193, 0, 0, 12, 0, 223, 0, 0, 0, 0, 0, '', 'Master Angler');

DELETE FROM creature_text WHERE CreatureID=15077;
INSERT INTO creature_text (CreatureID, GroupID, ID, Text, Type, Language, Probability, Emote, Duration, Sound, BroadcastTextId, TextRange, comment) VALUES
(15077, 0, 0, "Let the Fishing Tournament BEGIN!", 14, 0, 100, 0, 0, 0, 10608, 2, 'Riggle Bassbait'),
(15077, 1, 0, "We already have all our winners for today's contest, but Jang is willing to purchase any Tastyfish that you have fished up! There's always next Sunday for you to show your angling skill!", 14, 0, 100, 0, 0, 0, 10600, 2, 'Riggle Bassbait'),
(15077, 2, 0, "And the Tastyfish have gone for the week! I will remain for another hour to allow you to turn in your fish!", 14, 0, 100, 0, 0, 0, 10609, 2, 'Riggle Bassbait');

DELETE FROM game_event WHERE eventEntry=223;
INSERT INTO game_event (eventEntry, start_time, end_time, occurence, length, holiday, holidayStage, description, world_event, announce) VALUES
(223, '2016-10-30 12:00:00', '2030-12-31 06:00:00', 10080, 180, 0, 0, 'Stranglethorn Fishing Extravaganza Turn-ins (Main Prize Available)', 0, 2);

UPDATE quest_template_addon SET SpecialFlags='1' WHERE ID=24803;
UPDATE quest_template_addon SET SpecialFlags='1' WHERE ID=24806;

UPDATE conditions SET ConditionValue1='64' WHERE SourceTypeOrReferenceId=4 AND SourceEntry=50289 AND SourceId=0 AND ElseGroup=0 AND ConditionTypeOrReference=12 AND ConditionTarget=0 AND ConditionValue1=63;

[illfated]

Thank you for the update. Looks like a useful starting point to me.

[gygyti]

great solution, can we use it?

[illfated]

@gygyti : Feel free to test it. Report back any issues you may find, like DBErrors or console messages.

[dr-j]

Well still some things need sorting for stv one for kalu’ak working as intended (to my knowledge)