The Arcive of Official vBulletin Modifications Site.

Forum Statistics in FORUMDISPLAY · **Released**: 01-10-2004

This hack displays in the FORUMDISPLAY, a box where some stats of the forum are displayed.
These informations are :
- Total of Views
- Total of replies
- Total of views
- Average rating
- Last trhead created
- Total of threads
- Best poster
- Total of posts
- Last poster

A scrolling menu at the bottom of the box displays the last 3 statistics shown under

This statistics box is collapseable/expandable such as others elements of VB3.

Ce hack permet d'afficher dans le forumdisplay de vos forums, une boite d'affichage dans laquelle des stats sur le forum sont affich?es.
Les infos affich?es sont :
- Nombre de sujets
- Nombre de r?ponses
- Nombre de vues
- Moyenne des votes
- Dernier sujet cree par
- Nombre de sujets
- Meilleur posteur
- Nombre total de posts
- Titre du dernier sujet
- Dernier posteur

un menu deroulant permet d'afficher les 3 dernieres stats present?es plus haut

La boite de stats est retractable et sa position enregistr?e dans le cookie permet de la maintenir ferm?e/ouverte meme apres un changement de page.

Notez toutefois que 5 requetes sont ajout?es pour ce hack.

Installation time : 7 min
Templates to modify : 1
Templates to add : 1
Files to upload : 0
Files to modify : 1
Phrases to add : 10
Query to run : 0

:devious:

[HIGH]This hack has been released by VBulletinDev's team : http://www.vbulletindev.net

Ce hack a ete realis? par la team de VBulletinDev et est telechargeable en FR sur http://www.vbulletindev.net[/HIGH]

Boofo · #32 02-16-2004, 01:40 PM

Well, I hate to differ with you but all the information from the queries in my hack is 100% correct. It has been tested thoroughly. Yes, I am using the same cache type that I used for the forumhome stats cache hack. And my hack was completely rewritten for version 2 with the cache. It only uses 1 query when reading from the cache and 6 when writing to it at the preset time. So, if queries is a big issue for anyone (and on bigger boards it usually is), then my hack will save them that.

SpeedStreet · #33 03-11-2004, 12:49 AM

Can you install this hack on a per forum basis?

Gio Takahashi · #34 03-21-2004, 09:46 AM

Quote:

Originally Posted by SpeedStreet

Can you install this hack on a per forum basis?

Seems that this one may not be compatible with Gold. Had problem installiong this. Get a blank white page when I Try to do this:

Code:

Then find :


*********************************************************************
$show['forumdescription'] = iif ($foruminfo['description'] != '', true, false);
$show['forumsearch'] = iif ($forumperms & CANSEARCH, true, false);
$show['forumslist'] = iif ($forumshown, true, false);
$show['stickies'] = iif ($threadbits_sticky != '', true, false);

eval('print_output("' . fetch_template('FORUMDISPLAY') . '");');
*********************************************************************


and add above :


*********************************************************************
// STATS DU FORUM par Grog6 pour VBulletinDev
$sujets=$DB_site->query_first("$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues
FROM " . TABLE_PREFIX . "thread
WHERE forumid = $forumid
GROUP BY forumid
ORDER BY dateline DESC");
$nb_vues = vb_number_format($sujets['vues']);");
$nb_vues = vb_number_format($sujets['vues']);

$moyenne = $DB_site->query_first("SELECT AVG(votetotal/votenum) AS votes FROM " . TABLE_PREFIX . "thread where forumid=$forumid AND votenum<>0");
$moyenne['votes'] = vb_number_format($moyenne['votes']);
$moyenne['votes'] = "<img src=\"images/rating/rating_$moyenne[votes].gif\" alt=\"Vote : $moyenne[votes]\">";

$meilleur = $DB_site->query_first("SELECT " . TABLE_PREFIX . "user.userid, " . TABLE_PREFIX . "user.username, COUNT(" . TABLE_PREFIX . "post.postid) AS postcount FROM " . TABLE_PREFIX . "post LEFT JOIN " . TABLE_PREFIX . "thread ON (" . TABLE_PREFIX . "post.threadid=" . TABLE_PREFIX . "thread.threadid) LEFT JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "post.userid=" . TABLE_PREFIX . "user.userid) WHERE " . TABLE_PREFIX . "thread.forumid=$forumid GROUP BY " . TABLE_PREFIX . "post.userid ORDER BY POSTCOUNT DESC LIMIT 1");
$meilleur['postcount'] = vb_number_format($meilleur['postcount']);

$sujet = $DB_site->query_first("SELECT COUNT(open) AS ferme FROM " . TABLE_PREFIX . "thread WHERE forumid=$forumid AND open=0");

$forum = $DB_site->query_first("SELECT lastthread, lastposter, replycount, threadcount FROM " . TABLE_PREFIX . "forum WHERE forumid=$forumid");
  $forum['posts'] = ($forum['replycount'] - $forum['threadcount']);

   eval('$stats .= "' . fetch_template('forumdisplay_stats') . '";');
// STATS par Grog6
*********************************************************************

VBDev · #35 03-21-2004, 09:57 AM

@Gio : it should work but I haven't tested it on vb3 Gold, I'll have to modify all my hacks for Vb3 Gold

It should be posted during the week

VBDev · #36 03-24-2004, 08:40 PM

Our team has opened its support forum.

Now we will make support on our forum

So if you want better support on our hacks go on our forum: http://www.vbulletindev.net/

There are not a lot of hacks for the moment but it will come.

Cya soon on our forum

OCH-Stan · #37 06-15-2004, 01:09 PM

I get this message: Parse error: parse error, unexpected T_STRING in /home/ochost/public_html/forum/forumdisplay.php on line 825. What's wrong??

EscortCossie · #38 02-02-2005, 03:01 PM

I'm sorry to bump this thread, but I still get a parse error when installing exactly as stated in this thread. (also the fix..)

vakvak · #39 03-25-2005, 02:57 AM

Quote:

Parse error: parse error, unexpected T_STRING in /home/pcteknik/public_html/fr2/forumdisplay.php on line 816

forumdisplay error help pls

vakvak · #40 03-25-2005, 05:46 PM

My FILES MODIFICATIONS

PHP Code:


			
// pre-cache templates used by specific actions

$actiontemplates = array(

    'none' => array(

        'FORUMDISPLAY',

        'threadbit',

        'threadbit_deleted',

        'forumdisplay_announcement',

        'forumhome_lastpostby',

        'forumhome_forumbit_level1_post',

        'forumhome_forumbit_level2_post',

        'forumhome_forumbit_level1_nopost',

        'forumhome_forumbit_level2_nopost',

        'forumhome_subforumbit_nopost',

        'forumhome_subforumseparator_nopost',

        'forumdisplay_loggedinuser',

        'forumhome_moderator',

        'forumdisplay_moderator',

        'forumdisplay_sortarrow',

        'forumhome_subforumbit_post',

        'forumhome_subforumseparator_post',

        'forumrules'

        ,

                'forumdisplay_stats'

    )

);

PHP Code:


			
    // mark a single forum as read as it appears all threads are read

    set_bbarray_cookie('forum_view', $foruminfo['forumid'], TIMENOW);

}

construct_forum_rules($foruminfo, $forumperms);



//remove html to stop the breaking of the meta description

$foruminfo['description'] = strip_tags($foruminfo['description']);



// STATS DU FORUM par Grog6 pour VBulletinDev

$sujets=$DB_site->query_first("$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues

FROM " . TABLE_PREFIX . "thread

WHERE forumid = $forumid

GROUP BY forumid

ORDER BY dateline DESC");

$nb_vues = vb_number_format($sujets['vues']);");

$nb_vues = vb_number_format($sujets['vues']);



$moyenne = $DB_site->query_first("SELECT AVG(votetotal/votenum) AS votes FROM " . TABLE_PREFIX . "thread where forumid=$forumid AND votenum<>0");

$moyenne['votes'] = vb_number_format($moyenne['votes']);

$moyenne['votes'] = "<img src=\"images/rating/rating_$moyenne[votes].gif\" alt=\"Vote : $moyenne[votes]\">";



$meilleur = $DB_site->query_first("SELECT " . TABLE_PREFIX . "user.userid, " . TABLE_PREFIX . "user.username, COUNT(" . TABLE_PREFIX . "post.postid) AS postcount FROM " . TABLE_PREFIX . "post LEFT JOIN " . TABLE_PREFIX . "thread ON (" . TABLE_PREFIX . "post.threadid=" . TABLE_PREFIX . "thread.threadid) LEFT JOIN " . TABLE_PREFIX . "user ON (" . TABLE_PREFIX . "post.userid=" . TABLE_PREFIX . "user.userid) WHERE " . TABLE_PREFIX . "thread.forumid=$forumid GROUP BY " . TABLE_PREFIX . "post.userid ORDER BY POSTCOUNT DESC LIMIT 1");

$meilleur['postcount'] = vb_number_format($meilleur['postcount']);



$sujet = $DB_site->query_first("SELECT COUNT(open) AS ferme FROM " . TABLE_PREFIX . "thread WHERE forumid=$forumid AND open=0");



$forum = $DB_site->query_first("SELECT lastthread, lastposter, replycount, threadcount FROM " . TABLE_PREFIX . "forum WHERE forumid=$forumid");

  $forum['posts'] = ($forum['replycount'] - $forum['threadcount']);



   eval('$stats .= "' . fetch_template('forumdisplay_stats') . '";');

// STATS par Grog6



$show['forumdescription'] = iif ($foruminfo['description'] != '', true, false);

$show['forumsearch'] = iif ($forumperms & CANSEARCH AND $vboptions['enablesearches'], true, false);

$show['forumslist'] = iif ($forumshown, true, false);

$show['stickies'] = iif ($threadbits_sticky != '', true, false);



eval('print_output("' . fetch_template('FORUMDISPLAY') . '");');

but
Parse error: parse error, unexpected T_STRING in /home/pcteknik/public_html/fr2/forumdisplay.php on line 816
help.. :ninja:

Elfo King · #41 06-05-2005, 12:41 PM

I have this error....

Quote:

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in D:\Inetpub\wwwroot\forum\forumdisplay.php on line 822

This is line 822......

Quote:

$nb_vues = vb_number_format($sujets['vues']);

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05090 seconds Memory Usage 2,348KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_code (2)bbcode_php (4)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!