diff options
| author | Joas Schilling <nickvergessen@gmx.de> | 2009-06-18 11:04:54 +0000 |
|---|---|---|
| committer | Joas Schilling <nickvergessen@gmx.de> | 2009-06-18 11:04:54 +0000 |
| commit | 815bbac230917ae2110bd9d719f763d5bba1c52f (patch) | |
| tree | 25ed8f442ec110680a9db2c474b08f9a0f41ea2c /phpBB/index.php | |
| parent | d978dae5a11441bd3290535a91b7af33a816a832 (diff) | |
| download | forums-815bbac230917ae2110bd9d719f763d5bba1c52f.tar forums-815bbac230917ae2110bd9d719f763d5bba1c52f.tar.gz forums-815bbac230917ae2110bd9d719f763d5bba1c52f.tar.bz2 forums-815bbac230917ae2110bd9d719f763d5bba1c52f.tar.xz forums-815bbac230917ae2110bd9d719f763d5bba1c52f.zip | |
fix r9604
Authorised by: AcydBurn
git-svn-id: file:///svn/phpbb/branches/phpBB-3_0_0@9614 89ea8834-ac86-4346-8a33-228a782c2dd0
Diffstat (limited to 'phpBB/index.php')
| -rw-r--r-- | phpBB/index.php | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/phpBB/index.php b/phpBB/index.php index 9dffade44c..c3dbbd346e 100644 --- a/phpBB/index.php +++ b/phpBB/index.php @@ -84,10 +84,11 @@ $birthday_list = ''; if ($config['load_birthdays'] && $config['allow_birthdays']) { $now = getdate(time() + $user->timezone + $user->dst - date('Z')); - $sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday, b.ban_id + $sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday FROM ' . USERS_TABLE . ' u LEFT JOIN ' . BANLIST_TABLE . " b ON (u.user_id = b.ban_userid) - WHERE b.ban_id IS NULL + WHERE (b.ban_id IS NULL + OR b.ban_exclude = 1) AND u.user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%' AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')'; $result = $db->sql_query($sql); |