📄 root_board.php
字号:
<?
//////////////////////////////////ready
include "connect.php";
include "lib.php";
include "header.inc";
//////////////////////////////////check
chk_level(1,0,"login.php?go=root.php");
chk_memo();
//////////////////////////////////to take out table
$tables=list_bd();
$total=count($tables);
//////////////////////////////////board num per page
if($page){chk_num($page,0,"${error}必须输入数字",0);}
else{$page=10;}
//////////////////////////////////list num
$pageviewsu=10;
//////////////////////////////////index setting
$pagesu=ceil($total/$page);
$start=($page*$pagenum);
$no=$total-$start;
$pagegroup=ceil(($pagenum+1)/$pageviewsu);
$pagestart=($pageviewsu*($pagegroup-1))+1;
$pageend=$pagestart+$pageviewsu-1;
$nowpage=$pagenum+1;
?>
<script language=javascript>
function chk_drop(){
if(!confirm('<?=$warning?>删除所有表格、系统配置、上传的文件和论坛等。\n\n数据一旦删除将不能恢复! 是否继续进行?')){return false;}
}
function chk_del(){
if(!confirm('<?=$warning?>删除所有上传的文件和论坛内的文章。\n但不会删除论坛的系统配置\n\n是否继续进行?')){return false;}
}
function chk_new(){
if(!chk.new_board.value){alert('<?=$error?>请输入新讨论区的名称');chk.new_board.focus();return false;}
}
</script>
<link rel=StyleSheet HREF=style.css type=text/css title=style>
<table width=100% height=100%><tr><td valign=top><br><br>
<table align=center width=450 cellpadding=2 cellspacing=0 border=0 bgcolor=#F1F9FD>
<tr><td colspan=2 bgcolor=white><img src=image/logo.gif><br><br></td></tr>
<tr><td colspan=2 bgcolor=white>
<table width=100% cellpadding=0 cellspacing=0>
<tr>
<td><font color=#008CD6 size=3><b> <a href=root.php>管理主页面</a>>讨论区管理</b></font></td>
<td align=right><?=$logout?> <?=$help?> <?=$memo_list?></td>
</tr></table>
</td></tr>
<tr><td colspan=2 height=3 bgcolor=#2CBBFF></td></tr>
<tr><td colspan=2 height=5></td></tr>
<tr><td colspan=2>
<table align=center width=98% cellpadding=0 cellspacing=0 border=0>
<form method=post action=root_board.php>
<tr>
<td><font size=2> 总计:<b><?=$total?></b>个讨论区, 共分:<b><?=$nowpage?></b> 版块 <b><?=$pagesu?></b> 页</font></td>
<td align=right>View <input type=text size=3 class=input maxlength=3 name=page value=<?=$page?>> <input type=submit class=button value=讨论区></td>
</tr>
</form>
</table>
<table align=center width=98% cellpadding=2 cellspacing=0 border=1 bordercolor=white>
<form method=post action=root_board_ing.php name=chk onsubmit="return chk_new()">
<tr bgcolor=#C9F0FF>
<td width=1% nowrap align=center>No.</td>
<td width=91% align=center>讨论区名称</td>
<td width=1% nowrap align=center>配置</td>
<td width=1% nowrap align=center>删除</td>
<td width=1% nowrap align=center>清空</td>
<td width=1% nowrap align=center>文章数</td>
<td width=1% nowrap align=center>附件数</td>
<td width=1% nowrap align=center>评论数</td>
</tr>
<?
//////////////////////////////////Variable that is passed
$send="&page=$page&";
//////////////////////////////////output value
for($i=$start;$i<$start+$page;$i++)
{
if(!$tables[$i]){break;}
//////////////////////////////////3.1.5->3.1.6 update
$query="alter table ${board_table}${board_name} change title title varchar(250)";
@mysql_query($query,$connect);
$edit="<a href=member_edit.php?id=$data[id]&pagenum=$pagenum${send}>编辑</a>";
$del="<a href=root_member_ing.php?mode=1&id=$data[id]&pagenum=$pagenum${send} onclick=\"if(confirm('${warning}want to delete selected member?'))return true;else return false;\">Del</a>";
$board_name=str_replace("$board_table","",$tables[$i]);
$this_board=bd($board_name);
$article=total("$this_board[board]","");
$comment=total("$this_board[com]","");
$attach=total("$this_board[board]","and attach_name<>''");
$attach2=total("$this_board[board]","and attach2_name<>''");
$attach=$attach+$attach2;
//////////////////////////////////output
echo"
<tr bgcolor=white>
<td width=1% nowrap align=center>$no</td>
<td width=91%><a href=naboard.php?bd=$board_name target=_blank>$board_name</a></td>
<td width=1% nowrap align=center><a href='admin_board.php?bd=$board_name' target=_blank>配置</a></td>
<td width=1% nowrap align=center><a href=root_board_ing.php?bd=$board_name&mode=drop onclick=\"return chk_drop()\">删除</a></td>
<td width=1% nowrap align=center><a href=root_board_ing.php?bd=$board_name&mode=del onclick=\"return chk_del()\">清空</a></td>
<td width=1% nowrap align=right>$article</td>
<td width=1% nowrap align=right>$attach</td>
<td width=1% nowrap align=right>$comment</td>
</tr>
";
//////////////////////////////////-0-
$no--;
}
//////////////////////////////////total num
echo"<input type=hidden name=count value=$i>";
?>
</table>
</td></tr>
<tr><td colspan=2 align=center><?index()?>
</td></tr>
<tr><td colspan=2 height=5></td></tr>
<tr><td colspan=2>
<table align=center width=98% cellpadding=2 cellspacing=0 border=0 bordercolor=white bgcolor=#C9F0FF>
<tr>
<td>
<input type=hidden name=pagenum value=<?=$pagenum?>>
<select name=copy><option value=''></option>
<?
for($i=0;$i<$total;$i++){
$board_name=str_replace("$board_table","",$tables[$i]);
echo"<option value='$board_name'>$board_name</option>";
}
?>
</select>是已经建立的讨论区。 <br><input type=input class=input name=new_board size=20 value='<?=$word?>' onclick=select()> <input type=submit value="创建新讨论区" class=button>
</td></tr></table>
</td></tr></form>
<tr><td colspan=2 height=3 bgcolor=#2CBBFF></td></tr>
<tr><td bgcolor=white><a href=root_board.php>列表</a></td><td bgcolor=white><?=$copyright?></td></tr>
</table>
</td></tr></table>
<?mysql_close($connect);?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -