zencart新增分类字段步骤 ALTER TABLE `categories` ADD `related_categories` VARCHAR( 255 ) NOT NULL , ADD `related_products` VARCHAR( 255 ) NOT NULL;
2.修改admin\categories.php $insert_sql_data = array('parent_id' => $current_category_id, 'date_added' => 'now()'); 改为 $insert_sql_data = array('parent_id' => $current_category_id, 'date_added' => 'now()', 'related_categories'=>$_POST['related_categories'], 'related_products'=>$_POST['related_products']);
$update_sql_data = array('last_modified' => 'now()'); 改为 $update_sql_data = array('last_modified' => 'now()','related_categories'=>$_POST['related_categories'],'related_products'=>$_POST['related_products']);
大概776行 $contents[] = array('text' => '<br />' . TEXT_CATEGORIES_DESCRIPTION . $category_inputs_string); 下面一行新增 $contents[] = array('text' => '<br />关联分类ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_categories', '', zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name'))); $contents[] = array('text' => '<br />关联产品ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_products', '', zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name')));
$contents[] = array('text' => '<br />' . TEXT_CATEGORIES_DESCRIPTION . $category_inputs_string); 下面一行新增 $contents[] = array('text' => '<br />关联分类ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_categories', zen_get_related_categories($cInfo->categories_id), zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name'))); $contents[] = array('text' => '<br />关联产品ID(ID之间用英文半角逗号隔开)<br />' . zen_draw_input_field('related_products', zen_get_related_products($cInfo->categories_id), zen_set_field_length(TABLE_CATEGORIES_DESCRIPTION, 'categories_name')));
<?php function zen_get_related_categories($category_id) { global $db; $category = $db->Execute("select related_categories from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_categories']; } function zen_get_related_products($category_id) { global $db; $category = $db->Execute("select related_products from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_products']; } ?>
4.前台显示新增字段,includes\functions\extra_functions\目录下新建文件extra_functions.php 写入以下代码: <?php function zen_get_related_categories($category_id) { global $db; $category = $db->Execute("select related_categories from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_categories']; } function zen_get_related_products($category_id) { global $db; $category = $db->Execute("select related_products from " . TABLE_CATEGORIES . " where categories_id = '" . (int)$category_id . "'"); return $category->fields['related_products']; } ?> 接着,在前台页面tpl_index_categories.php、tpl_index_product_list.php里面适当位置调用新增字段值 echo zen_get_related_categories($current_category_id); echo zen_get_related_products($current_category_id); 打完收工! (责任编辑:最模板) |