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.

[Gryphon]

Originally Posted by Joe Siegler

What does this mod do if they put in a username, and have their settings on Xbox set to not broadcast what they're doing? Would that gum up this addon?

It will work fine, everyone has a public gamercard.

Originally Posted by Joe Siegler

The only thing I can come up with is the plugin chokes if it runs into a user profile it can't deal with. I'm not seeing any errors, there's nothing in the log. What *DOES* the plugin do with a user profile whose security is set that you can't read their data when you try?

If someone enters a bogus name you will see:

Warning: Unable to fetch URL: http://gamercard.xbox.com/this+is+a+fake+name.card in [path]/includes/cron/miner.gxboxlive.php on line 99

Originally Posted by Joe Siegler

Random thought about my issue. If someone put a gamertag of all spaces in that field, would that explain this? Would vB even accept all spaces as data there?

vBulletin trims profile field entries, all spaces is the same as blank.

Joe, I am afraid I just do not have an answer for what could be causing the issue.

Originally Posted by Chris11987

Would it be difficult to let the url of that page just be "xboxlive.php" instead of with the g?

You would have to change all refrences to that address in all of the files.

Originally Posted by Chris B

Hi, how would I go about changing the name of the mod in the navbar only, I'm fine with the gXboxLive name being used elsewhere I just want ti changed in the navbar.

They are handled by phrases. Search phrases for gXboxLive and make the desired changes.

Originally Posted by sdsvtdriver

A user brought up that the leaderboard is out of date on my site. His score is higher according to xbox.com.

Gamercards are only scanned once per day, manual scheduled task runs will not change that. So the user will have to wait up to 24 hours for it to update. If it is several days beyond when he last changed his score and gXboxLive is still not updating, I can't think of what would cause this off the top of my head.

Originally Posted by JVCode

Okay, I have an error message, which was sent to me by email:


Invalid SQL:
SELECT error FROM `vb_gxboxlive` AS gxboxlive WHERE error = '1' ORDER BY error DESC;

I am afraid I do not know what is invalid about that query, unless the product hasn't been updated/installed?

[JVCode]

Thanks for the reply, I think i'll just uninstall and move on lol, this hack is more trouble than it's worth!

[Gryphon]

Originally Posted by JVCode

Thanks for the reply, I think i'll just uninstall and move on lol, this hack is more trouble than it's worth!

There are a lot of people that have not had any trouble with the mod, including some with thousands of gamertags. Sorry to that I couldn't help you out better, the mod has been flawless for me and it is tough to troubleshoot problems I can't reproduce.

[Chris11987]

I'm having the same problem as others. Many of the gamertags aren't showing up for people on the leaderboard. They show up in their profiles fine, but not on the leaderboard. This is after hours and hours, and also running the task.

[Joe Siegler]

Originally Posted by Gryphon

vBulletin trims profile field entries, all spaces is the same as blank.

Joe, I am afraid I just do not have an answer for what could be causing the issue.

Let me ask you this. Do you know of a way to let me see which user accounts have put data in the specific field, and show it?

I could manually go through a list of users with data in the specific field (and what they've entered). and see if there's corrupt data and remove it. I'm seeing no errors, so either I'm looking in the wrong place, or the script is not throwing any.

If I could take a look at everyone's data for that field, it might help me. If your script doesn't do this, how hard would it be to write a quickie little something to make this happen? Kind of a "debug" script to go along with your main one?

Edit: I sort of managed to unstick this, although I don't know if I fully fixed it. Since I can't find a way to get vB to show me every user who has entered any kind of data into a custom field, I had to improvise. I did two separate searches for people who entered the letter e and the letter a into that particular field. Found quite a lot of users. I went through them one by one. I found a handful of users who had dead accounts, so I blanked that data field. Found a handful whose XBL accounts had a gamerscore of zero, and hadn't logged into my forum for over 6-8 months, so I just deleted those accounts outright. However...

I found a decent amount of them who had put junk in the profile field. I cleared all that out, but kept track of it. The list of the junk data in there from about 130 profiles I looked through manually. Here's the list:

Destroy All Humans.
aweddball
no like da xbox
^eRrOR^
Nope don't got it
I don't have one
I play PS2 Online
I hate consoles!
I Use Xbox Connect
Don't have a Wii, or PS3, or any other gaming console except for the PC for that matter!
not yet
PS Network: Spyd77
A what-box?!
I have no console.

What's really interesting is right after I force ran the script, my number of users on the charts jumped from 104 to 133 immediately. It seems like something in one of the profiles I changed or deleted was sticking the script. Is it possible that fourth one was culprit? Are there any data strings that would just cause the script to flat out STOP working?

Unrelated to this, I did have a thought. What would your script do if two users put the same data in the profile field? Would it just process them anyway, or would there be a problem if two user accounts had the same XBL tag?

[Gryphon]

It might be possible that one of those characters broke it, I will look into it, though I am pretty sure I encode the entries. There is a strikes system as well, if a gamertag can not be found within 5 tries the field is blanked.

Two or more people with the same gamertag will work fine, I did that for a while with my entry and my wife's.

[comet2500]

I'm also having a problem..

The plugin won't install..

It keeps saying that the sql is causing an error, and I wrote a ticket and they said to contact your community that created the mod.

It keeps saying..

"invalid Vb table, and then the sql says dropped."
"Alter Table."

[phractured]

I installed it a while back and while updating I now get this message http://talk360.net/

I believe it has something to do with that mod, so I deleted the tables for it but I still get that error.

[stud]

Love the most recent update! THANKS!

[imported_martyjp]

Originally Posted by phractured

I installed it a while back and while updating I now get this message http://talk360.net/

I believe it has something to do with that mod, so I deleted the tables for it but I still get that error.

Have you removed the product or just removed the tables?