zexus
Member
- Joined
- Oct 1, 2016
- Messages
- 133
- Reaction score
- 18
Bank NPC script:
http://hastebin.com/ecenupivug.lua
Auction Talkaction script:
http://hastebin.com/turofepoke.lua
From (https://otland.net/threads/offline-player-to-player-item-trader-auction-system.51447/)
I want to remove this auction_balance its useless
Should be better use only bank balance
What i need to put to when player buy:
No send money to auction_balance like is
Send money to player bank...
Link transfer (bank system)...
So i could remove it too
http://hastebin.com/ecenupivug.lua
Auction Talkaction script:
http://hastebin.com/turofepoke.lua
From (https://otland.net/threads/offline-player-to-player-item-trader-auction-system.51447/)
I want to remove this auction_balance its useless
PHP:
ALTER TABLE `players` DROP `auction_balance`;
What i need to put to when player buy:
PHP:
if(t[1] == "buy") then
No send money to auction_balance like is
PHP:
db.executeQuery("UPDATE `players` SET `auction_balance` = `auction_balance` + " .. buy:getDataInt("cost") .. " WHERE `id` = " .. buy:getDataInt("player") .. ";")
Send money to player bank...
Link transfer (bank system)...
So i could remove it too
PHP:
if(t[1] == "withdraw") then
local balance = db.getResult("SELECT `auction_balance` FROM `players` WHERE `id` = " .. getPlayerGUID(cid) .. ";")
if(balance:getDataInt("auction_balance") < 1) then
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You don't have money on your auction balance.")
balance:free()
return true
end
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You got " .. balance:getDataInt("auction_balance") .. " gps from auction system!")
doPlayerAddMoney(cid, balance:getDataInt("auction_balance"))
db.executeQuery("UPDATE `players` SET `auction_balance` = '0' WHERE `id` = " .. getPlayerGUID(cid) .. ";")
balance:free()
end