Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

[Guide] Setting up a Dragonica 0.15.12 Server

Junior Spellweaver
Joined
Mar 20, 2011
Messages
169
Reaction score
35
Hi,

Setting up a Dragonica server in only 30 little steps, it must long and hard :?:
No, easy as hell, the only hard thing was to think about everything of memory in this guide :lol:

(You must have installed .net framework 4 and visual studio C++)

Creating a Dragonica Server is easy, I didn't even needed a guide for the 0.14.10 and 0.15.12 files but I make a guide anyway for peoples.

So let's go !:drool:

~~~Setting Up the Database~~~:eek:tt1:

1.Once you have the Database and Serverfiles, go to the Database, copy all, and paste all to :
"C:program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackup"

2.Launch MSSQL, then, In MSSQL 2008R2, connect to your account, then Right Click on "Databases" and select "Restore Database..."

3.Click on "From Device" and select the Browse button ( [...] )

4.Make sure that "Backup media" is set on "File" and click on Add.

5.Now, select the .bak file you want to restore (DR2_Def) and click "Ok"

6.Then, a new window must pop-up. In front of "To database", you'll write the name of the database you're restoring. And check the box on the "Restore" tab.

7.Click on Options (on the left), check "Overwrite the existing database (WITH REPLACE)" and click on "Leave the database ready to use by..." (I'm lazy to write the rest)

8.And click on "OK" !!!

9.Now you know how to restare a database, do it for all the .bak files.

/!At the step 6, make sure to write well the databases names/!

Databases names ::sleep:

DR2_Def
DR2_GM
DR2_Local
DR2_Log
DR2_Member
DR2_SiteConfig
DR2_User

10.You should have restored all the .bak files, well done !

11.Open the Database DR2_SiteConfig inside MSSQL and right click on "dbo.TB_Realm_1" and select "Edit all Rows"

/!If you do not have the "Edit All Rows" option:$:, then click on "Tools>Options", Click in SQL Server Object Explorer and than in the "Table and View Options" change the value 200 to 0/!

12.Replace all the fields with written "YOUR IP" or "127.0.0.1" (I don't exactly remember) by your IP. (127.0.0.1 if you wish to make your server on local)

13.Do the same for dbo.TB_SiteServer !

/!Don't put your IP everywhere you see "NULL"/!

~~~Options for the Database !!!~~~

-To translate the CashShop categorie tab names, then expand "DR2_Local", expand "Tables", then Right click on "dbo.TB_Common_CashItemCategory", select the option "Edit all Rows" and edit the values you want to translate.

14.Verify that in MSSQL :
Expand "Security" and "Logins", right click on "sa" -> "Proprieties"
On the left, click on the "User Mapping" tab and make sure that "db_owner " is checked for all the databases. Then "Ok"

/!If you do not do this, your character's items IG won't be saved./!

15.You're done with the Database !!!:w00t:

~~~Setting Up the Serverfiles~~~:<:
16.Now, the borring part...:mad:

17.Go inside your serverfiles folder, then "GC" and edit all the .ini files with your settings.

Exemple :
ADDR = PUT YOUR IP OR SQL ADRESS,1433 Never change the Port
NAME = DR2_SiteConfig Never change the name of the Database
ID = sa
PW = PW

18.In MMC.ini and the end, just put 1 as ID and PW

Exemple :
[USER_INFO_1]
ID = 1
PW = 1
IP = 127.0.0.1
GRADE = 10
It is the ID and PW that you'll need to enter to log in the ServerControl.

19.And in Local.ini, change the values according to this :

[LOCAL_INFO]
NATION_CODE = SINGAPORE
SERVICE_REGION = SINGAPORE
LANGUAGE = ENGLISH
SERVICE_TYPE = 2

20.Now, move to "DragonicaServer files 0.15.12Patchconfig" and edit all the .ini files with your settings.

21.For the Local.ini file, change the values according to this :

[LOCAL_INFO]
NATION_CODE = SINGAPORE
SERVICE_REGION = SINGAPORE
LANGUAGE = ENGLISH
SERVICE_TYPE = 2

22.If you wanna stay in local, skip this step. Go back in your main server files folder and edit "2.bat" and change "127.0.0.1" by your IP.

23.Done with the config !!!

~~~Start the Server~~~

24.Start in the order 1.bat, 2.bat and then 3.bat

If ServerControl (3.bat) doesn't start:scared:, try first to launch it manualy by going inside the GC folder and start it with "Run as Admin" (Right click)
If it still doesn't work :grr:download all the Microsoft Visual C++ librarys you can find.

Lazy hmm ? Yeh I understand, it took several days to find the good one... So here's my package (run all of them:rolleyes:)



Alright, now you've start the ServerControl once MMC and SMC finished initialized, you'll login with the ID and PW you've set in the MMC.ini file (It's ID : 1 and PW : 1 if you've set the values according to my exemple)

25.Inside ServerControl, Click on Immigration and on left, down from the "Refresh" Button, click on "On" then "Ok".

26.Then start everything in the order you want. (Becarfull, it takes a lot of RAM)

27.Play !:D: Create a .bat if the values :

start .releaseDRAGONICA.EXE /NoGsm /LaunchByLauncher /ServerAddr:""127.0.0.1"" /ServerPort:""11201"" /SiteName:""""
exit

28.Replace the "127.0.0.1" by your IP server if you're not in local.

29.To stop the server:*:, don't shut down all the windows, just select everything in the ServerControl and click on "Off"

30.That's it, you have your own Dragonica server ! :thumbup:


How to create an account ?

Use the stored precedure called :
dbo.up_CreateMemberAccount

Here :
DR2_Member > Probality > Stored Procedures > dbo.up_CreateMemberAccount (R) > Execute stored procedure.

And you put inside :
UID = 0 (allways)
ID = username
PW = password
Gender = 0/1 , 0 male / 1 female
Birthday =" whatever you want date* like this = 2011-07-10 16:25:45.670
And then hit "Ok" !


Errors :

If you get your MMC closed 1 or 2 sec after having launched (+ dump error in the MMC folder) then, juste remove the port adress in all the .ini configs. Exemple : something like "ADDR = PCNAME\SQLEXPRESS" or "ADDR = IP"(without port ! ex. : ,1433)
Some people have this error on some kind of computer when they try to make the server run on local.

Credit to Unintended for having searched the fix of this unknown error ^^

Got an other problem ?

Re-run the guide from start, read all the discusion, search answers on google and if you don't find anything, post a comment, I'll probably help you

Please, to thank me for all my work, read the ReadMe.txt file inside the .rar file or in the Attached files and do what it asks (Subscribing to my Youtube Channel, that would please me so much.) :eek:tt:



My other threads :
http://forum.ragezone.com/f733/share-dragonica-v0-15-12-a-871065/
http://forum.ragezone.com/f733/realase-dragonica-servercontrol-0-15-a-871300/#post7194629
http://forum.ragezone.com/f733/share-dragonica-v0-15-12-a-871317/
 

Attachments

You must be registered for see attachments list
Last edited:
Junior Spellweaver
Joined
Jun 3, 2009
Messages
113
Reaction score
3
NICE tutorial ! now my server is running
btw can you recommended me what is the important map to run ?
I run all of the map take 8gb ram lol
i have no idea what the map is most important ( I just try dragonica today )
and btw why is my npc name chinese ? can we translate it ? if yes how ? thanks :D

you're the man
 
Junior Spellweaver
Joined
Mar 20, 2011
Messages
169
Reaction score
35
Hmmm.. I would recommend the 9 first map, the 2 last maps. And not the copy maps and nether the pvp.
 
Newbie Spellweaver
Joined
Apr 19, 2011
Messages
24
Reaction score
1
I get this error when i click on bat 2, any ideas on how to fix this

C:\Users\pc\Downloads\Server games\Dragonica\mhlz>cd .\GC

C:\Users\pc\Downloads\Server games\Dragonica\mhlz\GC>SMC_Release.exe /SERVER
_NO=9001 /MMC_ADDR=127.0.0.1:1801
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Check Start
LV-06,17:33:16,* Log File Check End
LV-06,17:33:16,======================================================
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Delete Start
LV-06,17:33:16,* Log File Delete End
LV-06,17:33:16,======================================================
LV-01,17:33:16,Wait For ProcessShutDown ... []
LV-01,17:33:16,Wait For ProcessShutDown ... [SMC_Temp.exe]
LV-07,17:33:17,==================== Server Initialize Start ====================

LV-07,17:33:17,Product Version : 0.10.30.1
LV-07,17:33:17,File Version : 0,1,2,0
LV-07,17:33:17,Protocol Version : 10.04.05.1
Connect LV-06,17:33:17,Regist Connector Success A55F021F-38F7-4A35-9733-1FF00C3B
AA3DT
o LV-08,17:33:17,[OnRegist]-[37] RT_CONNECTOR
MMC
LV-06,17:33:17,==================================================
LV-06,17:33:17,============ CoreCenter Run ======================
LV-06,17:33:17,==================================================
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
 
Newbie Spellweaver
Joined
Jul 19, 2010
Messages
6
Reaction score
0
Help me plz Server Start done, login ok and etc. but when char is relogin all item's disappear (in inventory), problem is on Contents server it all the time give me err-102 when char is gathering\purchases loot
 
Initiate Mage
Joined
May 24, 2009
Messages
4
Reaction score
0
LAN don't work

i changed all ip follow your guide (192.168.10.10 my lan ip)

but don't work

client said "Cannont Connect to Server"

how to fix ?
 
Junior Spellweaver
Joined
Jun 3, 2009
Messages
113
Reaction score
3
I get this error when i click on bat 2, any ideas on how to fix this

C:\Users\pc\Downloads\Server games\Dragonica\mhlz>cd .\GC

C:\Users\pc\Downloads\Server games\Dragonica\mhlz\GC>SMC_Release.exe /SERVER
_NO=9001 /MMC_ADDR=127.0.0.1:1801
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Check Start
LV-06,17:33:16,* Log File Check End
LV-06,17:33:16,======================================================
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Delete Start
LV-06,17:33:16,* Log File Delete End
LV-06,17:33:16,======================================================
LV-01,17:33:16,Wait For ProcessShutDown ... []
LV-01,17:33:16,Wait For ProcessShutDown ... [SMC_Temp.exe]
LV-07,17:33:17,==================== Server Initialize Start ====================

LV-07,17:33:17,Product Version : 0.10.30.1
LV-07,17:33:17,File Version : 0,1,2,0
LV-07,17:33:17,Protocol Version : 10.04.05.1
Connect LV-06,17:33:17,Regist Connector Success A55F021F-38F7-4A35-9733-1FF00C3B
AA3DT
o LV-08,17:33:17,[OnRegist]-[37] RT_CONNECTOR
MMC
LV-06,17:33:17,==================================================
LV-06,17:33:17,============ CoreCenter Run ======================
LV-06,17:33:17,==================================================
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!


are you already set the data base ?
make owner_db for all database ?
cek the ip setting on folder
 
Newbie Spellweaver
Joined
Apr 19, 2011
Messages
24
Reaction score
1
I set all my ip's to 127.0.0.1 and left all the ports as they were. and my databases all have db_owner rights. but when i start the second bat i get failed to connect to mmc, then something pops up. it says MMC_release.exe - no disk, then it says, There is no disk in the drive. please insert a disk into drive\Device\Harddisk\DR3. and then there are 3 buttons cancel, try again, and continue.
 
Newbie Spellweaver
Joined
Jul 29, 2012
Messages
5
Reaction score
0
TGfeu001 - [Guide] Setting up a Dragonica 0.15.12 Server - RaGEZONE Forums
[/url]
help me, please
 
Junior Spellweaver
Joined
Jun 3, 2009
Messages
113
Reaction score
3
why i cant login anymore ?
how to add account
server are run perfectly
but always please check your id -_-a
how to solve ?
 
Newbie Spellweaver
Joined
Jan 7, 2012
Messages
11
Reaction score
1
Image too small, And check db configs @ config folder.
That error there is the one cybernight was talking about and i have the same problem also. Everything is set up to the bone but whenever i run bat 1 and then bat 2. Bat to fails to connect and bat 1 gets that error shown and closes. Any ideas?
 
Skilled Illusionist
Joined
Jul 5, 2006
Messages
329
Reaction score
81
what the problem i got?

LV-07,22:50:02,==================== Server Initialize Start ====================

LV-07,22:50:02,Product Version : 0.9.29.6
LV-07,22:50:02,File Version : 0,1,1,0
LV-07,22:50:02,Protocol Version : 10.04.05.1
LV-00,22:50:02,[CEL::CDBConnection::OpenDB]-[112] Open=Provider = SQLOLEDB.1; D
ata Source=.\SQLEXPRESS; Initial Catalog=DR2_SiteConfig; User Id=sa; Password=**************; Packet Size = 16384; Use Procedure for Prepare = 1; Auto Translate =
True Failed=0x80040E4D
LV-01,22:50:02,-=-=-=-=-=- ASSERT_LOG -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
LV-01,22:50:02,[OnRegist]-[17] OnRegist Failed Type = 3
LV-01,22:50:02,-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
=
*==============LV-01,22:50:02,-=-=-=-=-=- ASSERT_LOG -=-=-=-=-=-=-=-=-=-=-=-=-
=-=-=-=-=-==
======LV-01,22:50:02,[OnRegist]-[17] OnRegist Failed Type = 3=
=======LV-01,22:50:02,-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
-=-=-=-==
==============================*
Unhandled excetpion triggerd!
Date / Time : [08/27/12 22:50:02]
ProcessID / ThreadID : [0x000004C8] / [0x00000150]
ExceptionCode : [0x80000003]
CommandLine : MMC_Release.exe /SERVER_NO=900 /RUN_MODE=INI
Writing Dump....
*============================================================*
 
Last edited:
Junior Spellweaver
Joined
Mar 20, 2011
Messages
169
Reaction score
35
I get this error when i click on bat 2, any ideas on how to fix this

C:\Users\pc\Downloads\Server games\Dragonica\mhlz>cd .\GC

C:\Users\pc\Downloads\Server games\Dragonica\mhlz\GC>SMC_Release.exe /SERVER
_NO=9001 /MMC_ADDR=127.0.0.1:1801
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Check Start
LV-06,17:33:16,* Log File Check End
LV-06,17:33:16,======================================================
LV-06,17:33:16,------------------------------------------------------
LV-06,17:33:16,* Log File Delete Start
LV-06,17:33:16,* Log File Delete End
LV-06,17:33:16,======================================================
LV-01,17:33:16,Wait For ProcessShutDown ... []
LV-01,17:33:16,Wait For ProcessShutDown ... [SMC_Temp.exe]
LV-07,17:33:17,==================== Server Initialize Start ====================

LV-07,17:33:17,Product Version : 0.10.30.1
LV-07,17:33:17,File Version : 0,1,2,0
LV-07,17:33:17,Protocol Version : 10.04.05.1
Connect LV-06,17:33:17,Regist Connector Success A55F021F-38F7-4A35-9733-1FF00C3B
AA3DT
o LV-08,17:33:17,[OnRegist]-[37] RT_CONNECTOR
MMC
LV-06,17:33:17,==================================================
LV-06,17:33:17,============ CoreCenter Run ======================
LV-06,17:33:17,==================================================
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!
Connect To MMC
Connect To MMC Failed. Connect Retry!

You must launch first MMC, then when its initialized properly, launch SMC and then ServerControl and then Immigration.
If done and doesn't solved, just check out if all your config is right.


Help me plz Server Start done, login ok and etc. but when char is relogin all item's disappear (in inventory), problem is on Contents server it all the time give me err-102 when char is gathering\purchases loot

You've just forgotten to set the rights on your "sa" user.
Step 14 ! Verify that in MSSQL :
Expand "Security" and "Logins", right click on "sa" -> "Proprieties"
On the left, click on the "User Mapping" tab and make sure that "db_owner " is checked for all the databases. Then "Ok" (do not uncheck the already checked box(s) !!)



LAN don't work

i changed all ip follow your guide (192.168.10.10 my lan ip)

but don't work

client said "Cannont Connect to Server"

how to fix ?

LAN Ip is ONLY 127.0.0.1



I set all my ip's to 127.0.0.1 and left all the ports as they were. and my databases all have db_owner rights. but when i start the second bat i get failed to connect to mmc, then something pops up. it says MMC_release.exe - no disk, then it says, There is no disk in the drive. please insert a disk into drive\Device\Harddisk\DR3. and then there are 3 buttons cancel, try again, and continue.

Can you explain better please ?
Before that, make sure all the configs and db in set right.
Maybe if you using a VM (Virtual Machine) this one isn't set right.
Try to see with "compmgmt.msc" if something is wrong with your hard drive.



TGfeu001 - [Guide] Setting up a Dragonica 0.15.12 Server - RaGEZONE Forums
[/url]
help me, please


If thing you havn't set well everything.. Try to follow my guide precisly again and only do what it is asked for. My guide is 100% complete.


why i cant login anymore ?
how to add account
server are run perfectly
but always please check your id -_-a
how to solve ?

How to create an account ?

Use the stored precedure called :
dbo.up_CreateMemberAccount

Here :
DR2_Member > Probality > Stored Procedures > dbo.up_CreateMemberAccount (R) > Execute stored procedure.

And you put inside :
UID = 0 (allways)
ID = username
PW = password
Gender = 0/1 , 0 male / 1 female
Birthday =" whatever you want date* like this = 2011-07-10 16:25:45.670
And then hit "Ok" !






Alright ! That's it !
Sorry, I was gone for a while ^^
 
Newbie Spellweaver
Joined
Apr 19, 2011
Messages
24
Reaction score
1
I went inside of my GC folder and clicked on MMC_Release.exe and all i got was Error Arg, then press any key to continue. I am going to tinker here and there to see if i can fix the problem, but if you guys have and suggestions, please tell me.
 
Newbie Spellweaver
Joined
Jul 26, 2012
Messages
19
Reaction score
0
Can you make video? I keep having alot of problems :(
 
Junior Spellweaver
Joined
Mar 20, 2011
Messages
169
Reaction score
35
Can you make video? I keep having alot of problems :(

No. I do not have the time and I made a guide. I wasn't obliged to make a guide but I did it anyway.

A helped a few people.

If you can't follow a guide step by step (which are precise and 100% complete), then, don't make a server.

Learn a bit in Database SQL (for MSSQL) then how does an emulator works with the DB and Client-Server Side and then come back.
I could have made a guide like that for normal people :
Step 1 : Extract DB in MSSQL
Step 2 : Put the write informations in the config files
Step 3 : Configure the client

But I didn't. I made a guide for big noobs because that makes me remember when I started to learn programmation and make my first server.

(Just for you to know, I made my dragonica server 1.5 year ago, it was the 0.13.12 version. I left all programming project and I played until now. Then, I didn't touch any script since a while and I anyway made a guide (by memories) and re-create a dragonica server 0.15.12 version within 2 hours without any help or guide. So, I think everyone can do it.)

That's it.

PS : Tell me which problem(s) you've got and maybe I'll answer to help you.
 
Last edited:
Newbie Spellweaver
Joined
Jan 7, 2012
Messages
11
Reaction score
1
I used your guide and i believe i have everything set, but i keep getting an error with the mmc when it runs. I believe thats the only issue im having. Everything in the database i left as it were. I made the sa account and configured it to the pw as shown. The only thing maybe is. Where the ADDR is, i put my SQL address there and it can be either that or the local IP right? I am not sure. If someone can confirm maybe i can fix it after all
 
Newbie Spellweaver
Joined
Jul 29, 2012
Messages
5
Reaction score
0
I have some problem: Do i have to coppy folder "translate ENGLISH" to "C:program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLBackup" ?. In step 12, if i want to make my sever in local, i won't change any thing, it it true?
I am very sorry because of my bad english, thank you so much for your help ^^.
 
Last edited:
Back
Top