<?php /** * common公用文件 * @author muhongwei * @copyright (C) 2009-2011 DirCMS * @lastmodify 2011-11-28 13:04 */ error_reporting (E_ALL & ~E_NOTICE & ~E_WARNING); define('DIRCMS_ROOT', str_replace("\", '/', substr(dirname(__FILE__), 0, -7))); define('MAGIC_QUOTES_GPC', get_magic_quotes_gpc()); if(PHP_VERSION < '5.3') { set_magic_quotes_runtime(0); } else { ini_set('magic_quotes_runtime',0); } unset($LANG, $HTTP_ENV_VARS, $HTTP_POST_VARS, $HTTP_GET_VARS, $HTTP_POST_FILES, $HTTP_COOKIE_VARS,$baselang); include_once(DIRCMS_ROOT.'data/config.inc.php'); header("Content-type:text/html;charset=".DB_CHARSET); date_default_timezone_set('Etc/GMT-'.TIMEDF); define('TIME',time()); /* Zip优化 */ if(GZIP && extension_loaded('zlib') && function_exists('ob_gzhandler') && function_exists('ob_start')) { ob_start('ob_gzhandler'); } else { ob_start(); } include_once('global.func.php'); define('IP',getIp()); define('IPADDRESS',ip2area(IP)); define('CURURL',getcururl()); $lang=cache_read('lang.inc.php',DIRCMS_ROOT.'data/lang/'.LANG.'/'); /* 数据库 */ include_once('mysql.class.php'); $db=new mysql(); $db->connect(DB_HOST,DB_USER,DB_PSW,DB_NAME,DB_PCONNECT,DB_CHARSET); /* 站群 */ if(defined('DIRCMS_MANAGE')) { $siteid=get_cookie('adminsiteid') && intval(get_cookie('adminsiteid'))?intval(get_cookie('adminsiteid')):1; } else { $siteid=isset($_GET['siteid']) && intval($_GET['siteid'])?intval($_GET['siteid']):(get_cookie('siteid') && intval(get_cookie('siteid'))?intval(get_cookie('siteid')):1); } include_once('sitecrowd.class.php'); $sitecrowdobj=new sitecrowd(); $dir_allcrowd=$allcrowd=$sitecrowdobj->allcrowd(); $childsite=$sitecrowdobj->sitecrowdinfo($siteid); define('SITEID',$childsite?$siteid:1); if(!$childsite) { $childsite=$sitecrowdobj->sitecrowdinfo(1); } define('SITEDIR',$childsite['site_dir']); set_cookie('siteid',SITEID); $baselangdir=SITEDIR?SITEDIR:'zh-cn'; $baselangfile=DIRCMS_ROOT.'data/lang/'.$baselangdir.'/baselang.inc.php'; $baselangfile=file_exists($baselangfile)?$baselangfile:DIRCMS_ROOT.'data/lang/zh-cn/baselang.inc.php'; include $baselangfile; /* FTP */ include_once('ftp.class.php'); if(FTP && FTP_SERVER && FTP_USER && FTP_PWD) { $ftpobj = new ftp(); $ftpobj->connect(FTP_SERVER,FTP_USER,FTP_PWD,FTP_PORT,FTP_TIMEOUT,SSL,PASV); } /* SESSION */ include_once('session_'.SESSION_STORAGE.'.class.php'); $session=new session(); /* 缓存类 */ include_once('cache_'.CACHE_STORAGE.'.class.php'); $cache=new cache(); /* 上传类 */ include_once('upload.class.php'); $upload=new upload(); include_once(DIRCMS_ROOT.'data/common.cache.php'); /* 获取自定义变量 */ $r=$db->fetch_all("SELECT * FROM `".DB_PRE."config` WHERE `".DB_PRE."config`.`siteid`=".intval(SITEID)); if($r) { foreach($r as $_r) { $DIRCMS[$_r['varname']]=$_r['value']; if($_r['system'] && $_r['groupid']==1 && !defined(strtoupper($_r['varname']))) { define(strtoupper($_r['varname']),$_r['value']); } } } $DIRCMS['tlp_path']=DIRCMS_PATH.'template/'.TPL_NAME.'/'; $DIRCMS['tlp_name']=TPL_NAME; $DIRCMS['dircms_path']=DIRCMS_PATH; $DIRCMS['site_id']=SITEID; $DIRCMS['site_dir']=SITEDIR; if(!define(TLP_NAME)) { define('TLP_NAME',TPL_NAME); } if($_REQUEST) { foreach($_REQUEST as $key => $value) { if(isset($$key)) { unset($_REQUEST[$key]); } } if(MAGIC_QUOTES_GPC) { $_REQUEST = dircms_stripslashes($_REQUEST); if($_COOKIE) $_COOKIE = dircms_stripslashes($_COOKIE); } else { $_POST = dircms_addslashes($_POST); $_GET = dircms_addslashes($_GET); $_COOKIE = dircms_addslashes($_COOKIE); extract($_POST,EXTR_SKIP); extract($_GET,EXTR_SKIP); extract($_COOKIE,EXTR_SKIP); } extract($db->escape($_REQUEST),EXTR_SKIP); if($_COOKIE) $db->escape($_COOKIE); } /* 模块对象 */ include_once('module.class.php'); $module=new module(); $_userid=0; $_username='游客/Tourist'; $_groupid=2; $_gradeid=10; $_roleid=0; $_areaid=intval(get_cookie('areaid')); $_areaid=$_areaid?$_areaid:CITY; /* $install 变量: 判断模块是否安装的数组 */ $install=array(); $modules=$module->module_list(); if($modules) { foreach($modules as $mods) { $parse_file=DIRCMS_ROOT.$mods['folder'].'/include/template.func.php'; if(file_exists($parse_file)) { include_once $parse_file; } if(!$module->module_disabled($mods['folder'])) { $install[$mods['folder']]=true; } else { $install[$mods['folder']]=false; } } } $_userid=0; if($install['member']) // 检查是否安装了会员模块 { include_once(DIRCMS_ROOT.'member/data/config.inc.php'); include_once(DIRCMS_ROOT.'member/api/templateinfo.func.php'); $_username=$baselang['tourist']; $_groupid=2; $_gradeid=10; $_level=0; $_expire=0; $_facephoto='member/images/nophoto.gif'; $dircms_auth=get_cookie('auth'); if($dircms_auth) { $auth_key=md5(AUTH_KEY.$_SERVER['HTTP_USER_AGENT']); list($_userid,$_password)=explode(" ", dircms_auth($dircms_auth, 'DECODE', $auth_key)); $_userid=intval($_userid); $sql_cache_member="SELECT * FROM `".DB_PRE."member_cache` WHERE `id`=$_userid"; $sql_member="SELECT * FROM `".DB_PRE."member` WHERE `id`=$_userid"; $r = $db->fetch_one($sql_cache_member); if(!$r) { $r=$db->fetch_one($sql_member); } if($r && $r['password']===$_password) { if($r['groupid']==3 || $r['level']==0) { set_cookie('auth', ''); showmsg($lang['MEMBER_LOGIN_ERR-1']); } extract($r,EXTR_PREFIX_ALL,''); $_message=max(0,$_message); } else { $_userid=0; $_username=''; $_groupid=2; set_cookie('auth',''); } unset($r,$dircms_auth,$dircms_auth_key,$_password,$sql_member); } } /* 插件 */ require DIRCMS_ROOT.'include/admin/plugins.class.php'; $plugins=new plugins(); $T=array(); ?>
<?php /** * Mssql数据库类 只支持数据读取 * @author muhongwei * @copyright (C) 2009-2011 DirCMS * @lastmodify 2011-11-17 10:37 */ class mssql { public $dblink; public $pconnect; private $rs; private $cursor = 0; private $querynum = 0; function connect($hostname,$username,$userpwd,$database,$pconnect=false) { $this->pconnect=$pconnect; $this->dblink=$pconnect?mssql_pconnect($hostname,$username,$userpwd):mssql_connect($hostname,$username,$userpwd);//
mssql_pconnect打开 MS SQL 服务器持续连接。 |
if(!$this->dblink ||!is_resource($this->dblink)) { echo("Can not connect to MsSQL server!"); return false; } mssql_query ('SET TEXTSIZE 65536',$this->dblink); if(!@mssql_select_db($database,$this->dblink)) { echo("Can not select database!"); return false; } return $this->dblink; } function query($sql) { $this->querynum++; $sql = trim($sql); if(preg_match("/^(select.*)limits+([0-9]+)(,([0-9]+))?$/i", $sql, $matchs)) { $sql = $matchs[1]; $offset = $matchs[2]; $pagesize = $matchs[4]; if(!$query = mssql_query($sql, $this->dblink)) { echo('MsSQL Query Error'.$sql); return false; } return $this->limit($query, $offset, $pagesize); } else { if(!$query = mssql_query($sql, $this->dblink)) { echo('MsSQL Query Error'.$sql); return false; } return $query; } } function fetch_all($sql) { $this->rs=$this->query($sql); $result=array(); while($rows=$this->fetch_array($this->rs,MSSQL_ASSOC)) { $result[]=$rows; } mssql_free_result($this->rs); return $result; } function fetch_array($query, $type = MSSQL_ASSOC) { if(is_resource($query)) return mssql_fetch_array($query, $type); if($this->cursor < count($query)) { return $query[$this->cursor++]; } return false; } function limit($query, $offset, $pagesize = 0) { if($pagesize > 0) { mssql_data_seek($query, $offset); } else { $pagesize = $offset; } $info = array(); for($i = 0; $i < $pagesize; $i++) { $r = $this->fetch_array($query); if(!$r) break; $info[] = $r; } $this->free_result($query); $this->cursor = 0; return $info; } function free_result($query) { if(is_resource($query)) { mssql_free_result($query); } } function close() { if($this->dblink && is_resource($this->dblink) && !$this->pconnect) { return mssql_close($this->dblink); } return true; } }