where can I found the select for the feature homeproducts

[deech123]

Hi guys,

where can I find in the code the select for the feature products?
I can not find them in the module/homefeatured.

I just want to change the order sequence to RAND().

I know there are modules made but not ready for the V1.3.

so thanks for any clue to find the correct select statement where I can change the order by .

[SpyrosT]

I use the 1.3.0.1 which was the first beta.
The "Featured Products on the homepage v0.93" by Nomman works fine

[rocky]

You can also change line 69 of modules/homefeatured/homefeatured.php from:

$products = $category->getProducts(intval($params['cookie']->id_lang), 1, ($nb ? $nb : 10));

to:

$products = $category->getProducts(intval($params['cookie']->id_lang), 1, ($nb ? $nb : 10), 'position', 'ASC', false, true, true, ($nb ? $nb : 10));

[deech123]

Rocky,

that you very much.
this works like a charm.
and since I prefer to change the code, .....thanks.

now my last problem, the required tva field in making an account (required in Europe if you do business with companies).
look here
http://www.prestashop.com/forums/viewthread/57226/configuring___using_prestashop/belgian_tva_number_on_new_account

thanks for your help...much appriciated