Egyptian Basra Leaderboard
'latest',
'region' => 'eu-west-1',
'credentials' => array(
'key' => 'AKIAXFDNRJOMYDM7H2ON',
'secret' => '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',)
]);
$stmt = "SELECT * FROM player ORDER BY score DESC LIMIT 20";
$bucket = "egybasraprofiles90946-dev";
$result = $mysqli->query($stmt);
//$rows = array();
echo "";
echo "";
echo "";
echo "";
echo "| Profile | ";
echo "Rank | ";
echo "Name | ";
echo "Score | ";
echo "
";
$order = 1;
$winnerUrl = "";
// go through the records *********************
while($r = $result->fetch_assoc()) {
$faceid = $r["facebookid"];
$name = $r["name"];
$score = $r["score"];
$key = "public/" .$faceid. ".jpg";
$cmd = $s3Client->getCommand('GetObject', [
'Bucket' => $bucket,
'Key' => $key
]);
//The period of availability
$request = $s3Client->createPresignedRequest($cmd, '+30 seconds');
//Get the pre-signed URL
$signedUrl = (string) $request->getUri();
if($order==1)
$winnerUrl = $signedUrl;
echo "";
echo "![The winner](" .$signedUrl. ") | ";
echo "" .$order. " | ";
echo "" .$name. " | ";
echo "".$score." | ";
echo "
";
$order++;
}
echo "
";
echo "";
echo "";
echo "";
?>