Forum statisctics at the top of each forum

Ce hack affiche en haut de vos forums un petit tableau vous permettant de savoir quelques petites infos sur le forum dans lequel vous vous trouvez tels que :
- Nbe de sujets
- Nbe de reponses
- Meilleur posteur du forum
- Dernier posteur
- Note moyenne
- Vues totales des sujets du forum

Fichiers a modifier : 1
Templates a modifier : 1

Temps d'installation : 2 min


:banana:


This hack displays at the top of each forum, a table where many statistics are displayed such as :
- Number of threads created
- Number of relplys
- Best post creator
- last poster
- Average mark
- Total of sees of the forum

Files to modify : 1
Templates to modify : 1

installation time : 2 min





Voici la version anglaise


HERE IS THE ENGLISH VERSION

[cirisme]

Umm, it is user.userid not post.userid.

:nervous:

[Boofo]

You're right. I just got verification on the userid. The code is good at this:

PHP Code:

$dposteurs=$DB_site->query_first("SELECT post.dateline, thread.threadid, user.username, user.userid
FROM post, thread
LEFT JOIN user ON user.userid = post.userid
WHERE thread.forumid = $forumid AND thread.threadid = post.threadid
ORDER BY post.dateline DESC 
LIMIT 1
"); 


Now, all we have to do is get the Average rating to work right on my site.

[cirisme]

What forums is it not working on?

[Boofo]

One of my Total Commander Forums.

[grog6]

Sorry, I haven't a lot of time for the moment, sorry for not having helped you ...

Really big thanks to Boofo for the support
I'll add these modifications to the archive as soon as I could

Thx to Boofo and other members to fix this hack

[Boofo]

grog6, any more fixes or updates for this hack?

[Boofo]

Well, since no one else seems to be supporting this hack now, I have an update that will knock 2 queries off of the stats.

Find these 3 queries and delete them:

PHP Code:

$nbeposts=$DB_site->query_first("SELECT SUM(replycount) AS reply FROM `thread` WHERE forumid=$forumid");
$nbepost=number_format($nbeposts['reply']);

$nbemesss=$DB_site->query_first("SELECT COUNT(*) AS nbe FROM thread WHERE forumid=$forumid");
$nbemess=$nbemesss['nbe'];
$numthreads = number_format($nbemess);

$vues=$DB_site->query_first("SELECT SUM(views) AS vu FROM thread WHERE forumid='$forumid'");
$vue=number_format($vues['vu']); 


Use this single query instead:

PHP Code:

$nbeposts=$DB_site->query_first("SELECT COUNT(*) AS nbe, SUM(replycount) AS reply, SUM(views) AS vu FROM `thread` WHERE forumid=$forumid");
$nbepost=number_format($nbeposts['reply']);
$numthreads = number_format($nbeposts['nbe']);
$vue=number_format($nbeposts['vu']); 


You will also need to find:

PHP Code:

$avgposteur=(($avgposteuri/$nbemess)*100); 


and change it to:

PHP Code:

$avgposteur=(($avgposteuri/$nbeposts['nbe'])*100); 


for the average poster stat to work with the new query.

[Crazy Pete]

Thanks for the update, Boofo! Any way to save a few queries, I'm all over it.

[Boofo]

You're very welcome.

[grog6]

Sorry

I really have too work for the moment, and can't provide any support for this hack.

As soon as possible, I'll look, udpate the hack with your work Boofo, and try to help for support here.
Sorry but I can't now

[Boofo]

Since Grog6 has not had time to support this hack, an updated (with his permission) and expanded version of this has been released in this thread:

https://vborg.vbsupport.ru/showthrea...threadid=53138

[CRego3D]

excellent ..