, who plays more online games, I believe that I am familiar with the game Hot Blood Jianghu , get rid of the dark and bloody game style of traditional martial arts games and advocate a "bright and happy martial arts" spirit. The picture will not be too casual or too heavy, and the picture will be clean and fresh. The lively and cute character shapes and uses the character's Avatar system in appearance, changing various clothes and decorations according to different identities.
Today Aisi told you what you need to prepare for the passionate Jianghu SF
If you want to open a server, you need to prepare the server, server, SQL database
installation and operation library: Common support library Notepad++
DirectX installation program
Server: The server is what we call the version. From the beginning of version 1.1, there are only four professions: knife, gun, sword, and medicine. Version 1.7 has released a new synthesis system - attribute stone, version 2.0 has released a new map - Beihai Ice Palace, and version 3.0 has added a new profession - Assassin. Each player likes to play differently. If you don’t know how to choose a version, you can open the version you like to play the most. You are more familiar with the version and have more ideas during version testing. You can communicate with the technology to add special gameplay to attract players.
The entire process of setting up:
install the system according to the normal way,
Note: During installation, you must select to install IIS service (used to set up web services). After installing the system files, install the high-quality and correct hardware drivers
Install SQL server: Just install the SQL components. The
installation directory is best placed on disk D. The authentication method should use SQL.server to verify the identity. After installing
, be sure to restart the computer.
server configuration system Select Chiwang Naked Metal Server 16H32G 50M Windows Server 2019
server configuration determines the overall smoothness of the game and the player's gaming experience. You must put rice on the edge!
Prepare the server software: decompress the server and create a directory called DB in the server directory to store database files. (For example: D: \rxjh put the server file, and create a DB folder below it, with the path: d: \rxjh\db\)
Create a database: Open SQL's "Enterprise Manager" - select the server under 'SQL server group' in the dial on the left. [Note: XXX (windows NT) XXX represents the file name. The server should be working (there is a green arrow at the bottom right of the icon). If it does not work, please restart the SQI. service. If it doesn't work, reinstall SQL. )
Create rxjhaccount database, right-click 'Database' - select 'New Database' - enter the name 'rxjhaccount' in the general order - modify the file storage paths of 'data file' and 'transaction log' to: 'd : \rxjh\db\XXX', and then confirm. Use the same method to create two databases, rxjhgame and rxjhweb.
Restore database records, select ‘rxjhaccount’ database, click the mouse button - select ‘restore database’ in ‘all tasks’ - In the pop-up window, select ‘restore from device’, and then click the ‘select device’ button - Danshi ‘add’ press l--Select the original database ‘rxjhaccount’ of server-side leucorrhea’ and confirm to return to the restore database window - Click the options page, select ‘force restore’, and modify the path under the ‘Move to physical file name’ column in the following list to: d :\rxjh \db\XXX. ——Confirm to be completed. The same steps complete the restoration of the other two databases.
Add user 'Right-click 'Login' in 'Security' - select 'New Login' - enter the name in 'General'. For authentication, select ‘SQI. server authentication’ and enter the password—1 In ‘Server Role’, select ‘system Admiristrator’—In ‘Database Access’, select the three databases just built, and select the three roles public, db-owner, and db-accessadmin in the list below.
Modify server.ini file as follows: Use XXX to indicate where you want to modify SEVERNAME= Test server (to be consistent with the name in Server.inf) [ODBC];
Account database DSN information ACCOUNT_DSN =rxjhaccount ACCOINT_UID = XXX (name and password of the new user created above) ACCOUNT_PWD = XXX;
Role database DSN information CHAR_DSN = rxjhgame CHAR_UID = XXX (name and password of the new user created above) CHAR_PWD = XXX ;
Baibaoge database DSN information, WEB_DSN = rxjhweb WEB_UID = XXX (name and password of the new user created above) WEB_PWD = XXX [GAME] ;
Announcement for entering the game WELCOMEINFO =XXXXXXX (welcome something or something); Baibaoge's web access address WEBSHOP_ADDR =http : / / XXX.XXX.XX (IP address of your computer) /shop/login. Asp
Modify the serverlogin.ini file. [SERVER] PORT = 1300 port number [ODBC] ACCOUNT_DSN =rxjhaccount ACCOLNT_UID = XXX (name and password of the new user created above) ACCOUNT_PWD = XXX
Modify server.inf file Number = 1 Test server – number – 3 Test server – 1—XXX.XXX.XXX.XX (IP address of your computer) – 1–13000 Test server – 2—XXX.XXX.XXX.XX (IP address of your computer) – 2-13001 Test server – 3-XXX.XXX.XXX (IP address of your computer) – 3- 13002
Modify IcIoIn. asp file Sq1DatabaseName = "rxjhweb"SqlPassword = "XXX" (name and password of the new user created above) SqlUsername = "XXX"
Modify reg.asp file response.redirect "http:// XXX.XXX.XXX.XX.XX (IP address of your computer)/reg.asp"
Modify fun.asp file Host_Addr = "XXX.XXX.XXX.XX.XX (IP address of your computer): 9000"’Game server address
Modify conn. asp file SqlDatabaseName = "rxjhaccount" SqlPassword = "XXX" (the name and password of the new user created above) SqlUsername = "xXx"
Register the data source There is a 'data source.reg' file under the server-side file. Double-click to run it and add the data source.
set up an IIS web server. The operation is simple, so I won’t talk about
registration. After running the web page once, the prepared Sockettml2.dll file is copied to the same directory under WINGDOwS.
If the CPU occupies 100% solution~(local) First open the query analyzer and select rxjhgame library to execute the following
SQL statement Immediately if you think it still occupies more and execute update TBLEXP set FLDEXP-FLD_EXP/2update TBL_MONSTER set FLD_EXP=FLD_EXP/2 update TBL_NPC set FLD_EXP-FLD_EXP/2 into the game but the server is under maintenance...? CREATFTRTGER online_update 0N[dbo].[TBL_ONL.INE] FORUPDATF. AS if upda te (FL.D_MAXUSER) begin ROL.I.BACK TRANSACTION Fnd realizes automatic gifting of experience CREATE TRIGGER[song] ON [dbo].[TBL_Char] after Insert as Update [TBL_Char] setFLD_FIGHIT_EXP=100000 From Inscrded whenc[TBL_CHAR].FLD_ID=inscrded.FLD_ID and[TBL_Char]. FLD_NAME=inscrded.FLD_NAME updatcTBL charset
FLD_MENOW=101,FLD_X=613.6401,FLD_Y=365.9651 where FLD_ MENOW='0’update TBL_Charset FLD_FIGHT_EXP=100000 where FLD_FIGHT_EXP100000 Implement automatic gifting experience-automatic solution to card number problems FLD_FIGHT_EXP=100000 It is a 10W experience, you can modify the usage method yourself: Right-click on TBL_Char-all tasks-management trigger-correct it and paste it in TBL_Char Right-click on TBL_Char-all tasks-management trigger-correct it and paste it in to realize new characters 1000w money, give 100w experience CREATE TRIGGER[song] 0N[dbo].[TBL_Char]after Insert as Update[TBL_Char]set[TBL_Char].FLD_MONEY=10000000, FLD_FIGHT_EXP=1000000
Detailed explanation of the database is that there are a lot of content, the detailed introduction of each field will not be done this time. The following is the role of the tables in each database.Database rxjhaccount: TBL_ACCOUNT Save account information TBL_ONLINE saves the number of people online on the server, updates in real time, cannot modify TBL_BANED banned IP information, IPs added to this table cannot log in to the game, and wildcard database rxjhgame: TBL_CHAR role basic information TBL_WAREHOUSE Character warehouse information TBL_PUBLICWAREHOUSE Comprehensive warehouse information The above three tables cannot be edited when players are online (it is useless if they are edited) TBL_ITEM item data TBL_NPC monster and NPC refresh information (Chinese name modification is useless) TBL_MONSTER monster
short information, which is convenient for modifying monster ability values. It must be used with tools. There is no tool to modify useless TBL_MAP map information, which is not used yet, and it is convenient to query map number TBL_EXP upgrade requirements experience value setting TBL_KONGFU skill information TBL_DROP item drop information, FLD_PP is the drop probability, and must be less than 10000, otherwise only a certain item will be dropped TBL_OPEN box will open item information TBL_SELL The NPC sells items, the price is О means the database is executed according to the price of the items in TBL_ITEM rxjhweb:ITEMSELL Baibao Pavilion sells items information. Baibao Pavilion website program and game server must use
setup process:
Prepare the server software: decompress the server, and create a directory named DB in the server directory to store database files. (For example: D: \rxjh puts the server file, and create a DB folder below it, with the path: d:\rxjh\db\)
Install the system according to the normal way. During installation, you must choose to install IIS service (used to set up web services).
After installing the system files, install the high-quality and correct hardware drivers (or your system will be very slow)
Install SQL server
Just install SQL components. It is best to place the installation directory on disk D. The authentication method should use SQL server to verify the identity. After installation, you must restart the computer.
prepares the server software
to decompress the server, and creates a directory called DB in the server's directory to store database files. (For example: D:irxjh puts the server file, and create a DB folder below it, the path is: dArxjh dbl
D: Create database
Create rxjhaccount database
Right-click 'database' - select 'new database' - enter the name 'rxjhaccount' in the general - modify the file storage path of 'data file' and 'transaction log' to: 'd:\rxjhldb\XXX', and then confirm.
create rxjhgame in the same way rxjhweb two databases.
Restore database record
Select 'rxjhaccount' database right-click - select 'restore database' in *all tasks' - In the pop-up window, select the restore method 'restore from device', and then click the 'select device' button - click the 'add' button - select the original database 'rxjhaccount' that comes with the server side and confirm to return to the restore database window - click the options page, select 'force restore', modify the following The path under the column ‘Move to physical file name’ in the face list is: d:Mrxjh\dblXXX. ——Confirm to complete.
The same steps are completed to restore the other two databases.
Add user
Right-click ‘Login’ in ‘Security’ – select ‘New login’ – enter the name in ‘General’. Select ‘HyperServer Authentication’ and enter the password – in ‘Server Role’, select ‘system Admin istrator'—In 'Database Access', select the three databases you just built, and select the three roles public, db-owner, and db-accessadmin in the list below.
Modify servergamc.ini file
The modification places are as follows: Use XXX to indicate where you want to modify
SEVERNAME=Test server (to be consistent with the name in Server.inf)[ODBC]
Account database DSN information
ACCOUNT_DSN - rxjhaccountml3
ACCOUNT__UID - XXX
(.The name and password of the new user created above)
ACCOUNT_PWD - XXX
Role database DSN information CHAR_DSN =rxjhgame
CHAR_UID = XXx The name and password of the new user created above).ComCHAR_PWD = XxX
Baibaoge database DSN information WEB_DSN = rxjhweb
WEB_UID = XXX(name and password of the new user created above)WEB_PWD = XXX
[GAME]
Announcement for entering the game
WELCOMEINFO= XXXXXXX (welcome something or something)
Baibaoge's web access address
WEBSHOP_ADDR = http://XXX.XXX.XXX.XXX (IP address of your computer)/shop/login.asp
