批量修改zencart型号：品牌名称+型号格式

将下面代码保存为zc_change_model.php，上传到网站根目录运行即可，操作前先备份数据库

     Execute($products_query);$id_array = array();while(!$products->EOF){    $id_array[] = $products->fields['products_id'];    $products->MoveNext();     }foreach($id_array as $val){    $manufacturer = $db->Execute("select p.products_id, m.manufacturers_name from " . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS . " p where m.manufacturers_id = p.manufacturers_id and p.products_id = '".(int)$val."' limit 0,1");    if($manufacturer->fields['manufacturers_name']){        $manufacturer_name = $manufacturer->fields['manufacturers_name'];        $products=$db->Execute("update " . TABLE_PRODUCTS . " set products_model = CONCAT('{
   $manufacturer_name}-', products_model) where products_id = " . (int)$val);    }}echo 'OK!处理完毕';require(DIR_WS_INCLUDES . 'application_bottom.php');?>