|
|
An Error Occured Could not connect to the Posts database. $sql");
$myrow = mysql_fetch_array($result);
$row_color = $color2;
$count = 0;
do {
if(!($count % 2))
$row_color = $color2;
else
$row_color = $color1;
echo "\n";
if($myrow[poster_id] != -1) {
$posterdata = get_userdata_from_id($myrow[poster_id], $db);
}
else
$posterdata = array("user_id" => -1, "username" => $l_anonymous, "user_posts" => "0", "user_rank" => -1);
echo "$posterdata[username]";
$posts = $posterdata[user_posts];
if($posterdata[user_id] != -1) {
if($posterdata[user_rank] != 0)
$sql = "SELECT rank_title, rank_image FROM ranks WHERE rank_id = '$posterdata[user_rank]'";
else
$sql = "SELECT rank_title, rank_image FROM ranks WHERE rank_min <= " . $posterdata[user_posts] . " AND rank_max >= " . $posterdata[user_posts] . " AND rank_special = 0";
if(!$rank_result = mysql_query($sql, $db))
error_die("Error connecting to the database!");
list($rank, $rank_image) = mysql_fetch_array($rank_result);
echo " " . own_stripslashes($rank) . "";
if($rank_image != '')
echo " ";
echo "
$l_joined: $posterdata[user_regdate]";
echo " $l_posts: $posts";
if ($posterdata[user_from] != ''){
echo " $l_location: $posterdata[user_from] ";
}
echo " | ";
}
else {
echo " $l_unregistered";
}
echo "$l_posted: $myrow[post_time]  ";
echo " \n";
$message = own_stripslashes($myrow[post_text]);
// Before we insert the sig, we have to strip its HTML if HTML is disabled by the admin.
// We do this _before_ bbencode(), otherwise we'd kill the bbcode's html.
$sig = $posterdata[user_sig];
if (!$allow_html)
{
$sig = htmlspecialchars($sig);
$sig = preg_replace("#<br>#is", " ", $sig);
}
$message = eregi_replace("\[addsig]$", " _________________ " . own_stripslashes(bbencode($sig, $allow_html)), $message);
echo "\n" . $message . " ";
echo "\n ";
if ($posterdata[user_id] != -1)
{
echo "  \n";
if($posterdata["user_viewemail"] != 0)
echo " \n";
if($posterdata["user_website"] != '') {
if(strstr("http://", $posterdata["user_website"]))
$posterdata["user_website"] = "http://" . $posterdata["user_website"];
echo " \n";
}
if($posterdata["user_icq"] != '')
echo " ";
if($posterdata["user_aim"] != '')
echo " ";
if($posterdata["user_yim"] != '')
echo " ";
if($posterdata["user_msnm"] != '')
echo " ";
echo " \n";
}
else
{
echo "  \n";
}
echo " \n";
echo " \n";
if(is_moderator($forum, $userdata["user_id"], $db) || $userdata[user_level] > 2) {
echo " \n";
echo " \n";
}
echo " | ";
$count++;
} while($myrow = mysql_fetch_array($result));
$sql = "UPDATE topics SET topic_views = topic_views + 1 WHERE topic_id = '$topic'";
@mysql_query($sql, $db);
?>
|