vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)
-   -   Add-On Releases - gXboxLive - Xbox Live Leaderboard (https://vborg.vbsupport.ru/showthread.php?t=139958)

Gryphon 01-07-2008 04:17 PM

Yes, the xbox.com provided gamercards are publicly viewable and will stay that way, they are meant to be. The gamercard is where gXboxLive obtains the data so there are usually only two reasons why the leaderboards fail, the gamertags html changed so that pattern matching fails or the site is unreachable/down. Most the time it is the latter and you just have to wait out the site downtime.

I still hope to optimize this better so that the leaderboards aren't affected as much by xbox.com downtime.

Kinneas 01-08-2008 02:42 PM

Hey, great hack, been using it for a while. Recently though I've been bombarded with several emails a day, content of which is similar to below:

Quote:

Database error in vBulletin 3.6.8:

Invalid SQL:
REPLACE INTO gxboxlive_games SET
userid = '21',
title = 'PES2008',
link = 'http://live.xbox.com/en-US/profile/Achievements/ViewAchievementDetails.aspx?tid=%09%5d%3a%13%1f%5d %1fGup&compareTo=Vardoc',
image = 'http://tiles.xbox.com/tiles/7O/LN/12dsb2JgbA9ECgR6G3UfWSpVL2ljb24vMC84MDAwIAABAAAAAP ji4vM=.jpg',
updated = '1199784849';

MySQL Error : MySQL server has gone away
Error Number : 2006
Date : Tuesday, January 8th 2008 @ 09:35:11 AM
Script : http://www.evolution-guild.co.uk/cron.php?&rand=944878
Referrer : http://www.evolution-guild.co.uk/new...?do=recruitwow
IP Address : XXX.XXX.XX.XXX
Username : Unregistered
Classname : vB_Database
I have reinstalled the product which has not helped. Does anyone know why this may be happening?

Gryphon 01-08-2008 04:38 PM

See this regarding "MySQL server has gone away". It appears that you are losing your MySQL connection during the update process. How many gamertags are in your leaderboard?

Kinneas 01-09-2008 04:19 PM

16...which I believe is correct, it's only a small forum.

Would a timeout value be causing this then? Do these queries take longer than usual vb functions to execute?

Gryphon 01-09-2008 04:39 PM

It does take longer as it has to fetch xbox.com once for each gamertag and then make mysql query for each tag it finds. So the cron takes some time to run, the update process could really use some more optimization if I could just find the time to rewrite it.

As far as the error goes, I am afraid it is beyond what knowledge I have of the process.

Kinneas 01-09-2008 04:41 PM

I've recently downgraded to shared hosting so I don't have control over the MySQL settings etc. I'll see if they will increase the timeout value and see if that helps.

Thanks for your assistance.

Gryphon 01-09-2008 05:01 PM

Quote:

Originally Posted by Kinneas (Post 1418461)
I've recently downgraded to shared hosting so I don't have control over the MySQL settings etc. I'll see if they will increase the timeout value and see if that helps.

Thanks for your assistance.

No problem. I have started working on updating the cron which will break up the process a bit.

kindi_boy 01-14-2008 04:54 AM

Hello,

I would like to say this is the best product i've ever seen.
also i need help with a little problem
the pictures that i uploaded are not showing up
i've checked the paths they are right.

am not really sure what's the problem
please help

Gryphon 01-14-2008 05:08 AM

Thank you. Regarding the images, make sure if you are using a custom style, that the images are in the misc folder for that particular style.

kindi_boy 01-14-2008 05:15 AM

worked like a charm! thanks a bunch!

now for something else if i need to translate just the "Send a Message To ????"
and the columns titles just the stuff that appears to people, any idea how to do that?


All times are GMT. The time now is 10:31 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01639 seconds
  • Memory Usage 1,741KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (3)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete