Couldn't view the thread as it doesn't exist.
Click here to return to the board, or wait to get redirected.
$tblend
";
print $footer;
if($stamptime){printtimedif($startingtime);}
exit;
} else {
$thread=mysql_fetch_array(mysql_query("SELECT * FROM threads WHERE id=$id"));
$forumid=$thread[forum];
$forum=mysql_fetch_array(mysql_query("SELECT * FROM forums WHERE id=$forumid"));
if($tnext=mysql_result(mysql_query("SELECT min(lastpostdate) FROM threads WHERE forum=$forumid AND lastpostdate>$thread[lastpostdate]"),0,0))
$tnext=mysql_result(mysql_query("SELECT id FROM threads WHERE lastpostdate=$tnext"),0,0);
if($tprev=mysql_result(mysql_query("SELECT max(lastpostdate) FROM threads WHERE forum=$forumid AND lastpostdate<$thread[lastpostdate]"),0,0))
$tprev=mysql_result(mysql_query("SELECT id FROM threads WHERE lastpostdate=$tprev"),0,0);
if($tnext) $nextnewer="Next newer thread";
if($tprev) $nextolder="Next older thread";
if($nextnewer && $nextolder) $nextnewer.=' | ';
if(@mysql_fetch_array(mysql_query("SELECT * FROM favorites WHERE user=$loguserid AND thread=$id")))
$favlink="Remove from favorites";
else $favlink="Add to favorites";
$favlink .= " | "RSS" Feed";
if($nextnewer or $nextolder) $favlink.=' | ';
mysql_query("UPDATE threads SET views=views+1 WHERE id=$id");
$thread[title]=str_replace("<","<",$thread[title]);
$restricted = false;
if($forum[minpower]>$power and $forum[minpower]>0) { $thread[title]="(restricted)"; $restricted = true; }
$forumtitle="$forum[title]: ";
if($pl) { // special case for permalinks
$pl = (int)$pl;
if(!$ppp) $ppp=($log?$loguser[postsperpage]:20);
// map all posts to a "page number" in an array
$posts2=mysql_query("SELECT p.id pid FROM posts p WHERE p.thread=$id ORDER BY p.id DESC");
while($po=mysql_fetch_array($posts2)) { $postids[] = $po[pid]; }
sort($postids);$d=0;$p=0;
foreach ($postids as $anid) {
$postidisonpage['p'.$anid] = $p; // "p" first to avoid catching numerical indexes
$d++; if ($d==$ppp) { $p++; $d=0; }
}
if (in_array('p'.$pl, array_keys($postidisonpage)) && !$restricted) {
$redir = "Location: thread.php?id=$id&ppp=$ppp&page=".$postidisonpage['p'.$pl]."#".$pl;
} else {
$redir = "Location: index.php";
}
//print $redir;
header($redir);
exit;
}
}
}elseif($user){
$usr=$user;
$tuser=mysql_fetch_array(mysql_query("SELECT name FROM users WHERE id=$usr"));
$thread[title]="Posts by $tuser[name]";
}elseif($search) $thread[title]="Search results";
$windowtitle="$boardname -- $forumtitle$thread[title]";
require_once 'lib/layout.php';
if($id) $fonline=fonlineusers($forumid);
if(@mysql_num_rows(mysql_query("SELECT user FROM forummods WHERE forum=$forumid and user=$loguserid"))) $ismod=1;
if(($id && $ismod && (!$thread[locked] || !$bconf[lockable])) || ($id && $isadmin)){
$trashid=20;
if($qmod){
$verb='editing';
mysql_query("INSERT INTO actionlog (atime, adesc, aip) VALUES (".ctime().", \"User ".$loguserid." edited thread $id\", \"$userip\")");
if($st!='') mysql_query("UPDATE threads SET sticky=$st WHERE id=$id");
if($cl!='') mysql_query("UPDATE threads SET closed=$cl WHERE id=$id");
if($lo!='' && $isadmin) { mysql_query("UPDATE threads SET locked=$lo WHERE id=$id"); mysql_query("INSERT INTO actionlog (atime, adesc, aip) VALUES (".ctime().", \"User ".$loguserid." ".($lo!=1?"un":"")."locked thread $id\", \"$userip\")"); }
if($trash){
mysql_query("INSERT INTO actionlog (atime, adesc, aip) VALUES (".ctime().", \"User ".$loguserid." trashed thread $id\", \"$userip\")");
mysql_query("UPDATE threads SET sticky=0,closed=1,forum=$trashid WHERE id=$id");
$numposts=$thread[replies]+1;
$t1=mysql_fetch_array(mysql_query("SELECT lastpostdate,lastposter FROM threads WHERE forum=$forumid ORDER BY lastpostdate DESC LIMIT 1"));
$t2=mysql_fetch_array(mysql_query("SELECT lastpostdate,lastposter FROM threads WHERE forum=$trashid ORDER BY lastpostdate DESC LIMIT 1"));
mysql_query("UPDATE forums SET numposts=numposts-$numposts,numthreads=numthreads-1,lastpostdate=$t1[lastpostdate],lastpostuser=$t1[lastposter] WHERE id=$forumid");
mysql_query("UPDATE forums SET numposts=numposts+$numposts,numthreads=numthreads+1,lastpostdate=$t2[lastpostdate],lastpostuser=$t2[lastposter] WHERE id=$trashid");
$verb='trashing';
}
print "
$header$tblstart
$tccell1>Thank you, $loguser[name], for $verb this thread. ".
redirect("forum.php?id=$forumid",'return to the forum',0)."
$tblend$footer
";
if($stamptime){printtimedif($startingtime);}
exit;
}else{
$fulledit="Edit thread";
$link="Delete";
if ($lock != "") { $lock = " | $lock"; }
$modfeats="
$tccellcls colspan=2>Moderating options: $stick | $close$lock$trash -- $fulledit";
}
}
if($thread[poll]){
$poll=mysql_fetch_array(mysql_query("SELECT * FROM poll WHERE id=$thread[poll]"));
$voted=@mysql_result(mysql_query("SELECT count(*) FROM pollvotes WHERE poll=$poll[id] AND user=$loguserid"),0,0);
if($action=='vote' and $loguserid and (!$voted or $poll[doublevote]) and !$poll[closed] and ($power>=$forum[minpower])){
mysql_query("INSERT INTO pollvotes (poll,choice,user) VALUES ($poll[id],$choice,$loguserid)");
$voted++;
}
$tvotes=mysql_result(mysql_query("SELECT count(*) FROM pollvotes WHERE poll=$poll[id]"),0,0);
if(!$tvotes) $tvotes=1;
$pollcs=mysql_query("SELECT * FROM poll_choices WHERE poll=$poll[id]");
$votedfor = array();
while($pollc=mysql_fetch_array($pollcs)){
$votes=mysql_result(mysql_query("SELECT count(*) FROM pollvotes WHERE choice=$pollc[id]"),0,0);
if ($loguserid) {
$chvq = "SELECT user FROM pollvotes WHERE poll=".$poll['id']." AND choice=".$pollc['id']." AND user=".$loguserid;
if (mysql_num_rows(mysql_query($chvq))>0) $votedfor[$pollc['id']] = 1;
// print $chvq;
}
$pct=sprintf('%02.1f',$votes/$tvotes*100);
$barpart="
";
if(!$votes) $barpart=' ';
$s=($votes>1?'s':'');
$link='';
if($loguserid and (!$voted or $poll[doublevote]) and !$poll[closed]) { if (!($poll[doublevote] and $votedfor[$pollc['id']])) { $link=""; } }
$choices.="
$tccell1l width=20%>$link$pollc[choice]
$tccell2l width=60%>$barpart
$tccell1 width=20%>$pct%, $votes vote$s
")."$choices
$tccell2l colspan=3>$smallfont Multi-voting ".($poll[closed]?"was":"is")." $mlt.".($poll[closed]?" This poll is closed.":"")."$polledit
$tblend $tblstart
";
}
loadtlayout();
if($loguser[viewsig]==0) $sfields='';
if($loguser[viewsig]==1) $sfields=',headtext,signtext';
if($loguser[viewsig]==2) $sfields=',u.postheader headtext,u.signature signtext';
$ufields=userfields();
$activity=mysql_query("SELECT user, count(*) num FROM posts WHERE date>".(ctime()-86400)." GROUP BY user");
while($n=mysql_fetch_array($activity)) $act[$n[user]]=$n[num];
$postlist="
$polltbl
$modfeats
$tccellh width=150>User
$tccellh>Post
";
if(!$ppp) $ppp=($log?$loguser[postsperpage]:20);
if($id && $power<$forum[minpower]){
print "
$header$tblstart
$tccell1>Couldn't enter the forum. Either you don't have access to this restricted forum, or you are not logged in.
Click here to return to the board, or wait to get redirected.
$tblend
";
}else{
$min=$ppp*$page;
if($id)
$posts=mysql_query("SELECT p.*,text$sfields,edited,tagval,u.id uid,name,$ufields,regdate FROM posts p,posts_text LEFT JOIN users u ON p.user=u.id WHERE thread=$id AND p.id=pid ORDER BY p.id LIMIT $min,$ppp");
elseif($usr){
$thread[replies]=mysql_result(mysql_query("SELECT count(*) FROM posts WHERE user=$usr"),0,0)-1;
$posts=mysql_query("SELECT p.*,text$sfields,edited,tagval,u.id uid,name,$ufields,regdate FROM posts p,posts_text LEFT JOIN users u ON p.user=u.id WHERE user=$usr AND p.id=pid ORDER BY p.id LIMIT $min,$ppp");
}elseif($search){
if($loguser[powerlevel]>=$bconf[searchfunction]){
if($quser){
$user=mysql_fetch_array(mysql_query("SELECT id FROM users WHERE name='".addslashes($quser)."'"));
$u=$user[id];
$srch.=($srch?"AND ":"")."posts.user=$u";
}
if($qip) $srch.=($srch?" AND ":"")."ip LIKE '$qip'";
if($qmsg) $srch.=($srch?" AND ":"")."text LIKE '%".addslashes($qmsg)."%'";
if($dopt==1) $srch.=($srch?" AND ":"")."date>".(ctime()-86400*$datedays);
if($dopt==2){
$date1=mktime(0,0,0,$d1m,$d1d,$d1y);
$date2=mktime(0,0,0,$d2m,$d2d,$d2y)+86400;
$srch.=($srch?" AND ":"")."date>$date1 AND date<$date2";
}
if($pord) $order=" ORDER BY id".($pord==2?" DESC":"");
if(!$fsch){
$posts=mysql_query("SELECT id,user,date,thread,ip,text,num$signquery,edited FROM posts,posts_text WHERE $srch AND id=pid $order LIMIT $min,$ppp");
$thread[replies]=mysql_result(mysql_query("SELECT COUNT(*) FROM posts,posts_text WHERE $srch AND id=pid"),0,0);
}else{
$posts=mysql_query("SELECT posts.id,posts.user,date,thread,ip,text,num$signquery,edited FROM posts,posts_text,threads WHERE $srch AND thread=threads.id AND forum=$fid AND id=pid $order LIMIT $min,$ppp");
$thread[replies]=mysql_result(mysql_query("SELECT COUNT(*) FROM posts,posts_text,threads WHERE $srch AND thread=threads.id AND forum=$fid AND id=pid"),0,0);
}
$quser=str_replace(" ","+",$quser);
$qip=str_replace(" ","+",$qip);
$qmsg=str_replace(" ","+",$qmsg);
}
else{
print "
$tccell1 Couldn't access search. You do not have sufficient rights to access search.
".redirect("index.php",'return to the main page',0);
}
}
for($i=0;$post=mysql_fetch_array($posts);$i++){
$bg=$i%2+1;
$postlist.='
';
$quote='Link';
$edit='';
if($id and !$thread[closed]) $quote.=" | Quote";
$deletelink="Delete";
if(($ismod or $post[user]==$loguserid) and !$thread[closed]) $edit=($quote?' | ':'')."Edit".(($i==0&&!$ismod&&$page==0)?"":" | $deletelink");
if($isadmin) $ip=(($edit||strpos($quote," | ") == false)?' | ':'')."IP: $post[ip] (SS | Arin)";
if(!$id){
$pthread=mysql_fetch_array(mysql_query("SELECT id,title,forum FROM threads WHERE id=$post[thread]"));
$pforum=@mysql_fetch_array(mysql_query("SELECT minpower FROM forums WHERE id=$pthread[forum]"));
}
$post[act]=$act[$post[user]];
if($pforum[minpower]<=$power or !$pforum[minpower]) $postlist.=threadpost($post,$bg,$pthread);
else $postlist.="$tccellc colspan=2>$fonttag (restricted)";
}
$query=preg_replace("'page=([0-9].*)'si",'','?'.getenv("QUERY_STRING"));
if($query AND substr($query,-1)!="&") $query.="&";
if(!$page) $page=0;
$pagelinks="Pages:";
for($i=0;$i<(($thread[replies]+1)/$ppp);$i++){
if($i==$page) $pagelinks.=" ".($i+1);
else $pagelinks.=" ".($i+1)."";
}
if($thread[replies]<$ppp) $pagelinks='';
$header = str_replace("", "", $header);
print
$header.sizelimitjs()."
$tblstart$tccell1s>$fonline$tblend