public static function getDailyLeaderBoard($userId = null, $action = null, $page = 0, $pageCount = 10)
{
$result = new FunctionResult();
$result->success = false;
if ($action == LeaderBoardUtils::$LEADERBOARD_ACTION_DAILY) {
$SQL = "SELECT daily.coins as leaderboard_coins,daily.lastPlayed as leaderboard_lastplayed,level.levelName as level_levelname,level.levelNumber as level_levelnumber,level.maxXP as level_maxXP,level.minXP as level_minXP,users.* FROM " . TBL_GAME_LEADERBOARD_DAILY . " daily," . TBL_GAME_USERS . " users," . TBL_GAME_USER_LEVEL . " as level WHERE daily.userId=users.userId and users.userLevelNumber=level.levelNumber ORDER BY daily.coins DESC LIMIT " . DBUtils::mysql_escape($page) . "," . DBUtils::mysql_escape($pageCount);
$query = mysql_query($SQL, DBUtils::getManualConnection());
if (empty($query)) {
$result->success = true;
$result->result = new stdClass();
$result->result->list = array();
$result->result->page = $page;
$result->result->pageCount = $pageCount;
} else {
$list = array();
$userAdded = false;
while ($db_field = mysql_fetch_assoc($query)) {
$user = GameUsers::createFromSQLWithLeaderboard($db_field);
if (!empty($user)) {
$userId_ = $user->getUserId();
if (!empty($userId_)) {
array_push($list, $user);
}
if ($userId_ == $userId) {
$userAdded = true;
}
}
}
if (!$userAdded) {
$user = LeaderBoardUtils::getUserDailyBoard($userId);
if (!empty($user)) {
array_push($list, $user);
}
}
$result->success = true;
$result->result = new stdClass();
$result->result->list = $list;
$result->result->page = $page;
$result->result->pageCount = $pageCount;
}
} else {
$result->result = "Action is unknown";
}
return $result;
}
