Does anyone know how to add ladder's to a server

Open the ladders.txt file in the server directory.
the format should be
Code: 
LADDER:*LADDERNAME* (w/o *s)
*Banlist A - Z*

There is a code to paste into your shoddy server's MySQL database, however I cannot Copy/Paste (broken!) so unfortunately I cannot give that to you.
 
Sorry about the second post. I got fed up with windows 7, and switched over to Linux (again). I have to code.

Code: 
CREATE TABLE `ladder3` ( 
  `player0` varchar(255) NOT NULL,
 `player1` varchar(255) NOT NULL,
 `victor` int(10) unsigned default NULL,
 KEY `player0` (`player0`),
 KEY `player1` (`player1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
ALTER TABLE users ADD rating3 DOUBLE; ALTER TABLE users ADD deviation3 DOUBLE; ALTER TABLE users ADD volatility3 DOUBLE; ALTER TABLE users ADD estimate3 DOUBLE; ALTER TABLE users ADD updated_rating3 DOUBLE; ALTER TABLE users ADD updated_deviation3 DOUBLE; ALTER TABLE users ADD updated_volatility3 DOUBLE;


Just drop into MySQL.


Note: From when I've used that, all users created before using that will be non-effected. They will have the ladder on their record, the rating remains 0, and cannot change. I do not know the solution to this, though.
 
Duck92 said:
Sorry about the second post. I got fed up with windows 7, and switched over to Linux (again). I have to code.

Code: 
CREATE TABLE `ladder3` ( 
  `player0` varchar(255) NOT NULL,
 `player1` varchar(255) NOT NULL,
 `victor` int(10) unsigned default NULL,
 KEY `player0` (`player0`),
 KEY `player1` (`player1`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
ALTER TABLE users ADD rating3 DOUBLE; ALTER TABLE users ADD deviation3 DOUBLE; ALTER TABLE users ADD volatility3 DOUBLE; ALTER TABLE users ADD estimate3 DOUBLE; ALTER TABLE users ADD updated_rating3 DOUBLE; ALTER TABLE users ADD updated_deviation3 DOUBLE; ALTER TABLE users ADD updated_volatility3 DOUBLE;
Just drop into MySQL.


Note: From when I've used that, all users created before using that will be non-effected. They will have the ladder on their record, the rating remains 0, and cannot change. I do not know the solution to this, though.
Click to expand...

Just run a mySQL query to populate the rows with their default values. Not too difficult.
 
You must log in or register to reply here.
Back
Top