Birthday

Sara75 · July 2nd, 2009, 10:59 AM

Hi!
How can I set birthday date in Italian style (dd-mm-yyyy)?

Thanks

Sara

Chuck S · July 2nd, 2009, 05:15 PM

Have you tried setting the date format in global options in admin to that?

Sara75 · July 3rd, 2009, 04:57 AM

Yes, and date for ads are ok, but not birthday date !

Chuck S · July 3rd, 2009, 07:43 AM

ah okay we are working with a whole different thing here

You would actually have to alter the code in register.php and member.php where the birthday is stored and switch around where it is stored.

Code:

Content visible to verified customers only.

see that line in register.php thats the order they store it. so you would alter the order there and in member.php before it is updated you would alter the order of this line accordingly.

Code:

Content visible to verified customers only.

Sara75 · July 3rd, 2009, 08:10 AM

Made these changes, but if I modify my profile, birthday date is asked still mm/dd/yyyy and not dd/mm/yyyy and if I enter my birthday it's not stored in db. (db field is 0000-00-00)

Chuck S · July 3rd, 2009, 08:44 AM

You can modify the template or other code in how its displayed to the user thats fine I was merely explaining how to alter it being stored.

Sara75 · July 3rd, 2009, 08:59 AM

It doesn't work !
I also modified adm_users.php as you suggested, but date stored in db is always 0000-00-00
Can you please tell me where is the update query?
Thanks

Chuck S · July 3rd, 2009, 09:03 AM

the update command is in each script and it would work as long as the lines In noted are changed. For example look at edit line I posted in member.php you simply need to change the variables around that work for you. I showed the lines to show you how we store it.

Sara75 · July 3rd, 2009, 11:59 AM

Quote:

Originally Posted by Chuck S

the update command is in each script and it would work as long as the lines In noted are changed. For example look at edit line I posted in member.php you simply need to change the variables around that work for you. I showed the lines to show you how we store it.

Sorry Chuck, but these informations are wrongs.
Changes you suggested doesn't work simply because you stored birthday date in db in a field "birthday" type DATE, that means that it only accept date in 0000-00-00 (yyyy-mm-dd) format - mysql standard.
So to have birthday date shown in format dd-mm-yyyy I had to work really more than what you suggested.
Sara

Chuck S · July 3rd, 2009, 03:15 PM

Yeah you will probally need to recode the whole thing how it works. Thats really a mysql limitation and since we store it in the mysql date field there is not much I can do to change that.

The birthday is only displayed one place in the profile when viewing the profile. Maybe altering member.php to add this in bold.

Code:

Content visible to verified customers only.

You can then edit the profile template and change $birthday to $birth2

Aside from that you can ask further code modification questions in THE MOD CORNER outside product support.