Need help with my Shoddy Server

[immortalityftw]

I'd like to add a few ladders(nu,uu, and lc)

Can someone give me a tutorial on how to do that?


and how do i add a picture on the login screen?

THANKS!

 

[lJLeeRSX7]

all you have to do is add LADDER: (the tier here) in the ladders file
and all the banned pokemon under it
like this
LADDER: NU
Empoleon
Garchomp
Gyarados

 

[Duck92]

You need to query the database using the SQL block below: (Change * to the # of ladders, eg OU = 0, Uber = 1, 3rd ladder = 2, so forth).

CREATE TABLE `ladder*` ( 
  `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 rating* DOUBLE; 

ALTER TABLE users ADD deviation* DOUBLE; 

ALTER TABLE users ADD volatility* DOUBLE; 

ALTER TABLE users ADD estimate* DOUBLE; 

ALTER TABLE users ADD updated_rating* DOUBLE; 

ALTER TABLE users ADD updated_deviation* DOUBLE; 

ALTER TABLE users ADD updated_volatility* DOUBLE;

Then edit ladders.txt to show your banlist, make sure to use the database name of the pokemon.

To add an image in the welcome text use this formula

<img src="Image URL">

As Lee says above is correct, BUT you need to query the database or else you will get errors during registration as the server tries to find tables that don't exist.

 

[immortalityftw]

thanks very much!