Przykładowo, dla modyfikacji :
Znajdź:
$this->DB->build( array(
'select' => 'COUNT( s.s_mid ) as shouts',
'from' => array( 'shoutbox_shouts' => 's' ),
'order' => 'shouts DESC',
'group' => 's.s_mid',
'limit' => array( 0, $this->settings['dp3_ts_limit'] ),
'add_join' => array(
array(
'select' => 'm.members_display_name, m.member_id, m.members_seo_name',
'from' => array( 'members' => 'm' ),
'where' => 's.s_mid = m.member_id',
'type' => 'left',
)
)
) );
Zamień na:
$this->DB->build( array(
'select' => 'COUNT( s.s_mid ) as shouts',
'from' => array( 'shoutbox_shouts' => 's' ),
'order' => 'shouts DESC',
'group' => 's.s_mid',
'limit' => array( 0, $this->settings['dp3_ts_limit'] ),
'add_join' => array(
array(
'select' => 'm.members_display_name, m.member_id, m.members_seo_name, m.member_group_id',
'from' => array( 'members' => 'm' ),
'where' => 's.s_mid = m.member_id AND m.member_group_id NOT IN (1,2,3)',
'type' => 'left',
)
)
) );
Na podstawie tego, możesz zrobić dla reszty.