vb.org Archive - Help with Review Hack

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Member Archives (https://vborg.vbsupport.ru/forumdisplay.php?f=202)

- - Help with Review Hack (https://vborg.vbsupport.ru/showthread.php?t=59246)

ULTIMATESSJ

12-17-2003 11:45 PM

Help with Review Hack

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

12-22-2003 11:03 PM

bump -_-

(seems to be a reoccuring thing)

Craigr

12-23-2003 12:24 PM

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

Craig

ULTIMATESSJ

12-23-2003 10:59 PM

how would this work exactly?

g-force2k2

12-24-2003 09:58 AM

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

PHP Code:


		
			
$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

12-24-2003 11:53 PM

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

All times are GMT. The time now is 02:00 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01027 seconds Memory Usage 1,721KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: