vb.org Archive - Major Additions - TIO/FTL Compatible Ranking Ladder System LITE

Page 5 of 10

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)

- - Major Additions - TIO/FTL Compatible Ranking Ladder System LITE (https://vborg.vbsupport.ru/showthread.php?t=208705)

Jaxel

03-20-2009 08:23 PM

Hmm... this new version created some new errors... give me a moment, as I am fixing them.

Jaxel

03-20-2009 08:37 PM

Okay... all errors should be fixed now.

Jaxel

03-21-2009 02:45 PM

By request from HoLyMeN... Ranks are now listed in the postbit!

================================================== =========
Version 1.3.0
================================================== =========

Added support for displaying a user's linked rank within the postbit.
- Linked ranks are controlled by the pExt (Forum ID) value of a player.
- Linked ranks are updated during the existing "rebuild ranks" function.
More small and minor MYSQL warnings; they should all be gone now!
FILE EDITS SINCE 1.2.0: (make sure you upload these new versions!)
- upload/ranking.php
- upload/ranking/functions_rank.php
- upload/ranking/functions_rank_pro.php

EWGF	03-21-2009 04:48 PM

Quote:

Originally Posted by Jaxel (Post 1771381)

You can add timezones in your control panel. Only timezones found HERE: http://us.php.net/timezones will function with this mod. You cant use something like "EST", you must use "US/Eastern"; as it will automatically take daylight savings into consideration. BTW... I hate Electric Wind God Fist... but I LOVE Bloodline Rebellion. Whats your name on TZ?

Ah okay, Europe/Amsterdam will be enough then.

EWGF	03-21-2009 10:43 PM

How can I add categories and games? I think the lack of it is preventing me from uploading an xml :confused:

And I saw something about recounting stuff. Can't find anything about it... Almost as if I'm missing a lot of files, yet they're all uploaded

Jaxel

03-21-2009 10:59 PM

EWGF, define an admin group in your user settings... you will see new options on the ladder then.

EWGF	03-21-2009 11:05 PM

Thanks, overlooked that :P

EWGF	03-21-2009 11:17 PM

Adding players to a tournament gives this error:

Code:

Database error in vBulletin 3.8.1:



Invalid SQL:

SELECT *, COUNT(playerID) as count FROM rank_events AS rank_events

                LEFT JOIN rank_categories AS rank_categories USING(categoryID)

                LEFT JOIN rank_scores AS rank_scores USING(eventID)

                WHERE rank_events.eventID = '1';



MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Error Number  : 1140

Request Date  : Sunday, March 22nd 2009 @ 01:13:31 AM

Error Date    : Sunday, March 22nd 2009 @ 01:13:31 AM

Script        : http://*/forum/ranking.php?do=event&eid=1

Referrer      : http://*/forum/ranking.php?do=event&eid=1

IP Address    : 

Username      : 

Classname     : vB_Database

MySQL Version : 5.0.45-Debian_1ubuntu3.3-log

XML uploading btw still gives me error, lol lite version

Jaxel

03-21-2009 11:19 PM

EWGF, please download the new version... I replaced all USING JOINS with ON JOINS...

People with older versions of MYSQL were having problems with USING JOINS.

EWGF	03-21-2009 11:25 PM

The error persists.

Code:

Database error in vBulletin 3.8.1:



Invalid SQL:

SELECT *, COUNT(playerID) as count FROM rank_events AS rank_events

                LEFT JOIN rank_categories AS rank_categories USING(categoryID)

                LEFT JOIN rank_scores AS rank_scores USING(eventID)

                WHERE rank_events.eventID = '1';



MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause

Error Number  : 1140

Request Date  : Sunday, March 22nd 2009 @ 01:24:19 AM

Error Date    : Sunday, March 22nd 2009 @ 01:24:19 AM

Script        : http://*/forum/ranking.php?do=event&eid=1

Referrer      : http://*/forum/ranking.php?do=event&eid=1

IP Address    : 

Username      : 

Classname     : vB_Database

MySQL Version : 5.0.45-Debian_1ubuntu3.3-log

All times are GMT. The time now is 07:10 AM.

Page 5 of 10

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01312 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_code_printable (1)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (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
Messages: