1
In file topten.php
---------------------
Change line 91 - 96
if(isset($HTTP_POST_VARS['rate']) or isset($HTTP_GET_VARS['rate'])){
$sort = _MD_RATING;
$sortDB = "rating";
INTO
if(isset($HTTP_GET_VARS['rate'])){
$sort = _MD_RATING;
$sortDB = "rating";
AND LINE 125
$query = "SELECT lid, cid, title, hits, rating, votes FROM ".$xoopsDB->prefix("myReviews_downloads")." WHERE status>0 AND rating>0 AND (cid=$cid";
INTO
$query = "SELECT lid, cid, title, hits, rating, votes FROM ".$xoopsDB->prefix(myReviews_downloads)." WHERE (status>0 AND rating>0 AND cid=$cid";
///////////////////////////////////////////////////////
Make the same changes in Onion.php,recommendit.php and loveit.php
Other errors: in onion.php,recommendit.php and loveit.php
remove ')' from line 40 this causes MySQL error 1064
FROM
$query .= ") ORDER BY ".$sortDB." ASC";
To
$query .= " ORDER BY ".$sortDB." ASC";
This ought to clear up some errors :o)