1 Topic by Socuine (edited by Socuine 2010-07-16 11:21)

  • From: The Netherlands
  • Registered: 2010-07-16
  • Posts: 7

Topic: Subject in Last Post row!

Dear community,

I've successfully modified my index.php and include/functions.php in order to create a subject in the last post row. Works like a charm! However .. One small details remains. In the Topics row my username appears at the bottom of that row..

Please view the issue here: http://project.burstingforce.com

Index.php Line 68 (*modified*):

$query = array(
    'SELECT'    => 'c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.redirect_url, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, t.subject',
    'FROM'        => 'categories AS c',
    'JOINS'        => array(
        array(
            'INNER JOIN'    => 'forums AS f',
            'ON'            => 'c.id=f.cat_id'
        ),
        array(
            'LEFT JOIN'     => 'topics AS t',
            'ON'            => 't.last_post_id=f.last_post_id'
        ),
        array(
            'LEFT JOIN'     => 'forum_perms AS fp',
            'ON'            => '(fp.forum_id=f.id AND fp.group_id='.$forum_user['g_id'].')'
        )
    ),
    'WHERE'        => 'fp.read_forum IS NULL OR fp.read_forum=1',
    'ORDER BY'    => 'c.disp_position, c.id, f.disp_position'
);

Index.php Line 208 (*Modified*):

$forum_page['item_body']['info']['lastpost'] = '<li class="info-lastpost"><span class="label">'.$lang_index['Last post'].'</span><strong><a href="'.forum_link($forum_url['post'], $cur_forum['last_post_id']).'">'.limit_characters(forum_htmlencode($cur_forum['subject'])).'</a></strong> <cite>'.sprintf($lang_index['Last poster'], forum_htmlencode($cur_forum['last_poster'])).'</cite><strong>'.format_time($cur_forum['last_post']).'</strong></li></strong><cite>'.sprintf($lang_index['Last poster'], forum_htmlencode($cur_forum['last_poster'])).'</cite></li>';

Could somebody help me out? Thanks! :]

Sincerely,

Socuine

EDIT: Nevermind, I got it to work. Please delete this thread in order to prevent confusion.