Views & Replies Count in Last Post box

[Fenriz]

Hi! Is it possible to make the hack "Views & Replies Count in Last Post box" for the vBulletin 3.5? I have next working code for the 3.0.x:

--------------------------------------------------------------------------

In the includes/functions_forumlist.php find:

$show['lastpostinfo'] = (!$lastpostforum['password'] OR verify_forum_password($lastpostforum['forumid'], $lastpostforum['password'], false));

below that insert:

$tviews = $DB_site->query_first("SELECT views AS tviews, replycount AS treply FROM " . TABLE_PREFIX . "thread WHERE threadid = $lastpostinfo[lastthreadid]");
$forum[tviews] = $tviews['tviews'];
$forum[treply] = $tviews['treply'];

In the forumhome_lastpostby template find:

</div>
</if>

below that insert:

<div class="smallfont" align="$stylevar[center]">
views: $forum[tviews] | replies: $forum[treply]
</div>

[Andreas]

That is inefficient.
I'd strongly recommend to implement this another way.

[Fenriz]

This hack works great on my 3.0.9 board http://valhalla.ulver.com , but I need it to be ported to the 3.5 !

KirbyDE, could you help me to find the efficient way? :)

[Andreas]

Smth. like this could work:

cache_ordered_forums

if (THIS_SCRIPT == 'forumdisplay' OR THIS_SCRIPT == 'index')
{
$tachyjoin .= " LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (thread.threadid=forum.lastthreadid)";
$counter_select = str_replace(array(', lastpost', ', lastposter', ', replycount'), array(', forum.lastpost', ', forum.lastposter', ', forum.replycount'), $counter_select) . ", thread.views AS tviews, thread.replycount AS treplies";
}


forumbit_display

$forum['tviews'] = vb_number_format($forum['tviews']));
$forum['treplies'] = vb_number_format($forum['treplies']));

[Fenriz]

KirbyDE, the first part works, but ..

forumbit_display

$forum['tviews'] = vb_number_format($forum['tviews']));
$forum['treplies'] = vb_number_format($forum['treplies']));


this second part of the code always calls for error:

Parse error: parse error, unexpected ')' in /home/.../includes/functions_forumlist.php(466) : eval()'d code on line 1

[Fenriz]

KirbyDE?

[Andreas]

Well, correct the wrong ) in both lines (as told in the error message) and it should work :)

[Fenriz]

Oh :) Thank you very much! Now it works perfect!

[Fenriz]

Andreas, in 3.5.4 this hack became buggy.

On my forum http://valhalla.ulver.com/index.php?langid=1 it doesn't show "views: | replies: " in several forums and shows wrong information about quantity in the most forums.

Could you give me a good advise about this code, please?