[Development] Soldier Front [WINDOWS][BINARIES ONLY][MSSQL]

[Naty48]

Hey guys.


so it's been awhile and people kinda seize from soldier front development (THIS THREAD)
so i wanted to summarize and unit all downloads and knowledge available and work it out .

i have also created a group , you guys can join and create new threads in there.
it will be organized : GROUP LINK

---

Server Files :
Requirements:
Windows Server 2008R2 - 64 BIT (Works best but can be used on pretty much any windows 64bits)
RAM : about 2GB Should be more the enough.. (including MSSQL) .
CPU : 2 cores will do.
Database type and version : (Install included in the server files download , but i use MSSQL Server 2008 R2 [64 BIT] ) .


You must change your computer date to around 2012/08/08
FILES MUST BE RUN AS SERVICES OTHERWISE THEY WON'T WORK!

Downloads :
Server files + mssql install -
https://mega.nz/#!8FVkASqJ!UX9N4SVukNrZJYcR9mIk3A-QiY3XDtZVFgxwBXAYVgQ
​

---

Client :

no too much details yet.... , game server shows T1.89_2
server files seems from between 2013/04/17 and 2013/08/08
the only client that we could actually log with is USF_20130717.zip (just unrar it , change ip,copy options folder to webserver ROOT /USA/* and change ip+patch server.

then copy the file from the client called update.u and copy it to webserver root\SoldierFrontUS\release\*
edit USF_20130717\avital\config.ini the url section
URL1=http://YOUR SERVER IP/SoldierFrontUS/release/

Now the client apex (gameguard) is conencted to your server and not being updated via the official server.

Downloads :

soldierfront_us_installer_20120720.exe

soldierfront_us_installer_20130426.exe

USF_20130717.zip​

---

HOW TO USER SERVER FILES :

#1. Copy Server file to C:/ like that :
 - C:/DMSystem
 - C:/SF_ServerConfig
 - C:/ApexServer
the Other file doesnt metter where..

#2. Config all configure file :
 - Change IP Address in all config file.
 - C:/DMSystem/*
 - C:/SF_ServerConfig/*
 - C:/ApexServer/*

#3. Restore database files .

#4. Config the ODBC Data Source files in  - C:/SF_ServerConfig/*.dsn 
(just change the instance name/server name , users are built-in and will work out of the box !) .
 
#5. Goto C:/DMSystem and open ServiceInstaller.exe
 
 - Drag Server File .exe   C:/SF_ServerConfig/*/*.exe to ServiceInstaller and Create Service.
 -  Start all SF Server Service.

create a new file anywhere ( i choose c:/SF_ServerConfig) called open.bat and fill in this :

sc start SF_GameServer
sc start SF_LoginServer
sc start SF_CheckOverlapServer
sc start SF_SessionServer
sc start SF_AdminServer
sc start SF_ClanChatServer
sc start SF_MessengerServer
sc start SF_LauncherServer
sc start DM_Server
sc start DM_Client

save it , and run it.

then open AHNetServer.exe .
*in order to open AHNetServer.exe you must change your computer date to around 08/08/2012

and then open MC_Tool.exe and use the username and password as follow :
Username = archonus
Password = gurisa

make sure all server files are running (should be blue not red in the MC_Tool) .

---

How to use the client (we dont sure yet its correct ofc!) .


If you want to connect your client to your server you need to edit
*quietusvs.ini to your IP
==>> How to Connect Launcher<<==
*install appserv/xampp/any other webserver
*Create New Folder in the root folder called "USA"
*Go to client and Copy option folder and paste in www/USA folder
*Edit version.ini to your local address IP


soldierfront.exe "UID|HASH VALUE|USN|USERNAME"
ex : soldierfront.exe "6641|ff23f-3443-g334g-h66i-5yuf3-33rgb|145621|testuser"

UID = uid in accounts table.
HASH VALUE = MD5(usn|authstring) in T_USER_STATUS table.
USN = usn in accounts table.
USERNAME = Username on use login or find on name field in accounts table.

---

How to create account :

INSERT INTO [age_account].[dbo].[accounts] ([uid],[name],[pass],[created],[updated]) VALUES (userid,'username','hashedpass','creationtime',NULL)GO

INSERT INTO [age_account].[dbo].[accounts] ([uid],[name],[pass],[created],[updated]) VALUES
(50000,'testUser123'
,'$2a$10$6a64a60418f63acd895aeuC0MVfsH0TwA3CFSPFESLtWX.Znz76Ha'
,'2015-04-12 16:18:49.540',NULL)
GO

user: testUser123
pass: test

or use the attached script (password.php.txt) in php to create your own password hash .

---

latest results is :

[/SIZE]

Everyone stuck in this screen , we get error on select Server .

---

CURRENT ISSUES :

1. AdminTool.exe showing that gameserver is offline .
2. we dont sure what is the correct client version .
3. we have that wierd error "Hacking account" on login (which i belive gives the error in server selection screen ) .
4. Logs showing : "02:59:01 [FATAL] [SYSTEM] [1] LoginServer(IP: xx.xxx.x.xx) Packet(ID: 11) Error!!" and then a DC Happens . (packet structure aint correct ?)

---

[STRIKE]what i think we need to do.

use the soldierfront_us_installer_20120720.exe client , update it to from 120817 to 130220_APEX
and then to try.. , it should be 100% matched client & server since all binaries are there (client,server,apex,etc) .

the only problem is probably the database (but im pretty sure it wont be a problem anyway .. ) .[/STRIKE]

well.. i tried that now.. same error ...:glare:
"04:13:58 [FATAL] [SYSTEM] [1] LoginServer(IP: xxxxxxxxxxxx) Packet(ID: 11) Error!!"

probably something with the server type (ALPHA/REAL/ETC) AND GameType(0/1/2) .

i will try debug the login server ..

---

you have an issue ? - POST IT HERE , I will try my best to answer it.

what i dont have time to are people who ask stupid questions like "what is odbc or how to restore database , or any questions that showing off inability to self lern .

ONLY PEOPLE WHO ACTUALLY KNOW WHAT THEY ARE DOING OR ATLEST ATTEMPTS ARE WELCOMED TO POST .

---

attached below :

wipedata.sql.txt - execute this query in the database and it will wipe all old users logs and data .

a few notes .

- All tables indexes has set to ZERO .
- All tables which containes gamedata (not users log/data) are remained untouched.
- IP And server name must be edited at : GameDB.dbo.sf_min_cu

- table which not truncated (couldn't verify if needed or not 100%) :

age_account.dbo.age_TrackerCheckpoints


- Queries has been checked by me - everything still works correctly.
- New users must be created (it will delete all old ones)
- GM Tables with basic info remained untouched (can be used for learning once we figure out how to create our own) .


hope we will find out how to get the client and server files up and running .

i will keep update more about new stuff..

Credits :

#Bola
#supergoudvis
#LegendOfCr33D
(maybe i forgot some credits , let me know i will be happy to add them!).

thanks for everyone who contributed .​

 

[Gabirieu]

GOOOOD MAN!!!, Finally the guys will solve the problem :w00t:
Thanks ;D

 

[Naty48]

well , today i found out how to get the exact same version for server side and client .

i used the client soldierfront_us_installer_20130426.exe
and i patched the server files from scratch from 120610 to 130417 , i applied server side (apex + binaries) only .

seems that its exactly the same version client as it suppose to be since i looked at datafilelist.txt and crossed it with all the patches applied - so client can stay as-is! , without any changes .

now there is only one problem.. , it gives me this error :

14:48:50 14:48:50 USN: 0, IP:xxx.xxx.xxx.xxx [INFO] [LOGIN] Different client session

which i figured out how it works.

each soldierfront.exe has a version from session which you can setup at

LauncherServer.ini
------------------------
ClientVersion=3001

and

SF_SessionServer.ini
------------------------
ClientVersion=3033 (im 99% sure its that value..) .

the thing is.. i used wireshark and looked over the values.. seems it encrypted value.. (md5)

if some one can help me find out the value or jmp/null that in SF_SessionServer.exe (which i cloudn't locate yet by myself..).

i think we will be able to 100% login and i will upload the server files if i can get it work.

---

well.. a few more debugs on the error..

the function offset : 00409590 (Packet Validation)
the error push to log offset : 0040EE63


and the actual issues starting here :

004053CF it compares below with a few strings , and if it wont be equal it will be JMP to Disconnect function..

i will now attempt to patch it and try again.

-- FAILED --

it will just crash the client without giving the DC error.

seems like more validations are done..

well we gotta to figure the client session version .


well. packet id 11 means SF_VALIDATION_ACK .


enum SessionServer_LoginServer_ProtocolList
{
SF_VALIDATION_REQ = 0xA,
SF_VALIDATION_ACK = 0xB,
SF_GAMESERVERLIST_REQ = 0xC,
SF_GAMESERVERLIST_ACK = 0xD,
SF_GAMESERVERIP_REQ = 0xE,
SF_GAMESERVERIP_ACK = 0xF,
SF_PROCESSINGUSERCOUNT_REQ = 0x10,
SF_PROCESSINGUSERCOUNT_ACK = 0x11,
SF_RELOGINUSER_REQ = 0x12,
SF_RELOGINUSER_ACK = 0x13,
SF_CONNECTCLOSEUSER_NOTICE = 0x14,
SF_EXPIRATIONUSER_NOTICE = 0x15,
SF_SL_GALAXYSERVER_REQ = 0x16,
SF_SL_GALAXYSERVER_ACK = 0x17,
};

i will now build some sort of packet analayzer and i will try to figure the stucture and the actual problem .

 

[Gabirieu]

hey my friend, can you help me, I am not able to configure SQL again, what User created and which database restore

 

[Naty48]

hey my friend, can you help me, I am not able to configure SQL again, what User created and which database restore

well.. i just stated above that i dont have time for this kind of questions , if you cannot restore the database how can you help us in anything ? .. you better wait for a complete release .

anyway a small guide:

login to mssql using SA user (using your password or windows auth)

resotre the .bak files from the backup folder (the .trn files are not necessary which those are transactions log).

---

found out something new..


Launcherserver produce this log with the "try again" error :


02:17:27 [0] Packet parsing : 9002
02:17:27 [ACCOUNT HACKING] [STEP1] IP:{MYIP} ID:1 ACCOUNT:gmdevo, PW:{MYPASS}, TYPE:1
02:17:27 [ACCOUNT HACKING] [STEP3] IP:{MYIP} ID:1 USN:2107257, AERIA_ID:26925
02:17:27 ConductQuery::GetUserAccount_Result: 2107257|EC8B322D-F321-4CDB-B26E-767D1EEC27BE|26925

after a analyzed the packets a bit -
9002 = 0x232A which is LAUNCHER_REQ opcode .

 

[Gabirieu]

I was among the first to make the server run, but every time the same mistake "try again" aí give up, now I want to try again..



When i Open ch, i get this erro,..

If you help me i will try To solve this too.
das is trying with me.

 

[BooGod]

I am starting to try open this new server, after I see that phillipines did created one private I want do one for USA and EU only, so if anyone wants to join me to make this happen I will be glad to you be Game Master.
My skype is: kelfrensouza
My email is: kelfrenmsbf@gmail.com

I already have a server, just need someone that have skills needed as thread asks.

 

[Naty48]

@Gabirieu , this is the error everyone has -_- , thats what i written above and it happens since the packets from soldierfront.exe dont match to the launcherserver.exe and sessionserver.exe .
BooGod , you have any experience in RE or osi model in depth (for networking) ?
otherwish if some one "helps" you to do it .. he pretty much doing everything and a DEDI/VPS everyone can afford today.

dont use it as a leverage.

and please guys DONT send me a private message or keep asking me to join to your skype unless you have actual knowledge that may help us .

good luck for those who actually contributed .