vb.org Archive

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

x626xblack 07-02-2010 03:42 PM

Disabling the two plug ins to prevent white pages? Yes.

You are not running 4.0.4

maf1973 07-06-2010 07:59 PM

Hope there will be a fully functional version soon....

RollaJedi 07-08-2010 03:42 PM

come on guys, somebody pick this thing up and run with it!? its such a great mod. shame to go to waste

thisgeek 07-09-2010 10:53 AM

Well, I've got users mysteriously disappearing from the leaderboard.

If I manually run the cron update task for it, I get the following error:
Code:

gXboxLive Info Update

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/includes/cron/miner.gxboxlive.php on line 85
Updated Accounts: .

Process Time: 0s.

Total Queries: 29.

Done

Looks like there may be a problem with the query.

I added some debug echos to the script, to try figure out what's going on.

I got the resolved query from $main_query, and ran it in phpmyadmin - I get a (correct) list of users.

However the line:
PHP Code:

$fullresult $vbulletin->db->query_read($main_query); 

appears to return nothing. Unfortunately I don't know enough about PHP and in particular, the VB api to try figure out what it's supposed to return.

I'll try investigate further, and I'll update this post as I go along.

Ok. Found the way to fix the error:

In the file /forum install/includes/cron/miner.gxboxlive.php
Find:
PHP Code:

$querylimit ceil(mysql_num_rows($fullresult) / ceil((strtotime(date("Y-m-d"strtotime("+1 day"))) - TIMENOW) / 60) ) + 5

And change it to:
PHP Code:

$querylimit ceil($vbulletin->db->num_rows($fullresult) / ceil((strtotime(date("Y-m-d"strtotime("+1 day"))) - TIMENOW) / 60) ) + 5

That fixes the initial error, but the rest of the script doesn't seem to be working.
---

Ok, after iterating through the $card_string array, it seems that my server is being rejected - all the cards contain "403 Forbidden". This might indicate why it no longer works.
---

For what it's worth, changing

PHP Code:

                $card_string fetch_file_via_socket($fetch_url "?bot=gXboxLive_" $gxblprod['version'] . "&ref=" $vbulletin->options['bburl'] . "/gxboxlive.php"); 

to simply

PHP Code:

                $card_string fetch_file_via_socket($fetch_url); 

fixed the issue for me. I don't know if it's the bot=gXboxLive string that has been banned or what.

AeonGamer 07-10-2010 06:51 AM

Im running vbulletin 4.0.4, whenever I click on the gxboxlive link in the navbar or visit the leaderboard file. I just get redirected back to the homepage of the forum.

Anyone know why? / how to fix it?

dieseltec 07-10-2010 07:24 AM

Quote:

Originally Posted by AeonGamer (Post 2067139)
Im running vbulletin 4.0.4, whenever I click on the gxboxlive link in the navbar or visit the leaderboard file. I just get redirected back to the homepage of the forum.

Anyone know why? / how to fix it?

Read this: https://vborg.vbsupport.ru/showpost....4&postcount=26

AeonGamer 07-10-2010 07:13 PM

Quote:

Originally Posted by dieseltec (Post 2067148)

Thanks for that. Much appreciated :)

thisgeek 07-12-2010 08:42 AM

Oh - I strongly suggest changing the update cron script to run once an hour instead of every minute. The script running every minute resulted in my server being temporarily banned from querying the cards.

HellBoy 07-21-2010 04:48 AM

Thanks to thisgeek, my Xbox Live Leaderboard is now working as intended once again. I had an issue with several disappearing accounts, which was resolved using the fix he posted. Great work!

Ronin Storm 07-21-2010 10:26 PM

Ah, good to see double confirmation of what I've discovered. Good work, thisgeek. I confirm that for us vB3.8.x users that the same fix works but I've also made the same recommendation about not hitting the card server frequently for fear of being banned.


All times are GMT. The time now is 04: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.01522 seconds
  • Memory Usage 1,753KB
  • 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
  • (1)bbcode_code_printable
  • (5)bbcode_php_printable
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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