说实话，ecshop这个系统，到目前也没见怎么推出新版本，如果是新项目，不太建议使用它。不过，因为我一直以来都在使用中，所以不得不更改让其适应PHP新版本。现在PHP 7已经出发行版了，所以更改来继续使用吧。具体的更改有以下方面：
（1）将mysql扩展的使用替换掉，改为使用mysqli或pdo：
从php5.5开始，mysql扩展将废弃了。
具体更改的文件在于includes/cls_mysql.php。这是个不小的工程，文件代码太长……
if (!defined('DITAN_ECS'))
{die('Hacking attempt');
}class cls_mysql
{var $link_id = NULL;var $settings = array();var $queryCount = 0;var $queryTime = '';var $queryLog = array();var $max_cache_time = 300; // 最大的缓存时间，以秒为单位var $cache_data_dir = 'temp/query_caches/';var $root_path = '';var $error_message = array();var $platform = '';var $version = '';var $dbhash = '';var $starttime = 0;var $timeline = 0;var $timezone = 0;// 事务指令数protected $transTimes = 0;var $mysql_config_cache_file_time = 0;var $mysql_disable_cache_tables = array(); // 不允许被缓存的表，遇到将不会进行缓存function __construct($dbhost, $dbuser, $dbpw, $dbname = '', $charset = 'gbk', $pconnect = 0, $quiet = 0)
{$this->cls_mysql($dbhost, $dbuser, $dbpw, $dbname, $charset, $pconnect, $quiet);
}function cls_mysql($dbhost, $dbuser, $dbpw, $dbname = '', $charset = 'gbk', $pconnect = 0, $quiet = 0)
{if (defined('EC_CHARSET'))
{$charset = strtolower(str_replace('-', '', EC_CHARSET));
}if (defined('ROOT_PATH') && !$this->root_path)
{$this->root_path = ROOT_PATH;
}if ($quiet)
{$this->connect($dbhost, $dbuser, $dbpw, $dbname, $charset, $pconnect, $quiet);
}else{$this->settings = array('dbhost' => $dbhost,
'dbuser' => $dbuser,
'dbpw' => $dbpw,
'dbname' => $dbname,
'charset' => $charset,
'pconnect' => $pconnect);
}
}function connect($dbhost, $dbuser, $dbpw, $dbname = '', $charset = 'utf8', $pconnect = 0, $quiet = 0)
{if ($pconnect)
{$this->link_id = new mysqli('p:'.$dbhost, $dbuser, $dbpw);if ($this->link_id->connect_error)
{if (!$quiet)
{$this->ErrorMsg("Can't pConnect MySQL Server($dbhost)!");
}return false;
}
}else{$this->link_id = new mysqli($dbhost, $dbuser, $dbpw);if ($this->link_id->connect_error)
{if (!$quiet)
{$this->ErrorMsg("Can't Connect MySQL Server($dbhost)!");
}return false;
}
}$this->dbhash = md5($this->root_path . $dbhost . $dbuser . $dbpw . $dbname);$this->version = $this->link_id->server_version;/* 对字符集进行初始化 */$this->link_id->set_charset($charset); $this->link_id->query("SET sql_mode=''");$sqlcache_config_file = $this->root_path . $this->cache_data_dir . 'sqlcache_config_file_' . $this->dbhash . '.php';
@include($sqlcache_config_file);$this->starttime = time();if ($this->max_cache_time && $this->starttime > $this->mysql_config_cache_file_time + $this->max_cache_time)
{if ($dbhost != '.')
{$result = $this->link_id->query("SHOW VARIABLES LIKE 'basedir'");$row = $result->fetch_array(MYSQLI_ASSOC);$result->free();if (!empty($row['Value']{1}) && $row['Value']{1} == ':' && !empty($row['Value']{2}) && $row['Value']{2} == "/")
{$this->platform = 'WINDOWS';
}else{$this->platform = 'OTHER';
}
}else{$this->platform = 'WINDOWS';
}if ($this->platform == 'OTHER' &&($dbhost != '.' && strtolower($dbhost) != 'localhost:3306' && $dbhost != '127.0.0.1:3306') ||date_default_timezone_get() == 'UTC')
{$result = $this->link_id->query("SELECT UNIX_TIMESTAMP() AS timeline, UNIX_TIMESTAMP('" . date('Y-m-d H:i:s', $this->starttime) . "') AS timezone");$row = $result->fetch_array(MYSQLI_ASSOC);$result->free();if ($dbhost != '.' && strtolower($dbhost) != 'localhost:3306' && $dbhost != '127.0.0.1:3306')
{$this->timeline = $this->starttime - $row['timeline'];
}if (date_default_timezone_get() == 'UTC')
{$this->timezone = $this->starttime - $row['timezone'];
}
}$content = '<' . "?phprn" .
'$this->mysql_config_cache_file_time = ' . $this->starttime . ";rn" .
'$this->timeline = ' . $this->timeline . ";rn" .
'$this->timezone = ' . $this->timezone . ";rn" .
'$this->platform = ' . "'" . $this->platform . "';rn?" . '>';
@file_put_contents($sqlcache_config_file, $content);
}/* 选择数据库 */if ($dbname)
{ if ($this->link_id->select_db($dbname) === false )
{if (!$quiet)
{$this->ErrorMsg("Can't select MySQL database($dbname)!");
}return false;
}else{return true;
}
}else{return true;
}
}function select_database($dbname)
{return $this->link_id->select_db($dbname);
}function set_mysql_charset($charset)
{if (in_array(strtolower($charset), array('gbk', 'big5', 'utf-8', 'utf8')))
{$charset = str_replace('-', '', $charset);
}$this->link_id->set_charset($charset);
}function fetch_array($query, $result_type = MYSQLI_ASSOC)
{$row = $query->fetch_array($result_type);$query->free();return $row;
}function query($sql, $type = '')
{if ($this->link_id === NULL)
{$this->connect($this->settings['dbhost'], $this->settings['dbuser'], $this->settings['dbpw'], $this->settings['dbname'], $this->settings['charset'], $this->settings['pconnect']);$this->settings = array();
}if ($this->queryCount++ <= 99)
{$this->queryLog[] = $sql;
}if ($this->queryTime == '')
{if (PHP_VERSION >= '5.0.0')
{$this->queryTime = microtime(true);
}else{$this->queryTime = microtime();
}
}/* 当当前的时间大于类初始化时间的时候，自动执行 ping 这个自动重新连接操作 */if (time() > $this->starttime + 1)
{$this->link_id->ping();
}if (!($query = $this->link_id->query($sql)) && $type != 'SILENT')
{$this->error_message[]['message'] = 'MySQL Query Error';$this->error_message[]['sql'] = $sql;$this->error_message[]['error'] = $this->link_id->error;$this->error_message[]['errno'] = $this->link_id->errno;$this->ErrorMsg();return false;
}if (defined('DEBUG_MODE') && (DEBUG_MODE & 8) == 8)
{$logfilename = $this->root_path . DATA_DIR . '/mysql_query_' . $this->dbhash . '_' . date('Y_m_d') . '.log';$str = $sql . "nn";if (PHP_VERSION >= '5.0')
{file_put_contents($logfilename, $str, FILE_APPEND);
}else{$fp = @fopen($logfilename, 'ab+');if ($fp)
{fwrite($fp, $str);fclose($fp);
}
}
}return $query;
}function affected_rows()
{return $this->link_id->affected_rows;
}function error()
{return $this->link_id->error;
}function errno()
{return $this->link_id->errno;
}function result($query, $row)
{$query->data_seek($row);$result = $query->fetch_row();$query->free();return $result;
}function num_rows($query)
{return $query->num_rows;
}function num_fields($query)
{return $this->link_id->field_count;
}function free_result($query)
{return $query->free();
}function insert_id()
{return $this->link_id->insert_id;
}function fetchRow($query)
{return $query->fetch_assoc();
}function fetch_fields($query)
{return $query->fetch_field();
}function version()
{return $this->version;
}function ping()
{return $this->link_id->ping();
}function escape_string($unescaped_string)
{return $this->link_id->real_escape_string($unescaped_string);
}function close()
{return $this->link_id->close();
}function ErrorMsg($message = '', $sql = '')
{if ($message)
{echo "<b>DTXB info</b>: $messagenn<br /><br />";//print('<a href="http://faq.comsenz.com/?type=mysql&dberrno=2003&dberror=Can%27t%20connect%20to%20MySQL%20server%20on" target="_blank">http://faq.comsenz.com/</a>'); }else{echo "<b>MySQL server error report:";print_r($this->error_message);//echo "<br /><br /><a href='http://faq.comsenz.com/?type=mysql&dberrno=" . $this->error_message[3]['errno'] . "&dberror=" . urlencode($this->error_message[2]['error']) . "' target='_blank'>http://faq.comsenz.com/</a>"; }exit;
}/* 仿真 Adodb 函数 */function selectLimit($sql, $num, $start = 0)
{if ($start == 0)
{$sql .= ' LIMIT ' . $num;
}else{$sql .= ' LIMIT ' . $start . ', ' . $num;
}return $this->query($sql);
}function getOne($sql, $limited = false)
{if ($limited == true)
{$sql = trim($sql . ' LIMIT 1');
}$res = $this->query($sql);if ($res !== false)
{$row = $res->fetch_row();$res->free();if ($row !== false)
{return $row[0];
}else{return '';
}
}else{return false;
}
}function getOneCached($sql, $cached = 'FILEFIRST')
{$sql = trim($sql . ' LIMIT 1');$cachefirst = ($cached == 'FILEFIRST' || ($cached == 'MYSQLFIRST' && $this->platform != 'WINDOWS')) && $this->max_cache_time;if (!$cachefirst)
{return $this->getOne($sql, true);
}else{$result = $this->getSqlCacheData($sql, $cached);if (empty($result['storecache']) == true)
{return $result['data'];
}
}$arr = $this->getOne($sql, true);if ($arr !== false && $cachefirst)
{$this->setSqlCacheData($result, $arr);
}return $arr;
}function getAll($sql)
{$res = $this->query($sql);if ($res !== false)
{$arr = $res->fetch_all(MYSQLI_ASSOC);$res->free(); return $arr;
}else{return false;
}
}function getAllCached($sql, $cached = 'FILEFIRST')
{$cachefirst = ($cached == 'FILEFIRST' || ($cached == 'MYSQLFIRST' && $this->platform != 'WINDOWS')) && $this->max_cache_time;if (!$cachefirst)
{return $this->getAll($sql);
}else{$result = $this->getSqlCacheData($sql, $cached);if (empty($result['storecache']) == true)
{return $result['data'];
}
}$arr = $this->getAll($sql);if ($arr !== false && $cachefirst)
{$this->setSqlCacheData($result, $arr);
}return $arr;
}function getRow($sql, $limited = false)
{if ($limited == true)
{$sql = trim($sql . ' LIMIT 1');
}$res = $this->query($sql);if ($res !== false)
{$result = $res->fetch_assoc();$res->free();return $result;
}else{return false;
}
}function getRowCached($sql, $cached = 'FILEFIRST')
{$cachefirst = ($cached == 'FILEFIRST' || ($cached == 'MYSQLFIRST' && $this->platform != 'WINDOWS')) && $this->max_cache_time;if (!$cachefirst)
{return $this->getRow($sql, true);
}else{$result = $this->getSqlCacheData($sql, $cached);if (empty($result['storecache']) == true)
{return $result['data'];
}
}$arr = $this->getRow($sql, true);if ($arr !== false && $cachefirst)
{$this->setSqlCacheData($result, $arr);
}return $arr;
}function getCol($sql)
{$res = $this->query($sql);if ($res !== false)
{$arr = array();while ($row = $res->fetch_row())
{$arr[] = $row[0];
}$res->free();return $arr;
}else{return false;
}
}function getColCached($sql, $cached = 'FILEFIRST')
{$cachefirst = ($cached == 'FILEFIRST' || ($cached == 'MYSQLFIRST' && $this->platform != 'WINDOWS')) && $this->max_cache_time;if (!$cachefirst)
{return $this->getCol($sql);
}else{$result = $this->getSqlCacheData($sql, $cached);if (empty($result['storecache']) == true)
{return $result['data'];
}
}$arr = $this->getCol($sql);if ($arr !== false && $cachefirst)
{$this->setSqlCacheData($result, $arr);
}return $arr;
}function autoExecute($table, $field_values, $mode = 'INSERT', $where = '', $querymode = '')
{$field_names = $this->getCol('DESC ' . $table);$sql = '';if ($mode == 'INSERT')
{$fields = $values = array();foreach ($field_names AS $value)
{if (array_key_exists($value, $field_values) == true)
{$fields[] = $value;$values[] = "'" . $field_values[$value] . "'";
}
}if (!empty($fields))
{$sql = 'INSERT INTO ' . $table . ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')';
}
}else{$sets = array();foreach ($field_names AS $value)
{if (array_key_exists($value, $field_values) == true)
{$sets[] = $value . " = '" . $field_values[$value] . "'";
}
}if (!empty($sets))
{$sql = 'UPDATE ' . $table . ' SET ' . implode(', ', $sets) . ' WHERE ' . $where;
}
}if ($sql)
{return $this->query($sql, $querymode);
}else{return false;
}
}function autoReplace($table, $field_values, $update_values, $where = '', $querymode = '')
{$field_descs = $this->getAll('DESC ' . $table);$primary_keys = array();foreach ($field_descs AS $value)
{$field_names[] = $value['Field'];if ($value['Key'] == 'PRI')
{$primary_keys[] = $value['Field'];
}
}$fields = $values = array();foreach ($field_names AS $value)
{if (array_key_exists($value, $field_values) == true)
{$fields[] = $value;$values[] = "'" . $field_values[$value] . "'";
}
}$sets = array();foreach ($update_values AS $key => $value)
{if (array_key_exists($key, $field_values) == true)
{if (is_int($value) || is_float($value))
{$sets[] = $key . ' = ' . $key . ' + ' . $value;
}else{$sets[] = $key . " = '" . $value . "'";
}
}
}$sql = '';if (empty($primary_keys))
{if (!empty($fields))
{$sql = 'INSERT INTO ' . $table . ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')';
}
}else{if ($this->version() >= '4.1')
{if (!empty($fields))
{$sql = 'INSERT INTO ' . $table . ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')';if (!empty($sets))
{$sql .= 'ON DUPLICATE KEY UPDATE ' . implode(', ', $sets);
}
}
}else{if (empty($where))
{$where = array();foreach ($primary_keys AS $value)
{if (is_numeric($value))
{$where[] = $value . ' = ' . $field_values[$value];
}else{$where[] = $value . " = '" . $field_values[$value] . "'";
}
}$where = implode(' AND ', $where);
}if ($where && (!empty($sets) || !empty($fields)))
{if (intval($this->getOne("SELECT COUNT(*) FROM $table WHERE $where")) > 0)
{if (!empty($sets))
{$sql = 'UPDATE ' . $table . ' SET ' . implode(', ', $sets) . ' WHERE ' . $where;
}
}else{if (!empty($fields))
{$sql = 'REPLACE INTO ' . $table . ' (' . implode(', ', $fields) . ') VALUES (' . implode(', ', $values) . ')';
}
}
}
}
}if ($sql)
{return $this->query($sql, $querymode);
}else{return false;
}
}function setMaxCacheTime($second)
{$this->max_cache_time = $second;
}function getMaxCacheTime()
{return $this->max_cache_time;
}function getSqlCacheData($sql, $cached = '')
{$sql = trim($sql);$result = array();$result['filename'] = $this->root_path . $this->cache_data_dir . 'sqlcache_' . abs(crc32($this->dbhash . $sql)) . '_' . md5($this->dbhash . $sql) . '.php';$data = @file_get_contents($result['filename']);if (isset($data{23}))
{$filetime = substr($data, 13, 10);$data = substr($data, 23);if (($cached == 'FILEFIRST' && time() > $filetime + $this->max_cache_time) || ($cached == 'MYSQLFIRST' && $this->table_lastupdate($this->get_table_name($sql)) > $filetime))
{$result['storecache'] = true;
}else{$result['data'] = @unserialize($data);if ($result['data'] === false)
{$result['storecache'] = true;
}else{$result['storecache'] = false;
}
}
}else{$result['storecache'] = true;
}return $result;
}function setSqlCacheData($result, $data)
{if ($result['storecache'] === true && $result['filename'])
{
@file_put_contents($result['filename'], '<?php exit;?>' . time() . serialize($data));clearstatcache();
}
}/* 获取 SQL 语句中最后更新的表的时间，有多个表的情况下，返回最新的表的时间 */function table_lastupdate($tables)
{if ($this->link_id === NULL)
{$this->connect($this->settings['dbhost'], $this->settings['dbuser'], $this->settings['dbpw'], $this->settings['dbname'], $this->settings['charset'], $this->settings['pconnect']);$this->settings = array();
}$lastupdatetime = '0000-00-00 00:00:00';$tables = str_replace('`', '', $tables);$this->mysql_disable_cache_tables = str_replace('`', '', $this->mysql_disable_cache_tables);foreach ($tables AS $table)
{if (in_array($table, $this->mysql_disable_cache_tables) == true)
{$lastupdatetime = '2037-12-31 23:59:59';break;
}if (strstr($table, '.') != NULL)
{$tmp = explode('.', $table);$sql = 'SHOW TABLE STATUS FROM `' . trim($tmp[0]) . "` LIKE '" . trim($tmp[1]) . "'";
}else{$sql = "SHOW TABLE STATUS LIKE '" . trim($table) . "'";
}$result = $this->link_id->query($sql);$row = $result->fetch_assoc();if ($row['Update_time'] > $lastupdatetime)
{$lastupdatetime = $row['Update_time'];
}
}$lastupdatetime = strtotime($lastupdatetime) - $this->timezone + $this->timeline;return $lastupdatetime;
}function get_table_name($query_item)
{$query_item = trim($query_item);$table_names = array();/* 判断语句中是不是含有 JOIN */if (stristr($query_item, ' JOIN ') == '')
{/* 解析一般的 SELECT FROM 语句 */if (preg_match('/^SELECT.*?FROMs*((?:`?w+`?s*.s*)?`?w+`?(?:(?:s*AS)?s*`?w+`?)?(?:s*,s*(?:`?w+`?s*.s*)?`?w+`?(?:(?:s*AS)?s*`?w+`?)?)*)/is', $query_item, $table_names))
{$table_names = preg_replace('/((?:`?w+`?s*.s*)?`?w+`?)[^,]*/', '1', $table_names[1]);return preg_split('/s*,s*/', $table_names);
}
}else{/* 对含有 JOIN 的语句进行解析 */if (preg_match('/^SELECT.*?FROMs*((?:`?w+`?s*.s*)?`?w+`?)(?:(?:s*AS)?s*`?w+`?)?.*?JOIN.*$/is', $query_item, $table_names))
{$other_table_names = array();preg_match_all('/JOINs*((?:`?w+`?s*.s*)?`?w+`?)s*/i', $query_item, $other_table_names);return array_merge(array($table_names[1]), $other_table_names[1]);
}
}return $table_names;
}/* 设置不允许进行缓存的表 */function set_disable_cache_tables($tables)
{if (!is_array($tables))
{$tables = explode(',', $tables);
}foreach ($tables AS $table)
{$this->mysql_disable_cache_tables[] = $table;
}array_unique($this->mysql_disable_cache_tables);
} /**
+----------------------------------------------------------
* 启动事务
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @return void
+---------------------------------------------------------- */public function startTrans() {//$this->initConnect(true);if ( !$this->link_id ) return false;//数据rollback 支持if ($this->transTimes == 0) {$this->link_id->autocommit(FALSE);
}$this->transTimes++;return ;
} /**
+----------------------------------------------------------
* 用于非自动提交状态下面的查询提交
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @return boolen
+---------------------------------------------------------- */public function commit()
{if ($this->transTimes > 0) {$result = $this->link_id->commit();$this->transTimes = 0;if(!$result){$this->error_message[]['message'] = 'MySQL Query Error';$this->error_message[]['sql'] = $sql;$this->error_message[]['error'] = $this->link_id->error;$this->error_message[]['errno'] = $this->link_id->errno;$this->ErrorMsg();return false;
}
}return true;
} /**
+----------------------------------------------------------
* 事务回滚
+----------------------------------------------------------
* @access public
+----------------------------------------------------------
* @return boolen
+---------------------------------------------------------- */public function rollback()
{if ($this->transTimes > 0) {$result = $this->link_id->rollback();$this->transTimes = 0;if(!$result){$this->error_message[]['message'] = 'MySQL Query Error';$this->error_message[]['sql'] = $sql;$this->error_message[]['error'] = $this->link_id->error;$this->error_message[]['errno'] = $this->link_id->errno;$this->ErrorMsg();return false;
}
}return true;
}
}
View Code
代码当中加了几个方法，用于支持事务。
（2）更改cls_image.php的gd_version()方法，将这个方法改为静态方法，并且所有调用此方法的地方，都改为静态调用。
PHP5.6开始，已经不支持不兼容的上下文调用方法， 并且产生 E_DEPRECATED 错误 （以前是 E_STRICT）。
更改如下：
includes/cls_images.php，(gd_version方法体添加static关键字）
/**
* 获得服务器上的 GD 版本
*
* @access public
* @return int 可能的值为0，1，2 */static function gd_version()
{....}
View Code
在好几处调用此方法的地方都改为静态调用，比如includes/cls_images.php的好几个方法在调用时使用类对象调用：
function make_thumb($img, $thumb_width = 0, $thumb_height = 0, $path = '', $bgcolor='')
{ $gd = $this->gd_version(); //获取 GD 版本。0 表示没有 GD 库，1 表示 GD 1.x，2 表示 GD 2.x 。。。
}
将其改为：
function make_thumb($img, $thumb_width = 0, $thumb_height = 0, $path = '', $bgcolor='')
{ $gd = self::gd_version(); //获取 GD 版本。0 表示没有 GD 库，1 表示 GD 1.x，2 表示 GD 2.x 。。。
}
还有includes/lib_base.php文件的gd_version函数，改为：
function gd_version()
{include_once(ROOT_PATH . 'includes/cls_image.php');return cls_image::gd_version();
}
其他文件代码在调用时，最好改为调用lib_base文件的gd_version的函数。可以搜索更改。
（3）更改includes/lib_main.php文件的get_dyna_libs函数，该第一行的代码：
function get_dyna_libs($theme, $tmp)
{$ext = end(explode('.', $tmp));
。。。
}
更改为：
function get_dyna_libs($theme, $tmp)
{$tmp_ext = explode('.', $tmp);$ext = end($tmp_ext);
}
end方法的接受的参数必须是引用传递值，这里使用了explode方法返回值，不可以直接套用。
（4）includes/cls_template.php代码：
preg_replace方法，自PHP5.5开始 /e修饰符已经废弃，所以要使用preg_replace_callback代替。此代替有多处:
fetch_str方法：
fetch_str($source)
{
。。。 return preg_replace_callback("/{([^}{n]*)}/",'self::select_replace', $source);
}//新增的方法private function select_replace($matches){return $this->select($matches[1]);
}
select方法：
function select($tag)
{
。。。 $pregReplace = preg_replace_callback("/('\$[^,]+)/" , function($matches){ return stripslashes(trim($matches[1],'''));
}, var_export($t, true));
。。。
}
smarty_prefilter_preCompile方法：
$source = preg_replace_callback($pattern, function($matches){return '{include file='.strtolower($matches[1]). '}';
}, $source);
（5）将所有类的构造函数，都去除使用类名的构造函数，保留__construct()：
涉及此改动的超多，用搜索一一找到并改动吧……这个就不列举了。
0% (0)
0% (0)