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 \\=^))

[glo]

actually, i have continued with the hack and i didnt get any indication that the command was actioned. There was no "todays date" to confirm that it was done ok. but there was no error either???

Please help, thanks

[glo]

I get this error

Database error in vBulletin 2.3.0:

Invalid SQL: SELECT * FROM timetick WHERE action='birthday' LIMIT 1
mysql error: Table 'forum.timetick' doesn't exist

mysql error number: 1146

Date: Friday 01st of October 2004 10:53:06 PM
Script: http://localhost/forum/forum_wip/
Referer:

[Logician]

Originally Posted by glo

I get this error

You can use any SQL running tool to apply these SQL commands. For instance use phpmyadmin. Apparently logician_query.php didn't run it for somereason.

[glo]

Originally Posted by Logician

You can use any SQL running tool to apply these SQL commands. For instance use phpmyadmin. Apparently logician_query.php didn't run it for somereason.

Hi Logician,

I tried running the script in PhpMyAdmin but i couldnt see any response either, so it could be a MySQL setting, however i did notice that the error says that the script is located at "http://localhost/forum/forum_wip/" which is also incorrect, it is located at http://localhost/forum_wip/admin/

So could this assist in determining where the issue is?

Thanks

[glo]

This is what PhpMyAdmin says:

Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.

Which links to the below message.

PMA Database ... not OK[ Documentation ]
General relation features Disabled

How can i enable this???

Thanks

[Logician]

Originally Posted by glo

This is what PhpMyAdmin says:

Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.

Which links to the below message.

PMA Database ... not OK[ Documentation ]
General relation features Disabled

How can i enable this???

Thanks

This is not a hack problem, you have a MYSQL configuration/installation problem. Please fix it first. You can try searching the error in google. Also this can help:
http://forums.devside.net/viewtopic.php?t=198

[glo]

Hi Logician, I was able to load your queries through phpMyAdmin.

I believe the problem lies in the configuration rather than the installation.

But for now, i think im ok since i could load your queries via phpMyAdmin (unless you tell me thats not possibe)

Already Clicks install. (just using it on my test setup for now!)

thanks for your help!

[Takamine334]

is this available for 3.0.3?

[Takamine334]

nevermind

[bigdaddy04]

Anyone try this with vB 2.3.5?

Thanks.