Major Additions - Tournaments, Ladders & Leagues Manager v4.x

**** Copyright by bananalive.org ****

Email: admin [at] bananalive.org

Version History | Screenshots | More Screenshots | Premium

Modification Description

This modification allows you to manage tournaments and ladders on your forum. It provides interactibility both for forum members and forum admin.

Tournament Types:

• Single Elimination Tournaments
• Last Man Standing Tournaments
• Double Elimination Tournaments
• Round Robin Tournaments also called all-play-all tournament
• Double Round Robin

Ladder Description:

Users or teams can join ladders and challenge other players or teams in the ladder. Elo rating system is used which calculates the difficultly of a match according to the players' ranks and this is taken into account when the ranks are updated after the match is finished.

Feature List:

• General Features
  • All pages are XHTML valid
• Tournament Features
  • Hall of Fame (Top 10 Tournament Players)
  • Permissions can be set per usergroup
    (AdminCP -> Usergroups -> Usergroup Manager -> {Select Usergroup} -> Tournament Permissions)
  • Tournaments start automatically when no slots are left
  • Tournaments have proper Date/ Time converted to users timezone and DST
  • 3 Tournament Modes: Last Man Standing, Single Elimination, Double Elimination and Round Robin
  • Filter Tournaments Displayed according to Tournament Status
  • Tournament User Stats Page
  • 'Start Tournament' for Single Elimination adds bye players and creates brackets
• Tournament options
  • Turn on/off tournament
  • Create Thread on Tournament Creation
  • Require check-in before tournaments
  • Tournament Stats in Member Profile
  • Tournament Stats in Postbit (Can be turned on/off in Tournament Options)
  • Comments per page
  • Tournament description length shown in tournament List
• Tournament Display
  • LMS realtime ranking shows if players are equal positions
  • Tournament View Counter
  • Tournament creator and last edited by notes at bottom of tournament
• Tournament Moderators can...
  • Add/edit tournament (description uses vBulletin Editor)
  • Edit tournament type if not started yet
  • Add Score type (points, wins, kills, deaths, etc.) for LMS tournaments
  • Tournament mods can remove players if tournament hasn't started
  • Increase/ Decrease Tournament Slots
  • Pm all competitors with custom message and title (permissions set to bypass max pm recipients restrictions)
  • Add players (Ajax/Javascript userid fetch)
  • Swap players in LMS mode
  • Create/ edit/ delete announcements
• Competitors can...
  • Players can remove themselves if tournament hasn't started
  • Users can PM themselves the details of the tournament
  • Sign up to tournament only once
• Tournament Comments
  • Uses vBulletin Editor
  • Comment Display with user avatars and last edited by note
  • User able to edit/delete their own comment (subject to permissions)
  • Tournament moderators can edit all comments
  • If applicable under username on comments Tournament Creator, Tournament Competitor or Tournament Winner
  • Comment paging
• Teams
  • Users can apply to teams
  • Leader can accept/ decline users
  • Team profile shows team stats
  • Team list
  • Can limit teams created by user (in usergroup options)
  • Fields: team website, gamertag, logo, description, slog, tags
• Team leader can...
  • delete players from his/her team
  • Promote players in his/her team to Leader or Co-Leader
  • Join tournaments
  • Search Free Agents for new team members
• Ladder Features
  • Elo rating system (Javascript Elo calculator @ ladders.php?do=elorating)
  • Players last activity (date)
  • Winning/ Losing Streak
  • Longest Winning Streak
  • Admin can submit scores/ add challenges
  • Report/ dispute challenges
  • Match Finder
• Ladder Display
  • leader-board for each ladder
  • last 10 upcoming/ past matches per ladder
  • separate page for accepting/rejecting challenges and submitting score (have to be accepted by other user)
• Tournament Announcements
  • Tournament Moderators can create/edit announcements
  • Uses forum last visit for announcement read marking
  • Shows last user to edit announcement
• Categories
  • Share categories for tournaments/ ladders/ leagues
  • Category displays in navbar when viewing ladder/ tournament/ league

Installation:

1. Follow instructions included in .zip
2. Click Install

Premium Features:

• Pay to play/ credits system
  • Opportunity to earn money for your forum
  • Uses PayPal for payments
• Support Tickets
• Leagues into Knockout Stage
• Live Match Finder

Suggestions:

1. Please post any suggestions/ comments about this modification and I will try and implement them

** Don't forgot to click Mark as Installed **

[joshskeety]

Originally Posted by bananalive

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]

Originally Posted by bananalive

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]

Originally Posted by MARCUS1980

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]

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]

Originally Posted by MARCUS1980

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]

Originally Posted by bananalive

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]

Originally Posted by MARCUS1980

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]

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]

Can you update the version history?

[TheChief]

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