mirror of
https://github.com/NamelessMC/Nameless
synced 2026-08-18 06:29:04 -04:00
27 lines
733 B
PHP
27 lines
733 B
PHP
<?php
|
|
|
|
/**
|
|
* Highest reaction scores member list provider
|
|
*
|
|
* @package Modules\Forum
|
|
* @author Aberdener
|
|
* @version 2.1.0
|
|
* @license MIT
|
|
*/
|
|
class MostPostsMemberListProvider extends MemberListProvider {
|
|
|
|
public function __construct(Language $language) {
|
|
$this->_name = 'most_posts';
|
|
$this->_friendly_name = $language->get('forum', 'most_posts');
|
|
$this->_module = 'Forum';
|
|
$this->_icon = 'sort numeric up icon';
|
|
}
|
|
|
|
protected function generator(): array {
|
|
return [
|
|
'SELECT post_creator, COUNT(post_content) AS `count` FROM nl2_posts WHERE deleted = 0 GROUP BY post_creator ORDER BY `count` DESC',
|
|
'post_creator',
|
|
'count'
|
|
];
|
|
}
|
|
}
|