Add-On Releases - gXboxLive - Xbox Live Leaderboard

What is it?
gXboxLive is a modification for vBulletin which allows you to display a Xbox Live Leaderboard for your users.

If you use this mod, please Mark as Installed, and if you really enjoy this mod, please Nominate for MOTM, and if you really really enjoy this mod, feel free to Support Developer! Thank you!

Visit this thread for vBulletin 4 compatible version.

[hr]-[/hr]
Support
[hr]-[/hr]I use my released mods daily, if I find an issue with them or add features for myself I will release updates. If there are significant bugs or simple feature requests I will do my best to release fixes. Some of my mods rely on fetching data from 3rd party websites, due to the unreliable results, my mods will require users to troubleshoot for themselves if they find the addon is not working for them specifically. I am offering my personal mods that work ok for me for you to use, I am sorry I do not have time to troubleshoot many user specific issues. Thank you for your understanding.

Features
[hr]-[/hr]

• Lists all ranked Gamertags, each updated once per day
• Optionally show unranked Gamertags (Original Xbox Users).
• Optionally allow Xbox Live message sending.
• Optionally allow Xbox Live friend requests.
• Optionally to choose how many User Names Per Page to display.
• Optionally require a minimum post count.
• Optionally to add a navbar link.*
• Optionally to add a miscellaneous quick link.*
• Choose how recently users must be active to be displayed.
• Optionally display leaderboard statistics
• Limit usergroups to display.
• Limit access by usergroup.
• Optionally display Forumhome stats
• Optionally display Memberinfo gamercard
• Optionally display Postbit leaderboard rank
• Monitors invalid gamertags, 5 attempts to verify the gamertag and then the users gamertag profile field is blanked to prevent further checks.
• Can link directly to a gamertag position in the leaderboard with gxboxlive.php?gt=Gamertag

*Depends on your vBulletin version and template configuration.

Installation
[hr]-[/hr]

1. Download the latest version and upload all files. Images go in the folders specific to your style.
2. Install the product.
3. Create a Single-Line Text Box User Profile Field for members to enter their Gamertag into.
   • Go to yourdomain.com/forumdir/admincp/?loc=profilefield.php%3Fdo%3Dadd
   • Single-Line Text Box
   • Continue
   • Title: Xbox Live Gamertag
   • Description: Enter your Xbox Live Gamertag
     [S]
   • Regular Expression: ^([A-Za-z0-9 ]+)?$[/S] (regex not required)
   • The rest of the settings is your prefrence.
   • Save
   • Look and see what the field id number is for Xbox Live Gamertag, example field25.
4. Fill in the gXboxLive configuration options, make sure to enter the field id for the newly created Xbox profile field above.
   • Go to yourdomain.com/forumdir/admincp/?loc=options.php%3Fdo%3Doptions%26dogroup%3Dgxbl_g roup
5. Send people to their user cp to enter their gamertags.
6. Wait up a few minutes for the gamertags to appear on the leaderboard.

Examples
[hr]-[/hr]Authors

• http://alliedtribalforces.com/gxboxlive.php
• http://thzclan.com/forums/gxboxlive.php

Others

• http://forums.3drealms.com/vb/gxboxlive.php
• http://www.alanwake.com/forum/gxboxlive.php

Google

• http://www.google.com/search?q=allin...oxlive.php+-gt

Changes
[hr]-[/hr]
v2.2.6 - import product with Overwrite enabled, upload functions_gxboxlive.php and miner.gxboxlive.php

• Updates for April 18 gamercard changes.
• Uses DOMDocument PHP class now for parsing.

v2.2.5 - import product with Overwrite enabled, upload gxboxlive.php, functions_gxboxlive.php and miner.gxboxlive.php

• Updates for January 20th gamercard changes. Thanks Ronin Storm.

v2.2.4c - import product with Overwrite enabled.

• Quick xbox.com url changes, there is no longer any way to directly link to add a friend.

v2.2.4b - upload miner.gxboxlive.php

• Quick fix for miner, no other updates.

v2.2.4a - upload miner.gxboxlive.php

• Quick fix for num_rows error, no other updates.

v2.2.4 - upload functions_gxboxlive.php, miner.gxboxlive.php, import product with Overwrite enabled.

• Minor update, confirmed bogus gamertags do not cause issues with updating the rest of the leaderboard.
• Changed cron output to help find the people with bad usernames.
• Extended strikeout rule for bad usernames.

v2.2.3 - upload functions_gxboxlive.php, import product with Overwrite enabled.

• Reverted, no problems that I can find with leader board.

v2.2.2 - upload functions_gxboxlive.php, import product with Overwrite enabled.

• Temporary fix till more time can be spent to make updates for NXE

v2.2.1 - import product with Overwrite enabled.

• Added NXE avatar display

v2.1.9 - import product with Overwrite enabled.

• Security token update.
• Postbit style update.

v2.1.8 - upload gxboxlive.php, import product with Overwrite enabled.

• Security Fix.

v2.1.7 - upload functions_gxboxlive.php, import product with Overwrite enabled.

• Fix for query error.

v2.1.6 - upload gxboxlive.php, functions_gxboxlive.php, miner.gxboxlive.php, import product with Overwrite enabled.

• Update to close the leaderboard when product is disabled.

v2.1.5 - upload functions_gxboxlive.php, import product with Overwrite enabled.

• Fix for error when running cron manually.

v2.1.4 - upload files, import product with Overwrite enabled.

• Added some safety checks to keep the wrong field id from breaking the forums.

v2.1.3 - upload functions_gxboxlive.php, import product with Overwrite enabled.

• Fixed a broken update query.

v2.1.2 - import product with Overwrite enabled.

• Fix a bug that prevented total number of users to display when stats were turned off.

v2.1.1 - import product with Overwrite enabled.

• Navbar location selectable
• Quick Links location selectable
• Postbit location selection slightly changed, you will need to revisit this setting.

v2.1.0 - upload all files, import product with Overwrite enabled.

• Nearly all database queries rewritten to be more efficient
• Member listing is more stable, shouldn't see people disappear/reappear
• Image directories changed, /rank directory now called /silk
• New images for message user and add friend
• Leaderboard will now properly filter banned users
• New option to choose what usergroups are displayed on the board separate from who can view the board
• Database structure changed, so the leaderboard will need to repopulate after upgrade.
• Updated regex in the instructions above, this makes sure that people enter gamertags in the correct format.

v2.0.2 - upload all files, import product with Overwrite enabled.

• Stats display reorganized
• Gamertag linking is case insensitive now
• Fix for page navigation disappearing for leaderboards with over 1000 members.
• Fix another headinclude bug
• Temporarily disabled user update hooks

v2.0.1 - import product with Overwrite enabled.

• Fix headinclude bug

v2.0.0 - Upload all files import product with Overwrite enabled. Double check settings, field id method has changed, it is digit only now. In case of error upon upgrading from a previous version, uninstall and then reinstall.

• Rewritten much of the caching code to be more efficient
• Optionally display Forumhome stats
• Optionally display Memberinfo gamercard
• Optionally display Postbit leaderboard rank
• Can link directly to a gamertag position in the leaderboard
• Monitors invalid gamertags, 5 attempts to verify the gamertag and then the users gamertag profile field is blanked to prevent further checks.
• Many more improvements

Copyright
[hr]-[/hr]gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

overLIB javascript library Copyright Erik Bosrup.

[akoj]

Thank you very much for this. Install went great on 3.8

[Scarface Claw]

these instructions suck. how do I know where to upload the folders to?

[Jason UK]

There has been a fair bit of bad press about the non-validation of the code. It pertains to anyone using an SEO system which usually requires XHTML to validate.

I have gone through the code for you on various sites that use the mod and the general errors appear to be.

Error 1: character "<" is the first character of a delimiter but occurred as data.

for(i = 0; i < links.length; i++) links.item(i).style.cursor = typeof type == '

Error 2: there is no attribute "onload".

var html = '<iframe onload="gXBL_setcursor();" src="http://gamercard.xbox.com/

Error 3: there is no attribute "frameBorder".

?g+'.card" scrolling="no" frameBorder="0" height="140" width="204">'+gamertag+

Error 4: document type does not allow element "iframe" here.

?meBorder="0" height="140" width="204">'+gamertag+'</iframe>';

Error 5: document type does not allow element "iframe" here.

?meBorder="0" height="300" width="150">'+gamertag+'</iframe>';

Error 6: XML Parsing Error: StartTag: invalid element name.

for(i = 0; i < links.length; i++) links.item(i).style.cursor = typeof type == '

I would imagine the popularity of this will shoot up tons once it validates simply because the sites that use SEO are going to be more inclined to use it and they are far more popular then most non-SEO sites.

[TheInsaneManiac]

Why do the avatars show in full?
http://img156.imageshack.us/img156/3...erboardfu0.jpg

[smokey]

Originally Posted by XFSImperial

When I run the cron job manually, I get this error:

gXboxLive Update 

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in \includes\cron\miner.gxboxlive.php on line 85
Updated Accounts: gamertag, gamertag, gamertag

Process Time: 2s.

Total Queries: 79.
Done

Still an issue if you run cron manually no matter the version of vB and everyone using the latest is affected especially if you are using the mysqli module rather than mysql. It seems everything still works though with this error but here is a hotfix until its updated. To see, run the scheduled task gXboxLive Update manually and you will get this error.

On line 85 in includes/cron/miner.gxboxlive.php

Find:

PHP Code:

$querylimit = ceil(mysql_num_rows($fullresult) / ceil((strtotime(date("Y-m-d", strtotime("+1 day"))) - TIMENOW) / 60) ) + 5; 


Replace with:

PHP Code:

$querylimit = ceil($vbulletin->db->num_rows($fullresult) / ceil((strtotime(date("Y-m-d", strtotime("+1 day"))) - TIMENOW) / 60) ) + 5; 


Error will be gone. Quite surprised the code has been like this for this long LOL. That is standard code and nothing was wrong with it, in most cases it would work but not with vBulletins setup. Hopefully this will be fixed in future updates.

Also I would recommend setting up the cron to run on 10 minute intervals or less even rather than every page load. Current setup is

* * * * * gXboxLive Update.

This is not good if you have a lot of id's to process, many queries every page load, performance will lag big time. My setup

00, 10, 20, 30, 40, 50 * * * * gXboxLive Update

No need having a crap load of queries every time a page loads. It will all update none the less even on a 12 hour cycle.

Hopefully this helps anyone still having issues.

My 2 cents.

[Gryphon]

Originally Posted by Scarface Claw

these instructions suck. how do I know where to upload the folders to?

It uses the exact same structure as the vBulletin install.....

Originally Posted by smokey

No need having a crap load of queries every time a page loads. It will all update none the less even on a 12 hour cycle.

You are actually increasing the queries when it runs by doing that. The cron file itself contains the timing needed to spread the queries out over the course of 24 hours, running it fewer will increase the amount of queries needed for that run.

[smokey]

Originally Posted by Gryphon

You are actually increasing the queries when it runs by doing that. The cron file itself contains the timing needed to spread the queries out over the course of 24 hours, running it fewer will increase the amount of queries needed for that run.

My thought was with boards with heavy usage could have quite a few per page loads but I see what you mean as it runs in background. It was just a thought however. In my case, I'd rather have less queries run per page load and have them run at a less frequent interval. Just a suggestion to those with large communities.

PS good script. Thx!

[Booyakan]

Is there any way to limit this to just one game? Like just pull the gamer score/stats for madden? If not, does anyone know of any other hacks that do this?

Thanks
Great Mod!

[Stryker412]

Each time I load the index of my forum the leaderboard fails to load the avatars/gamer pics of those on it and it hangs the index.

[TheInsaneManiac]

Why are my avatars showing in full?