PHP User_score::count Examples

Example #1

File: User_score.php Project: samoldenburg/Stepmania-Leaderboards

 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;
 }

Example #2

File: generic_helper.php Project: samoldenburg/Stepmania-Leaderboards

function get_mod_alert_count_pending_scores()
{
    $ps_count = User_score::count(array('conditions' => 'status = "pending"'));
    return $ps_count;
}

Example #3

File: Scores.php Project: samoldenburg/Stepmania-Leaderboards

 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";
         }
     }
 }