Page 1 of 1

Birthday event ?

Posted: Sun Jan 10, 2010 8:07 pm
by 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 :/

Re: Birthday event ?

Posted: Sun Jan 10, 2010 8:23 pm
by 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 ;)

Re: Birthday event ?

Posted: Sun Jan 10, 2010 8:52 pm
by 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! :)

Re: Birthday event ?

Posted: Sun Jan 10, 2010 9:15 pm
by Tan
Gnacik wrote: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?

Re: Birthday event ?

Posted: Sun Jan 10, 2010 9:20 pm
by Gnacik
Adventurer Hat and 24h vitality buff

Re: Birthday event ?

Posted: Sun Jan 10, 2010 10:47 pm
by JIV
i think reward will be changed on next birthday

Re: Birthday event ?

Posted: Mon Jan 11, 2010 12:46 pm
by 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 ?

Re: Birthday event ?

Posted: Mon Jan 11, 2010 9:49 pm
by jurchiks

Re: Birthday event ?

Posted: Tue Jan 12, 2010 12:08 am
by Crom
This date could be changed on create account form or any one?

Re: Birthday event ?

Posted: Tue Jan 12, 2010 7:43 am
by 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.

Re: Birthday event ?

Posted: Tue Jan 12, 2010 9:59 am
by babyjason
janiii wrote: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 :)

Re: Birthday event ?

Posted: Thu Jan 14, 2010 6:50 am
by kilkenny
janiii wrote: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 :)

Re: Birthday event ?

Posted: Fri Jan 15, 2010 10:27 am
by 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)

Re: Birthday event ?

Posted: Tue Feb 23, 2010 6:04 am
by momo61
kilkenny wrote: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.