[AJAX] Advanced Forum Statistics

[Hasann]

[AJAX] Advanced Forum Statistics for vB v3.8.x by Hasann

This Product brought to you by
www.vbulletin-TR.com (http://www.vbulletin-tr.com)

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 (http://www.vBulletin-Tr.com/forum)

[klaush]

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

[klaush]

And one more:

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

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

[klaush]

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

[klaush]

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

[vBarsiv]

Installed ! Thank you ;)

[nw-fotografie]

Hasann?

[Hasann]

Hasann?

ja bitte ich bins Hasann :)

[nw-fotografie]

Did you see the problem Klaus had?