#####################
# func.php #########
####################
0){
              $sql=update $board set renum=renum-1 where id=$slaveid;
              mysql_query($sql);
         }
         $sql=delete from $board where id=$id;
         mysql_query($sql);
         $sql=delete from $board where slaveid=$id;
         mysql_query($sql);
}
#### 转换 html 特殊字符和
#####
function htmlencode2($str){
         $str=htmlspecialchars($str);
         $str=nl2br($str);
         return $str;
}
##### 增加一个 hit ####
function add_one_hit($board,$id){
         $sql=update $board set hits=hits+1 where id=$id;
         mysql_query($sql);
}
##### 检查用户密码 ####
function check_user_password($name,$password){
         $name=trim($name);
         $name=ereg_replace(',‘,$name);
         $name=htmlspecialchars($name);
         $password=trim($password);
         $sql=select password from user where name='$name';
         $sql_result=mysql_query($sql);
         $sql_row=mysql_fetch_array($sql_result);
         if($password$sql_row[password]){
              $result=0;
         }
         else{
              $result=1;
              setcookie (jl_forum[name],$name);
              setcookie (jl_forum[password],$password);
         }
         return $result;
}
##### 检查管理员密码 ####
function check_admin_password(){
         $sql=select * from user where name='$jl_forum[name]';
         $sql_result=mysql_query($sql);
         $sql_row=mysql_fetch_array($sql_result);
        if ($jl_forum[password]==$sql_row[password]){
            $result=1;
        }
        else {
            $result=0;
        }
        if ($sql_row[slaveboard]==$jl_forum[board]){
            $result=1;
        }
        else {
            $result=0;
        }  
         return $result;
}
##### 修改个人资料 ####
function change_profile($name){
         global $sex,$realname,$password,$address,$oicq,$homepage,$phone,$email,$qm;
         $name=trim($name);
         $name=htmlspecialchars($name);
         $realname=htmlspecialchars($realname);
         $address=htmlspecialchars($address);
         $oicq=htmlspecialchars($oicq);
         $homepage=htmlspecialchars($homepage);
         $phone=htmlspecialchars($phone);
         $email=htmlspecialchars($email);
         $qm=htmlencode2($qm);
         $sql=update user set sex='$sex',realname='$realname',password='$password',address='$address',oicq='$oicq',homepage='$homepage',phone='$phone',email='$email',qm='$qm' where name='$name';
         mysql_query($sql);
}
##### 显示错误 ####
function show_error($id){
         redirect2(wrong.php?id=$id);
}
##### 增加版主 ####
function add_admin($board,$name){
         $name=trim($name);
         $sql=update user set slaveboard='$board' where name='$name';
         mysql_query($sql);
}
##### 删除版主 #####
function del_admin($name){
         $name=trim($name);
         $name=htmlspecialchars($name);
         $sql=update user set slaveboard='' where name='$name';
         mysql_query($sql);
}
##### 贴子转精华 ####
function set_good($board,$id){
         $sql=update $board set good='y' where id=$id;
         mysql_query($sql);
}
##### 转出精华 ###
function set_no_good($board,$id){
         $sql=update $board set good='' where id=$id;
         mysql_query($sql);
}
##### 导出签名 #####
function expl_qm($name){
        $name=htmlspecialchars($name);
         $sql=select qm from user where name='$name';
         $sql_result=mysql_query($sql);
         $sql_row=mysql_fetch_array($sql_result);
         $qm=$sql_row[qm];
         return $qm;
}
##### 管理员 #####
function adminok() {
    if ($jl_admin[name]==$admin_name and $jl_admin[password]==$admin_password) {
        return 1;
    }
    else {
        return 0;
    }
}
##### 增加积分 #####
function add_score($name,$num) {
    $name=htmlspecialchars($name);
    $sql=update user set score=score+$num where name='$name';
    mysql_query($sql);
}
##### 减少积分 ####
function remove_score($name,$num) {
    $name=htmlspecialchars($name);
    $sql=update user set score=score-$num where name='$name';
    mysql_query($sql);
}
#### 发送留言 ####
function sendmsg() {
    global $fromname,$name,$cont;
    $name=htmlspecialchars($name);
    $fromname=htmlspecialchars($fromname);
    $cont=htmlencode2($cont);
    $wt=date(y-m-d h:i:s);
    $sql=insert into message (name,fromname,cont,writetime) values ('$name','$fromname','$cont','$wt');
    mysql_query($sql);
}
#### 删除留言 ####
function delmsg($id) {
    $sql=delete from message where id=$id;
    mysql_query($sql);
}
### 留言是否属于这个人 #####
function is_this_user($id) {
    $sql=select name from message where id=$id;
    $sql_result=mysql_query($sql);
    $sql_row=mysql_fetch_row($sql_result);
    if ($sql_row[name]==$jl_forum[name]) {
        return 1;
    }
    else {
        return 0;
    }
}
?>
##########################
# good.php ##########
########################
main
璁哄