L2J Server

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

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

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

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

kocinski wrote: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

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

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

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

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

Cheers

post here the exact error message...

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.

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

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

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

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!