vb.org Archive

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)

smirkley 03-23-2013 01:58 AM

OK, running vB4.2, and so far it posts and sends pm like it is supposed to.

I set the post number to 0, before I read the whole thread of course.
Set the number of days active to 60
And I set the excluded usergroups to exclude banned of course, and the awaiting email confirmation too.

Problem is, the very first birthday celebrated was for a uncomfirmed user account, one that specifically excluded.

Did I not configure it properly?

elitecarders 04-08-2013 08:20 PM

i got this error kindly check it

Code:

Database error in vBulletin 4.2.0:

Invalid SQL:
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 1l_user
        WHERE birthday LIKE DATE_FORMAT(DATE_ADD(UTC_TIMESTAMP(), INTERVAL ((timezoneoffset - 4)*60) MINUTE), '%m-%d%%')
        AND showbirthday > '1'
        AND usergroupid NOT IN ()
        AND userid NOT IN (SELECT 1l_ap_birthday.userid FROM 1l_ap_birthday);

MySQL Error  : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
        AND userid NOT IN (SELECT 1l_ap_birthday.userid FROM 1l_ap_birthday)' at line 7
Error Number  : 1064
Request Date  : Monday, April 8th 2013 @ 09:18:07 PM
Error Date    : Monday, April 8th 2013 @ 09:18:08 PM
Script        : http://www.XXXXXX.com/XXXXX/cronadmin.php?do=runcron&cronid=70
Referrer      : http://www.XXXXXX.com/XXX/cronadmin.php?do=modify
IP Address    : 103.22.201.159
Username      : _Mike74
Classname    : vB_Database
MySQL Version : 5.5.21-log


AusPhotography 04-08-2013 09:58 PM

Quote:

Originally Posted by elitecarders (Post 2415199)
i got this error kindly check it

Thanks for the report. I'll fix it in the next day or so.

As a work around set at least one user group in the Exclude User Groups setting e.g. 8 which is Banned Users :D

Kym

AusPhotography 04-08-2013 09:58 PM

Quote:

Originally Posted by smirkley (Post 2411672)
OK, running vB4.2, and so far it posts and sends pm like it is supposed to.

I set the post number to 0, before I read the whole thread of course.
Set the number of days active to 60
And I set the excluded usergroups to exclude banned of course, and the awaiting email confirmation too.

Problem is, the very first birthday celebrated was for a uncomfirmed user account, one that specifically excluded.

Did I not configure it properly?

I'll check that as well.

smirkley 04-09-2013 02:31 AM

Thanks.

Quick question ricktas,..

If a member does not opt to show their birthyear?... it seems the mod doesnt report their birthday.

Still testing it out mind you, but that was something I noticed.

AusPhotography 04-09-2013 08:19 AM

Quote:

Originally Posted by smirkley (Post 2415230)
If a member does not opt to show their birthyear?... it seems the mod doesn't report their birthday.

It should do its thing if either of these privacy settings are set:
  • Display Only Day and Month of Birth
  • Display Age and Full Date of Birth
otherwise nada, that maybe the issue?

smirkley 04-09-2013 01:28 PM

Thanks for the reply.

I am experimenting with a test account, just to see it work with the first setting you listed above.

Seems like it didnt work last time, but I will let you know here in a day or two of the results.

AusPhotography 04-10-2013 03:53 AM

It works in my test system without the year set - with either profile option set,.

smirkley 04-11-2013 03:55 AM

Verified,..thx.

smirkley 04-11-2013 12:19 PM

Just noticed this morning that since after I set for "number of posts=0", that this will now ignore "days active=60" and give birthdays to everyone even inactive.

edit to add, I think that the description in the acp settings for this confused me. I was thinking that the mod will only post for members active, with x number of posts as a minimum.

I think now it says that active, means number of posts exclusively, and if you set it to 0, all members now qualify even if they havent logged on in years.


All times are GMT. The time now is 10:51 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01116 seconds
  • Memory Usage 1,741KB
  • 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
  • (3)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