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]

Installed and running well on 2.2.9!

Haven't had any prolems with the average rating, or last poster, but I have been making a few modifications.

[Boofo]

Check the last poster in your Frat House forum.

[Boofo]

Also, check your average rating in the Dean's List.

[yxboom]

Mononoke is a bot but Im sure you already noticed that and I saw the Dean's List rating that is hilarious. This is one of those times where we say......ooops.

Thanks Boofo!

[Boofo]

Still the last poster should have been updated right if the query was working ok.

It's nice to see that I am not the only one having the Average Rating problem.

[cirisme]

The Bot doesn't update the forum info, so I'm not all that suprised.(although, now that you bring it up; I think I'll update that )

As for the average rating... oops.

[Boofo]

Which Bot are you using?

[Boofo]

Ok, here is the fix for the lastposter problem. Thanks goes out to Logician for providing the basis of this code in one of his hacks.

In forumdisplay.php, change the last poster query to:

PHP Code:

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


and use this for the lastposter code in the template:

<td nowrap><smallfont><b>Last Poster:</b> <a href="member.php?s=$session[sessionhash]&action=getinfo&userid=$dposteurs[userid]" target=_blank>$dposteurs[username]</a></smallfont></td>

Let me know if this fixes it for everybody. It did for me.

[cirisme]

It's the TomBot. There is a way to make it appear as the last poster, but it got overwritten(IIRC think it was by another hack) it and I have been too lazy to put it back.

BTW, the query that runs the average rating is:

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

....and I ran it manually in PHPMyAdmin, and the average rating is 4.5. Weird eh? I'm looking for a fix for this so I can pry my foot out of my mouth.

[Boofo]

I'm working on that one now. I just posted the fix for the last poster above. Try it and let me know if it fixes it for you.