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.

[Jaxel]

Hmm... this new version created some new errors... give me a moment, as I am fixing them.

[Jaxel]

Okay... all errors should be fixed now.

[Jaxel]

By request from HoLyMeN... Ranks are now listed in the postbit!

================================================== =========
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.
    
• More small and minor MYSQL warnings; they should all be gone now!
• 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
    

[EWGF]

Originally Posted by Jaxel

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?

Ah okay, Europe/Amsterdam will be enough then.

[EWGF]

How can I add categories and games? I think the lack of it is preventing me from uploading an xml

And I saw something about recounting stuff. Can't find anything about it... Almost as if I'm missing a lot of files, yet they're all uploaded

[Jaxel]

EWGF, define an admin group in your user settings... you will see new options on the ladder then.

[EWGF]

Thanks, overlooked that :P

[EWGF]

Adding players to a tournament gives this error:

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT *, COUNT(playerID) as count FROM rank_events AS rank_events
		LEFT JOIN rank_categories AS rank_categories USING(categoryID)
		LEFT JOIN rank_scores AS rank_scores USING(eventID)
		WHERE rank_events.eventID = '1';

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140
Request Date  : Sunday, March 22nd 2009 @ 01:13:31 AM
Error Date    : Sunday, March 22nd 2009 @ 01:13:31 AM
Script        : http://*/forum/ranking.php?do=event&eid=1
Referrer      : http://*/forum/ranking.php?do=event&eid=1
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.45-Debian_1ubuntu3.3-log

XML uploading btw still gives me error, lol lite version

[Jaxel]

EWGF, please download the new version... I replaced all USING JOINS with ON JOINS...

People with older versions of MYSQL were having problems with USING JOINS.

[EWGF]

The error persists.

Database error in vBulletin 3.8.1:

Invalid SQL:
SELECT *, COUNT(playerID) as count FROM rank_events AS rank_events
		LEFT JOIN rank_categories AS rank_categories USING(categoryID)
		LEFT JOIN rank_scores AS rank_scores USING(eventID)
		WHERE rank_events.eventID = '1';

MySQL Error   : Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
Error Number  : 1140
Request Date  : Sunday, March 22nd 2009 @ 01:24:19 AM
Error Date    : Sunday, March 22nd 2009 @ 01:24:19 AM
Script        : http://*/forum/ranking.php?do=event&eid=1
Referrer      : http://*/forum/ranking.php?do=event&eid=1
IP Address    : 
Username      : 
Classname     : vB_Database
MySQL Version : 5.0.45-Debian_1ubuntu3.3-log