gXboxLive - Xbox Live Leaderboard

[Gryphon]

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 (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=139958), 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 (https://vborg.vbsupport.ru/showthread.php?t=243493) for vBulletin 4 compatible version.

-
Support
-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
-
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
-
Download the latest version and upload all files. Images go in the folders specific to your style.
Install the product.
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
Regular Expression: ^([A-Za-z0-9 ]+)?$ (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.

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

Send people to their user cp to enter their gamertags.
Wait up a few minutes for the gamertags to appear on the leaderboard.


Examples
-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=allinurl:gxboxlive.php+-gt


Changes
-
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
-gXboxLive, Copyright ? Ghryphen (https://github.com/ghryphen)
Please maintain copyrights in derivative works, thank you.

overLIB (http://www.bosrup.com/web/overlib/) javascript library Copyright Erik Bosrup.

[Sexified Ninja]

nice

[feverwilly]

I tried to install it on my board and i got the following error

Warning: Invalid argument supplied for foreach() in /gxboxlive.php on line 85

http://www.360leagues.com/forums/gxboxlive.php

[Gryphon]

Looking into that.

Made a minor change, let me know if that fixes it.

[blockbusted]

Installed. Nice hack :)

[Gryphon]

Thanks, looks like I might have to implement pagination :D

Has it affected forum load? Both of your sites load a little slow for me.

[feverwilly]

Yes they are running a lil slow

[feverwilly]

the sites load normal in Firefox and slow in IE explorer..

[tappedout]

Awesome!! Installed!!

[feverwilly]

everythings fixed.. some bad code in the navbar. Site seems to be running at a good speed..

[Cajun]

Installed nice work.

The only thing is the page gets long for sites with a large user base.

[Gryphon]

Hehe nice Cajun, I will definitely be working on pagination next.

[tappedout]

Blackjack I sent you a PM.... Thanks

[Omikaru]

This is great! Once you get pagination in, I'll definately be installing this.

[feverwilly]

whats Pagnation?

[Gryphon]

whats Pagnation?
Split the list into numbered pages.

[powerbook]

Hi,

I get this when trying to run the cron job in the AdminCP

Fatal error: Call to undefined function: curl_init() in /home/xxx/public_html/includes/cron/miner.gxboxlive.php on line 48

[jkwasn01]

very nice!! Works great! working on a button for the nav bar now

**INSTALLED**

http://www.thevhub.com/forums/gxboxlive.php

[Gryphon]

Fatal error: Call to undefined function: curl_init()

Looks like you don't have php compiled with cURL. I will look at making cURL optional.

[powerbook]

Thanks, great hack though!!

[syrus.xl]

whats Pagnation?

It means it will split the page after a certain number of entries is reached.

[syrus.xl]

I'm getting the same database error with this modifcation with 3.6.2 and 3.6.4 :(

Field 12 is defined in Profile fields.

See below for the error:
Database error in vBulletin 3.6.2:

Invalid SQL:
SELECT vb3user.username, vb3user.userid, vb3user.lastvisit, vb3userfield.12 FROM `vb3userfield` LEFT JOIN `vb3user` ON vb3userfield.userid = vb3user.userid WHERE vb3userfield.12 != '';

MySQL Error : Unknown column 'vb3userfield.12' in 'field list'
Error Number : 1054
Date : Thursday, February 22nd 2007 @ 11:22:20 AM
Script : http://www.digitalport.co.uk/digital/admincp/cronadmin.php?do=runcron&cronid=50
Referrer : http://www.digitalport.co.uk/digital/admincp/cronadmin.php?do=modify
IP Address : **.**.**.**
Username : syrus
Classname : vb_database

[Gryphon]

The correct entry should be field12 not just 12.

[syrus.xl]

Thanks works perfect! I have another mod that uses just the field ID, thats why I left it out.

[Gryphon]

Yeah, I had a feeling that might come up. I can easily make it so it will accept either which I will implement.

[Gryphon]

Updated with some changes, still working on pagination.

[fernas]

I suggest that will be very nice if you add a code or something to put the personal position of each user in Postbit.

Sorry for my English...

[Gryphon]

I will look into that, however the position is processed at time of display, it isn't stored anywhere to be able to call it for the postbit so I will have to investigate how to accomplish such a thing.

In other news: I have pagination working, however now the cron appears to have stopped working. Once I have figured out why that has happened I will have a new version up.

[wattieuk]

Works perfectly. Many thanks.

[ringoflight]

Works perfectly. I would have paid anything for a hack like this. Might have to send a donation !

[Sjakie]

Great mod. Thanks very much!

See it on my dutch xbox forum: http://www.xboxforum.nl/gxboxlive.php

[blockbusted]

Thanks.

Great mod. The newest update is very nice!

[Sexified Ninja]

Could you add some features like required amount of posts to be included?

[Sjakie]

Only the friend request and the mail button at the end are orange outlined.
How can I remove this outline (maybe include border "0" somewhere?)

Thanks
http://www.xboxforum.nl/gxboxlive.php

//EDIT// already fixed now!

[Gryphon]

Sexified Ninja, no problem I can add that.

Sjakie, yeah I noticed that and have fixed that for the next version. I didn't realize that as I my css put zero border on all images.

Update: Sjakie, I can see that there are some issues with the avatars over lapping the Gamertags on your board. I will attempt to fix this.

[blockbusted]

Another great update :) Usernames per page really helps with the server load. Thanks!

[Gryphon]

Thanks :D I noticed a banned person is showing in your list. I will have to put in a check for that.

[Sjakie]

I get a MySQL error, this is the message:

Database error in vBulletin 3.6.4:

Invalid SQL:
SELECT vb_gxboxlive.*, vb_gxboxlive.reputation AS rep, vb_user.* FROM `vb_gxboxlive` LEFT JOIN `vb_user` ON vb_gxboxlive.userid = vb_user.userid ORDER BY vb_gxboxlive.rep ASC, vb_gxboxlive.score DESC, vb_gxboxlive.gamertag ASC LIMIT 0,30;

MySQL Error : Unknown column 'vb_gxboxlive.rep' in 'order clause'
Error Number : 1054
Date : Monday, February 26th 2007 @ 11:10:47 PM
Script : http://www.xboxforum.nl/gxboxlive.php?page=1&sortfield=r&sortorder=asc
Referrer : http://www.xboxforum.nl/gxboxlive.php?do=getall
IP Address : 71.216.187.10
Username : Niet geregistreerd (unregistered)
Classname : vB_Database

[Gryphon]

Thank you, I saw that there was a db error on your site when sorting by reputation. I will fix this for the next release, not sure why it doesn't happen on my servers. /shrug

[Sjakie]

I'm not so good with MySQL, what does this error mean, and how does it affect my forum?

//EDIT// ok the reputation sorting, Does it do any harm?

[Gryphon]

It does not do anything harmful, it just displays a database error when someone chooses to sort the list by Reputation.

Version 1.21 released to fix this issue.

[Sjakie]

Works! Tnx.

[tappedout]

Great Mod blackjack and everything works fine except I get the %20 where the Spaces are in the Gamertag? Any Idea how to fix this?

[Gryphon]

It appears ok to me, I do not see any %20.

[tappedout]

Great Mod blackjack and everything works fine except I get the %20 where the Spaces are in the Gamertag? Any Idea how to fix this?

Nevermind I think the Cron just had to kick in! Works great! Thanks man, great MOD I am sure to use the heck out of it!! But I do have one question but I am going to send you a PM! Thanks!

[feverwilly]

I uploaded and installed the update it seems to run fine.

I limit it to the Admin Group and users inactive for 60 days or less and less then 10 posts and get the following error when I run it as a cron job manually.


Warning: Unable to fetch URL in /includes/cron/miner.gxboxlive.php on line 73
Updated Accounts: 47. Deleted Entries: 0. Process Time: 11s. Total Queries: 56.

Done


http://360leagues.com/forums/gxboxlive.php

thanks,

[Gryphon]

I will check on that.

[Cajun]

Nice work. Just installed the update and works great.

Now all we need is a search function. :D ;)

[Robbed]

Thanks

Good work

[Sjakie]

Love the new work you've put into this hack.

One question: Is it possible to show the Leaderboard statics on the index page of my forum? I've tried to input "$gxbl_stats" into the FORUMHOME template, but this didn't work

[Gryphon]

Love the new work you've put into this hack.

One question: Is it possible to show the Leaderboard statics on the index page of my forum? I've tried to input "$gxbl_stats" into the FORUMHOME template, but this didn't work

It is not currently possible. I am not sure how easy that would be, I can look into it.

[jgommel]

This just keeps getting better and better... I've actually run out of ideas to throw at you Blackjack. Hmmm, let me think now...

[Robbed]

Uncached templates: gxbl_top_avatars (5)
Uncached templates: gxbl_top_players (5)
Uncached templates: gxbl_top_zones (3)

[Gryphon]

Ah yeah, I forgot that. v1.31 should fix that.

[Robbed]

Thanks Again

[Canis Firebrand]

I uploaded the files and overwrote the older version I had. When I view my list, the gamertag icons and games aren't there.
So, I tried to force the cron job to run. When I do so, I get a database error.


Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
user.*,
userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`userfield`
INNER JOIN
usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN
`user` ON userfield.userid = user.userid
WHERE
user.posts >= '0'
AND
userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Wednesday, February 28th 2007 @ 04:48:56 AM


I looked at my phpadmin and the user table does have a field called usergroupid. So, I'm not sure why it is saying that it is an unknown column.

Also, in the Leaderboard Statistics section, the Top Avatar just reads "By 2 players By 2 players By 2 players By 1 player By 1 player"

That might be because the cron job won't run, however.

[Canis Firebrand]

I still had the 1.21 zip file, so I went back to that and it that version works. I never updated to 1.30. I went right from 1.10 to 1.31 by uploading all files and overwriting them all and importing the product with an overwrite.

Something in the 1.31 query my database doesn't like. I'll stick with 1.21 until you can take a look and see if you can figure out what might be happening. I know that 1.31 works as I've seen it on other sites that you have linked in the first post.

My host was using php 4.4.2 I was able to change it and tell it to use 5.1.2 but I still got the sql error when the cron job ran. I've since told it to go back to 4.4.2 as the 5.1.2 was causing an issue with searches on my forum.

[Gryphon]

Hmm, interesting. I will see what I can find out about this. Just in case others have the same issue I have made v1.21 and v1.10 available for download. You should be able to go from any version to v1.31.

For info; I develop on two servers, PHP version 4.3.11 and PHP version 4.4.3.

[powerbook]

I got similar DB errors and reverted back to previous version. Now I get DB failures when the cron tries to run...

[Gryphon]

If you install an older version, you need to uninstall and then reinstall. You can not install an older product over the top of a newer product.

[powerbook]

I dropped the two tables manually and now the issue seems to be fixed... Thanks

[Neoka21]

hi!, i have this problem:

Database error in vBulletin 3.5.2:

Invalid SQL:

### INSERT QUERY GENERATED BY fetch_query_sql() ###
INSERT INTO vb_plugin
(`active`, `executionorder`, `title`, `hookname`, `phpcode`, `product`)
VALUES
('1', '5', 'gXBL Cache', 'cache_templates', '$globaltemplates[] = \'gxbl_vbnav_quicklink\';\r\n$globaltemplates[] = \'gxbl_vbnav_navbarlink\';', 'gXboxLive');

MySQL Error : Unknown column 'executionorder' in 'field list'
Error Number : 1054
Date : Saturday, March 3rd 2007 @ 02:24:20 AM
Script : http://www.gamersforce.com.mx/foro/admincp/plugin.php
Referrer : http://www.gamersforce.com.mx/foro/admincp/plugin.php?do=productadd
IP Address : 189.135.237.220
Username : Neoka21
Classname : vb_database

[josh_B]

I installed this, very nice by the way, however, some have high scores etc.. but there are no icons for games played.. Rest have them.. Is there an icon set I need to update from time to time?

[PabloAM]

I uploaded the files and overwrote the older version I had. When I view my list, the gamertag icons and games aren't there.
So, I tried to force the cron job to run. When I do so, I get a database error.


Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
user.*,
userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`userfield`
INNER JOIN
usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN
`user` ON userfield.userid = user.userid
WHERE
user.posts >= '0'
AND
userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Wednesday, February 28th 2007 @ 04:48:56 AM


I looked at my phpadmin and the user table does have a field called usergroupid. So, I'm not sure why it is saying that it is an unknown column.

Also, in the Leaderboard Statistics section, the Top Avatar just reads "By 2 players By 2 players By 2 players By 1 player By 1 player"

That might be because the cron job won't run, however.

Same problem :(

Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
user.*,
userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`userfield`
INNER JOIN
usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN
`user` ON userfield.userid = user.userid
WHERE
user.posts >= '0'
AND
userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Saturday, March 3rd 2007 @ 08:57:58 PM
Script : http://www.xboxers360.net/admincp/cronadmin.php?do=runcron&cronid=25
Referrer : http://www.xboxers360.net/admincp/cronadmin.php?do=modify
IP Address : 81.202.163.34
Username : PabloAM
Classname : vB_Database

One solution?

[Gryphon]

hi!, i have this problem:

Database error in vBulletin 3.5.2:

Neoka21, sorry this product is for vBulletin 3.6, there are plugin changes that aren't available in 3.5. However, I can look into making it 3.5 compatible.

Same problem :(

One solution?

Sorry, I got sidetracked on about 4 other modifications I'm working on. I will look into correcting this database error soon. v1.21 should work in the meantime until I can release v1.32.

[ORACLE]

Hi im getting this error on 3.6.4 does it have to be 3.6.5???
thanks
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
user.*,
userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`userfield`
INNER JOIN
usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN
`user` ON userfield.userid = user.userid
WHERE
user.posts >= '0'
AND
userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Sunday, March 4th 2007 @ 04:06:56 PM
Script : http://www.digital-community.co.uk/forum/admincp/cronadmin.php?do=runcron&cronid=25
Referrer : http://www.digital-community.co.uk/forum/admincp/index.php?loc=user.php%3Fdo%3Dedit%26u%3D22
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database

[ORACLE]

im not using 3.6.5 and i get this i think its the same not checked properly:
Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
user.*,
userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`userfield`
INNER JOIN
usergroup AS usergroup ON(usergroup.usergroupid = user.usergroupid)
LEFT JOIN
`user` ON userfield.userid = user.userid
WHERE
user.posts >= '0'
AND
userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'user.usergroupid' in 'on clause'
Error Number : 1054
Date : Sunday, March 4th 2007 @ 05:45:34 PM
Script : http://www.digital-community.co.uk/forum/admincp/cronadmin.php?do=runcron&cronid=26
Referrer : http://www.digital-community.co.uk/forum/admincp/index.php
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database

[Gryphon]

Thank you, yes it is compatible with all 3.6.x, I have an error in my query statement as reported by two others already. I need a few more days to get some time to sort it out. This error will exist as long as v1.31 is the latest version.

[WNxWakko]

ONly problem for me is that I have an xbox mod to display them in profiles and such, however I dont use a custom field. I actually cloned the msn, icq etc. so my field is called xbox and your script doesnt acknoledge that?? How can I make this pull from my xbox titled field?

[Gryphon]

Hmm, that will require the query to be completely different. Is it a public mod available here? I can look into making it compatible.

[WNxWakko]

Here ya go, I went ahead and released my plugin.

https://vborg.vbsupport.ru/showthread.php?t=141145

[Gryphon]

Alright I will take a look and see what I can do.

[Techno05]

I'm pretty sure my errors the same the other 2 guys but just in case:

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
vb_user.*,
vb_userfield.field5,
IF(usergroup.genericoptions & 32, 0, 1) AS isnotbannedgroup
FROM
`vb_userfield`
INNER JOIN
vb_usergroup AS usergroup ON(usergroup.usergroupid = vb_user.usergroupid)
LEFT JOIN
`vb_user` ON vb_userfield.userid = vb_user.userid
WHERE
vb_user.posts >= '0'
AND
vb_userfield.field5 != ''
ORDER BY
RAND();

MySQL Error : Unknown column 'vb_user.usergroupid' in 'on clause'
Error Number : 1054
Date : Monday, March 5th 2007 @ 02:58:43 AM
Script : http://www.premiumbattles.com/forums//admincp/cronadmin.php?do=runcron&cronid=18
Referrer : http://www.premiumbattles.com/forums//admincp/cronadmin.php?do=modify
IP Address : 83.100.162.12
Username : Matt
Classname : vB_Database

[Spinball]

Hello,
nice hack. We have used one of our userfields for the XBL gamertag for some time and have 2,300 members with a gamertag entered.
I have reduced the frequency of the scheduled task to every hour but still only have the details of 275 members in the gxboxlive table.
I have just changed it to update once a day.
Do you have an idea of how long it takes to retrieve the data for 2,300 members?
Will it cause excess load on the server?
http://www.avforums.com/forums/gxboxlive.php

[edit : having looked through the scheduled task log, there are no entries for the gxboxlive task]

[PabloAM]

Neoka21, sorry this product is for vBulletin 3.6, there are plugin changes that aren't available in 3.5. However, I can look into making it 3.5 compatible.



Sorry, I got sidetracked on about 4 other modifications I'm working on. I will look into correcting this database error soon. v1.21 should work in the meantime until I can release v1.32.

Thanks Jack ;)

[Gryphon]

Do you have an idea of how long it takes to retrieve the data for 2,300 members?

Spinball, I'm afraid that vBulletin's cron may not be powerful enough to handle large gamertag processes. I will have to work on splitting up the processes into smaller chunks in order to make this more efficient, until then, there may be no fix other than to run the tak manually occasionally. I've been monitoring some boards with thousands of users and they appear to work ok, though server setup can play a large roll in how well they will do.

Improving this is on top of my list of things to do.

[Canis Firebrand]

Nice :)

Uploaded the xboxlive.php, miner.gxboxlive.php files from the 1.32 zip file. Imported product with Overwrite enabled.

Manually ran the cron job. No errors and everything works beautifully now. Thanks for a fast update and fix for the issue. It was odd that some people had it and others didn't.

Awesome job with this product.

[Gryphon]

Thanks. I most likely didn't follow coding standards in creating my mySQL statement and people with less strict settings/older software/different permissions on their servers let it slip by while others error. I will have to learn what it is I did wrong in order to eliminate banned users from the listing.

[Spinball]

Spinball, I'm afraid that vBulletin's cron may not be powerful enough to handle large gamertag processes. I will have to work on splitting up the processes into smaller chunks in order to make this more efficient, until then, there may be no fix other than to run the tak manually occasionally. I've been monitoring some boards with thousands of users and they appear to work ok, though server setup can play a large roll in how well they will do.

Improving this is on top of my list of things to do.Thanks for the reply.

[Inferno Dragon]

brilliant addon I will use it in the future :) keep up the good work Blackjack!

*Voted for MOTM" :)

[Sjakie]

Do you know how to show the players "leaderboard rank" in postbit?

[Gryphon]

The rank is created when the page is created, it is not stored anywhere in the database to be able to put it on the postbit. I can look into trying to add this functionality.

[Sjakie]

Great!

[Skedoozy]

It is not currently possible. I am not sure how easy that would be, I can look into it.

Great hack. Works perfectly.

I too would be interested in adding it to the main page, more so I'd love to be add it as a module for VBa CMPS.

[syrus.xl]

Strange, I'm getting an error on one site I installed this modification on. The game images refuse to show on the page, but appear fine in the popups.

Here's the url: http://xboxlivegaming247.com/gxboxlive.php

Any ideas why?

Edit: NVM. Fixed it :)

[fernas]

Great hack. Works perfectly.

I too would be interested in adding it to the main page, more so I'd love to be add it as a module for VBa CMPS.
+1. That will be great :).

[AzzidReign]

I don't know if this has been suggested or not but one of my members just complained about this....since I have a large site, we have around 190 pages listed for this mod and my members would like to be able to use a search feature to find out where they are ranked. Any way we can get this in the near future?

[ninjashadow80]

I am quite new to this sort of thing

When you say upload it upload it where and how?

And when you say install it install it how

What menus in hte admin panel should i be using

Thanks

[ninjashadow80]

Good news is i got it work bad news is i cant get a link to show up for it up top right below my banner. How do i get the link to show up?

[breamy1990]

how do i make this use fopen instead of fsocket ?

[Gryphon]

The mod is currently using vBulletin RSS Feed functions for fetching the GamerTags which does not support fopen.

[breamy1990]

i get this error


Warning: Unable to fetch URL:http://gamercard.xbox.com/TCG+Breamy.card in /includes/cron/miner.gxboxlive.php on line 95
Updated Accounts: 0. Deleted Entries: 0. Process Time: 1s. Total Queries: 8.

is there anyway to make it use anything other than fsockopen(), as my host as disabled this because of a security reason :confused:

[Gryphon]

Not currently, I may look into it, however I am not sure what security issues there could be.

[breamy1990]

ive asked the guys here whether theres anyway to switch over to fopen for rss maybe that will help :confused:

[Kinneas]

Another great mod! You're on a roll, BlackJack :D

*installs*

[soccerlance3]

..how do you install this? Sorry still a noob. ;) Everywhere I try to install has a folder already created with the same name as one the folders I just uploaded. What do I do? Thanks in advance!

[powerbook]

The ' in Texas Hold'em is giving errors on my site.

Invalid SQL:
REPLACE INTO 120_gxboxlive SET
userid = '982',
gamertag = 'whatever',
avatar = 'http://tiles.xbox.com/blabla.jpg" alt="Texas Hold'em',


MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'em',

Any ideas how to fix this?

Ps) I have the latest version of this hack installed on 3.6.4

[vhero]

[QUOTE]REPLACE INTO gxboxlive SET
userid = '1',
gamertag = 'Vherostar',
avatar = '

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'em',
score = '6241',
reputation = '20',
zone = 'Recreation',
las' at line 4
Error Number : 1064
Date : Wednesday, March 28th 2007 @ 09:55:12 AM

please help me i cannot figure out the prob...

[Sjakie]

My forum is giving the same database errors???

[Gryphon]

I look into having a fix up for this today.

vhero, can you please clean up your post? It is the same error as the post above yours, I don't need all that info.

[TheJackal56]

ok, nice, I d have it installed but not working nd I suspect the following:
# Fill in the gXboxLive configuration options, make sure to enter the field id for the newly created Xbox profile field above.

* /admincp/?loc=options.php%3Fdo%3Doptions%26dogroup%3Dgxbl_g roup

I am missing it, where does the filed# exactly go on the config page?

I have the field# but cannot for the life of me figure out where to put it???

Thx

[Gryphon]

User Profile Field, the very last option.

[vhero]

ok done blackjack any idea how to fix?? I googled the error and it says its a mysql version problem?

[Gryphon]

Get version gXboxLive v1.33 I uploaded earlier today.

[duckdodger]

Hi, I uploaded miner.gxboxlive.php and imported the product with Overwrite enabled, but now when I go to the list it just takes me to a blank page.

[doberlec]

Yep, the new update also messed up my ladder... zones & scores don't fit anymore:

-> http://forum.deepsilver.com/forum/gxboxlive.php

Procedure was as instructed. Replace the cron job file and overwrite the old with the new product file.

[Gryphon]

v1.34 has been posted to fix this.

[duckdodger]

I updated to 1.34 but it still just takes me to a blank page when I visit the leader board.

[Gryphon]

What do you mean by blank? White?

[duckdodger]

Yeah, just a white page.

http://www.ikproductions.net/gxboxlive.php

[Gryphon]

Does your server pring an error_log to your web directory? I don't understand why it would be that way for you.

[duckdodger]

Hmm, I don't see anything like that. I may have to contact the server owner.The last version I used was 1.20 and it worked fine.

[Gryphon]

Make sure you upload all files if you are updating from that version.

[duckdodger]

Yep, that fixed it. Thanks!

[Extirpate]

I keep getting an sql error when i try to go to gxboxlive.php

Database error in vBulletin 3.6.5:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_gllc AS phrasegroup_gllc,
language.phrasegroup_gxbl AS phrasegroup_gxbl,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep

FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))

WHERE user.userid = 1;

MySQL Error : Unknown column 'language.phrasegroup_gllc' in 'field list'
Error Number : 1054
Date : Wednesday, March 28th 2007 @ 08:02:14 PM
Script : http://klicart.com/vt/gxboxlive.php
Referrer : http://klicart.com/vt/index.php
IP Address : 24.168.71.51
Username :
Classname : vb_database

[Gryphon]

Not sure what caused that. Appears the product didn't install fully or something. That query is generated by vBulletin, it is erroring before my script is run. Looks like the product didn't install the phrases, try re-installing the product.

[Extirpate]

i tried like 3 times :(

[XtremeCrash]

Great Mod,Works fine...Thanks

[Gryphon]

i tried like 3 times :(

Try downloading the file again and re-upload the gxboxlive.php file.

[doberlec]

Update 1.34 fixed the wrong ladder listing, thanks a bunch for the quick patch :)

[gray]

Is there a resolution to the game thumbnails not showing? I take it the offical xbox site has moved them?

[gray]

Sorry, ignore the above post (it's because I'm behind a web filter).

[vhero]

thanks blackjack you rock!

[halcyoncmdr]

Awesome hack. Is there a possibility to have it show online status as well? Also, could you make a setting in the options to change the name of the link in the navbar? :)

Those are the only things bugging me :)

[Gryphon]

You can change the name of the link in the navbar with phrases, search for gxboxlive_vbnav.

Online status is a little tougher because you have to get the script to authenticate with Xbox.com and login to access that information. Currently that is a little more work than I am looking to put in. However, it is something I would like to accomplish sometime.

[halcyoncmdr]

Ok, thanks so much Blackjack. This is an awesome hack. I'd love to see the online status appear in it at some point in time. :)

Keep up the great work!!

[GnG_ShoOk]

where do i upload the files?

and where do i create that text line?

thanks

[Ronin Storm]

Looks like this class of error has been reported before. Just like to indicate that it's still turning up:

(some data cleaned up as it doesn't seem relevant... can provide entire error via PM on request)

Database error in vBulletin 3.6.5:

Invalid SQL:
REPLACE INTO gxboxlive SET
userid = '77',
gamertag = '[...SNIP...]',
avatar = 'http://tiles.xbox.com/tiles/fr/8+/1mdsb2JhbC9FCgUABh4AGANYL3RpbGUvMC8yODAwMQAAAAAAAA D5Eb9e.jpg" alt="Street Fighter II' HF',
score = '5653',
reputation = '20',
zone = 'Recreation',
[...SNIP...]

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HF',
score = '5653',
reputation = '20',
zone = 'Recreation',
las' at line 4
Error Number : 1064
[...SNIP...]
Classname : vb_database

I suspect the issue is in the avatar line, and to do with the apostrophe after "Street Fighter II", exactly as the apostrophe after "Texas Hold" (i.e. "Street Fighter II' HF" and "Texas Hold'Em").

I'm using gXboxLive v1.34 on vB3.6.5.

Let me know if I can provide any more information.

[GnG_ShoOk]

i get everything isntalled and working, i have it under my quick links , but when i put in my gt and my friends they dnt come up it s just the columns?

[vhero]

blackjack you ever thought in future releases to make bigger thumnails as an option? I would like to see them.

[EricaJoy]

It is not currently possible. I am not sure how easy that would be, I can look into it. Any progress on this? I'd love to put a top 10 leaderboard at the top of my gaming forum.

[Ronin Storm]

I've made a one line change to miner.gxboxlive.php to resolve the error I get with avatars that have a single quote in their name. This appears to resolve the issue for me but I can't guarantee that it doesn't cause other problems.

In miner.gxboxlive.php, on line 106, change:

$player['avatar'] = $matches[0][2];

...to:

$player['avatar'] = addslashes($matches[0][2]);

Again, no guarantees. Just hoping the contribution helps.

[ringoflight]

You can change the name of the link in the navbar with phrases, search for gxboxlive_vbnav.

Online status is a little tougher because you have to get the script to authenticate with Xbox.com and login to access that information. Currently that is a little more work than I am looking to put in. However, it is something I would like to accomplish sometime.

Hmmm, I may be able to help you actually. I am going to be paying a coder for some extensive work on my forums, with a big part being the xbox live leaderboard. On my list is the following:

The ability to view the users current Xbox Live status
The ability to show the rank of the user in the postbit
The ability to show the last 5 games played in the postbit
If the user specifies his login details for xbox.com, a script will run in the background which will log that user in to xbox.com, and allow the user to send messages and view the users friends list, within your forums template, but running through xbox.com completely. (The coder says this is possible, but I have no intention to take the matter further if he cannot do it).

This could take a few weeks, and at the end result, I will send you the final code, or release the hack seperately if needed!

If anyone else has any other ideas, please tell me!

[Gryphon]

I suspect the issue is in the avatar line, and to do with the apostrophe after "Street Fighter II", exactly as the apostrophe after "Texas Hold" (i.e. "Street Fighter II' HF" and "Texas Hold'Em").

The miner should not be picking up the alt tag at all, only the url. Please look at the top of miner.gxboxlive.php and ensure that you are using Rev: 540. If you are, I will try and find out why this is happening, but it should not be.

i get everything isntalled and working, i have it under my quick links , but when i put in my gt and my friends they dnt come up it s just the columns?

Did you wait for the cron to run? Did you enter the proper field id?

blackjack you ever thought in future releases to make bigger thumnails as an option? I would like to see them.

You can edit the size of the icons to your liking in the template.

Any progress on this? I'd love to put a top 10 leaderboard at the top of my gaming forum.

I have not yet looked into doing this.

Hmmm, I may be able to help you actually. I am going to be paying a coder for some extensive work on my forums, with a big part being the xbox live leaderboard.

On your first point; There are classes available that login to xbox.com and obtain some of that information I have been toying with, however the connection is not entirely reliable. I would always be willing to look at any code improvements anyone may have. Your 4th point would be quite nice and I would look into working on the same thing, however I would not be comfortable managing other users credentials, that is pretty sensitive information to be handling. Your second and third points I can certainly implement into gXboxLive.

If you do release something, all I ask is that it does not include my code or modifications to my code. It would be great if it worked in conjunction with it or standalone. Thanks.

[Spinball]

Hmmm, I may be able to help you actually. I am going to be paying a coder for some extensive work on my forums, with a big part being the xbox live leaderboard. On my list is the following:

The ability to view the users current Xbox Live status
The ability to show the rank of the user in the postbit
The ability to show the last 5 games played in the postbit
If the user specifies his login details for xbox.com, a script will run in the background which will log that user in to xbox.com, and allow the user to send messages and view the users friends list, within your forums template, but running through xbox.com completely. (The coder says this is possible, but I have no intention to take the matter further if he cannot do it).

This could take a few weeks, and at the end result, I will send you the final code, or release the hack seperately if needed!

If anyone else has any other ideas, please tell me!

WRT the postbit element, do you mean something like this?
http://www.avforums.com/forums/showthread.php?t=424987

[Gryphon]

No, s/he wants extended information not available in the gamer cards which is currently where gXboxLive gets it's information from.

There is more information available, like offline/online status, if you login to xbox.com with your credentials that this mod cannot currently do.

*Edit: After re-reading the your post, I see you are directing the comment about the postbit display.

[JD45]

/me installs and nominates!

[Ronin Storm]

The miner should not be picking up the alt tag at all, only the url. Please look at the top of miner.gxboxlive.php and ensure that you are using Rev: 540. If you are, I will try and find out why this is happening, but it should not be.

Sorry it's taken me a while to get back.

$Id: miner.gxboxlive.php 540 2007-03-28 21:09:43Z gryphon $

Looks like rev 540 to me. Was certainly getting errors. Now I'm not. Pretty comfortable with the alt tags appearing, actually, now they're not causing issues with the SQL.

[jkwasn01]

I am receiving the same error as Ronin.. I am also using the miner 540

Database error in vBulletin 3.6.4:

Invalid SQL:
REPLACE INTO gxboxlive SET
userid = '65',
gamertag = 'hidden',
avatar = 'http://tiles.xbox.com/tiles/Ml/29/0Wdsb2JhbC9BCgUABh4AGANYL3RpbGUvMC8yODAwNQAAAAAAAA D+kl0S.jpg" alt="Street Fighter II' HF" title="Street Fighter II' HF',
score = '31722',
reputation = '20',
zone = 'Recreation',
lastplayed = 'a:5:{i:0;a:3:{s:5:\"title\";s:7:\"MLB 2K7\";s:4:\"link\";s:116:\"http://live.xbox.com/en-US/profile/Achievements/ViewAchievementDetails.aspx?tid=%09%5d%3bdh-o0%01t&compareTo=MIK\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/4P/Ce/12dsb2JgbA9ECgUMGgQfWSkiL2ljb24vMC84MDAwIAABAAAAAP ix8P8=.jpg\";}i:1;a:3:{s:5:\"title\";s:7:\"Luxor 2\";s:4:\"link\";s:116:\"http://live.xbox.com/en-US/profile/Achievements/ViewAchievementDetails.aspx?tid=%09%5d%3bhe)j3u%03 &compareTo=MIK\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/r8/tv/1Wdsb2JgbA9ECgUAGwEfVl8nL2ljb24vMC84MDAwIAABAAAAAP pAy7A=.jpg\";}i:2;a:3:{s:5:\"title\";s:4:\"TMNT\";s:4:\"link\";s:123:\"http://live.xbox.com/en-US/profile/Achievements/ViewAchievementDetails.aspx?tid=%09%5d%3bei*h1e4X6 z-17%0a&compareTo=MIK\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/0S/RW/0mdsb2JgbA9ECgUNGgMfWSlbL2ljb24vMC84MDAwIAABAAAAAP 15JM4=.jpg\";}i:3;a:3:{s:5:\"title\";s:6:\"GRAW 2\";s:4:\"link\";s:123:\"http://live.xbox.com/en-US/profile/Achievements/ViewAchievementDetails.aspx?tid=%09%5d%3bei*h1e4X6 z-17%02&compareTo=MIK\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/-h/jO/0Gdsb2JgbA9ECgUNGgMfWSlTL2ljb24vMC84MDAwIAABAAAAAP-hGOE=.jpg\";}i:4;a:3:{s:5:\"title\";s:12:\"Gears of War\";s:4:\"link\";s:120:\"http://live.xbox.com/en-US/profile/Achievements/ViewAchievementDetails.aspx?tid=%09%5d%3a%15%18*iA s%05&compareTo=MIK\";s:5:\"image\";s:94:\"http://tiles.xbox.com/tiles/bU/l4/1Gdsb2JgbA9ECgR8GgMfWStWL2ljb24vMC84MDAwIAABAAAAAP tXSXI=.jpg\";}}',
updated = '1176072257';

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'HF" title="Street Fighter II' HF',
score = '31722',
reputation = '20',
' at line 4
Error Number : 1064

[jonty]

Is there (or will there be) an easy way to exclude banned users, or members of specific groups?

[Gryphon]

I am receiving the same error as Ronin..

Hmm, I am not sure why this is still coming up. Make sure you have the latest files. I will look into this again.

Is there (or will there be) an easy way to exclude banned users, or members of specific groups?

I started the code for this, but there are still some bugs I have to work out.

[famousthomas]

Is there a lag with populating the 'gxboxlive.php'? I added two users with gamertags and nothing's come up yet.

[Gryphon]

Yes, it updates every 10 minutes.

[famousthomas]

There it goes!

Awesome mod, man.

[djwins]

has anyone tried this on 3.5?

[Sjakie]

Can you give me the code for adding and sending messages to friends (as seen in attached picture) beacause I cant seem to find it anywere. I would like to implement this code into my postbit template.

http://www.xboxforum.nl/uploads/send.jpg

[Gryphon]

It is in the gxbl_bit template, replace $player[url_gamertag] with your field id.

[jimmcq]

Installed and working great!

http://pinataisland.info/forum/gxboxlive.php

[Semjaza]

I'm sorry if this has been answered. I've not had much luck finding it.

I installed this a few weeks back and love it. It was working great and it was nice to have, even if there were only 5 people on the list.

However, I checked it out again today and now it only shows one person. The other four are missing... I checked every one's profiles and nothing has been changed. Any idea what happened...?

[Gryphon]

Xbox.com is having some issues displaying their gamer cards currently. You will have to wait out their problems.

[Semjaza]

Xbox.com is having some issues displaying their gamer cards currently. You will have to wait out their problems.

OK, sounds good. Thanks for replying so quickly. I was thinking it might be that once I noticed a lot of the images weren't working either.

[Oblivion Knight]

This is truely awesome! :)

[auctionguy]

You mean with this mod, a 360 live member can log in to his account and play 360 live games in a forum?? What do you need for that?

[Vizionz]

he isnt a rocket scientist dude. theres no way possible to do that. all its doing is grabbing the stats from xbox and dispalying them in a forum. if you could play xbox360 games from a forum it would put microsoft out of business.

1. you need a xbox 360
2. you need a xbox360 live account
3. you get your stats from xbox thats all its doing. instead of going to xbox.com and logging in to see your stats you get them directly on your forum so you can just check youjr stats and your members with xbox stats.

[auctionguy]

Yah, I guess I knew that but I thought that I would ask the stupid question!! Just looking for some other types of gaming that I can integrate in my gaming forum!! Thanks though!

[Vizionz]

go buy inferno demo = gzevolutions.net purchase = http://infernotechnologies.net/

[Vizionz]

and i would ad this mod for your site. itwould be a great addition for your site since your a gaming site it would be cool to have your xbox users stats. but inferno is a rpg game if you dont know that.. you set up for your members to play you create everything

[nexus xb3c]

Excellent product thankyou for all your hard work on it

[xXSesshomaruXx]

Doesn't let me add the user. Everything works fine but when I put the name in, nothing shows on the rank page.

[Gryphon]

Did you wait for the cron to run?

[Gil427]

Everything installed fine. When I click on gXboxLive, no one shows up on the list. Does it take some time to install or something?

Link: http://www.vgtrades.com/forums/gxboxlive.php

[Gryphon]

I see profiles on your board. It only gathers the profiles every ten minutes, you needed to wait for the cron to run.

[Gil427]

Yeah, I just realized that. Thanks :)

Also, do you know why the send message and add to friends list buttons aren't showing up?

[Gryphon]

You need to upload the included images to your styles misc folder.

[tandalier]

any news for 3.5??

currently my server can't use 3.6 and don't want to wait so long before implementing this really cool feature.

My hope is you can help me....

[Gryphon]

Try installing this product (https://vborg.vbsupport.ru/showthread.php?t=134603), it may allow you to install gXboxLive ok on 3.5.

If you don't want to install that hack, you can try editing the gXboxLive product xml and remove execusionorder="5" in 5 places.

[XtremeCrash]

Love the mod.Ive seen on anther site where it shows if the person online or offline.: Something like the mod you make.

http://www.xboxusersgroup.com/forums/vbgamerboard.php

Any way you can make it something like that?

[Gryphon]

I have lightly started work on getting online status. I am not sure how soon it will arrive however.

[molook]

I tried to add the gxboxlive hack but it didn't show up to me in my forum main page..

need assistance (www.egames.ae/vb)

The only field worked with me is the one in the profile user CP.

Need assistance please!!

[molook]

am trying to use the gxboxlive in my forum www.egames.ae/vb but it doesnt work when i add my gamertag
it give me this msg

There are no subscribed threads to display in this folder for this time period

need assistance!

[Gryphon]

Looks like you got it working.

[ssk_forum_site]

Hey does it take a while for the gamertags to load cuz I have done everything and put in the tags and they dont show up

[Gryphon]

Yes, the cron runs every 10 minutes as mentioned previously.

[ssk_forum_site]

its been a couple hours now and its not workin? any ideas

[Gryphon]

Only two ideas, it is not installed properly or your server cannot resolve the xbox.com domain. I would imagine it would be the first, double check all settings and instructions. I can't make any guesses on what steps may have been missed without a lot more information because it is your server and you did the install.

[Inferno Dragon]

Just installed it yesterday, working fine :) great mod!

[Snookieboy]

Hi, I’ve installed this great mod and got it working fine.

I’m wondering if its possible to change where it says "gXboxLive" on the top menu to just Say "Xbox Live"

If I’m allowed to do this how would I do it?

[Gryphon]

Yes you can change this, you can find it if you search the phrases for gxboxlive.

[InsaneNutter]

Yes you can change this, you can find it if you search the phrases for gxboxlive.

What exactley do i want to search in? ive had a look in the gxboxlive.php file, the skin templates and the gxboxlive templates, if i change anything that says gxboxlive i just break the mod.

[Tiger24]

when i click the add button it dosent add users why??

[theorigin]

First of all, let me say..great hack. This is exactly what I've been looking for, for quite some time. With that said, would it be possible to add an online status to this?

[MotMann]

I will displayed the statistik with the 5 bests Users in the Forumhome, maybe in the Userinfo Bar.

What i must do?

[Gryphon]

What exactley do i want to search in? ive had a look in the gxboxlive.php file, the skin templates and the gxboxlive templates, if i change anything that says gxboxlive i just break the mod.

Go to your vBulletin options and click on the Search in Phrases section in the left column.

when i click the add button it dosent add users why??

Add users to your friends list button? Do you have your passport account setup for your Xbox.com login and your Gamertag associated with it? You need to login to Xbox.com to add friends.

First of all, let me say..great hack. This is exactly what I've been looking for, for quite some time. With that said, would it be possible to add an online status to this?
Possible yes, but it will require some available time for me to code this. It is not a simple matter.

I will displayed the statistik with the 5 bests Users in the Forumhome, maybe in the Userinfo Bar.

What i must do?

It is not possible at the moment, the statistics are only created when viewing the leaderboard.

[dmiller68]

Thanks, I installed this today. It seems to work great. I need to add it to our menu yet.

[Biby]

is it possibile to search for a gamertag/user and view his position on leaderboard?

[Gryphon]

is it possibile to search for a gamertag/user and view his position on leaderboard?

Not currently. The ranks just count row numbers currently, they aren't associated with players, which is why the ranks column hides if you sort by any other method. A search feature may be possible after I add ranks to the profile.

[chubzilla]

this is a great mod, but the avatars are overlapping the gamertags

http://www.postgamepub.com/gxboxlive.php

[Gryphon]

this is a great mod, but the avatars are overlapping the gamertags

http://www.postgamepub.com/gxboxlive.php

I answered you by PM before seeing that you posted here also. Please, it is not that dire of a problem that required you to ask your question in multiple places.

As answered by PM, and for the benefit of others; this is a problem with the current layout I have yet to fix. A possible fix would be by creating a new column for the avatars.

[chubzilla]

well i figured i would see if anyone else had a fix for this. not in dire needs..im a perfectionist

like i said great mod, mu board loves it

[Didikoy]

Excellent MOD , keep up the good work :)
This MOD was one of the reasons why I purchased vbulletin :D

[Hicksatpd]

I just installed this. Nicely done. :)

[Parm]

This looks a fantastic mod, thanks for all the hard work Blackjack!

I'm about to try installing it on my forum. I'm a new vBulletin user and this will be my second attempt at installing a mod (the first one didn't work but hopefully this one provides more luck hehe).

One quick question; I was actually looking for a way to allow users to put their Gamercard in place of their avatars, will this mod do anything along those lines too? I love the leaderboard idea and will be installing it, but I would like to put gamercards by peoples names viewable when reading threads. Any ideas? :)

*update* installed, it works! *thumbs up*

[ggiersdorf]

I love this mod, but WHY do only like 9 users showup? I have it set to allow all users to showup its not a field issue mine does not even show up but others do!

[Gryphon]

It will only show users who have entered a gamer tag, it will not show all users. Where is your installation, and what is your gamertag?

[gobbly2100]

Oh yes, I am now using it and it is damn sweet!

http://www.huxleygame.com/forum/gxboxlive.php

I love it :D

[InsaneNutter]

Go to your vBulletin options and click on the Search in Phrases section in the left column.

Ok I did that then clicked edit on a few of the results but there's nothing to edit.
Here is a screenshot of what I found, am I doing it right?

Thanks

[Gryphon]

Put what you want it to be called in the bottom box and press save.

You should be editing the two in the Global phrases section. The top three are for the admin panel phrases.

[InsaneNutter]

Thanks, thats easy once you know how :D:up:

[EnterXment]

I installed this, and put the custom profile feild up, and its #8, I put field8 in that choice for the gXboxlive options... and had my user put his gamertag in his pro, but no one comes up.

Any ideas?

[iceytdot]

this modification looks really good, when i have my site up and some gamers on there it will be nice to see in action.

[Gryphon]

I installed this, and put the custom profile feild up, and its #8, I put field8 in that choice for the gXboxlive options... and had my user put his gamertag in his pro, but no one comes up.

Any ideas?

I assume you gave some time for the cron to run?


*Please click install if you use this mod :)

[theorigin]

Mine hasn't updated in several days. I've tried to do it manually, but every time I do, it comes up with an error saying that it can't fetch the gamercard data from gamercard.xbox.com. I've even tried uninstalling and reinstalling, but it hasn't done any good. Any idea what I should try next?

[Gryphon]

What is the exact error? It is also possible that your server can not resolve the xbox.com domain as well.

[theorigin]

If it needs to be resolved, how would I go about doing that? It's weird because it worked just fine up until about 2 days ago.


Warning: fsockopen() [function.fsockopen]: unable to connect to gamercard.xbox.com:80 in /includes/class_rss_poster.php on line 95

Warning: Unable to fetch URL:http://gamercard.xbox.com/#######.card in /includes/cron/miner.gxboxlive.php on line 95

[AsilentFart02]

Actually two things I want to ask you.

1. I have done the instructions perfectly to install the Xbox Live Leaderboard and yet it is still not working, why?

2. Is there any possible way to rename it in the navi bar and quick navibar?

[Athena PMS]

First of all great mod. We are a very large professional gaming clan with a large Xbox userbase. Currently we have 831 gamertags in this list of the mod. http://www.pmsclan.com/forums/gxboxlive.php

A few feature requests if possible:
1) Is there a way to limit which usergroups it pulls this profile field from. We have way to many people in this list and we would rather just pull from our clan member usergroups

2) Is there a way to hide the reputation column? Everyone has 20 and there is no need to display it

3) Is there a way to add a icon for message the user and add the member instead of text. When you have those options turned on it is rather large column.

Thanks a lot for your help!

[Gryphon]

theorigin, I can't be sure what is causing that. It appears that your server is not resolving the domain name, that is beyond the scope of this addon, I don't really know where to start telling you how to fix that.

AsiletFart02, 1) I need more info, I don't know what isn't working for you. 2) That is managed by phrases, it was documented on page 4 of this thread.

Athena PMS, 1) Not currently, but I could implement that. It currently pulls all users, even banned users. I ran into some trouble coding that portion, it is on my todo and I will add limiting usergroups. 2) I could make an option, there is none currently. You can edit the template to remove the column until then. 3) There should be icons for them and reputation which is broken, you are probably using Firefox (which lamely hides broken images, I hate that, grrrr), but you should upload the images to your styles misc folder.

[Athena PMS]

Oh yes I had the images in the wrong folder (we designed a custom skin). Now it is better thanks for the help :).

Looking forward to the new usergroups feature.

Thanks a lot!

[teamsupra]

Awsome mod, I am running it ALMOST perfectly:) if you look at http://www.halotalk.com/forums/gxboxlive.php you will notice on the leaderboard stats that the Top Games field is empty.. Can someone help?

[Gryphon]

teamsupra, I am afraid I am not quite sure what could be causing that :/

*edit: After freshing the page, they showed up. Seems ok now.

[LewisAinslie]

the admin link is not there to change settings and it says it cannot connect to database on the gxboxlive.php file

[Gryphon]

Doesn't sound like it installed properly. I can't suggest anything other than double check the installation.

[Parm]

Another quick question for you Blackjack, I have the link displayed in my navbar, but I've also got my forums setup to have a second row in the navbar. How do I move the Leaderboard link from one row to another?

[Gryphon]

Hmm, you will have to turn off auto add link and insert a link manually in your second bars template.

[Parm]

I should have thought of that, hehehe! Thanks :)

[ChrisSy]

How can you delete or remove entries from the leaderboard?

[Gryphon]

Currently, anyone who has a gamertag entered in their profile will be listed. I need to work on improving that feature. If their gamertag is removed from their profile, it will be deleted from the leaderboard on the next update.

[yashua]

Why aint anything showing up? http://www.ultimatehalo.com/gxboxlive.php

[Gryphon]

You haven't really given me much to go on to help you troubleshoot it.

You haven't waited for the cron to run, you have not entered any gamertags into a profile, you haven't setup the fieldid option in the config, your server can't resolve the xbox.com domain.

Anything beyond that, you will have to provide much more information.

[yashua]

You haven't really given me much to go on to help you troubleshoot it.

You haven't waited for the cron to run, you have not entered any gamertags into a profile, you haven't setup the fieldid option in the config, your server can't resolve the xbox.com domain.

Anything beyond that, you will have to provide much more information.here is the page http://www.ultimatehalo.com/gxboxlive.php I did everything that TUT you made told me to do I set up the field and everything its been up for a hole day now still not working all my users entered there info in the profile and it still aint working =(

[LewisAinslie]

considering you have called the field "Xbox Live name" then it may not work and in the options for the script what field did you put in

[yashua]

considering you have called the field "Xbox Live name" then it may not work and in the options for the script what field did you put in

I put field6 and than what should I call the Field? and I named the Field Xbox Live GamerTag you are looking at the wrong one lol

[Gryphon]

You can name the field whatever you like. All I can figure is happening is that your server can not resolve the xbox.com domain. Try pining xbox.com.

[GamerJunk.net]

MySQL Error : Unknown column 'vb3_userfield.field15' in 'field list'
Error Number : 1054

That is the error I get when I run the cron

[Gryphon]

You used the field # specific to your boards? field15 is just an example, the actual number is often unique to different users.

[glorify]

Haven't checked thru all of them, but installed, then each day for about 4 days got db errors--lots of them--uninstalled, no errors. 3.6.7 PL1.

I love this hack, I just can't use it with the errors :(

[RollaJedi]

ok, I am trying very hard to find out how you change the name 'gxboxlive' on the navbar to just 'leaderboard'. I saw the post about searching phrases but I dont really know how to do this. I'm sorta a newbie to all this. Could someone please help me? Thanks!

[Gryphon]

ok, I am trying very hard to find out how you change the name 'gxboxlive' on the navbar to just 'leaderboard'. I saw the post about searching phrases but I dont really know how to do this. I'm sorta a newbie to all this. Could someone please help me? Thanks!

See this thread (https://vborg.vbsupport.ru/showthread.php?p=1262577) and the one following it.

[RollaJedi]

thank you for taking the time to respond. Very much appreciated!

[KipLarson]

Installed.

And it's working great!

I have one question though:

Would there be a way to set only Xbox Live Arcade game points to count on the leaderboard? I run XboxLiveArcade.com (http://www.xboxlivearcade.com) and could see this being a blast for our members to compare and contrast each others top scores based entirely on XBLA games.

Is that possible?

Thanks, I love your mods they're great!

[Gryphon]

I'm afraid it would take quite a bit of work at the moment. All current information is based solely on what is available in the public gamercard. Anything more requires authenticating with xbox.com which I have only slightly tested.

That is a nice idea, however, I will keep it in mind for when I can find the time to expand on gXboxLive.

[LewisAinslie]

They seem to be messed up at the moment. Please check some links. This may be due to the xbox live maintinence as My Gamercard.net was having truble also.

[Cynthdivide]

Seems gamertags take forever to be posted on the list...

[Gryphon]

The update runs every 10 minutes.

[DoB Rhapsody]

I installed this mod and i'm seeing the leaderboard but no one is listed. It's been about half a day now.. I'm running the latest version of VB, any idea?

Edit: how do i manually run cron?

[Gryphon]

Go to Scheduled Task Manager in your vBulletin options and click the Run Now on the gXboxLive Update cron.

It is possible that your server cannot resolve the xbox.com domain.

[DoB Rhapsody]

I get this error:

Database error in vBulletin 3.6.7:

Invalid SQL:
SELECT VB_user.userid, VB_user.lastvisit, VB_user.posts, VB_userfield.field6 FROM `VB_userfield` LEFT JOIN `VB_user` ON VB_userfield.userid = VB_user.userid WHERE VB_user.posts >= '0' AND VB_userfield.field6 != '';

MySQL Error : Unknown column 'VB_userfield.field6' in 'field list'
Error Number : 1054
Date : Friday, July 27th 2007 @ 03:57:34 PM
Script : http://lockoutgaming.net/admincp/cronadmin.php?do=runcron&cronid=18
Referrer : http://lockoutgaming.net/admincp/cronadmin.php?do=modify
IP Address : -censored-
Username : Rhaps☼dy
Classname : vb_database

[Gryphon]

Double check id for the the profile field you created and entered into the gXboxLive options, it appears that you entered field6 which is incorrect.

[DoB Rhapsody]

oops, i was switching between field6 and field5 because i had two custom fields for gamertags due to another mod. The thing is I waited several hours on both, field6 and field5 and it still didn't work. It was only till i manually ran the task that they appeared. Does this mean that i will have to manually update the leaderboard?

[Gryphon]

It should run ok on it's own, just keep an eye on it. If it doesn't automatically update, I am not quite sure where to start to look for a fix, if it ran manually, it should be ok by cron. I looked at your board, looks like you need to upload the images to your styles misc folder, not the default location.

[DoB Rhapsody]

It should run ok on it's own, just keep an eye on it. If it doesn't automatically update, I am not quite sure where to start to look for a fix, if it ran manually, it should be ok by cron. I looked at your board, looks like you need to upload the images to your styles misc folder, not the default location.

Thanks. I didn't even notice that the rep stars weren't showing up. The cron is running and updating the leaderboard fine now.

Thanks for your help, great mod.

*installed*

[Baku]

I'm having a bit of an issue with the gamer icons and game icons not showing up, along with the send message, add friend icons etc....

My board's gXBL page is http://www.hybrid-gamers.com/forums/gxboxlive.php

Can anyone shed a little light on what I've done wrong? I've just updated from the older version of gXBL.

ANy help would be greatly appreciated. :)

[Gryphon]

Gamer icons and game icons are hosted on xbox.com, if they don't display their site is down. The other icons should be placed in the misc folder for your specific style.

[JGM007]

Hi Gryphon,
I am using a Xbox tag in IM field mod, and instead of making a second field for someone to enter their gamertag in for a second time I would like to just use the value $userinfo[xbox] instead of setting the field number.

I thought $bbuserinfo[$gxbl_user_field] was that value being passed on from the field if it had been created so I tried to replace it with $userinfo[xbox], so I made the changes and re-imported it, but it did not work I also tried setting $bbuserinfo[$gxbl_user_field] = $userinfo[xbox] which did not work.

How could I set it to use that variable instead of relying on a field number?

Thank you!!

[Gryphon]

Unfortunately it is a bit more involved than replacing the variable, the cron job would need the queries re-written for one as well as some other checks in place that expect an id.

Another solution would be to use a query to move every body's IM style entries to a profile field and then remove the IM style mod.

[monstergamer]

My screen is all white, http://www.monstergamer.net/vb/gxboxlive.php
How can i fix this?

[Gryphon]

Hmm, I have not seen that before. I am not sure exactly what would cause that.

*Edit, upon looking at the source your stylesheet has the domain name doubled.

[monstergamer]

Hmm, I have not seen that before. I am not sure exactly what would cause that.

*Edit, upon looking at the source your stylesheet has the domain name doubled.

I have my CSS store as a file
i changes it to NO and it works now..can you fix this cause i like to have my css as a file

Fixed it
For those that use a CSS file sheet

EDIT gxboxlive.php

Remove
$headinclude = str_replace('clientscript', $vbulletin->options['bburl'] . '/clientscript', $headinclude);

[Fallback]

Its not deleting entries when the profile is blank.

For example I added a gamertag. That gamertag was added to the page correctly. The next day I emptied the profile field but the gamertag on that gamertag listing page is not reflecting that I cleared the profile and its still on that page.

[theorigin]

Lately when I try and run the cron, it spins its wheels and then asks me to open the cronadmin.php file. I'm still wondering if it has to do with my server.