[AJAX] Advanced Forum Statistics
 

Description: this addon add to forum home a very advanced forum statistic with vBulletin AJAX functions for more details see below screenshots !!!

AJAX Forum Statistics:

-Latest Posts / New Replies
-Most Viewed Threads / Hit Threads
-Hottest Threads / Top Threads
-New Album Pictures
-Random Album Pictures
-Newest Members
-Top Posters
-Random Social Groups
-My Threads

Installation: -Import XML file (as product): AdminCP > Plugin System > Manage Products > [Add/Import Product]


Tested on:

• vBulletin 3.8.10

LIVE DEMO:

• www.vBulletin-Tr.com/forum

Great stuff! What shows "new replies"? In our installation it does not show anythging?

And one more:

MySQL-error : Unknown column 'user.userid' in 'field list'
Error-Nr. : 1054

Skript : http://xxxxx/ajax.php
Referrer : http://xxxxx/forum/

More details:

Invalid SQL:
SELECT user.userid, user.usergroupid, user.username, user.posts, IF(displaygroupid=0, usergroupid, displaygroupid) AS displaygroupid,

user.avatarid, user.avatarrevision
,
avatar.avatarpath,NOT ISNULL(customavatar.userid) AS hascustomavatar,
customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight
FROM vb3_user


LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid)
LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)

ORDER BY joindate DESC LIMIT 0, 10;

MySQL-Fehler : Unknown column 'user.userid' in 'field list'
Fehler-Nr. : 1054

Ok, the database error happens when you click "new replies".

Installed ! Thank you ;)

Hasann?

ja bitte ich bins Hasann :)

Did you see the problem Klaus had?