Aclaro que todo esto está orientado para Cataclysm... ya que hay muchos problemas con los eventos; en WotLK prácticamente no hay problemas de vinculación de npcs/gobs.
Vincularemos un npc u objeto a un evento. El npc debeya estar spawneado, pero al vincularlo a un evento, solo aparecerá cuando el evento este activo.
Para creatures usamos la tabla: game_event_creature
Para gameobjects usamos la tabla: game_event_gameobject
Columnas de la tabla
Ambas tablas (game_event_creature y game_event_gameobject), tienen la misma estructura.
eventEntry
guid
eventEntry - Acá va el ID del evento. Abajo la tabla de los mismos. guid - El guid del npc u objeto. En positivo es para que spawnee solo cuando está activo el evento, en negativo para que despawnee al estar activo el evento.
Si no sabes que es el GUID leé acá . Si no sabés como conseguirlo, leé acá
Lista de IDs de eventos
Código:
Evententry,description
Evententry,description
1,Midsummer Fire Festival
2,Winter Veil
3,Darkmoon Faire (Terokkar Forest)
4,Darkmoon Faire (Elwynn Forest)
5,Darkmoon Faire (Mulgore)
6,New Year's Eve
7,Lunar Festival
8,Love is in the Air
9,Noblegarden
10,Children's Week
11,Harvest Festival
12,Hallow's End
13,Elemental Invasions
14,Stranglethorn Fishing Extravaganza Announce
15,Stranglethorn Fishing Extravaganza Fishing Pools
16,Gurubashi Arena Booty Run
17,Scourge Invasion
18,Call to Arms: Alterac Valley!
19,Call to Arms: Warsong Gulch!
20,Call to Arms: Arathi Basin!
21,Call to Arms: Eye of the Storm!
22,AQ War Effort
23,Darkmoon Faire Building (Elwynn Forest)
24,Brewfest
25,Nights
26,Pilgrim's Bounty
27,Edge of Madness, Gri'lek
28,Edge of Madness, Hazza'rah
29,Edge of Madness, Renataki
30,Call to Arms: Strand of the Ancients!
31,Arena Tournament
32,L70ETC Concert
33,Shattered Sun Offensive: Phase 1 - Reclaiming the Sanctum
34,Shattered Sun Offensive: Phase 1 - Reclaiming the Sanctum COMPLETE
35,Shattered Sun Offensive: Phase 2 - Sun's Reach Armory
36,Shattered Sun Offensive: Phase 2 - Sun's Reach Armory COMPLETE
37,Shattered Sun Offensive: Phase 2b - Activating the Sunwell Portal
38,Shattered Sun Offensive: Phase 2b - Activating the Sunwell Portal COMPLETE
39,Shattered Sun Offensive: Phase 3 - Sun's Reach Harbor
40,Shattered Sun Offensive: Phase 3 - Sun's Reach Harbor COMPLETE
41,Shattered Sun Offensive: Phase 3b - Rebuilding the Anvil and Forge
42,Call to Arms: Isle of Conquest!
43,Shattered Sun Offensive: Phase 4A - Creating the Alchemy Lab
44,Shattered Sun Offensive: Phase 4A - Creating the Alchemy Lab COMPLETE
45,Shattered Sun Offensive: Phase 4B - Building the Monument to the Fallen
46,Shattered Sun Offensive: Phase 4B - Building the Monument to the Fallen COMPLETE
47,Shattered Sun Offensive: Phase 4 - COMPLETE
49,Wintergrasp Horde Defence
50,Pirates' Day
51,Day of the Dead
52,Winter Veil: Gifts
53,Call to Arms: Strand of the Ancients!
54,Call to Arms: Isle of Conquest!
55,Arena Season 3
56,Arena Season 4
57,Arena Season 5
58,Arena Season 6
59,Arena Season 7
60,Arena Season 8
61,Zalazane's Fall
62,Stranglethorn Fishing Extravaganza Turn-ins
63,Kalu'ak Fishing Derby Turn-ins
64,Kalu'ak Fishing Derby Fishing Pools
65,Perry Gatner
67,AT Event Trigger (Tirion Speech)
68,AT Event Trigger (Horde Event)
69,AT Event Trigger (Alliance Event)
75,Call to Arms: Twin Peaks!
78,Call to Arms: The Battle for Gilneas
80,Brew of the Month October
81,Brew of the Month November
82,Brew of the Month December
83,Brew of the Month January
84,Brew of the Month February
85,Brew of the Month March
86,Brew of the Month April
87,Brew of the Month May
88,Brew of the Month June
89,Brew of the Month July
90,Brew of the Month August
91,Brew of the Month September
Relacionando creature con evento
Si vamos a donde están spawneado este npc Entry 24108 - S.T.O.U.T. (Self-Turning and Oscillating Utility Target), veremos que siempre están visibles, esté el evento activo o no.
Así que vamos a asociar los dos spawns del npc, al evento de la cerveza 24,"Brewfest":
Código:
DELETE FROM `game_event_creature` WHERE eventEntry=24 AND `guid` IN (321932,321953); -- Entry 24108 - S.T.O.U.T. (Self-Turning and Oscillating Utility Target)
INSERT INTO `game_event_creature` (`eventEntry`,`guid`) VALUES
(24,321932),(24,321953);
Eso es todo. Con eso agregamos la info de que tales npcs en particular (guid), pertenecen a tal evento (brewfest). Ya no estarán visibles siempre; ahora cuando el evento de la cerveza comience, los npcs aparecerán.
