| $author
|
Thread: $posttitle
$multipage |
";
if ($view != "true") {
echo $denied;
}
if ($view == "true") {
$sql = "SELECT *, p.username AS poster FROM post p, members m WHERE (p.username=m.username OR p.username = 'Anonymous') AND TID='$TID' GROUP BY p.pagetext ORDER BY PID LIMIT $start_limit, $GLOBALS[topicsper]";
$query_thread = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$editthread = "1";
while ($post = mysql_fetch_array($query_thread)) {
$postreplydate=date("F d, Y",$post[dateline]+($timeoffset*3600));
$postreplytime=date("h:i A",$post[dateline]+($timeoffset*3600));
$pagetext=censor(bbcodeparse($post[pagetext]));
$lastpost = $post[lastpost];
$sql = "select signature from post where pid=$post[PID]";
$query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$psig = mysql_fetch_array($query);
if ($psig[signature] == 1) {
$postsig = "$post[signature]";
$censoredsig = censor(bbcodeparse($postsig));
}
$UserName=$post[poster];
$edited = $post[edited];
$postt = htmlspecialchars($post[title]);
if($post[title] != "") $pagetext="$postt
$pagetext";
if ($bg_color == $col1_bg) {
$bg_color=$col2_bg;
} else {
$bg_color=$col1_bg;
}
if ($post[icon] == '') { $post[icon] = 'blank.gif'; }
$icon = "![](\"images/icons/$post[icon]\") ";
if($post[dateline]>$lastvisit) {
$foldericon="![](\"images/posticonnew.gif\") ";
} else {
$foldericon="![](\"images/posticon.gif\") ";
}
if ($post[status] == "Administrator") {
$stars = "![](\"images/star.gif\") ";
} elseif ($post[status] == "Moderator") {
$stars = "";
} elseif ($post[status] == "Needs a Job") {
$stars = "";
} elseif ($post[status] == "No Life") {
$stars = "";
} elseif ($post[status] == "Senior Member") {
$stars = "";
} elseif ($post[status] == "Member") {
$stars = "";
} elseif ($post[status] == "Fast Newbie") {
$stars = "";
} elseif ($post[status] == "Cool Newbie") {
$stars = "";
} elseif ($post[status] == "Newbie") {
$stars = "";
} else {
$stars = "";
}
if($post[cus_status] == "") {
$post[cus_status] = "";
} else {
$post[cus_status] = "$post[cus_status]
";
}
if($UserName == "Anonymous") {
$avatar = "";
$stars = "";
$post[cus_status] = "";
$post[status] = "";
$posts = "";
} else {
$posts = "Posts: $post[post_num]";
$avatar = "![](\"$post[avatar]\") ";
}
if ($showgender) {
if ($post[sex] == 0) {
$gender = " ![\"$UserName](\"images/male.gif\") ";
} else {
$gender = " ![\"$UserName](\"images/female.gif\") ";
}
} else { $gender = ''; }
$view_profile = "![](\"images/profile.gif\") ";
$email_user = "![](\"images/email.gif\") ";
if ($pms == 1)
$send_pm = "![](\"images/pm.gif\") ";
else
$send_pm = '';
$edit_post = "![](\"images/edit.gif\") ";
$editthread="";
$reply_w_quote = "![](\"images/quote.gif\") ";
$post_line = $post[post_line];
$ip = "![\"View](\"images/ip.gif\") ";
if (($psig[signature] == 1) && ($censoredsig != "")){
$pagetext = "$pagetext \n
____________
\n$censoredsig";
}
// Checks if post is a poll
if ($post[type] == "poll")
{
$sql = "SELECT pollid FROM plog WHERE username='$username' AND pollid='$TID'";
$query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
if (($action == "showpoll") || ($username == "") || (($plog_info = mysql_fetch_array($query)) && ($plog_info[pollid] == $TID)))
{
$pagetext = "Poll Question:
$pagetext
Poll Results:
\n";
$sql = "SELECT sum(votes) FROM polls WHERE pollid='$TID'";
$query = mysql_db_query($database, $sql);
$total = mysql_fetch_row($query);
$sql = "SELECT * FROM polls WHERE pollid='$TID'";
$query = mysql_db_query($database, $sql);
while ($resp = mysql_fetch_array($query))
{
$votes = $resp[votes];
if ($total[0] == 0)
{
$total[0] = 1;
}
$per = round(100 * ($votes / $total[0]));
$width = $per * $mult;
$pagetext .= "\n";
$pagetext .= "![](\"images/bar.gif\") $resp[votes] votes ($per%)
\n";
$pagetext .= "$resp[response]
\n";
$pagetext .= "\n";
}
} else {
$sql = "SELECT * FROM polls WHERE pollid='$TID'";
$query = mysql_query($sql) or die(geterrdesc($sql));
$count_responses = mysql_num_rows($query);
if ($count_responses != 0)
{
$newpagetext = "";
}
$pagetext = "Poll Question:
$pagetext
\n" . $newpagetext;
}
}
$newline = template_cache("viewthread_box.html");
eval("echo stripslashes(\"$newline\");");
}
}
// Updates # of views
$sql = "UPDATE thread SET viewed_num=viewed_num+1 WHERE TID=$TID";
$query = mysql_query($sql) or die(geterrdesc($sql));
//Admin Options
$sql = "SELECT status FROM members WHERE username='$username'";
$member_query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$memberinfo = mysql_fetch_array($member_query);
$status = $memberinfo[status];
$admin_options = "";
$sql = "SELECT thread_lock FROM thread WHERE TID=$TID";
$query = mysql_db_query($database, $sql) or die(geterrdesc($sql));
$info = mysql_fetch_array($query);
if (($info[thread_lock] == 1) & ($status == "Administrator" || $status ==
"Moderator"))
{
$admin_options = "Open Thread |
Move Thread |
Delete
Thread";
}
if (($info[thread_lock] != 1) & ($status == "Administrator" || $status ==
"Moderator"))
{
$admin_options = "Close Thread |
Move Thread
| Delete Thread";
}
// Displays the list of forums available to "jump to" $jump = jump_to();
echo "
| $lang[timezone]
$multipage |
$next
$last
|
|
|
![\"Post](\"images/new_poll2.gif\")
![\"Post](\"images/new_topic2.gif\")
![\"Post](\"images/post_reply2.gif\")