X-Cart forums

[plnewton]

Is there anyway to create another products_t.tpl, and somehow display products that are currently "hidden"? I want to make a list of these, and display them. Is that possible?

also, it needs to be linked via href and do a search and use SKU field as the search string. Is this possible?

[cflsystems]

Yes it is possible. It will require php and template changes. I can get this done for you, you can email me at the email in my signature

[plnewton]

instead of soliciting on this forum, do you mind helping a fellow programmer out?

[cflsystems]

Wow. Thank you very much. Now I almost don't wanna help you. You asked if it's possible, I answered - yes it is possible. You need to edit search.php and query the hidden products, assign the result so smarty and call the template you want to use to show result

[plnewton]

How do I go about listing the hidden products on say a products_t.tpl? What code would I use to display hidden products?

[plnewton]

How do I edit search.php to query the hidden products? Sorry, I'm new to this, and your response of hiring you once pretty quick. If you help me out, I'll be sure to turn to you for advice or hiring in the future. I hardly know this stuff yet.

[totaltec]

Don't piss Steve off, it will come back to haunt you.....

Do you want to do this in a category, or in featured products?

The logic here would be to query the database for the table xcart_products.
In your php file:

$newtons_query = "SELECT * FROM $sql_tbl[products] WHERE forsale = 'H' "; 
$hidden_products = func_query($newtons_query);
//Assign the hidden_products variable (array)
$smarty->assign('hidden_products', $hidden_products);

--Untested

The best way to see what is getting included in your assigned variable is to use webmaster mode, in the variables view of the debug window.

[plnewton]

I'm wanting to duplicate products_t.tpl to say products_t_rightside.tpl, include this file into customer_manufacturer_products.tpl, and display those hidden products on products_t_rightside.tpl....


Then, when one of the hidden products is clicked on, I want it to run a search for the SKU number OF that hidden product that's shown and has a link for it. - Is this possible?

[plnewton]

Where do I paste this code? Which file? Search.php? ;
$newtons_query = "SELECT * FROM $sql_tbl[products] WHERE forsale = 'H' "; $hidden_products = func_query($newtons_query); //Assign the hidden_products variable (array) $smarty->assign('hidden_products', $hidden_products);

[plnewton]

I added ;
$newtons_query = "SELECT * FROM $sql_tbl[products] WHERE forsale = 'H' "; $hidden_products = func_query($newtons_query); //Assign the hidden_products variable (array) $smarty->assign('hidden_products', $hidden_products);

to manufacturer.php,

then i did {$hidden_products}, but all it's displaying is "Array". Am I doing this wrong? Please help!