 | 项目搜索 |
|
| |
|
|
代码片段库:
查看代码片段
浏览
| 提交新的代码片段
| 创建代码包
board.php
|
类型:
Full Script |
类别:
BBS Systems
|
许可证:
GNU Library Public License |
语言:
PHP
|
描述:
可换SKIN的BOARD中的主文件
|
该代码片段的版本系列:
| 片段ID |
下载版本 |
提交时间 |
提交人 |
删除 |
| 19 | 1.0 | 2002-02-25 16:03 | firefox |  |
点击"下载版本"来下载该代码片段.
最新版本的代码片段: 1.0
<?
require "lib.php";
require "include/list_check.php";
if(!$id) Error("连接格式错误.<br><br> board.php?id=编号","");
if(!$connect) $connect=dbConn();//数据库连接
$setup=get_table_attrib($id);
if(!$setup[name]) Error("连接错误或地址已更改.<br><br>请确认无误后从试或与管理员联系","");
$group=group_info($setup[group_no]);
$member=member_info();
if($member[is_admin]==1||($member[is_admin]==2&&$member[group_no]==$setup[group_no])||check_board_master($member, $setup[no])) $is_admin=1; else $is_admin="";
$avoid_ip=explode(",",$setup[avoid_ip]);
for($i=0;$i<count($avoid_ip);$i++)
{
if(!isblank($avoid_ip[$i])&&eregi($avoid_ip[$i],$REMOTE_ADDR)&&!$is_admin)
Error(" Access Denied ");
}
//
if($group[is_open]==0&&!$is_admin&&$member[group_no]!=$setup[group_no]) Error("此工作组下的所有论坛已被加密");
//
if($setup[grant_list]<$member[level]&&!$is_admin) Error("你的权限不足.","login.php?id=$id&page=$page&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&no=$no&s_url=".urlencode($REQUEST_URI));
if($is_admin) $setup[use_cart]=1; // 如果当前用户是管理员那么显示可选的框.
if(!$setup[use_category]) $category=""; // 如果不是用分类,那当前分类是空值.
if($setup[use_category]) // 使用分类
{
$result=mysql_query("select * from $t_category"."_$id order by no");
$a_category="<select name=category onchange=category_change()><option value=''>Category</option>";
while($data=mysql_fetch_array($result))
{
$category_num_c[]=$data[no];
$category_name_c[]=$data[name];
$category_n_c[]=$data[num];
$category_data[$data[no]]=$data[name];
if($category==$data[no]) $a_category.="<option value=$data[no] selected>$data[name]</option>";
else $a_category.="<option value=$data[no]>$data[name]</option>";
}
$a_category.="</select>";
}
if(!$browser) $a_category="Category";
$dir="skin/".$setup[skinname];
$keyword=stripslashes($keyword);
$keyword=eregi_replace("`","",$keyword);
$keyword=eregi_replace("\"","",$keyword);
$keyword=eregi_replace("'","",$keyword);
if(!$sn) $sn="off";
if(!$ss) $ss="off";
if(!$sc) $sc="off";
if($sc=="off"&&$sn=="off"&&$ss=="off") {$sc="on"; $ss="on";}
if(!isblank($keyword))
{
$keyword=addslashes($keyword);
if($sn=="on"&&$s_que) $s_que.=" or name like '%$keyword%' "; elseif($sn=="on") $s_que.=" name like '%$keyword%' ";
if($ss=="on"&&$s_que) $s_que.=" or subject like '%$keyword%' "; elseif($ss=="on") $s_que.=" subject like '%$keyword%' ";
if($sc=="on"&&$s_que) $s_que.=" or memo like '%$keyword%' "; elseif($sc=="on") $s_que.=" memo like '%$keyword%' ";
if($s_que) $s_que=" ( ".$s_que." ) ";
$keyword=stripslashes($keyword);
}
if(!$select_arrange) $select_arrange="headnum";
if(!$desc) $desc="asc";
if(!$setup[use_showreply]) if(!$s_que) $s_que=" arrangenum=0 "; else $s_que.=" and arrangenum=0 ";
if($category) if(!$s_que) $s_que=" category='$category' "; else $s_que.=" and category='$category'";
if($s_que) $s_que=" where ".$s_que;
if($s_que)
{
$temp=mysql_fetch_array(mysql_query("select count(*) from $t_board"."_$id $s_que",$connect));
$total=$temp[0];
}
else $total=$setup[total_article];
$page_num=$setup[memo_num];
if(!$page) $page=1;
$total_page=(int)(($total-1)/$page_num)+1;
if($page>$total_page) $page=$total_page;
$start_num=($page-1)*$page_num;
if($s_que)
{
if($select_arrange!="headnum") $s_que.=" and $select_arrange !='-1'";
else { $s_que.=" and headnum != 0 "; $add_on=", arrangenum "; }
$que="select * from $t_board"."_$id $s_que order by $select_arrange $desc $add_on limit $start_num, $page_num";
$result=mysql_query($que,$connect) or Error(mysql_error());
}
elseif($select_arrange=="headnum"&&$desc=="asc")
{
$division_result=mysql_query("select * from $t_division"."_$id where num>0 order by division desc");
$low_division=mysql_fetch_array(mysql_query("select min(division) from $t_division"."_$id where num>0"));
$total_division=mysql_num_rows($division_result);
$sum=0;
$division=0;
while($division_data=mysql_fetch_array($division_result))
{
$sum=$sum+$division_data[num];
if($sum>=$start_num)
{
$division=$division_data[division];
$start_num=$start_num-($sum-$division_data[num]);
$result1=mysql_query("select division,headnum,arrangenum from $t_board"."_$id where division='$division' order by headnum,arrangenum limit $start_num, $page_num") or error(mysql_error());
$check1=1;
}
if($check1 && $low_division[0]<$division)
{
if(mysql_num_rows($result1) < $page_num)
{
$division_data=mysql_fetch_array($division_result);
$division=$division_data[division];
$minus=$page_num-mysql_num_rows($result1);
$result2=mysql_query("select division,headnum,arrangenum from $t_board"."_$id where division=$division order by headnum,arrangenum limit $minus") or error(mysql_error());
$check2=1;
}
break;
}
}
$s_que2="";
if($check1)
{
while($data=mysql_fetch_array($result1))
{
if($s_que) $s_que.=" or (division='$data[division]' and headnum='$data[headnum]' and arrangenum='$data[arrangenum]') ";
else $s_que=" (division='$data[division]' and headnum='$data[headnum]' and arrangenum='$data[arrangenum]') ";
}
}
if($check2)
{
while($data=mysql_fetch_array($result2))
{
if($s_que) $s_que.=" or (division='$data[division]' and headnum='$data[headnum]' and arrangenum='$data[arrangenum]') ";
else $s_que=" (division='$data[division]' and headnum='$data[headnum]' and arrangenum='$data[arrangenum]') ";
}
}
if($s_que) $result=mysql_query("select * from $t_board"."_$id where $s_que order by headnum,arrangenum");
else $result=mysql_query("select * from $t_board"."_$id where no=-1");
}
else
{
if($select_arrange!="headnum") $s_que=" where $select_arrange !='-1'";
else { $s_que=" where headnum != '0' "; $add_on=", arrangenum "; }
$que="select headnum,arrangenum from $t_board"."_$id $s_que order by $select_arrange $desc $add_on limit $start_num, $page_num";
$result=mysql_query($que,$connect) or Error(mysql_error());
$s_que2="";
while($data=mysql_fetch_array($result))
{
if($s_que2) $s_que2.=" or ( "; else $s_que2.=" ( ";
$s_que2.=" headnum='$data[headnum]' and arrangenum='$data[arrangenum]' ";
$s_que2.=" ) ";
}
mysql_freeresult($result);
if($s_que2)$result=mysql_query("select * from $t_board"."_$id where $s_que2 order by $select_arrange $desc $add_on",$connect);
else $result=mysql_query("select * from $t_board"."_$id where headnum=1",$connect);
}
$href="id=$id&page=$page&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword";
$sort="&select_arrange=$select_arrange&desc=$desc";
if($no)
{
include "now_view1.php";
}
if($is_admin)
{
if($member[is_admin]==2) $temp_que=" and group_no='$member[group_no]' ";
$board_result=mysql_query("select no,name from $admin_table where no!='$setup[no]' $temp_que");
}
$temp=mysql_fetch_array(mysql_query("select count(*) from $now_table"));
$total_connect=$temp[0];
$temp=mysql_fetch_array(mysql_query("select count(*) from $now_table where group_no='$setup[group_no]'"));
$group_connect=$temp[0];
//////// MySQL关闭///////////////////////////////////////////////
if($connect) mysql_close($connect); $connect="";
$query_time=getmicrotime();
$print_page="";
$show_page_num=$setup[page_num];
$start_page=(int)(($page-1)/$show_page_num)*$show_page_num;
$i=1;
$a_1_prev_page= "<QQ ";
$a_1_next_page= "<QQ ";
$a_prev_page = "<QQ ";
$a_next_page = "<QQ ";
if($page>1) $a_1_prev_page="<a onfocus=blur() href='$PHP_SELF?id=$id&page=".($page-1)."&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'>";
if($page<$total_page) $a_1_next_page="<a onfocus=blur() href='$PHP_SELF?id=$id&page=".($page+1)."&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'>";
if($page>$show_page_num)
{
$prev_page=$start_page;
$a_prev_page="<a onfocus=blur() href='$PHP_SELF?id=$id&page=$prev_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'>";
$print_page.="<a onfocus=blur() href='$PHP_SELF?id=$id&page=1&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'><font style=font-size:8pt>[1]</a><font style=font-size:8pt>..";
}
while($i+$start_page<=$total_page&&$i<=$show_page_num)
{
$move_page=$i+$start_page;
if($page==$move_page) $print_page.=" <font style=font-size:8pt><b>$move_page</b> ";
else $print_page.="<a onfocus=blur() href='$PHP_SELF?id=$id&page=$move_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'><font style=font-size:8pt>[$move_page]</a>";
$i++;
}
if($total_page>$move_page)
{
$next_page=$move_page+1;
$a_next_page="<a onfocus=blur() href='$PHP_SELF?id=$id&page=$next_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'>";
$print_page.="<font style=font-size:8pt>..<a onfocus=blur() href='$PHP_SELF?id=$id&page=$total_page&select_arrange=$select_arrange&desc=$desc&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&page_num=$page_num'><font style=font-size:8pt>[$total_page]</a>";
}
$width=$setup[table_width];
if($setup[use_status]) $a_status="<a onfocus=blur() href=javascript:void(window.open('stat.php?id=$id','status','width=400,height=400,statusbar=no,toolbar=noresizable=no'))>"; else $a_status="<QQ ";
$a_status="<QQ ";
if(!$member[name]) $a_login="<a onfocus=blur() href='login.php?$href$sort&s_url=".urlencode($REQUEST_URI)."'>"; else $a_login="<QQ ";
if($member[name]) $a_logout="<a onfocus=blur() href='logout.php?$href$sort'>"; else $a_logout="<QQ ";
if($is_admin&&$member[is_admin]==1)
$a_setup="<a onfocus=blur() href='admin_setup.php?exec=view_board&no=$setup[no]&group_no=$setup[group_no]&exec2=modify' target=_blank>"; else $a_setup="<QQ ";
if($is_admin||$member[level]<=$setup[grant_write]) $a_write="<a onfocus=blur() href='write.php?$href$sort&no=$no&mode=write'>"; else $a_write="<QQ ";
if($is_admin||$member[level]<=$setup[grant_list]) $a_list="<a onfocus=blur() href='$PHP_SELF?id=$id&page=$page&page_num=$page_num&category=$category&sn=$sn&ss=$ss&sc=$sc&keyword=$keyword&prev_no=$no'>"; else $a_list="<QQ ";
$a_cancel="<a onfocus=blur() href='$PHP_SELF?id=$id'>";
if($is_admin) $a_delete_all="<a onfocus=blur() href='javascript:delete_all()'>"; else $a_delete_all="<QQ ";
if(!$member[no]&&$group[use_join]) $a_member_join="<a onfocus=blur() href='member_join.php?$href$sort'>"; else $a_member_join="<QQ ";
if($member[no]) $a_member_modify="<a onfocus=blur() href='member_modify.php?$href$sort'>"; else $a_member_modify="<QQ ";
if($member[no]) $a_member_memo="<a onfocus=blur() href=\"javascript:void(window.open('member_memo.php','member_memo','width=450,height=500,status=no,toolbar=no,resizable=yes,scrollbars=yes'))\">"; else $a_member_memo="<QQ ";
if($member[no])
{
if($member[new_memo])
{
$member_memo_icon="<img name=memozzz src=$dir/member_memo_on.gif border=0 align=absmiddle>";
$memo_on_sound="<object classid='clsid:D27CDB6E-AE6D-11cf-96B8-444553540000' codebase='http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=5,0,0,0' width='0' height='0'>
<param name=menu value=false>
<param name=wmode value=transparent>
<param name=movie value='$dir/memo_on.swf'>
<param name=quality value=low><param name='LOOP' value='false'>
<embed src='$dir/memo_on.swf' quality=low pluginspage='http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash' type='application/x-shockwave-flash' width='0' height='0' loop='false' wmode=transparent menu='false'>
</embed>
</object>";
}
else $member_memo_icon="<img src=$dir/member_memo_off.gif border=0 align=absmiddle>";
}
else $member_memo_icon="";
if($desc=="desc") $t_desc="asc"; else $t_desc="desc";
$a_no="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=headnum&desc=$t_desc'>";
$a_subject="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=subject&desc=$t_desc'>";
$a_name="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=name&desc=$t_desc'>";
$a_hit="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=hit&desc=$t_desc'>";
$a_vote="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=vote&desc=$t_desc'>";
$a_date="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=reg_date&desc=$t_desc'>";
$a_download1="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=download1&desc=$t_desc'>";
$a_download2="<a onfocus=blur() href='$PHP_SELF?$href&select_arrange=download2&desc=$t_desc'>";
if(!$setup[use_category])
{
$hide_category_start="<!--";
$hide_category_end="-->";
}
if($is_admin||$setup[use_cart])
{
$a_cart="<a onfocus=blur() href='javascript:reverse()'>";
}
else
{
$hide_cart_start="<!--";
$hide_cart_end="-->";
$a_cart="";
}
head('',"script_list.php");
include "$dir/setup.php";
if($no&&$setup[use_alllist])
{
list_check(&$now_data,1);
include "now_view.php";
}
require $dir."/list_head.php";
$loop_number=$total-($page-1)*$page_num;
if($setup[use_alllist]&&!$prev_no) $prev_no=$no;
while($data=mysql_fetch_array($result))
{
list_check(&$data);
if($data[headnum]>-2000000000) {include $dir."/list_main.php";}
else {include $dir."/list_notice.php"; }
$loop_number--;
}
include $dir."/list_foot.php";
foot();
?>
如果您修改了一个代码片段并且觉得很应该让别人共享,您可以把这作为这个代码片段的最新版本提交上来. |
|
