TIO/FTL Compatible Ranking Ladder System LITE

[Jaxel]

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 (http://allisbrawl.com/tio/) files.
Ability to automatically generate brackets based on TIO (http://allisbrawl.com/tio/) files.
Ability to parse data instantly and directly from Forum Tournaments & Ladders (https://vborg.vbsupport.ru/showthread.php?t=189375).
Ability to automatically generate brackets based on Forum Tournaments & Ladders (https://vborg.vbsupport.ru/showthread.php?t=189375).
Ability to embed brackets directly into posts with IDInstallation Procedure:
Upload all files in the "upload" directory to your forum root.
CHMOD /ranking/events and /ranking/games to 777.
Import the product "product-rankingladder.xml" in your Product Manager.
OPTIONAL: Import the VBAdvanced RankLad module into your VBAdvanced Pages.Upgrade Procedure:
Upload all files in the "upload" directory to your forum root.
Take note of the information stored in Ranking Award Values of Ranking Ladder Settings.
Import the product "product-rankingladder.xml" in your Product Manager.
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]

================================================== =========
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=viewdetails&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 (https://vborg.vbsupport.ru/showthread.php?t=189375).

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

[EWGF]

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:

[Sugoi na]

Great looking mod. keep up the good work.

[DobieGillis?]

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

[Ranger375]

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?

[Jasem]

good job man, thank you!

Installed

[Sugoi na]

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?

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.

[Ranger375]

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

[Jaxel]

Edit: Only US timezones? :confused: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?

installed but getting this error when trying to create a new eventFixed in new release. Try it again and tell me if you still get the error.

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?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.

InstalledPlease click the "Mark as Installed" link.

[DobieGillis?]

right o

[DobieGillis?]

works perfectly, thanks!

[wastemytime]

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

Fatal error: Call to undefined function: date_default_timezone_set() in

[Jaxel]

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

[wastemytime]

http://us.php.net/date_default_timezone_set

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.

[wastemytime]

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

Fatal error: Call to undefined function: set_default_timezone()

[DobieGillis?]

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.

[Jaxel]

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

Fatal error: Call to undefined function: set_default_timezone()
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.

[HoLyMeN]

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

how fix this??

[schlottkej]

SQL error

http://www.thewrestlingtalk.com/ranking.php?do=categories

[schlottkej]

http://www.ps3multiplayer.com/ranking.php


how fix this??

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

[HoLyMeN]

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

ok and how fix that please

[schlottkej]

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

[HoLyMeN]

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

[HoLyMeN]

jaxel please answer ......

[Jaxel]

http://www.ps3multiplayer.com/ranking.php


how fix this??
This mod must be installed in your FORUM ROOT...

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

[Jaxel]

SQL error

http://www.thewrestlingtalk.com/ranking.php?do=categories

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

[SocialNetworkBuzz]

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.

[Jaxel]

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.

[schlottkej]

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?

[schlottkej]

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?]

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]

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]

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]

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 (https://vborg.vbsupport.ru/showthread.php?t=189375).

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/ranking.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

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

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

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

[Jaxel]

Hmm... okay, I just uploaded version 1.3.1... please try it out and tell me if it works...

I dunno, the version of MySQL I have on my server doesnt give problems for these issues.

[EWGF]

It worked :)

But I have noticed another problem, when I choose any rebuilt-option; it rebuilds and keeps refreshing the page infinitely

[Jaxel]

It worked :)

But I have noticed another problem, when I choose any rebuilt-option; it rebuilds and keeps refreshing the page infinitely
put at least 1 player, in 1 event into your system... and tell me if it still does that. I think its a simple divide by 0 error since you dont have any events or players in yet.

[EWGF]

I have set 2 events with both 4 players. Keeps hanging on:

ranking.php?do=rebuild_events&count=3
ranking.php?do=rebuild_players&count=5

[Jaxel]

can you send me a link?

[EWGF]

Needs login, so i'll pm a needed pass

Edit: Can you also check the ranking.php?do=players page, while you're at it? It says 3 members share the second place, although they don't have the same amount of points

[Jaxel]

Okay EWGF, I just tested it on your website (you sent me an admin account)... and it doesn't infinite loop for me...

[Jaxel]

Needs login, so i'll pm a needed pass


Edit: Can you also check the ranking.php?do=players page, while you're at it? It says 3 members share the second place, although they don't have the same amount of points
It said that because you didn't rebuild the ranks yet; thats why you need to rebuild ranks immediately after rebuilding players.

I just rebuild events > rebuild players > rebuild ranks on your website and didnt get any infinite loops.

[Jaxel]

tommorow's new version will include... PROFILE BLOCKS!

preview: http://www.8wayrun.com/member.php?u=316

[EWGF]

Strangely enough I get that infinite loop on other computers too :confused:

@ profile blocks: NICE!

[Jaxel]

Are you sure its infinite looping? Its supposed to refresh a few times as it calculates.

[EWGF]

I'm sure about it, after 15 minutes it was still refreshing the page while the text "All events have been successfully rebuilt" was displayed

[TheLastSuperman]

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.

GREAT to hear! Downloaded only but marking as installed since I'll be using this for something else but need time to tweak it ;)

Also it seems your busy but when you have a free moment can you look into my post regarding your video directory? Found here --> https://vborg.vbsupport.ru/showthread.php?t=200819&page=42 becuase that could save me some frustration ;)

Thanks for these great mods imo... I love em' :D

S-MAN

[Jaxel]

EWGF... try the attached file... if it works for you, I'll include it in today's build.

Superman... I answered that question in a previous post, I'm not answering it again.

[EWGF]

Yes sir, it worked! :D

[EWGF]

If you have added a player which isn't registered and his ranking account is reasonably filled. If that person later decides to register on the forum, it's just a matter of editing the ranking account by adding his vB-id number?

[Jaxel]

If you have added a player which isn't registered and his ranking account is reasonably filled. If that person later decides to register on the forum, it's just a matter of editing the ranking account by adding his vB-id number?
Yep. I made sure you could do that.

[TheLastSuperman]

EWGF... try the attached file... if it works for you, I'll include it in today's build.

Superman... I answered that question in a previous post, I'm not answering it again.

Sorry bud, simply did not see the info and I did read through the posts - 41+ pages so forgive the overlook but I did not see it... little more tact next time though, a link eh or a simple reply.. anything other than just ignoring the questions presented leaving us to wonder :D *sigh, now let's go read all the posts again for another 30 mins to an hour when like I said, you could have saved some time as you know this whereas I do not.

[EWGF]

I noticed tournaments played in 2007 can't be added. Why's that?

It would give people a more complete view of one's accomplishments. Especially for oldskool players who rarely play anymore.

[Jaxel]

I noticed tournaments played in 2007 can't be added. Why's that?

It would give people a more complete view of one's accomplishments. Especially for oldskool players who rarely play anymore.
You can edit the template and add 2007 in if you want, but I didn't see the point

The default settings are that a player is ranked by their best 10 scores in the course of 12 months. 2007 is outside that spectrum; so I didn't see the need to include it.

[Jaxel]

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

[EWGF]

You can edit the template and add 2007 in if you want, but I didn't see the point.
How do I edit $selectYEA?
Edit: file edit did the job.


1.4 working nicely here



Edit2: Another question to bug you with: why do numbers 6-10 get even points? In brackets you mostly end somewhere with 8 players, meaning 2 players advanced less but get equal points here

[Jaxel]

Our tournaments usually get 16+, so 6-10 get more points that 11+...

If you wish, you can easily set it so that 6-10 dont get points.

[Jaxel]

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

[EWGF]

Next question: I've edited functions_rank to change (for example) 1st to 1e; to match it with my own language. But I have noticed those changes aren't applied to the postbit. How can this be done?

[Jaxel]

Next question: I've edited functions_rank to change (for example) 1st to 1e; to match it with my own language. But I have noticed those changes aren't applied to the postbit. How can this be done?
Rebuild your ranks. While the ranking system runs the fetch_ordinal everytime, the postbit doesnt, as it would add too much overhead to the server. I did this so that it doesnt affect performance.

[EWGF]

Invalid SQL:
SELECT COUNT(eventID) AS count FROM vbrank_events
LEFT JOIN vbrank_categories AS rank_categories ON rank_events.categoryID = rank_categories.categoryID
WHERE rank_categories.categoryID = 1;

MySQL Error : Unknown column 'rank_events.categoryID' in 'on clause'

Script: /forum/ranking.php?do=category&cid=1

Is this a bug that rarely shows up or a crappy error on the server?

[AzzidReign]

Where do you purchase the PRO version and for how much? I tried searching the thread and couldn't find anything.

Nevermind, found it at the bottom of the original post...not sure how I didn't see it last time:
For more information on how to purchase the PRO version ($100), feel free to send me a message.
The PRO version makes this mod easier to manage by integrating this mod directly with your TIO files.

[Jaxel]

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

[Jaxel]

Hey, I'm curious how people are using this mod at all... Would anyone mind sending me links showing examples of how they are using this system?

[EWGF]

I'm still using it, but didn't really check vb.org the last couple of weeks ^^"

About your question, you mean like modding certain things?

[EWGF]

Are you planning any exciting new features? :)

[Jaxel]

Maybe some round robin stuff.

[Jaxel]

Okay... upcoming soon...

ATTENDANCE CHARTS...
http://www.8wayrun.com/ranking.php?do=category&cid=1

[john102774]

I love the GUI and the concept. I own a tennis board, my main problem would be scoring. Before I actually install I'm curious as to how my members can submit their score as such, 6-4 2-6 7-5 for 2 out of three set and possibly for 3 out of 5 sets (6-1 3-6 6-4 5-7 6-0) as well, on the ladder result and the bracket result.

Would this be possible?

If so, then I would like to purchase your PRO version.

Thanks

[Jaxel]

upcoming soon...

ROUND ROBIN SUPPORT!
Single Pool: http://www.8wayrun.com/ranking.php?do=event&eid=116
Multi Pool: http://www.8wayrun.com/ranking.php?do=event&eid=119

John, this mod is not for the RUNNING of tournaments... this mod is the for CALCULATIONS of event results into a ladder.

This mod is compatible with both TIO (http://allisbrawl.com/tio) and FTL (https://vborg.vbsupport.ru/showthread.php?t=189375), you can use those to run tournaments.

[Jaxel]

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

[EWGF]

Aw, pro got Round Robin support :'(

[Covert-OPs_]

I have the Forum Tournament & Ladders mod but currently I have it disabled because I needed something more in-depth. Does this add on work in conjunction with that mod? If so can someone link me to the additional features it grants you?(Pro version)

[Jaxel]

This mod is a RANKING SYSTEM... not a mod for the RUNNING of tournaments. This mod is used to calculate the RESULTS of a tournament that has already been done. Using the pro version, you can parse the results of a tournament run using the Forum Tournament & Ladders mod.

[Covert-OPs_]

This mod is a RANKING SYSTEM... not a mod for the RUNNING of tournaments. This mod is used to calculate the RESULTS of a tournament that has already been done. Using the pro version, you can parse the results of a tournament run using the Forum Tournament & Ladders mod.
Ok but what is the support for a round robin? As far as I know the current Tournament & Ladder mod does not have a round robin setup. Unless I have the wrong mod.

[Jaxel]

EWGF... you will like this new feature coming in the next version (will be available in the FREE version)

http://www.8wayrun.com/video.php?do=viewdetails&videoid=1045

[EWGF]

ZOMG, ajax + character statistics! =D

[Jaxel]

Yet another new feature... http://www.8wayrun.com/ranking.php?do=players&gid=1

GAME BASED RANKINGS!

Now, in addition to the global rankings that are already in, you can now have different rankings based on the GAMES (http://www.8wayrun.com/ranking.php?do=games) in your ladder.

[Jaxel]

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

[Adem GEN?]

Hello,
Error Unistalling
Altering Table user ...vB_Database_Alter: fetch_table_info() has not been called successfully.

I know how to uninstall this product?

[cowcowcow]

This looks so good, its a pity i missed it all these years!

Is it still working? Both demo sites are down. Also, how can i get the pro version?