Register Members List Search Today's Posts Mark Forums Read

Reply
 
Mod Options
Birthday Thread and PM generator Details »
Birthday Thread and PM generator
Mod Version: 1.1.2, by AusPhotography (Coder) AusPhotography is offline
Developer Last Online: Nov 2019 I like it Show Printable Version Email this Page

vB Version: 4.0.0 Rating: (14 votes - 4.79 average) Installs: 115
Released: 16 May 2011 Last Update: 16 Apr 2013 Downloads: 715
Not Supported DB Changes Uses Plugins Additional Files Re-usable Code Translations  

www.AusPhotography.net.au 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

Download Now

Only licensed members can download files, Click Here for more information.

Show Your Support

  • To receive notifications regarding updates -> Click to Mark as Installed.
  • If you like this modification support the author by donating.
  • This modification may not be copied, reproduced or published elsewhere without author's permission.
Similar Mod
Mod Developer Type Replies Last Post
birthday in thread Mas*Mind vBulletin 2.x Full Releases 34 06 Sep 2002 12:31

  #31  
Old 25 Jun 2011, 17:28
whitey92lx's Avatar
whitey92lx whitey92lx is offline
 
Join Date: May 2011
Real name: Guy
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 :
__________________
westsidemustangs.com

Reply With Quote
  #32  
Old 25 Jun 2011, 23:11
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Brain fart - fixed (again)
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #33  
Old 26 Jun 2011, 05:03
whitey92lx's Avatar
whitey92lx whitey92lx is offline
 
Join Date: May 2011
Real name: Guy
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 :
__________________
westsidemustangs.com

Reply With Quote
  #34  
Old 26 Jun 2011, 09:35
Markos Markos is offline
 
Join Date: Aug 2006
seams to work fine for me on 4.1.4
Reply With Quote
  #35  
Old 26 Jun 2011, 09:48
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Originally Posted by Markos View Post
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
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #36  
Old 26 Jun 2011, 10:21
Markos Markos is offline
 
Join Date: Aug 2006
do we need to update the xml file or just the ap_birthday.php file
Reply With Quote
  #37  
Old 26 Jun 2011, 10:38
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Just the ap_birthday.php, but the XML ups the version number so you can track it.
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #38  
Old 26 Jun 2011, 11:46
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Do this allow you to turn off the PM option while keeping the thread option open?
Reply With Quote
  #39  
Old 26 Jun 2011, 15:35
whitey92lx's Avatar
whitey92lx whitey92lx is offline
 
Join Date: May 2011
Real name: Guy
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!
__________________
westsidemustangs.com

Reply With Quote
  #40  
Old 27 Jun 2011, 02:51
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
Originally Posted by Boofo View Post
Do this allow you to turn off the PM option while keeping the thread option open?
No, but 1.0.6 will
__________________
www.AusPhotography.net.au a.k.a. AP is a photography forum where members share their photography, photo editing skills and techniques. We run regular photographic competitions; Rick (site owner) and Kym (site tech) using this account
*** Home of the AP fully comprehensive vb4 photographic competition management solution ***
Reply With Quote
  #41  
Old 27 Jun 2011, 03:11
whitey92lx's Avatar
whitey92lx whitey92lx is offline
 
Join Date: May 2011
Real name: Guy
installed! Thanks!
__________________
westsidemustangs.com

Reply With Quote
  #42  
Old 27 Jun 2011, 03:27
Boofo's Avatar
Boofo Boofo is offline
 
Join Date: Mar 2002
Real name: Rob
Originally Posted by snoopytas View Post
No, but 1.0.6 will
I should hope so.
Reply With Quote
  #43  
Old 27 Jun 2011, 05:02
whitey92lx's Avatar
whitey92lx whitey92lx is offline
 
Join Date: May 2011
Real name: Guy
aaaaannd, IT WORKS!
__________________
westsidemustangs.com

Reply With Quote
  #44  
Old 28 Jun 2011, 11:35
BadgerDog BadgerDog is offline
 
Join Date: Oct 2006
Real name: Doug
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
Reply With Quote
  #45  
Old 28 Jun 2011, 23:53
AusPhotography's Avatar
AusPhotography AusPhotography is offline
 
Join Date: Nov 2007
Real name: Rick-owner, Kym-admin
@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.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Mod Options

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off


New To Site? Need Help?

All times are GMT. The time now is 23:06.

Layout Options | Width: Wide Color: