ShowBattleHallPage Sort by time Problem

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • ShowBattleHallPage Sort by time Problem

    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?


    PHP Source Code: ShowBattleHallPage.class

    1. switch($order)
    2. {
    3. case 'date':
    4. $key = '%%TOPKB%%.time '.$sort;
    5. break;
    6. case 'units':
    7. default:
    8. $key = '%%TOPKB%%.units '.$sort;
    9. break;
    10. }
    11. $db = Database::get();
    12. $sql = "SELECT *, (
    13. SELECT DISTINCT
    14. IF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))
    15. FROM %%TOPKB_USERS%%
    16. LEFT JOIN %%USERS%% ON uid = %%USERS%%.id
    17. WHERE %%TOPKB_USERS%%.rid = %%TOPKB%%.rid AND role = 1
    18. ) as attacker,
    19. (
    20. SELECT DISTINCT
    21. IF(%%TOPKB_USERS%%.username = '', GROUP_CONCAT(%%USERS%%.username SEPARATOR ' & '), GROUP_CONCAT(%%TOPKB_USERS%%.username SEPARATOR ' & '))
    22. FROM %%TOPKB_USERS%% INNER JOIN %%USERS%% ON uid = id
    23. WHERE %%TOPKB_USERS%%.rid = %%TOPKB%%.`rid` AND `role` = 2
    24. ) as defender
    25. FROM %%TOPKB%% WHERE universe = :universe ORDER BY ".$key." LIMIT 100;";
    26. $top = $db->select($sql, array(
    27. ':universe' => Universe::current()
    28. ));
    Display All
    --------------------------------------------------------------------------------------

    The post was edited 1 time, last by noonn ().