Go Back   vb.org Archive > vBulletin Modifications > vBulletin 3.8 Modifications > vBulletin 3.8 Add-ons
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Forum Tournaments & Ladders Details »»
Forum Tournaments & Ladders
Version: 2.8.4, by bananalive bananalive is offline
Developer Last Online: Nov 2023 Show Printable Version Email this Page

Category: Major Additions - Version: 3.8.x Rating:
Released: 08-27-2008 Last Update: 06-05-2011 Installs: 683
DB Changes Uses Plugins Auto-Templates
Additional Files Translations  
No support by the author.

[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:

Download Now

File Type: zip vB_Tournaments+Ladders v2.8.4.zip (71.8 KB, 2059 views)
File Type: zip Security_Patch_for_vB_Tournaments_and_Ladders_v2.8.4.zip (9.5 KB, 254 views)

Screenshots

File Type: jpg createtournament.jpg (78.0 KB, 0 views)
File Type: jpg jointournament.jpg (89.2 KB, 0 views)
File Type: jpg tournamentpermissions.jpg (123.5 KB, 0 views)
File Type: jpg exampletournament.jpg (68.0 KB, 0 views)
File Type: jpg tmnt_comments.jpg (107.0 KB, 0 views)
File Type: jpg reprogressplayer.jpg (67.4 KB, 0 views)
File Type: jpg teamviewleader.jpg (76.8 KB, 0 views)
File Type: jpg teamlist.jpg (43.1 KB, 0 views)

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #822  
Old 10-17-2008, 07:29 PM
powerbook's Avatar
powerbook powerbook is offline
 
Join Date: Jul 2006
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

ALTER TABLE vb_tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;


Quote:
Originally Posted by bananalive View Post
For New Installs:
Use Attachment 88248 to completely uninstall modification tables. (Only use if you have no tournament data, it completely uninstalls the mod.)
Then import Attachment 88249 which is updated product file for mod

For upgrades:
Import Attachment 88249 which is updated product file for mod
Reply With Quote
  #823  
Old 10-17-2008, 07:31 PM
bananalive bananalive is offline
 
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by powerbook View Post
ALTER TABLE vb_tmnt_ladder_players ADD rank INT(10) UNSIGNED DEFAULT '1000' NOT NULL ;;
Are you new install or upgrade?
Reply With Quote
  #824  
Old 10-17-2008, 07:35 PM
conker1 conker1 is offline
 
Join Date: May 2007
Location: Turkey
Posts: 16
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

i got this error

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:

  INSERT INTO `vbtmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here');

MySQL Error   : Duplicate entry '1' for key 1
Error Number  : 1062
and errorfix2008.xml

Code:
Database error in vBulletin 3.7.3:

Invalid SQL:
ALTER TABLE vbusergroup DROP COLUMN tournamentpermissions;;

MySQL Error   : Can't DROP 'tournamentpermissions'; check that column/key exists
Error Number  : 1091
Reply With Quote
  #825  
Old 10-17-2008, 07:37 PM
powerbook's Avatar
powerbook powerbook is offline
 
Join Date: Jul 2006
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I had a install...Run the errorfix checked DB removed tables then run install..

Quote:
Originally Posted by bananalive View Post
Are you new install or upgrade?
Reply With Quote
  #826  
Old 10-17-2008, 07:39 PM
bananalive bananalive is offline
 
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by conker1 View Post
i got this error
Any errors in error-fix.xml doesnt matter.

Find and delete following code from product-tournament2008.xml then re-import.
Code:
$vbulletin->db->query_write("
  INSERT INTO `". TABLE_PREFIX ."tmnt_rules` (`id`, `rules`) VALUES
(1, 'Your Rules Here')");
Reply With Quote
  #827  
Old 10-17-2008, 07:45 PM
powerbook's Avatar
powerbook powerbook is offline
 
Join Date: Jul 2006
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

There is a DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players; after it creates it in the xml...

Quote:
Originally Posted by powerbook View Post
I had a install...Run the errorfix checked DB removed tables then run install..
Reply With Quote
  #828  
Old 10-17-2008, 07:45 PM
bananalive bananalive is offline
 
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by powerbook View Post
I had a install...Run the errorfix checked DB removed tables then run install..
The product-errorfix.xml has code (see below) to remove ladder players data tables so you should not get multiple column error.
PHP Code:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS "
TABLE_PREFIX ."tmnt_ladder_players;
"
); 
Reply With Quote
  #829  
Old 10-17-2008, 07:47 PM
bananalive bananalive is offline
 
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by powerbook View Post
There is a DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players; after it creates it in the xml...
it is enclosed in <uninstallcode> tags so it only execs the query on uninstall of product.
Reply With Quote
  #830  
Old 10-17-2008, 07:56 PM
powerbook's Avatar
powerbook powerbook is offline
 
Join Date: Jul 2006
Posts: 132
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

From product-tournament2008.xml

Line 236:
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (


LINE 256:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");


Quote:
Originally Posted by bananalive View Post
it is enclosed in <uninstallcode> tags so it only execs the query on uninstall of product.
Reply With Quote
  #831  
Old 10-17-2008, 08:07 PM
bananalive bananalive is offline
 
Join Date: Oct 2007
Location: UK
Posts: 2,802
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by powerbook View Post
From product-tournament2008.xml

Line 236:
$vbulletin->db->query_write("
CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (


LINE 256:
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
Everything in installcode execs on product install and everything in uninstall execs on product uninstall
Code:
<code version="2.4.2.1">
			<installcode><![CDATA[
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladders` (
  `id` int(11) NOT NULL auto_increment,
  `title` varchar(50) NOT NULL,
  `description` text NOT NULL,
  `noplayers` int(3) NOT NULL,
  `status` int(3) NOT NULL,
  `cr_userid` int(10) NOT NULL,
  `cr_username` varchar(100) NOT NULL,
  `cr_time` int(10) NOT NULL,
  `cr_ip` varchar(100) NOT NULL,
  `ed_userid` int(10) NOT NULL,
  `ed_username` varchar(100) NOT NULL,
  `ed_time` int(10) NOT NULL,
  `ed_ip` varchar(50) NOT NULL,
  `threadid` int(10) NOT NULL,
  `views` int(10) NOT NULL default '0',
  `winpoints` int(10) NOT NULL default '2',
  `drawpoints` int(10) NOT NULL default '1',
  `losepoints` int(10) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_games` (
  `id` int(11) NOT NULL auto_increment,
  `u` int(10) NOT NULL,
  `u2` int(10) NOT NULL,
  `time` int(10) NOT NULL,
  `accepted` int(10) NOT NULL,
  `lid` int(11) NOT NULL,
  `score_u` int(20) NOT NULL,
  `score_u2` int(20) NOT NULL,
  `agree_u` int(10) NOT NULL,
  `agree_u2` int(10) NOT NULL,
  `finished` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
$vbulletin->db->query_write("
  CREATE TABLE IF NOT EXISTS `". TABLE_PREFIX ."tmnt_ladder_players` (
  `id` int(11) NOT NULL auto_increment,
  `userid` int(10) NOT NULL,
  `username` varchar(100) NOT NULL,
  `lid` int(11) NOT NULL,
  `time` int(10) NOT NULL,
  `ip` varchar(100) NOT NULL,
  `wins` int(10) NOT NULL,
  `draws` int(10) NOT NULL,
  `loses` int(10) NOT NULL,
  `challenges` int(10) NOT NULL,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM");
]]></installcode>
			<uninstallcode><![CDATA[
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladders;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_games;
");
$vbulletin->db->query_write("
DROP TABLE IF EXISTS ". TABLE_PREFIX ."tmnt_ladder_players;
");
$vbulletin->db->query_write("ALTER TABLE ". TABLE_PREFIX ."usergroup DROP COLUMN ladderpermissions;");
]]></uninstallcode>
		</code>
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 10:40 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.07111 seconds
  • Memory Usage 2,381KB
  • Queries Executed 26 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (4)bbcode_code
  • (1)bbcode_php
  • (9)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (4)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (11)post_thanks_box
  • (11)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (11)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_attachment
  • (11)postbit_onlinestatus
  • (11)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete