The Arcive of Official vBulletin Modifications Site.

Forum Tournaments & Ladders · **Released**: 08-27-2008

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

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'

Translations:

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

powerbook · #**832** 10-17-2008, 08:10 PM

Sorry only realized that after I posted..

Quote:

Originally Posted by bananalive

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>

conker1 · #**833** 10-17-2008, 08:10 PM

Quote:

Originally Posted by bananalive

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')");

i did, new error message

Code:

Database error in vBulletin 3.7.3:

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

MySQL Error   : Duplicate column name 'tmnt_joins'
Error Number  : 1060

and thanks for reply

RK1gaming · #**834** 10-17-2008, 08:58 PM

never mind brain cramp

fernas · #**835** 10-18-2008, 05:01 AM

My suggestions:

- Teams for ladders.
- vbAdvanced modules for newest teams and recent matches.

Tnis hack is great!!

Antek · #**836** 10-18-2008, 09:33 AM

I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error   : Table 'xxx.vb_tmnt_rules' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 18th 2008 @ 12:36:58 PM
Error Date    : Saturday, October 18th 2008 @ 12:36:58 PM
Script        : http://xxx/tournament.php?do=rules
Referrer      : http://xxx/tournament.php?do=view&id=8
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.37-standard

bananalive · #**837** 10-18-2008, 10:03 AM

Quote:

Originally Posted by Antek

I've got problem as below:

After click on 'Rules' ina navbar ( http://xxx/tournament.php?do=rules)

I take this error:

Code:

Database error in vBulletin 3.7.3:

Invalid SQL:
SELECT * FROM vb_tmnt_rules;

MySQL Error   : Table 'xxx.vb_tmnt_rules' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 18th 2008 @ 12:36:58 PM
Error Date    : Saturday, October 18th 2008 @ 12:36:58 PM
Script        : http://xxx/tournament.php?do=rules
Referrer      : http://xxx/tournament.php?do=view&id=8
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.37-standard

have you tried the rules fix here

bananalive · #**838** 10-18-2008, 10:08 AM

Quote:

Originally Posted by conker1

i did, new error message

Code:

Database error in vBulletin 3.7.3:

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

MySQL Error   : Duplicate column name 'tmnt_joins'
Error Number  : 1060

and thanks for reply

Re-import Attachment 88261 (this is modified version just for you) and then try installing product-tournament2008.xml

Antek · #**839** 10-18-2008, 04:15 PM

bananalive, still doesn't work

After patched I get error here: http://xxx/tournament.php

Code:

Database error in vBulletin 3.7.3:

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

MySQL Error   : Table 'xxx.vb_tmnt_announcements' doesn't exist
Error Number  : 1146
Request Date  : Saturday, October 18th 2008 @ 07:18:31 PM
Error Date    : Saturday, October 18th 2008 @ 07:18:32 PM
Script        : http://xxx/tournament.php
Referrer      : xxx/
IP Address    : xxx
Username      : xxx
Classname     : vB_Database
MySQL Version : 5.0.37-standard

bananalive · #**840** 10-18-2008, 04:43 PM

Quote:

Originally Posted by Antek

bananalive, still doesn't work

After patched I get error here: http://xxx/tournament.php

You are missing table which means you need to reinstall product.

Antek · #**841** 10-18-2008, 06:23 PM

Ops

It's working now

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07336 seconds Memory Usage 2,378KB 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 (7)bbcode_code (5)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
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!