Cool, thanks!

Now, I'm just wondering, how should I get that IWT /plugin for counting spent time/ fixed, hehe. Curious about one thing, vBE 4 devs offering support for 3rd party mod, wondering whether they might or might not give me a hand with that one.

Anyway thanks,
~tEh'P?r4d0x

vBExperience 4.1.1 BETA has been released. This is primary a bugfix release. Download the Installation from the first post.

Please reinstall ALL plugins you are using from the ZIP\Plugins! Espacially if you get SQL Errors after reinstalling vBExperience.

Changes:
- Fixed Plugin for 8WR_Media_Library
- Fixed Plugin for Advanced_Forum_Points
- Fixed Plugin for Attachment_Consumes_Points
- Fixed Plugin for EasyForms
- Fixed Plugin for Post_Thanks_Abe1
- Fixed border around boxes
- Fixed not correctly saving award images
- Extended character length for manual award assignment
- Several smaller fixes

There is a plugin for that one, it is included in the ZIP of vBExperience. You can find it in ZIP\Plugins\Time_Spent_Online.xml

So basically the functions of it are included? Does it count time spent online and shows some sort of ladder of people, who spent online the most time?

Thanks,
~tEh'P?r4d0x

I thought you asked for the "bridge" between Time Spent Online and vBExperience.

when install complete i get database error in admin panel


Attachment 136890

Database error in vBulletin 4.1.10:

Invalid SQL:
SELECT
u.userid,
u.usergroupid,
u.membergroupids,
u.username,
u.xperience_level,
u.xperience,
u.xperience_ppd,
u.xperience_awardt,
u.reputation,
SUM(s.points_user) AS points_user,
SUM(s.points_thread) AS points_thread,
SUM(s.points_post) AS points_post,
SUM(s.points_misc) AS points_misc
FROM vbxperience_stats AS s
INNER JOIN vbuser AS u ON u.userid=s.userid
WHERE 1=1
GROUP BY S.userid
ORDER BY u.xperience desc
LIMIT 0,30;

MySQL Error : Unknown column 'S.userid' in 'group statement'
Error Number : 1054
Request Date : Wednesday, March 7th 2012 @ 04:35:28 AM
Error Date : Wednesday, March 7th 2012 @ 04:35:28 AM
Script : http://www.*******/xperience.php?go=ranking
Referrer : http://www.******/xperience.php?go=groups
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.56

I found the same error after the update but when clicking on Ranking tab only:

Database error in vBulletin 4.1.11:

Invalid SQL:
SELECT
u.userid,
u.usergroupid,
u.membergroupids,
u.username,
u.xperience_level,
u.xperience,
u.xperience_ppd,
u.xperience_awardt,
u.reputation,
SUM(s.points_user) AS points_user,
SUM(s.points_thread) AS points_thread,
SUM(s.points_post) AS points_post,
SUM(s.points_misc) AS points_misc
FROM xperience_stats AS s
INNER JOIN user AS u ON u.userid=s.userid
WHERE 1=1
GROUP BY S.userid
ORDER BY u.xperience desc
LIMIT 0,30;

MySQL Error : Unknown column 'S.userid' in 'group statement'
Error Number : 1054
Request Date : Tuesday, March 6th 2012 @ 10:55:01 PM
Error Date : Tuesday, March 6th 2012 @ 10:55:02 PM
Script : http://www.xxxxx.xxx/xperience.php?go=ranking
Referrer : http://www.xxxxx.xxx/xperience.php
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.95

Yes is the same Error my vbullettin 4.1.11

Please replace xperience.php in the root with the file attached.
Installation ZIP has been also replaced.

Its same condition...when install complete database error in admin panel

Attachment 136895