vb.org Archive
Page 53 of 127 « First 3435152 53 545563103 Last »
Show 40 post(s) from this thread on one page

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 02-01-2008 04:26 AM
@Silviu, unfortunately I think you will have to try that. I am at a loss for why you are having that issue.

@XFSImperial, I'm not quite sure what is causing the error, I will look into that. It appears that some users just entered 'gamertag' as their gamertag?

@theoz1, you can take out the regex from the profilefield.

theoz1 02-01-2008 08:00 AM
i am not finding the regex anywhere.

blayke 02-01-2008 09:04 AM
Is there a way to make it so the navbar says

LeaderBaords instead of gXboxLive?

And in the postbit too?

sense1 02-01-2008 11:49 AM
I'm getting an error message when I load the mod. This happens even though I set the user profile field to '7', as this seems to be the common cause for errors like this. Any ideas? The user.lastvisit entry looks a bit suspect but then, I know nothing about SQL...

Quote:
Database error in vBulletin 3.6.8:

Invalid SQL:
SELECT
COUNT(user.userid) AS `usercount`,
SUM(gxboxlive.score) AS `score`,
SUM(gxboxlive.reputation) AS `reputation`,
SUM(gxboxlive.gold) AS `gold`
FROM
`user` AS user
LEFT JOIN
`userfield` AS userfield ON (user.userid = userfield.userid)
LEFT JOIN
`gxboxlive` AS gxboxlive ON (userfield.userid = gxboxlive.userid)
WHERE
user.usergroupid NOT IN()

AND
field7 != ''
AND
user.posts >= '0'
AND
user.lastvisit >= '1170334536'
AND
gxboxlive.strikes = '0'
AND
gxboxlive.score >= '1';

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 ')

AND
field7 != ''
AND
user.posts >= '0'
AND
user.lastvisit' at line 13
Error Number : 1064
Date : Friday, February 1st 2008 @ 04:55:35 AM
Script : http://www.insensatez.com/forum/index.php
Referrer : http://www.insensatez.com/forum/admi...ex.php?do=head
IP Address : x.x.x.x
Username : xxx
Classname : vb_database
I've disabled the plugin for now until I can resolve this.

mr.gamesbay 02-01-2008 10:49 PM
Works perfect on vB 3.7 Beta 4.
Thanks for this great Mod :)

In "Zone, Top Zone" i have the english "Recreation" word.
Can i chance somewhere the URL to the German live server?

Thanks and sorry for my bed English :)

Gryphon 02-01-2008 11:11 PM
@theoz1, go to your user profilefield option and remove the regular expression.

@blayke, search the phreases for gxboxlive

@sense1, it might be the usergroup ids make sure those options have at least a 0

@mr.gamesbay, ill look into that

theoz1 02-02-2008 12:28 AM
Thx for the help. This will still update without that expression?

Gryphon 02-02-2008 04:13 AM
Yeah, it is just to help keep people from entering the wrong format, like using underscores for spaces or just entering gibberish, a rare occurrence.

XFSImperial 02-02-2008 02:45 PM
I also liked how previous versions gave the date/time that the leaderboard was updated. Unless I'm crazy and it's still on there somewhere...

Ran the scheduled task again, still get the error. Tried re-installing but same thing comes up.

Code:
gXboxLive Update

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

Process Time: 1s.

Total Queries: 71.
Done

ForumDrop 02-04-2008 02:58 PM
How do i get the stats to show under the navbar on the forum homepage: http://xgamertag.com


All times are GMT. The time now is 12:04 PM.
Page 53 of 127 « First 3435152 53 545563103 Last »
Show 40 post(s) from this thread on one page

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.01904 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
  • (1)bbcode_code_printable
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)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