Quote:
|
Originally Posted by junaid
please let me know can it made with just last category we were on as it seems cart taking more time to load with sql above may be im wrong.
|
Try change in "
cart.php" code for universal solution "Continue Shopping Button" by this:
PHP Code:
#back URL when cont. shoping:
x_session_register("back_url");
if ($mode == "add")
{
$back_url = $_SERVER['HTTP_REFERER'];
$id = intval($productid);
if ($id>0) {
$cat_path = func_query_first_cell("select categoryid_path from $sql_tbl[products_categories], $sql_tbl[categories] where (productid = $id)and(main='Y')and($sql_tbl[products_categories].categoryid=$sql_tbl[categories].categoryid)");
if (!empty($cat_path)) {
$cats_path = split("/ *",$cat_path);
if (!empty($cats_path[0])) {
$last = end($cats_path);
$back_url = "home.php?cat=".$last;
}
}
}
}
$smarty->assign("back_url", $back_url);
This modification just add one sql query (On load the page X-cart makes 80-140 query to DB
).