chrometweaks.org

How do I unsubscribe to my iPage account?

Click Here To View All Answers...


Got a quick question: How do I unsubscribe to my iPage account? Many thanks for any response. Second question.. How can I make osC display random products instead of new products on the index page?..

Comments (78)

I'm stumped. I'm not so sure what is the answer to that question. I'll do some research in Google and get back to you if I find an useful answer. You should email the people at iPage as they probably could give you an answer..

Comment #1

The contribution.

Featured Products.

Works well. It allows you to display only the products you specify...

Comment #2

I will give this a try. Where can I find the code you are making refrence to. the file name will suffice..

Thank you in advance...

Comment #3

Thank you Kem your Tip worked for me also, I changed the upmentioned thing in a file include/modules/new_products.php and it's workingggggg yeahhhhh.

Thanks great tip..

Comment #4

And if someone wants to change the number of the product listed you can edit the same file line 21.

The value MAX_DISPLAY_NEW_PRODUCTS to a number of the products you want to be listed on that page.

And then find at the end of the file.

If ($col > 3) {.

$col = 0;.

$row ++;.

And change >3 to the number of the rows you want +1 (if you want two rows then put number three) at least it worked for me this way..

Comment #5

I find 'order by' in 2 places what do I change? and there is all this after it 'p.products_date_added desc limit' not sure what to change. could you help...

Comment #6

I have 2 columns and 5 rows that displays 9 products which is obviously an odd number..

I would like to display.

10 products randomly.

Which is why I came to this thread but my code doesnt make sense to me would anyone be able to put me straight please ? .

Many thanks in advance - this is taken from catalog\includes\modules\new_products.php.

If ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {.

$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id where products_status = '1' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

} else {.

$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from "TABLE_PRODUCTS" p left join "TABLE_SPECIALS" s on p.products_id = s.products_id, "TABLE_PRODUCTS_TO_CATEGORIES" p2c, "TABLE_CATEGORIES" c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '"(int)$new_products_category_id"' and p.products_status = '1' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);.

}.

$row = 0;.

$col = 0;..

Comment #7

How can I make osC display random products instead of new products on the index page?..

Comment #8

Here's the tips:.

Look for order by ... (say, products_name).

Then change it to.

Order by RAND().

Ken..

Comment #9


This question was taken from a support group/message board and re-posted here so others can learn from it.