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