How to change a guard equipment on day/night

[alexluana]

how is it possible to make a guard change equipment on day one id and on night a different id?

[YuruY]

http://wiki.ytdb.ru/index.php/Game_event_creature_data

[alexluana]

ok ty... I did that and here is the script

INSERT INTO game_event VALUES
(67, '2013-01-14 18:00:00', '2020-12-31 07:00:00', 1440, 780, 0, 'Orgrimmar Grunts - Night Equipment');

INSERT INTO game_event_creature VALUES
(3382, 67),
(3383, 67),
(3384, 67),
(3385, 67),
(3386, 67),
(3387, 67),
(3388, 67),
(3389, 67),
(3390, 67),
(3391, 67),
(3462, 67),
(3465, 67),
(6558, 67),
(6559, 67),
(6560, 67),
(6561, 67),
(6562, 67),
(6563, 67),
(6564, 67),
(6565, 67),
(6566, 67),
(6567, 67),
(7397, 67),
(7398, 67),
(7399, 67),
(7415, 67),
(7416, 67),
(7417, 67),
(7418, 67),
(7419, 67),
(7420, 67),
(7421, 67),
(7941, 67),
(7942, 67),
(7943, 67),
(7945, 67),
(7946, 67),
(7948, 67),
(7949, 67),
(7950, 67),
(8521, 67),
(8522, 67),
(8523, 67),
(8524, 67),
(8525, 67),
(8526, 67),
(8527, 67),
(8528, 67),
(8529, 67),
(8530, 67),
(10297, 67),
(10298, 67),
(10299, 67),
(10347, 67),
(10348, 67),
(10350, 67),
(10351, 67),
(10352, 67),
(10353, 67),
(10450, 67),
(10462, 67),
(10463, 67),
(10464, 67),
(10465, 67),
(10466, 67),
(10467, 67),
(10468, 67),
(10469, 67),
(10470, 67),
(11789, 67),
(11790, 67),
(11791, 67),
(11792, 67),
(11793, 67),
(11794, 67),
(11795, 67),
(11796, 67),
(200000, 67),
(200001, 67),
(200002, 67),
(200003, 67),
(200004, 67);

INSERT INTO game_event_creature_data VALUES
(3382, 0, 0, 4161, 0, 0, 67),
(3383, 0, 0, 4161, 0, 0, 67),
(3384, 0, 0, 4161, 0, 0, 67),
(3385, 0, 0, 4161, 0, 0, 67),
(3386, 0, 0, 4161, 0, 0, 67),
(3387, 0, 0, 4161, 0, 0, 67),
(3388, 0, 0, 4161, 0, 0, 67),
(3389, 0, 0, 4161, 0, 0, 67),
(3390, 0, 0, 4161, 0, 0, 67),
(3391, 0, 0, 4161, 0, 0, 67),
(3462, 0, 0, 4161, 0, 0, 67),
(3465, 0, 0, 4161, 0, 0, 67),
(6558, 0, 0, 4161, 0, 0, 67),
(6559, 0, 0, 4161, 0, 0, 67),
(6560, 0, 0, 4161, 0, 0, 67),
(6561, 0, 0, 4161, 0, 0, 67),
(6562, 0, 0, 4161, 0, 0, 67),
(6563, 0, 0, 4161, 0, 0, 67),
(6564, 0, 0, 4161, 0, 0, 67),
(6565, 0, 0, 4161, 0, 0, 67),
(6566, 0, 0, 4161, 0, 0, 67),
(6567, 0, 0, 4161, 0, 0, 67),
(7397, 0, 0, 4161, 0, 0, 67),
(7398, 0, 0, 4161, 0, 0, 67),
(7399, 0, 0, 4161, 0, 0, 67),
(7415, 0, 0, 4161, 0, 0, 67),
(7416, 0, 0, 4161, 0, 0, 67),
(7417, 0, 0, 4161, 0, 0, 67),
(7418, 0, 0, 4161, 0, 0, 67),
(7419, 0, 0, 4161, 0, 0, 67),
(7420, 0, 0, 4161, 0, 0, 67),
(7421, 0, 0, 4161, 0, 0, 67),
(7941, 0, 0, 4161, 0, 0, 67),
(7942, 0, 0, 4161, 0, 0, 67),
(7943, 0, 0, 4161, 0, 0, 67),
(7945, 0, 0, 4161, 0, 0, 67),
(7946, 0, 0, 4161, 0, 0, 67),
(7948, 0, 0, 4161, 0, 0, 67),
(7949, 0, 0, 4161, 0, 0, 67),
(7950, 0, 0, 4161, 0, 0, 67),
(8521, 0, 0, 4161, 0, 0, 67),
(8522, 0, 0, 4161, 0, 0, 67),
(8523, 0, 0, 4161, 0, 0, 67),
(8524, 0, 0, 4161, 0, 0, 67),
(8525, 0, 0, 4161, 0, 0, 67),
(8526, 0, 0, 4161, 0, 0, 67),
(8527, 0, 0, 4161, 0, 0, 67),
(8528, 0, 0, 4161, 0, 0, 67),
(8529, 0, 0, 4161, 0, 0, 67),
(8530, 0, 0, 4161, 0, 0, 67),
(10297, 0, 0, 4161, 0, 0, 67),
(10298, 0, 0, 4161, 0, 0, 67),
(10299, 0, 0, 4161, 0, 0, 67),
(10347, 0, 0, 4161, 0, 0, 67),
(10348, 0, 0, 4161, 0, 0, 67),
(10350, 0, 0, 4161, 0, 0, 67),
(10351, 0, 0, 4161, 0, 0, 67),
(10352, 0, 0, 4161, 0, 0, 67),
(10353, 0, 0, 4161, 0, 0, 67),
(10450, 0, 0, 4161, 0, 0, 67),
(10462, 0, 0, 4161, 0, 0, 67),
(10463, 0, 0, 4161, 0, 0, 67),
(10464, 0, 0, 4161, 0, 0, 67),
(10465, 0, 0, 4161, 0, 0, 67),
(10466, 0, 0, 4161, 0, 0, 67),
(10467, 0, 0, 4161, 0, 0, 67),
(10468, 0, 0, 4161, 0, 0, 67),
(10469, 0, 0, 4161, 0, 0, 67),
(10470, 0, 0, 4161, 0, 0, 67),
(11789, 0, 0, 4161, 0, 0, 67),
(11790, 0, 0, 4161, 0, 0, 67),
(11791, 0, 0, 4161, 0, 0, 67),
(11792, 0, 0, 4161, 0, 0, 67),
(11793, 0, 0, 4161, 0, 0, 67),
(11794, 0, 0, 4161, 0, 0, 67),
(11795, 0, 0, 4161, 0, 0, 67),
(11796, 0, 0, 4161, 0, 0, 67),
(200000, 0, 0, 4161, 0, 0, 67),
(200001, 0, 0, 4161, 0, 0, 67),
(200002, 0, 0, 4161, 0, 0, 67),
(200003, 0, 0, 4161, 0, 0, 67),
(200004, 0, 0, 4161, 0, 0, 67);

but the problem is that all my guards dissapear? They should only during night appear with equipment 4161 and on day with their normal equip..

What did I missed?

[NeatElves]

Они не могут исчезать, если такой гуид есть в мире, но при наступлении эвента у них просто сменится эквип...
Ваше подобие скрипта (как вы его назвали) - злобность...

Это лишнее :

INSERT INTO game_event_creature VALUES

YTDB
1. Event - Nights,id =29
2. Creature, guid=5946(1976) - in normal world(3 - normal equipment_id in creature_template), in event - '5946,0,0,92,0,0,29' >- 5946 - guid npc, 92 - equipment_id, 29 - event_id

Да есть же примеры в базе - смотрите внимательно!!!

[alexluana]

ty all...I found my problem game_event_creature ... I removed all content from there...and all worked fine