{"id":199176,"date":"2025-05-03T14:05:46","date_gmt":"2025-05-03T06:05:46","guid":{"rendered":"https:\/\/server.hk\/cnblog\/199176\/"},"modified":"2025-05-03T14:05:46","modified_gmt":"2025-05-03T06:05:46","slug":"shopex%e8%bd%ac%e5%88%b0ecshop%e5%90%8e%ef%bc%8c%e5%95%86%e5%93%81%e7%9b%b8%e5%86%8c%e5%9b%be%e7%89%87%e6%95%b0%e6%8d%ae%e9%87%8d%e5%a4%8d%e7%9a%84%e8%a7%a3%e5%86%b3","status":"publish","type":"post","link":"https:\/\/server.hk\/cnblog\/199176\/","title":{"rendered":"Shopex\u8f6c\u5230Ecshop\u540e\uff0c\u5546\u54c1\u76f8\u518c\u56fe\u7247\u6570\u636e\u91cd\u590d\u7684\u89e3\u51b3"},"content":{"rendered":"

 <?php<\/span><\/p>\n

define(‘IN_ECS’, true);<\/p>\n

require(dirname(__FILE__) . ‘\/includes\/init.php’);
 $q = $db->getAll(“SELECT DISTINCT `img_url` FROM “. $ecs->table(‘goods_gallery’));
 foreach($q as $key => $val){
  $c = intval($db->getOne(“SELECT count(0) FROM “. $ecs->table(‘goods_gallery’) .” WHERE img_url='”. $val[‘img_url’] .”‘”));
  if($c>1){
   $c = intval($db->getOne(“SELECT img_id FROM “. $ecs->table(‘goods_gallery’) .” WHERE img_url='”. $val[‘img_url’] .”‘ ORDER BY img_id LIMIT 0,1″));
   if($c>0){
    $sql = “DELETE FROM ” . $ecs->table(‘goods_gallery’) . ” WHERE img_id <> “. $c .” and img_url='”. $val[‘img_url’] .”‘”;
    $db->query($sql);
   }
  }
 }
?><\/p>\n

\u5c06\u4ee5\u4e0a\u5185\u5bb9\u4fdd\u5b58\u6210\u4e3a\u4e00\u4e2aphp\u6587\u4ef6 \u8fd0\u884c\u5373\u53ef<\/p>\n","protected":false},"excerpt":{"rendered":"

 <?php d...<\/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-199176","post","type-post","status-publish","format-standard","hentry","category-4925"],"_links":{"self":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199176","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=199176"}],"version-history":[{"count":0,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/posts\/199176\/revisions"}],"wp:attachment":[{"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/media?parent=199176"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/categories?post=199176"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/server.hk\/cnblog\/wp-json\/wp\/v2\/tags?post=199176"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}