Miscellany
public text v1 · immutable 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;
}