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

[WebCraker]

Thanks a lot, working like charm on 4.1.10

[sadaar]

Can anyone assist me with solving the following Database error? I like this mod but keep getting the error from time to time....

Database error in vBulletin 4.1.10:

Invalid SQL:

                       SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times
                       FROM user AS user
                       WHERE post_thanks_thanked_times > '0'
                       ORDER BY post_thanks_thanked_times DESC
                       LIMIT 0, 15;

MySQL Error   : Unknown column 'post_thanks_thanked_times' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 27th 2012 @ 10:19:56 PM
Error Date    : Friday, January 27th 2012 @ 10:19:56 PM
Script        : http://forum.sadaar.com/ajax.php?do=gettop&ran=0.1480469424277544
Referrer      : http://forum.sadaar.com/forum.php
IP Address    : xx.xx.xx.xx
Username      : xxxxxxxx
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.20-cll

[sadiq6210]

Originally Posted by sadaar

Can anyone assist me with solving the following Database error? I like this mod but keep getting the error from time to time....

Database error in vBulletin 4.1.10:

Invalid SQL:

                       SELECT userid, usergroupid, displaygroupid, username, posts, post_thanks_thanked_times
                       FROM user AS user
                       WHERE post_thanks_thanked_times > '0'
                       ORDER BY post_thanks_thanked_times DESC
                       LIMIT 0, 15;

MySQL Error   : Unknown column 'post_thanks_thanked_times' in 'field list'
Error Number  : 1054
Request Date  : Friday, January 27th 2012 @ 10:19:56 PM
Error Date    : Friday, January 27th 2012 @ 10:19:56 PM
Script        : http://forum.sadaar.com/ajax.php?do=gettop&ran=0.1480469424277544
Referrer      : http://forum.sadaar.com/forum.php
IP Address    : xx.xx.xx.xx
Username      : xxxxxxxx
Classname     : vB_Database_MySQLi
MySQL Version : 5.5.20-cll

This error in not related with this mod

MySQL Error : Unknown column 'post_thanks_thanked_times' in 'field list'

[sadaar]

However when I disable this mod the error stops completely. I was thinking it had something to do with the mod trying to determine the most thanked members.

[sadaar]

Anyone? I would really like to use this mod without all the database errors.

[HHelp1]

Any help please?
Okay im using black style but the statistic not turn black as style but its a WHITE board here

[Easy5s.net]

Originally Posted by HHelp1

Any help please?
Okay im using black style but the statistic not turn black as style but its a WHITE board here

you can change it in temp v i e t v b b_topstats.css (v i e t v b b without space)

[HHelp1]

Originally Posted by Easy5s.net

you can change it in temp v i e t v b b_topstats.css (v i e t v b b without space)

Where may i edit it ?

[iCafe]

Originally Posted by sadaar

Anyone? I would really like to use this mod without all the database errors.

disable show thanked fuction in admincp of this hack

[Easy5s.net]

Originally Posted by HHelp1

Where may i edit it ?

admincp => Search in Templates => choose you wan edit end input v i e t v b b_topstats.css (v i e t v b b without space) and Search Titles Only