<?php

header("content-Type: text/html; charset=utf-8");

/***

批量恢复zencart产品表master_categories_id为0的产品

***/

require('includes/application_top.php');

echo '正在处理...';

$products_query = "select products_id from " . TABLE_PRODUCTS . " where master_categories_id = '0' order by products_id";

$products = $db->Execute($products_query);

$id_array = array();

while(!$products->EOF){

    $id_array[] = $products->fields['products_id'];

    $products->MoveNext();

}

foreach($id_array as $val){

    $categories_id = $db->Execute("select categories_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where products_id = '".(int)$val."' limit 0,1");

    if($categories_id->fields['categories_id']){

        $products=$db->Execute("update " . TABLE_PRODUCTS . " set master_categories_id = '" .$categories_id->fields['categories_id']. "' where products_id = " . (int)$val);

    }

}

echo 'OK!处理完毕';

require(DIR_WS_INCLUDES . 'application_bottom.php');

?>