Request: Banned users not in birthdaylist?

[Carsten]

Hi,
I don't want to display banned users in birthdaylist on forumhome and in calendar.
Is this possible?

Thanks a lot.

[Logician]

edit functions.php find:

PHP Code:

  $bdays = $DB_site->query("SELECT username,userid,birthday
                            FROM user
                            WHERE birthday LIKE '%-$todayneggmt'
                              OR birthday LIKE '%-$todayposgmt'"); 


Replace it as:

PHP Code:

  $bdays = $DB_site->query("SELECT username,userid,birthday
                            FROM user
                            WHERE (birthday LIKE '%-$todayneggmt'
                              OR birthday LIKE '%-$todayposgmt') AND usergroupid!=X"); 


(Replace X with your banned usergroupid)

edit calendar.php, find:

PHP Code:

$birthday=$DB_site->query("SELECT birthday,username,userid from user where birthday like '%-$doublemonth-%'"); 


Replace it as:

PHP Code:

$birthday=$DB_site->query("SELECT birthday,username,userid from user where birthday like '%-$doublemonth-%' AND usergroupid!=X"); 


(Replace X with your banned usergroupid)

FYI. forum home hack will be active tomorrow, not in the day you applied.

Enjoy

[Carsten]

Thanks for help!

One additional question:
How can I ban several usergroups, e.g. 3, 4 and 5?

[Logician]

Replace
AND usergroupid!=X
parts as
AND (usergroupid!=X AND usergroupid!=Y AND usergroupid!=Z)

[Carsten]

Thx!