Help with Review Hack

[ULTIMATESSJ]

I am writing my own vBulletin Integrated Review Script for my anime site which outputs a modified thread with new fields and places all the variables on a non-vb page, along with all necessary vBulletin things, such as vBCode and Smilies. One problem i have with my script however is that i have no way in defining an average review score. Can someone tell me how i would be able to do this?

I have added "animerating" into my "post" table. What i want to do is get all the scores from the fields in the post table, make them an average, and place the final score into the thread table under, say "averagerating". Where and how would i place this?

[ULTIMATESSJ]

bump -_-

(seems to be a reoccuring thing)

[Craigr]

You could do something like this:
SELECT AVG(column) AS number FROM reviews

Craig

[ULTIMATESSJ]

how would this work exactly?

[g-force2k2]

You would first have to select all the fields from the post, ie.

$ratefields = "field1,field2" ; // replace field1 and field2 with the names of the colums from the post table that you want
// seperate entries with a comma
// $postid varibable should be defined before this code

$ratearray = explode ( ",", $ratefields ) ;
$numofrate = count ( $ratearray ) ;
$ratequery = implode ( ", ", $ratearray ) ;

$r = $DB_site->query_first ( "SELECT " . $ratequery . " FROM post WHERE postid=" . $postid ) ;

$totalrate = 0 ;
foreach ( $ratearray AS $rating ) :
$totalrate += $r["$rating"] ;
endforeach ;

$avgrate = round ( $totalrate / $numofrate, 2 ) ;

Has not been tested but should work, if you have any problems I will help you debug it.

Regards,
g-force2k2

[ULTIMATESSJ]

What file is this intended for? I have placed it in my non-vb file and i don't get anything come from it.