Major Additions - 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.

[schlottkej]

Originally Posted by Jaxel

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

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?

[schlottkej]

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

[DobieGillis?]

Originally Posted by schlottkej

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?

[HoLyMeN]

Originally Posted by Jaxel

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

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

thanks :up:

[Jaxel]

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

[Jaxel]

Originally Posted by DobieGillis?

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?

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.

[Jaxel]

Originally Posted by schlottkej

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 dont understand this error... The code is...

SELECT * FROM rank_events AS rank_events
LEFT JOIN rank_games AS rank_games USING(gameID)
LEFT JOIN rank_categories AS rank_categories USING(categoryID)
ORDER BY eDate DESC
LIMIT 0, 30;

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:

	$result = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."rank_events AS rank_events
		LEFT JOIN ".TABLE_PREFIX."rank_games AS rank_games USING(gameID)
		LEFT JOIN ".TABLE_PREFIX."rank_categories AS rank_categories USING(categoryID)
		ORDER BY $sort $order
		LIMIT ".($limitlower - 1).", $perpage
	");

with...

	$result = $vbulletin->db->query_read("SELECT * FROM ".TABLE_PREFIX."rank_events AS rank_events
		LEFT JOIN ".TABLE_PREFIX."rank_games AS rank_games ON rank_events.gameID = rank_games.gameID
		LEFT JOIN ".TABLE_PREFIX."rank_categories AS rank_categories ON rank_events.categoryID = rank_category.categoryID
		ORDER BY $sort $order
		LIMIT ".($limitlower - 1).", $perpage
	");

[Jaxel]

================================================== =========
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
    

[HoLyMeN]

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

[Jaxel]

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