EOM;
$query2 ="SELECT * FROM game_list WHERE times_played <> '' AND enabled = '1' ORDER BY times_played DESC LIMIT $max_items";
//print "Q: $query2 ";
$result2 = mysqli_query($dbcon, $query2) or die(mysqli_error());
//print "RESULT: $result2 ";
$cellcounter = 0;
print <<
Most Popular Games
EOM;
while ($myrow = mysqli_fetch_array($result2)) {
// get the vars
$game_id = trim($myrow['game_id']);
$display_name = trim($myrow['display_name']);
$image_name = trim($myrow['image_name']);
$times_played = trim($myrow['times_played']);
$rating = trim($myrow['rating']);
$ratimg = round($rating) . "stars";
$display_name = preg_replace('|-|', ' ', $display_name);
// correct for missing icons
if($image_name == "stand_in.jpg"){
$image_name = image_picker();
}
print <<
EOM;
$cellcounter++;
$itemcounter++;
if($cellcounter == $max_across){
print " \n";
$cellcounter = 0;
if($itemcounter != $max_items){
print "\n";
}
}
}
if($cellcounter == '1'){print " | | ";}
if($cellcounter == '2'){print " | ";}
print " \n";
// set extra-high number for results to make up for
// the ones already displayed in the icon table
$RLIMIT = 30;
//print "Other most-popular games....";
// add list of link of additional games after table
$list_query = "SELECT display_name, game_id FROM game_list WHERE enabled = '1' ORDER BY times_played DESC LIMIT $RLIMIT";
//print "Q: $list_query ";
$list_result = mysqli_query($dbcon, $list_query) or die(mysqli_error());
//print "RESULT: $list_result ";
$tcount = 0;
while ($list_row = mysqli_fetch_array($list_result)) {
$tcount++;
// skip the first ones that are already displayed
if($tcount < ($max_items + 1)){continue;}
$display_name = preg_replace('|-|', ' ', $list_row['display_name']);
print " $display_name * ";
}
print " ... more ...";
print " \n";
////////////////////////////////////
// get highest rated
// how many items to display?
// total is max_across * max_down
$max_across = 3;
$max_down = 4;
$max_items = ($max_across * $max_down);
print <<
EOM;
$query3 ="SELECT * FROM game_list WHERE rating <> '' AND enabled = '1' ORDER BY rating DESC LIMIT $max_items";
//print "Q: $query3 ";
$result3 = mysqli_query($dbcon, $query3) or die(mysqli_error());
//print "RESULT: $result3 ";
$cellcounter = 0;
print <<
Highest Rated Games
EOM;
while ($myrow = mysqli_fetch_array($result3)) {
// get the vars
$game_id = trim($myrow['game_id']);
$display_name = trim($myrow['display_name']);
$image_name = trim($myrow['image_name']);
$times_played = trim($myrow['times_played']);
$rating = trim($myrow['rating']);
$ratimg = round($rating) . "stars";
$display_name = preg_replace('|-|', ' ', $display_name);
// correct for missing icons
if($image_name == "stand_in.jpg"){
$image_name = image_picker();
}
print <<
EOM;
$rating = 0;
$cellcounter++;
$itemcounter++;
if($cellcounter == $max_across){
print " \n";
$cellcounter = 0;
if($itemcounter != $max_items){
print "\n";
}
}
}
if($cellcounter == '1'){print " | | ";}
if($cellcounter == '2'){print " | ";}
print " \n";
//print "Other highest-rated games....";
// add list of link of additional games after table
$list_query = "SELECT display_name, game_id FROM game_list WHERE enabled = '1' ORDER BY rating DESC LIMIT 22";
//print "Q: $list_query ";
$list_result = mysqli_query($dbcon, $list_query) or die(mysqli_error());
//print "RESULT: $list_result ";
$tcount = 0;
while ($list_row = mysqli_fetch_array($list_result)) {
$tcount++;
// skip the first ones that are already displayed
if($tcount < ($max_items + 1)){continue;}
$display_name = preg_replace('|-|', ' ', $list_row['display_name']);
print " $display_name * ";
}
print " ... more ...";
print " \n";
////////////////////////////////////
// get newest games by date
// how many items to display?
// total is max_across * max_down
$max_across = 3;
$max_down = 3;
$max_items = ($max_across * $max_down);
$query2 ="SELECT * FROM game_list WHERE enabled = '1' ORDER BY add_date DESC LIMIT $max_items";
//print "Q: $query2 ";
$result2 = mysqli_query($dbcon, $query2) or die(mysqli_error());
//print "RESULT: $result2 ";
$cellcounter = 0;
print <<
Newest Games
EOM;
while ($myrow = mysqli_fetch_array($result2)) {
// get the vars
$game_id = trim($myrow['game_id']);
$display_name = trim($myrow['display_name']);
$image_name = trim($myrow['image_name']);
$times_played = trim($myrow['times_played']);
$rating = trim($myrow['rating']);
$ratimg = round($rating) . "stars";
$display_name = preg_replace('|-|', ' ', $display_name);
// correct for missing icons
if($image_name == "stand_in.jpg"){
$image_name = image_picker();
}
print <<
EOM;
$cellcounter++;
$itemcounter++;
if($cellcounter == $max_across){
print " \n";
$cellcounter = 0;
if($itemcounter != $max_items){
print "\n";
}
}
}
if($cellcounter == '1'){print " | | ";}
if($cellcounter == '2'){print " | ";}
print " \n
\n\n";
print <<
|
EOM;
function image_picker(){
// selects an icon for games without an image
global $image_name, $rand_set, $max_icons_available, $start, $stop, $rand_cntr;
$rand_image = $rand_set[$rand_cntr];
$rand_cntr++;
// check to make sure we didn't run out of numbers
// if so, refresh the rand_set array
if($rand_cntr){
// create a new array
range($start,$stop);
// fill it
$rand_set = range(1,$max_icons_available); // 50 icons available
// randomize it
shuffle($rand_set);
shuffle($rand_set);
// reset the counter
$rand_cntr = 1;
}
$image_name = "stand_in$rand_image.jpg";
return $image_name;
}
// get footer
include('/var/www/jokesnfun.com/web/footer.php');
?>
|