X-Cart forums

[loopsound]

Thanks to PhilJ I am now able to use the provider username as a variable in my product information however I am stuck when it comes to how to get it to display in the product list.

In product.php

$product_owner = addslashes($product_info['provider']);
if (!empty($product_owner)) {
    $provider_info = func_query_first("SELECT id, login, title, firstname, lastname FROM $sql_tbl[customers] WHERE id='$product_owner' AND usertype IN ('P','A')");
    $smarty->assign('provider_info', $provider_info);
}

then in product.tpl and products.tpl

{$provider_info.login}

But nothing displays in the product list only the product pages? Anyone know how adapt the following to make it display in the products list? I have contacted PhilJ but I am aware he is very busy at the moment

[PhilJ]

See below...

[loopsound]

Sorry Phil,

Placed code in products.php and {$product.login} in products_t.tpl and products_audio.tpl and the value returned just says "Array" ?

Anything else, I can try? Seems strange that X-Cart don't have this by default anyway.

[PhilJ]

ok, use...

if($products) {
foreach($products as $key=> $product)
$products[$key]["login"] = func_query_first_cell("SELECT login FROM $sql_tbl[customers] WHERE id=".$product["provider"]);
}

And use {$product.login}

Tested and working.

[loopsound]

You star! Perfect! And now everyone will get the benefits of this

Thanks so much