vb.org Archive
Page 6 of 127 « First 45 6 781656106 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-27-2007 09:26 PM
Quote:
Originally Posted by Sjakie (Post 1192220)
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 02-27-2007 09:49 PM
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 02-27-2007 09:55 PM
Uncached templates: gxbl_top_avatars (5)
Uncached templates: gxbl_top_players (5)
Uncached templates: gxbl_top_zones (3)

Gryphon 02-27-2007 10:02 PM
Ah yeah, I forgot that. v1.31 should fix that.

Robbed 02-27-2007 10:33 PM
Thanks Again

Canis Firebrand 02-28-2007 10:52 AM
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.

Canis Firebrand 02-28-2007 12:05 PM
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 02-28-2007 02:34 PM
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 02-28-2007 04:13 PM
I got similar DB errors and reverted back to previous version. Now I get DB failures when the cron tries to run...

Gryphon 02-28-2007 04:22 PM
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.


All times are GMT. The time now is 12:09 AM.
Page 6 of 127 « First 45 6 781656106 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.01785 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
  • (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