Lua A Globalevent that delivery house to player OTX 2.15 (TFS 0.3.7)

[mano368]

Hello,

I need a script that delivers houses purchased via website(znote).

local query = db.storeQuery("SELECT `id`, `owner`, `bid`, `bid_end`, `highest_bidder` FROM `houses` WHERE `bid_end` <= " .. os.time() .. " AND `highest_bidder` != 0 LIMIT 1;")

the script checks 2 conditions before delivering the house(remembering that there may be more than one house to be delivered, for example 10 houses):
1. if the player has the money in the bank.
2. if the auction time is less than the current time.
Then the house is delivered (setHouseOwner) and the money in the bank is deducted, and if the player does not have the money, the purchase is undone, resetting values such as:

db.executeQuery("UPDATE `houses` SET `bid` = 0, `bid_end` = 0, `last_bid` = 0, `highest_bidder` = 0 WHERE `id` = " .. houseNumber .. ";")

Preferably this script will be onStartup type, which will deliver the house as soon as the SS, being even a way to prevent the player from being online and not find a way to bug the gold in the bank (withdraw) before receiving the house.
(system similar to the global, where you buy the house, wait for the bid time, and in the next ss you receive the house).

Obs.:

bid = current offer(money)
bid_end = auction end time
last_bid = previous offer(money)
highest_bidder = id player current offer

- Can someone help me? even giving tips on how to write this script!

 

[Danger II]

Why don’t you look how TFS got it? It’s almost exactly to what you have explained. Probably some lua adjusting needed but the core should stay the same.

forgottenserver/data/globalevents/scripts/startup.lua at master · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

 

[mano368]

Why don’t you look how TFS got it? It’s almost exactly to what you have explained. Probably some lua adjusting needed but the core should stay the same.

forgottenserver/data/globalevents/scripts/startup.lua at master · otland/forgottenserver

A free and open-source MMORPG server emulator written in C++ - otland/forgottenserver

github.com

Thank you Danger II! Works so beaultiful!!

If someone needs:

function onStartup()

    -- Check house auctions
    local resultId = db.storeQuery("SELECT `id`, `highest_bidder`, `last_bid`, (SELECT `balance` FROM `players` WHERE `players`.`id` = `highest_bidder`) AS `balance` FROM `houses` WHERE `owner` = 0 AND `bid_end` != 0 AND `bid_end` < " .. os.time())
    if resultId then
        repeat
            local house = getHouseInfo(result.getDataInt(resultId, "id"))
            if house then
                local highestBidder = result.getDataInt(resultId, "highest_bidder")
                local balance = result.getDataInt(resultId, "balance")
                local lastBid = result.getDataInt(resultId, "last_bid")
                if balance >= lastBid then
                    db.query("UPDATE `players` SET `balance` = " .. (balance - lastBid) .. " WHERE `id` = " .. highestBidder)
                    setHouseOwner(house.id, highestBidder)
                    print("> House: Player ".. getPlayerNameByGUID(highestBidder) .." received the ".. getHouseName(house.id) ..".")
                end
                db.query("UPDATE `houses` SET `last_bid` = 0, `bid_end` = 0, `highest_bidder` = 0, `bid` = 0 WHERE `id` = " .. house.id)
            end
        until not result.next(resultId)
        result.free(resultId)
    end
end

Added print() in the code to see if everything goes ok!