Dennis_gull Posted March 10, 2007 Share Posted March 10, 2007 Hey, I uploaded ajax_rating_bar_v1-1 for oscommerce.zip (ajax vote system) yesterday but it got removed. I showed a link to the provider of ajax_rating_bar_v1-1 (which he wanted) so I thought it was fine. Quote Link to comment Share on other sites More sharing options...
Dennis_gull Posted March 11, 2007 Author Share Posted March 11, 2007 haha okay I now know why the contribution got deleted. Anyways will correct it and add a top 10 rated product list to it :) Quote Link to comment Share on other sites More sharing options...
Guest Posted September 3, 2007 Share Posted September 3, 2007 hi. great contrib. installed and modified it for my shop, works all fine. except 1 little thing. the top_rating.php module does not show any rated products at all. sometimes it shows up 1 product which has not yet been rated but it never shows my top 10? could anyone please help out with this problem? i don't know what is wrong with the sql-query. tried several "solutions" but nothing worked for me :-( Quote Link to comment Share on other sites More sharing options...
sonixtwo Posted June 30, 2008 Share Posted June 30, 2008 hi. great contrib. installed and modified it for my shop, works all fine. except 1 little thing. the top_rating.php module does not show any rated products at all. sometimes it shows up 1 product which has not yet been rated but it never shows my top 10? could anyone please help out with this problem? i don't know what is wrong with the sql-query. tried several "solutions" but nothing worked for me :-( I am having the same problem. I am using php 4.4 and mysql 5.0. It has to do with the following lines not being compatible with mysql 5.0 $rating_query = tep_db_query("select p.products_id, pd.products_name, p.products_image, p.products_model, p.products_tax_class_id, p.products_price, s.specials_new_products_price, r.* from " . TABLE_PRODUCTS . " p inner join " . TABLE_SPECIALS . " s on p.products_id = s.products_id right join " . TABLE_PRODUCTS_DESCRIPTION . " pd on p.products_id = pd.products_id inner join rating r on p.products_id = r.id where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' ORDER BY average DESC LIMIT 0, 10"); $rating_query = tep_db_query("select p.products_id, p.products_image, p.products_model, p.products_tax_class_id, p.products_price, s.specials_new_products_price, r.* from " . TABLE_PRODUCTS . " p inner join " . TABLE_SPECIALS . " s on p.products_id = s.products_id right join " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c on p.products_id = p2c.products_id join rating r on p.products_id = r.id, " . TABLE_CATEGORIES . " c where p.products_status = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' ORDER BY average DESC LIMIT 0, 10"); I believe the new mysql syntax requires parenthesis to handle the joins correctly, but where they go, I do not know. If someone could post fixes for those 2 lines, it would be greatly appreciated. Thanks Quote Link to comment Share on other sites More sharing options...
Kennith Posted February 5, 2010 Share Posted February 5, 2010 Hi I've installed this and it's working fine in FireFox but in IE 8 the stars dosen't show up anyone have an idea about why? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.