vBulletin Mods

The Official vBulletin Modifications Site
https://www.vbulletin.org/forum/showthread.php?t=238945

ywwz 20 Mar 2012 12:26

Thanks mate, good MOD!

I solved my problem.......

joshskeety 20 Mar 2012 15:03

I have a very important tournament coming up, single elimination, 24 players and when the 24th player signs up it automatically starts the tournaments and sets the slots to 32 and adds a bunch of BYE players. Can you check in to this for me? Thanks

EDIT:

Quote:

Originally Posted by excessive34 (Post 2302240)
Trying to create a 12 man Single elimination tournament... if I add 12 people to the tourny it automatically changes it to 16 and puts 4 of the people on a bye week... wtf man

Same problem here!

bananalive 20 Mar 2012 18:00

Quote:

Originally Posted by joshskeety (Post 2311395)
I have a very important tournament coming up, single elimination, 24 players and when the 24th player signs up it automatically starts the tournaments and sets the slots to 32 and adds a bunch of BYE players. Can you check in to this for me? Thanks

EDIT:



Same problem here!

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.

bananalive 20 Mar 2012 18:07

Quote:

Originally Posted by MARCUS1980 (Post 2311333)
Hello friend Bananalive I need your help more now thank you for your attention!

I got the product mentioned in this post, the full version on your site, as did the instalção correctly sends the instructions, but it adds the fields in the menu bar, but when I click paa access, error on page appears.

"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 : Tabela 'torbrasil.tmnt_tmnts' não existe
Error Number : 1146
Request Date : Tuesday, March 20th 2012 @ 09:35:04 AM
Error Date : Tuesday, March 20th 2012 @ 09:35:04 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 "


I installed and reinstalled several times, but always with the same error, I asked my friends WHAT could be, then I got the answer for some reason the file *. Xml installation is not creating the table in the database.

My site is www.torbrasil.com.br, my account on their site is [email protected], sorry English horrible because I'm from Brazil and used a translator lol, sorry!

I'm posting here because you can not send the other place, thank you and help me because I liked the mod, and you are parabens, goodbye!

How is your mysql database set-up, is the mysql type = MyISAM ?

bananalive 20 Mar 2012 18:16

Quote:

Originally Posted by pwnedPRO (Post 2310613)
Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

If they do not exist...


Use these images: http://www.vbulletin.org/forum/image...llapse_alt.gif
http://www.vbulletin.org/forum/image...llapse_alt.gif
http://www.vbulletin.org/forum/image..._collapsed.gif

Right click on image, save as, then upload to server to appropriate folder.
Quote:

Originally Posted by pwnedPRO (Post 2310613)
where this files? :)


you are updated first post and download link module?

ps seo links for this mod - good idea ...

for example links:

no seo - http://a/competitions.php?
with seo - http://a/competitions/
no seo - http://a/ladders.php?showonly=ladders
with seo - http://a/ladders/

etc...

SEO links will be added into next version as premium feature.

joshskeety 20 Mar 2012 18:43

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 20 Mar 2012 22:14

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 20 Mar 2012 23:53

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 21 Mar 2012 04:01

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 21 Mar 2012 10:17

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 21 Mar 2012 15:50

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 21 Mar 2012 16:31

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 21 Mar 2012 23:19

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 22 Mar 2012 10:19

Can you update the version history?

TheChief 23 Mar 2012 07:58

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 08:00.

Powered by vBulletin® Version 3.8.14
Copyright © 2023, MH Sub I, LLC dba vBulletin. All Rights Reserved. vBulletin® is a registered trademark of MH Sub I, LLC
Copyright ©2001 - , vbulletin.org. All rights reserved.