Search options (Page 3 of 4)

<?php
$punbb_path = $_SERVER['SCRIPT_FILENAME'];
$punbb_path = './punbb/';

define('PUN_ROOT', "$punbb_path");
require PUN_ROOT.'include/common.php';

define('PUN_TURN_OFF_MAINT', 1); // if forums go down the site will not
define('PUN_QUIET_VISIT', 0); // update last visit when outside of the forums
?>

<?
if($pun_user['id'] > 1)
{ 
$query = "SELECT id, username, last_visit FROM ".$db->prefix."users WHERE id='".$pun_user['id']."'";
$result = $db->query($query) or error('Unable to fetch user data', __FILE__, __LINE__, $db->error());

$data = $db->fetch_assoc($result);

if ($pun_user['show_avatars'] != '0')
        {
        $avatars_dir="punbb/img/avatars/";//avatars are located here
        
            if ($img_size = @getimagesize($avatars_dir.'/'.$data['id'].'.gif'))
                $user_avatar = '<img src="'.$avatars_dir.'/'.$data['id'].'.gif" '.$img_size[3].' alt="" />';
            else if ($img_size = @getimagesize($avatars_dir.'/'.$data['id'].'.jpg'))
                $user_avatar = '<img src="'.$avatars_dir.'/'.$data['id'].'.jpg" '.$img_size[3].' alt="" />';
            else if ($img_size = @getimagesize($avatars_dir.'/'.$data['id'].'.png'))
                $user_avatar = '<img src="'.$avatars_dir.'/'.$data['id'].'.png" '.$img_size[3].' alt="" />';
        }
        else
            $user_avatar = '';

echo $user_avatar . "<br />";
echo 'Welcome to ----, <strong>'. $data['username'] . '</strong>.<br />';
echo "Last visit: " . date('M j, Y h:i:s a' , $data['last_visit']) . "<br />";
}
else
{// show login forum
    echo "Welcome to ----, Guest.";
?>


<!--update urls-->
<form id="login" method="post" action="/punbb/login.php?action=in" onsubmit="return process_form(this)">
<input type="hidden" name="form_sent" value="1" />
<input type="hidden" name="redirect_url" value="<?php echo $_SERVER['SCRIPT_NAME'] ?>" /><!-- remove that if you dont want redirect to this same page, it will go to forum index instead-->
<label class="conl"><strong>Username</strong><br /><input type="text" name="req_username" size="25" maxlength="25" tabindex="1" /><br /></label>
<label class="conl"><strong>Password</strong><br /><input type="password" name="req_password" size="16" maxlength="16" tabindex="2" /><br /></label>
<p class="clearb">If you have not registered or have forgotten your password click on the appropriate link below.</p>
<p><a href="/punbb/register.php" tabindex="4">Not registered yet?</a>  
<a href="/punbb/login.php?action=forget" tabindex="5">Forgotten your password?</a></p>
<p><input type="submit" name="login" value="Login" tabindex="3" /></p>
</form>
<?php
}
?>

<p>
Forum Search - <a href="http://FORUMS.YOURSITE.COM/search.php">more options</a><br />
<form id="search" method="get" action="FORUMS.YOURSITE.COM/search.php">
<input type="hidden" name="action" value="search" />
<input id="author" type="hidden" name="author" size="25" maxlength="25" value="" />
<input type="hidden" class="conl" value="-1" />
<input type="hidden" id="search_in" name="search_in" value="all" />
<input type="hidden" name="sort_by" value="0" />
<input type="hidden" name="sort_dir" value="DESC" />
<input type="hidden" name="show_as" value="topics" />
<label class="conl">Search<br /><input type="text" name="keywords" size="40" maxlength="100" /></label>
<input type="submit" name="search" value="Submit" accesskey="s" />
</form>
</p>

//random profile
$result = $db->query('SELECT id, username, num_posts, registered, location FROM '.$db->prefix.'users AS r1 JOIN (SELECT ROUND(RAND() * (SELECT MAX(id) FROM users)) AS id) AS r2 WHERE r1.id >= r2.id ORDER BY r1.id ASC LIMIT 1')
 or error('Unable to fetch user data', __FILE__, __LINE__, $db->error());
while ($data = $db->fetch_assoc($result))
{
echo "\t\t\t\t\t\t".'<a href="http://mysite.com/profile.php?id='.$data['id'].'">'.pun_htmlspecialchars($data['username']).'</a><br />Total Posts: '.$data['num_posts']."<br />Member since:".$data['registered']."<br />Location:".$data['location']."<br />\n";
}