文件名：global.inc.php
<?
//////////////////////////////////////////////////////////////////////
// 定义SALT为encode()函数服务，以便用户忘记密码时，可以告知其原来密码
$SALT="sin30du=0.5";
$def_interval=30;
////////////////////////////////////////////////////////////////////
// sql_connect()
function sql_connect()
{
$admin="ni_ch";
$password="ht0338";
$host="localhost";
$link=mysql_pconnect($host,$admin,$password);
mysql_select_db("icii");
return $link;
}
function school_select()
{
sql_connect();
$sql="SELECT * FROM school";
$result=mysql_query($sql)
or show_error();
print("<select name=\"school_id\">\n");
printf("<option value=%d %s>%s</option>\n",0,"","学校...");
while($row=mysql_fetch_array($result))
printf("<option value=%d>%s</option>\n",$row["school_id"],$row["school_name"]);
print("</select>");
}
function can_delete()
{
global $SALT,$name,$pass,$article_id,$sub_id;
if(is_admin())
return true;
if($sub_id) // 是从帖
{
$sql="select * from member left join sub_article on name=auth_name "
."where sub_id='$sub_id' and pass=encode('$pass','$SALT')";
$result=mysql_query($sql)
or show_error($sql);
if(mysql_num_rows($result)==0)
{
echo $name.$pass.$sub_id;
return false;
}
}
else
{
$sql="select * from member left join article on name=auth_name "
."where article_id='$article_id' and pass=encode('$pass','$SALT')";
$result=mysql_query($sql)
or show_error($sql);
if(mysql_num_rows($result)==0)
{
echo $name.$pass.$article_id;
return false;
}
}
return true;
}
function is_admin()
{
global $SALT,$name,$pass,$article_id,$topic_id;
if($article_id)
{
$sql="select * from member left join topic "
."on member_id=admin_id or member_id=admin_id2 "
."left join article on article.topic_id=topic.topic_id "
." where article_id='$article_id' and name='$name' and pass=encode('$pass','$SALT')";
$result=mysql_query($sql)
or show_error($sql);
if(mysql_num_rows($result)==0)
return false;
return true;
}
elseif($topic_id)
{
$sql="select * from member left join topic "
."on member_id=admin_id or member_id=admin_id2 "
." where topic.topic_id='$topic_id' and name='$name' and pass=encode('$pass','$SALT')";
$result=mysql_query($sql)
or show_error($sql);
if(mysql_num_rows($result)==0)
return false;
return true;
}
}
function user_exist()
{
global $member_id,$name,$pass,$SALT;
$sql="select * from member where member_id='$member_id' and name='$name' and pass=ENCODE('$pass','$SALT')";
$result=mysql_query($sql)
or show_error($sql);
if(mysql_num_rows($result)!=1)
return false;
return true;
}
function href($name,$link,$is_link=1,$extend="")
{
if($is_link)
printf("<a href=%s %s>%s</a>\n",$link,$extend,$name);
else
print($name);
}
//////////////////////////////////////////////////////////////////////////
// print_column($label,$row
function error($id)
{
switch($id)
{
case 1:
$msg="连接数据库失败！";
break;
case 2:
$msg="请将表格中各项填写完整";
break;
case 3:
$msg="用户已经存在，请选择其他用户名";
break;
case 4:
$msg="错误的用户名/密码";
break;
case 5:
$msg="两次密码不一样";
break;
case 6:
$msg="您在表格里面填写的数据过长";
break;
case 7:
$msg="无此用户";
break;
case 8:
$msg="您没有输入查询条件";
break;
case 9:
$msg="没有符合查询条件的纪录";
break;
case 10:
$msg="发现相同用户资料";
break;
default:
$msg="非法请求！";
break;
}
?>
<table>
<tr>
<td align="center" valign="middle"><font color="#FF0000">错误<?=$id.": ".$msg?><font></td>
</tr>
</table>
<?
}
// show_error()
function show_error($str="unknow error")
{
?><h3><font color=red><?=$str?></font></h3>
<?
printf("%d:%s",mysql_errno(),mysql_error());
exit();
}
//////////////////////////////////////////////////////////////////////
// button_field($type,$name,$value,$extend="")
function button_field($type,$name,$value,$extend="")
{
printf("<input type=%s name=%s value=%s $extend>\n",$type,$name,$value,$extend);
}
function copyright()
{
print("<table width=100%><tr><td align=center>©copyright 2001/5 ICII </td></tr></table>");
}
function forum_head($sub)
{
global $topic_id,$type;
?>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../icii.css" type="text/css">
<base link="../index.htm">
<SCRIPT language=javaScript>
function post()
{
window.open ("post.php?topic_id=<?=$topic_id?>", "",
"width=630, height=560, toolbar=no, status=no, menubar=no, resizable=yes, scrollbars=yes");
}
function fresh()
{
window.location.reload(true);
}
function read_article(article_id,type,action)
{
window.open("ArticleView.php?article_id="+article_id+"&type="+type+"&action="+action,"ArticleView");
}
</SCRIPT>
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="100%" border="0" bgcolor="#3A6EA5">
<tr>
<td ><a class="leftlink" href="../index.htm" target="_blank">协会首页</a>|<a class="leftlink" href="../aboutus/" target="_blank">协会简介</a>|<a class="leftlink" href="../org/" target="_blank">协会组织</a>|<font class=currentpage>我的论坛</font>|<a class="leftlink" href="../mag/" target="_blank">《信息潮》</a>|<a class="leftlink" href="../news/" target="_blank">协会新闻</a></td>
</tr>
<tr>
<td height="19">
<hr width="65%" align="left" >
</td>
</tr>
<?
if($sub==0)
{
echo "</table>\n";
return;
}
else
{
?>
<tr>
<td>
<a href="javascript:fresh()" class="sublink">刷新</a>|
<a href="search.php?topic_id=<?=$topic_id?>&type=<?=$type?>" class="sublink" target="_self">搜索</a>|
<?if($type==0){?><a href="javascript:post()" class="sublink">发帖</a>|
<a href="TopicView.php?topic_id=<?=$topic_id?>&type=1" class="sublink" target="_self">精华区</a>
<?}if($type==1){?><a href="TopicView.php?topic_id=<?=$topic_id?>&type=0" class="sublink" target="_self">讨论区</a><?}?></td>
</tr>
</table>
<?
}// else end
}
?>
|