Widzę sklejkę z kilku kodów.
Próbuj:
public function doExecute( ipsRegistry $registry )
{
$this->registry->class_localization->loadLanguageFile( array( 'public_game') );
$changes = array();
$this->DB->build( array(
'select' => 'p.*',
'from' => array( 'posts' => 'p' ),
'where' => 'p.topic_id = 2',
'order' => 'p.pid DESC',
'limit' => array( 0, 1000 ),
'add_join' => array(
array(
'select' => 'm.members_display_name, m.member_id, m.member_group_id',
'from' => array( 'members' => 'm' ),
'where' => 'p.author_id = m.member_id',
'type' => 'left',
)
)
) );
$q = $this->DB->execute();
while( $r = $this->DB->fetch( $q ) )
{
$r['author_id'] = IPSLib::makeProfileLink( IPSLib::makeNameFormatted( $r['members_display_name'], $r['member_group_id'] ) );
$changes[] = $r;
}
$this->returnHtml( $this->registry->getClass('output')->getTemplate('game')->showRows( $changes ) );
}
P.s. jak możesz to ustaw sobie w Pajączku tabulację na 4.