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 .= '
Instruction

Commands

!offer add, itemName, itemPrice, itemCount
example: !offer add, plate armor, 500, 1

!offer buy, AuctionID
example: !offer buy, 1943

!offer remove, AuctionID
example: !offer remove, 1943

!offer withdraw
Use this command to get money for sold items.

'; if(empty($auctions)) { $main_content .= '
Auctions
Currently is no one active Auction.
'; $main_content .= '

System created by vDk.

'; } else { foreach($auctions as $auction) { $players++; if(is_int($players / 2)) $bgcolor = $config['site']['lightborder']; else $bgcolor = $config['site']['darkborder']; $cost = round($auction['cost']/1000, 2); $content .= '
'.$auction['id'].'
'.$auction['item_name'].'
'.$auction['name'].'
'.$auction['count'].'
'.$cost.'k
'.$auction['cost'].'gp
!offer buy, '.$auction['id'].'
'; } $main_content .= ''.$content.'
ID
#
Item Name
Player
Count
Cost
Buy
'; $main_content .= '

System created by vDk.

'; } ?>