TFS 0.X Upgrade System + Auction System

samandriel

Active Member
Joined
Oct 19, 2016
Messages
133
Best answers
0
Reaction score
37
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


Code:
ALTER TABLE `auction_system` ADD `upgrade_level` INT NOT NULL DEFAULT '0' AFTER `date`;
 
OP
samandriel

samandriel

Active Member
Joined
Oct 19, 2016
Messages
133
Best answers
0
Reaction score
37
2. Spamming / Double post: You may not repeat the same message multiple times. It is seen as spamming. This also applies if you for example "bump" a thread.
bump

bump

bump

bump

bump

bump

bump

bump

bump

bump

bump

bump
 

Znote

<?php echo $title; ?>
Staff member
Global Moderator
Premium User
Joined
Feb 14, 2008
Messages
6,619
Best answers
191
Reaction score
1,338
Location
Norway, Oslo
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.
 
Top