db_mysql.class.php

Dedecms5.3泄密版 Dedecms5.3泄密版

<?php
/*
	[Onez!] (C)2002-2008 Onez Inc.
	This is NOT a freeware, use is subject to license terms
  
  $Author: 冰冻的天份 $
  $QQ: 6200103 $
	$file: db_mysql.class.php $
	$Revision: 2.0 $
	$Date: 2008/06/20 14:37:06 $
*/
class db{
  function db(){
    global $dbhost,$dbuser,$dbpass,$dbname,$pconnect,$charset;
		if($pconnect) {
      $conn=@mysql_pconnect($dbhost, $dbuser, $dbpass);
		} else {
			$conn=@mysql_connect($dbhost, $dbuser, $dbpass);
		}
    if(!$conn) {
      die('Can not connect to MySQL server');
    }
    mysql_select_db($dbname,$conn);
    @$this->query("SET NAMES '$charset'",true);
    register_shutdown_function(array(&$this, 'close'));
  }
  
  function close(){
    @mysql_close();
  }
  
  function query($sql) {
    $query=mysql_query($sql);
    if(!$query){
      //print(mysql_errno() . ': ' . mysql_error());
      //exit;
    }
    return $query;
  }
  
  function fetch_array($sql) {
    return mysql_fetch_array($sql);
  }
  
  function rows($table,$vars="") {
    global $tbl;
    $table = $tbl.$table;
    if($vars){
      $vars = "where $vars";
    }
    $result=$this->query("select id from $table $vars");
    return $result ? mysql_num_rows($result) : 0;
  }
  
  function insert($table,$key,$value) {
    global $tbl;
    $table = $tbl.$table;
    $v=explode("|",$value);
    for($i=0;$i<count($v);$i++){
      $xxx.="\"".(substr($v[$i],0,7)=="content" ? $_POST[$v[$i]] :$v[$i])."\"";
      if($i<count($v)-1)$xxx.=",";
    }
    $this->query("insert into $table ($key)values($xxx)");
  }
  function update($table,$key,$value,$vars) {
    global $tbl;
    $table = $tbl.$table;
    if($vars){
      $vars = "where $vars";
    }
    $k=explode(",",$key);
    $v=explode("|",$value);
    for($i=0;$i<count($k);$i++){
      $xxx.=$k[$i]."=\"".(substr($v[$i],0,7)=="content" ? $_POST[$v[$i]] :$v[$i])."\"";
      if($i<count($k)-1)$xxx.=",";
    }
    $this->query("update $table set $xxx $vars");
  }
  function delete($table,$vars) {
    global $tbl;
    $table = $tbl.$table;
    if($vars){
      $vars = "where $vars";
    }
    $this->query("delete from $table $vars");
  }
  function select($table,$key,$vars=""){
    global $tbl;
    $table = $tbl.$table;
    if($vars){
      $vars = "where $vars";
    }
    $result=$this->query("select $key from $table $vars");
    if(!$result){
      return false;
    }else{
      $rs=mysql_fetch_array($result);
      return $rs[0];
    }
  }
  function record($table,$key,$vars="",$limit=""){
    global $tbl;
    $table = $tbl.$table;
    if($vars){
      $vars = "where $vars";
    }
    if($limit){
      $limit = "limit $limit";
    }
    $k=explode(",",$key);
    $record = Array();
    $result=$this->query("select $key from $table $vars $limit");
    $j=0;
    if(!$result){
      return false;
    }
    while($eqmk=$this->fetch_array($result)){
      for($i=0;$i<count($k);$i++){
        $temp = $eqmk[$i];
        $record[$j][$k[$i]]=$temp;
        $record[$j][$i]=$temp;
      }
      $j++;
    }
    return $record;
  }
  function page($table,$key,$vars="",$maxperpage=20,$strs=""){
    global $tbl;
    $table_=$table;
    $vars_=$vars;
    $pagename = $_SERVER['PHP_SELF'];
    $table = $tbl.$table;
    if($vars){
      $vars = "where $vars";
    }
    if($limit){
      $limit = "limit $limit";
    }
    $j=0;
    $thispage=Char_Cv("page","get");
    if ($thispage=="" || !is_numeric($thispage)){
      $thispage=1;
    }
    $thispage=intval($thispage);
    $sql="select $key from $table $vars $limit";
    $result=$this->query($sql);
    $totalput=$this->rows($table_,$vars_);
    if ($thispage>1){
      mysql_data_seek($result,$maxperpage*($thispage-1));
    }
    $k=explode(",",$key);
    $record = Array();
    while($eqmk=$this->fetch_array($result)){
      for($i=0;$i<count($k);$i++){
        $temp = $eqmk[$i];
        $record[$j][$k[$i]]=$temp;
        $record[$j][$i]=$temp;
      }
      $j++;
      if ($j>=$maxperpage){
        break;
      }
    }
    if (($totalput %$maxperpage)==0){
      $PageCount=intval($totalput /$maxperpage);
    }else{
      $PageCount=intval($totalput /$maxperpage+1);
    } 
    $ms="";
    for ($k=1; $k<=$PageCount; $k=$k+1){
      if ($k==$thispage){
        $ms=$ms.$k." "."\r\n";
      }else{
        $ms=$ms."<a href='".$pagename."?page=".$k."&".$strs."'><u><font color=blue>[".$k."]</font></u></a> "."\r\n";
      }
    }
    $pagelist="<div align=\"center\">".$ms."</div>";
    if(Trim($ms)=="1"){
      $pagelist="";
    }
    return array($record,$pagelist,$totalput);
  }
  
  function datediff($interval,$date1,$date2,$num){
    switch($interval){
      case "n":
        $interval="MINUTE";
        break;
    }
    return "DATE_FORMAT(ADDDATE($date1,INTERVAL $num $interval),'%Y%m%d%H%i')<DATE_FORMAT($date2,'%Y%m%d%H%i')";
  }
}
?>