{"id":199404,"date":"2025-05-03T08:07:20","date_gmt":"2025-05-03T00:07:20","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199404\/"},"modified":"2025-05-03T08:07:20","modified_gmt":"2025-05-03T00:07:20","slug":"ecshop%e6%94%b9%e9%80%a0%e8%af%bb%e5%86%99%e4%b8%bb%e4%bb%8e%e6%95%b0%e6%8d%ae%e5%ba%93%e5%88%86%e7%a6%bb","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199404\/","title":{"rendered":"ecshop\u6539\u9020\u8bfb\u5199\u4e3b\u4ece\u6570\u636e\u5e93\u5206\u79bb"},"content":{"rendered":"

\u8bbe\u7f6eecshop\u6570\u636e\u5e93\u670d\u52a1\u5668\u5206\u79bb\uff0c\u8ba9\u8bfb\u4e0e\u5199\u5206\u5f00 \uff0c\u53ef\u5927\u5927\u52a0\u5feb\u7f51\u7ad9\u901f\u5ea6\u3002\u4e5f\u53ef\u66f4\u597d\u7684\u4f18\u5316\u7f51\u7ad9\u3002
\n
data\/config.php   <?php   $db_name   = “ecshop”;   $prefix    = “ecs_”;   $timezone    = “Europe\/Berlin”;   $cookie_path    = “\/”;   $cookie_domain    = “”;   $session = “1440”;   $_config = array();   \/\/\u6570\u636e\u5e93\u4e3b\u670d\u52a1\u5668\u8bbe\u7f6e, \u652f\u6301\u591a\u7ec4\u670d\u52a1\u5668\u8bbe\u7f6e, \u5f53\u8bbe\u7f6e\u591a\u7ec4\u670d\u52a1\u5668\u65f6, \u5219\u4f1a\u968f\u673a\u4f7f\u7528\u67d0\u4e2a\u670d\u52a1\u5668 $_config[‘master’][1][‘dbhost’] = “192.168.2.175:3306”; $_config[‘master’][1][‘dbname’] = “ecshop”; $_config[‘master’][1][‘dbuser’] = “dragon”; $_config[‘master’][1][‘dbpw’] = “loong”;   \/*  *$_config[‘master’][2][‘dbhost’] = “”;  *…  *\/   \/\/\u6570\u636e\u5e93\u4ece\u670d\u52a1\u5668\u8bbe\u7f6e( slave, \u53ea\u8bfb ), \u652f\u6301\u591a\u7ec4\u670d\u52a1\u5668\u8bbe\u7f6e, \u5f53\u8bbe\u7f6e\u591a\u7ec4\u670d\u52a1\u5668\u65f6, \u7cfb\u7edf\u6bcf\u6b21\u968f\u673a\u4f7f\u7528 $_config[‘slave’][1][‘dbhost’] = “192.168.2.176:3306”; $_config[‘slave’][1][‘dbname’] = “ecshop”; $_config[‘slave’][1][‘dbuser’] = “ivan”; $_config[‘slave’][1][‘dbpw’] = “loong”;   $_config[‘slave’][2][‘dbhost’] = “192.168.2.177:3306”; $_config[‘slave’][2][‘dbname’] = “ecshop”; $_config[‘slave’][2][‘dbuser’] = “ivan”; $_config[‘slave’][2][‘dbpw’] = “loong”;   define(‘EC_CHARSET’,’utf-8′);   define(‘ADMIN_PATH’,’admin’);   define(‘AUTH_KEY’, ‘this is a key’);   define(‘OLD_AUTH_KEY’, ”);   define(‘API_TIME’, ”);   ?>   \u521d\u59cb\u5316\u6570\u636e\u8fde\u63a5\u7c7b         \/* \u521d\u59cb\u5316\u6570\u636e\u5e93\u7c7b        * \u5982\u679c\u914d\u7f6e\u4e86\u4ece\u670d\u52a1\u5668\uff0c\u5219\u521d\u59cb\u5316\u4ece\u5e93\u7c7b      *\/       if(count($_config[‘slave’])) {           require(ROOT_PATH . ‘includes\/cls_mysql_slave.php’);           $db = new cls_mysql_slave($_config);       }else{           require(ROOT_PATH . ‘includes\/cls_mysql.php’);           $db = new cls_mysql($_config);       } \u589e\u52a0cls_mysql_slave.php\u4ece\u5e93\u7c7b     <?php   require(ROOT_PATH . ‘includes\/cls_mysql.php’); class cls_mysql_slave extends cls_mysql {  var $slaveid = null;    function set_config($config){  if(!empty($this->config[‘slave’])) {  $this->slaveid = array_rand($this->config[‘slave’]);  }  parent::set_config($config);  }    \/* \u968f\u673a\u5206\u914d\u4ece\u5e93\u8fde\u63a5 *\/  function set_slave_config() {   $this->settings = $this->config[‘slave’][$this->slaveid];  $this->settings[‘charset’] = $this->config[‘charset’];  $this->settings[‘pconnect’] = $this->config[‘pconnect’];  }    function slave_connect() {  $this->set_slave_config();  $dbhost = $this->settings[‘dbhost’];  $dbuser = $this->settings[‘dbuser’];  $dbpw = $this->settings[‘dbpw’];  $dbname = $this->settings[‘dbname’];  $this->connect($dbhost, $dbuser, $dbpw, $dbname);    }      function query($sql, $type = ”) {  \/\/ \u5982\u679c\u6267\u884c\u67e5\u8be2\u64cd\u4f5c\uff0c\u5219\u6267\u884c\u4ece\u5e93\u8fde\u63a5  if($this->slaveid && strtoupper(substr($sql, 0 , 6)) == ‘SELECT’) {  $this->slave_connect();  }else{  parent::set_config($this->config);  $dbhost = $this->settings[‘dbhost’];  $dbuser = $this->settings[‘dbuser’];  $dbpw = $this->settings[‘dbpw’];  $dbname = $this->settings[‘dbname’];  $this->connect($dbhost, $dbuser, $dbpw, $dbname);  }  return parent::query($sql, $type);  }    \/* \u5220\u9664\u5931\u8d25\u8fde\u63a5*\/  function del_error_link(){  unset($this->config[‘slave’][$this->slaveid]);  $this->set_config($this->config);  $this->set_slave_config();  $dbhost = $this->settings[‘dbhost’];  $dbuser = $this->settings[‘dbuser’];  $dbpw = $this->settings[‘dbpw’];  $dbname = $this->settings[‘dbname’];  $this->connect($dbhost, $dbuser, $dbpw, $dbname);  }   } cls_mysql.php\u6587\u4ef6\u7c7b\u4fee\u6539     <?php   if (!defined(‘IN_ECS’)) {     die(‘Hacking attempt’); }   class cls_mysql {     var $link_id    = NULL;       var $settings   = array();       var $queryCount = 0;     var $linkCount = 0;     var $queryTime  = ”;     var $queryLog   = array();       var $max_cache_time = 300; \/\/ \u6700\u5927\u7684\u7f13\u5b58\u65f6\u95f4\uff0c\u4ee5\u79d2\u4e3a\u5355\u4f4d       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;       var $mysql_config_cache_file_time = 0;       var $mysql_disable_cache_tables = array(); \/\/ \u4e0d\u5141\u8bb8\u88ab\u7f13\u5b58\u7684\u8868\uff0c\u9047\u5230\u5c06\u4e0d\u4f1a\u8fdb\u884c\u7f13\u5b58     var $config = array();       function __construct($config, $charset = ‘utf8’, $pconnect = 0, $quiet = 0)     {         $this->cls_mysql($config, $charset, $pconnect, $quiet);     }       function cls_mysql($config, $charset = ‘utf8’, $pconnect = 0, $quiet = 0)     {         if(!empty($config)) {             $config[‘charset’] = $charset;             $config[‘pconnect’] = $pconnect;             $this->config = $config;         }                  if (defined(‘EC_CHARSET’))         {             $charset = strtolower(str_replace(‘-‘, ”, EC_CHARSET));         }           if (defined(‘ROOT_PATH’) && !$this->root_path)         {             $this->root_path = ROOT_PATH;         }           $this->set_config($this->config);           if ($quiet)         {             $dbhost = $this->settings[‘dbhost’];             $dbuser = $this->settings[‘dbuser’];             $dbpw = $this->settings[‘dbpw’];             $dbname = $this->settings[‘dbname’];             $this->connect($dbhost, $dbuser, $dbpw, $dbname, $charset, $pconnect, $quiet);         }     }       \/\/\u968f\u673a\u5206\u914d\u6570\u636e\u5e93\u8fde\u63a5     function set_config($config) {         $sid = array_rand($config[‘master’]);         $settings = $config[‘master’][$sid];         $settings[‘sid’] = $sid;
\n\/\/www.ldhost.cn<\/span>         $settings[‘charset’] = $this->config[‘charset’];         $settings[‘pconnect’] = $this->config[‘pconnect’];         $this->settings = $settings;     }       function connect($dbhost, $dbuser, $dbpw, $dbname = ”, $charset = ‘utf8’, $pconnect = 0, $quiet = 0)     {         if ($pconnect)         {             if (!($this->link_id = @mysql_pconnect($dbhost, $dbuser, $dbpw)))             {                 if (!$quiet)                 {                     $this->ErrorMsg(“Can’t pConnect MySQL Server!”);                 }                   return false;             }         }         else         {             if (PHP_VERSION >= ‘4.2’)             {                 $this->link_id = @mysql_connect($dbhost, $dbuser, $dbpw, true);             }             else             {                 $this->link_id = @mysql_connect($dbhost, $dbuser, $dbpw);                   mt_srand((double)microtime() * 1000000); \/\/ \u5bf9 PHP 4.2 \u4ee5\u4e0b\u7684\u7248\u672c\u8fdb\u884c\u968f\u673a\u6570\u51fd\u6570\u7684\u521d\u59cb\u5316\u5de5\u4f5c             }             if (!$this->link_id)             {                 if (!$quiet)                 {                                       \/\/\u8fde\u63a5\u8d85\u8fc710\u6b21\uff0c\u4e2d\u65ad\u8fde\u63a5\uff0c\u629b\u51fa\u9519\u8bef                       if($this->linkCount>9){                         $this->ErrorMsg(“Can’t Connect MySQL Server!”);                     }                      $this->linkCount++;                     $this->del_error_link();                 }                   return false;             }         }           $this->dbhash  = md5($this->root_path . $dbhost . $dbuser . $dbpw . $dbname);         $this->version = mysql_get_server_info($this->link_id);           \/* \u5982\u679cmysql \u7248\u672c\u662f 4.1+ \u4ee5\u4e0a\uff0c\u9700\u8981\u5bf9\u5b57\u7b26\u96c6\u8fdb\u884c\u521d\u59cb\u5316 *\/         if ($this->version > ‘4.1’)         {             if ($charset != ‘latin1’)             {                 mysql_query(“SET character_set_connection=$charset, character_set_results=$charset, character_set_client=binary”, $this->link_id);             }             if ($this->version > ‘5.0.1’)             {                 mysql_query(“SET sql_mode=””, $this->link_id);             }         }           $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 = mysql_query(“SHOW VARIABLES LIKE ‘basedir'”, $this->link_id);                 $row    = mysql_fetch_assoc($result);                 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’) ||                 (PHP_VERSION >= ‘5.1’ && date_default_timezone_get() == ‘UTC’))             {                 $result = mysql_query(“SELECT UNIX_TIMESTAMP() AS timeline, UNIX_TIMESTAMP(‘” . date(‘Y-m-d H:i:s’, $this->starttime) . “‘) AS timezone”, $this->link_id);                 $row    = mysql_fetch_assoc($result);                   if ($dbhost != ‘.’ && strtolower($dbhost) != ‘localhost:3306’ && $dbhost != ‘127.0.0.1:3306’)                 {                     $this->timeline = $this->starttime – $row[‘timeline’];                 }                   if (PHP_VERSION >= ‘5.1’ && date_default_timezone_get() == ‘UTC’)                 {                     $this->timezone = $this->starttime – $row[‘timezone’];                 }             }               $content = ‘<‘ . “?php\\r\\n” .                        ‘$this->mysql_config_cache_file_time = ‘ . $this->starttime . “;\\r\\n” .                        ‘$this->timeline = ‘ . $this->timeline . “;\\r\\n” .                        ‘$this->timezone = ‘ . $this->timezone . “;\\r\\n” .                        ‘$this->platform = ‘ . “‘” . $this->platform . “‘;\\r\\n?” . ‘>’;               @file_put_contents($sqlcache_config_file, $content);         }           \/* \u9009\u62e9\u6570\u636e\u5e93 *\/         if ($dbname)         {             if (mysql_select_db($dbname, $this->link_id) === false )             {                 if (!$quiet)                 {                     $this->ErrorMsg(“Can’t select MySQL database!”);                 }                   return false;             }             else             {                 return true;             }         }         else         {             return true;         }     }       ……       \/* \u5220\u9664\u5931\u8d25\u8fde\u63a5*\/     function del_error_link(){         unset($this->config[‘master’][$this->settings[‘sid’]]);         $this->set_config($this->config);         $dbhost = $this->settings[‘dbhost’];         $dbuser = $this->settings[‘dbuser’];         $dbpw = $this->settings[‘dbpw’];         $dbname = $this->settings[‘dbname’];         $this->connect($dbhost, $dbuser, $dbpw, $dbname);     } }   <\/p>\n","protected":false},"excerpt":{"rendered":"

\u8bbe\u7f6eecshop\u6570\u636e\u5e93\u670d\u52a1\u5668\u5206\u79bb...<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4925],"tags":[],"class_list":["post-199404","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199404","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/comments?post=199404"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199404\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199404"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199404"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199404"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}