/*
------------------------------------------------------------------------------------
| Front List v 1.0 alpha
| Code By SinoPower
| CopyRight (c) 2007
| Http://www.sditi.com
------------------------------------------------------------------------------------
*/
class MSSQL
{
var $db = array ( "db_user" => "sa", "db_pass" => "", "db_host" => "127.0.0.1", "db_name" => "", );
var $conn = "";
var $query_id = "";
var $insert_id="";
function connect()
{
$this->conn = @mssql_connect($this->db['db_host'], $this->db['db_user'], $this->db['db_pass'])
OR $this->halt("db connect failed,please check.");
@mssql_select_db($this->db['db_name'], $this->conn)
OR $this->halt("select db error,please check.");
}
function query($sql)
{
$this->query_id = @mssql_query($sql) OR $this->halt("SQL Query failed:".$sql);
$this->count++;
return $this->query_id;
}
function fetch_array($query)
{
$this->record = @mssql_fetch_array($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->record;
}
function fetch_assoc($query)
{
$this->record = @mssql_fetch_assoc($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->record;
}
function fetch_row($query)
{
$this->record = @mssql_fetch_row($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->record;
}
function num_rows($query)
{
$this->rows = @mssql_num_rows($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->rows;
}
function free_result()
{
@mssql_free_result($this->query_id);
}
function fetch_object($query)
{
$this->objects = mssql_fetch_object($query);
if (empty($query))
{
$this->halt("Query Invalid:".$query);
}
return $this->objects;
}
function conn_close()
{
@mssql_close($this->conn);
}
function halt($msg)
{
$message = "Error:".htmlspecialchars($msg)."
";
$message .= "Time: ".date("Y-m-d @ H:i")."
";
$message .= "Script: http://".$_SERVER["HTTP_HOST"].getenv("REQUEST_URI")."
";
$message .= "Referer: ".getenv("HTTP_REFERER")."
";
echo $message;
exit;
}
}
?>
/*
------------------------------------------------------------------------------------
| Front List v 1.0 alpha
| Code By SinoPower
| CopyRight (c) 2007
| Http://www.sditi.com
------------------------------------------------------------------------------------
*/
//弹出警告提示
function show_message($str)
{
echo "";
}
//去除HTML标记符号
function clear_html($html){
return trim(preg_replace("/[><]/","",$html));
}
//后退
function back($str)
{
show_message($str);
echo "";
EXIT;
}
// 获取客户端IP
function getip()
{
if (isset($_SERVER))
{
if (isset($_SERVER['HTTP_X_FORWARDED_FOR']))
{
$realip = $_SERVER['HTTP_X_FORWARDED_FOR'];
}
elseif (isset($_SERVER['HTTP_CLIENT_IP']))
{
$realip = $_SERVER['HTTP_CLIENT_IP'];
}
else
{
$realip = $_SERVER['REMOTE_ADDR'];
}
}
else
{
if (getenv("HTTP_X_FORWARDED_FOR"))
{
$realip = getenv( "HTTP_X_FORWARDED_FOR");
} elseif (getenv("HTTP_CLIENT_IP"))
{
$realip = getenv("HTTP_CLIENT_IP");
} else
{
$realip = getenv("REMOTE_ADDR");
}
}
return $realip;
}
//写文件
function write_file($fdir,$fname,$str)
{
$fdir=makedir($fdir);
if($fp=@fopen($fdir."/".$fname,'w'))
{
fwrite($fp,$str);
fclose($fp);
return TRUE;
}else
{
return FALSE;
}
}
function makedir($mdir,$gdir="../")
{
$dir=explode("/",$mdir);
foreach($dir AS $tmp)
{
if(!empty($tmp))
{
if(!is_dir("$gdir/$tmp"))
{
mkdir("$gdir/$tmp",0777);
$gdir.="/".$tmp;
}else
{
$gdir.="/".$tmp;
}
}
}
return $gdir;
}
//创建目录 '根目录/2005+4/1'
function makedir_time($maindir,$time,$maindir)
{
$y=date("Y",$time);
$m=date("m",$time);
$d=date("d",$time);
$dir=$maindir."/".$y."+".$m."/".$d."/";
if(!file_exists($dir))
{
if(!is_dir($maindir."/".$y."+".$m))
{
@mkdir($maindir."/".$y."+".$m,0777);
}
if(!is_dir($maindir."/".$y."+".$m."/".$d))
{
@mkdir($maindir."/".$y."+".$m."/".$d,0777);
}
}
return $dir;
}
//截取字符串,考虑中文
function left_string($str,$strlen=10,$append=true)
{
$j = 0;
for($i=0;$i< $strlen;$i++)
if(ord(substr($str,$i,1))>0xa0) $j++;
if($j%2!=0) $strlen++;
$rstr=substr($str,0,$strlen);
if (strlen($str) > $strlen && $append) {$rstr.='...';}
return $rstr;
}
//除去数组中的slashes
function stripslashes_array(&$array)
{
while(list($key,$var) = each($array))
{
if ($key != 'argc' && $key != 'argv' && (strtoupper($key) != $key || ''.intval($key) == "$key"))
{
if (is_string($var))
{
$array[$key] = stripslashes($var);
}
if (is_array($var))
{
$array[$key] = stripslashes_array($var);
}
}
}
return $array;
}
//转换半角逗号
function change_comma(&$str)
{
if(is_array($str))
{
if(!empty($str))
{
foreach($str AS $v)
{
$v=change_comma($v);
}
}
}else
{
if(!empty($str))
{
$str=str_replace(",",",",$str);
}
}
return $str;
}
?>channel not existss.