The application is designed to process packets between WOW Client and WOW Server and save information from the Auction House in the MySQL database. The data is used for analysis, statistics collection and use in the profitable buying / selling of items, calculating the cost of crafting items.
- As injection sniffer used PacketSniffer. It can sniff and save packets as binary file and text (human readable log). Project has been forked from SzimatSzatyor, added functionality of dump packet data to TCP Socket connection.
- Also, when writing the server, was used WowPacketParser for parse bin files and fetch packet structure.
Build tool: Apache Maven 3.8.5
In project root directory run command: mvn package
- Starts WOWSnifferServer (run:
java -jar .\server\target\server-1.0-SNAPSHOT.jar) it begin listen localhost:6666 - run wow.exe (WOW WOTLK Client)
- on login screen run PacketSniffer, it inject to client and start TCP connection to WOWSnifferServer
- login in to server, select character, go to Auction House and start request items/buy/sell, all data been saved to DB.
- Process response packages from the Auction House and keep the minimum price for the item. Both single item requests and full scan packages (55,000 items) are supported. Screenshot of how it is stored in the database:
- Calculation of profit when reselling or crafting an item. Also, a comment is compiled for each entry, which contains the components and their cost.
- Saving the history of the price of an item, for statistics. For example: minimum price, median price per month / week / day. They are saved simultaneously with the upper table.
- Saving information about purchases / sales in the Auction House for keeping statistics of purchase prices of materials, their quantity, counting the money earned from the sale of goods, what goods, their quantity. Information is taken from the mailbox when the letter(with money or items) is picked up.
