TheGhostGroup / trinitydb

Early Trinitycore Databases Backup from code.google.com/p/trinitydb
0 stars 1 forks source link

brewfest missing spawn NPC info in DB #62

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
I discovered that ingame, you can see some beerfest ONLY NPCs all during the 
year where they are supposed to be spawned ONLY during beerfest.

This is a bug related to: 
http://code.google.com/p/trinitycore/issues/detail?id=3345&can=1&q=reporter%3Ast
ormbyte&colspec=ID%20Type%20Status%20Stars%20Priority%20Summary%20Reporter%20Att
achments%20Com where more details can be shown.

I researched a bit (in wowhead), and tried:
INSERT INTO game_event_creature (guid,event) VALUES 
(20102,26),(18927,26),(19148,26),(19171,26),(19172,26),(19173,26),(27215,26);
INSERT INTO game_event_creature_quest (id,quest,event) VALUES (19148,11441,26);

Restarted the server but the problem persist.
Some NPCs are still spawned WITHOUT having brewfest active (not in that date!), 
for example, outside ironforge, where brewfest normally is, you have one NPC 
giving you quests (and there are others, see the INSERT statement).

Why despite it is set in DB that those only need to be spawned during brewfest 
are still be spawned anyway??

Original issue reported on code.google.com by StormB...@gmail.com on 17 Sep 2010 at 2:27

GoogleCodeExporter commented 9 years ago
And there are NPCs with quests for other seasonal events and brewfest also. How 
can one achieve to see these gossip options when they're supposed to be seen?

Original comment by magikuso...@gmail.com on 1 Nov 2010 at 2:15