vb.org Archive - Profile Enhancements - Birthday Thread and PM generator

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

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Profile Enhancements - Birthday Thread and PM generator (https://vborg.vbsupport.ru/showthread.php?t=263701)

Quote:

Originally Posted by snoopytas (Post 2213346)

No, but 1.0.6 will :D

I should hope so. :p

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?

Quote:

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. :confused:

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

@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.

Quote:

Originally Posted by snoopytas (Post 2214300)

Thanks ... :up:

Is there a line in the code (or plugin) somewhere that I could change it to permit 0 posts?

Regards,
Doug

Quote:

Originally Posted by BadgerDog (Post 2214437)

Thanks ... :up:
Is there a line in the code (or plugin) somewhere that I could change it to permit 0 posts?

Sure... you will need to modify the 2nd SQL select statement in ap_birthday.php.

http://dev.mysql.com/doc/refman/5.1/en/select.html

I had a query by PM regarding when the greeting is posted...

The messages get posted ~4 hours after midnight of the person receiving the greetings timezone.
The idea being they get the greeting on the morning of their birthday.
Obviously subject to the vagaries of the cron job system.
As we have members across the planet this was an important idea.

The code that makes it happen is this...

Code:

// Get all possible birthdays today in members timezone after 4:00am members timezone        

// vBulletin formats birthday as mm-dd-yyyy (yyyy = 0000 is year if supressed)        

$birthdays_db = $vbulletin->db->query_read("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 " . TABLE_PREFIX . "user

        WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')

        AND showbirthday > '1'

        AND usergroupid NOT IN (".$vbulletin->options['APbirthday_excludeug'].")

        AND userid NOT IN (SELECT " . TABLE_PREFIX . "ap_birthday.userid FROM " . TABLE_PREFIX . "ap_birthday)

");

Uninstalled ... for some reason, just stopped working .... switched back to Valter's mod for this purpose ...

Thanks to the developer his efforts .... :)

Regards,
Doug

Quote:

Originally Posted by BadgerDog (Post 2221421)

Uninstalled ... for some reason, just stopped working .... switched back to Valter's mod for this purpose ...

Thanks to the developer his efforts .... :)

Regards,
Doug

:confused: It works for us and other sites.
There is no reason it should just stop working.

Check that the cron job is working.

What changed on you site?
Remember it is based on forum activity.

What settings did you have?

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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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.01035 seconds Memory Usage 1,745KB 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 (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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: