TFS 0.X Upgrade System + Auction System

[samandriel]

I have 2 systems who need to work together, but idk how to do
I want to some how, players can put their upgraded items to sell and buy on auction system

1- auction system, its like a offline trade to 8.6, you can buy and sell items offline by using website and talkactions
My version of this script: [Lua] auctionsystem.lua - Pastebin.com (https://pastebin.com/nDBRHTCC)
take from this base: TalkAction - Offline player to player item trader (Auction System). (https://otland.net/threads/offline-player-to-player-item-trader-auction-system.51447/)

2- perfect upgrade items system, its a system where players upgrade his items and make it more stronger
My version of this script: [Lua] upgradesystem.lua - Pastebin.com (https://pastebin.com/kd4rQDn1)
take from this base: Perfect Upgrade System (https://www.xtibia.com/forum/topic/187075-perfect-upgrade-system/)

My idea was add a new row, and use it, but idk how:
on sell get item upgrade and put on DB
on buy load DB and set item upgrade

ALTER TABLE `auction_system` ADD `upgrade_level` INT NOT NULL DEFAULT '0' AFTER `date`;

 

[samandriel]

bump

bump

bump

bump

bump

bump

bump

bump

bump

bump

bump

bump

 

[Znote]

The upgrade system updates the item uniqueid's metadata.

While the provided auction script removes the item when it is added to the auction system, and when retrieved it is re-created to the new player. In this process extra attributes on the item is stripped. (so the upgrades don't work).

There is no easy way to preserve this data, you might want to try to create an actionid association on the item and re-apply the modification when the item is retreived from the auction house.
Or add a supporting SQL table that is somehow able to retain this reference.

I would probably scratch all this and try to temporarily store that particular item on a holder character. Transferring the item between seller - holder - buyer instead of removing it and recreating it. Which is a workaround I think is maybe possible with the latest version of TFS on github.