How to setup with MS Sql 7.0 and MS Sql 2000
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 MS SQL 7 or MS SQL 2000 (depending on your version) from the DB Type pull down menu
- Enter in the IP or enter in the named instance of the server ("192.168.1.9" OR "192.168.1.9\MyInstance") 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, use Enterprise Manager, or 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)
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Ladder]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Ladder]
GO
CREATE TABLE [dbo].[Ladder] (
[pid] [int] IDENTITY (1, 1) NOT NULL ,
[pName] [nvarchar] (50) NULL ,
[pKills] [int] NULL ,
[pDeaths] [int] NULL ,
[pScore] [int] NULL ,
[pLadder] [int] NULL ,
[pGDI] [int] NULL ,
[pNod] [int] NULL
) ON [PRIMARY]
GO
* 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