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/

[Bradley_Wint]

Aww man, I was disappointed when I saw you couldn't host score table style competitions. I have a racing forum and we race single events as well as tournaments, where the higher scorer gets more points and the lower gets least points, so in effect all players will be listed according to score per event. Would anything be in the works like this in the future? I couldn't find any other script to meet those needs

[bananalive]

Originally Posted by Bradley_Wint

Aww man, I was disappointed when I saw you couldn't host score table style competitions. I have a racing forum and we race single events as well as tournaments, where the higher scorer gets more points and the lower gets least points, so in effect all players will be listed according to score per event. Would anything be in the works like this in the future? I couldn't find any other script to meet those needs

You could try LMS (Last Man Standing) tournament for this.

Originally Posted by astrid1

Isn't there also a German version (translation) on vbulletin-germany.org is to be found? I think many Germans would be pleased.

No sorry. (They have my permission to translate it.)

[Bradley_Wint]

Oh, so basically, technically I am not eliminating anyone. Rather than scoring on who remains alive (shooting game, the order of last man standing would be the order of who wins the race? Am I right?

[Gn_Snake]

Hi for all,
i have a problem ,when submit score in the ladder gives this error to me:

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE HG_tmnt_ladder_players SET loses = loses + 1, wstreak = 0, lstreak = lstreak + 1, latime =1233780968, rank = 987.5, uod = -1, totalpoints = totalpoints + 5, longeststreak = 0 WHERE lid = 3 AND userid = 5574;

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


any idea???

[Gamelobby]

Originally Posted by Bradley_Wint

Aww man, I was disappointed when I saw you couldn't host score table style competitions. I have a racing forum and we race single events as well as tournaments, where the higher scorer gets more points and the lower gets least points, so in effect all players will be listed according to score per event. Would anything be in the works like this in the future? I couldn't find any other script to meet those needs

This would be great to score like a league.. (think Nascar where each week they get a certain amount of points for each place)
I think both the ladder & tournament system can be altered to work for this.. i just dont know how.


Also i have a question..
My board has this BIG gap between the 2 columns, in the tournament section.?
http://www.gamelobby.com/Forum/competitions.php
Is anyone else having this problem.? (maybe it is an issue with 3.8)

Thanks

[Bradley_Wint]

@bananalive - I got it to work. Thanks man. Also, is there a way to have a championship style event where a number of LMS events fall under a certain main event.

e.g. Race Championship

Under that would be

Event 1 - Track A
Event 2 - Track B
etc

and the aggregate scores would add up to show the winner of the overall event.

Is that possible?

@Gamelobby - I will get back to you tonight via PM.

[montesm]

Running 3.6.4 - and getting this error when creating a tournament. Can you please help??

Invalid SQL:
SELECT comments.id AS id, comments.comment AS comment, comments.userid AS userid, comments.username AS username, comments.time AS time, comments.ed_userid AS ed_userid, comments.ed_username AS ed_username, comments.ed_time AS ed_time, comments.ed_ip AS ed_ip, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb
FROM vb_tmnt_comments AS comments
LEFT JOIN vb_user AS user ON (comments.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE comments.tid=4 ORDER BY comments.id ASC LIMIT 0, 5;

MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054

[Freakboy380]

Hmmmm was working fine until I installed some new mods, now it just shows up blank when i go to /competition.php (i renamed it because of another mod, it worked fine, just after the new mods the problem began). Here is the list of mods installed please tell me if anyone knows if one or more are incompatible.
Running 3.8.1

AME - The Automatic Media Embeder 2.5.4
Community News Letter Light 1.0.0 1.0.0
Competitions 1.0.3
Cyb - Advanced 'New Posts' 2.4
Cyb - Advanced Forum Statistics 6.5
Cyb - Last Post Info Enhancements 1.2
Cyb - Login To User Account 2.2
Cyb - PM System Enhancements 1.5
Hide Closed Forum Threadlist 1.0.1
Inferno External 1.0
Invitation System 2.0.3
Live Topic 1.05b
Quick Editor Improver 3.0
Separate Sticky and Normal Threads 2.0.0
Similar thread check v2 2.0
Tag Cloud - Forum Home 2.0.0
vB Tournaments and Ladders 2.7.5
vBjirc 1.0.0

[bananalive]

Originally Posted by montesm

Running 3.6.4 - and getting this error when creating a tournament. Can you please help??


Invalid SQL:
SELECT comments.id AS id, comments.comment AS comment, comments.userid AS userid, comments.username AS username, comments.time AS time, comments.ed_userid AS ed_userid, comments.ed_username AS ed_username, comments.ed_time AS ed_time, comments.ed_ip AS ed_ip, user.avatarrevision AS avatarrevision, avatar.avatarpath AS avatarpath, NOT ISNULL(customavatar.userid) AS hascustom, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb
FROM vb_tmnt_comments AS comments
LEFT JOIN vb_user AS user ON (comments.userid = user.userid) LEFT JOIN vb_avatar AS avatar ON(avatar.avatarid = user.avatarid) LEFT JOIN vb_customavatar AS customavatar ON(customavatar.userid = user.userid)
WHERE comments.tid=4 ORDER BY comments.id ASC LIMIT 0, 5;

MySQL Error : Unknown column 'customavatar.width_thumb' in 'field list'
Error Number : 1054

Find and delete in competitions.php

PHP Code:

, customavatar.width_thumb AS width_thumb, customavatar.height_thumb AS height_thumb 


[Gn_Snake]

Originally Posted by Gn_Snake

Hi for all,
i have a problem ,when submit score in the ladder gives this error to me:

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE HG_tmnt_ladder_players SET loses = loses + 1, wstreak = 0, lstreak = lstreak + 1, latime =1233780968, rank = 987.5, uod = -1, totalpoints = totalpoints + 5, longeststreak = 0 WHERE lid = 3 AND userid = 5574;

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


any idea???

Hi bananalive
You have a solution for me??

thanx