Add-On Releases - Update 4.0.4a - [AJAX] - Advanced Forum Statistics

AJAX - Advanced Forum Statisticss

+Compatiable with latest version of vBulletin
+ This Mod has been coded by one person in our Team Linhnt
+ You can also check 3.8.x version here posted by ry215
+ This Mod is supported so I will try my best to give most possible support to you guys here.
+ Enjoy it!

DEMO: view screenshot
LIVE DEMO: my site is currently under construction so feel free to leave a link to your site if you use it. I will put it here.

Features:

Thread, blog, forum:
- Latest Post
- 9 Latest Post custom
- Hostest thread
- Most viewed thread
- Latest News
- Top Forum
- Latest Class Ads
- Latest Blog (Entry)
- Latest Blog Comment
- Most viewed Entry
- Hottest Entry

Member:
- Newest Member
- Top Starter
- Top Referrer
- Top Reputation
- Top thanked
- Top Richest
- Top Bloger

Install:
1. Upload all the folder with file in UPLOAD folder to your root folder.
2. Import Product
3. Settings -> options - > [AJAX] - Advanced Forum Statistics change all options to fit your need.
4. Remember to mark as installed and nominate if you use and like this mod.

History version:
v 4.0.0 : first release
v 4.0.1 : Update with some little fix
v 4.0.2 : Update 1 new template which dispay thread information when mouse-over view.
v4.0.4: Optimize, fix css, add thread prefix. Work with latest version 4.0.2 patch level 1
IF YOU ARE NOT RUNNING VBULLETIN 4.0.2 or HIGHER - DO NOT UPGRADE TO 4.0.4 OR IT WILL MESS YOUR BOARD>
v4.0.4.a: Quick fix with tooltips.

Regards,
haothiencz

[Shanti Nanda]

I have an issue: one of my users turn off this hack manually, and he wants it back... but I can't find how to do it D:

[redtailboas]

Have them go to the Forums -> Quick Links -> Enable Top Stats

[Shanti Nanda]

Thank you! <3

[yin9]

Thanks for this update haothiencz, installed, 5 stars.

VB version: 4.1.0 PL2

[Aramist]

HI, I have installed this today...

And a strange issue happens...

I was testing it on Opera browser, where i was logged in as admin.

Everything was ok there...

But when i tryed to test others browsers (as guest visitors), my board does not load and it gives me and database error message.

as below:

Database error in vBulletin 4.1.1:

Invalid SQL:

SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid 
FROM vb_thread AS thread
LEFT JOIN vb_user AS user ON (user.userid = thread.lastposterid)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10'  AND thread.forumid NOT IN(137,87,48,54,45,72,30,12,136,6,31,37,101,7,32,53,113,68,)
ORDER BY lastpost DESC
LIMIT 0, 15;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')
ORDER BY lastpost DESC
LIMIT 0, 15' at line 4
Error Number  : 1064
Request Date  : Saturday, January 22nd 2011 @ 10:24:16 PM
Error Date    : Saturday, January 22nd 2011 @ 10:24:16 PM
Script        : http://www.myboard.com/forum/forum.php
Referrer      : 
IP Address    : my.ip
Username      : N?o Registrado(s)
Classname     : vB_Database
MySQL Version :

now the mod is unninstaled and everything comes alright....

Any clue?

Ty in advance


pS.: While the problem was happening in others browsers....opera (admin instance) was running ok.

[ComoEstaEso-com]

Just installed this on our forums.
Running vB 4.1.2, and everything is working perfectly.

Thank you very much for your work!
I should have installed this a long time ago!!

[ErnestA]

I think I found a bug in the program. The stat box looks fine in the forum root folder, but when you go to a lower level category (with show on forumdisplay enabled and multiple comma separated values in the default results box), the box ends up looking cut off under all sub forums from the root.

You can see in the attached picture, the first picture is from the forum root which looks fine, the drop down box to select the # of results you want looks fine, but the second screen shot shows the box is cut at the bottom.

I tried it in both Firefox and Chrome and got the same results.

<div class="forumhead foruminfo collapse">

and

<span class="forumtitle"><a href="#" target="_blank">[AJAX] Advanced Forum Statistics</a></span>

get rendered with different pixel heights depending on whether or not it's being displayed from the forum home (root) or from a sub forum (forumdisplay).

Example:

In Forumhome, class forumhead is 33px high

and in a sub forum (forumdisplay), class forumhead is only 25px high (and thus the bottom of the drop down results box is cut off).

I've tried to find where this is happening in the code but can't quite figure it out.

Thanks,

Ernest A.

[Viddek]

Could it be possible to add some more statistics? Like the ACP statistics about the new posts for each day?

[lsgworldl]

every time i upload the files from this it makes me have a white screen

[ash50210]

i've successfully installed this mod but i've problems here which is no threads are showing but only 'X' but i can see name who post the thread.

Appreciate any helps here.