vb.org Archive
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

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.

AusPhotography 04-12-2013 02:35 AM
Quote:
Originally Posted by smirkley (Post 2415705)
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.
You are correct. It's post activity based (in forums that have post count enabled).
We are attempting to limit greeting to people who have posted something in the last X days.

Posts = 0 does mean everyone.

So in that case I'll change it to apply the last activity date.

smirkley 04-12-2013 02:40 AM
Tried to 'like', but vborg wont let me.

Still 'like'.

smirkley 04-15-2013 01:35 PM
Using the latest update...

Had a birthday notice today for a member that hasnt been online active since 2004.

Have minimum posts set to 0.

AusPhotography 04-16-2013 03:18 AM
Quote:
Originally Posted by smirkley (Post 2416481)
Using the latest update...
Had a birthday notice today for a member that hasn't been online active since 2004.
Have minimum posts set to 0.
I can't reproduce that.

Can you tell me the value of the field 'lastactivity' on that users record?
(Use phpmyadmin for that on cPanel)
or a query like
Code:
select lastactivity from user where userid=XXX
in the AdminCP -- you may need to change user to TABLE_PREFIXuser and XXX is the userid of the account.

Also, make sure you uploaded "ap_birthday.php" to the correct folder (i.e. the cron folder) and overwrote the old version.

smirkley 04-16-2013 03:30 AM
I did upload the file to the correct folders, checked to be sure.

And just had a member that hasnt logged on given a birthday thread even though not logged into since 2005 someodd.

I will do the cpanel query tomorrow,..its late atm.

smirkley 04-16-2013 12:18 PM
"ap_birthday.php" should have "Version: 1.1.1 2013-04-12" on line 5.

I verified this this morning as correct as well as the file location.

But then I noticed the 1.1.2, so I installed that version.

stevieb 08-01-2013 11:23 AM
is this confirmed as working, or dead then?

Looking to install in vB 4.2.0

Thanks :)

AusPhotography 08-02-2013 02:47 AM
Working fine and supported. Works on all 4.2 versions.

stevieb 08-07-2013 09:45 AM
Quote:
Originally Posted by ricktas (Post 2436647)
Working fine and supported. Works on all 4.2 versions.
Installed - lets see if tomorrow birthdays work right :)

Thanks again, will update you soon. (vB 4.2.0)

My Hattiesburg 08-08-2013 03:07 AM
I just installed it on a 4.2.1 board and so far it works fine.

ahobilam 08-08-2013 05:44 AM
Installed but yet to check.
I have some idea for another mod basing on this mod, the author can try if possible and interested.
That is:
Fetching the events stored in the calendar and posting new thread in a forum for that to remind users about that event in advance say one week or one day.
Mostly people will search on current topics and the forums will get lot of hits to view the discussions going on about the current topic.

stevieb 08-08-2013 05:30 PM
Quote:
Originally Posted by ricktas (Post 2436647)
Working fine and supported. Works on all 4.2 versions.
Quote:
Originally Posted by stevieb (Post 2437616)
Installed - lets see if tomorrow birthdays work right :)

Thanks again, will update you soon. (vB 4.2.0)
Yep works sound on 4.2.0 although the pm, email & thread gets posted in bold font and the URL sent to pm doesn't hyperlink - it's in plain text.

Can we use HTML in the message text? Any ideas how to sort above issues please?

stevieb 08-08-2013 05:31 PM
Quote:
Originally Posted by ahobilam (Post 2437766)
Fetching the events stored in the calendar and posting new thread in a forum for that to remind users about that event in advance say one week or one day.
Mostly people will search on current topics and the forums will get lot of hits to view the discussions going on about the current topic.
Great idea :)

AusPhotography 08-09-2013 04:12 AM
Quote:
Originally Posted by stevieb (Post 2437868)
Yep works sound on 4.2.0 although the pm, email & thread gets posted in bold font and the URL sent to pm doesn't hyperlink - it's in plain text.
The URL in the PM should hyperlink as it's wrapped in URL bbcode. What did you change the standard text to?

Quote:
Can we use HTML in the message text? Any ideas how to sort above issues please?
No.

CoZmicShReddeR 08-10-2013 01:06 PM
I want it to show Birthdays no matter what how do I set it to always show Birthdays? I do not want it based on posts or active users...

AusPhotography 08-11-2013 10:33 PM
Quote:
Originally Posted by CoZmicShReddeR (Post 2438156)
I want it to show Birthdays no matter what how do I set it to always show Birthdays? I do not want it based on posts or active users...
Set the Days Active and Posts in Days to zero.

scottct1 09-03-2013 12:47 PM
I keep setting both to 0 but when I save it, it sets Days Active to 1.

AusPhotography 09-03-2013 11:17 PM
Quote:
Originally Posted by scottct1 (Post 2442861)
I keep setting both to 0 but when I save it, it sets Days Active to 1.
I'll investigate that

Jamey 09-09-2013 02:08 PM
Thanks!

Jamey 09-10-2013 12:22 PM
How can I set it so I don't have to approve these new threads?

Jamey 09-11-2013 01:20 PM
How do we mark this mod as unsupported?

ozzy47 09-11-2013 09:58 PM
You don't the developer has to do that.

AusPhotography 09-11-2013 10:17 PM
Quote:
Originally Posted by Jamey (Post 2444632)
How can I set it so I don't have to approve these new threads?
It is supported, it is also free.
I have a life as well :D So I may not respond within a day or week, but will eventually.

The thread approval is part of your vB setup, not this add-on.
The add-on does not set anything to do with thread approval.

You do via AdminCP and the Forum Manager - RTFM :eek:

Kym

Jamey 09-12-2013 11:23 AM
Thanks. I am the main Admin, so what setting should it be then? None of my other stuff is moderated obviously. All moderation options are not enabled on that forum. Maybe set the forum to allow HTML?

smirkley 09-12-2013 12:06 PM
No, you should never allow html in a forum unless only admins can post there, security risk.

I use the same mod, and I have never had to approve a thread with this. But I have it posting in my Lounge forum.

What member group is the post member set for?

AusPhotography 09-13-2013 03:22 AM
The following should be of in the Forum being posted to by this add-on...
via the Forum Manager
  • Moderate Posts (Require moderator validation before new posts are displayed)
  • Moderate Threads (Require moderator validation before new threads are displayed)

AusPhotography 09-14-2013 07:44 AM
Quote:
Originally Posted by scottct1 (Post 2442861)
I keep setting both to 0 but when I save it, it sets Days Active to 1.
Days Active should be set to a high number if you want everyone to get a greeting.
I just realised what you want to do with this.
Eg. 365 for one year (anyone active in the last year) or 99999999 for effectively infinite.

Jamey 09-15-2013 12:55 PM
Quote:
Originally Posted by smirkley (Post 2445087)
No, you should never allow html in a forum unless only admins can post there, security risk.

I use the same mod, and I have never had to approve a thread with this. But I have it posting in my Lounge forum.

What member group is the post member set for?
I just took the 1 out of Exclude Usergroups. I am in usergroup 1 abd it did post for me. But I stiil had to moderate (approve the thread) it.

We'll see if that makes a difference...don't know why It would though. That's just for excluding their Birthdays if I am correct.

Jamey 09-28-2013 02:38 PM
1 Attachment(s)
Like I said. I had the permissions set for that forum already.

Jamey 10-27-2013 03:02 PM
same deal still


All times are GMT. The time now is 09:54 AM.
Page 3 of 4 12 3 4
Show 40 post(s) from this thread on one page

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.01434 seconds
  • Memory Usage 1,829KB
  • 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
  • (2)bbcode_code_printable
  • (16)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (3)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)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