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/

[Chris11987]

Originally Posted by bananalive

Tournament creators' should/ do have full control over their own tournaments.

Oh, sweet. So far only "special" members have had permission to make tournaments, and they had full control already, so I wasn't aware. Thanks.

[butler312]

One suggestion by one of my members was pretty good and I thought I would post it here. He suggested the ability to seed members/teams in tournaments. It would be sweet if for each tournament there was the option to not seed members, seed them according to their place in the ladder (anyone not in the ladder would randomly be seeded at the end), or seed them manually. Players/teams would then be placed in the tournament according to their seed (top seeds playing the lowest seeds or receiving the byes).

[Chris11987]

Originally Posted by butler312

One suggestion by one of my members was pretty good and I thought I would post it here. He suggested the ability to seed members/teams in tournaments. It would be sweet if for each tournament there was the option to not seed members, seed them according to their place in the ladder (anyone not in the ladder would randomly be seeded at the end), or seed them manually. Players/teams would then be placed in the tournament according to their seed (top seeds playing the lowest seeds or receiving the byes).

I'd like this as well. It should be easy if the "swap user" icon is still available after brackets have been made. That way, you can still customize them once a tournament is in progress.

Also, I have a question about how players are currently seeded: It seems that each person is given a random number out of about 10 million or so. Why is that? Why don't the players just have a random number from 1-32, or whatever the players maximum is for a tourney? I noticed all of the round 2-77 fields in the database use this way to order spots, so why not on the first round as well? I'm no coder, so forgive me if there's a good reason for that.

[darkforce114]

What the chances of changing the Ladder's from single into team's?

For example instead of Play A challenges Play B, we want it to do Team A challenges Team B and when you click on the team it list's all the players registered with that team.

[msimonds]

Originally Posted by msimonds

bananlive,

I have to say that this seems to be an outstanding add on. I thought of doing this one time for my sports site for Sports team tournaments, like American College Basketball or other sports.

do you have any thoughts of adding these features to your script?

Outstanding job sir!!!

Sir did you get a chance to read my post? is this something that could be put into place? or plans for it?

Thanks so much for creating this script by the way, it is awesome

[mozik]

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT userid, id, time, title FROM tmnt_announcements ORDER BY id DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064
Request Date : Tuesday, October 21st 2008 @ 05:42:50 PM
Error Date : Tuesday, October 21st 2008 @ 05:42:51 PM
Script : http://www.vzrgaming.com/tournament.php
Referrer : http://www.vzrgaming.com/index.php
IP Address : **********
Username : **********
Classname : vB_Database
MySQL Version : 5.0.45-community-log

keep getting this when updating.

[gamerscms]

Getting a error on the latest install

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Full Member',
	`description` = 'A full and proud member of thirteen ghosts.',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`ispublicgroup` = '0',
	`canoverride` = '0',
	`forumpermissions` = '272363767',
	`genericpermissions` = '1277695619',
	`attachlimit` = '1000000',
	`pmquota` = '50',
	`pmpermissions` = '1',
	`pmsendmax` = '5',
	`calendarpermissions` = '23',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions2` = '1',
	`genericoptions` = '47',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '25000',
	`avatarmaxwidth` = '150',
	`avatarmaxheight` = '150',
	`avatarmaxsize` = '100000',
	`signaturepermissions` = '237055',
	`sigpicmaxwidth` = '0',
	`sigpicmaxheight` = '0',
	`sigpicmaxsize` = '0',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '100',
	`albumpermissions` = '239',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '31',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '375',
	`mgc_cb_evo_permissions` = '0',
	`mgc_cb_evo_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = '',
	`awardpermissions` = '1',
	`photoplogpermissions` = '29647',
	`photoplogmaxfilesize` = '0',
	`photoplogmaxfilelimit` = '0',
	`tournamentpermissions` = '339',
	`maxteams` = '1',
	`ladderpermissions` = '3'
WHERE usergroupid=15;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 22nd 2008 @ 04:44:06 PM
Error Date    : Wednesday, October 22nd 2008 @ 04:44:06 PM
Script        : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=update
Referrer      : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=15
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname     : xxxxxxxxxx
MySQL Version : 5.0.67-community

Any ideas why this is happening when trying to update usergroups.

thanks

[JAnders]

something I find can be improved is on the ladder challanges if you add a column with the ladder name.

I have about 4 different ladders and I have about 10 challanges but I can't tell what challange is for which unless I click on the view ladder link.

[bananalive]

Originally Posted by Chris11987

I'd like this as well. It should be easy if the "swap user" icon is still available after brackets have been made. That way, you can still customize them once a tournament is in progress.

Also, I have a question about how players are currently seeded: It seems that each person is given a random number out of about 10 million or so. Why is that? Why don't the players just have a random number from 1-32, or whatever the players maximum is for a tourney? I noticed all of the round 2-77 fields in the database use this way to order spots, so why not on the first round as well? I'm no coder, so forgive me if there's a good reason for that.

It decreases probability of two players getting same slot number. I have wrote code to stop this happening but havent added it yet.

Originally Posted by darkforce114

What the chances of changing the Ladder's from single into team's?

For example instead of Play A challenges Play B, we want it to do Team A challenges Team B and when you click on the team it list's all the players registered with that team.

Team ladders coming soon

Originally Posted by msimonds

Sir did you get a chance to read my post? is this something that could be put into place? or plans for it?

Thanks so much for creating this script by the way, it is awesome

I'm sorry I don't fully understand your previous post, could you possibly rephrase it

Originally Posted by mozik

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT userid, id, time, title FROM tmnt_announcements ORDER BY id DESC LIMIT 0,;

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 '' at line 1
Error Number : 1064
Request Date : Tuesday, October 21st 2008 @ 05:42:50 PM
Error Date : Tuesday, October 21st 2008 @ 05:42:51 PM
Script : http://www.vzrgaming.com/tournament.php
Referrer : http://www.vzrgaming.com/index.php
IP Address : **********
Username : **********
Classname : vB_Database
MySQL Version : 5.0.45-community-log

keep getting this when updating.

Originally Posted by gamerscms

Getting a error on the latest install

Database error in vBulletin 3.7.2:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
	`title` = 'Full Member',
	`description` = 'A full and proud member of thirteen ghosts.',
	`usertitle` = '',
	`opentag` = '',
	`closetag` = '',
	`passwordexpires` = '0',
	`passwordhistory` = '0',
	`ispublicgroup` = '0',
	`canoverride` = '0',
	`forumpermissions` = '272363767',
	`genericpermissions` = '1277695619',
	`attachlimit` = '1000000',
	`pmquota` = '50',
	`pmpermissions` = '1',
	`pmsendmax` = '5',
	`calendarpermissions` = '23',
	`wolpermissions` = '1',
	`adminpermissions` = '0',
	`genericpermissions2` = '1',
	`genericoptions` = '47',
	`profilepicmaxwidth` = '100',
	`profilepicmaxheight` = '100',
	`profilepicmaxsize` = '25000',
	`avatarmaxwidth` = '150',
	`avatarmaxheight` = '150',
	`avatarmaxsize` = '100000',
	`signaturepermissions` = '237055',
	`sigpicmaxwidth` = '0',
	`sigpicmaxheight` = '0',
	`sigpicmaxsize` = '0',
	`sigmaxrawchars` = '0',
	`sigmaxchars` = '0',
	`sigmaxlines` = '0',
	`sigmaxsizebbcode` = '7',
	`sigmaximages` = '100',
	`albumpermissions` = '239',
	`albumpicmaxwidth` = '600',
	`albumpicmaxheight` = '600',
	`albumpicmaxsize` = '100000',
	`albummaxpics` = '100',
	`albummaxsize` = '0',
	`usercsspermissions` = '31',
	`visitormessagepermissions` = '63',
	`socialgrouppermissions` = '375',
	`mgc_cb_evo_permissions` = '0',
	`mgc_cb_evo_nbmsg_show` = '',
	`mgc_cb_evo_nbmsg_perday_show` = '',
	`awardpermissions` = '1',
	`photoplogpermissions` = '29647',
	`photoplogmaxfilesize` = '0',
	`photoplogmaxfilelimit` = '0',
	`tournamentpermissions` = '339',
	`maxteams` = '1',
	`ladderpermissions` = '3'
WHERE usergroupid=15;

MySQL Error   : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number  : 1054
Request Date  : Wednesday, October 22nd 2008 @ 04:44:06 PM
Error Date    : Wednesday, October 22nd 2008 @ 04:44:06 PM
Script        : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=update
Referrer      : http://www.xboxhive.co.uk/forums/admincp/usergroup.php?do=edit&usergroupid=15
IP Address    : xxxxxxxx
Username      : xxxxxxxxx
Classname     : xxxxxxxxxx
MySQL Version : 5.0.67-community

Any ideas why this is happening when trying to update usergroups.

thanks

That is probelm with MGC Chatbox Evo Permission column not existing.

[bananalive]

Originally Posted by jackapup

Are you going to featuring a double elimination function anytime soon with the script?

Yes, but I've got few more things to do before that

Originally Posted by chriskellar

Ok got it uninstalled. Now I'm moving forward with installing the upgraded version and here is the error that I'm getting.

Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vB_user ADD tmnt_joins INT(10) NOT NULL DEFAULT '0' ;;

MySQL Error   : Duplicate column name 'tmnt_joins'
Error Number  : 1060
Request Date  : Monday, October 20th 2008 @ 02:27:08 PM
Error Date    : Monday, October 20th 2008 @ 02:27:09 PM

Open product file with notepad or wordpad and remove that line