Version: 1.00, by grog6
Developer Last Online: Dec 2008
Version: 2.3.x
Rating:
Released: 04-26-2003
Last Update: Never
Installs: 41
No support by the author.
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
Show Your Support
This modification may not be copied, reproduced or published elsewhere without author's permission.
FYI: There is nothing wrong with the average rating. Something must be wrong with in the vote section for each thread in forumdisplay, because there are several threads in the Dean's List that ARE rated 4~5.
One question though.
Would it not be better for the Average Rating to use the formula;
(total stars divided by total threads in the forum),rather than only including threads that have been rated.
Ok, I was told that the query I posted earlier for the last poster fix, might give false information at a point in the future. Here is the updated one. This one works, I've tested it.
PHP Code:
$dposteurs=$DB_site->query_first("SELECT post.dateline, thread.threadid, user.username
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");
Just use $dposteurs[username] for the username. I'm not sure what tio use to pull the userid out of this query, though. Can someone lend a hand?
$dposteurs=$DB_site->query_first("SELECT post.dateline AS lastpostminute, 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");
SHOULD do it(hopefully). And then use $dposteurs[userid]. But let me go test it.
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.
Forum statisctics at the top of each forum Details »»
About Developer
Visit Web Site
No support by the author.
05-11-2003, 06:08 PM
