Birthday event ?

[babyjason]

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

i saw there is a birthday event, also a /mybirthday command that shows players birthday

could you tell me how to set a players birthday, and how to use the event? couldnt find info :/

[Gnacik]

Birthday date is stored in `characters` table (createTime field) Its day when player create character. must play whole year on server to get reward

[Notorious]

Maybe someone could put together some little program that reads the login-log, and sets the database with date from first login to server so that old accounts get a more suitable birthday than 1/1 1970!

[Tan]

Birthday date is stored in `characters` table (createTime field) Its day when player create character. must play whole year on server to get reward

and the reward is?

[Gnacik]

Adventurer Hat and 24h vitality buff

[JIV]

i think reward will be changed on next birthday

[babyjason]

ty for the info,

in the character field, the date is in unix format again? and if it is, does anybody has a link to convert normal date to unix ?

[jurchiks]

http://www.unixtimestamp.com/index.php

[Crom]

This date could be changed on create account form or any one?

[janiii]

l2j uses timestamp in milliseconds, so be aware to add the three 000 at the end. unix time is in seconds, l2j time is in milliseconds.

[babyjason]

l2j uses timestamp in milliseconds, so be aware to add the three 000 at the end. unix time is in seconds, l2j time is in milliseconds.

great, also i ve found the html s in event folder, much clearer now , sry for not looking before

[kilkenny]

l2j uses timestamp in milliseconds, so be aware to add the three 000 at the end. unix time is in seconds, l2j time is in milliseconds.

Thanks for the tip, i tried adding old birthdates and still ended up in 1970...but then this is probably the cause

[kilkenny]

After trying to figure out who created his character when I was left with a couple of characters that I could not find. To give them a createdate i used the following sql query, might be interesting for some people:

Code: Select all

UPDATE characters SET createTime = lastAccess - onlinetime * 10000 WHERE createTime = '0';

The value 10000 is just a guess, you can put whatever you want here, but I tested it on my server for a few chars and got the best result with this value (not very active players i guess :p)

[momo61]

After trying to figure out who created his character when I was left with a couple of characters that I could not find. To give them a createdate i used the following sql query, might be interesting for some people:

Code: Select all

UPDATE characters SET createTime = lastAccess - onlinetime * 10000 WHERE createTime = '0';

The value 10000 is just a guess, you can put whatever you want here, but I tested it on my server for a few chars and got the best result with this value (not very active players i guess :p)

very interesting. thank you.