Hi ChriTERIS,
I apply your hack in my local vbulletin, using
this style but i have error like this
Code:
Database error in vBulletin 4.1.5:
Invalid SQL:
SELECT AVG(vb_microclassifieds_orders.sreviewrating) AS thisrating,
vb_user.* AS thisprofile
FROM vb_microclassifieds_orders
JOIN vb_user
ON vb_user.userid=vb_microclassifieds_orders.sellerid
WHERE vb_microclassifieds_orders.sreviewrating>0
GROUP BY vb_microclassifieds_orders.sellerid
ORDER BY vb_microclassifieds_orders.sreviewrating DESC
LIMIT 5;
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AS thisprofile
FROM vb_microclassifieds_orders
' at line 2
Error Number : 1064
Please help me.. thanks.