Thanks man it worked, but I don't see any difference with the upgraded one, looks exactly the same to me.

Do you think maybe you could add a quick readme stating the userfield will default to zero with the upgrade? I think it will save people time and concern. I found that to be the cause of the immediate database call fails that I experienced after updating with the latest version.

Quick readme addition to the zip would probably clear up confusion for newer users, too.

Just a painless suggestion. Good product. Updated again.

I have this error as well and I can't access my admincp to fix it!

As always - great work!

One issue I am having though, is the reputation does not seem to be updating for some reason. Any idea why that may be? If you hover over the stars, it shows reputation: 10 and each person only shows 2 1/2 stars?

@harlita, there is a not about the field id change in the upgrade notice above. I also do not like to distribute readme's as they are too static and I can't make adjustments to them once they are out the door, not to mention another document to keep updated. The instructions above should get any new user through ok.

@fatony69, there shouldn't be anything that prevents you from accessing the admincp. However, in the event a plugin causes such an issue, you can add define('DISABLE_HOOKS', true); to your config.php to disable plugins while you troubleshoot the problem.

Actually upon reflection, there could be a problem with the script in this regard. I will double check this.

@doogie1775, Reputation 10 is about 2.5 stars. There is a max of 20 reputation, so 10 rep is half of 5 stars which is 2.5.

Yes, I am with ya there Gryphon, but what I am saying is "everyone has 2.5 stars" and I know that isn't the actual case. Most, if not all of us, have 5 star reps in XBL.

thanks for the prompt response :)

Hmm, that is odd. I am not sure why that would be the case. Would you mind PM'ing me your address for your installation?

I have it disabled like you said and still recieve this. I like this addon, so I don't mind doing this extra work:)


Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reputation) AS `reputation`,
SUM(gxboxlive.gold) AS `gold`
FROM
`gpuser` AS user
LEFT JOIN
`gpuserfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gpgxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN(8)

AND
field0 != ''
AND
user.posts >= '10'
AND
user.lastvisit >= '0'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

MySQL Error : Unknown column 'field0' in 'where clause'
Error Number : 1054
Date : Friday, January 25th 2008 @ 10:10:32 PM
Script : http://www.gamerspride.com/phpBB2/online.php
Referrer : http://www.gamerspride.com/phpBB2/online.php
IP Address : **********
Username : ********
Classname : vb_database

Try version 2.1.4, it appears that you are not having any errors at present on your site. Are you still unable to access the admincp?

Thanks everything working . But one little issue on the leaderboard when u use firefox everything is ok , but when u use Internet explorer some pics have X why is that?