Profile Enhancements - Birthday Thread and PM generator

<a href="http://www.AusPhotography.net.au" target="_blank">www.AusPhotography.net.au</a> Birthday Thread and PM generator

This product provides a simple way to create both an automatic Birthday greeting thread and forum member birthday PM.

Features:

1. Configurable greeting text with name, age (optional), and birthday
2. Excludable usergroups (eg. banned etc)
3. Creates a thread in selectable forum and sends a PM from selected user (admin or other)
4. Runs as a vBulletin scheduled task (vB cron job)
5. Honours forum members birthday profile settings
6. Only sends birthdays for members with recent forum activity (configurable)
7. Adjusts for forum members time-zone so the greeting will be on their birthday

Uses:

1. Creates a Database table to track birthday processed
2. One additional file vBulletin scheduled task (vB cron job)
3. Product installation file

Installation:

1. Copy ap_birthday.php to the forum ./includes/cron directory
2. Install the product file
3. Configure it via AdminCP/Settings/Options
4. Disable the vBulletin birthday emailer in AdminCP / Scheduled tasks
Done!

Enjoy! It will probably work on vB3.6+ as well.

Update 2013-04-12: Working with 4.2.0
Update 1.1.2 if zero active post use 'lastactivity' instead (bugfix)

Kym

[whitey92lx]

I installed the update and then set it up, and got this email.

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT forumid FROM vbwsm_forum
WHERE (forum.options & 4096)
ORDER BY forumid;

MySQL Error : Unknown column 'forum.options' in 'where clause'
Error Number : 1054
Request Date : Saturday, June 25th 2011 @ 12:21:01 PM
Error Date : Saturday, June 25th 2011 @ 12:21:01 PM
Script : http://www.westsidemustangs.com/cron...and=1309022460
Referrer : http://www.westsidemustangs.com/forum.php
IP Address : 99.153.185.197
Username : Unregistered
Classname : vB_Database
MySQL Version :

[AusPhotography]

Brain fart - fixed (again)

[whitey92lx]

I re installed, updated the settings and got this email.


************************************************** ****

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT userid, username, usergroupid, birthday, showbirthday, posts, timezoneoffset,
DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%D of %M') AS BDisplay,
(DATE_FORMAT(DATE_SUB(UTC_TIMESTAMP(), INTERVAL (timezoneoffset - 4) HOUR), '%Y') - SUBSTRING(birthday,7,4)) AS UserAge
FROM vbwsm_user
WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')
AND showbirthday > '1'
AND usergroupid NOT IN (1,3,4,8,45,51)
AND userid NOT IN (SELECT ap_birthday.userid FROM vbwsm_ap_birthday);

MySQL Error : Unknown column 'ap_birthday.userid' in 'field list'
Error Number : 1054
Request Date : Sunday, June 26th 2011 @ 12:00:30 AM
Error Date : Sunday, June 26th 2011 @ 12:00:30 AM
Script : http://www.westsidemustangs.com/cron...and=1309064428
Referrer : http://www.westsidemustangs.com/sear...earchid=400030
IP Address : 208.54.83.141
Username : Unregistered
Classname : vB_Database
MySQL Version :

[Markos]

seams to work fine for me on 4.1.4

[AusPhotography]

Originally Posted by Markos

seams to work fine for me on 4.1.4

Ahhhhhhhhhhh!!!! It databases with pre-fix table names - which i don't use. I only do that by eyeballing the code.


Mea culpa

[Markos]

do we need to update the xml file or just the ap_birthday.php file

[AusPhotography]

Just the ap_birthday.php, but the XML ups the version number so you can track it.

[Boofo]

Do this allow you to turn off the PM option while keeping the thread option open?

[whitey92lx]

Well 1.0.5 seems to be working fine now. I didn't receive any database error emails, but I also don't appear to have any birthdays today..

Thank you for all of your help!

[AusPhotography]

Originally Posted by Boofo

Do this allow you to turn off the PM option while keeping the thread option open?

No, but 1.0.6 will