What happened to ajax vote system?

[Dennis_gull]

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.

[Dennis_gull]

haha okay I now know why the contribution got deleted. Anyways will correct it and add a top 10 rated product list to it :)

[Guest]

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 :-(

[sonixtwo]

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

[Kennith]

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?