I just updated my board to 3.1 and I'm going through the files to re-do the Group Format and when I edited "admin/applications/forums/modules_public/forums/forums.php" to
FIND:
$this->DB->build( array(
'select' => '*',
'from' => 'topics t',
'where' => "t.forum_id=" . $this->forum['id'] . " AND t.pinned IN (0,1)" . $_SQL_APPROVED . $_SQL_AGE_PRUNE . $_SQL_EXTRA,
'order' => 't.pinned DESC, '.$topic_sort.' t.'.$sort_key .' '. $r_sort_by,
'limit' => array( intval($First), $this->settings['display_max_topics'] )
) );
REPLACE WITH:
/* (T30) Group Format */
$this->DB->build( array( 'select' => 't.*',
'from' => array( 'topics' => 't' ),
'where' => "t.forum_id=" . $this->forum['id'] . " AND t.pinned IN (0,1)" . $_SQL_APPROVED . $_SQL_AGE_PRUNE . $_SQL_EXTRA,
'order' => 't.pinned DESC, '.$topic_sort.' t.'.$sort_key .' '. $r_sort_by,
'limit' => array( intval($First), $this->settings['display_max_topics'] ),
'add_join' => array( array( 'select' => 'fp.member_group_id AS starter_group',
'from' => array( 'members' => 'fp' ),
'where' => "fp.member_id=t.starter_id",
'type' => 'left',
),
array( 'select' => 'lp.member_group_id AS last_poster_group',
'from' => array( 'members' => 'lp' ),
'where' => "lp.member_id=t.last_poster_id",
'type' => 'left',
) )
) );
When I reupload and check the thread index this happens:
Can anyone help with with this?