} else {
$where_clause = "1=1";
}
}
}
//Get config options
$config_res = DB_query("SELECT * FROM {$_TABLES['ecom_config']}");
$config_row = DB_fetchArray($config_res);
//Get start item
if (isset($_GET['page'])) {
$item_start = $page * $config_row['item_per_page'] - $config_row['item_per_page'];
} else {
$item_start = 0;
}
//Draw Products
$res = DB_query("SELECT * FROM {$_TABLES['ecom_item']} WHERE " . $where_clause . $s->get_sql_sort() . " LIMIT " . $item_start . ", " . $config_row['item_per_page'] . "");
while ($row = DB_fetchArray($res)) {
$res_comments = DB_Query("SELECT ID FROM {$_TABLES['ecom_item_rating']} WHERE item_id = " . $row['ecom_item_id'] . "");
$num_comments = DB_numRows($res_comments);
$T->set_var('image', $_ECOM_CONF['item_images'] . $row['ecom_item_picture_small']);
$T->set_var('name', $row['ecom_item_name']);
$T->set_var('num_comments', $num_comments);
if ($config_row['item_picture_small_enable']) {
$T->set_var('image_autosize', true);
$T->set_var('image_width', $config_row['item_picture_width_small']);
$T->set_var('image_height', $config_row['item_picture_height_small']);
} else {
$T->set_var('image_autosize', false);
}
$T->set_var('fixxedPrice', $row['ecom_item_priceFixxed'] == true ? true : false);
$T->set_var('price', '$' . number_format($row['ecom_item_price'], 2));
