Changeset 702 for trunk/forum/index.php
- Timestamp:
- Mar 31, 2010, 6:32:40 PM (15 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/forum/index.php
r400 r702 3 3 * 4 4 * @package phpBB3 5 * @version $Id : index.php 8987 2008-10-09 14:17:02Z acydburn$5 * @version $Id$ 6 6 * @copyright (c) 2005 phpBB Group 7 7 * @license http://opensource.org/licenses/gpl-license.php GNU Public License … … 85 85 { 86 86 $now = getdate(time() + $user->timezone + $user->dst - date('Z')); 87 $sql = 'SELECT user_id, username, user_colour, user_birthday 88 FROM ' . USERS_TABLE . " 89 WHERE user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%' 90 AND user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')'; 87 $sql = 'SELECT u.user_id, u.username, u.user_colour, u.user_birthday 88 FROM ' . USERS_TABLE . ' u 89 LEFT JOIN ' . BANLIST_TABLE . " b ON (u.user_id = b.ban_userid) 90 WHERE (b.ban_id IS NULL 91 OR b.ban_exclude = 1) 92 AND u.user_birthday LIKE '" . $db->sql_escape(sprintf('%2d-%2d-', $now['mday'], $now['mon'])) . "%' 93 AND u.user_type IN (" . USER_NORMAL . ', ' . USER_FOUNDER . ')'; 91 94 $result = $db->sql_query($sql); 92 95
Note:
See TracChangeset
for help on using the changeset viewer.