[Guide] Ultimate Dekaron Server Tutorial

Page 1 of 3 1 23
11/13/2009 20:53 janvier123#1
Quote:

A tutorial is one method of transferring knowledge and may be used as a part of learning. More interactive and specific than a book or a lecture; a tutorial seeks to teach by example and supply the information to complete a certain task

Internet computer tutorials can take the form of a screen recording, a written document (either online or downloadable), or an audio file, where a person will give step by step instructions on how to do something.

In computer-based education, a tutorial is a computer program whose purpose it is to assist users in learning how to use (parts of) a software product such as an office suite or any other application, operating system interface, programming tool, or game. There are two kinds of software tutorials: movie tutorials that you watch, and interactive tutorials where you follow on-screen instructions (and in some cases watch short instruction movies), whereupon you do the tutorial exercises and get feedback depending on your actions. Some computer based tutorials can also be put up on the web.
PLEASE USE SEARCH !!!!

Step 1: Download

SQL 2000: [Only registered and activated users can see links. Click Here To Register...]
SQL 2000 SP4: [Only registered and activated users can see links. Click Here To Register...]


Step 2: Install

Run SQL Setup Select "SQL Server 2000 Components"
  • 1. Click "Install Database Server"
  • 2. Click Next
  • 3. Click Dot In Local Computer And Click Next
  • 4. Click Dot In "Create A New Instance of SQL Server, Or Install Client Tools" & Click Next
  • 5. Put Name And Company Click Next
  • 6. Click Yes To Agreement
  • 7. Click Dot In Server And Client Tools And Click Next
  • 8. Click Dot In Default At Top And Click Next
  • 9. Click Dot In Typical Click Next
  • 10. Click Dot In "Use The Same Account For Each Service. Auto Start SQL Server Service"
  • 11. Click Dot In "Use The Local System Account" Click Next
  • 12. Click Dot In "Mixed Mode.” Enter Password And Confirm Password Remember It, Username Is ALWAYS "sa" (Server Admin)
  • 13. Click Next And Install
  • 14. When Install Is Done Run SQL 2000 Service Pack 4 Installer (Not Making Guide On How To Install, Its Straight Forward)
  • 15. When Installed Restart PC So Server Starts
Step 3: Restoring Database
  • 1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
  • 2. Console Root -> Microsoft SQL Servers -> SQL server Group ->
  • 3. Right Click (local) (windows) -> Edit SQL Server Registration Properties
  • 4. Click Dot In Use SQL Server Authentication -> Login Name (That You Gave At The Install) -> Leave Pass Empty -> Click Dot In Always Prompt For Login Name And Password *Then Add The Login And Pass That You Gave At The Install And Go To Databases
  • 5. Create A New Database, Name It "account" (Do This Again For "billing", "cash", And "character")
  • 6. After That, Right Click On "account" Database Then Click All Tasks And Then "Restore Database"
  • 7. Click On "From Device" And Then Click On "Select Devices"
  • 8. Click Add And Then Choose The Destination Of The Backups To Restore Into SQL
  • 9. Press OK 2 Times To Continue, And Then Press The Options Tab
  • 10. Click Dot In "Force Restore Over Existing Database"
  • 11. Make Sure The Path Of The MDF And LDF Files Is Set To "C:/" (Example: C:/account.ldf)
  • 12. Press OK To Import The Database (Do This For All 4 Databases)
  • 13. Console Root -> Microsoft SQL Servers -> SQL server Group -> [local]
  • 14. Go To Security -> Login -> Right Click -> New Login
  • 15. Put Name "account" -> Click Dot In SQL Server Authentication
  • 16. Use "account" As Password -> Choose "master" As Default Database
  • 17. Go To Tab Database Access -> Click On Database "account, billing, cash, character"
  • 18. In Permit In Database Role Click On "db_owner" For Each Of The 4 Databases -> Click OK
    *If You Get An Error "User "account" Already Existed" Then Go To "account, billing, cash, character" -> Users And Delete The User "account" That Should Be There. And Then Do Steps 14-18 Again
  • 19. Go To Databases -> "account, billing, cash, character" -> Right Click -> Properties -> Permission Click All Of Them On User "account"
  • 20. Open SQL Query Analyzer And Run Query In Q-1 And In Q-2
Q-1
Code:
Use master;
Go
EXEC sp_addlinkedserver 'LSV_GHBILL','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRACNT','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRCASH','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRHELION','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={S QL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRQUNE','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRRONDOW','','MSDASQL',NULL,NULL,'DRIVER={SQ L Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSIZ','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRTEST','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRZUTO','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRSTA','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'DKRACCOUNT01','','MSDASQL',NULL,NULL,'DRIVER={SQL Server};SERVER=localhost;UID=;PWD=;'
Q-2
Code:
Use master;
Go
exec sp_serveroption 'LSV_GHBILL','rpc out','true'
exec sp_serveroption 'LSV_GHBILL','rpc','true'
exec sp_serveroption 'LSV_DKRACNT','rpc out','true'
exec sp_serveroption 'LSV_DKRACNT','rpc','true'
exec sp_serveroption 'DKRCASH','rpc out','true'
exec sp_serveroption 'DKRCASH','rpc','true'
exec sp_serveroption 'LSV_DKRHELION','rpc out','true'
exec sp_serveroption 'LSV_DKRHELION','rpc','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc out','true'
exec sp_serveroption 'LSV_DKRNUNVICE','rpc','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc out','true'
exec sp_serveroption 'LSV_DKRQUNE','rpc','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc out','true'
exec sp_serveroption 'LSV_DKRRONDOW','rpc','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc out','true'
exec sp_serveroption 'LSV_DKRSIZ','rpc','true'
exec sp_serveroption 'LSV_DKRTEST','rpc out','true'
exec sp_serveroption 'LSV_DKRTEST','rpc','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc out','true'
exec sp_serveroption 'LSV_DKRZUTO','rpc','true'
exec sp_serveroption 'LSV_DKRSTA','rpc out','true'
exec sp_serveroption 'LSV_DKRSTA','rpc','true'
exec sp_serveroption 'DKRACCOUNT01','rpc out','true'
exec sp_serveroption 'DKRACCOUNT01','rpc','true'
Step 4: Adding Accounts

1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
Code:
Use account;
Go
Insert Into [TBL_USER] Values ('09101410275532', 'ID', 'Password', 'E-Mail', 'Secret Answer', 'Secret Question')
Insert Into [USER_PROFILE] Values ('09101410275532','ID','Password','801011000000','1','0','Y','01/01/2006 00:00:00',null,null,null,'000')
(NOTE: 09101410275532 Must Be Changed Atleast 1 Digit Per Account Added This Way)

Step 5: System DSN
  • 1. Start Data Sources (ODBC) Located In Windows XP At Start -> Control Panel -> Performance And Maintenance -> Administrative Tools -> Data Sources (ODBC), Go To System DSN Tab Then Click Add.
    (If You Cant Find It Try Going To Start -> Run -> Type In "odbcad32.exe" And Hit Enter)
  • 2. Select The SQL Server Driver (Its At The Bottom) And Click Finish. Choose "account" For Name And Your SQL Server "Name" For Server. Dont Use [local] It Doesnt Work. To Obtain It Put Your Mouse Over The Server Tray Icon, Right Click Go Into Open SQL Server Service Manager, Select The Server Name, And Right Click -> Copy. Paste That As Your Server Name
  • 3. Choose SQL Server Authentication -> Connect To SQL Server To Obtain Settings Use "account" As User, And "account" As Password Then Click Next
  • 4. Click Next Then Finish And OK.

Step 6: Server Ini Files

All Ini Files Should Be Opened And Checked. Make Sure All IPs Are Set To "127.0.0.1" For Localhost First Time Server Testing, Make Sure All Database Logins Are Set Like So:
Code:
DATABASE_ACCOUNT	= account
DATABASE_PASSWORD	= account
For A Public Server You Should Set All IP's In Ini's To 127.0.0.1 EXCEPT! LoginServers IP. Which Should Be Set To Your External IP [Only registered and activated users can see links. Click Here To Register...]

Step 7: Starting YOUR Server
  • 1. Dbmon
  • 2. Cast Server
  • 3. Login Server
  • 4. Msg Server
  • 5. Session Server
  • 6. Game Server
Step 8: Edit The Client So You Can Connect To Your Server
  • 1. Open Client Folder And Go Into Data -> Share
  • 2. Now Theres 2 Files That Control IP To Connect To (loginlist.csv & channellist.csv)
  • 3. Replace The IP In Both Of Them With "127.0.0.1" Then Save And Exit
  • 4. Load Up Client And Login And Play!
(This Is For Clients With Unpacked data.pak)

Extras

[How to Make Your Self A GM]
Login And Make A Character Once Your Ingame Go To SQL Server Analyzer (Read Step 4: 2 To Find If You Cant)
Code:
Use character;
Go
Update [user_character] Set chatacter_name= '[GM]NAME' Where character_name= 'NAME'
[Dekaron Port Forwarding List]
  • 1. 7880 - 7880 (TCP/UDP)
  • 2. 10000 - 10000 (TCP/UDP)
  • 3. 50005 - 50005 (TCP/UDP)

[Item ID List][Steps To Backup Your Database]
  • 1. Open Enterprise Manager
  • 2. Click SQL Server -> SQL Server Group -> [local]
  • 3. Click Your Database (IE: account)
  • 4. Right Click Database -> All Tasks -> Backup Database
  • 5. Click Remove Of Any Names In Destination, If No Names Present Then Click Add
  • 6. Click The "..." And Type A Name
  • 7. For Example account_backup_09
  • 8. Click OK
  • 9. Go To Options Click Dot "Verify Upon Completion"
  • 10. Click OK... And Its Backed Up

[Common Errors And Problems Fixes]
Code:
>>CRITICAL ERROR : SP_LOGIN_FLAG_SET PROC CALL FAIL
This Happens Becuase Your "account" Login In Database Wasnt Made Right And Is Missing Permissions To 1 Or More Of The 4 Databases. To Fix Refer To Step 3 Sections 13-19.

Code:
File: .\Config\Provider.cpp, Line: 79
This Happenes Becuase Of Ram Or Virtual Memory. These Server Files Bank Into PageFile For Some Reason IDK Dont Ask Me Why But They Do (Chances Are Thier Old Files And Servers Needed A Way To Load Files And Keep Physical Ram Open For Connected Users). To Fix This Either 1. Buy More Ram Or 2. Increase Your PageFile.

How Do I Increase My PageFile?
Start -> Right Click "My Computer" -> Properties -> Advanced Tab -> First Settings Button Under "Performance" -> Advanced Tab Again -> Bottom Click "Change" Button -> Click On C: -> Then Click On "Custom Size" And Place 3000 In Each Box -> Then Click "Set" Then Ok And Ok Again. Restart Computer.

Have fun ! ~Warmonger
11/13/2009 21:11 bullet21.#2
great post janvier123 but this wont help much, cause if they cant build a pserver on video tuts then nothing will help. anyway again a great post by. janiver
11/13/2009 21:27 xaneiro80#3
i think its almost easy but u have done it easiery than its already ..now even noobs can make pserver xD
noobs are noobs and they will be noobs...xD
11/13/2009 21:29 bullet21.#4
Quote:
Originally Posted by xaneiro80 View Post
i think its almost easy but u have done it easiery than its already ..now even noobs can make pserver xD
wanna bet they will still ask ?
11/13/2009 21:37 janvier123#5
Quote:
Originally Posted by [GM]Bullet View Post
wanna bet they will still ask ?
Sure they will
if you gave them:

- working server files
- video tutorials
- everything to set up a server

they still dont get it! ;)
11/13/2009 21:46 xaneiro80#6
...[GM]Bullet i will bet with u that noobs will say "where i can find serverfiles or how to install SP4 there aren't any how to" xD
11/13/2009 21:52 bullet21.#7
Quote:
Originally Posted by xaneiro80 View Post
...[GM]Bullet i will bet with u that noobs will say "where i can find serverfiles or how to install SP4 there aren't any how to" xD
yea lol anyway lets stop our "spam" posts :)
11/13/2009 22:00 janvier123#8
Quote:
Originally Posted by xaneiro80 View Post
...[GM]Bullet i will bet with u that noobs will say "where i can find serverfiles or how to install SP4 there aren't any how to" xD
easy [Only registered and activated users can see links. Click Here To Register...] :d
specialy made for DK p-server
11/13/2009 22:01 sephx#9
The credits for this guide belong to Warmonger here is original post

[Only registered and activated users can see links. Click Here To Register...]
11/13/2009 23:02 janvier123#10
good eye :)
thx i forgot to add him name
shame on me :(
11/14/2009 06:28 nobleman80#11
Quote:
Originally Posted by janvier123 View Post
good eye :)
thx i forgot to add him name
shame on me :(
ANYWAY YOU STILL A IDOL OF SO MANY PPLS. YOU R GOOD DUDE!!!:handsdown::handsdown:
11/14/2009 07:16 janvier123#12
thx i try to do my best
11/14/2009 10:26 nobleman80#13
i had follow the steps. i m sure i i m done it right. but when i run cast server it always show me that SQL server not found or access deny. i gotta no problem. only 1 error durig th installion of SQL at the last part error in netgetinfo. can you help me???

heY if i back up your 1 click server. will my com 's config change?? cos our hardwares are differents. and if i only back up the 1 click server parts not those window/system 32 will do??? shld i use guest acct for it??
11/14/2009 13:03 bullet21.#14
Quote:
Originally Posted by nobleman80 View Post
i had follow the steps. i m sure i i m done it right. but when i run cast server it always show me that SQL server not found or access deny. i gotta no problem. only 1 error durig th installion of SQL at the last part error in netgetinfo. can you help me???

heY if i back up your 1 click server. will my com 's config change?? cos our hardwares are differents. and if i only back up the 1 click server parts not those window/system 32 will do??? shld i use guest acct for it??
u putted right username and pass in ur config. ini files in cast server and in session server ?

Quote:
Originally Posted by nobleman80 View Post
only 1 error durig th installion of SQL at the last part error in netgetinfo
install it again rofl
11/14/2009 14:26 nobleman80#15
Quote:
Originally Posted by [GM]Bullet View Post
u putted right username and pass in ur config. ini files in cast server and in session server ?

install it again rofl
I had tried to reinstall it many times. still the same. and i oso tried made 1 new com user acct for it. but the error still there. dman it.. failure... i had use silkbotter 1 click server. it works. but need to use haimachi. and the vm took up hell alot of hard disc. so i m thinking of making 1 on my pyhsical com. i m 100% sure i follow the steps. i believe the fault is layed on the stupid SQL error!!! fk!!
Page 1 of 3 1 23