X-Cart forums

[jones]

Hi,

in next_prev.tpl you made corrected changes:

{* Previous *}
{if $prev.productid}
<div style="float:left;"><a href="product.php?productid={$prev.productid}&cat={$cat}" title="{$prev.product}"><img src="{$ImagesDir}/larrow.gif" width=9 height=9 border=0 alt="{$lng.lbl_prev_page}"> {$prev.product}</a></div>
{/if}

{* Next *}
{if $next.productid}
<div style="float:right;"><a href="product.php?productid={$next.productid}&cat={$cat}" title="{$next.product}">{$next.product} <img src="{$ImagesDir}/rarrow.gif" width=9 height=9 border=0 alt="{$lng.lbl_next_page}"></a></div>
{/if}

<br><br>

in product.php it must be:

// === Next - Previous products from xCartMod.com ===

if ($cat != "")
    $xcat = $cat;
else
    $xcat = $product_info["categoryid"];

$mem_list = func_query("SELECT pr.productid, pr.product, mem.membershipid FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products] AS pr LEFT JOIN $sql_tbl[product_memberships] AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '$xcat' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");

$list = array();
......

Alex

[clik]

Thanks Alex!

It works like magic

The code looks like this right now (there is no membership):

if ($cat != "")
    $xcat = $cat;
else
    $xcat = $product_info["categoryid"];
	
$mem_list = func_query("SELECT pr.productid, pr.product FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products] AS pr WHERE cat.categoryid = '$xcat' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");

$list = array();

Thanks!

[jones]

Yes...for membership code must be:

if ($cat != "")
     $xcat = $cat;
else
    $xcat = $product_info["categoryid"];
    
$mem_list = func_query("SELECT pr.productid, pr.product, mem.membershipid FROM $sql_tbl[products_categories] AS cat, $sql_tbl[products] AS pr LEFT JOIN $sql_tbl[product_memberships] AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '$xcat' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.product");

$list = array();

Alex

[royng]

I am lost, can someone please tell me the location of the files need to be change.
Ex. Customer>xxx.html
And is that possilble to add "view all" too?

Thanks!
X-Cart version 4.1.11

[royng]

I guess No one know the view all option.

[info@sjidesign.com]

Hi

Great mod,

Can this be done so that instead of going to the next product (alphabetically) as the code does at the moment then it goes through to the next product by the number they are listed in the category position order?

e.g. I have 3 products

Football
Tennis Racket
Golf Club

They are set to be listed in this order: Football 1 (product number 20) Tennis Racket 2 (product number 3) Golf Club 3 (product number 9)

So I need to go throguh from football, tennis racket, golf club.

Thanks in advance

Dan

[jones]

Hi Dan,

You can change it easy:

in product.php add "cat.orderby," in this query:

// === Next - Previous products from xCartMod.com ===

$mem_list = func_.... ORDER BY cat.orderby, pr.product");

$list = array();
......

Alex

[info@sjidesign.com]

Hi Alex,

Thank you very much for the reply but when I put that code in my product.php I get the error.

INVALID SQL: 1054 : Unknown column 'pr.orderby' in 'order clause'
SQL QUERY FAILURE:SELECT pr.productid, pr.product, mem.membershipid FROM xcart_products_categories AS cat, xcart_products AS pr LEFT JOIN xcart_product_memberships AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '71' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.orderby, pr.product


Any ideas what's wrong?

Thanks again for your help.

Regards

Dan

[jones]

Hi Dan,

Sorry, I slipped. Need to add "cat.orderby,".

Alex

Originally Posted by info@sjidesign.com

Hi Alex,

Thank you very much for the reply but when I put that code in my product.php I get the error.

INVALID SQL: 1054 : Unknown column 'pr.orderby' in 'order clause'
SQL QUERY FAILURE:SELECT pr.productid, pr.product, mem.membershipid FROM xcart_products_categories AS cat, xcart_products AS pr LEFT JOIN xcart_product_memberships AS mem ON mem.productid = pr.productid WHERE cat.categoryid = '71' AND pr.productid = cat.productid AND pr.forsale='Y' ORDER BY pr.orderby, pr.product


Any ideas what's wrong?

Thanks again for your help.

Regards

Dan

[info@sjidesign.com]

Hi Alex,

Thank you very much, it worked perfectly

I really appreciate your help.

Thank you again.

Regards

Dan