Forum Statistics in FORUMDISPLAY

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]

[Gio Takahashi]

har har.

Oh. the "Total Views" seems to be the total views of the last thread created. Isn't it supposed to be the total views in this forum?

[VBDev]

Originally Posted by Gio Takahashi

har har.

Oh. the "Total Views" seems to be the total views of the last thread created. Isn't it supposed to be the total views in this forum?

I had this problem in one forum when I did it, in other forums, it seems to work correctly

I think I had an idea, I'll take a look and try to repair it

[VBDev]

@Gio : modify in the forumdisplay.php :

$sujets=$DB_site->query_first("SELECT postusername, SUM(views) AS vues FROM  " . TABLE_PREFIX . "thread WHERE forumid=$forumid GROUP BY postusername ORDER BY dateline DESC");

with

$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues
FROM " . TABLE_PREFIX . "thread
WHERE forumid =2
GROUP BY forumid
ORDER BY dateline DESC");

I'll update my archive

[sypher_again]

Super taff les mecs vive vbdev vous allez tout dechirer j'en suis sur ^^ / very good taff

[MGM]

sweet..... i added this to my vB2 board, I'll be sure to use this on vB3

/me clicks Install

MGM out

[eXtremeTim]

Originally Posted by VBDev

@Gio : modify in the forumdisplay.php :

$sujets=$DB_site->query_first("SELECT postusername, SUM(views) AS vues FROM  " . TABLE_PREFIX . "thread WHERE forumid=$forumid GROUP BY postusername ORDER BY dateline DESC");

with

$sujets=$DB_site->query_first("SELECT postusername, SUM( views )  AS vues
FROM " . TABLE_PREFIX . "thread
WHERE forumid =2
GROUP BY forumid
ORDER BY dateline DESC");

I'll update my archive

One problem all the forums would show the thread views amount for forum id number 2 in that new sql query you posted above.

[nuke]

Hmm Sorry Error

Parse error: parse error, expecting `T_STRING' or `T_VARIABLE' or `T_NUM_STRING' in /var/www/web2/html/vb/forumdisplay.php on line 823

vB RC 2???

[g-force2k2]

Originally Posted by eXtremeTim

One problem all the forums would show the thread views amount for forum id number 2 in that new sql query you posted above.

If you updated the sql query you will get this error. Just change the code from his recent fix:

PHP Code:

WHERE forumid =2 


to:

PHP Code:

WHERE forumid = $forumid 


Regards,
g-force2k2

[VBDev]

The zip was updated

Thx for the report of bugs

[Vb-Hispano]

Parse error: parse error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/httpd/vhosts/juegos21.org/httpdocs/foros/forumdisplay.php on line 812

is error ???