Soldier Front 1 Server files

[hodias]

Re: Soldier Front 1 Release

work server and client?

 

[Shinnosuke Mvp]

Re: Soldier Front 1 Release

[h=2]SF Tutorials ?[/h]

 

[Shinnosuke Mvp]

Re: Soldier Front 1 Release

I want to run servers. Because I run a server file. exe it hidden?

 

[okarve0007]

Re: Soldier Front 1 Release

I want to run servers. Because I run a server file. exe it hidden?

Read this https://forum.ragezone.com/f857/soldier-front-1-release-1053131/index4.html

 

[HolyShift]

Re: Soldier Front 1 Release

plzzz share some Tutorial for restoring all the database

 

[Gabirieu]

Re: Soldier Front 1 Release

To work fine, need start Apex

 

[HolyShift]

Re: Soldier Front 1 Release

To work fine, need start Apex

can u share us the steps on how to restore its database?

​

 

[sfteam2015]

Re: Soldier Front 1 Release

HELP me TUTORIAL plss....

 

[Shinnosuke Mvp]

Re: Soldier Front 1 Release

Help me!

 

[sfteam2015]

Re: Soldier Front 1 Release

bro can You Help me on how to set up in DATA BASE?
please..



I WILL NOT CREATE SF SERVER. but I WILL CONNECT ON THE OTHER MEMBER WHO CREATED SUCCESSFUL. SEND ME A LINK AND I WILL CONNECT ON YOUR SERVER THANKS.



Send me the GAME CLIENT of your SERVER and I WILL CONNECT

 

[das11501]

Re: [Release] Soldier Front 1 Server files

i want Client use apex protect now i can play game now bug new part

 

[Naty48]

Re: [Release] Soldier Front 1 Server files

well , apex is easy to start..

if you debug using IDA or OLLYDBG you can figure out why it crash in 3~ minutes (HINT Computer Date...) .

now this bloody "Try Again" Error on channel entry because of Packets missmatch :

17:55:32 1. pAddress: , pPort:
17:55:32 Authentication Initialize Error
18:11:06 country: USA

and the cause :

15:03:08 15:03:08 USN: 0, IP:109.226.21.89 [INFO] [LOGIN] Different client session

also does anyone have client version 526 (in Version.ini)

or anything close to that ?

sems like the database version is 526 , server files version is 3001/3033, and clients are 1027/10XX .

can anyone confirm a working USF (526/30XX) client ? (from around august 2013 client)

 

[xrickztahx]

Re: [Release] Soldier Front 1 Server files

well , apex is easy to start..

if you debug using IDA or OLLYDBG you can figure out why it crash in 3~ minutes (HINT Computer Date...) .

now this bloody "Try Again" Error on channel entry because of Packets missmatch :

17:55:32 1. pAddress: , pPort:
17:55:32 Authentication Initialize Error
18:11:06 country: USA

and the cause :

15:03:08 15:03:08 USN: 0, IP:109.226.21.89 [INFO] [LOGIN] Different client session

also does anyone have client version 526 (in Version.ini)

or anything close to that ?

sems like the database version is 526 , server files version is 3001/3033, and clients are 1027/10XX .

can anyone confirm a working USF (526/30XX) client ? (from around august 2013 client)

Great! if its work fine to me then i will share the client to you.

 

[Bola]

Re: [Release] Soldier Front 1 Server files

well , apex is easy to start..

if you debug using IDA or OLLYDBG you can figure out why it crash in 3~ minutes (HINT Computer Date...) .

now this bloody "Try Again" Error on channel entry because of Packets missmatch :

17:55:32 1. pAddress: , pPort:
17:55:32 Authentication Initialize Error
18:11:06 country: USA

and the cause :

15:03:08 15:03:08 USN: 0, IP:109.226.21.89 [INFO] [LOGIN] Different client session

also does anyone have client version 526 (in Version.ini)

or anything close to that ?

sems like the database version is 526 , server files version is 3001/3033, and clients are 1027/10XX .

can anyone confirm a working USF (526/30XX) client ? (from around august 2013 client)

don't forget patch server is included with release, you can find server and client match inside

 

[xrickztahx]

Re: [Release] Soldier Front 1 Server files

don't forget patch server is included with release, you can find server and client match inside

Thankyou Bola! the server works fine

 

[Bola]

Re: [Release] Soldier Front 1 Server files

Thankyou Bola! the server works fine

share with comunity your server method if is possible, people will be grateful for you

 

[das11501]

Re: [Release] Soldier Front 1 Server files

apex server auto close help

Loadserver
2015-12-16 13:35:53>ServerLoad Run , Ver:0321,Build:Sep 24 2012
2015-12-16 13:35:53>AHLoadServer No Open CtrlPort
2015-12-16 13:35:54> In sh_load_start ,WaitUnPakConfig2,1
locklog
13:35:54> zzz:axupdate build:;getCfgFiles: 0,1,1
MainServer
13:35:54>Authorized >2012-10-31
13:35:54>MainServer Exit
NetServer
2015-12-16 13:35:53 >NetGMSG4704):>AHNetServer Build:Sep 24 2012
2015-12-16 13:35:53 >NetGMSG4704):>AHNetServer start....
2015-12-16 13:35:53 >AHNetServer :0.0.0.0-15306
2015-12-16 13:35:54 >NetGMSG4704):>CHSStart OK

 

[Naty48]

Re: [Release] Soldier Front 1 Server files

apex server auto close help

Loadserver
2015-12-16 13:35:53>ServerLoad Run , Ver:0321,Build:Sep 24 2012
2015-12-16 13:35:53>AHLoadServer No Open CtrlPort
2015-12-16 13:35:54> In sh_load_start ,WaitUnPakConfig2,1
locklog
13:35:54> zzz:axupdate build:;getCfgFiles: 0,1,1
MainServer
13:35:54>Authorized >2012-10-31
13:35:54>MainServer Exit
NetServer
2015-12-16 13:35:53 >NetGMSG4704):>AHNetServer Build:Sep 24 2012
2015-12-16 13:35:53 >NetGMSG4704):>AHNetServer start....
2015-12-16 13:35:53 >AHNetServer :0.0.0.0-15306
2015-12-16 13:35:54 >NetGMSG4704):>CHSStart OK

already explained...

2015-12-16 13:35:53>ServerLoad Run , Ver:0321,Build:Sep 24 2012

your answer is right there! , everything you need to know .

[Set your computer to 24/07/2012 or any date in 2012~2013 ]

Thankyou Bola! the server works fine

Pics or It Didn't Happen ...


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

well , after a damn hour i have created a query which clears the database (wipe all users data) and make it clean .

use [GmDB]go
truncate table gactionlog
truncate table gm_action_log
truncate table gm_adminauth
truncate table gm_login_log
truncate table sf_cu
truncate table sf_daily
truncate table sf_daily_backup


use [ClanDB]
go
truncate table BAK_guild
truncate table channel_war_detail_log
truncate table channel_war_invade_log
truncate table channel_war_snapshot
DELETE FROM guild
DBCC CHECKIDENT ('ClanDB.dbo.guild',RESEED, 0)
truncate table guild_info
truncate table guild_layer_mark
truncate table guild_member
truncate table guild_web_schedule
truncate table team
truncate table team_member
truncate table TMP_DEL_CLANLIST


use [age_account]
go
truncate table account_login
truncate table accounts
truncate table accounts_migration_log
truncate table accounts_migration_log2
truncate table age_sfus_remigration_log
truncate table age_UserLogins
truncate table T_USER_STATUS


use [logdb]
go
truncate table sf_log
truncate table sf_game_log


use [MsgDB]
go
truncate table sf_user_friends
DELETE FROM sf_user_rep


use [RankDB_USA]
go
truncate table clan_high_ranking
truncate table clan_high_ranking_tmp
truncate table clan_league_daily_ranking
truncate table clan_league_daily_record
truncate table clan_league_total_ranking
truncate table clan_league_total_record
truncate table clan_ranking
truncate table clan_ranking_tmp
truncate table event_sf_open_multiidc_stamp
truncate table monthly_clan_ranking
truncate table monthly_clan_record
truncate table monthly_user_ranking
truncate table pub_user
truncate table rank_result
truncate table sf_character_ts
truncate table tbl_ranking_process
truncate table team_ranking
truncate table tmp_user_ranking_f
truncate table tmp_user_ranking_h
truncate table tmp_user_ranking_m
truncate table tmp_user_ranking_t
truncate table user_point
truncate table user_point_view
truncate table user_ranking
truncate table user_ranking_deleteme_20080220
truncate table weekly_clan_ranking
truncate table weekly_clan_record
truncate table weekly_user_ranking
truncate table weekly_user_record


use [GameDB]
go
truncate table age_ItemInsert_TxnLog
truncate table event_back2school
truncate table event_boa_evil_ranking
truncate table event_boa_good_ranking
truncate table event_boa_total_killcnt
truncate table event_boa_user
truncate table event_gug_bonus
truncate table event_gug_bonus_work
truncate table event_gug_mission
truncate table event_referral
truncate table event_sf_halloween
truncate table event_sf_open_multiidc_stamp_gamedb
truncate table sf_arms
truncate table sf_capsule_use_log
truncate table sf_character
truncate table sf_character_old
truncate table sf_clan_items_inventory
truncate table sf_clan_items_log
truncate table sf_clan_items_name_change_request
truncate table sf_consecutive_log
truncate table sf_cut_log
truncate table sf_defend_event_detail
truncate table sf_defend_event_total
truncate table sf_enchant_log
truncate table sf_event_dufflebag
truncate table sf_event_log
truncate table sf_event_status
truncate table sf_exp_log
truncate table sf_freesalary_log
truncate table sf_game_log
truncate table sf_general_env
truncate table sf_item_ware
truncate table sf_itembuy_log
truncate table sf_itembuy_log_cancel
truncate table sf_itemuse
truncate table sf_itemuse_20090112
truncate table sf_log
truncate table sf_nick
truncate table sf_nickchange_log
truncate table sf_playtime_event
truncate table sf_pointchange_log
truncate table sf_price_change_log
truncate table sf_rank_log
truncate table sf_sp_itembuy_log
truncate table sf_sp_itembuy_log_cancel
truncate table sf_sp_itemrepair_log
DELETE FROM sf_user
truncate table sf_user_gift
truncate table sf_ware
truncate table ssk_tmp
truncate table TMP_GET_30DL
truncate table TMP_GET_30DL_ERR
truncate table TMP_GET_PDL
truncate table TMP_ITEMBUY_11G
truncate table TMP_ITEMBUY_11G_30DL_O
truncate table TMP_ITEMBUY_11G_30DL_X
truncate table TMP_ITEMBUY_11PWB
truncate table TMP_ITEMBUY_11PWB_PDL_O
truncate table TMP_ITEMBUY_11PWB_PDL_X
truncate table tmp_itembuy_log_cancel
truncate table tmp_itembuy_log1
truncate table tmp_itembuy_unlimited_all
truncate table tmp_itemuse_org
truncate table tmp_itemuse_step1_done
truncate table tmp_itemuse_step2_done
truncate table tmp_itemuse_unlimited2
truncate table tmp_itemuse_unlimited2_1014_usn
truncate table tmp_itemuse_unlimited2_1015_usn
truncate table tmp_itemuse_unlimited2_1022_usn
truncate table tmp_itemuse_unlimited2_1031_usn
truncate table tmp_itemuse_unlimited3_1014_usn
truncate table tmp_itemuse_unlimited3_1015_usn
truncate table tmp_itemuse_unlimited3_1022_usn
truncate table tmp_itemuse_unlimited3_1031_usn
truncate table weekly_clan_ranking
truncate table weekly_clan_record
truncate table weekly_user_ranking
truncate table weekly_user_record

hope it will help someone .


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

 

[xrickztahx]

Re: [Release] Soldier Front 1 Server files

apex server auto close help

Loadserver
2015-12-16 13:35:53>ServerLoad Run , Ver:0321,Build:Sep 24 2012
2015-12-16 13:35:53>AHLoadServer No Open CtrlPort
2015-12-16 13:35:54> In sh_load_start ,WaitUnPakConfig2,1
locklog
13:35:54> zzz:axupdate build:;getCfgFiles: 0,1,1
MainServer
13:35:54>Authorized >2012-10-31
13:35:54>MainServer Exit
NetServer
2015-12-16 13:35:53 >NetGMSG4704):>AHNetServer Build:Sep 24 2012
2015-12-16 13:35:53 >NetGMSG4704):>AHNetServer start....
2015-12-16 13:35:53 >AHNetServer :0.0.0.0-15306
2015-12-16 13:35:54 >NetGMSG4704):>CHSStart OK

Dude did you try to check the logs? if no then check it it will help you to fix the problem and also backread on Page 10 or 11.

well

21:08:25 [FATAL] [SYSTEM] [1] LoginServer(IP: 127.0.0.1) Packet(ID: 11) Error!!

i am looking for this crappy bug

 

[Naty48]

Re: [Release] Soldier Front 1 Server files

new thread for development:

https://forum.ragezone.com/f856/development-soldier-front-windows-binaries-1088212/