1 Topic by Alux

(1 replies, posted in PunBB 1.3 troubleshooting)

Hi, i'm new to the PunBB code so bare with me.

I'm trying to show the title of a topic on the forum home page. This is my current code:

index.php

$queryr = array(
    'SELECT'    => 'subject',
    'FROM'        => 'topics',
    'WHERE'        => 'last_post_id != '.$cur_forum['last_post_id']
);

($hook = get_hook('in_stats_qr_get_user_count')) ? eval($hook) : null;
$resultr = $forum_db->query_build($queryr) or error(__FILE__, __LINE__);
$subtitle = $forum_db->result($resultr);

            $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']).'">'.$subtitle.'</a></strong> <cite>'.format_time($cur_forum['last_post']).' by '.sprintf($lang_index['Last poster'], forum_htmlencode($cur_forum['last_poster'])).'</cite></li>';
unset($subtitle);
unset($resultr);
unset($queryr);

all it seems to do is show the topic title from the first thread of the first forum for all of them. any help please anyone?

Go to forum: PunBB 1.3 troubleshooting