PDA

View Full Version : Request: Banned users not in birthdaylist?


Carsten
10-08-2003, 04:06 PM
Hi,
I don't want to display banned users in birthdaylist on forumhome and in calendar.
Is this possible?

Thanks a lot.

Logician
10-08-2003, 07:38 PM
edit functions.php find:

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

Replace it as:
$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:
$birthday=$DB_site->query("SELECT birthday,username,userid from user where birthday like '%-$doublemonth-%'");

Replace it as:
$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
10-29-2003, 10:03 AM
Thanks for help! :)

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

Logician
10-29-2003, 10:50 AM
Replace
AND usergroupid!=X
parts as
AND (usergroupid!=X AND usergroupid!=Y AND usergroupid!=Z)

Carsten
10-29-2003, 10:52 AM
Thx! :)