phpBB.de

Code: Alles auswählen

        $sql = 'SELECT u.user_id, u.username, u.username_clean, u.user_type, u.user_colour, s.session_time, s.session_viewonline 
            FROM ' . USERS_TABLE . ' u, ' . SESSIONS_TABLE . ' s
            WHERE u.user_id = s.session_user_id
                AND u.group_id IN (4, 5)
                AND s.session_time >= ' . (time() - ($config['load_online_time'] * 60)) . '
                AND s.session_viewonline = 1
            ORDER BY s.session_viewonline';
        $result = $db->sql_query($sql);
        if ($result)
        {
            $template->assign_vars(array(
                'S_STAFF_ONLINE'    => true,
            ));
        } 

Code: Alles auswählen

if ($row = $db->sql_fetchrow($result) AND ($user->data['group_id'] <= 4))
        {
                $template->assign_vars(array(
                        'S_STAFF_ONLINE'    => true,
                ));
        } 

Code: Alles auswählen

    if ($row = $db->sql_fetchrow($result) AND ($user->data['group_id'] <= 4) AND ($user->data['group_id'] == 7))
            {
                    $template->assign_vars(array(
                            'S_STAFF_ONLINE'    => true,
                    ));
            } 

Code: Alles auswählen

if ($row = $db->sql_fetchrow($result) AND (($user->data['group_id'] <= 4) OR ($user->data['group_id'] == 7)))
        {
                $template->assign_vars(array(
                        'S_STAFF_ONLINE'    => true,
                ));
        }  

Code: Alles auswählen

if ($row = $db->sql_fetchrow($result) AND (($user->data['group_id'] < 4) OR ($user->data['group_id'] > 5)))
        {
                $template->assign_vars(array(
                        'S_STAFF_ONLINE'    => true,
                ));
        }