query("SELECT sid,sort1 AS sort,orderid FROM {$dbprefix}sort WHERE grade=1 ORDER BY orderid asc"); $i=0; while($row=$dblink->fetch_array($query)) { ?> [] [] []

query("SELECT sid,sort1 AS sort,orderid FROM {$dbprefix}sort WHERE sid=$sid"); $sort_row=$dblink->fetch_array($query); $query=$dblink->query("SELECT sid,sort2 AS sort,orderid FROM {$dbprefix}sort WHERE grade=2 AND sid1=$sid ORDER BY orderid asc"); ?>

fetch_array($query)) { ?>     [] [] [] []

query("SELECT sid,sid1,sort2 AS sort,orderid FROM {$dbprefix}sort WHERE sid='$_GET[sid]'"); $sort_row=$dblink->fetch_array($query); $query=$dblink->query("SELECT sid,sort3 AS sort,orderid FROM {$dbprefix}sort WHERE grade='3' AND sid2='$_GET[sid]' ORDER BY orderid asc"); ?>

fetch_array($query)) { ?>     [] [] []

query("SELECT * FROM {$dbprefix}sort WHERE sid=$sid"); $sort_row=$dblink->fetch_array($query); if($sort_row['grade']==1) { $sort_path=$sort_row['sort1'].'  ['.$lang['ques_back_upper'].']'; $sort_sid=intval($sort_row['sid']); $query=$dblink->query("SELECT count(*) FROM {$dbprefix}ques WHERE sid1=$sort_sid"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE sid1=$sort_sid ORDER BY asktime desc limit $start,$pagerow"); } elseif($sort_row['grade']==2) { $sort_path=$sort_row['sort1'].' -> '.$sort_row['sort2'].'  ['.$lang['ques_back_upper'].']'; $sort_sid=intval($sort_row['sid']); $query=$dblink->query("SELECT count(*) FROM {$dbprefix}ques WHERE sid2=$sort_sid"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE sid2=$sort_sid ORDER BY asktime desc limit $start,$pagerow"); } elseif($sort_row['grade']==3) { $sort_path=$sort_row['sort1'].' -> '.$sort_row['sort2'].' -> '.$sort_row[sort3].'  ['.$lang['ques_back_upper'].']'; $sort_sid=intval($sort_row['sid']); $query=$dblink->query("SELECT count(*) FROM {$dbprefix}ques WHERE sid3=$sort_sid"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE sid3=$sort_sid ORDER BY asktime desc limit $start,$pagerow"); } else { exit("ques_grade error"); } admin_header(); ?>

fetch_array($query)) { $stitle=cut_str($row['title'],54); $introtag = $row['introtime'] ? ''.$lang['ques_intro'].'' : $lang['ques_nointro']; ?>   / 1) { $start = floor($page/10)*10; $end = $start+9; if($start<1) { $start=1; } if($end>$pagecount) { $end=$pagecount; } for($i=$start; $i<=$end; $i++) { if($page==$i) { echo ' '.$i.''; } else { echo ' ['.$i.']'; } } } ?>

query("SELECT count(*) FROM {$dbprefix}ques WHERE status=1"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE status='1' ORDER BY asktime desc limit $start,$pagerow"); admin_header(); ?>

() fetch_array($query)) { $stitle=cut_str($row['title'],54); $introtag = $row['introtime'] ? ''.$lang['ques_introed'].'' :$lang['ques_unintroed']; ?>   / 1) { $start = floor($page/10)*10; $end = $start+9; if($start<1) { $start=1; } if($end>$pagecount) { $end=$pagecount; } for($i=$start; $i<=$end; $i++) { if($page==$i) { echo ' '.$i.''; } else { echo ' ['.$i.']'; } } } ?>

query("SELECT count(*) FROM {$dbprefix}ques WHERE status=2"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE status=2 ORDER BY asktime desc limit $start,$pagerow"); admin_header(); ?>

() fetch_array($query)) { $stitle=cut_str($row['title'],54); $introtag = $row['introtime'] ? ''.$lang['ques_introed'].'' : $lang['ques_unintroed']; ?>   / 1) { $start = floor($page/10)*10; $end = $start+9; if($start<1) { $start=1; } if($end>$pagecount) { $end=$pagecount; } for($i=$start; $i<=$end; $i++) { if($page==$i) { echo ' '.$i.''; } else { echo ' ['.$i.']'; } } } ?>

query("SELECT count(*) FROM {$dbprefix}ques WHERE status=3"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE status=3 ORDER BY asktime desc limit $start,$pagerow"); admin_header(); ?>

() fetch_array($query)) { $stitle=cut_str($row['title'],54); ?>   / 1) { $start = floor($page/10)*10; $end = $start+9; if($start<1) { $start=1; } if($end>$pagecount) { $end=$pagecount; } for($i=$start; $i<=$end; $i++) { if($page==$i) { echo ' '.$i.''; } else { echo ' ['.$i.']'; } } } ?>

query("SELECT count(*) FROM {$dbprefix}ques WHERE introtime !=0"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE introtime !=0 ORDER BY introtime desc limit $start,$pagerow"); admin_header(); ?>

() fetch_array($query)) { $stitle=cut_str($row['title'],54); ?>   / 1) { $start = floor($page/10)*10; $end = $start+9; if($start<1) { $start=1; } if($end>$pagecount) { $end=$pagecount; } for($i=$start; $i<=$end; $i++) { if($page==$i) { echo ' '.$i.''; } else { echo ' ['.$i.']'; } } } ?>

query("SELECT count(*) FROM {$dbprefix}ques WHERE status=4"); $qcount=$dblink->result($query,0); $pagecount=ceil($qcount/$pagerow); if ($page>$pagecount) $page=1; $start=($page-1)*$pagerow; $query=$dblink->query("SELECT * FROM {$dbprefix}ques WHERE status=4 ORDER BY asktime desc limit $start,$pagerow"); admin_header(); ?>

() fetch_array($query)) { $stitle=cut_str($row['title'],60); ?>   / 1) { $start = floor($page/10)*10; $end = $start+9; if($start<1) { $start=1; } if($end>$pagecount) { $end=$pagecount; } for($i=$start; $i<=$end; $i++) { if($page==$i) { echo ' '.$i.''; } else { echo ' ['.$i.']'; } } } ?>

query("UPDATE {$dbprefix}ques SET title='$title',content='$content' where qid=$qid"); header("location:admin.php?admin_action=$backaction&sid=$sid&page=$page"); } else { $qid=intval($_GET['qid']); $query=$dblink->query("SELECT qid,title,content FROM {$dbprefix}ques WHERE qid=$qid"); $row=$dblink->fetch_array($query); $row['content']=filters_outcontent($row['content']); $row['content']=htmlspecialchars($row['content']); admin_header(); ?>

: :

query("SELECT introtime FROM {$dbprefix}ques where qid=$qid"); $introtime=$dblink->result($query,0); $introtime = $introtime ? 0 : time(); $dblink->query("UPDATE {$dbprefix}ques SET introtime='$introtime' where qid=$qid"); header("location:admin.php?admin_action=$backaction&sid=$sid&page=$page"); } elseif($admin_action=='ques_del') { $grade=intval($_GET['grade']); $sid=intval($_GET['sid']); $page=intval($_GET['page']); if($grade) { $query=$dblink->query("SELECT * FROM {$dbprefix}sort WHERE sid=$sid"); $row=$dblink->fetch_array($query); switch($grade) { case 1: $dblink->query("DELETE FROM {$dbprefix}ques where sid1=$sid"); break; case 2: $dblink->query("DELETE FROM {$dbprefix}ques where sid2=$sid"); $sid=$row['sid1']; break; case 3: $dblink->query("DELETE FROM {$dbprefix}ques where sid3=$sid"); $sid=$row['sid2']; break; } header("location:admin.php?admin_action=ques_sort&grade=$grade&sid=$sid&page=$page"); } else { $ctype=intval($_GET['ctype']); if($ctype==1) { //$dblink->query("DELETE FROM {$dbprefix}ques where qid=$qid"); } else { $qid=intval($_GET['qid']); $dblink->query("DELETE FROM {$dbprefix}ques where qid=$qid"); } header("location:admin.php?admin_action=$backaction&sid=$sid&page=$page"); } } else { echo 'ques_manage error'; } ?>