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

[smirkley]

OK, running vB4.2, and so far it posts and sends pm like it is supposed to.

I set the post number to 0, before I read the whole thread of course.
Set the number of days active to 60
And I set the excluded usergroups to exclude banned of course, and the awaiting email confirmation too.

Problem is, the very first birthday celebrated was for a uncomfirmed user account, one that specifically excluded.

Did I not configure it properly?

[elitecarders]

i got this error kindly check it

Database error in vBulletin 4.2.0:

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 1l_user
	WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')
	AND showbirthday > '1'
	AND usergroupid NOT IN ()
	AND userid NOT IN (SELECT 1l_ap_birthday.userid FROM 1l_ap_birthday);

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
	AND userid NOT IN (SELECT 1l_ap_birthday.userid FROM 1l_ap_birthday)' at line 7
Error Number  : 1064
Request Date  : Monday, April 8th 2013 @ 09:18:07 PM
Error Date    : Monday, April 8th 2013 @ 09:18:08 PM
Script        : http://www.XXXXXX.com/XXXXX/cronadmin.php?do=runcron&cronid=70
Referrer      : http://www.XXXXXX.com/XXX/cronadmin.php?do=modify
IP Address    : 103.22.201.159
Username      : _Mike74
Classname     : vB_Database
MySQL Version : 5.5.21-log

[AusPhotography]

Originally Posted by elitecarders

i got this error kindly check it

Thanks for the report. I'll fix it in the next day or so.

As a work around set at least one user group in the Exclude User Groups setting e.g. 8 which is Banned Users

Kym

[AusPhotography]

Originally Posted by smirkley

OK, running vB4.2, and so far it posts and sends pm like it is supposed to.

I set the post number to 0, before I read the whole thread of course.
Set the number of days active to 60
And I set the excluded usergroups to exclude banned of course, and the awaiting email confirmation too.

Problem is, the very first birthday celebrated was for a uncomfirmed user account, one that specifically excluded.

Did I not configure it properly?

I'll check that as well.

[smirkley]

Thanks.

Quick question ricktas,..

If a member does not opt to show their birthyear?... it seems the mod doesnt report their birthday.

Still testing it out mind you, but that was something I noticed.

[AusPhotography]

Originally Posted by smirkley

If a member does not opt to show their birthyear?... it seems the mod doesn't report their birthday.

It should do its thing if either of these privacy settings are set:

• Display Only Day and Month of Birth
• Display Age and Full Date of Birth

otherwise nada, that maybe the issue?

[smirkley]

Thanks for the reply.

I am experimenting with a test account, just to see it work with the first setting you listed above.

Seems like it didnt work last time, but I will let you know here in a day or two of the results.

[AusPhotography]

It works in my test system without the year set - with either profile option set,.

[smirkley]

Verified,..thx.

[smirkley]

Just noticed this morning that since after I set for "number of posts=0", that this will now ignore "days active=60" and give birthdays to everyone even inactive.

edit to add, I think that the description in the acp settings for this confused me. I was thinking that the mod will only post for members active, with x number of posts as a minimum.

I think now it says that active, means number of posts exclusively, and if you set it to 0, all members now qualify even if they havent logged on in years.