All pastes #962612 Raw Edit

Miscellany

public text v1 · immutable
#962612 ·published 2008-03-29 22:14 UTC
rendered paste body
	function get_poster_rank($name) {
		
		$this->db->select('name, COUNT(*) as posts');
		$this->db->group_by('name');
		$this->db->order_by('posts', 'desc');
		$tmp = $this->db->get('posts');
		
		$rank = 1;
		
		foreach ($tmp->result() as $item) {
			if(strcasecmp(urldecode($item->name), $name) == 0)
				return $rank;
			
			$rank++;
		}
		return -1;
	}