I'll update this later. Probably in another post that works for SQL 2012.
I found that this server doesn't work properly if you're running the server on the same computer as the client. Try a virtual machine.
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??
main.exe: main.part04.rarmain.part03.rarmain.part02.rarmain.part01.rar
-------------------------
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:
...and then execute it.Code:USE [gc] INSERT INTO [dbo].[ClientChecksum] (ProtocolVer, Checksum, RegDate) SELECT 321,0xCRC32HERE,CURRENT_TIMESTAMP
Now replace everything with:
...and then copy the result. (the last one)Code:SELECT cast(checksum AS bigint) as rtxt FROM dbo.ClientChecksum
Put the result in between the parentheses of anything that says "Checksum" in config_server.lua. Only once, though. There should be 2 checksum parts.
-------------------------
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:
...and then run it.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 a lot
DarkStronge/iLek - creating the even more debugged files (the "almost everything works" files)
Divine/Divin3 - for allowing this to be released <3
Originally Posted by Divin3
