![]() |
Birthday List - one group only?
I want the birthday list to show up for only one particular group (paid members).
I know how to alter the select statement, but I don't know where the SQL statement is that updates the birthday bit!! Any help out there??? THANKS!! |
functions.php, check after:
PHP Code:
|
Thank you! Works great. Here's the hack if anyone wants it.
EDIT: admin/functions.php REPLACE: $bdays = $DB_site->query("SELECT username,userid,birthday FROM user WHERE birthday LIKE '%-$todayneggmt' OR birthday LIKE '%-$todayposgmt'"); WITH: $bdays = $DB_site->query("SELECT username,userid,birthday FROM user WHERE (usergroupid='1' OR usergroupid='2') AND (birthday LIKE '%-$todayneggmt' OR birthday LIKE '%-$todayposgmt')"); ~~~~~~ Notes: include the usergroupid you want PLUS any moderator or admin group if you want their birthdays to show up too. |
All times are GMT. The time now is 02:13 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 | |
---|---|
|
|
![]() |
|
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|