How to setup with My Sql
FIRST THINGS FIRST, unless you want your app to lag all to hell, delete those hundreds of results files from your Server directory (C:\Westwood\RenegadeFDS\Server\ by default)
- Open up BR .Net and goto the Ladder Tab
- Select MySQL from the DB Type pull down menu
- Enter in the IP of the server ("192.168.1.9" ") in the DB location
- Enter in the DB name of the Ladder in the DB Name textbox
- Enter in the Table Name (default is Ladder) into the TableName textbox
- Enter in a User ID of someone that has Select, Insert, Update permissions in the Ladder DB into the User ID textbox
- Enter the password for the above account
- Now, open up whatever means you have to connecting your SQL server, and run the following sql query to add the Ladder DB (replace the Ladder table name if you wish)
CREATE TABLE Ladder.Ladder(
pID INT (3) NOT NULL AUTO_INCREMENT,
pName VARCHAR (10) NOT NULL,
pKills INT (4) NOT NULL ,
pDeaths INT (4) NOT NULL ,
pScore INT (9) NOT NULL,
pLadder INT (9) NOT NULL,
pGDI INT (3) NOT NULL,
pNod INT (3) NOT NULL,
INDEX(pID))
* i have included a Ladder_ms_sql.sql file in the install directory, you can use that as well
- now, click on Enable Ladder Support, and Save Settings
- To test the DB connectivity, simply click on Update View to verify
That is about it, now when the game is over, BR .Net will input the results file into the ladder DB, and move the resultsxx.txt to the BR .Net program dir\Results\ for RenStat compatability.
See the section on Displaying the ladder for retrieving the data.
Back to main