phpBB2 Conversion Observation - Birthdays
Posted: Tue Mar 03, 2009 1:32 pm
Just something that has emerged from the migration project that I'm currently undertaking. The Birthdays database seems to have imported all the days into the month table, and the months in the days table, or something to this effect.
For someone whose birthday is on 5th December, then the phpBB3 profile will show 12th May. As the months onlty go up to 12, it also means that anyone with a birthday between 12th and 31st of a month will not have a month for their birthday entered at all.
Maybe some SQL tweaking could be arranged to get around this? Better still if some SQL routine to get users days and months and to transpose them so that they are the right way around, could be written.
For someone whose birthday is on 5th December, then the phpBB3 profile will show 12th May. As the months onlty go up to 12, it also means that anyone with a birthday between 12th and 31st of a month will not have a month for their birthday entered at all.
Maybe some SQL tweaking could be arranged to get around this? Better still if some SQL routine to get users days and months and to transpose them so that they are the right way around, could be written.