Jump to content
TrinityCore

Question About game_event_pool table


blackmetalz
 Share

Recommended Posts

Hi,i'm trying to understand this table.



As description of this table: This table determines if a given pool is active for a given game event.



it means it linked with table pool_template?



I have a pool creature that have 1 NPC with 3 respawn, only 1 will available to see,if you kill that repsawn, NPC will respawn in another location. But when i bring it with game_event, when event start it displays all NPC spawned ....



I already insert a record with event ID and pool entry in table pool_template



Hope you understand what i'm saying. Sorry for my bad english!

 

Link to comment
Share on other sites

Thanks for reply,here is my code

-- Random Respawn

DELETE FROM `pool_template` WHERE entry=888002;

INSERT INTO `pool_template`(`entry`,`max_limit`,`description`) VALUES

(888002,1, 'NPC Event Spawn (888002)');



DELETE FROM `pool_creature` WHERE pool_entry=888002;

INSERT INTO `pool_creature`(`guid`,`pool_entry`,`chance`,`description`) VALUES

(400000,888002,0, 'NPC Event Spawn 1'),

(400001,888002,0, 'NPC Event Spawn 2'),

(400002,888002,0, 'NPC Event Spawn 3');


-- Game Event ID: 100

DELETE FROM game_event WHERE eventEntry IN (100);

INSERT INTO game_event VALUES

(100,'2015-03-16 21:46:00','2015-03-16 22:40:00',120,119,0,'Event Killing Mob',0);



-- Game Event Creature

DELETE FROM game_event_creature WHERE guid IN (400000,400001,400002);

INSERT INTO game_event_creature VALUES

(100,400000),

(100,400001),

(100,400002);



-- Game Event Pool

DELETE FROM game_event_pool WHERE eventEntry IN (100);

INSERT INTO game_event_pool VALUES

(100,888002);
 
Link to comment
Share on other sites

  • 2 years later...
 Share

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...