public static function getLeaderBoard($rank = 0)
{
$database = new Database();
$rank_list = array();
if (!empty($rank)) {
$offset = $rank;
} else {
$offset = 0;
}
$query = "SELECT id,u_id,cur_amt,n_status,leader_pos,s_companies FROM " . self::$table;
$query .= " ORDER BY leader_pos ASC";
$run = $database->query($query);
if ($run) {
if ($database->num_rows($run) > 0) {
while ($data = $database->fetch_array($run)) {
if ($data['leader_pos'] == 0) {
continue;
}
if ($offset != 0 && $offset < (int) $data['leader_pos']) {
unset($database);
return $rank_list;
}
$user = new User($data['u_id']);
$rank_list[] = array('pos' => $data['leader_pos'], 'name' => $user->name, 'asset' => HolderStocks::getAllStockPrices($data['id']) + $data['cur_amt'], 'status' => $data['n_status'], 'companies' => $data['s_companies'], 'email' => $user->user_id);
}
unset($database);
return $rank_list;
}
}
}
