TIO/FTL Compatible Ranking Ladder System LITE
 

This ranking system is based very loosely on the Association of Tennis Professionals ATP Entry Ranking System (as apposed to their ATP Race System). What this means, is that players are ranked by the total scores of their best performances within a specified time period. Using this system solves many problems within other ranking systems; especially race systems that tend to give preference to players who attend the most tournament events. This system ensures a more accurate calculation on the relative performances of players.

With this system, a player's rank is calculated using their best scores within a specified time period. Stronger players are not penalized because they had a "bad day", and weaker players are not rewarded by attending the most events. By specifying best scores limit, a player's weakest performances will be ignored in the ranking calculations (provided that player attends enough tournaments to exceed the limit). By specifying a time period, the system will automatically weed out stale rankings and remove players who are no longer active.

What is this mod?

Using this system, you can put together a fully featured ranking system for your tournaments. The purpose of this system is to give users a method to calculate rankings for all manner of events, even events that exist outside the spectrum of your forums. Because of this, this mod does NOT integrate with your forum user database; if it did, people who attended your event, but are not members of your forum, would be left out and it would skew the point values for events.

Product Demo:

http://www.8wayrun.com/ranking.php
http://www.thebreak.net/tekken/

Basic LITE Feature Listing:

• Fully integrated into the product manager with built in plugins.
• Fully phrased and built on templates for easy reskinning and styling.
• Fully administratable and a myriad of settings for personalization.
• Submission form for users to submit their tournaments for addition.
• Ability to define specific point modifier values for categories.
• Ability to define tournaments to specific categories and games.
• Keeps a paginated history of past tournaments and their values.
• Each event has full listings of attendance and earned player scores.
• Ability to upload images for each event, such as bracketted results.
• Keeps a paginated list of all players, their scores and their ranks.
• Each player has a full listing of attendance history and scores.
• Ability to link a player on the ladder to their vbulletin profile.

Advanced PRO Feature Listing:

• Ability to parse data instantly and directly from TIO files.
• Ability to automatically generate brackets based on TIO files.
• Ability to parse data instantly and directly from Forum Tournaments & Ladders.
• Ability to automatically generate brackets based on Forum Tournaments & Ladders.
• Ability to embed brackets directly into posts with [bracket]ID[/bracket]

Installation Procedure:

1. Upload all files in the "upload" directory to your forum root.
2. CHMOD /ranking/events and /ranking/games to 777.
3. Import the product "product-rankingladder.xml" in your Product Manager.
4. OPTIONAL: Import the VBAdvanced RankLad module into your VBAdvanced Pages.

Upgrade Procedure:

1. Upload all files in the "upload" directory to your forum root.
2. Take note of the information stored in Ranking Award Values of Ranking Ladder Settings.
3. Import the product "product-rankingladder.xml" in your Product Manager.
4. Re-establish your previous Ranking Award Values settings in Ranking Ladder Settings.

NOTES:

• Before you can add any event listings, you must have both a category, and a game to assign it to.
• Before you can add any scores for an event, each player in your event must have a Ladder-ID (INT).
• When adding scores to an event, you need to input their earned rank (INT), and their Ladder-ID (INT).
• If you are using the PRO version, you should put a player's Ladder-ID as their "Name" field in TIO. Then use the "Edit Existing Event" link and use the "Upload Scores from TIO" form. If you properly added all of your player's Ladder-IDs in your TIO file, the script will automatically add all scores to the event with a single click.
• If you are using the PRO version, you can automatically generate bracketted results based on the event.
• You should only need to use the "Rebuild All Events" function if your change the modifier values for your categories or awards; then you will need to rebuild all events to recalculate the scores for events.
• In order to recalculate scores for player, you will need to run the "Rebuild All Players" function; I do it once a week.
• Immediately after running "Rebuild All Players", you should also run "Rebuild All Rankings" to calculate ladder positions.

Don't forget to click INSTALL!

For more information on how to purchase the PRO version, feel free to send me a message.

================================================== =========
Version 2.0.0
================================================== =========

• Added the ability to put the sidebar on the left or the right.
• Added a vbAdvanced Events module that automatically parses for events.
• Added a moderation permission setting for AJAX editing and scripting.
• Added a system so players can easily edit their character usage settings.
  
  • VIDEO: http://www.8wayrun.com/video.php?do=...s&videoid=1045
    
  • Each game in your ladder must have a folder in /usage/ with it's TAG
    
  • Characters are validated by the existance of images in /usage/TAG/
    
  • For example, I have included several character usage images.
    
  • This feature must be turned on in your admin control panel first!
    
• Adding a new event will now return to the edit page of that specific event.
• Slightly changed the editing of events so that it returns to the edit page.
• The top 1/3 of unranked players will now earn double points for ranking.
• Changed the way scores are rebuilt to include a new multi-game ladder system.
• There are now multiple ladders, as well as the previous GLOBAL LADDER.
  
  • Each game will get it's own ladder, which must be updated seperately.
    
• GAME and CATEGORY pages are now gone and have merged into EVENTS listings.
• Many template names have been changed to fit this new system. Please revert!
• Redid the Event Submission page to be easier to read and less oppressive.
• BUG FIX: Fixed erroneous hypertext errors in vbAdvanced Players module.
• FILE EDITS SINCE 1.8.0: (make sure you upload these new versions!)
  
  • vbacmps_ranklad.xml
    
  • vbacmps_rankvnt.xml
    
  • upload/includes/xml/bitfield_rankingladder.xml
    
  • upload/ranking/usage/**
    
  • upload/ranking/functions_rank.php
    
  • upload/ranking/instantedit.js
    
  • upload/ranking.php
    
  • upload/rankingAJAX.php
    
• TEMPLATE EDITS SINCE 1.8.0: (make sure you revert these templates!)
  
  • rankings_categories_add
    
  • rankings_categories_bit
    
  • rankings_categories_edit
    
  • rankings_event
    
  • rankings_event_bit
    
  • rankings_events
    
  • rankings_events_add
    
  • rankings_events_bit
    
  • rankings_games_add
    
  • rankings_games_bit
    
  • rankings_games_edit
    
  • rankings_player
    
  • rankings_player_bit
    
  • rankings_players
    
  • rankings_players_add
    
  • rankings_players_bit
    
  • rankings_postbit
    
  • rankings_profile
    
  • rankings_scores_merge
    
  • rankings_SHELL
    
  • rankings_SHELL_bit
    
  • rankings_SHELL_nav
    
  • rankings_submit
    

================================================== =========
Version 1.8.0
================================================== =========

• YOU WILL NEED TO RESET YOUR USERGROUP PERMISSIONS WITH THIS VERSION
  
  • Fixed erroneous permission errors.
    
• Cleaned up the SHELL design and added new PNG formatted ranking images!
• Added an function to automatically check and update for username changes.
• Added attendance history BAR CHARTS for events/categories/games pages.
• Altered the bracket javascript code to limit the area of empty white space.
• PRO VERSION: Added support for TIO ROUND ROBIN POOLS (single AND multi).
• BUG FIX: Fixed the error with improper game callups on games summary page.
• FILE EDITS SINCE 1.6.0: (make sure you upload these new versions!)
  
  • vbacmps_ranklad.xml
    
  • upload/includes/xml/bitfield_rankingladder.xml
    
  • upload/ranking.php
    
  • upload/ranking/+.png
    
  • upload/ranking/-.png
    
  • upload/ranking/=.png
    
  • upload/ranking/functions_rank.php
    
  • upload/ranking/functions_rank_pro.php
    
• TEMPLATE EDITS SINCE 1.6.0: (make sure you revert these templates!)
  
  • rankings_bbcode
    
  • rankings_bracket_rrb
    
  • rankings_bracket_rrb_letter
    
  • rankings_bracket_rrb_player
    
  • rankings_bracket_rrb_pool
    
  • rankings_bracket_rrb_score
    
  • rankings_category
    
  • rankings_event
    
  • rankings_events
    
  • rankings_events_bar
    
  • rankings_game
    
  • rankings_player
    
  • rankings_players_bit
    
  • rankings_postbit
    
  • rankings_SHELL
    

================================================== =========
Version 1.6.0
================================================== =========

• Added a MERGE PLAYERS function so you can now merge linked events.
  
  • Event history of source player will be merged into destination player.
    
  • If duplicate event scores exist, the destination's score will be retained.
    
• Added the ability to SEARCH for Players by Names, Regions and Teams.
• Added the ability to SEARCH for Events by Names, Organizers and Venues.
• Renamed some phrases in the system for administrative functions.
• BUG FIX: Fixed bug where category browsing for those with table prefixes.
• FILE EDITS SINCE 1.5.0: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
  • upload/ranking/functions_rank.php
    
• TEMPLATE EDITS SINCE 1.5.0: (make sure you revert these templates!)
  
  • rankings_category_add
    
  • rankings_events
    
  • rankings_event_add
    
  • rankings_game_add
    
  • rankings_players
    
  • rankings_players_bit
    
  • rankings_player
    
  • rankings_player_add
    
  • rankings_postbit
    
  • rankings_scores_merge
    
  • rankings_SHELL
    

================================================== =========
Version 1.5.0
================================================== =========

• Changes made to the PRO functions to be compatible with the new version of TIO.
• Changed the copyright and license notice to make it less obstrusive.
• Added seperate bracket icons for bracket images and bracket TIO-XML files.
• Added ladder-ids in event result and player listings for reference.
• Event scores are no longer rebuilt when you edit the details for the event.
  
  • This fixes a MYSQL error for updating details for events with no scores.
    
  • If you change the event category, you will need to "Rebuild All Events".
    
• FILE EDITS SINCE 1.4.0: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
  • upload/ranking/functions_rank.php
    
  • upload/ranking/functions_rank_pro.php
    
• TEMPLATE EDITS SINCE 1.4.0: (make sure you revert these templates!)
  
  • rankings_category
    
  • rankings_category_bit
    
  • rankings_event
    
  • rankings_events
    
  • rankings_events_bit
    
  • rankings_event_bit
    
  • rankings_game
    
  • rankings_game_bit
    
  • rankings_players
    
  • rankings_players_bit
    
  • rankings_submit
    
  • rankings_SHELL
    

================================================== =========
Version 1.4.0
================================================== =========

• Added support for displaying a user's linked rank within the profile blocks.
  
  • The profile block lists a player's top 10 ranked performances in order.
    
• Fixed broken profile link in the postbit and the postbit plugin.
• Fixed infinite loop problems while rebuilding event, player and rank data.
• FILE EDITS SINCE 1.3.0: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
• TEMPLATE EDITS SINCE 1.3.0: (make sure you revert these templates!)
  
  • rankings_postbit
    
  • rankings_profile
    
  • rankings_profile_bit
    

================================================== =========
Version 1.3.0
================================================== =========

• Added support for displaying a user's linked rank within the postbit.
  
  • Linked ranks are controlled by the pExt (Forum ID) value of a player.
    
  • Linked ranks are updated during the existing "rebuild ranks" function.
    
• Replaced all instances of JOIN USING with JOIN ON in all files.
• This fixes the many MySQL join errors with older versions of MySQL.
• FILE EDITS SINCE 1.2.0: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
  • upload/ranking/functions_rank.php
    
  • upload/ranking/functions_rank_pro.php
    

================================================== =========
Version 1.2.0
================================================== =========

• Added better support for bracket viewing and tournament SPLITS.
• Fixed several functional and template design issues.
• Added Full PRO Version Support for Forum Tournamnets & Ladders.
  
  • You can now add results for FTL tournaments easily with the PRO version.
    
  • You can now add brackets for FTL tournaments easily with the PRO version.
    
• FILE EDITS SINCE 1.1.1: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
  • upload/ranking/functions_rank_pro.php
    
• TEMPLATE EDITS SINCE 1.1.1: (make sure you revert these templates!)
  
  • rankings_event
    
  • rankings_event_bit
    
  • rankings_event_edit
    
  • rankings_event_edit_pro
    
  • rankings_event_edit_bit
    
  • rankings_event_edit_brack
    
  • rankings_player_bit
    

================================================== =========
Version 1.1.0
================================================== =========

• Fixed ambiguity problems with Categories and Game Selection
• Fixed TABLE_PREFIX problems with Categories and Game Selection

================================================== =========
Version 1.0.0
================================================== =========

• First Public Release of TIO Compatibile Ranking Ladder System

Looks way more appealing than the ladders&tournaments mod!

I have many people on tournaments that aren't registered on my site, thus great solution.



Edit: Only US timezones? :confused:

Great looking mod. keep up the good work.

installed but getting this error when trying to create a new event

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT rank_games.* FROM rank_games WHERE gActive = 1;

MySQL Error : Table 'universe.rank_games' doesn't exist
Error Number : 1146
Request Date : Wednesday, March 18th 2009 @ 11:56:14 AM
Error Date : Wednesday, March 18th 2009 @ 11:56:14 AM
Script : http://www.cooluniverse.net/ranking.php?do=add_event
Referrer : http://www.cooluniverse.net/ranking.php?do=games
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.0.75-log

Crazy question, is this strictly designed for use in gaming or can it be used in just about anything? For example, if I run a fitness forum, can I have people 'compete' in that way?

good job man, thank you!

Installed

It seems to me like this is very easy to edit. Worst case scenario you change the phrase from "Game" -> "your genre".

Everything else is handled through the manager.

Can't argue there, I will give it a whirl, thanks.

You can add timezones in your control panel. Only timezones found HERE: http://us.php.net/timezones will function with this mod. You cant use something like "EST", you must use "US/Eastern"; as it will automatically take daylight savings into consideration. BTW... I hate Electric Wind God Fist... but I LOVE Bloodline Rebellion. Whats your name on TZ?

Fixed in new release. Try it again and tell me if you still get the error.

This system works with ANY tournament structure for any type of event; doesn't have to be games. Doesn't even have to be single/double elimination; you can do round robin or swiss pairings as well. This system gives scores based on the OUTCOME of an event, not what happens during the event.

Please click the "Mark as Installed" link.

right o

works perfectly, thanks!

If i want to create a new Event i get this:

<a href="http://us.php.net/date_default_timezone_set" target="_blank">http://us.php.net/date_default_timezone_set</a>

date_default_timezone_set() is a function added to PHP after 5.2.0...

To fix this problem, you could replace all instances of date_default_timezone_set(###), with set_default_timezone(###) or putenv("TZ=###"); but I dont know what sort of side effects that would have. Those two older functions were depricated.

Ok, thank you. After creating a new Event - nothing happened. It just doesnt do anything.

Must wait for php5 i think...

But thanks for your hack.

Ah, no sorry, i did it wrong...had no game for the event...but still:

hi Jaxel

Thanks for joining up. I registered you on my forums at www.cooluniverse.net Trying to enter the event submission form but I do not have the right permissions, lol...I am the admin. Help! Lol! Love this mod.

try the puntenv("TZ=...") function instead, it tends to work better.

Dobie... you need to set your usergroup as an administrator in your usergroup settings.

<a href="http://www.ps3multiplayer.com/ranking.php" target="_blank">http://www.ps3multiplayer.com/ranking.php</a>

how fix this??

SQL error

http://www.thewrestlingtalk.com/rank...?do=categories

It appears the ranking.php file isn't in the base directory.

ok and how fix that please

Upload the ranking.php file to the base directory /public_html/

i need help in http://www.ps3multiplayer.com/ranking.php i have fatal eror
and in http://www.ps3multiplayer.com/ranking/ you can see the files from the rooter anybody can help m with this ore need to unistall

thanks

jaxel please answer ......

This mod must be installed in your FORUM ROOT...

which means http://www.ps3multiplayer.com/forum/ not http://www.ps3multiplayer.com/

Try this file and tell me if it works... if it does, I will add it to the main file.

Could this be intergrated to work with WoW? I run a pretty large private server and one of our realms has Arena seasons. We be great to have a ladder to update the standings daily with. All arena information is stored in a database table.

This mod is not used for the act of RUNNING tournaments. For that, you should be using TIO. This mod is used to calculate the rankings and results based on already completed events. Based on that, you can use it for ANY game.

Where is the TIO script?

This worked for most, but not http://www.thewrestlingtalk.com/ranking.php?do=events

Also- if I want to run tournaments, which script of your's will I Need? TIO? What is it and where can i find it?

I believe I found it: http://allisbrawl.com/tio/

so let me understand all this. This Mod cannot be used to create an event and I need what you linked in order to do so? Then what is the purpose of this Mod may I ask?

thanks :up:

<a href="http://www.allisbrawl.com/tio" target="_blank">www.allisbrawl.com/tio</a>

This mod is used to calculate the RESULTS of events into a ladder, not to actually run the events. You don't even have to use TIO; you can use ANY tournament running script you want. Hell, you can even run your tournaments on pen and paper. All this mod is for, is calculating the RESULTS of your tournaments after you input them. However, if you have the PRO version of this mod, you should be using TIO, as it will read the results directly from your TIO files, and GREATLY reduce the amount of work required to add a tournament to the rankings.

I dont understand this error... The code is...
The error you are getting is: Unknown column 'thematfo_forum.rank_games.categoryID' in 'on clause'

This line of code should be joining rank_events with rank_games using gameID, and then joining rank_events with rank_categories using categoryID. For some reason, the script is trying to join rank_games (instead of rank_events) with rank_categories using categoryID; which wont work. Why this is only happening on YOUR server, and no one elses... confuses me. Try replacing the following code in ranking.php:

with...

================================================== =========
Version 1.2.0
================================================== =========

• Added better support for bracket viewing and tournament SPLITS.
• Fixed several functional and template design issues.
• Added Full PRO Version Support for Forum Tournamnets & Ladders.
  
  • You can now add results for FTL tournaments easily with the PRO version.
    
  • You can now add brackets for FTL tournaments easily with the PRO version.
    
• FILE EDITS SINCE 1.1.1: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
  • upload/ranking/functions_rank_pro.php
    
• TEMPLATE EDITS SINCE 1.1.1: (make sure you revert these templates!)
  
  • rankings_event
    
  • rankings_event_bit
    
  • rankings_event_edit
    
  • rankings_event_edit_pro
    
  • rankings_event_edit_bit
    
  • rankings_event_edit_brack
    
  • rankings_player_bit
    

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT * FROM ps3multirank_events AS rank_events
LEFT JOIN ps3multirank_games AS rank_games USING(gameID)
LEFT JOIN ps3multirank_categories AS rank_categories USING(categoryID)
ORDER BY eDate DESC
LIMIT 0, 30;

MySQL Error : Unknown column 'ps3multi_ps3db.rank_games.categoryID' in 'on clause'
Error Number : 1054
Request Date : Friday, March 20th 2009 @ 03:22:16 PM
Error Date : Friday, March 20th 2009 @ 03:22:16 PM
Script : http://www.ps3multiplayer.com/forum/....php?do=events
Referrer : http://www.ps3multiplayer.com/forum/ranking.php
Classname : vb_database
MySQL Version : 4.1.22-standard-log

Try this new version please... fixes the many SQL errors.

================================================== =========
Version 1.2.1
================================================== =========

• Replaced all instances of JOIN USING with JOIN ON in all files
• This fixes the many MySQL join errors with older versions of MySQL.
• FILE EDITS SINCE 1.2.0: (make sure you upload these new versions!)
  
  • upload/ranking.php
    
  • upload/ranking/functions_rank_pro.php