Private Server: GrandChase

Files:
SQL Server 2005 x86/x64: click for 2005 universal.
...or...
SQL Server 2008 x86: click for 2008 x86.
...or...
SQL Server 2008 x64: click for 2008 x64.

Databases: click here. it's a button. i think.

The log database: click. NOWWWWWW.
Password: WiNdOwSxP-Db0ByHeHeTrI
Use SQL Server 2005 or 2008. I use 2008.

Server files that are "desbugados": crick here

Extract all of them, and then use this (it's a link) and replace the GameServer files in the other "desbugados" ones.

DarkStronge's "even more debugged" files: u gunna criek heer??

-------------------------

Configuring the database:

Install SQL Server and the Management Studio*.
*should be included

Here's a hint for the next part: hashcalc.

Open up a new query, and then type:

Code:

USE [gc]
INSERT INTO [dbo].[ClientChecksum] (ProtocolVer, Checksum, RegDate)
SELECT 321,0xCRC32HERE,CURRENT_TIMESTAMP

...and then execute it.

Now replace everything with:

Code:

SELECT cast(checksum AS bigint) as rtxt FROM dbo.ClientChecksum

-------------------------

Creating a user:

Here's a hint with the MD5 part, again: hashcalc.

Open up the dbo.users table. (Right click + Edit)

Choose "text string" in hashcalc and then type in your password in the text box where it says data. Now select MD5 and click calculat

Type in your username in the column that says ID.
Use that MD5 thing as your password.
Change your GP in gamepoint.
Type something random into email.

You're done.

-------------------------

ConnectStatusDB:

Right click + edit.
Delete everything else except the first one.
Edit your server name, and change your server IP to your local IP. (Hint: cmd+ipconfig)

You're done.

-------------------------

msg database:

Open MsgRouterList.
Change your IP.

Open MsgServerList.
Input these:
UserNum 0, IP (your local IP), Port 9300, ProtocolVersion 215

You're done.

-------------------------

ODBC:

Now go into your folders and edit the odbc dsn files with notepad/wordpad.
Edit it. It's self explanitory. Change the "PW" part to your password. Change the "Server" part to your "instance" name. (example: .\SQLEXPRESS or WAFFLE-PC\SQLEXPRESS)

-------------------------

GameServer:

Open config_server.lua.

Change the IPs to your local IP.

-------------------------

Running the server:

Open them up.

-------------------------

Client:

Use the IPU client. It'll be decrypted already. Probably.
Hotfile.com: Размещение файлов в один клик: IPUGC.exe
Use a hex editor like HxD and then find LoginServerIP. Change the IP after that.

-------------------------

Creating a nickname for your user:

Go into NickNames. It's a table.
Put your info in.

-------------------------

Running the client:

Create a bat file with:

Code:

main.exe __kogstudios_original_service__

-------------------------

Credits:

hehetri/lucasmf2507 - the sql server 2005 database :D
Kei - the original tutorial
not me - because I leeched this
DarkStronge/iLek - creating the even more debugged files (the "almost everything works" files)
Divine/Divin3 - for allowing this to be released <3

iceblade112
Ragezone

Create a GrandChase Server (Use BR Client)

Requirements:
brain.exe
Downloads
YOU MUST USE Windows XP - HIGHER WILL NOT WORK

Downloads:
GrandChase Related Files:
GC Client(BR, Season 1)

.RAR Pack/Server Files

Other Related Files
SQL Server 2005 - x32/x86

Navicat Lite

Lots of you have errors, server errors, client errors, and straight up to having no server in the Server List.
So, this is the tutorial.
(I saw nothing that said to install Microsoft Loopback Adaptor in shining's tutorial... sorry I have to post this!)

Alright.

Download the files.
In SQL Server 2005, select your version of Windows, sorry about Mac, I dunno how to do that. Use Parallels or something.

1.Install SQL Server 2005 with a password (SQL Mixed Mode), be sure to put that in, leave the instance name as it is (SQLEXPRESS).

2.Install Navicat.

3.Open up Navicat.

If you have made it through this, you don't have no brain.

4.Create a new connection. Use SQL Server.
You may be asked to install SQL Native Client, but it's one of the rare things.

5.Put in your details.

6.Create databases gc and stat. You don't need web. Web is useless.

7.Restore the Databases. Search up a tutorial if you don't know what I mean.

8.Go to gc, and find ConnectStatusIP. Stay there!

9.Go to Control Panel, Classic View and click Add Hardware.

10. Press Next, and then wait, after that, click "Yes, I have already connected the hardware."

11.Select Add a New Hardware Device from the bottom.

12.Click the one that says "Install the hardware that I manually select from a list (Advanced)".

13.Select Network Adapters.

14.Find Microsoft, then find Microsoft Loopback Adapter, then install it.

If you have made it this far, you are not that stupid/not a noob.

15.Go to that connecting computer thing on the taskbar part next to your time, then that should open settings, go to Properties, and select Internet Protocol (TCP/IP).

16.Click "Use the following IP address:", then in IP address, type in 1.2.3.4 and in Subnet mask, just click it.

17.Apply it and type in 1.2.3.4 in all of the boxes with the row that says something like "ServerIP". In ExtraFlag, type 215 for all of them.

18.Do what you just did with MsgRouter and MsgServer, same with the 215 part.

Heheh... you really aren't stupid now if you made it through.
Well, lets config the DSN files.

19.Open up GameServer, open up the .dsn files with notepad and in Server= part, type in the server name in SQL Server.
Don't touch anything else.

20.Same with the ones in the other folders. In GameServer, you aren't done. Open up Config_Server.lua with Notepad, and find:

Init_NCashBillingInfo ( 'SeuIP', 9500, 5, 4, 'odbc_internal.dsn')

21.Find "SeuIP" and type in your IP there.

Go back to the folders, and open up StartAll.bat, and you should be good to go!

If it doesn't say something with LUA on the bottom, you did something wrong! D:

Alright.

1.Lets go hex the game.

2.Replace the main.exe from the .rar file to the one in your client.

3.Open the main.exe up and find LoginServerIP (with caps) in the hex editor.

4.Replace what is there with your IP and you are done.

Starting up the game...
Start main.exe with the arguments:
__kogstudios_original_service__

If i'm wrong, correct me!

END OF TUTORIAL

I may do a video... IF I have about 1,000 views and atleast 10 successful servers from this guide.

iceblade112
Ragezone

Private Server

Pages

GrandChase Season 2

GrandChase Server