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)
-   -   Major Additions - Tournaments, Ladders & Leagues Manager v4.x (https://vborg.vbsupport.ru/showthread.php?t=238945)

joshskeety 03-20-2012 06:43 PM

Quote:

Originally Posted by bananalive (Post 2311453)
Tournaments are required to be have a slots factor of 4.

32 players goes to 16 goes to 8 goes to 4 goes to 2 and then a winner.
24 players goes to 12 goes to 6 goes to 3 then ???

The bye players are added in round 1, to prevent someone getting a bye in the semi-final to the final, as it seems more fair.

You're right... I'm not quite sure how I missed this detail, heh.

Anyway, as for my feature request above it seems like it'd be a good idea. Specify usergroups for users who join tournaments. Not sure if it would be needed to have individual usergroup designations PER tournament rather than just one global group for any tournament participant. Could give them access to hidden tournament forums, etc.

MARCUS1980 03-20-2012 10:14 PM

Quote:

Originally Posted by bananalive (Post 2311455)
How is your mysql database set-up, is the mysql type = MyISAM ?

Server version: MySQL 5.5.15-log x86_64 Linux
Host Connection: mysql.torbrasil.com.br
User Connection: same name as the database
InnoDB: Server with support for InnoDB

bananalive 03-20-2012 11:53 PM

Quote:

Originally Posted by MARCUS1980 (Post 2311568)
Server version: MySQL 5.5.15-log x86_64 Linux
Host Connection: mysql.torbrasil.com.br
User Connection: same name as the database
InnoDB: Server with support for InnoDB

I think there was conflict between MyISAM and InnoDB

Try v5.1.0

MARCUS1980 03-21-2012 04:01 AM

As I said, I installed the version and nothing :-(

"Database error in vBulletin 4.1.6:

Invalid SQL:

SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN tmnt_ladders AS leagues
ON (cats.catid = leagues.catid AND leagues.league > 0)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;

MySQL Error : Coluna 'cats.displayorder' desconhecida em 'order clause'
Error Number : 1054
Request Date : Wednesday, March 21st 2012 @ 01:08:52 AM
Error Date : Wednesday, March 21st 2012 @ 01:08:52 AM
Script : http://www.torbrasil.com.br/competitions.php
Referrer : http://www.torbrasil.com.br/forum.php
IP Address : 187.21.114.241
Username : MARCUS1980
Classname : vB_Database
MySQL Version : 5.5.15-log"

bananalive 03-21-2012 10:17 AM

Quote:

Originally Posted by MARCUS1980 (Post 2311616)
As I said, I installed the version and nothing :-(

"Database error in vBulletin 4.1.6:

Invalid SQL:

SELECT cats.*, COUNT(DISTINCT tmnts.id) AS counttmnts, COUNT(DISTINCT ladders.id) AS countladders, COUNT(DISTINCT leagues.id) AS countleagues, pcat.title AS categorytitle2, pcat.title AS parenttitle
FROM tmnt_categories AS cats
LEFT JOIN tmnt_categories AS pcat
ON (cats.parentid = pcat.catid)
LEFT OUTER JOIN tmnt_tmnts AS tmnts
ON (cats.catid = tmnts.catid)
LEFT OUTER JOIN tmnt_ladders AS ladders
ON (cats.catid = ladders.catid AND ladders.league = 0)
LEFT OUTER JOIN tmnt_ladders AS leagues
ON (cats.catid = leagues.catid AND leagues.league > 0)
GROUP BY cats.catid
ORDER BY cats.parentid DESC, cats.displayorder ASC, cats.title ASC;

MySQL Error : Coluna 'cats.displayorder' desconhecida em 'order clause'
Error Number : 1054
Request Date : Wednesday, March 21st 2012 @ 01:08:52 AM
Error Date : Wednesday, March 21st 2012 @ 01:08:52 AM
Script : http://www.torbrasil.com.br/competitions.php
Referrer : http://www.torbrasil.com.br/forum.php
IP Address : 187.21.114.241
Username : MARCUS1980
Classname : vB_Database
MySQL Version : 5.5.15-log"

That's a different error now. Do you have access to PHPMYADMIN to view/edit mysql manually.

Have a look at table `tmnt_categories` for column `displayorder`

MARCUS1980 03-21-2012 03:50 PM

Quote:

Originally Posted by bananalive (Post 2311664)
That's a different error now. Do you have access to PHPMYADMIN to view/edit mysql manually.

Have a look at table `tmnt_categories` for column `displayorder`

Done thank you, just one question, would have some translation into Portuguese Brazil

bananalive 03-21-2012 04:31 PM

Quote:

Originally Posted by MARCUS1980 (Post 2311752)
Done thank you, just one question, would have some translation into Portuguese Brazil

Use vBulletin AdminCP Phrase Manager

AdminCP -> Languages & Phrases -> Search in Phrases

Then translate phrases, beginning with tmnt_ or ladder_ into portugese.

InTheBox 03-21-2012 11:19 PM

Just started testing this mod and it looks great so far, very nice job. I have a few feature requests though if possible.

1. Ability to Limit amount of teams and/or players per ladder

2. Ability for vacation time limit per ladder. (For example when setting up, the ladder admin would have the ability to activate "allow team/player vacation time" and enter in a number for maximum days) on the team admin side they would have the ability to activate the vacation switch (if they have any time remaining from the set max days) and during that time the team would be safe from challenges or deactivated up to the max days, if the team only uses a partial of the max days it would be subtracted from their overall total which was set as max vacation days when the ladder was configured.

3. Map List choices with drop downs for Ladder.

4. Ability for challenger to choose more than one date and time for possible ladder match then defender accepts from those dates.

What I would love to see is combining 3 and 4. The challenger picks 2 to 3 dates and times for the match, the defender accepts 1 date out of those and selects 2 to 3 map choices and then the challenger accepts 1 map out of those for the match.

5 Ability to upload demo's or screenshots after ladder match completion , I see the screenshot field but not sure how to use it.

vap0r-7 03-22-2012 10:19 AM

Can you update the version history?

TheChief 03-23-2012 07:58 AM

Sorry if this has already been asked/answered

I have set all the permissions for this mod and the team that have mod abilities cannot edit announcements. When they do edit and go to save it states 'Do you want to navigate away from this page, all changes will be lost'

I've checked, double checked and even triple checked the permissions but no luck.

I'm the site super admin and i cannot edit these either.

It's probably me...............any help would be greatly appreciated


All times are GMT. The time now is 04:34 AM.

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.02911 seconds
  • Memory Usage 1,756KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)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