/**
* Updates the players name associated with the passed uuid.
*
* @param playerUUID The UUID of the player to update
* @param playerName The new name for the player
* @return True on success, false on failure
*/
function setPlayerName($playerUUID, $playerName)
{
// do the update based on the internal ID, rather than the public UUID
$playerID = getPlayerFromUUID($playerUUID);
$qryUpdate = 'UPDATE
players
SET
name = \'' . dbEscape($playerName) . '\'
WHERE
id = \'' . (int) dbEscape($playerID) . '\'';
$resUpdate = mysql_query($qryUpdate);
return $resUpdate ? true : false;
}
<?php
require_once '../config.inc.php';
require_once DIR_INCLUDE . '/common.inc.php';
// make sure the scores aren't cached
sendXMLHeaders();
// initially see whether this is an existing player
$playerUUID = getRequest('puuid');
$playerID = getPlayerFromUUID($playerUUID);
//
// At this point, $playerUUID may be false (if one wasn't passed). We can safely ignore
// this as the queries involving a specific player will all return nothing which is
// fine.
//
//
// retrieve top player scores
//
$qryPlayer = 'SELECT
score
FROM
scores
WHERE
player_id = \'' . (int) $playerID . '\'
ORDER BY
score DESC
LIMIT ' . MAX_PLAYER_SCORES;
$resPlayer = mysql_query($qryPlayer);
// extract player scores
$scorePlayers = array();
for ($i = 0; $i < MAX_PLAYER_SCORES; $i++) {
$row = mysql_fetch_assoc($resPlayer);
