classicdb / database

Classic DB is a content database for CMaNGOS Classic: world, NPCs, objects, quests and so on.
https://github.com/cmangos/mangos-classic
Other
87 stars 56 forks source link

STV Event - Fishing Extravaganza #747

Open ghost opened 9 years ago

ghost commented 9 years ago

To simply put, it doesn't work.

Bugs: As well it doesn't start/end correctly (Every sunday from 2pm - 4pm server time) or makes any announcements. Master Angler quest should be temporarily removed from Riggle Bassbait on first turn in (One turn in per event). Riggle Bassbait is missing his fishing rod. Riggle Bassbait missing his crate that he stands on. Riggle Bassbait, Jang, and Fishbot 5000 doesn't spawn in the correct location (near the anchor by the fishing trainer Myizz Luckycatch). As well as quests don't offer money reward, some of the quests doesn't have a fishing profession/level requirement and/or level 60 requirement.

-[Event IDs]- Fishing Extravaganza Announce (14) Fishing Extravaganza (15) Fishing Extravaganza Turn-In (34)

-[Quests]- Master Angler (8193) - Riggle Bassbait Apprentice Angler (8194) - Jang Rare Fish - Keefer's Angelfish (8221) - Fishbot 5000 Rare Fish - Dezian Queenfish (8224) - Fishbot 5000 Rare Fish - Brownell's Blue Striped Racer (8225) - Fishbot 5000

-[NPCs]- Riggle Bassbait (15077) Jang (15078) Fishbot 5000 (15079)

-[Gameobject]- Unknown crate (?)

-[Source(s)]- https://www.youtube.com/watch?v=4j-pnWLLw-M http://web.archive.org/web/20060510063616/http://wow.allakhazam.com/db/quest.html?wquest=8193 http://web.archive.org/web/20071102130655/http://wow.allakhazam.com/db/quest.html?wquest=8194 http://web.archive.org/web/20070527005034/http://wow.allakhazam.com/db/quest.html?wquest=8221 http://web.archive.org/web/20060521040146/http://wow.allakhazam.com/db/quest.html?wquest=8224 http://web.archive.org/web/20060302055704/http://wow.allakhazam.com/db/quest.html?wquest=8225

ghost commented 9 years ago

Here is a fix to one of the many bugs. It's to have the quests properly be given at the correct Level and Fishing Skill, as well as give the proper money reward.

UPDATE quest_template SET MinLevel = '60', RequiredSkill = '356', RequiredSkillValue = '1', RewOrReqMoney = '18000', RewMoneyMaxLevel = '0' WHERE entry = '8193'; UPDATE quest_template SET MinLevel = '60', RequiredSkill = '356', RequiredSkillValue = '1', RewOrReqMoney = '2300', RewMoneyMaxLevel = '0' WHERE entry IN ('8194', '8221', '8224', '8225');

cala commented 9 years ago

Thank you for the report and the first part of a fix. :+1: I'll review it soon.

Tobschinski commented 9 years ago

Why did you set the minimum level to 60?

cala commented 9 years ago

I would have thought that wow.allakhazam stated lvl 60 for the quest, but it might be "player's level" instead, which DB sites like this one and wowhead change to 1 or "max player level".

However, linked comments and http://www.wowwiki.com/Quest:Master_Angler lead to think that quest level (and min quest level) is indeed 60. Same for the Apprentice Angler quest. Strange. The rare fish quests however should be available before level 60, both comments and wowwiki confirm this (the later giving level 17 as a minimum).

Phatcat commented 8 years ago

https://web.archive.org/web/20070218223002/http://wow.allakhazam.com/db/quest.html?wquest=8193

No idea on the level req, but I won this the first week on a new BC server at level 30. Did it in just under 30 minutes, had to avoid mobs a lot and use +75 lures on my wimpy +5 pole, but with only 225 skill at the start I never saw any "got away" messages. So if theres no "quest" level requirement, it could be done at whatever level you can train journeyman (75-150) fishing at. Which is 10 I think? You'd need a team to keep mobs away of course.

this quest does not require a level at all as far as I can make out.

And the quest is repeatable:

It is. The ? is blue meaning you can do it as many times as you want... but it's kind of pointless after the second time.

And not one you actually pick up:

You don't pick up the quest, it's just a turn-in like the Scourgestones for Argent Dawn. When the server clock hits 2pm, the guy in Booty Bay where you turn this in (over near the engineer portal guy) announces that the fishing extravaganza has begun. Between then and 4pm, there are little swirly fish-catching spots where you can catch the tastyfish and rare fish. First person to catch 40 and turn them in finishes the quest. Everyone else turns in their tastyfish to the female assistant next to him and any rare fish to the robot assistant.

Phatcat commented 8 years ago

I don't know if you guys remember, but a lot of event quests were given level 60 so they wouldn't appear gray to high levels (which would also make the yellow exclamation mark above questgivers heads disappear), even though they have no level requirement (lots of holiday quests come to mind)

Tobschinski commented 8 years ago

But there is no need to do that for these type of quest, because you will never have them in your log. You just turn in the items directly, afair.

There are a few others in STV:

name required level
Filling the Soul Gem 1 46
Enticing Negolash 1 52
Arena Master 1 55
Arena Grandmaster 1 55
Stranglethorn Fever 32 35

I'll try to get some more info about the fishing event on sunday ...