[Недоработка] Топ предупреждений (обработано)

[Dementor]

в сортировку (ORDER BY) SQL запроса добавить бы 2ю колонку для точности. Мелочь, но все же.

[Zubastic]

off

А чего я то? :redlol:

[Dementor]

офф

off

А чего я то? :redlol:

а ты должен быть выше :redlol:

[DakChe]

off

Код:

###################### Top Infractions  #########################
    private function top_infractions()    {
        $query = $this->db->query_read("
            SELECT COUNT(infraction.infractionid) AS infs, SUM(infraction.points) AS infpoints, infraction.userid, user.usergroupid, user.displaygroupid, user.username
            FROM " . TABLE_PREFIX . "infraction AS infraction
            LEFT JOIN " . TABLE_PREFIX . "user AS user ON (infraction.userid = user.userid)
            WHERE infraction.userid > '0' AND infraction.points > '0' {$this->exclgroups}
            GROUP BY infraction.userid
            ORDER BY infpoints DESC
            LIMIT 0, {$this->result}
            ");
        
        while ($getstats_infraction = $this->db->fetch_array($query))    {
            $getstats_infraction[fullusername] = strip_tags($getstats_infraction[username]);
            if ($this->trimusername > 0)    {
                $getstats_infraction[username] = fetch_trimmed_title($getstats_infraction[fullusername], $this->trimusername);
            }
            else    {
                $getstats_infraction[username] = $getstats_infraction[fullusername];
            }
            $getstats_infraction[musername] = fetch_musername($getstats_infraction);
            if ($this->vbb->options['vietvbbtopstats_bold_remove'])    {
                $getstats_infraction[musername] = str_replace($this->bold, '', $getstats_infraction[musername]);
            }
            
            $temp = vB_Template::create('vietvbb_topstats_top_infractions');
            $temp->register('content', $getstats_infraction);
            $output .= $temp->render();            
        }
        
        if (!$output)    $output = 'No Result';
        $this->db->free_result($query);
        return $output;

[Dementor]

[Zubastic]

Опять неработаит!

[PROGRAMMATOR]

Все там работает. Сортировка по баллам нарушений, а не по количеству полученных карточек. Изменил, раз вам это так важно.