Major Additions - Forum Tournaments & Ladders

[Script Demo] [Version History]
Compatible with 3.6.x, 3.7.x, 3.8.x

Tournament Description:
Users or teams can join tournaments. Once full the tournament starts. In single elimination tournaments competitors progress through rounds of tournament with the number of rounds depending on the number of players in tournament which is set on tournament creation. Last Man Standing Tournaments also supported.
[Screenshot of Single Elimination Tournament (Slightly outdated)]

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
• 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
• 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
• 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
  • Category displays in navbar when viewing ladder/ tournament

Installation:

1. Follow instructions included in .zip
2. 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)
3. 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'

Translations:

• German/ Deutsch http://www.vbulletin-germany.org/showthread.php?t=5594
• French/ fran?aise http://www.vbulletin-ressources.com/...itions-t15101/

[bananalive]

Originally Posted by bananalive

Sorry yes there's an error with PM sending to user being challenged. (Fix will be released with next version.)

v2.4.2 BETA 2
- contains ladder challenge fix

[mlthmp]

OK.. just uploaded the files form the BETA 2 zip.
When I tried to import the file, I get this.

Invalid SQL:
ALTER TABLE vb_usergroup ADD ladderpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'ladderpermissions'
Error Number : 1060
Request Date : Monday, September 29th 2008 @ 05:22:50 PM
Error Date : Monday, September 29th 2008 @ 05:22:53 PM

[bananalive]

Originally Posted by mlthmp

OK.. just uploaded the files form the BETA 2 zip.
When I tried to import the file, I get this.


Invalid SQL:
ALTER TABLE vb_usergroup ADD ladderpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;;

MySQL Error : Duplicate column name 'ladderpermissions'
Error Number : 1060
Request Date : Monday, September 29th 2008 @ 05:22:50 PM
Error Date : Monday, September 29th 2008 @ 05:22:53 PM

find and delete in product file

$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup ADD ladderpermissions INT(10) UNSIGNED DEFAULT '0' NOT NULL ;");

[mlthmp]

When I did that, I kept getting the same error, for different tables.

So, instead I went in via myphpadmin and physically found, and deleted every table, or addition to existing tables the modification created. Took awhile, but when I was done, it installed correctly.

I have one suggestion. Is it possible to create, and include an additional file that will delete all modification DB changes encase anyone ever wants or needs to uninstall? I know some phpbb mods include an install / uninstall file you can upload, and click on to add/remove tables. Maybe something like that is possible here?

I know it was sure a hassle to find, and remove all the DB tables by hand, lol. Maybe save someone some heartbreak if they ever need to remove to upgrade or something?

BTW, I like the merged mods. Looks great together! Great job!

[gamerscms]

Still getting the PM error:

Please complete both the subject and message fields.

[mlthmp]

Found one small error to add.

When a user adds a comment to an event, it pops up the message that its been entered, and click here if you do not wish to wait. Clicking does nothing, and the message just stalls.

No biggie, the guys can just use the back button.. but just wanted to let you know.

[AK47 Nemesis]

Small sugestion: Maybe you could add a section to put rules? That would be great.

[rob01]

hey im trying to install the new tournament
but if i drop the tournament mob i get this error

Database error in vBulletin 3.7.3:
Invalid SQL:
DROP TABLE vbb_tmnt_activity;;
MySQL Error : Unknown table 'vbb_tmnt_activity'

and if i drop ladder i get this error

Database error in vBulletin 3.7.3:
Invalid SQL:
DROP TABLE vbb_ladders;;
MySQL Error : Unknown table 'vbb_ladders'

but i already try adding the vbb_ladders table with mysql, but still i get the same error
any help? pleas thanks

[indie2industry]

is there a way to change the color of the brackets?? I have an all black VB and no one can see the actual brackets

[Chris11987]

I'm having a big problem.... I can't update usergroups because of a table from the tournament. I tried to uninstall the tournament and this is what I get everytime:

Invalid SQL:

DROP TABLE vb_tmnt_activity;;

MySQL Error : Unknown table 'vb_tmnt_activity'
Error Number : 1051

I tried reinstalling and upgrading the tournament as well, and no luck. I haven't even used the tournament software in about a week, so I'm unsure as to why it suddenly did this. I checked phpmyadmin and the table doesn't exist. What do I do here?

fyi: I was using/reinstalled/upgraded with version 2.4.

edit: This is the error I get when trying to update a usergroup:

MySQL Error : Unknown column 'tournamentpermissions' in 'field list'
Error Number : 1054

Both of those are missing form the db, even after I update the product again.