View Full Version : Filter Birthdays By Posts
afterlab
05-04-2002, 10:00 PM
Filter Birthdays By Posts
Because members sometime only register to be famous.
============================================
This hack will only show Birthdays in the calendar and forumhome if the user's postcount is more than 10. (That number can be changed, just check out the install file.. Find the 10 in there somewhere. ;))
Compatibility: This hack will work with vB 2.0.3 and higher.
Install Time: 1-2 Minutes
Download: Instructions are in attachment.
Keyser S?ze
05-04-2002, 11:47 PM
OMG i just suggested this like 10 mins ago, i assume someone else did before me, or did u make this that quick?
great hack BTW!
afterlab
05-05-2002, 12:06 AM
heh.. I was bored and wanted to help people out, so I was just browsing the Request forum, and then made this by your request.
Thanks.
Keyser S?ze
05-05-2002, 12:57 AM
wow thats a record! :p great man, thanks, been wanting this for a log time :D
afterlab
05-05-2002, 01:12 AM
heh, glad to be of help, IceMalee. I see why you needed this: http://www.emusanet.com/forums/calendar.php
:eek:
AnkisethGallant
05-05-2002, 01:28 AM
Afterlab, your site, your boards, and your hacking abilities amaze me.
Job well done.
Keyser S?ze
05-05-2002, 01:44 AM
man u have no idea, back in the day when we had it so u had to be registerd to download, we had like 80,000 members, and 79,000 with 0 posts :p so the birthday thing was so long we had to turn it off :( but since then we changed that, and then went and cleared out all the dead members
but still, great hack
something to becareful of, i set mine to post>99 and that made it not work, but post>100 works fine, would be great to have that changeable in the admin cp >options under "turn today birthday on/off"
thanks again
Keyser S?ze
05-05-2002, 07:20 AM
this hack just seems to have stopped working :( check out the forums, most all these b-day users have 0 posts, also attached is my functions.php
www.emusanet.com/forums
Originally posted by IceMalee
this hack just seems to have stopped working :( check out the forums, most all these b-day users have 0 posts, also attached is my functions.php
www.emusanet.com/forums First, delete that attachment. We're not allowed to post complete vB files. Then, modify the query in functions.php. I think this will work: $bdays = $DB_site->query("SELECT username,userid,birthday
FROM user
WHERE posts>'101' AND (birthday LIKE '%-$todayneggmt'
OR birthday LIKE '%-$todayposgmt')");
TigerLily
05-05-2002, 02:36 PM
This is a great hack! I am wondering though how I could use it to include only users from a members group, mods, and admin (excluding banned, inactive, and awaiting moderation people from the bday listings). Is there an easy way to do this?
Thanks!
TigerLily:D
Keyser S?ze
05-05-2002, 03:55 PM
ok that seems to work, odd thing is, the other was working fine as well when i checked, so i think its a problem with the time, like 1am-9am type thing, i dunno, ill post again here tonight and tell u what happens :D
thanks
Broekie
05-05-2002, 05:04 PM
whoa, you really scared me!
could someone please change that [vB 2.2.6] to [vB 2.2.5]
* Broekie allready started sweating 'cause he thought it was update time again ;)
Originally posted by IceMalee
ok that seems to work, odd thing is, the other was working fine as well when i checked, so i think its a problem with the time, like 1am-9am type thing, i dunno, ill post again here tonight and tell u what happens :D
thanks If it worked, it will keep working. The code looks like it breaks the day up into two parts. The the two varialbes in the OR part of the query needed to be grouped together in parentheses.
-=dm=-
05-06-2002, 09:21 PM
Thanx :)
its working for me, but not in forumhome, it still shows todaysbirthday:(
Danny
06-04-2002, 02:09 PM
yeah on forumhome it still shows todays birthdays? do you know how fix this? or does anyone know how to fix this?
Keyser S?ze
06-04-2002, 06:12 PM
if u are using this hack and you have a member that has enough posts and its their b-day it suppose to show
if u dont want it to show ever just go to the admin cp>options and turn it off
LaNder
09-06-2002, 06:15 AM
On forumhome it still shows all Birthdays not depending on postcount.
The $birthdays-variable is no affected by this hack.
How could this be fixed?
LaNder
LaNder
09-07-2002, 08:00 AM
No Ideas? :(
LangTuDaTinh
01-01-2003, 08:54 PM
if u have vbportal from phpportals.com u can use this hack just change
showbirthdays.php
just change this line
$bdays = $DB_site->query("SELECT userid, username, birthday FROM user WHERE birthday LIKE '%-$today'");
to this line.
$bdays = $DB_site->query("SELECT posts, userid, username, birthday FROM user WHERE posts>='10' AND birthday LIKE '%-$today'");
great hack...thanks, and it works on 2.2.9
vBulletin® v3.8.12 by vBS, Copyright ©2000-2025, vBulletin Solutions Inc.