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]

@sdsvtdriver, You can edit your config.php and add define('DISABLE_HOOKS', true); to disable the plugins. You can then uninstall and then remove the line from the config.

That is really odd. I am not quite sure what could cause that.

[sdsvtdriver]

it was permissions, i removed the post but you replied too quickly

it loads now, however i have appeared to lost my existing leaderboard. it only had a few people, so not a big deal, however I've added myself but it doesn't seem to be appearing.

[sdsvtdriver]

fixed. had to set the profile field again in the options.

[kindi_boy]

Hi,

i would like to ask how to force update to the list and how to actually
make any modification on how often it updates automatically?

thx

[Viper007Bond]

If the user doesn't use the exact same capitalization as their XBL profile, it won't highlight them and scroll to them.

Example: http://forums.finalgear.com/gxboxlive.php?gt=Phyrenet

His XBL profile is really "phyrenet".

Not a big deal, but I thought I'd point it out.

Keep up the GREAT work!

[kindi_boy]

it's not updating, dose closing the forums have any effect on the product?

[Canis Firebrand]

I'm not sure if the Min Post count requirement is working. I am running vB 3.6.4 still.
I upgraded this plugin to the latest version. I set the min post count to be 25 posts before they should show up in the list. I have people with 0 posts showing up.

Also, is there a way, or would it be considered, to allow only certain member groups to show up in the list. Kind of how you have it filter out usergroups to view the list?

[Sar]

Originally Posted by Gryphon

Upload all files

:O

I'll blame my zip program - thought I had.

Doh!



Anyway, got it all uploaded: http://www.the-yarn.net/forums/gxboxlive.php

But when I try to run a Scheduled Task update in the Admin CP it gives the following error:

Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT
          user.userid,
          user.posts,
          user.lastvisit,
          userfield.field16,
          gxboxlive.updated
      FROM
          `vbuser` AS user
      LEFT JOIN
          `vbuserfield` AS userfield ON (user.userid = userfield.userid)
      LEFT JOIN
          `vbgxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
      WHERE
          user.posts >= '0'
      AND
          (userfield.field16 != '' AND userfield.field16 != 'User does not exist')
      AND
        (gxboxlive.updated is null OR DATE_FORMAT( FROM_UNIXTIME( gxboxlive.updated ), '%Y-%m-%d' ) != '2008-01-16')
          
        ORDER BY
            RAND();

MySQL Error  : Unknown column 'userfield.field16' in 'field list'
Error Number : 1054
Date         : Wednesday, January 16th 2008 @ 03:46:12 PM
Script       : http://www.the-yarn.net/forums/admincp/cronadmin.php?do=runcron&cronid=18
Referrer     : http://www.the-yarn.net/forums/admincp/cronadmin.php?do=modify
IP Address   : 81.xxx.xxx.xxx
Username     : Sar
Classname    : vb_database

At the moment it's showing 1 user on the leaderboard, and it's using his occupation field as a gamertag, and his occupation just so happens to be some random guy's gamertag! :P

I have my own GT entered (Saruya X360) as well as having edited a couple of my friends profiles to enter their GT's too, but it's still only showing the one user with the wrong GT applied to him.

I've tried changing the field ID just incase it was the same ID as the occupation field, but no dice so far.

Many thanks for any further help, as this is a cracking wee mod :up:

[Gryphon]

Originally Posted by kindi_boy

Hi,

i would like to ask how to force update to the list and how to actually
make any modification on how often it updates automatically?

The total gamertags are spread out over the course of the day and they are each updated once a day. There isn't really any reason to update more often than that, however, I will probably add an option for users to refresh their own score if they want an immediate update due to a score discrepancy mid-day. But the scores are not that volatile that they should require updates any faster, and not to mention disrespectful of the xbox.com services.

Originally Posted by Viper007Bond

If the user doesn't use the exact same capitalization as their XBL profile, it won't highlight them and scroll to them.

Thank you, I did not think of that. I will fix that for the next version.

Originally Posted by kindi_boy

it's not updating, dose closing the forums have any effect on the product?

It should not affect it. Double check your field ID setting, the update resets it due to changes I needed to make in the product.

Originally Posted by Canis Firebrand

I'm not sure if the Min Post count requirement is working. I am running vB 3.6.4 still.
I upgraded this plugin to the latest version. I set the min post count to be 25 posts before they should show up in the list. I have people with 0 posts showing up.

Also, is there a way, or would it be considered, to allow only certain member groups to show up in the list. Kind of how you have it filter out usergroups to view the list?

There are some display issues with the post count option I need to fix. If the leaderboard updated with users with zero posts and then you later change it to people with 10 posts, people with less than 10 posts wont be pruned for a couple of days. There are some other problems with it as well, it is kind of a messy spider web of permissions I need to sort out some more.

It currently doesn't filter any usergoups accept for banned (I think if even that works right). I will have to work on more usergroup options as well.

Originally Posted by Sar

Anyway, got it all uploaded: http://www.the-yarn.net/forums/gxboxlive.php

But when I try to run a Scheduled Task update in the Admin CP it gives the following error:

Double check the field ID because that error is pretty telling, there is no such field 16, maybe it's supposed to be 6 or some other common mistake.

[HellBoy]

I noticed that several gamertags keeps disappearing and reappearing throughout the day, and this happens mostly for active users. Any quick fix for this to make qXBL update as the old versions did?