Ultimate Dekaron Server Tutorial

[BladeCX]

OK, thanks)

Then can I connect server (instaled on VirtualMachine) from my computer using IP 127.0.0.1?

No, you should use bridged adapter then it will connect to your physical network and acquire an IP. After that you just need to config your loginlist and channellist to the IP of the virtualmachine.

 

[egortar]

mm, I understand, thx.


New problem

My SessionServer just closing down, when I'm trying to connect server.What's wrong?

dbmon says "3708: File: .\Message\FormatHandler\Provider.cpp Line:81"

 

[BladeCX]

mm, I understand, thx.


New problem

My SessionServer just closing down, when I'm trying to connect server.What's wrong?

dbmon says "3708: File: .\Message\FormatHandler\Provider.cpp Line:81"

Check your configuration ini in the SessionServer folder, and see if the IP, MSSQL User and Pass are correct.

Also would like to know what MSSQL you are using.

 

[egortar]

I have MSSQL 2000 SP4, but I'm not sure of installing SP4... is it importatnt?

Everything is OK in configuration.

 

[BladeCX]

I have MSSQL 2000 SP4, but I'm not sure of installing SP4... is it importatnt?

Everything is OK in configuration.

You must use the SP4 update.

 

[egortar]

yeah,everything is working now!!!

Thank you very much for your patience and help!)

 

[egortar]

Some more questions..

1.How can i ban user?
(I know that I can do it through firewall..but how can I get user's IP then?)
2.How can I get player's ID?

 

[OpenFile]

Can I use mysql with these server files? In the server files I only see database connection, but not talk how database use.

Thanks.

 

[BladeCX]

Can I use mysql with these server files? In the server files I only see database connection, but not talk how database use.

Thanks.

No you can't use mysql you must use mssql 2000 sp 4 or later.

Some more questions..

1.How can i ban user?
(I konow that I can do it through firewall..but how can I get user's IP then?)
2.How can I get player's ID?

I will explain how when I have time to connect to my server to take screenshots.

 

[egortar]

ok, thx)

 

[kinder32]

nice guide, really nice, but how can i add a7 weap and armors and that things.


thx for the guide.

 

[BladeCX]

ok, thx)

Okay First of all sorry for the delay.

To ban a user the easiest and safest way is to open your "ACCOUNT" database and go to the table "USER_PROFILE"

Once "USER_PROFILE" is open search for the user you want to ban then change their "login_tag" to "N" so the account is blocked.

If you just know the character's nick then 1st get the "user_no" from the character, you can do so by opening your "CHARACTER" database and look for a table named "user_character" if I'm not mistaken. There look for the nick and then on the row of that character look for the "user_no". Go back to your "USER_PROFILE" and search for that "user_no" and do the above stated.

 

[Dylan3000]

Nice efforts Blade.

 

[hdvn0201]

server required setup VMware not? I'm is newbie all you help me ..... Pls........ setup VMware ? guide me ....

 

[Warmonger]

server required setup VMware not? I'm is newbie all you help me ..... Pls........ setup VMware ? guide me ....

Setting up vmware isn't really no different then normal setup. Just follow guide once you get your windows installed. Also remember to bridge your NAT.

 

[astruan]

is this the guide to create a dekaron server? thx you

 

[Warmonger]

is this the guide to create a dekaron server? thx you

Like ---------------------------------------------------------------------------------->

 

[supercrashn1]

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)

After i done this steps , can i move the backup files stored in C:\ in other partition ? Cause i don't have much hdd space left there ...

 

[Warmonger]

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)

After i done this steps , can i move the backup files stored in C:\ in other partition ? Cause i don't have much hdd space left there ...

You could try change them all to E:\ or whatever other drive is. Also there is clean database files on net.

Clean Database:

To view the content, you need to sign in or register

 

[supercrashn1]

Thx for that , now i have another problem

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

I made this step 3 times in a row , and it still gives me that "User account already exists" ...help me :?:
--------------------------------------------------------------------------

My mistake , sorry. i was deleting the user "account" from Security Logins , that's why it kept giving me that error. Got that figured it out when i looked carefully at ur steps.