Forum

$Template->assign_vars(array(
        'PAGINATION' => '&nbsp;<strong>' . $LANG['page'] . ' :</strong> ' . $Pagination->display('member' . url('.php' . (!empty($unget) ? $unget . '&amp;' : '?') . 'p=%d', '-0-%d.php' . $unget), $nbr_member, 'p', 25, 3)
    ));
 
    $result = $Sql->query_while("SELECT user_id, login, user_mail, user_show_mail, timestamp, user_msg, user_local, user_web, last_connect
    FROM " . PREFIX . "member
    $result = $Sql->query_while("SELECT user_id, login, user_mail, user_show_mail, timestamp, user_msg, user_local, user_web, last_connect, user_avatar
    ORDER BY " . $sort . " " . $mode .
    $Sql->limit($Pagination->get_first_msg(25, 'p'), 25), __LINE__, __FILE__);
    while ($row = $Sql->fetch_assoc($result))
    {
        $user_web = !empty($row['user_web']) ? '<a href="' . $row['user_web'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/user_web.png" alt="' . $row['user_web'] . '" title="' . $row['user_web'] . '" /></a>' : '&nbsp;';
        $user_msg = !empty($row['user_msg']) ? $row['user_msg'] : '0';
 
        $user_mail = ( $row['user_show_mail'] == 1 ) ? '<a href="mailto:' . $row['user_mail'] . '"><img src="../templates/' . get_utheme() . '/images/' . get_ulang() . '/email.png" alt="' . $row['user_mail'] . '" /></a>' : '&nbsp;';
 
        $row['last_connect'] = !empty($row['last_connect']) ? $row['last_connect'] : $row['timestamp'];
 
        $Template->assign_block_vars('member_list', array(
            //Avatar    .
$user_avatar = !empty($row['user_avatar']) ? '<img class="valign_middle" src="' . $row['user_avatar'] . '" alt=""    />' : '';
if (empty($row['user_avatar']) && $CONFIG_USER['activ_avatar'] == '1')
$user_avatar = '<img class="valign_middle" src="../templates/' . get_utheme() . '/images/' .  $CONFIG_USER['avatar_url'] . '" alt="" />';
            'PSEUDO' => $row['login'],
            'USER_AVATAR' => $user_avatar,
'L_AVATAR' => $LANG['avatar'],
            'MAIL' => $user_mail,
            'MSG' => $user_msg,
            'LOCAL' => !empty($row['user_local']) ? $row['user_local'] : '&nbsp;',
            'LAST_CONNECT' => gmdate_format('date_format_short', $row['last_connect']),
            'WEB' => $user_web,
            'DATE' => gmdate_format('date_format_short', $row['timestamp']),
            'U_USER_ID' => url('.php?id=' . $row['user_id'], '-' . $row['user_id'] . '.php'),
            'U_USER_PM' => url('.php?pm=' . $row['user_id'], '-' . $row['user_id'] . '.php')
        ));
    }
    $Sql->query_close($result);
 
    $Template->pparse('member');
}

$result = $Sql->query_while(