How to set Epic or RB dead for server start

Tables in which data with respawn are located:
raidboss_status - for standard raids such as Queen Ant, Zaken, Orfen, Core and so regular world raids.
epic_boss_spawn - for grand bosses from the series Baium, Antaras, Valakas.

To set respawn in the raidboss_status table, just set them to add and set the time, consider the example of Queen Ant:
INSERT INTO `raidboss_status` (`id`, `current_hp`, `current_mp`, `respawn_delay`) VALUES (29001, 0, 0, 1544566860);
In the respawn_delay field we put the date the necessary date for the spawn in Unix TimeStamp format, for this you can use the resource https://www.cy-pr.com/tools/time/

To set respawn in the epic_boss_spawn table, just place the necessary spawn date in the `respawnDate` field using https://www.cy-pr.com/tools/time/ and set the value in the` state` field to 3.
On the example of Baium, it will visually look like this:

Also, all these manipulations are best done on the off game server.

 

[Caio vinicius]

Alternative Website https://www.epochconverter.com/

 

[scantraxx7777]

Is there a fast way to import all IDs at once?
To set every raid boss dead for the start.

 

[gfman]

Tables in which data with respawn are located:
raidboss_status - for standard raids such as Queen Ant, Zaken, Orfen, Core and so regular world raids.
epic_boss_spawn - for grand bosses from the series Baium, Antaras, Valakas.

To set respawn in the raidboss_status table, just set them to add and set the time, consider the example of Queen Ant:
INSERT INTO `raidboss_status` (`id`, `current_hp`, `current_mp`, `respawn_delay`) VALUES (29001, 0, 0, 1544566860);
In the respawn_delay field we put the date the necessary date for the spawn in Unix TimeStamp format, for this you can use the resource https://www.cy-pr.com/tools/time/

To set respawn in the epic_boss_spawn table, just place the necessary spawn date in the `respawnDate` field using https://www.cy-pr.com/tools/time/ and set the value in the` state` field to 3.
On the example of Baium, it will visually look like this:

Also, all these manipulations are best done on the off game server.

Hello how do I so that they can not cure the raid with heal?

 

[Trance]

Hello how do I so that they can not cure the raid with heal?

 

[Trance]

Is there a fast way to import all IDs at once?
To set every raid boss dead for the start.

Set all Alive:

UPDATE epic_boss_spawn SET respawnDate=0,state=0;
UPDATE raidboss_status SET current_hp = 0, current_mp = 0, respawn_delay = 0;

Dead:

Raid/Epics:

INSERT INTO `epic_boss_spawn` (`bossId`, `respawnDate`, `state`, `boss_name`)
VALUES
  (29020, UNIX_TIMESTAMP('2025-01-01 21:00:00'), 3, 'Baium'), -- Wednesday at 21:00
  (29068, UNIX_TIMESTAMP('2025-01-03 21:00:00'), 3, 'Antharas'), -- Friday at 21:00
  (29045, UNIX_TIMESTAMP('2025-01-05 17:30:00'), 3, 'Frintezza'), -- Sunday at 17:30
  (29028, UNIX_TIMESTAMP('2025-01-05 20:30:00'), 3, 'Valakas') -- Sunday at 20:30
ON DUPLICATE KEY UPDATE
  `respawnDate` = VALUES(`respawnDate`),
  `state` = VALUES(`state`);

INSERT INTO raidboss_status (id, current_hp, current_mp, respawn_delay)
VALUES
  (29006, 0, 0, UNIX_TIMESTAMP('2025-01-06 19:30:00')), -- Core Monday at 19:30
  (29001, 0, 0, UNIX_TIMESTAMP('2025-01-06 21:00:00')), -- Queen Ant Monday at 21:00
  (29022, 0, 0, UNIX_TIMESTAMP('2025-01-07 21:00:00')), -- Zaken Tuesday at 21:00
  (29014, 0, 0, UNIX_TIMESTAMP('2025-01-01 19:30:00')) -- Orfen Wednesday at 19:30
ON DUPLICATE KEY UPDATE
  current_hp = VALUES(current_hp),
  current_mp = VALUES(current_mp),
  respawn_delay = VALUES(respawn_delay);

SELECT bossId AS id, boss_name AS name, respawnDate AS timestamp,
       FROM_UNIXTIME(respawnDate) AS timestamp_utc
FROM epic_boss_spawn
WHERE bossId IN (29068, 29020, 29028, 29045)

UNION ALL

SELECT id,
       CASE
         WHEN id = 29014 THEN 'Orfen'
         WHEN id = 29001 THEN 'Queen Ant'
         WHEN id = 29006 THEN 'Core'
         WHEN id = 29022 THEN 'Zaken'
         ELSE 'Unknown'
       END AS raid_name,
       respawn_delay AS timestamp,
       FROM_UNIXTIME(respawn_delay) AS timestamp_utc
FROM raidboss_status
WHERE id IN (29014, 29001, 29006, 29022)

ORDER BY ABS(timestamp - UNIX_TIMESTAMP(CURRENT_TIMESTAMP)) ASC;