It BattleHall sorts well by units size.
However, sorting by time also sorts smaller units by newest.
Looks like need to edit the source.
Please Any good solution?
Display All
However, sorting by time also sorts smaller units by newest.
Looks like need to edit the source.
Please Any good solution?
PHP Source Code: ShowBattleHallPage.class
- switch($order)
- {
- case 'date':
- $key = '%%TOPKB%%.time '.$sort;
- break;
- case 'units':
- default:
- $key = '%%TOPKB%%.units '.$sort;
- break;
- }
- $db = Database::get();
- $sql = "SELECT *, (
- SELECT DISTINCT
- IF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))
- FROM %%TOPKB_USERS%%
- LEFT JOIN %%USERS%% ON uid = %%USERS%%.id
- WHERE %%TOPKB_USERS%%.rid = %%TOPKB%%.rid AND role = 1
- ) as attacker,
- (
- SELECT DISTINCT
- IF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))
- FROM %%TOPKB_USERS%% INNER JOIN %%USERS%% ON uid = id
- WHERE %%TOPKB_USERS%%.rid = %%TOPKB%%.`rid` AND `role` = 2
- ) as defender
- FROM %%TOPKB%% WHERE universe = :universe ORDER BY ".$key." LIMIT 100;";
- $top = $db->select($sql, array(
- ':universe' => Universe::current()
- ));
--------------------------------------------------------------------------------------
The post was edited 1 time, last by noonn ().