Antharas Spawn

[TheChuck]

If you want to receive support we need this info to help you properly.
» Find Revision
L2J Revision Number:
L2JDP Revision Number:

Hi, again...

Somehow the antharas spawn change with a little trouble: It will appear again in December 31th 1970


Anybody know what could happen or how can i fix it?

Thanks a lot, again

[denser]

check your server time. may be your cmos are broken.

[TheChuck]

But this problem is only with Antharas :S If the clock is wrong, all rb's should be wrong too or not?

[kocinski]

SEARCHING: viewtopic.php?f=81&t=17063

Fix it in DB:

Code: Select all

UPDATE `grandboss_data` SET `respawn_time`=1284735600000' WHERE (`boss_id`='29019'); 

http://www.onlineconversion.com/unix_time.htm

1284735600000 / 1000 = Fri, 17 Sep 2010 15:00:00 GMT

[TheChuck]

Thanks, I set the new spawn, let see how it goes.

[TheChuck]

Fail, it didn't work. Still 1970 of spawn

[MELERIX]

then shutdown server, delete grandboss_data table, and import again, then start server... and should be fine.

if not... is because your machine don't have the right date/month/year/timezone

[TheChuck]

After had deleted grandboss data, at the time to import a message appears. Something about a primary key. What's that?

Cheers

[jurchiks]

post here the exact error message...

[TheChuck]

[Naonah]

well, remember that Antharas is instanced and dont spawn it manually (//spawn Antharas), otherwise you will have an error like this.

If you want to spawn Antharas make it custom NPC.

[celestialcommunity]

Why duplicate row 29001? Delete duplicate.

The error say that the table not have primary key. Secondary click in the table grandboss_data, Design Table, secondary click field boss_id and click "Primary Key".

Modify row of Antharas NPC '29001'
SET = 0 respawn_time and status for reset instance grandboss Antharas.

PD: Shutdown server for modifications in database

[TheChuck]

The first line appears when i did the backup of the file. I don't know what happen and i can't delete it.

[hope]

Close server delete table then install a new one from your SQL files

[TheChuck]

I need the name of every row. Boss_id, x, y, z, respown time


Anybody can help me or post a image with the names?


Thanks!