[Guide]Making a GrandChase Server

Page 1 of 3 1 23
09/20/2009 01:10 darkmik07#1
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. [Only registered and activated users can see links. Click Here To Register...] - Must download
  2. [Only registered and activated users can see links. Click Here To Register...] - Must download too
  3. [Only registered and activated users can see links. Click Here To Register...] - 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)

[Only registered and activated users can see links. Click Here To Register...]


[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]


Logs: config_mr.lua


[Only registered and activated users can see links. Click Here To Register...]

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

2nd: MsgServer

Protocols - config_msg.lua

[Only registered and activated users can see links. Click Here To Register...]

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

[Only registered and activated users can see links. Click Here To Register...]


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 [Only registered and activated users can see links. Click Here To 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
[LEFT]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:

[Only registered and activated users can see links. Click Here To Register...]

[LEFT]- 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.

Code:
You: Hey, where do I find the Items ID?
ShadowTH: At GoodsInfoList table!
[LEFT]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.

[Only registered and activated users can see links. Click Here To Register...]
Code:
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

Code:
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:

[Only registered and activated users can see links. Click Here To Register...]

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)~

Code:
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.
Code:
You: Hey, where do I put CASH in my account?
 
ShadowTH: Nobody knows yet!
Code:
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!


All Credits to ShadowTH


09/20/2009 03:46 zack_zi#2
what are lucrative finallities?
09/20/2009 06:12 PiReights#3
oh darkmik...

finally, you became a guard...

what made you drop here in gc section?

anyway, nice tutorial... :)

[MOVED]
11/30/2009 19:55 luke4life#4
Nice! gotta try soon when i have vacation!
12/01/2009 00:48 wolfgangjt#5
Nice guide, but one thing you could add is how good your computer must be to run a GC server (either for personal use or for public/private use).

Also, I am guessing that Cash is a part of the Ntreev site and the game loads the info from the site.

Proof:

I began torrenting stuff again recently and I redownloaded peer blocker (vista's peer guardian) and while it was on and un edited for allowance of stuff, I launched GC. After I allowed it to update, I got in game and noticed all my cash was gone. I then tried to load up the Ntreev site and could not load it up. I allowed all things popping up from playing GC and loading the site and re opened the shop in game and my cash was there. I reloaded the site and I was able to access the site.

So I am sure that the webserver handles cash and the game grabs the info from there and updates it real time.
12/01/2009 04:12 HlRYU25#6
i cant down load the 3 links :)
12/01/2009 04:15 HlRYU25#7
i cant down load the 3 link jejejejje
12/01/2009 05:19 sinpaktu#8
nc...but this is hard to do
12/01/2009 05:39 HlRYU25#9
the link is close jejejeje for me it easy
12/01/2009 06:01 jetro2009#10
theres any one try this hard to understand ahe
cool^^
12/01/2009 06:10 HlRYU25#11
ahahahahaha








[Only registered and activated users can see links. Click Here To Register...]

[Only registered and activated users can see links. Click Here To Register...]
12/01/2009 06:19 jervis#12
wahaha very long procedure xD!
12/01/2009 07:51 iSatan#13
Is the 3 links closed already? O___o
I cant download it
12/01/2009 09:46 portisheadz#14
the links don't open
12/01/2009 12:49 majina25#15
summary ahahah juk
Page 1 of 3 1 23