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

[grog6]

So, to add link to lastposter'sprofile, replace in admin/functions.php :

PHP Code:

$dposteurs=$DB_site->query_first("SELECT lastposter FROM thread WHERE forumid='$forumid' ORDER BY threadid DESC");
$dposteur=$dposteurs['lastposter']; 


with

PHP Code:

$dposteurs=$DB_site->query_first("SELECT lastposter, userid FROM thread,user WHERE (thread.forumid='$forumid' AND 

user.username=thread.lastposter) ORDER BY threadid DESC LIMIT 0,1");
$dposteurnom=$dposteurs['lastposter'];
$dposteurid=$dposteurs['userid']; 


and in the template forumdisplay_stats, replace $dposteur with

PHP Code:

<a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$dposteurid" 
target=_blank>$dposteurnom</a> 


[subu1]

i cant find this in admin/functions.php

[grog6]

Haven't you it at the end of the modification there is to do for my hack :

PHP Code:

$dposteurs=$DB_site->query_first("SELECT lastposter FROM thread WHERE forumid='$forumid' ORDER BY threadid DESC");
$dposteur=$dposteurs['lastposter'];
eval("\$forumdisplaystats = \"".gettemplate('forumdisplay_stats')."\";"); 


??

[Boofo]

Today at 06:38 PM subu1 said this in Post #62
i cant find this in admin/functions.php

grog6 meant to say the forumdisplay.php file, not functions.php.

[Boofo]

grog6, the lastposter link code works like a charm. Thanks.

bitg is right about the Top Thread Starter bug. If you have a forum with only one thread in it, it will also give the error where it will show 100 % but no Top Thread Starter username. If you also have a forum where every thread is started by a different user, it will not show the username, because it doesn't know which one to pick. You must have threads started by the same username for it to show the name. I hope that makes sense.

Amy, is there a way to fix the Average rating like you posted? It is still showing in one of my forums as a thread rating of 4 stars for an average and there are no thread ratings whatsoever in that forum.

[grog6]

@ Boofo : strange for the vote :-/

Run this query on your DB, just replace the $forumid with your forumid, and say us which result, you have

PHP Code:

SELECT AVG(vote) AS moythread FROM thread,threadrate WHERE (thread.forumid='$forumid' AND 
threadrate.threadid=thread.threadid 


It may show you sthg between 3.5 and 4.5, if it is not, there really might be a problem, but take a look at it before

[Boofo]

I ran this query because the one you gave me gave a db error.

SELECT AVG(vote) AS moythread FROM thread,threadrate WHERE thread.forumid='13' AND threadrate.threadid=thread.threadid;

and here is what it returned:

vote)ASmoythread

[Holidazed]

grog, thanks for the update. The Last Poster link works awesome. Now for the bug that shows no user name when more than one user has the same amount of posts.

[Edgar]

Sweet hack, works perfect on my forum.
I do have a few questions though. Will there be a similar hack in the future to display the same stats but then for all forums together on the forums home page?

I hope you know what I mean.

[RetroDreams]

Is there a reason that the total views doesn't use the proper comma format like the total threads and replys?

[grog6]

@ RetroDreams : what's the problem exactly ?

[RetroDreams]

Today at 01:42 AM grog6 said this in Post #71
@ RetroDreams : what's the problem exactly ?

Well, total threads and replys have commas in the numbers after they hit 1,000, but the total views does not, so it would read 1000, instead of 1,000 - Just looking for parity.

[Boofo]

Just replace:

PHP Code:

$vue=$vues['vu']; 


with this:

PHP Code:

$vue=number_format($vues['vu']); 


Did anyone ever get the Average rating thing figured out?

[Sweet Evil]

I would like it to link to last posters profile and also I do not wish for the rating and would like to show and link to newest member.
I added the code for newest member from forumhome template but it is not showing the newest member nor a link.

My Display

Anyone make these changes and can let me in as to how?

Thanks!

[subu1]

Yesterday at 02:47 AM Boofo said this in Post #73
Just replace:

PHP Code:

$vue=$vues['vu']; 


with this:

PHP Code:

$vue=number_format($vues['vu']); 


Did anyone ever get the Average rating thing figured out?

thxx i do it, it works, and what is with "total clicks"

greetz and thxx subu1