auction system Erro

Postado Setembro 6, 2016 8 anos

fala galera meu gesior 2012 está dando esse erro no meu trade off line

Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\pages\auctionsystem.php on line 2

Spoiler

<?PHP
$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>Instruction</TD></TR><TR BGCOLOR='.$config['site']
['darkborder'].'><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 BGCOLOR="'.$config['site']
['vdarkborder'].'"><TD CLASS=white>Auctions</td></TR><TR BGCOLOR='.$config['site']['darkborder'].'><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++;
if(is_int($players / 2))
$bgcolor = $config['site']['lightborder'];
else
$bgcolor = $config['site']['darkborder'];
$cost = round($auction['cost']/1000, 2);
$content .= '<TR BGCOLOR='.$bgcolor.'><TD><center>'.$auction['id'].'</center></TD><TD><center><img
src="/item_images/'.$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'].'gp</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';
}

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']
['vdarkborder'].'"><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.1553/">vDk</a>.';
}
?>

OT PURA DIVERSÃO | IP: otfun.servegame.com | 8.60 | Port: 7171

Citar

Mention

Postado Setembro 6, 2016 8 anos

59 minutos atrás, OtFunEX disse:

fala galera meu gesior 2012 está dando esse erro no meu trade off line

Fatal error: Call to a member function fetchAll() on a non-object in C:\xampp\htdocs\pages\auctionsystem.php on line 2

Mostrar conteúdo oculto

<?PHP
$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>Instruction</TD></TR><TR BGCOLOR='.$config['site']
['darkborder'].'><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 BGCOLOR="'.$config['site']
['vdarkborder'].'"><TD CLASS=white>Auctions</td></TR><TR BGCOLOR='.$config['site']['darkborder'].'><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++;
if(is_int($players / 2))
$bgcolor = $config['site']['lightborder'];
else
$bgcolor = $config['site']['darkborder'];
$cost = round($auction['cost']/1000, 2);
$content .= '<TR BGCOLOR='.$bgcolor.'><TD><center>'.$auction['id'].'</center></TD><TD><center><img
src="/item_images/'.$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'].'gp</center></TD><TD><center>!offer buy, '.$auction['id'].'</center></TR>';
}

$main_content .= '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR="'.$config['site']
['vdarkborder'].'"><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.1553/">vDk</a>.';
}
?>

Tente agora:

<?PHP
$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')-
$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'];
        $cost = round($auction['cost']/1000, 2);
        $content .= '<TR BGCOLOR='.$bgcolor.'><TD><center>'.$auction['id'].'</center></TD><TD><center><img
src="/item_images/'.$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>';
    }
    
    $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.1553/">vDk</a>.</small></p>';
}
    ?>