Ladder Description:
Users or teams can also 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:
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
2 Tournament Modes: Last Man Standing and Single Elimination
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
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
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
Category displays in navbar when viewing ladder/ tournament
Installation:
Follow instructions included in .zip
If you are using v3.6.x you will need to download this product file and import it
(It contains memberinfo css which is used in profile comments in v3.7.x and is in used in Tournaments Comments and Team Profiles)
Click Install
Future Features:
Add more Different Tournament Types (Double Elimination and Round Robin)
Allowing a player to only join one team per ladder
Use 3.7/3.8 notification system
My Teams page
Easy way to Re-arrange users in tournament
Limit number of challenges per week/day
Ladder match finder
Custom message included in challenge pm sent to user
Donations:
If you want to donate please click 'Support Developer'
Database error in vBulletin 3.7.4:
Invalid SQL:
UPDATE tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=3 AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1
Error Number : 1064
Request Date : Monday, November 24th 2008 @ 09:04:15 PM
Error Date : Monday, November 24th 2008 @ 09:04:16 PM
Script : http://www.com/forum/competitions.php?do=ladderteamreject&id=3
Referrer : http://www.com/forum/competitions.php?do=ladderteamchallenges
IP Address : ************
Username : **********
Classname : vB_Database
MySQL Version : 5.0.51a-community
Just installed, went smooth. Made test ladder, made a challange, accepts challange great. I get this error when I reject challange. Anyone know what is causing this. Installed latest mod from first post. No other issues are known at this time.
Database error in vBulletin 3.7.3:
Invalid SQL:
SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
WHERE champion<>'';
MySQL Error : Unknown column 't.champion' in 'field list'
Error Number : 1054
Request Date : Friday, September 26th 2008 @ 08:57:34 PM
Error Date : Friday, September 26th 2008 @ 08:57:35 PM
Script : http://xaax.biz/forums/showthread.php?t=12346
Referrer : http://xaax.biz/forums/halo_3/
IP Address : 71.28.9.189
Username : CamoMouse
Classname : vB_Database
MySQL Version : 5.0.51b-community-nt
How do I get that to stop? There are now plugins installed of Tournaments. As far as I know, Tournaments should not exits on my site but I'm getting nothing but MySql errors when you visit my site. I need help.
Quote:
Database error in vBulletin 3.7.4:
Invalid SQL:
SELECT t.champion, u.userid FROM tournaments AS t
LEFT JOIN user AS u ON (t.champion = u.username)
WHERE champion<>'';
MySQL Error : Table 'fragmast_khalik59.tournaments' doesn't exist
Error Number : 1146
Request Date : Wednesday, November 26th 2008 @ 12:16:16 PM
Error Date : Wednesday, November 26th 2008 @ 12:16:16 PM
Script : http://www.fragmasters.co.uk/forum/s...ad.php?t=28186
Referrer : http://www.fragmasters.co.uk/forum/index.php
IP Address : 194.106.36.230
Username : Fragmaster
Classname : vB_Database
MySQL Version : 5.0.51a
I am getting the same error, I had uninstalled it completely as it should not be on my site but I am getting mysql errors everywhere.
Being able to create categories for tournaments, e.g. Categorie A "Tournaments of Game X", Categorie B "Tournaments of Game Y", as well as Sub Catogeries like Categorie A "Tournaments of Game X" - Sub Categorie A-1 "XY Championship Series" etc.
It would be nice to add names without being them registered users
Combined with the categories mentioned above, being able to create leagues (=overview who won how many times etc) off tournaments.
Being able to set points. Reaching the semifinals = 5 pts, reaching the final = 10 pts etc.
Fight for 2nd and 3rd place in tournaments
Being able to deactivate the ladder system if you don't need it
Being able to create categories for tournaments, e.g. Categorie A "Tournaments of Game X", Categorie B "Tournaments of Game Y", as well as Sub Catogeries like Categorie A "Tournaments of Game X" - Sub Categorie A-1 "XY Championship Series" etc.
It would be nice to add names without being them registered users
Combined with the categories mentioned above, being able to create leagues (=overview who won how many times etc) off tournaments.
Being able to set points. Reaching the semifinals = 5 pts, reaching the final = 10 pts etc.
Fight for 2nd and 3rd place in tournaments
Being able to deactivate the ladder system if you don't need it
However, it's already a great modification!
Thanks for reading
Agreed.
+ Requests:
1. Randomized Map/Gametype that is tournament specific.
2. Ability to Report Wins/Loses to Tournament Mod to make advancement quicker.
3. Addition to the vB Notification system for said reports and Team Invites/Requests to join.
I am getting the same error, I had uninstalled it completely as it should not be on my site but I am getting mysql errors everywhere.
How do I stop it ?
I want to say that is your arcade tournaments. No database tables with this mod have the word tournaments in it. They all start tmnt and than whatever the table is for. tournaments is a database table for the arcade system.
Database error in vBulletin 3.7.4:
Invalid SQL:
UPDATE tmnt_ladder_games SET accepted = -1, finished = 1 WHERE id=3 AND agree_u = 0, agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1);
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' agree_u2 = 0, score_u = 0, score_u2 = 0, AND u2 IN (1)' at line 1
Error Number : 1064
Request Date : Monday, November 24th 2008 @ 09:04:15 PM
Error Date : Monday, November 24th 2008 @ 09:04:16 PM
Script : http://www.com/forum/competitions.php?do=ladderteamreject&id=3
Referrer : http://www.com/forum/competitions.php?do=ladderteamchallenges
IP Address : ************
Username : **********
Classname : vB_Database
MySQL Version : 5.0.51a-community
Just installed, went smooth. Made test ladder, made a challange, accepts challange great. I get this error when I reject challange. Anyone know what is causing this. Installed latest mod from first post. No other issues are known at this time.
I want to add that this is with the Teams for the ladders. It works fine with just members of the forum joing the Player ladders. Could this issue be caused because you create a team name rather using the username of the forums.
Forum Tournaments & Ladders Details »»
About Developer
Visit Web Site
DB Changes 
No support by the author.
11-25-2008, 02:14 AM
