Introduction to server setup tutorial

Set up the audition server. The required software is MySQL 4.0.26, MySQL 3.51.06, and MySQL-Front 3.1.

Let me explain the functions of the three software and their connection:
MySQLIs a pure database, it does not come with management tools (such as Enterprise Manager) as SQL Server 2000 ). note that MySQL must use versions earlier than MySQL 4.1. Both MySQL 4.0.26 and MySQL 4.0.24 can be used. this is because the password verification methods for database Versions later than MySQL 4.1 are different, resulting in the connection between the server-side program and MySQL versions later than MySQL, so do not seek new information, use MySQL4.1 or the latest MySQL5.1 to load databases.
MyODBCThe MySQL driver is installed in the data source Manager (Control Panel-> management tools-> data source (ODBC) in Windows, because for windows, mySQL is a third-party database (not developed by Microsoft as SQL Server), so the system does not have its own driver.
MySQL-FrontIs a database management tool that performs visualized operations on MySQL, just like the Enterprise Manager in SQL Server. You can perform basic maintenance operations on the database. 3.1 or 3.2 is recommended.

In the Server File, audition. SQL is a file that requires database restoration using MySQL-Front software. Audition. ipsec is the file to be imported in [IP Security Policy] of [local security settings] in windows. however, a known error is that if the file is imported to [IP Security Policy] and assigned, the computer will not be able to access the Internet (dizzy ~~~ -_-!), You need to focus on this document.
After the database software on the server is installed and the audition server program can be connected to the database successfully, the Client Login problem occurs, which is a very difficult problem.
Because we don't know what version of the client is corresponding to this server end, I have searched all the files on the server end, but there is no such information as the version.
However, we can clearly see the word AuditonAgenDBServe1_China_NativeMySQL from the title of the started server program. Please note the word "China. The MissionInfo. ini configuration file in the D: \ AuditionGameServer \ gameserver \ Data directory contains Chinese annotations. Whether the Chinese comment is commented by the 4f investigator after the outflow or before the outflow, cannot be determined. However, if it is the latter, this server file may flow out of the Chinese server, rather than from the Korean server. Later, I asked the Administrator and got a positive response. This server is outbound from the Chinese server, meaning that the client only needs to use the official Server Client. the corresponding complete version number is 01.02.06.cn. It is estimated that the final version number is. Now it is hard to find it. Please check the audilog.txt file in the installation directory of the VPC with A-inch version. The complete version number of current version 1.6 is 01.02.10.cn.
On the server side, there are two programs that do not know what to do, but you can be sure that these two programs have no impact on enabling services on the server side, these two programs are server-side management tools, but their specific functions are unknown. These two programs are divided into errorhandler.exeand fi.exe. the fi.exe program is actually a program that monitors file attributes. It is generally used for shelling, shelling, and cracking. I don't know how to use it here?
For running the client, I found that the login method of the dance troupe is different from that of other games. Instead of placing the server's ip file on the client, he downloads the ip address and port number of each server once after a connection. The modified login file patcher.exe does not work because it does not store any server IP address or port number information in all files on the client. But it does not mean that there is no way to log on. After passing through the tracing program, I found that the startup plug-in is actually running with parameters added after audition.exe. For example, you enter "D: \ Program Files \ 9you \ audition v1.6 \ Audition.exe "/t3enter upgrade, change \ Audition.exe to your own audition installation path. You will find that you are on the southwest China 1 server. Different servers follow different parameters. The hexadecimal code 13007e347f540b516e10546f05476003426703 contains the address and port information of Server 1 in southwest China. I still don't know how to convert this encoding to plain code, or how to convert the plain code ip address and port information to this hexadecimal encoding. If someone can study it, then the IPaddress information of ipv4fcan be converted to this category, and then added to the audition.exe program, you can directly access your own private server.
As the Client Login method has not been studied, the specific setup tutorial cannot be created. Please study it together. When there is new progress, I will release my research materials for a while.

Attach the intercepted official district packages

HTTP/1.1 200 OK .. date: Tue, 28 Feb 2006 09:40:59 GMT .. server: Apache/1.3.33 (Unix) PHP/4.3.10 .. x-Powered-By: PHP/4.3.10 .. keep-Alive: timeout = 15, max = 100 .. connection: Keep-Alive .. transfer-Encoding: chunked .. content-Type: text/html .... 3fe .. northwest Region 1 (handsome male) (double game currency) auconnectxian.9you.com: 9801 China Netcom (Jingwu show) auconnectwt.9you.com: 9801 China East 3 (fashion party) region: 9801 Central China (SKY) auconnecthnkf.9you.com: 9801 Shandong (wanjia Network) auconnectsdwj.9you.com: 9801 Hebei (China Netcom) region: 9801 China North 2 (Shenzhen) region: 9801 Southwest China 2 (Shenzhen) auconnectxn2.9you.com: 9801 Zhejiang (wasu) Region: 9801 China South 2 (Telecom) region: 9801 Ningbo (Netcom) auconnectnbwt.9you.com: 9801 Jiangxi (Mingzhi) auconnectjx.9you.com: 9801 Jiangsu (langtaosha) auconnectlts.9you.com: 9801 Heilongjiang (Northeast China Netcom) region: 9801 SHAANXI (Northwest China mangrove forest) auconnectsx.9you.com: 9801 Guangdong (BOPOMO) auconnectld.9you.com: 9801 Sichuan (Tianfu hotline) auconnecttf.9you.com: 9801 China North 1 (Netcom) Region: 9801 China East 1 (Telecom) auconnecthd.9you.com: 9801 China East 2 (Telecom) region: 9801 China South 1 (Telecom) region: 9801 China South 1 (Telecom) auconnectxn.9you.com: 9801 v1.65 special experience zone auconnectty.9you.com: 9801 #.. 0 ....

HTTP/1.1 200 OK .. date: Tue, 28 Feb 2006 09:40:59 GMT .. server: Apache/1.3.33 (Unix) PHP/4.3.10 .. x-Powered-By: PHP/4.3.10 .. keep-Alive: timeout = 15, max = 99 .. connection: Keep-Alive .. transfer-Encoding: chunked .. content-Type: text/html .... 2c .. v1.65 special experience zone auconnectty.9you.com: 9801 #.. 0 ....