基于mysql的论坛(4)
                        
                            时间:2021-07-01 10:21:17
                            帮助过:4人阅读
							                        
                     
                    
                    
            ## index.php 
<html> 
<head> 
<title>论坛</title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
</head> 
<frameset cols="125,*" rows="*" border="0" frameborder="0">  
  <frame src="left.php" name="left" scrolling="AUTO" frameborder="YES" bordercolor="#000000"> 
  <frame src="right.htm" name="main" scrolling="AUTO"> 
</frameset> 
<noframes><body bgcolor="#FFFFFF"> 
</body></noframes> 
</html> 
## left.php 
<?php 
$fp=fopen("file/counter.txt","r"); 
$counter=fgets($fp,8); 
fclose($fp); 
$counter=$counter+1; 
$fp=fopen("file/counter.txt","w"); 
fputs($fp,$counter); 
fclose($fp); 
require("config.inc.php"); 
$sql="select * from boardinfo"; 
$sql_result=mysql_query($sql); 
$sql_row=mysql_fetch_array($sql_result); 
?> 
<html> 
<head> 
<title>版面列表</title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<link href="css/new.css" rel=stylesheet> 
</head> 
<body background="image/bg.gif" bgcolor="#FFFFFF"> 
<table width="100%" border="0" cellspacing="2" cellpadding="0"> 
  <tr> 
    <td align="center"> </td> 
  </tr> 
  <tr> 
    <td align="center"><a href="apply.php" target="main">注册用户</a></td> 
  </tr> 
  <tr> 
    <td align="center"><font color="#666666">---------</font></td> 
  </tr> 
<?php 
do 
{ 
echo"<tr>"; 
echo"<td align="center"><a href="list.php?board=$sql_row[name]" target="main">$sql_row[chinesename]</a></td>"; 
echo"</tr>"; 
}while($sql_row=mysql_fetch_array($sql_result)); 
?> 
<tr> 
    <td align="center"><font color="#006666">---------</font></td> 
  </tr> 
  <tr> 
    <td height="11"> 
      <script src=file/X86tree.js></script> 
      <script language=javascript> 
        img_t1="image/t1.gif"; 
        img_t2="image/t2.gif"; 
        tree=new TreeView(0,0,640,300); 
        tree.AddImage(0,"image/dot.gif"); 
        tree.AddImage(1,"image/close.gif"); 
        tree.AddImage(2,"image/open.gif"); 
        m1=new Nodes("m1",tree.ImageList,"论坛转向",0,2,""); 
        m1.Add(new Node("站点首页",1,0,"<a href='http://www.jlbusiness.com' target='_top'>"));                                                              m1.Add(new Node("论坛首页",1,0,"<a href='right.htm' target='main'>")); 
    tree.Add2(m1); 
        doc2=new Nodes("doc2",tree.ImageList,"论坛功能",0,2,"-"); 
            doc2.Add(new Node("帖子查询",1,0,"<a href='query.php' target='main'>")); 
            doc2.Add(new Node("精华区域",1,0,"<a href='good.php' target='main'>")); 
                doc2.Add(new Node("察看留言",1,0,"<a href='vmlogin.php' target='main'>")); 
                doc2.Add(new Node("修改资料",1,0,"<a href='modify_l.php' target='main'>")); 
                doc2.Add(new Node("察看资料",1,0,"<a href='userinfo.php' target='main'>")); 
                doc2.Add(new Node("察看积分",1,0,"<a href='viewscore.php' target='main'>")); 
                doc2.Add(new Node("论坛管理",1,0,"<a href='manage.htm' target='main'>")); 
        tree.Add2(doc2); 
        tree.Show(); 
        doc2.Close(); 
        m1.Close(); 
</script> 
    </td> 
  </tr> 
  <tr> 
    <td align="center"> <b><font color="#006666">--------</font><br> 
      <?php echo "$counter"?></b></td> 
  </tr> 
</table> 
</body> 
</html> 
## list.php 
<?php 
require("func.php"); 
if(empty($board)){ 
    $board="computer"; 
} 
$sql="select * from boardinfo where name='$board'"; 
$sql_result=mysql_query($sql); 
$sql_row=mysql_fetch_array($sql_result); 
$chinesename=$sql_row[chinesename]; 
setcookie ("jl_forum[chinesename]",$chinesename); 
$sql="select name from user where slaveboard='$board'"; 
$sql_result=mysql_query($sql); 
?> 
<html> 
<head> 
<title>List</title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<link rel="stylesheet" type="text/css" href="css/index.css"> 
<script language="javascript"> 
function openwin(board,id){                window.open("read.php?board="+board+"&id="+id,"","height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); 
} 
function post(board){                window.open("post.php?board="+board,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); 
} 
</script> 
</head> 
<body bgcolor="#FFFFFF" background="image/bg.gif"> 
<?php include "header.php";?> <br> 
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF"> 
  <tr>  
    <td height="22" width="23%" bgcolor="#eeeeee">版面:<?php 
echo $chinesename; 
?></td> 
    <td height="22" width="41%" bgcolor="#eeeeee">版主:<?php 
while ($sql_row=mysql_fetch_array($sql_result)) 
{ 
echo "$sql_row[name]"." "; 
} 
# 选择出留言纪录; 
$sql="select * from $board where slaveid=0"; 
$temp=mysql_query($sql); 
$sum=mysql_num_rows($temp); 
$totalpage=ceil($sum/$pagesize); 
if ($sum==0) { 
    $totalpage=1; 
} 
# 分页 
if($page<1 or empty($page)){ 
    $page=1; 
} 
elseif ($page>$totalpage){ 
         $page=$totalpage; 
} 
$offset=($page-1)*$pagesize; 
$sql="select * from $board where slaveid=0 order by id desc limit $offset,$pagesize"; 
$sql_result=mysql_query($sql); 
?> </td> 
    <td height="22" width="13%" bgcolor="#eeeeee">贴子总数:<?php echo $sum; ?></td> 
    <td height="22" width="12%"><a href='javascript:post("<?php echo $board;?>")'><img src="image/newtopic.jpg" width="93" height="21" border="0" alt="发新贴子"></a></td> 
    <td height="22" width="11%">  
      <div align="center"><a href="<?php echo "$php_self?board=$board&page=$page";?>">刷新浏览</a></div> 
    </td> 
  </tr> 
</table> 
<br> 
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF"> 
  <tr bgcolor="#995100" align="center"> 
    <td width="6%"><font color="#FFFFFF">回应</font></td> 
    <td width="67%" bgcolor="#995100"><font color="#FFFFFF">主 题</font></td> 
    <td width="20%"><font color="#FFFFFF">时 间</font></td> 
    <td width="7%"><font color="#FFFFFF">人气</font></td> 
  </tr> 
  <tr bgcolor="#FFCC99"> 
    <td colspan="5" height="2"> </td> 
  </tr> 
  <?php 
while ($sql_row=mysql_fetch_array($sql_result)) 
{ 
 echo"<tr>"; 
 echo"<td width="6%" bgcolor="#FFF5DD" align="center">"; 
 if ($sql_row[renum]!=0) 
      { 
       echo "<font color="#FF0000">[+$sql_row[renum]]</font>"; 
      } 
 else 
{ 
echo "[0]"; 
} 
  echo"</td>"; 
  echo"<td bgcolor="#E8FDEE" width="56%"><font face="宋体"><a href='javascript:openwin("$board",$sql_row[id])' title="作者:$sql_row[writer] 大小:$sql_row[size]字节">$sql_row[title]</a></font></td>"; 
  echo"<td width="18%" bgcolor="#FFF5DD" align="center">$sql_row[writetime]</td>"; 
  echo"<td width="6%" bgcolor="#E8FDEE" align="center">$sql_row[hits]</td>"; 
  echo"</tr>"; 
} 
?> 
  <tr bgcolor="#FFCC99"> 
    <td colspan="5" align="center" height="2"> </td> 
  </tr> 
</table> 
<div align="right"> 
<form method="post" action="<?php echo $php_self;?>"> 
    共<b><?php echo $totalpage;?></b>页 第<b><?php echo $page;?></b>页·<?php 
if ($page!=1){ 
     $back=$page-1; 
        echo"<a href="$php_self?board=$board&page=1">首页</a> <a href="$php_self?board=$board&page=$back">上一页</a>"; 
} 
if ($page==1){ 
       echo"首页 上一页"; 
} 
if($page!=$totalpage){ 
    $next=$page+1; 
        echo" <a href="$php_self?board=$board&page=$next">下一页</a> <a href="$php_self?board=$board&page=$totalpage">尾页</a>"; 
} 
if($page==$totalpage){ 
        echo" 下一页 尾页"; 
} 
?>·  
    <input type="submit" name="goto" value="转到"> 
    <input type="text" name="page" size="2"> 
    页  
  </form> 
</div> 
<?php include "footer.php";?> 
</body> 
</html> 
## login.php 
<?php 
require "func.php"; 
if ($name==$admin_name and $password==$admin_password) { 
    setcookie ("jl_admin[name]",$name); 
    setcookie ("jl_admin[password]",$name); 
    redirect2("admin.php"); 
} 
else { 
    show_error(1); 
} 
?> 
## manage.php 
<?php 
require "func.php"; 
if (check_admin_password()) { 
    switch ($job){ 
        case "setgood": 
            set_good($jl_forum[board],$id); 
            break; 
        case "setnogood": 
            set_no_good($jl_forum[board],$id); 
            break; 
        case "delete": 
            del_doc($jl_forum[board],$id); 
            break; 
    } 
echo "<h2>操作成功!</h2><br>"; 
?> 
<html><head><title>o,k</title></head><body> 
<form method="POST"> 
      <input type="button" value=" 关 闭 " name="B1" onclick="window.close()"> 
</form> 
</body> 
</html> 
<?php 
} 
else { 
    show_error(1); 
} 
?> 
## manage_list.php 
<?php 
require("func.php"); 
if (check_admin_password()) { 
$board=$jl_forum[board]; 
$sql="select * from boardinfo where name='$board'"; 
$sql_result=mysql_query($sql); 
$sql_row=mysql_fetch_array($sql_result); 
$chinesename=$sql_row[chinesename]; 
setcookie ("jl_forum[chinesename]",$chinesename); 
$sql="select name from user where slaveboard='$board'"; 
$sql_result=mysql_query($sql); 
?> 
<html> 
<head> 
<title>List</title> 
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"> 
<link rel="stylesheet" type="text/css" href="css/index.css"> 
<script language="javascript"> 
function openwin(board,id){                window.open("manage_read.php?board="+board+"&id="+id,"","height=460,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); 
} 
function post(board){                window.open("post.php?board="+board,"","height=500,width=600,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"); 
} 
</script> 
</head> 
<body bgcolor="#FFFFFF" background="image/bg.gif"> 
<?php include "header.php";?> <br> 
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#D8D8E8" bordercolordark="#D8D8E8"> 
  <tr>  
    <td height="20" width="27%" bgcolor="#d8dde9">版面:<?php 
echo $chinesename; 
?>(管理)</td> 
    <td height="20" width="31%" bgcolor="#d8dde9">版主:<?php 
while ($sql_row=mysql_fetch_array($sql_result)) 
{ 
echo "$sql_row[name]"." "; 
} 
# 选择出留言纪录; 
$sql="select * from $board where slaveid=0"; 
$temp=mysql_query($sql); 
$sum=mysql_num_rows($temp); 
$totalpage=ceil($sum/$pagesize); 
if ($sum==0) { 
    $totalpage=1; 
} 
# 分页 
if($page<1 or empty($page)){ 
    $page=1; 
} 
elseif ($page>$totalpage){ 
         $page=$totalpage; 
} 
$offset=($page-1)*$pagesize; 
$sql="select * from $board where slaveid=0 order by id desc limit $offset,$pagesize"; 
$sql_result=mysql_query($sql); 
?> </td> 
    <td height="20" width="15%" bgcolor="#d8dde9">贴子总数:<?php echo $sum; ?></td> 
    <td height="20" width="12%"><a href='javascript:post("<?php echo $board;?>")'><img src="image/newtopic.jpg" width="92" height="21" border="0" alt="发新贴子"></a></td> 
    <td height="20" align="center" width="15%"><a href="<?php echo "$php_self?board=$board&page=$page";?>">刷新浏览</a></td> 
  </tr> 
</table> 
<br> 
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolorlight="#CCCCCC" bordercolordark="#CCCCCC"> 
  <tr bgcolor="#995100" align="center"> 
    <td width="6%"><font color="#FFFFFF">回应</font></td> 
    <td width="67%" bgcolor="#995100"><font color="#FFFFFF">主 题</font></td> 
    <td width="20%"><font color="#FFFFFF">时 间</font></td> 
    <td width="7%"><font color="#FFFFFF">人气</font></td> 
  </tr> 
  <tr bgcolor="#FFCC99"> 
    <td colspan="5" height="2"> </td> 
  </tr> 
  <?php 
while ($sql_row=mysql_fetch_array($sql_result)) 
{ 
 echo"<tr>"; 
 echo"<td width="6%" bgcolor="#FFF5DD" align="center">"; 
 if ($sql_row[renum]!=0) 
      { 
       echo "<font color="#FF0000">[+$sql_row[renum]]</font>"; 
      } 
 else 
{ 
echo "[0]"; 
} 
  echo"</td>"; 
  echo"<td bgcolor="#E8FDEE" width="56%"><font face="宋体"><a href='javascript:openwin("$board",$sql_row[id])' title="作者:$sql_row[writer] 大小:$sql_row[size]字节">$sql_row[title]</a></font></td>"; 
  echo"<td width="18%" bgcolor="#FFF5DD" align="center">$sql_row[writetime]</td>"; 
  echo"<td width="6%" bgcolor="#E8FDEE" align="center">$sql_row[hits]</td>"; 
  echo"</tr>"; 
} 
?> 
  <tr bgcolor="#FFCC99"> 
    <td colspan="5" align="center" height="2"> </td> 
  </tr> 
</table> 
<div align="right"> 
<form method="post" action="<?php echo $php_self;?>"> 
    共<b><?php echo $totalpage;?></b>页 第<b><?php echo $page;?></b>页· <?php 
if ($page!=1){ 
     $back=$page-1; 
        echo"<a href="$php_self?board=$board&page=1">首页</a> <a href="$php_self?board=$board&page=$back">上一页</a>"; 
} 
if ($page==1){ 
       echo"首页 上一页"; 
} 
if($page!=$totalpage){ 
    $next=$page+1; 
        echo" <a href="$php_self?board=$board&page=$next">下一页</a> <a href="$php_self?board=$board&page=$totalpage">尾页</a>"; 
} 
if($page==$totalpage){ 
        echo" 下一页 尾页"; 
} 
?>·转到第  
    <input type="text" name="page" size="2"> 
    页  
  </form> 
</div> 
<?php include "footer.php"?> 
</body> 
</html> 
<?php 
} 
else { 
    show_error(4); 
} 
?>