Jump to content
Latest News: (loading..)
Sign in to follow this  
Dennis_gull

What happened to ajax vote system?

Recommended Posts

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×