I've tried changing the following phpbb lines with no success:
viewtopic.php - LINE 451:
Code: Select all
$sort_by_sql = array('a' => array('u.username_clean', 'p.post_id'), 't' => array('p.post_time', 'p.post_id'), 's' => array('p.post_subject', 'p.post_id'));
Code: Select all
$sort_by_sql = array('a' => array('u.username_clean', 'p.post_id'), 't' => array('p.post_id', 'p.post_time'), 's' => array('p.post_subject', 'p.post_id'));
viewtopic.php - LINE 1193:
Code: Select all
ORDER BY $sql_sort_order";
Code: Select all
ORDER BY p.post_id ASC;
Not sure how to do this properly or if/how to create a proper index for it, if possible I'd like to do the same for topics. Any help would be appreciated.