[Modern ACC] Auction System (Page)

xTremoxx · Mar 16, 2011

Auction System For MACC (Only Page)

Credits:

xTremoxx - Fix Script and Customize
Paxton - Fix Script
vdK - Develop Script

Install:

First step, get all script in this TOPIC, except website page.

Second step, goto MACC root folder and /system/pages create a new file called auctionsystem.php and paste:

PHP:

<?PHP   
require("config.php");  
$ots = POT::getInstance();  
$ots->connect(POT::DB_MYSQL, connection());  
$SQL = $ots->getDBHandle();  
$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><TD CLASS=white><b><center><font color="green" size="3"><h4><b>Instruções</b></h4></font></center><b></TD></TR><TR><TD><center><h2>Comandos</h2><b><font color="red">!offer add, NomeDoItem, PreçoDoItem, Quantidade</font></b><br />Exemplo: !offer add, Plate Armor, 500, 1<br /><br /><B><font color="red">!offer buy, ID</font></b><br />Exemplo: !offer buy, 1943<br /><br /><b><font color="red">!offer remove, ID</font></b><br />Exemplo: !offer remove, 1943<br /><br /><b><font color="red">!offer withdraw</font></b><br />Use este comando para retirar os lucros de suas vendas.</center></TR></TD></TABLE><br />';   
    if(empty($auctions))   
    {   
        $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white><b><center><h3>Auctions</h3></center></b></td></TR><TR><TD><center>Currently is no one active Auction.</center></TD></TR></TABLE>';      
    }   
    else   
    {   
    foreach($auctions as $auction) {   
        $players++;   
        $cost = round($auction['cost']/1000, 2);   
        $content .= '<TD><center>'.$auction['id'].'</center></TD><TD><center><img src="/public/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 />'.$auction['cost'].' gps</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';   
    }   
       
    $main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white><b><center>ID</center></b></TD><TD class="white"><b><center>Foto</center></b></TD><TD class="white"><b><center>Nome do Item</center></b></TD><TD class="white"><b><center>Vendedor</center></b></TD><TD class="white"><b><center>Quantidade</center></b></TD><TD class="white"><b><center>Preço</center></b></td><TD class="white"><b><center>Comprar</center></TR></b></td>'.$content.'</TABLE>';      
}   

echo $main_content;  
?>

The language is Portuguese, because i'm from Brazil, feel free to translate. if you don't know Portuguese use Google translator.

Third Step, goto /templates/youtemplatename/index.tpl

Find:

PHP:

<li><a href="{$path}/index.php/forum">Forum</a></li>

or same this...

Add Above:

PHP:

<li><a href="{$path}/index.php/p/v/auctionsystem"><span style="color: green;font-weight: bold;">Trade Online</span></a></li>

Information

This script is working perfectly, but have one bug, and i don't know to resolve it, if any people know, please post solution here, the bug is, when u enter in page, a php error apear :} ...

PS: this bug isn't serious, stay calm

Script in Work:

REP ++

Archez · Mar 18, 2011

Approved

Fyruz · Mar 18, 2011

thx man searching it long time ago.

Chris · Mar 18, 2011

Below

PHP:

$SQL = $ots->getDBHandle();

Put

PHP:

$content = '';

to get rid of your notice 'bug'.

Zonet · Mar 18, 2011

Chris said:
Below

PHP:

$SQL = $ots->getDBHandle();

Put

PHP:

$content = '';

to get rid of your notice 'bug'.

He is just using that variable once so the .= isn't needed

PHP:

 $content = '<TD><center>'.$auction['id'].'</center></TD><TD><center><img src="/public/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 />'.$auction['cost'].' gps</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';

Chris · Mar 18, 2011

Aha, did not even see that. Good find!

Fyruz · Mar 18, 2011

test: Infinity | new and revolutinary server, no bug message.

Chris · Mar 18, 2011

Fyruz said:
test: Infinity | new and revolutinary server, no bug message.

You are most likely hiding notices.

agomez · Mar 18, 2011

i rlly like it

!! but why appear this??

A PHP Error was encountered
Severity: Notice

Message: Undefined variable: content

Filename: pages/auctionsystem.php

Line Number: 19

agomez · Mar 18, 2011

and all appear like this:
ID Foto Item Name Seller Amount Price Buy 6 crystal key Download 1 10 k 10000 gps !offer buy, 6 5 demonic essence Xyzon 1 1000 k 1000000 gps !offer buy, 5 4 Morgaroth's heart Download 1 10 k 10000 gps !offer buy, 4 3 broken amulet Xyzon 1 1000 k 1000000 gps !offer buy, 3
All in just 1 line :S!!!!!!!!!!!!!!!! how can i fix

!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

agomez · Mar 18, 2011

xTremoxx · Mar 18, 2011

When u translate you changed one line of script ... please review again x.x

agomez · Mar 18, 2011

nop, keeping in the same way :S! all in one line ='(!!!!!
and the page rox ='(!!

xTremoxx · Mar 18, 2011

post your script.

agomez · Mar 18, 2011

Here it is:

<?PHP
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT:B_MYSQL, connection());
$SQL = $ots->getDBHandle();
$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><TD CLASS=white><center><h4>Instruções</h4></center></TD></TR><TR><TD><center><h2>Comandos</h2>!offer add, NomeDoItem, PreçoDoItem, Quantidade Exemplo: !offer add, Plate Armor, 500, 1 !offer buy, ID Exemplo: !offer buy, 1943 !offer remove, ID Exemplo: !offer remove, 1943 !offer withdraw Use este comando para retirar os lucros de suas vendas.</center></TR></TD></TABLE> ';
if(empty($auctions))
{
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white><center><h3>Auctions</h3></center></td></TR><TR><TD><center>Currently is no one active Auction.</center></TD></TR></TABLE>';
}
else
{
foreach($auctions as $auction) {
$players++;
$cost = round($auction['cost']/1000, 2);
$content .= '<TD><center>'.$auction['id'].'</center></TD><TD><center><img src="/public/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 '.$auction['cost'].' gps</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';
}

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white><center>ID</center></TD><TD class="white"><center>Foto</center></TD><TD class="white"><center>Nome do Item</center></TD><TD class="white"><center>Vendedor</center></TD><TD class="white"><center>Quantidade</center></TD><TD class="white"><center>Preço</center></td><TD class="white"><center>Comprar</center></TR></td>'.$content.'</TABLE>';
}

echo $main_content;
?>

agomez · Mar 19, 2011

i fix it, and the problem with the line 9 or 19 too take a look:

<?PHP
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT:B_MYSQL, connection());
$SQL = $ots->getDBHandle();
$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><TD CLASS=white>Instruction</TD></TR><TR><TD><center><h2>Commands</h2>!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.</center></TR></TD></TABLE> ';
if(empty($auctions))
{
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white>Auctions</td></TR><TR><TD>Currently is no one active Auction.</TD></TR></TABLE>';
$main_content .= ' System created by <a href="http://otland.net/members/vDk/">vDk</a>.';
}
else
{
foreach($auctions as $auction) {
$players++;
$cost = round($auction['cost']/1000, 2);
$content = '<TR BGCOLOR=="#CCCC99"><TD><center>'.$auction['id'].'</center></TD><TD><center><img src="/public/images/items/'.$auction['item_id'].'.gif"/></center></TD><TD><center>'.$auction['item_name'].'</center></TD><TD><center><a href="'.WEBSITE.'/index.php/character/view/'.$auction['name'].'">'.$auction['name'].'</a></center></TD><TD><center>'.$auction['count'].'</center></TD><TD><center>'.$cost.'k '.$auction['cost'].'gp</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';
}

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white><center>ID</center></TD><TD class="white"><center>#</center></TD><TD class="white"><center>Item Name</center></TD><TD class="white"><center>Player</center></TD><TD class="white"><center>Count</center></TD><TD class="white"><center>Cost</center></td><TD class="white"><center>Buy</center></td></TR>'.$content.'</TABLE>';
$main_content .= ' System created by <a href="http://otland.net/members/vDk/">vDk</a>.';
}

echo $main_content;
?>

agomez · Mar 19, 2011

@up sorry to all, i dont how i can edit my last post but anyways. the scrip up one

dont worked for a little time so here it is, i hope xtremoxx take a look of this:

<?PHP
require("config.php");
$ots = POT::getInstance();
$ots->connect(POT:B_MYSQL, connection());
$SQL = $ots->getDBHandle();
$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><TD CLASS=white>Instruction</TD></TR><TR><TD><center><h2>Commands</h2>!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.</center></TR></TD></TABLE> ';
if(empty($auctions))
{
$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white>Auctions</td></TR><TR><TD>Currently is no one active Auction.</TD></TR></TABLE>';
$main_content .= ' System created by <a href="http://otland.net/members/vDk/">vDk</a>.';
}
else
{
foreach($auctions as $auction) {
$players++;
$cost = round($auction['cost']/1000, 2);
$content .= '<TR BGCOLOR="CCCC99"><TD><center>'.$auction['id'].'</center></TD><TD><center><img src="/public/images/items/'.$auction['item_id'].'.gif"/></center></TD><TD><center>'.$auction['item_name'].'</center></TD><TD><center><a href="'.WEBSITE.'/index.php/character/view/'.$auction['name'].'">'.$auction['name'].'</a></center></TD><TD><center>'.$auction['count'].'</center></TD><TD><center>'.$cost.'k '.$auction['cost'].'gp</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';
}

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR><TD CLASS=white><center>ID</center></TD><TD class="white"><center>#</center></TD><TD class="white"><center>Item Name</center></TD><TD class="white"><center>Player</center></TD><TD class="white"><center>Count</center></TD><TD class="white"><center>Cost</center></td><TD class="white"><center>Buy</center></td></TR>'.$content.'</TABLE>';
$main_content .= ' System created by <a href="http://otland.net/members/vDk/">vDk</a>.';
}

echo $main_content;
?>

Mooosie · Mar 25, 2011

Only for mac?

Peacy · Mar 31, 2011

@up lol? why should it be only for mac? it's for all operating systems.

Bogart · Mar 31, 2011

Peacy said:
@up lol? why should it be only for mac? it's for all operating systems.

lulz? I think he ment MAAC(Modern AAC).

@ontopic
does it save the 'charges or time left' of the items like Soft Boots or SSA]?

[Modern ACC] Auction System (Page)

domasturb(cid, genital)

'

★★★★★

Inactive

Web Developer

Inactive

★★★★★

Inactive

Member

Member

Member

domasturb(cid, genital)

Member

domasturb(cid, genital)

Member

Member

Member

- Lua Scripter -

Member

...has super panda powers

Similar threads