41996477306

MARKTING SYSTEM PARA OT 7.4

The market system is designed to be used with OpenTibia 7.4 and it uses the Lua scripting language. It includes features such as:

• Adding offers to the market where players can sell items to other players
• Retrieving offers for a specific item
• Buying offers from the market
• A tax system that applies a percentage on top of the offer price
• A validation system that checks if the offer is valid (sufficient item quantity and reasonable price)
• Support for MySQL database to store and retrieve offers.
• Secure system to prevent duplicate or fake offers

Additionally, the system uses events that can be registered and called by the game client to interact with the market. These events include:

• BuyOffer: Allows a player to buy an offer from the market
• GetOffers: Retrieves all offers for a specific item
• AddOffer: Allows a player to add an offer to the market

The system also includes a function to send the offers to the player's client in order to be displayed in-game.
MySQL:
 

And here I present the tables that need to be imported into the MySQL database:

```sql
CREATE TABLE market_offers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    player_name VARCHAR(255),
    item_id INT,
    item_count INT,
    price INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

market.lua:

market.lua