Birthday List - one group only?

[jamoss]

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!!

[Logician]

functions.php, check after:


function getbirthdays() {

[jamoss]

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.