• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Lua offer expires Offline player to player item trader (Auction System).

This post is not only directed to you but in general.

Even though the links says the TFS version for the troubling script.
Lets start using the TFS version on title again xD
like this: [TFS 0.3.6]

Sure there are ppl who don't care which version is used, but some like me do care.
I usually don't even look thread if I assume it has nothing to to with TFS 1.x
And finally we need to know TFS version anyway in order to help.

I know this could be improved by website itself but its not. Still we have a sticky how to ask support. Doesn't harm to read it first.
 
you could put up rules against intentionally trying to ripoff people.
and have them banished + deleted shop auctions if they obviously are trying to rip people off in hope they're tired and doesn't look to close.

IMO, players that buys rares for 1 gp, should be banished, as they're attempting to abuse the system to lure people.
 
This post is not only directed to you but in general.

Even though the links says the TFS version for the troubling script.
Lets start using the TFS version on title again xD
like this: [TFS 0.3.6]

Sure there are ppl who don't care which version is used, but some like me do care.
I usually don't even look thread if I assume it has nothing to to with TFS 1.x
And finally we need to know TFS version anyway in order to help.

I know this could be improved by website itself but its not. Still we have a sticky how to ask support. Doesn't harm to read it first.

I'm sorry, i'm new here, i'll edit the topic

you could put up rules against intentionally trying to ripoff people.
and have them banished + deleted shop auctions if they obviously are trying to rip people off in hope they're tired and doesn't look to close.

IMO, players that buys rares for 1 gp, should be banished, as they're attempting to abuse the system to lure people.

Its not a good way to solved it...
Imagine how many players i could lose for nothing... I just care about many items in web page/DB its have a size, its disrupts

With a date to expire the offer all the problems are solved
 
You already have the date in the database table so you can run a query to remove items which date < os.time() - X days and you'll have to return the items to the player or the players mailbox as well as delete it from the database table.

You can look for examples on how to use getResult/executeQuery in the talkaction code from the market system you are using.
 
You already have the date in the database table so you can run a query to remove items which date < os.time() - X days and you'll have to return the items to the player or the players mailbox as well as delete it from the database table.

You can look for examples on how to use getResult/executeQuery in the talkaction code from the market system you are using.

I know, there is date when use the command INSERT
Code:
...
`date` int(11),
...

What i don't know is how make to when start the server return the items to the player depot and delete from DB
 
I am not really familiar with the aac's but maybe someone else can assist with finishing the rest of the code.
PHP:
<?PHP
$time_limit = // time limit here;
$auctions = $SQL->query('SELECT `auction_system`.`player`, `auction_system`.`id`, `auction_system`.`item_name`, `auction_system`.`item_id`, `auction_system`.`count`, `auction_system`.`cost`, `auction_system`.`date`, `players`.`name` FROM `auction_system`, `players` WHERE `players`.`id` = `auction_system`.`player` ORDER BY `auction_system`.`id` DESC')->fetchAll();
$players = 0;
     
    $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b>Instruction<b></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD><center><h2>Commands</h2><b>!offer add, itemName, itemPrice, itemCount</b><br /><small>example: !offer add, plate armor, 500, 1</small><br /><br /><B>!offer buy, AuctionID</b><br /><small>example: !offer buy, 1943</small><br /><br /><b>!offer remove, AuctionID</b><br /><small>example: !offer remove, 1943</small><br /><br /><b>!offer withdraw</b><br /><small>Use this command to get money for sold items.</small></center></TR></TD></TABLE><br />';
    if(empty($auctions))
    {
        $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b>Auctions</b></td></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD>Currently is no one active Auction.</TD></TR></TABLE>';
        $main_content .= '<br /><p align="right"><small>System created by <a href="http://otland.net/members/vDk/">vDk</a>.</small></p>';
    }
    else
    {
    foreach($auctions as $auction) {
        $players++;
            if(is_int($players / 2))
                $bgcolor = $config['site']['lightborder'];
            else
                $bgcolor = $config['site']['darkborder'];
        if (intval($auction['date']) < $time_limit) {
            $cost = round($auction['cost']/1000, 2);
            $content .= '<TR BGCOLOR='.$bgcolor.'><TD><center>'.$auction['id'].'</center></TD><TD><center><img src="http://otland.net/images/items/'.$auction['item_id'].'.gif"/></center></TD><TD><center>'.$auction['item_name'].'</center></TD><TD><center><a href="?subtopic=characters&name='.urlencode($auction['name']).'">'.$auction['name'].'</a></center></TD><TD><center>'.$auction['count'].'</center></TD><TD><center>'.$cost.'k<br /><small>'.$auction['cost'].'gp</small></center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';
        }else{
            // query code to delete database entry here
        }
    }
  
    $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=white><b><center>ID</center></b></TD><TD class="white"><b><center>#</center></b></TD><TD class="white"><b><center>Item Name</center></b></TD><TD class="white"><b><center>Player</center></b></TD><TD class="white"><b><center>Count</center></b></TD><TD class="white"><b><center>Cost</center></b></td><TD class="white"><b><center>Buy</center></b></td></TR>'.$content.'</TABLE>';
    $main_content .= '<br /><p align="right"><small>System created by <a href="http://otland.net/members/vDk/">vDk</a>.</small></p>';
}
    ?>
 
Back
Top