- Joined
- Aug 14, 2009
- Messages
- 1,097
- Reaction score
- 134
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:
...or...
SQL Server 2008 x86:
...or...
SQL Server 2008 x64:
Databases:
The log database:
Password: WiNdOwSxP-Db0ByHeHeTrI
Use SQL Server 2005 or 2008. I use 2008.
Server files that are "desbugados":
Extract all of them, and then use
DarkStronge's "even more debugged" files:
main.exe: View attachment main.part04.rarView attachment main.part03.rarView attachment main.part02.rarView attachment main.part01.rar
-------------------------
Configuring the database:
Install SQL Server and the Management Studio*.
*should be included
Here's a hint for the next part:
Open up a new query, and then type:
...and then execute it.
Now replace everything with:
...and then copy the result. (the last one)
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:
Open up the dbo.users table. (Right click + Edit)
Choose "text string" in
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.
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.
-------------------------
Credits:
hehetri/lucasmf2507 - the sql server 2005 database
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
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:
You must be registered to see links
...or...
SQL Server 2008 x86:
You must be registered to see links
...or...
SQL Server 2008 x64:
You must be registered to see links
Databases:
You must be registered to see links
The log database:
You must be registered to see links
Password: WiNdOwSxP-Db0ByHeHeTrI
Use SQL Server 2005 or 2008. I use 2008.
Server files that are "desbugados":
You must be registered to see links
Extract all of them, and then use
You must be registered to see links
and replace the GameServer files in the other "desbugados" ones.DarkStronge's "even more debugged" files:
You must be registered to see links
main.exe: View attachment main.part04.rarView attachment main.part03.rarView attachment main.part02.rarView attachment main.part01.rar
-------------------------
Configuring the database:
Install SQL Server and the Management Studio*.
*should be included
Here's a hint for the next part:
You must be registered to see links
.Open up a new query, and then type:
Code:
USE [gc]
INSERT INTO [dbo].[ClientChecksum] (ProtocolVer, Checksum, RegDate)
SELECT 321,0x[B]CRC32HERE[/B],CURRENT_TIMESTAMP...and then execute it.
Now replace everything with:
Code:
SELECT cast(checksum AS bigint) as rtxt FROM dbo.ClientChecksum...and then copy the result. (the last one)
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:
You must be registered to see links
.Open up the dbo.users table. (Right click + Edit)
Choose "text string" in
You must be registered to see links
and then type in your password in the text box where it says data. Now select MD5 and click calculatType 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.
You must be registered to see links
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__...and then run it.
-------------------------
Credits:
hehetri/lucasmf2507 - the sql server 2005 database
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
Last edited:
