
High Scores | ||
$query = "Select * from #__puarcade WHERE game LIKE 'snake1' ORDER BY score DESC LIMIT 1"; //query for slug snake score
$database->setQuery( $query );
$rows = $database->loadObjectList();
echo "Slug "; echo strtoupper($rows[0]->name); echo " "; echo $rows[0]->score; ?> |
$query = "Select * from #__puarcade WHERE game LIKE 'snake2' ORDER BY score DESC LIMIT 1"; //query for worm snake
$database->setQuery( $query );
$rows = $database->loadObjectList();
echo "Worm "; echo strtoupper($rows[0]->name); echo " "; echo $rows[0]->score; ?> |
$query = "Select * from #__puarcade WHERE game LIKE 'snake3' ORDER BY score DESC LIMIT 1"; //query for python snake score
$database->setQuery( $query );
$rows = $database->loadObjectList();
echo "Python "; echo strtoupper($rows[0]->name); echo " "; echo $rows[0]->score; ?> |

$query = "Select * from #__puarcade WHERE game LIKE 'simon' ORDER BY score DESC LIMIT 1"; $database->setQuery( $query ); $rows = $database->loadObjectList(); echo "High Score: "; echo " | "; echo $rows[0]->score; echo " |
"; echo "Score By: "; echo " | "; echo strtoupper($rows[0]->name); ?> |

$query = "Select * from #__puarcade WHERE game LIKE 'asteroids' ORDER BY score DESC LIMIT 1"; $database->setQuery( $query ); $rows = $database->loadObjectList(); echo "High Score: "; echo " | "; echo $rows[0]->score; echo " |
"; echo "Score By: "; echo " | "; echo strtoupper($rows[0]->name); ?> |

$query = "Select * from #__puarcade WHERE game LIKE 'invaders' ORDER BY score DESC LIMIT 1"; $database->setQuery( $query ); $rows = $database->loadObjectList(); echo "High Score: "; echo " | "; echo $rows[0]->score; echo " |
"; echo "Score By: "; echo " | "; echo strtoupper($rows[0]->name); ?> |

$query = "Select * from #__puarcade WHERE game LIKE 'pacman' ORDER BY score DESC LIMIT 1"; $database->setQuery( $query ); $rows = $database->loadObjectList(); echo "High Score: "; echo " | "; echo $rows[0]->score; echo " |
"; echo "Score By: "; echo " | "; echo strtoupper($rows[0]->name); ?> |

$query = "Select * from #__puarcade WHERE game LIKE 'tetris' ORDER BY score DESC LIMIT 1"; $database->setQuery( $query ); $rows = $database->loadObjectList(); echo "High Score: "; echo " | "; echo $rows[0]->score; echo " |
"; echo "Score By: "; echo " | "; echo strtoupper($rows[0]->name); ?> |

$query = "Select * from #__puarcade WHERE game LIKE 'frogger' ORDER BY score DESC LIMIT 1"; $database->setQuery( $query ); $rows = $database->loadObjectList(); echo "High Score: "; echo " | "; echo $rows[0]->score; echo " |
"; echo "Score By: "; echo " | "; echo strtoupper($rows[0]->name); ?> |