vb.org Archive - Automatic Greeting Email/PM/Threads for Member Birthdays

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)

- - Automatic Greeting Email/PM/Threads for Member Birthdays (https://vborg.vbsupport.ru/showthread.php?t=39663)

Great Hack!

But is it also possible that the automatic birthday greeting thread adds a birthday greet Post into (a specified) Birthday thread? I think a new Birthday Greet Thread each day is a bit too much though.

Thanks in advance for helping!

Quote:

08-18-03 at 12:02 AM dano said this in Post #159
Strange, I installed this and for some reason I can not post polls anymore on the site. I have not installed any other hacks or anything and the polls worked fine before. The hack works great, but I need my polls back, any ideas?

I'm safe to say that this can not be related to this hack. It has nothing to do with polls of vb, nor changes any poll related codes.

Quote:

Originally Posted by Logician

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

I've noticed that the hack stopped working on my site a little while ago.

The last timetick was about two months ago.

I've examined the code and the problem appears to be in the seeding of rand.

After a certain version of PHP this is no longer needed... and doing so seems to make PHP only return the maximum from rand.

So... where rand should have been producing a number between 1 and 6 (in my case)... it only ever produced 6... but you need a value of 1 to run Logicians code.

The solution... is merely to remove the make_seed function and the seeding of srand from the beginning of the hack.

BUT... only do this if you're affected by it.

Quote:

Originally Posted by buro9

thanks for letting us know and it will be also helpful if you mention your PHP version :)

Hi.

I have a serious problem with this hack, since 1/1/04 my users receive mails and PM's greetings without stopping. The hack is not sending or creating new threads since 31/12, just looping the mails and PMs for the 1/1 birthdays.
Please anyone can help me?

Sorry for my english.

Psico.

I installed the hack but I receive the following email with SQL Error. I'm sure it is something simple but I can't seem to find it. Thanks

Invalid SQL: SELECT userid, username, birthday, email, receivepm FROM user WHERE birthday LIKE '%-01-16' AND usergroupid!='3'
mysql error: Unknown column 'receivepm' in 'field list'

I have VB Version 3 rc 2

Quote:

Originally Posted by CaptChill

mysql error: Unknown column 'receivepm' in 'field list'

I have VB Version 3 rc 2

uhh this hack is NOT for VB3! :speechless: Please uninstall ASAP! :)

Besides you dont need it so badly, because VB3 already have a birthday greeting mailing as a default feature. You can find it under CRON management section.. ;)

OOPS...Thanks, Logician

Hi Logician,

I am testing this on my laptop test server, and after running the SQL command in part 1, you say i should get "SQL ... Run Successfully!" but i didnt any message at all?

Should i continue or is there a problem.

Im using it in vB2.3.0

Thanks

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

I get this error

Quote:

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:

Quote:

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.

Quote:

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

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

Quote:

Originally Posted by glo

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

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!

is this available for 3.0.3?

Anyone try this with vB 2.3.5?

Thanks.

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*

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01428 seconds Memory Usage 1,795KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (8)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (21)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: