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]

installed! Thanks!

[Boofo]

Originally Posted by snoopytas

No, but 1.0.6 will

I should hope so.

[whitey92lx]

aaaaannd, IT WORKS!

[BadgerDog]

I think I'm going to have to un-install this as I can't figure out why it's not working ...

Perhaps I don't understand the wording of these options?

Days Active
Posts in this number of Days to get a Birthday Post (30)

Posts in days
Number of posts in days to get a Birthday Post (5)

I simply want any member who has been active in the last 180 days and whose post count is zero (0), to be able to receive a PM and post in the designated forum.

What should be the settings for these options above.

It won't accept a zero in the "Number of posts in days to get a Birthday Post" field and keeps defaulting back to one (1)...

Any feedback would be welcome ..

Regards,
Doug

[AusPhotography]

@Doug
The definition of 'active' for this plugin is posts; not just logging in.
I.e. 1 post in the last 180 days would work, but not zero.

I wrote it as a reward for people who actually interact on the forums.
On our forum we discourage lurking.

Feel free to modify the code to your needs.

[BadgerDog]

Originally Posted by snoopytas

@Doug
The definition of 'active' for this plugin is posts; not just logging in.
I.e. 1 post in the last 180 days would work, but not zero.

I wrote it as a reward for people who actually interact on the forums.
On our forum we discourage lurking.

Feel free to modify the code to your needs.

Thanks ... :up:

Is there a line in the code (or plugin) somewhere that I could change it to permit 0 posts?

Regards,
Doug

[AusPhotography]

Originally Posted by BadgerDog

Thanks ... :up:
Is there a line in the code (or plugin) somewhere that I could change it to permit 0 posts?

Sure... you will need to modify the 2nd SQL select statement in ap_birthday.php.

http://dev.mysql.com/doc/refman/5.1/en/select.html

[AusPhotography]

I had a query by PM regarding when the greeting is posted...

The messages get posted ~4 hours after midnight of the person receiving the greetings timezone.
The idea being they get the greeting on the morning of their birthday.
Obviously subject to the vagaries of the cron job system.
As we have members across the planet this was an important idea.

The code that makes it happen is this...

// Get all possible birthdays today in members timezone after 4:00am members timezone	
// vBulletin formats birthday as mm-dd-yyyy (yyyy = 0000 is year if supressed)	
$birthdays_db = $vbulletin->db->query_read("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 " . TABLE_PREFIX . "user
	WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')
	AND showbirthday > '1'
	AND usergroupid NOT IN (".$vbulletin->options['APbirthday_excludeug'].")
	AND userid NOT IN (SELECT " . TABLE_PREFIX . "ap_birthday.userid FROM " . TABLE_PREFIX . "ap_birthday)
");

[BadgerDog]

Uninstalled ... for some reason, just stopped working .... switched back to Valter's mod for this purpose ...

Thanks to the developer his efforts ....

Regards,
Doug

[AusPhotography]

Originally Posted by BadgerDog

Uninstalled ... for some reason, just stopped working .... switched back to Valter's mod for this purpose ...

Thanks to the developer his efforts ....

Regards,
Doug

It works for us and other sites.
There is no reason it should just stop working.

Check that the cron job is working.

What changed on you site?
Remember it is based on forum activity.

What settings did you have?