[BETA] Birthday Extension for Topic Calendar

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment! No new topics are allowed in this forum.
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: MOD Development Forum rules

On February 1, 2009 this forum will be set to read only as part of retiring of phpBB2.
Registered User
Posts: 198
Joined: Tue May 18, 2004 10:58 am

Re: Date format?

Post by Paddic »

chadcham wrote: Does anyone know what date format this stores into the user_birthday field of the phpbb_users table? For example, my birthday is 10-18-1974 and in the user_birthday field it is stored as 1751. I need to populate this field from a spreadsheet, but I cannot figure out what logic is used to generate the short format used for the date.


Looking at the values, could it be days since 1-1-1970?
Registered User
Posts: 14
Joined: Sat Sep 03, 2005 7:37 pm

Post by chadcham »

Thanks so much Paddic! That is exactly what it is. I had not even though of that, although I have seen it in code in other apps before....

I have one other one since someone else has probably already done something like this. I wanted to include the users first and last name (which I store after installing 'The Defpom's' full name in profile mod) instead of the username in the calendar for their birthday in the topic calendar and in the hover text for the birthday.

I have a pretty good idea on how to do this, but I wanted to check and see if anyone has already tackled this.

Thanks again!
Post Reply

Return to “[2.0.x] MODs in Development”