Sucheinstellungen (Seite 3 von 16)

  $result = $db->query('SELECT A.user_id, A.ident, B.group_id FROM '.$db->prefix.'online A, '.$db->prefix.'users B WHERE A.user_id=B.id and B.group_id > '.PUN_ADMIN .' and idle=0 ORDER BY ident', true) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error());

  $result = $db->query('SELECT A.user_id, A.ident, B.group_id FROM '.$db->prefix.'online A, '.$db->prefix.'users B WHERE A.user_id='.$MEINEUSERID.' and idle=0 ', true) or error('Unable to fetch online list', __FILE__, __LINE__, $db->error());

function handle_url_tag($url, $link = '')
{
    global $pun_user;

    $full_url = str_replace(array(' ', '\'', '`', '"'), array('%20', '', '', ''), $url);
    if (strpos($url, 'www.') === 0)            // If it starts with www, we add http://
        $full_url = 'http://'.$full_url;
    else if (strpos($url, 'ftp.') === 0)    // Else if it starts with ftp, we add ftp://
        $full_url = 'ftp://'.$full_url;
    else if (!preg_match('#^([a-z0-9]{3,6})://#', $url, $bah))     // Else if it doesn't start with abcdef://, we add http://
        $full_url = 'http://'.$full_url;

    // Ok, not very pretty :-)
    $link = ($link == '' || $link == $url) ? ((strlen($url) > 55) ? substr($url, 0 , 39).' … '.substr($url, -10) : $url) : stripslashes($link);
    $link = preg_replace("|https?://|","", $link);
//     $link = preg_replace("|([^/]+)/.*|","\\1", $link);
    
    return '<a href="'.$full_url.'">'.$link.'</a>';
}

function handle_url_tag($url, $link = '')
{
    global $pun_user;

    $full_url = str_replace(array(' ', '\'', '`', '"'), array('%20', '', '', ''), $url);
    if (strpos($url, 'www.') === 0)            // If it starts with www, we add http://
        $full_url = 'http://'.$full_url;
    else if (strpos($url, 'ftp.') === 0)    // Else if it starts with ftp, we add ftp://
        $full_url = 'ftp://'.$full_url;
    else if (!preg_match('#^([a-z0-9]{3,6})://#', $url, $bah))     // Else if it doesn't start with abcdef://, we add http://
        $full_url = 'http://'.$full_url;

    // Ok, not very pretty :-)
    $link = ($link == '' || $link == $url) ? "Link" : stripslashes($link);
    $link = preg_replace("|https?://|","", $link);
//     $link = preg_replace("|([^/]+)/.*|","\\1", $link);
    
    return '<a href="'.$full_url.'">'.$link.'</a>';
}

$result = $db->query('SELECT u.id, u.username, u.title, u.num_posts, u.registered, u.last_visit, g.g_id, g.g_user_title FROM '.$db->prefix.'users AS u LEFT JOIN '.$db->prefix.'groups AS g ON g.g_id=u.group_id WHERE u.id>1'.(!empty($where_sql) ? ' AND '.implode(' AND ', $where_sql) : '').' ORDER BY '.$sort_by.' '.$sort_dir.' LIMIT '.$start_from.', 50') or error('Unable to fetch user list', __FILE__, __LINE__, $db->error());

                    <td class="tcr"><?php echo format_time($user_data['last_visit'], true) ?></td>