public static function get_top_10_percentile() { $total_count = User_score::count(); $floor_count = floor($total_count * 0.1); $all_scores = User_score::all(array('select' => "user_scores.*, ranked_files.difficulty_score as difficulty_score", 'joins' => "LEFT JOIN ranked_files ON ranked_files.id = user_scores.file_id", 'order' => "difficulty_score desc", 'limit' => $floor_count)); $last_score = 0; foreach ($all_scores as $score) { $last_score = $score->difficulty_score; } return $last_score; }
function get_mod_alert_count_pending_scores() { $ps_count = User_score::count(array('conditions' => 'status = "pending"')); return $ps_count; }
public function remove($score_id = null) { $this->require_login(); if (!$score_id) { redirect('home'); } else { if (User_score::count(array('conditions' => array('id = ?', $score_id))) != 1) { redirect('home'); } else { $user_score = User_score::find($score_id); $write_mod_log = false; if ($user_score->user_id != $this->session->userdata('user_id')) { if ($this->session->userdata('user_level') < 2) { redirect('home'); } else { $write_mod_log = true; } } $this->data['user_score'] = $user_score; $song = Ranked_file::find($user_score->file_id); $this->data['song'] = $song; $user_score->status = "removed"; $user_score->save(); $scores_user = User::find($user_score->user_id); if ($write_mod_log) { $log_string = $this->session->userdata('username') . " (" . $this->session->userdata('display_name') . ") removed user score: " . $scores_user->username . " (" . $scores_user->display_name . ") " . $song->title . " " . number_format($song->rate, 2) . "x"; write_to_mod_log($log_string); } $this->content_view = "scores/removed"; } } }