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.