Best <?=$stitle?> Video Games - GameScoreBoard.com

userinfo['userid']; // $arSystemAbbr = had been set in gsbinit if (isset($_GET['system']) && $_GET['system']>=1 && $_GET['system']<=count($arSystemAbbr)) $system=(int)$_GET['system']; else $system=1; $gsbdb->query("SELECT systemName FROM gamecms_system WHERE systemid='$system'"); $gsbdb->next_record(); $systemname=$gsbdb->f('systemName'); if (isset($_GET['genre'])) { $genreid=(int)$_GET['genre']; if ($genreid > 1000) { $sql="SELECT maingenre FROM gamecms_genre WHERE genreid='".($genreid-1000)."'"; $gsbdb->query($sql); if ($gsbdb->next_record()) { $maingenre=$gsbdb->f('maingenre'); } else { $genreid=0; $maingenre=''; } } else { $sql="SELECT genre FROM gamecms_genre WHERE genreid='$genreid'"; $gsbdb->query($sql); if ($gsbdb->next_record()) { $genrename=$gsbdb->f('genre'); } else { $genrename=''; $genreid=0; } } } else $genreid=0; $arOrderBy=array('Gameplay','Graphic','Sound','Presentation','Innovation','Control','Story','Fun Factor','Value','Multiplayer','Overall'); if (isset($_GET['order']) && $_GET['order']>=0 && $_GET['order'] " /> Best <?=$stitle?> Video Games - GameScoreBoard.com

Filter by Genre: Order by:

0) { if ($genreid>1000) echo '(By Main Genre: '.$maingenre.')'; else echo '(By Genre: '.$genrename.')'; } ?>

'') $where.=" AND ge.maingenre='$maingenre'"; else $where.=" AND g.genreId='$genreid'"; } if (!isset($_GET['start'])) $start=1; else $start=max((int)$_GET['start'],1); $sql="SELECT count(*) AS reccnt". " FROM ". " (SELECT g.gameId, g.systemId, count(*) AS numreviews" . " FROM gamecms_gamescores gs" . " LEFT JOIN gamecms_game g ON gs.gameId=g.gameId" . " LEFT JOIN gamecms_genre ge ON g.genreId=ge.genreId". " WHERE g.deleted='0'". " AND gs.deleted='0'". $where. " GROUP BY g.gameId, g.systemId". " HAVING numreviews>1) qry"; $gsbdb->query($sql); if ($gsbdb->next_record()) $reccnt=$gsbdb->f('reccnt'); else $reccnt=0; switch ($order) { // $order didefine di paling atas case 0: $orderby='gameplay'; break; case 1: $orderby='graphic'; break; case 2: $orderby='sound'; break; case 3: $orderby='presentation'; break; case 4: $orderby='innovation'; break; case 5: $orderby='control'; break; case 6: $orderby='story'; break; case 7: $orderby='funfactor'; break; case 8: $orderby='value'; break; case 9: $orderby='online'; break; default: $orderby='overall'; } $sql="SELECT gs.gameId AS gameId, g.systemId AS systemId, g.gameName AS gameName, ". " s.systemName AS systemName, s.systemAbbrev, ge.genre AS genre,". " g.boxartfilename, g.releaseDate, g.relDateRegion,". " pub.companyName AS publisherName, dev.companyName AS developerName,". " avg(if(gs.gameplay_scr=0,NULL,gs.gameplay_scr)) AS gameplay, avg(if(gs.graphic_scr=0,NULL,gs.graphic_scr)) AS graphic," . " avg(if(gs.sound_scr=0,NULL,gs.sound_scr)) AS sound, avg(if(gs.control_scr=0,NULL,gs.control_scr)) AS control,". " avg(if(gs.presentation_scr=0,NULL,gs.presentation_scr)) AS presentation, avg(if(gs.innovation_scr=0,NULL,gs.innovation_scr)) AS innovation,". " avg(if(gs.story_scr=0,NULL,gs.story_scr)) AS story, avg(if(gs.funfactor_scr=0,NULL,gs.funfactor_scr)) AS funfactor," . " avg(if(gs.value_scr=0,NULL,gs.value_scr)) AS value, avg(if(gs.online_scr=0,NULL,gs.online_scr)) AS online," . " avg(if(gs.overall_scr=0,NULL,gs.overall_scr)) AS overall, count(*) AS numreviews" . " FROM gamecms_gamescores gs" . " LEFT JOIN gamecms_game g ON gs.gameId=g.gameId" . " LEFT JOIN gamecms_system s ON g.systemId=s.systemId". " LEFT JOIN gamecms_genre ge ON g.genreId=ge.genreId". " LEFT JOIN gamecms_pubdev pub ON g.publisherId=pub.companyId". " LEFT JOIN gamecms_pubdev dev ON g.developerId=dev.companyId". " WHERE g.deleted='0'". " AND gs.deleted='0'". $where. " GROUP BY g.gameId, g.systemId". " HAVING numreviews>1". " ORDER BY $orderby desc". " LIMIT ".($start-1).",20"; $gsbdb->query($sql); $cnthigh=$start-1; while ($gsbdb->next_record()) { $cnthigh++; $fgameid = $gsbdb->f('gameId'); $fsystemid = $gsbdb->f('systemId'); $fgamepic = $gsbdb->f('featuredpic'); $ftitle = htmlentities($gsbdb->f('gameName')); $fsystem = $gsbdb->f('systemName'); $fsysAbbrev = $gsbdb->f('systemAbbrev'); $fpublisher = $gsbdb->f('publisherName'); $fdeveloper = $gsbdb->f('developerName'); $fgenre = $gsbdb->f('genre'); $frelease = ($gsbdb->f('releaseDate')==0 || $gsbdb->f('releaseDate')=='' || $gsbdb->f('releaseDate')==NULL)? '': date('F j, Y',strtotime($gsbdb->f('releaseDate'))); $frelease1 = ($gsbdb->f('releaseDate')==0 || $gsbdb->f('releaseDate')=='' || $gsbdb->f('releaseDate')==NULL)? '': date('m/d/Y',strtotime($gsbdb->f('releaseDate'))); $frelDateRegion = $gsbdb->f('relDateRegion'); $fboxart = $gsbdb->f('boxartfilename'); $fnumreviews = $gsbdb->f('numreviews'); $fgameplay = $gsbdb->f('gameplay'); $fgraphic = $gsbdb->f('graphic'); $fsound = $gsbdb->f('sound'); $fpresentation = $gsbdb->f('presentation'); $finnovation = $gsbdb->f('innovation'); $fcontrol = $gsbdb->f('control'); $fstory = $gsbdb->f('story'); $ffunfactor = $gsbdb->f('funfactor'); $fvalue = $gsbdb->f('value'); $fonline = $gsbdb->f('online'); $foverall = $gsbdb->f('overall'); if ($fgameplay==NULL || $fgameplay==0) { $tgameplay='n/a'; } else { $tgameplay='

'.number_format($fgameplay,1).''; } if ($fgraphic==NULL || $fgraphic==0) { $tgraphic='n/a'; } else { $tgraphic='

'.number_format($fgraphic,1).''; } if ($fsound==NULL || $fsound==0) { $tsound='n/a'; } else { $tsound='

'.number_format($fsound,1).''; } if ($fpresentation==NULL || $fpresentation==0) { $tpresentation='n/a'; } else { $tpresentation='

'.number_format($fpresentation,1).''; } if ($finnovation==NULL || $finnovation==0) { $tinnovation='n/a'; } else { $tinnovation='

'.number_format($finnovation,1).''; } if ($fcontrol==NULL || $fcontrol==0) { $tcontrol='n/a'; } else { $tcontrol='

'.number_format($fcontrol,1).''; } if ($fstory==NULL || $fstory==0) { $tstory='n/a'; } else { $tstory='

'.number_format($fstory,1).''; } if ($ffunfactor==NULL || $ffunfactor==0) { $tfunfactor='n/a'; } else { $tfunfactor='

'.number_format($ffunfactor,1).''; } if ($fvalue==NULL || $fvalue==0) { $tvalue='n/a'; } else { $tvalue='

'.number_format($fvalue,1).''; } if ($fonline==NULL || $fonline==0) { $tonline='n/a'; } else { $tonline='

'.number_format($fonline,1).''; } if ($foverall==NULL || $foverall==0) { $toverall='n/a'; } else { $toverall='

'.number_format($foverall,1).''; } if ($cnthigh==$start) { if ($cnthigh==1) { ?>

'.$ftitle."\n"; ?>

'') && file_exists(_GSBPATH."/boxarts/".strtolower($fsysAbbrev)."/$fboxart")) $boxart=$fboxart; else $boxart="noboxart.gif"; ?>

System:
Publisher:
Developer:
Genre:
Release:	'') echo " ($frelDateRegion)"; ?>

Average Score: ( 1)? 'reviews':'review'; ?> compiled )
Gameplay:
Graphic:
Sound:
Presentation:
Innovation:
Control:
Story:
Fun Factor:
Value:
Multiplayer:
Overall:

1) { if (($cnthigh % 2)==0) { echo ''."\n"; } else { echo ''."\n"; } ?>

Rank

Game Title

Release

Genre

# Rev

'.$ftitle;?>

f($orderby)==NULL || $gsbdb->f($orderby)==0) echo 'n/a'; else echo number_format($gsbdb->f($orderby),1); ?>

Rank

Game Title

Release

Genre

# Rev

Sorry, there is no game for the selected criteria, please try another.

Only games with minimum 2 reviews being shown.

<< First"; } echo ' '; if ($start==1) { echo "< Prev"; } else { if ($start-20>1) $nstart=$start-20; else $nstart=1; echo "< Prev"; } echo ' '; if ($start+20>$reccnt) $estart=$reccnt; else $estart=$start+19; echo "Showing $start-$estart of $reccnt game(s) "; if ($start+20>$reccnt) { echo "Next >"; } else { $nstart=$start+20; echo "Next >"; } echo ' '; if ($start+20>$reccnt) { echo "Last >>"; } else { $nstart=$reccnt-19; echo "Last >>"; } echo ' '; echo "\n

\n"; } ?>