Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons

Reply
 
Thread Tools
gXboxLive - Xbox Live Leaderboard Details »»
gXboxLive - Xbox Live Leaderboard
Version: 2.2.6, by Gryphon Gryphon is offline
Developer Last Online: Sep 2023 Show Printable Version Email this Page

Category: Add-On Releases - Version: 3.8.x Rating:
Released: 02-19-2007 Last Update: 04-28-2011 Installs: 848
Supported DB Changes Uses Plugins Template Edits Auto-Templates
Re-useable Code Additional Files  

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]AuthorsOthersGoogle
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.

Download Now

File Type: zip gXboxLive_v2.2.6.zip (118.1 KB, 348 views)

Screenshots

File Type: jpg gxboxlive_front.jpg (141.5 KB, 1 views)
File Type: jpg gxboxlive_options.jpg (89.7 KB, 0 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.
3 благодарности(ей) от:
Fethi.dz, TTayfun

Comments
  #62  
Old 02-28-2007, 05:03 PM
powerbook's Avatar
powerbook powerbook is offline
 
Join Date: Jul 2006
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I dropped the two tables manually and now the issue seems to be fixed... Thanks
Reply With Quote
  #63  
Old 03-03-2007, 06:41 AM
Neoka21 Neoka21 is offline
 
Join Date: Aug 2005
Posts: 7
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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/a...?do=productadd
IP Address : 189.135.237.220
Username : Neoka21
Classname : vb_database
Reply With Quote
  #64  
Old 03-03-2007, 11:20 AM
josh_B josh_B is offline
 
Join Date: Jan 2007
Posts: 31
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #65  
Old 03-03-2007, 06:03 PM
PabloAM PabloAM is offline
 
Join Date: Jan 2006
Posts: 82
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Canis Firebrand View Post
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.

Code:
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

Quote:
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/cr...cron&cronid=25
Referrer : http://www.xboxers360.net/admincp/cr....php?do=modify
IP Address : 81.202.163.34
Username : PabloAM
Classname : vB_Database
One solution?
Reply With Quote
  #66  
Old 03-03-2007, 07:30 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Neoka21 View Post
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.

Quote:
Originally Posted by PabloAM View Post
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.
Reply With Quote
  #67  
Old 03-04-2007, 02:11 PM
ORACLE ORACLE is offline
 
Join Date: Feb 2006
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Hi im getting this error on 3.6.4 does it have to be 3.6.5???
thanks
Quote:
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/f...cron&cronid=25
Referrer : http://www.digital-community.co.uk/f...Dedit%26u%3D22
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database
Reply With Quote
  #68  
Old 03-04-2007, 03:46 PM
ORACLE ORACLE is offline
 
Join Date: Feb 2006
Posts: 12
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

im not using 3.6.5 and i get this i think its the same not checked properly:
Quote:
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/f...cron&cronid=26
Referrer : http://www.digital-community.co.uk/f...incp/index.php
IP Address : 86.2.61.215
Username : ORACLE
Classname : vB_Database
Reply With Quote
  #69  
Old 03-04-2007, 07:42 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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.
Reply With Quote
  #70  
Old 03-04-2007, 07:45 PM
WNxWakko's Avatar
WNxWakko WNxWakko is offline
 
Join Date: Apr 2003
Location: Paradise, Texas
Posts: 309
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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?
Reply With Quote
  #71  
Old 03-04-2007, 07:50 PM
Gryphon's Avatar
Gryphon Gryphon is offline
 
Join Date: Oct 2001
Location: Seattle, WA
Posts: 617
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 11:16 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.08438 seconds
  • Memory Usage 2,364KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (6)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (2)post_thanks_box_bit
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (3)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • fetch_musername
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • post_thanks_function_fetch_thanks_bit_start
  • post_thanks_function_show_thanks_date_start
  • post_thanks_function_show_thanks_date_end
  • post_thanks_function_fetch_thanks_bit_end
  • post_thanks_function_fetch_post_thanks_template_start
  • post_thanks_function_fetch_post_thanks_template_end
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete