Automatic Greeting Email/PM/Threads for Member Birthdays

This hack will automatically greet the birthdays of your board members by sending them:

• Private Messages
• Emails
• Both
• or by creating a birthday celebration thread in a specific forum.

Features:
* Does NOT require cron jobs so everybody can use it regardless of their server settings/rights.
* You can send PMs, emails (or both) or you can choose to send them PM if they can receive PM or else send email.
* The Hack can create special greeting threads for birthdays. (optional)
* Some usergroups (like banned users) can be excluded from automatic greetings.
* Admin can choose to receive a daily report via Email or PM about the greeted birthdays. (optional)
* Compatible with ALL vbulletin versions I know.
* Carefully coded to not to increase your SQL load and its quite performance-friendly. (More info about performance issues)
* New Added Feature: To greet only members who have more than X messages or who have visited your board in the last X days, see here
* New Added Feature: You can change his style in the day user has his birthday. Check here)
* New Added Feature: You can play Happy Birthday Song to your members in their birthdays. Check here

The hack is beta tested by many users for a long time before the release and proven to be quite stable. (BTW. thx to all beta testers especially to Dark_Wizard, Boofo, DslTeam, C-Pr0mpt for returning feedback).

WARNING: I strongly suggest:
a) Be careful while installing this hack (especially in step 2). If you install it wrongly, your members may get a lot of irrelevant greetings.
b) To make sure you installed it correctly, turn on DEBUG mode AND administrator notifications in the options of the hack while you are installing it. So the hack will NOT send any notifications to members but only send daily reports to admin. Keep an eye on these reports for a few days and if you made sure you installed it correctly and it works ok, you can safely turn off debug mode.


Enjoy the hack and if you install the hack please click INSTALL, thank you..

Logician \\=^))

[TruthElixirX]

Database error in vBulletin 3.0.5:

Invalid SQL: SELECT userid, username, birthday, email, receivepm FROM user WHERE birthday LIKE '%-02-25' AND usergroupid!='3'
mysql error: Table 'vbulletin.user' doesn't exist

mysql error number: 1146

Date: Friday 25th of February 2005 09:54:26 PM
Script: http://www.punktek.com/forums/?
Referer: http://www.punktek.com/?
Username: Chris
IP Address: 162.40.130.58



MySql Error....Crud

EDIT:: I refreshed and it worked. Also could this have screwed with my member pages? Whenever some looks at the member list and tries to click on someon'es profile they/me get a blank page.


EDIT 2:: I have found the problem! This is a Vb2 mod...I'm running Vb 3. God..-_-. I can't frigging believe this.

*Goes to uninstall*