[GUIDE] How Make Your Own Server Dekaron

[dr4g9n]

Hello, i have been looking at the dekaron forum and realized that the existing tutorial meets with links disabled, as well, just to let down the links and tabs that you want to create your own server Dekaron.

[ Step 1 - Download Files and Programs ]

* SQL 2000 -

You must be registered to see links

* SQL 2000 SP4 -

You must be registered to see links

** Server Files:

You must be registered to see links

or

You must be registered to see links

** Client:

• You must be registered to see links
• You must be registered to see links
• You must be registered to see links
• You must be registered to see links
• You must be registered to see links
• You must be registered to see links
• You must be registered to see links
• You must be registered to see links
• You must be registered to see links

[Step 2 - Install & Configure]

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 - Restore 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 -> All Tasks -> 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 Then In Q-2

Q-1

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={SQL Server};SERVER=localhost;UID=;PWD=;'
EXEC sp_addlinkedserver 'LSV_DKRNUNVICE','','MSDASQL',NULL,NULL,'DRIVER={SQL 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={SQL 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

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)
3. Go To

You must be registered to see links

And Generate A Hashed Password And Define It Below.

Use account;
Go
---Account Query By Warmonger---
DECLARE @UserNO varchar(16), @AccountID varchar(16), @Password  varchar(32), @Email varchar(50), @SecretA varchar(22), @SecretQ  varchar(22)
SET @UserNO= '09101410275532'
SET @AccountID = 'Account ID'
SET @Password = 'Account Password'
SET @Email = 'E-Mail'
SET @SecretA = 'Secret Answer'
SET @SecretQ = 'Secret Question'
 
Insert Into [USER_PROFILE] Values  (@UserNO,@AccountID,@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 DNS]

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:

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.

[Step 7 - Starting Server]

1. Dbmon
2. Cast Server
3. Login Server
4. Msg Server
5. Session Server
6. Game Server

Step 8 - Edit Client to Connect to 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!

[How make Your Self a GM]

Login And Make A Character Logout And Go To SQL Server Analyzer (Read Step 4: 2 To Find If You Cant)

Use character;
Go
Update [user_character] Set character_name= '[GM]NAME' Where character_name= 'NAME'

Thanks!

 

[xfactorbowler]

yet again posting stuff and not giving credits to the original posters.

 

[xShawn]

This client version is 13.8.4?

 

[I Am NoLimiT]

is this a latest version?

please post some details,changelog with that files,also ScreenShots?.thanks for the release

 

[I Am NoLimiT]

wheres the database?

 

[clever]

where is the database? canu upload it?

 

[marveloko]

I think this will serve databases, have not tested it but I'm out of time, most will try and come back here to talk.

You must be registered to see links

 

[jorge1978]

you can use sql 2005?

 

[DevilSpeak]

you can use sql 2005?

Hello,

Take a look at what past members have to say.
http://forum.ragezone.com/f535/ultimate-dekaron-server-tutorial-616366/index6.html

 

[marveloko]

I will use the same SQL2000, I'm giving now download the client and will create for testing.

you can use sql 2005?

 

[Maginaz]

Sir i have a question can i make vmware server i mean pc to connect to other pc with vmware? cuz i can't install/use SQL2000 on windows 8(my pc) and i dont know how to setup SQL 2008 & above version which can i only install on windows 8.. i can only use SQL2000 on vmware which is XP OS.

 

[Dzver]

Sir i have a question can i make vmware server i mean pc to connect to other pc with vmware? cuz i can't install/use SQL2000 on windows 8(my pc) and i dont know how to setup SQL 2008 & above version which can i only install on windows 8.. i can only use SQL2000 on vmware which is XP OS.

Easiest and fastest method is to install hamachi or other similar product (there is alot in net). Then you just edit loginlist.csv and channellist.csv ip's from 127.0.0.1 to your ip in hamachi (something like 87.64.12.193). Of course you need to have hamachi started both in client and server pc's. Dont forget to join on client side in hamachi network you made in vm. Good luck.

 

[cypher]

*poof*

you're up.

 

[pihla2]

Hi cuys!
If i start server, its run fine.

But, ater that if i close server and try it again, says ID or PW is wrong, how to i recover it?
How then shutdown server, so it saving files, or do i miss some part?
"Its work perfectly per setup" lol <--a little nonsense

 

[flickers]

I'm just a a beginner at making server. I've wanted to make my own Test Server for Fantasy Dekaron. How can I do it? Which one should i Download? the server files are a12/a13 i think

 

[netzhdez]

Thank you so much for this excelent post. This is the game that I play in the middle school all the day, but now i can have my own server to play, that´s 2 cool. Thank you so mucho again.
I´m going to download all the files...

 

[khurux]

because I disconnected when I choose the character Aloken!!! help me

 

[ratchakon]

http://image.ohozaa.com/view2/xIru9B52GZhqHK4Q

 

[4pLay]

ELP!!! dekaronserver.exe crashes after loading...

thanks!!!
god bless!!!

 

[sasuke]

no matter the database by mistake