Changeset 702 for trunk/forum/index.php


Ignore:
Timestamp:
Mar 31, 2010, 6:32:40 PM (15 years ago)
Author:
george
Message:
  • Upraveno: Aktualizace fóra.
File:
1 edited

Legend:

Unmodified
Added
Removed
  • trunk/forum/index.php

    r400 r702  
    33*
    44* @package phpBB3
    5 * @version $Id: index.php 8987 2008-10-09 14:17:02Z acydburn $
     5* @version $Id$
    66* @copyright (c) 2005 phpBB Group
    77* @license http://opensource.org/licenses/gpl-license.php GNU Public License
     
    8585{
    8686        $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 . ')';
    9194        $result = $db->sql_query($sql);
    9295
Note: See TracChangeset for help on using the changeset viewer.