[qpurser]

Originally Posted by ChrisTERiS

Do you know about the nervous laughing?? .... This is how I'm right now. I don't believe what childish error is, but because is also normal mysql syntax, it does not produces any error.

When I'll be able to stop laughing, I'll correct it

Chris

It is just weird the star rating is getting updated perfectly but not the reviews when they are stored in the DB (and yes they get stored. I saw them)
And it has nothing to do with the cron job?
Only thing I could find in there was about the rating but not about the reviews:
// Calculate the allowed time for rating
$maxdays = $vbulletin->options["microclassifieds_rating_limit"];
$timenow = time();
$timelimit = $timenow - ($maxdays * 86400);
// Update records for selldate >= timelimit
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."microclassifieds_orders SET allowrating=0, showrating=1 WHERE selldate<=$timelimit");
// Also update records where Seller and Buyer have rate each other, even if timelimit hasn't expired
$vbulletin->db->query_write("UPDATE ".TABLE_PREFIX."microclassifieds_orders SET allowrating=0, showrating=1 WHERE breviewrating>0 AND sreviewrating>0");