Mod Name / Version - Profile Birthdays 1.5 <br />    ver 1.1 fixes a bug where the "Happy Birthday" message repeated with each category. <br />            Lists the usernames in alphabetical order for a neater look. <br />    ver 1.2 update to work with UBB.Threads 6.2, adds the year and age calculation as an option <br />    ver 1.3 updates the age calculation function and fixes a bug. <br />    ver 1.4 fixes a bug where the date of the birthday wasn't displaying <br />    ver 1.5 fixes the age calculation bug. Thanks to Dimopoulos and JustDave for help in nailing that down. <img src="/forum/images/graemlins/wink.gif" alt="" /> <br /> <br />Description - This modification will allow users to enter their birthdays into their profile and display birthday info. <br /> <br />Working Under - UBB.Threads 6.2 <br /> <br />Features - <br />

• Birthday will Display in their Profile.
• Age will appear in their Profile if they have entered the year of their Birth. (Thanks Dimopoulos)
• Bottom of Main Index Will Display "Today's Birthdays" and "This
• Months Birthdays" if there are any.
• Birthday Names will link to the users profiles.
• Top of Main Index will wish the User a Happy Birthday if It's their
• Birthday.
• Bottom of Main Index will offer a link to update their profile if the profile does not contain the Birthday Info
• If they have completed their whole birthday, an accurate age will be calculated.
• If they have only filled in their birthyear, an aprox. age will be calculated. <br />

<br /> <br />Pre-requisites - none <br /> <br />Author - JoshPet - www.joshuapettit.com <br /> <br />Credits - PamW of www.thesoulelement.com for requesting it. Thanks to Dimopoulos for adding the year to the code. Thanks to Dave_L for help with the age calculation. <br /> <br />Files Altered - editbasic.tmpl, editbasic.php, changebasic.php, ubbthreads.php, ubbthreads.tmpl, showprofile.php, showprofile.tmpl <br /> <br />Database Altered - Three Fields added to the w3t_Users table (U_BirthMonth, U_BirthDay, U_BirthYear). <br /> <br />New Files - none <br /> <br />Other Info - Backup your database and your files before modifing!!!!! <br /> <br />Add On Available - A birthday Cron addon is available here. It automatically can send PMs or Make Posts for people's birthdays. <img src="/forum/images/graemlins/smile.gif" alt="" /> <br />

I'm using the 1.1 mod on threads 6.1.1 and love it. Although it seems that as more of my members add their info (probably a couple thousand of my 18,000 members) the page loads slower. I think there was talk about cache this info ( I would be happy with a once a day look up ).<br /><br />Q. - Is the additonal lookup time insignificant and I should forget it?<br /> <br />Q. - Should drop it from my Main Index page which is re-loaded many times and just leave the info in a PAL box on IIP?<br /><br />Thanks... just looking to keep things running smoothly.

It would have to check and load the info each time the Main Index is loaded. That can slow things down I imagine. <br /><br />I am working on an Updated Pal Box for the next version of IIP which will Cache the info. (Thanks to JustDave!) <img src="/forum/images/graemlins/smile.gif" alt="" /> Next step will be figuring out if we can have the bottom of the index page pull the cached info from IIP. That would be best for sure. <img src="/forum/images/graemlins/smile.gif" alt="" /> Let IIP update it however often it does when it loads, and just have the Main Index use the info.

I've got this all worked out and up and running. <img src="/forum/images/graemlins/laugh.gif" alt="" /> Thanks to some great IIP groundwork by JustDave, it was easy. <img src="/forum/images/graemlins/smile.gif" alt="" /><br /><br />I've got the BirthdayPal box for IIP 5.2 ready to go. It will cache the birthdays however many minutes you want. <img src="/forum/images/graemlins/smile.gif" alt="" /> You can define it in the IIP config file. <br /><br />Then, I tweaked the mod for the main index. The only thing the main index will check for, is if it's that users Birthday (so they get a birthday greeting) or if their birthday is empty (so they get the link to fill in their profile). <br />All the big list of names (today's bdays and this months bdays) is pulled from the IIP cache. I figure it's sufficient for the IIP to update that info however often. So the Main Index won't do any pulling of that info.<br /><br />So I guess you'll have to load IIP at least once so that there's info to read. But if your site is busy, IIP will get loaded at least once a day easily. <br /><br />That should cut down on the load, caching the bulk of the info. <img src="/forum/images/graemlins/smile.gif" alt="" />

Adding all my hacks to 6.2 test board........... hehe <img src="/forum/images/graemlins/smile.gif" alt="" /> Or ummmmm all of your hacks I guess I should say?? *LMAO* Good Work!! Thanks!

<img src="/forum/images/graemlins/grin.gif" alt="" /><br /><br />THANKS!<br />

I modified my directions in the attachment above.<br /><br />NOTE: If you are upgrading from the old birthday Mod, you'll already have U_BirthMonth and U_BirthDay, but you'll need to <br />add U_BirthYear, as that was added in this version.<br /><br />To add U_BirthYear run this:<br /><br />ALTER TABLE w3t_Users ADD U_BirthYear INT (4) NULL<br /><br />Otherwise, as Storm discovered, you'll get errors on the show profile page.<br /><br /><img src="/forum/images/graemlins/smile.gif" alt="" /><br />

Josh, <br /><br />You referenced a new palbox that would cache the birthdays... was that released?

No didn't have a chance yet. Here's the PalBox for IIP 5.2. It's named custombox1pal.php <br /> <br />Put it in your pals directory and adjust it's location using the IIP admin editor. It's called Custom Box 1. <br /> <br />Adjust the Cache time for Custom Box 1 in the IIP Admin Interface. <img src="/forum/images/graemlins/smile.gif" alt="" /> <br /> <br />Enjoy! <br /> <br /> <br />Updated with new tablewrapers to work with IIP 5.3 <br /> <br />Updated with a tablewrapper tweak.

Thanks Again! <br /><br />It Works.

Works great on my site Josh! Thanks once again!! <img src="/forum/images/graemlins/laugh.gif" alt="" /><br /><br />[]http://www.threadsdev.com/images/panels/9936-14259.png[/] <~~~Me wants this hack <img src="/forum/images/graemlins/laugh.gif" alt="" />

If you are using the Pal Box.... and Caching the results.... you can pull that Cached info to the Main Index.... rather than pulling it each time the Main index Loads.<br /><br />You must be using the Pal Box, and Caching the results.<br /><br />I've attached instructions to this post. <img src="/forum/images/graemlins/wink.gif" alt="" /><br /><br />

works like a charm <img src="/forum/images/graemlins/grin.gif" alt="" />

Thanks Josh,<br /><br />In editbasic.php you say find...<br /><br /> if (!$debug) {<br /> include("$thispath/templates/$tempstyle/editbasic.tmpl");<br /> }<br /><br />but that code does not exist <img src="/forum/images/graemlins/frown.gif" alt="" /><br /><br />Thanks.

Hi Josh,<br />jsut a quick not on the previous version (1.1). There is maybe a bug with the calendar entries. It might not be fixed with the 1.2 version :<br />If a user changes the date, say the month from april to may, a new may entry is added to the calendar. and the april entry stays. Looks like a bug to me.<br /><br />Greetings and a happy new year to you all!<br />

Josh,<br />another thing the users pointed me at:<br />How do I DELETE birthday information (calender and profile)?<br /><br />Greetings

Hi Carl,<br /><br />What you are seeing is quite weird. In my 6.1.1 board I went and changed my birthday from April to January. Immediately in my calendar board the entry from April disappeared and appeared in January.<br /><br />What the calendar modification on the profile birtdays does is it queries the users table for birthdays on a particular month and while the script runs to display the data in the calendar it also displays the birthday. The w3t_events table is never used for birthdays.<br /><br />Very weird that your users see the events.... Did you or your users manually entered events on the calendar board? To check this, see the color of the three little arrows in front of the person's name on the particular date. If they are blue, it was generated by this modification if Red then it was manually entered in the w3t_events table as a new event.<br /><br />Any chance of having a sample to have a look at the behavior?<br /><br />Warm regards<br /><br />Nikos

I found a bug I found a bug!<br /><br />I tested it with my own birthday, and it lists me as a year older than I really am. Unless I forgot how old I was already? lol<br /><br />My birthday is march 5th, 1980. I entered that into my profile. But it is showing me as 23, when infact I won't be 23 until March 5th of this year. <img src="/forum/images/graemlins/confused.gif" alt="" />

I have an update that I'll post this evening. I noticed that and with Dave_L's help, I got this worked out. <img src="/forum/images/graemlins/smile.gif" alt="" />

[]My birthday is march 5th, 1980. [/] <br />Baby <img src="/forum/images/graemlins/tongue.gif" alt="" /> <br /> <br /><img src="/forum/images/graemlins/laugh.gif" alt="" /> <img src="/forum/images/graemlins/laugh.gif" alt="" /> <img src="/forum/images/graemlins/laugh.gif" alt="" /> <img src="/forum/images/graemlins/laugh.gif" alt="" /> <img src="/forum/images/graemlins/laugh.gif" alt="" /> <br /> <br />Nice one Jeremy, thanks for spotting that. I was wondering why one of my users insisted he was 52.... <img src="/forum/images/graemlins/smile.gif" alt="" /> <br /> <br />Warm regards <br /> <br />Nikos