vBulletin Mods

The Official vBulletin Modifications Site

[AJAX] Advanced Forum Statistics
by Hasann
17 Mar 2016 01:42

10 Attachment(s)
[AJAX] Advanced Forum Statistics for vB v3.8.x by Hasann

This Product brought to you by

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


klaush 18 Mar 2016 14:19

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

klaush 18 Mar 2016 15:18

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 18 Mar 2016 15:27

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 18 Mar 2016 15:40

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

vBarsiv 23 Mar 2016 15:08

Installed ! Thank you ;)

nw-fotografie 04 Apr 2016 14:01


Hasann 04 Apr 2016 16:40


Originally Posted by nw-fotografie (Post 2568479)

ja bitte ich bins Hasann :)

nw-fotografie 05 Apr 2016 11:50

Did you see the problem Klaus had?

All times are GMT. The time now is 14:55.

Powered by vBulletin® Version 3.8.14
Copyright © 2022, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.