[Guide]Making a GrandChase server

[ShadowTH]

This tutorial was originally made by andreddj2 at RagezoneBR. I'm translating it to English, so that you don't have any doubts. Some things I'll add by myself.
Let's go!

1. Description
2. Files [Downloads]
3. Tutorials:

• Restoring the database
• Setting up IP's
• CenterServer
• GameServer
• MsgRouter and MsgServer
• Creating an account/ Hash/Adding items to the account
• Editing your character
• Increasing rates
• Turning on the server
• Frequently Asked Questions (F.A.Q)

~Description~​

I'm here to teach you how to make an GrandChase server. Although it's very hard, with this tutorial you are going to make it lightning fast!​

It's legal to make your own GrandChase server without lucrative finallities. You can be arrested under the law if you do so.​

~Files Download~​

Here are the files you'll need to download:

1. Server files - Must download
2. Databases - Must download too
3. Microsoft SQL Server 2005 Express - Necessary
   - SQL Server Management Studio Express
4. CZ GrandChase Client, because it's in English.

~Restoring the Databases~​

In order to restore the databases, you will need Microsoft SQL Server 2005 Express. I believe you've downloaded it.​

So, in order to do this, you must do everything correctly!​

Let's go:​

1st: Open your SQL Server Management Studio Express. Before, when you install it, you MUST install it as SQL Authentication Mode, or else it won't work properly.​

2nd: After logging in on SQL, click on Databases with mouse's right button, click on New Databases and create three new databases: gc, stat and web.​

3rd: After doing this, right-click on gc (the database you've just created) and click on Task → Restore → Database. Select the appropriate .bak file (gc database uses gc.bak, stat database uses stat.bak etc.). Do the same process to the other 2 databases (stat and web)​

After doing this, your databases are ready.​

Thanks to Black Khaos for the pics!​

~Setting Up IP's~​

Let's begin with the ODBCs, as they are hard to set up.​

Here is how it must be:​

[ODBC]
DRIVER=SQL Server
UID=SQL User
Address=127.0.0.1,1433
Network=DBMSSOCN
DATABASE=gc
WSID=xmlab-coolcopy
APP=Microsoft Data Access Components
SERVER=(local)
Description=brazil internal
PWD=SQL Password​

The odbc files ↑ are the following:

.\Server\GameServer\odbc_internal.dsn
.\Server\GameServer\odbc_stat.dsn
.\Server\Center\odbc_internal.dsn
.\Server\Center\odbc_stat.dsn

Now, open these files:

.\Server\GameServer\config_server.LUA
.\Server\GameServer\config_server.LUA~

Go to line 71 with Ctrl + G and edit like this:

Init_NCashBillingInfo( 'Your IP goes here', 9500, 5, 0, 'odbc_internal.dsn' )

Go to line 31 and remove these --

Let's now edit the IPs at the SQL:

Open those tables on the database gc:

ConnectStatusDB
MsgRouter*
MsgServer*

At ConnectStatusDB, you are going to need to create 2 servers if you are going to make an online server: one with the local IP and another with external IP.

*They are going to be explained later.

We are almost done with the IPs! Let's go to the next step:

~CenterServer~​

This program controls the "Login Server", ie, it controls the logins and passwords registered at the databases. I'll explain later how to create accounts. ​

This program uses ConnectStatusDB table. I've already taught how to set up this table.​

~GameServer~​

This program controls the characters, the missions, the PvPs, the EXP, so, everything you do in-game goes to it.​

I've already explained how to config config_server.lua and config_server.lua~​

~MsgRouter and MsgServer~​

These programs controls Friend List. If one of them or both aren't online, the Friends list won't work.​

Let's set up them, so:

1st: MsgRouter

Protocols: config_mr.ini

Logs: config_mr.lua​

The message on the second picture says: Change this: log( 2 ) to log( 0 )​

2nd: MsgServer​

Protocols - config_msg.lua​

We are done with MsgRouter/MsgServer. Let's move on to Accounts Creation!

~Creating an Accoun/Hash/Adding items to the account~​

Go to users table (gc database):​

LOGIN PASSWD SEX​

Explaining the Picture:

• Login column: Put the login you're going to use in the game​
• Passwd column: The passwords are criptografed in MD5. Use

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

  to put the password in MD5. Don't be afraid, your password is still the one you typed before.​
• Sex column: 0 for Male/ 1 for Female​

How to use Hash:

1st: Open Hash.
2nd: Choose MD5 where you see SHA1
3rd: Click on the First button, next to MD5.
4th: Put the password you want
5th: Copy and Paste the code generated.​

To add items, go to GoodsObjectList:​

- ITEMUID = Automatic. Don't need to fill it.
- OWNERLOGIN = Login of the person who will receive the item
- BUYERLOGIN = Login of the person who will receive the item
- ITEMID = Put the item's ID here
- REGDATE = Whatever date
- STARTDATE = Whatever date
- ENDDATE = Whatever date as well.​

You: Hey, where do I find the Items ID?
ShadowTH: At GoodsInfoList table!

Let's edit now the Characters, its experience, level..., shall we?

~Editing your character~​

Go to Characters table. There will be your Level, Exp, Win, Lose... You can just edit there and restart your game. It's not necessary to restart the server.​

You: How can I add Ronan, Lass, Ryan...?
ShadowTH: Simple! Just follow the example shown on the photo above.

CharType column:

0 - Elesis
1 - Lire
2 - Arme
3 - Lass
4 - Ryan
5 - Ronan​

You: How can I become 4th class without doing any tests?

Promotion column:

0 - 1st class
1 - 2nd class
2 - 3rd class
3 - 4th class​

Let's now increase the rates!​

~Increasing rates~​

Go to EventTimeLimit table:​

Explaining the picture:​

At StartDate, you put when you want to start the event that increases rate.
At EndDate, you put when you want to end the event that increases rate.
Put 1 at EventType, or else it won't work.
At GPRatio and EXPRatio, you put the rate you want to put (GP and EXP).
CommentID you put 0.​

~Turning on the server~​

Click on StartAll to turn on the server. It should have 6 windows opened. If you don't have 6 windows open, then you did a mistake somewhere. ​

~Frequently Asked Questions (F.A.Q)~​

You: Hey, everytime I try to log in, I get the following message: Hack detectado (Hack detected). What can I do??
ShadowTH: It might be a problem with your GameGuard or not much memory.

You: Hey, where do I put CASH in my account?

ShadowTH: Nobody knows yet!

You: Where do I edit the items?

ShadowTH: In the main.exe. As we don't have the proper tool to edit them, then we can't do it.

END!

====================================================================================​

Hope I helped you to make a GrandChase server.​

Thanks to andreddj2 and Black Khaos for the pictures. It helped me a lot!​

 

[phiber]

Re: Making a GrandChase server

like i say on the other post, if you want cash on your account, you must use the ncash daemon + billcrux db.
I dont remember exactly what tables have the coins becuse i do it 1 year ago, but you must edit 2 tables.

 

[ShadowTH]

Re: Making a GrandChase server

I got your point. I just did a better tutorial, more complete and with my own words.

The other one was translated by google. I can say this because I speak portuguese and I know how is the original topic.

As you said: We need N-Cash Daemon and BillCrux DB.

But, here's the question: Where can we find them out?

 

[chiosin2]

Re: Making a GrandChase server

nice post very nice.. but i have a problem when connecting.. it cant... what's the problem? should i use main.exe? but nothing happens.. @___@

 

[AkitoKunX]

Re: Making a GrandChase server

I keep getting that error on all my servers except TCP and UDP Relays. What did I do wrong?

Here's a thread I found with my problem (I think) Maybe you can translate it ^_^

BTW : Here is my OBDC on all of them

[ODBC]
DRIVER=SQL Server
UID=sa
Address=127.0.0.1,1433
Network=DBMSSOCN
DATABASE=gc
WSID=xmlab-coolcopy
APP=Microsoft Data Access Components
SERVER=(local)
Description=brazil internal
PWD=**** password censored


Thanks again,
~akito

 

[kirihara]

Re: Making a GrandChase server

well i got kinda bored so i made this server since i nvr played game >.>

nyway when i started the server... after few sec only 2 did remain... so i checked the logs... sum things regarding odbc..

cerr : KODBC::DriverConnect(), 2008-11-10 11:51:25, DriverConnect() Failed. Ret : -1
    m_strDSN : FILEDSN=C:\Users\AngeL\Desktop\Light 1017 SQL\Center\odbc_main.dsn
    (D:\Dev\KncGC\Common\Odbc\Odbc.cpp, 113)

so i checked the file in it > odbc_main.dsn < then on first look nothing seems wrong tough only this caused the problem > portugu饿 < so i set htat 2 english and then it started all fine o.o


edit: also my odbc looks way diffirent that urs...

[ODBC]
DRIVER=SQL Server
LANGUAGE=English
DATABASE=gc
WSID=xmlab-coolcopy
APP=Microsoft Data Access Components
SERVER=AngeL\GRANDCHASE
Description=Internal

 

[ShadowTH]

Re: Making a GrandChase server

[ODBC]
DRIVER=SQL Server
LANGUAGE=English
UID=sa (main sql user)
DATABASE=gc
WSID=xmlab-coolcopy
APP=Microsoft Data Access Components
SERVER=AngeL\GRANDCHASE -> Are you sure this is correct? It must be the name of your PC. Example: LUCAS-PC\SQLEXPRESS
Description=Internal
PWD=Your SQL pass goes here

This might help you with your error.

 

[kirihara]

Re: Making a GrandChase server

already solved it and yes "AngeL\GRANDCHASE -" is correct xD

 

[AkitoKunX]

Re: Making a GrandChase server

My problem still exists, can you help me?

 

[kirihara]

Re: Making a GrandChase server

well 2 me it seems ur prob is in those odbc files included with the server... check these files on any chinese signs... cuzz when i had sum chinese in it... server didnt start either...
and 2 be sure i manually created the odbc files in control panel.
so my server now is running perfect since last night... only gameserver crashed once...
btw... ill add my odbc files

 

[AKllX]

Re: Making a GrandChase server

Connecting to Server :

Use this Main

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

and Edit using HEX Editor
find Server_IP and change

~~

Poblems with ODBC can vary according to your MSSQL / The most usable is MSSQL 2000 but the server files work on 2005 .

1 - Remove the line Adress on ODBC config
2 - If you are using MSSQL 2000 , The line SERVER is the MSSQL comand : (local) , but if you are using MSSQL 2005 the driver is :

OSNAME\SQLEXPRESS Examples :

Home\SQLEXPRESS

PC-317C663BA4C3\SQLEXPRESS

3 - You need to change your MSSQL Windows Only connection to Mixed Mode ( Windows and SQL Server Authentication ) -- This can be changed on installation

Changing ~ ( I have only MSSQL 2000 )

Open Enterprise Manager .
Click on MSSQL Connection on Enterprise Manager ( is usually below SQL Server Group )
Right click and open Proprierits
Go to security tab and change Authentication
If your athentication is SQL Server and Windows you doesn't need to change it


~~

Creditz : Ragezone Brasil

 

[chiosin2]

Re: Making a GrandChase server

my MSG Server and MSG ROUTER Wont connect? i edited the one inside the ? and how do i disable the GAME GUARD? ANYWAY? is there a way to disable it?

and GameServer Closes everytime

 

[AKllX]

Re: Making a GrandChase server

change ip on tables MsgRouterList and MsgServerList .

 

[noobmigit]

Re: Making a GrandChase server

anyone upload the gameguard setup files for grandchase for me? i have problems

 

[DF08Said]

Re: Making a GrandChase server

thank You For This Guide!

 

[DF08Said]

Re: Making a GrandChase server

i got my Server Working and On.. is there any1 else who got 1 aswell?

 

[echaxxx]

Re: Making a GrandChase server

i got my server running...

now my problem..i cant find the ip address on the main.exe that im trying to hex...

 

[KillerStefan]

Re: Making a GrandChase server

i got my server running...

now my problem..i cant find the ip address on the main.exe that im trying to hex...

Kenzu and I think you made the Grand Chase server.
I'm already looking in the patcher cause Kenzu asked and I think I found it.
I'll send it to Kenzu tommorow.

 

[echaxxx]

Re: Making a GrandChase server

hehehe i just followed the instructions....and change some minor things like in the odbc files....no problems occur...i havent read any errors in all 6 servers when i press the start all...

@KillerStefan
thats nice and hope this guide will go in the "server developments" once the client is ok...nice guide^_^

 

[Abry]

Re: Making a GrandChase server

Wow, great guide and just the 1st time i saw this game.