score
|
time
|
name
|
date
|
//sort names in asc order
$arrange = 'DESC';
if($_GET[sort]=="name" or $_GET['sort']=="clock"){
$arrange = "ASC";
}
//////////////////////////
//top ten, or 100, or *
$limit=100;
switch($viewState){
case 0: $limit = 10 ;break;
case 1: $limit = 100 ;break;
case 2: $limit = 10000 ;break;
}
$query = "select * from popblox order by '$sort' $arrange LIMIT $limit";
//////////////////////
//DUMP scores
$result = mysql_query($query);
$num=1;
while ($hs = mysql_fetch_array($result)){
//alternate BGcolor
if ( fmod($num, 2) == 0){
$col = "#9d9f64";//#E7F4FD
$tclass = "score1";
}else{
$col = "#9d9f66";//#C0C8CA
$tclass = "score2";
}
$d = convDateTime($hs[date]);
$t = num2Time($hs[clock]);
if( empty($hs[name]) ){
$name = "Player";
}else{
$name = $hs[name];
}
echo "
| ".number_format($hs[points])." |
".$t." |
".$name." |
".$d." |
";
$num++;
}
?>