zen_get_products_category_id($products_id)
该函数返回一个商品所在目录的ID,输入参数为商品的ID。返回的ID一般都是做zen_get_category_name函数的参数。
主要查询了 products 表。在includes/database_tables.php中定义:
define(‘TABLE_PRODUCTS’, DB_PREFIX . ‘products’);function zen_get_products_category_id($products_id) {
global $db;
$the_products_category_query = "select products_id, master_categories_id from " . TABLE_PRODUCTS . " where products_id = '" . (int)$products_id . "'";
$the_products_category = $db->Execute($the_products_category_query);
return $the_products_category->fields['master_categories_id'];
}
zen_get_categories_image($what_am_i)
该函数返回目录的图片,这个照片是在添加一个目录的时候的可选项。输入参数为目录的ID
主要查询了 categories 表。在includes/database_tables.php中定义:
define(‘TABLE_CATEGORIES’, DB_PREFIX . ‘categories’);function zen_get_categories_image($what_am_i) {
global $db;
$the_categories_image_query= "select categories_image from " . TABLE_CATEGORIES . " where categories_id= '" . $what_am_i . "'";
$the_products_category = $db->Execute($the_categories_image_query);
return $the_products_category->fields['categories_image'];
}
zen_get_categories_name($who_am_i)
该函数返回目录的名字,输入参数为目录的ID。
主要查询了 categories_description 表。在includes/database_tables.php中定义:
define(‘TABLE_CATEGORIES_DESCRIPTION’, DB_PREFIX . ‘categories_description’);function zen_get_categories_name($who_am_i) {
global $db;
$the_categories_name_query= "select categories_name from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id= '" . $who_am_i . "' and language_id= '" . $_SESSION['languages_id'] . "'";
$the_categories_name = $db->Execute($the_categories_name_query);
return $the_categories_name->fields['categories_name'];
}