I'm already there, I'm Mask
Install MSSQL Server 2019 and SSMS. Open
SQL Server Configuration Manager, go to the
SQL Server Network Configuration tab, under
Protocols for MSSQLSERVER and activate the
TCP/IP protocol. Click on the name of the protocol, go to the IP addresses tab and enable the address
127.0.0.1.
Restore the backups of each database, delete the already created logins with the name
saycf from each of them and create a login again.
The login name must be saycf and the password must also be saycf.
Map the saycf user to each database used by the server, configure them to use
dbo as their default schema, and set each of their member roles to
public and
db_owner.
Open the
CF_PH_GAME database, go to the
CF_MIN_CU table and edit the server IP and port to the IP you will use. Also edit the IP in the
TBOQAllowedIP table in the
MICROGAMESBILL_DB database.
Extract and copy the pmang folder to local disk
C: and run the
setup.bat file as administrator. Copy the
gDBGW.ini and
DBGWMGR.ini files from the pmang folder to the
C:\Windows\ directory.
Open the command prompt as administrator and run the command
sc create gDBGW binpath=C:\pmang\gdbgw\gdbgw.exe.
Still at the command prompt, run the command
C:\pmang\crossfire\cf_billsrv\BOQV3MicroGamesTx.exe -install, press enter when the console prompts for the Provider name, type the database IP and press enter (or press enter again to use the default value 127.0.0.1), type the database name
MICROGAMESBILL_DB and press enter again, type the database user name
saycf and press enter, type the password which is also
saycf and press enter again.
Configure the IP correctly in all server configuration files:
Code:
File: C:\pmang\crossfire\cf_alserver\AutoLeagueServer.ini Key: LISTEN_IP
File: C:\pmang\crossfire\cf_buddyrelay\ServerInfo.ini Keys: ServerIP and IP_1
File: C:\pmang\crossfire\cf_clansvr\ClanServer.ini Key: LISTEN_IP
File: C:\pmang\crossfire\cf_gamesrv\ServerInfo.ini Keys: PHBillingIPandPORT, ServerServiceForceIP, LoginMgmtIP, GameMgmtIP1 and GameMgmtExternalIP1, ClanServerIP, RelayServerIP
File: C:\pmang\crossfire\cf_gamesrv\HGWManager.dat Key: HGWM_IP
File: C:\pmang\crossfire\cf_hostsrv\Setting.ini Keys: GameServerAddr and MatchMakingServerAddr
File: C:\pmang\crossfire\cf_loginsrv\ServerInfo.ini Key: ServerServiceForceIP1
File: C:\pmang\crossfire\cf_loginsrv\HGWManager.dat Key: HGWM_IP
Press
Windows Key+R, type
services.msc and press enter. Look for the gDBGW service in the list and start it, start the other services right after. It is necessary to start the
BOQ Bill MicroGames Demon(Tx) service for cash/EC to work, but I still haven't found out why it isn't working for me even after configuring it.
The starting order is:
- gDBGW
- cf_gms/GameMgmtServer
- cf_alserver
- cf_buddyrelay
- cf_clansvr
- cf_GSM/cf_hostsrv
- cf_loginsrv
- cf_gamesrv
To create an account, simply run the
PROC_CREATE_USER stored procedure in the CF_PH_GAME database.
SQL:
USE [CF_PH_GAME]
GO
DECLARE @return_value int,
@p_Result numeric(10, 0)
EXEC @return_value = [dbo].[PROC_CREATE_USER]
@p_User_id = N'login', -- <-enter username here
@p_User_pass = N'password', -- <-enter password here
@p_Result = @p_Result OUTPUT
SELECT @p_Result as N'@p_Result'
SELECT 'Return Value' = @return_value
GO