📄 index.php
字号:
<?php
include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
$ITEMS_IN_PAGE = 10;
if ( !isset( $start ) && $start == "" )
{
$start = 0;
}
echo "\r\n<html>\r\n<head>\r\n<title>项目讨论区</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script Language=\"JavaScript\">\r\nfunction check_all()\r\n{\r\n if(!document.all(\"title_select\"))\r\n return;\r\n for (i=0;i<document.all(\"title_select\").length;i++)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"title_select\").item(i).checked=true;\r\n else\r\n document.all(\"title_select\").item(i).checked=false;\r\n }\r\n\r\n if(i==0)\r\n {\r\n if(document.all(\"allbox\").checked)\r\n document.all(\"title_select\").checked=true;\r\n else\r\n document.all(\"title_select\").checked=false;\r\n }\r\n}\r\n\r\nfunction check_one(el)\r\n{\r\n if(!el.checked)\r\n document.all(\"allbox\").checked=false;\r\n}\r\n\r\nfunction get_checked()\r\n{\r\n checked_str=\"\";\r\n for(i=0;i<document.all(\"title_select\").length;i++)\r\n {\r\n\r\n el=document.all(\"title_select\").item(i);\r\n if(el.checked)\r\n { val=el.value;\r\n checked_str+=val + \",\";\r\n }\r\n }\r\n\r\n if(i==0)\r\n {\r\n el=document.all(\"title_select\");\r\n if(el.checked)\r\n { val=el.value;\r\n checked_str+=val + \",\";\r\n }\r\n }\r\n return checked_str;\r\n \r\n}\r\n\r\nfunction delete_title()\r\n{\r\n delete_str=get_checked();\r\n if(delete_str==\"\")\r\n {\r\n alert(\"要删除主题,请至少选择其中一项。\");\r\n return;\r\n }\r\n\r\n msg='确认要删除所选主题么?';\r\n if(window.confirm(msg))\r\n {\r\n URL=\"delete.php?DELETE_STR=\"+ delete_str +\"&PROJ_ID=";
echo $PROJ_ID;
echo "&start=";
echo $start;
echo "\";\r\n location=URL;\r\n }\r\n}\r\n\r\n</script>\r\n</head>\r\n\r\n<body class=\"bodycolor\" topmargin=\"5\">\r\n";
$query = "select 1 from PROJ_PROJECT WHERE FIND_IN_SET('".$LOGIN_USER_ID."',PROJ_USER) OR FIND_IN_SET('{$LOGIN_USER_ID}',PROJ_VIWER) OR PROJ_OWNER='{$LOGIN_USER_ID}'";
$cursor = exequery( $connection, $query );
if ( !mysql_fetch_array( $cursor ) )
{
message( "错误", "您无权查看!" );
exit( );
}
if ( !isset( $TOTAL_ITEMS ) )
{
$TOTAL_ITEMS = 0;
$query = "SELECT count(*) from PROJ_FORUM where PROJ_ID='".$PROJ_ID."' and PARENT=0";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$TOTAL_ITEMS = $ROW[0];
}
}
if ( $TOTAL_ITEMS == 0 )
{
echo "<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/bbs.gif\" align=\"absmiddle\" width=16 height=16><span class=\"big3\"> 项目讨论区</span> \r\n <input type=\"button\" class=\"SmallButton\" value=\"发帖\" onclick=\"location='edit.php?PROJ_ID=";
echo $PROJ_ID;
echo "'\" title=\"发表新文章\">\r\n </td>\r\n </tr>\r\n</table>\r\n</div>\r\n";
message( "", "此项目尚无讨论内容!" );
exit( );
}
echo "\r\n<table border=\"0\" width=\"100%\" cellspacing=\"0\" cellpadding=\"3\" class=\"small\">\r\n <tr>\r\n <td class=\"Big\"><img src=\"/images/menu/bbs.gif\" align=\"absmiddle\" width=16 height=16><span class=\"big3\"> 项目讨论区</span> \r\n <input type=\"button\" class=\"SmallButton\" value=\"发帖\" onclick=\"location='edit.php?PROJ_ID=";
echo $PROJ_ID;
echo "&start=";
echo $start;
echo "'\" title=\"发表新文章\">\r\n </td>\r\n <td align=\"right\" valign=\"bottom\" class=\"small1\">\r\n \t";
echo page_bar( $start, $TOTAL_ITEMS, $ITEMS_IN_PAGE );
echo " </td>\r\n </tr>\r\n</table>\r\n\r\n<table class=\"TableList\" width=\"100%\" border=0>\r\n <tr class=\"TableHeader\">\r\n";
$query = "SELECT PROJ_OWNER from PROJ_PROJECT where PROJ_ID='".$PROJ_ID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$PROJ_OWNER = $ROW['PROJ_OWNER'];
}
if ( $LOGIN_USER_PRIV == 1 || find_id( $PROJ_OWNER, $LOGIN_USER_ID ) )
{
echo " \t\r\n <td nowrap align=\"center\">选择</td> \t\r\n";
}
echo " \r\n <td nowrap align=\"center\">主题</td>\r\n <td nowrap align=\"center\">作者</td>\r\n <td nowrap align=\"center\">回复数</td>\r\n <td align=\"center\">最后回复</td>\r\n </tr>\r\n\r\n";
$query = "SELECT * from PROJ_FORUM where PROJ_ID='".$PROJ_ID."' and PARENT='0' order by SUBMIT_TIME desc limit {$start},{$ITEMS_IN_PAGE}";
$cursor = exequery( $connection, $query );
$MSG_COUNT = 0;
while ( $ROW = mysql_fetch_array( $cursor ) )
{
++$MSG_COUNT;
$MSG_ID = $ROW['MSG_ID'];
$USER_ID = $ROW['USER_ID'];
$SUBJECT = $ROW['SUBJECT'];
$SUBMIT_TIME = $ROW['SUBMIT_TIME'];
$OLD_SUBMIT_TIME = $ROW['OLD_SUBMIT_TIME'];
if ( $OLD_SUBMIT_TIME == "0000-00-00 00:00:00" )
{
$OLD_SUBMIT_TIME = $SUBMIT_TIME;
}
$REPLY_CONT = $ROW['REPLY_CONT'];
$CONTENT = $ROW['CONTENT'];
$SUBJECT = str_replace( "<", "<", $SUBJECT );
$SUBJECT = str_replace( ">", ">", $SUBJECT );
$SUBJECT = stripslashes( $SUBJECT );
$query1 = "SELECT AVATAR,USER_NAME from USER where USER_ID='".$USER_ID."'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$AVATAR = $ROW['AVATAR'];
$AUTHOR_NAME = $ROW['USER_NAME'];
}
else
{
$USER_NAME = $USER_ID;
$AVATAR = "";
}
$query1 = "SELECT USER.USER_NAME from PROJ_FORUM LEFT JOIN USER ON(PROJ_FORUM.USER_ID=USER.USER_ID) where PARENT='".$MSG_ID."' order by SUBMIT_TIME desc limit 1";
$cursor1 = exequery( $connection, $query1 );
$NEWER = "";
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$NEWER = $ROW['USER_NAME'];
}
if ( $REPLY_CONT == 0 )
{
$REPLY_STR = $OLD_SUBMIT_TIME." by ".$AUTHOR_NAME;
}
else
{
$REPLY_STR = $SUBMIT_TIME." by ".$NEWER;
}
if ( $MSG_COUNT % 2 == 0 )
{
$TableLine = "TableLine1";
}
else
{
$TableLine = "TableLine2";
}
echo " <tr class=\"";
echo $TableLine;
echo "\" onmouseover=\"this.style.backgroundColor='#F5FBFF'\" onmouseout=\"this.style.backgroundColor='#FFFFFF'\">\r\n";
if ( $LOGIN_USER_PRIV == 1 || find_id( $PROJ_OWNER, $LOGIN_USER_ID ) )
{
echo " \r\n <td width=\"40px\" align=\"center\" nowrap> \t\r\n \t<input type=\"checkbox\" name=\"title_select\" value=\"";
echo $MSG_ID;
echo "\" onClick=\"check_one(self);\">\r\n </td>\r\n";
}
echo " <td width=\"50%\">\r\n \t<a href=\"comment.php?PROJ_ID=";
echo $PROJ_ID;
echo "&MSG_ID=";
echo $MSG_ID;
echo "&start=";
echo $start;
echo "\">";
echo $SUBJECT;
echo "</a>\r\n </td>\r\n <td width=\"90\" align=\"center\" nowrap>";
echo $AUTHOR_NAME;
echo "</td>\r\n <td align=\"center\">";
echo $REPLY_CONT;
echo "</td>\r\n <td nowrap>";
echo $REPLY_STR;
echo "</td>\r\n </tr>\r\n";
}
if ( 0 < $MSG_COUNT )
{
echo "\r\n <tr class=\"TableControl\">\r\n <td colspan=10>\r\n";
if ( $LOGIN_USER_PRIV == 1 || find_id( $PROJ_OWNER, $LOGIN_USER_ID ) )
{
echo " \t<input type=checkbox id=\"allbox_for\" onClick=\"check_all();\" name=\"allbox\"><label for=\"allbox_for\">全选</label>\r\n <input type=\"button\" class=\"SmallButton\" value=\"删除主题\" onclick=\"delete_title()\">\r\n";
}
echo " </td>\r\n </tr>\r\n</table>\t\r\n";
}
echo "</body>\r\n</html>";
?>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -