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)

Installed, now waiting for midnight :)

Thanks for the brilliant idea, this increases a lot the personal bound between users and the page!

Installed.... waiting for midnight too :)
Thank you!

When I run queries using Firefly's hack I sometimes make it - other times not. This time..."success" came the third time. Is this normal?

Quote:

Originally posted by bandersen
When I run queries using Firefly's hack I sometimes make it - other times not. This time..."success" came the third time. Is this normal?

Well, it doesnt seem normal but you need to ask Firefly about his hack :)

Quote:

Installed.... waiting for midnight too :)

Dont wait for the exact midnight time.. Wait for "tomorrow"..It can take the hack a few hours after midnight to greet the birthdays depending on the "serverload" option you set in the options. ;)

Quote:

Originally posted by lordofgun
Is there an option where this would only post a Happy Birthday thread to member with a certain number of posts? I don't want to clutter my boards with hundreds of happy birthday messages for members whoi have never posted.

Thanks in advance! GREAT HACK!

Would you be able to send me this hack as well? This looks freakin awesome, but I don't want birthdays for people that have 0 posts ;)

GREAT HACK! THANKS!

this sounds really cool! i gonna install when you updated the file with the function "certain number of posts"

Respect!

Quote:

Originally posted by WebMasterAJ

Would you be able to send me this hack as well? This looks freakin awesome, but I don't want birthdays for people that have 0 posts ;)

Why wouldn't you? It's a great way to get your non-posting members posting again. They will feel all warm and fuzzy when reading a special birthday PM or e-mail or even thread! :cool:

Good point. :)

Quote:

Originally posted by djr

Why wouldn't you? It's a great way to get your non-posting members posting again. They will feel all warm and fuzzy when reading a special birthday PM or e-mail or even thread! :cool:

Quote:

Originally posted by Birdie501
[B]i gonna install when you updated the file with the function "certain number of posts"
[B]

I'll give you the code soon, but first my 2 cents: :)
Install this hack as it is and set it to send EMAILS to your users (all of them). This will help remind you and your board to old/non-posting/non-visiting members, which is a good thing, dont you think?

Ok...Please note...

In this part...

Code:

// Excluded User groups. (That is Usergroup ID, NOT userid!)

// If you dont want to sent greetings for some usergroups enter their usergroups id:

// For example you should consider excluding Banned Users.

// Usage Examples: To exlude user group 12 use: $excluded_usergroups=array("12");

// To exclude user group 12 AND 13 use: $excluded_usergroups=array("12", "13");

// To NOT to exclude any usergroups, simply put a # in the begining of line below:

$excluded_usergroups=array('3');

In the instructions you show double quotes for the data and in the actual line you show single.

Not being a programmer...Which is right please?

Thank you for a very nice addition to our site.

As requested: (Apply ONE of them)

HACK OF THE HACK: ;)

TO GREET ONLY USERS WHO VISITED YOUR BOARD IN THE LAST X DAYS:

Find:

PHP Code:


		
			
## Time difference between the time zone you and your server's time. 

## Set is as a positive or negative number such as -3, +5 etc.

$timeset=9;

After that add:

PHP Code:


		
			
## Greets only users who visited your board in the last X days

$last_visit_day=90;

Find:

PHP Code:


		
			
$todays_date1= date("Y-m-d", mktime (date("H")+$timeset, date("i"), date("s"), date("m"), date("d"), date("Y")));

After that add:

PHP Code:


		
			
$user_last_visit= mktime (date("H")+$timeset, date("i"), date("s"), date("m"), date("d")-$last_visit_day, date("Y"));

Find:

PHP Code:


		
			
    $birthday_children_row=$DB_site->query("SELECT userid, username, birthday, email, receivepm FROM user WHERE birthday LIKE '%$greetingday' $excluded_SQL");

Replace it as:

PHP Code:


		
			
    $birthday_children_row=$DB_site->query("SELECT userid, username, birthday, email, receivepm FROM user WHERE lastvisit > $user_last_visit AND birthday LIKE '%$greetingday' $excluded_SQL");

TO GREET ONLY USERS WHO HAVE POSTED MORE THAN X MESSAGES:

Find:

PHP Code:


		
			
## Time difference between the time zone you and your server's time. 

## Set is as a positive or negative number such as -3, +5 etc.

$timeset=9;

After that add:

PHP Code:


		
			
## To Greet only users who have more than X messages, set this:

$message_to_greet=90;

Find:

PHP Code:


		
			
    $birthday_children_row=$DB_site->query("SELECT userid, username, birthday, email, receivepm FROM user WHERE birthday LIKE '%$greetingday' $excluded_SQL");

Replace it as:

PHP Code:


		
			
    $birthday_children_row=$DB_site->query("SELECT userid, username, birthday, email, receivepm FROM user WHERE posts>$message_to_greet AND birthday LIKE '%$greetingday' $excluded_SQL");

Enjoy! ;)
Logician

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (10)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01395 seconds Memory Usage 1,767KB 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 (1)bbcode_code_printable (10)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: