(Resolvido)Bans

[p e o p l e 50]

No meu site está sem a coluna bans, e dando erro na hora que clica no botão de bans do site. 

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

Como que faço para adicionar essa coluna ? e outra adicionei o sistema de vip do mock e precisa adicionar isso na coluana também

ALTER TABLE `accounts` ADD `vip_time` INT NOT NULL;

Obrigado.

[kk4444 18]

posta seu bans.php em spoiler

[p e o p l e 50]

<?PHP if(!defined('INITIALIZED')) exit;

 

######################################   Config  #######################################

$bans = $SQL->query('

SELECT 

'.$SQL->tableName('bans').'.'.$SQL->fieldName('id').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('type').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('value').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('comment').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('admin_id').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('expires').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('added').',

'.$SQL->tableName('bans').'.'.$SQL->fieldName('reason').'

FROM 

'.$SQL->tableName('bans').','.$SQL->tableName('players').'

WHERE 

'.$SQL->tableName('players').'.'.$SQL->fieldName('account_id').' 

= 

'.$SQL->tableName('bans').'.'.$SQL->fieldName('value').' 

AND 

'.$SQL->tableName('bans').'.'.$SQL->fieldName('active').' 

= 

1 

GROUP BY 

'.$SQL->tableName('bans').'.'.$SQL->fieldName('value').' 

ORDER BY 

'.$SQL->tableName('bans').'.'.$SQL->fieldName('added').' 

DESC')->fetchAll();

 

$banType = $config['site']['bantype']; # config/config.php

 

ECHO '<div class="well"> <h2> Banishment List </h2> ';

 

######################################    List    ######################################

 

if($action == '')

{

$number_of_players = 0;

foreach($bans as $ban) 

{

$nick = $SQL->query('

SELECT 

'.$SQL->fieldName('name').', 

'.$SQL->fieldName('id').', 

'.$SQL->fieldName('level').', 

'.$SQL->fieldName('account_id').' 

FROM '.$SQL->tableName('players').' 

WHERE '.$SQL->fieldName('account_id').' = '.$ban['value'].' 

ORDER BY '.$SQL->fieldName('level').' 

DESC LIMIT 1')->fetch();

 

$gmnick = $SQL->query('

SELECT 

'.$SQL->fieldName('name').', 

'.$SQL->fieldName('id').' 

FROM '.$SQL->tableName('players').' 

WHERE '.$SQL->fieldName('id').' = '.$ban['admin_id'].' ')->fetch();

 

 

if($ban['admin_id'] > 0) { $banby = '<a href=characters&name=.urlencode($gmnick['name]).'>'.$gmnick['name'].'</a>'; }

else { $banby = 'Auto Ban System'; }

 

$number_of_players++;

 

if ($ban['expires'] == '-1'){ $expires = 'Permament'; } # If the banishment is permanent

else { $expires = date('d.m.Y - G:i:s', $ban['expires']); }

 

        # <TD WIDTH="5%">'.$ban_reason[$player['reason']].'</TD>

$players_rows .= '<TR> 

<TD WIDTH=20%> <A HREF="characters&name='.$nick['name'].'">'.$nick['name'].'</A> </TD>

<TD WIDTH=20%>'.$ban['comment'].'</TD> 

<TD WIDTH=20%>'.$banby.'</TD>

<td WIDTH=20%>'.date('d/m/Y, G:i:s', $ban['added']).'</td>

<TD WIDTH=20%>'.$expires.' ';

 

if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) 

{

ECHO '<a href="bans&action=delete&id='.$ban['id'].'"> 

<span class="label label-important">UNDELETE </SPAN> </a>';

        }

 

        ECHO '</TD> </TR>'; # '.$ban_reason / '.getReason

}

 

if(!$bans) 

{

   ECHO '<TABLE class="table table-condensed table-content table-striped">

<TABLE> <TR> <TD> No one is banned at the moment. </TD> </TR> </TABLE> </table> <BR>';

}

else

{

   ECHO '<table width=100%>

   <TR><TD WIDTH=20%><span class="label label-info">Banned Player</span></TD>';

   #ECHO '<TD WIDTH="30%"><span class="label label-info">Reason</span></TD>';

   ECHO '<TD WIDTH=20%><span class="label label-info">Comment</span></TD>

   <TD  WIDTH=20%><span class="label label-info">Banned By</span></TD>

   <TD  WIDTH=20%><span class="label label-info">Date</span></TD>

   <TD  WIDTH=20%><span class="label label-info">Expires</span></TD>

   </TR></TABLE><br> <TABLE class="table table-condensed table-content table-striped"> '.$players_rows.'</TABLE>';

}

}

 

###################################   Deletion ban   #####################################

if($action == 'delete')

{

if($group_id_of_acc_logged >= $config['site']['access_admin_panel']) 

{

$banId = (int) $_REQUEST['id'];

$SQL->query('

UPDATE '.$SQL->tableName('bans').'

SET '.$SQL->fieldName('active').' = 0 

WHERE '.$SQL->fieldName('id').' = '.$banId.';');

header('Location: bans&action=admin');

}

else { ECHO 'You don\'t have admin right.'; }

}

##########################################################################################

ECHO '</div>';

?>

[luanluciano93 1994]

Verifica se na sua tabela bans na database tem as seguintes colunas .. 
 

• id, type, value, comment, admin_id, expires, added, reason.

[p e o p l e 50]

• Possui id, type, value, comment, admin_id, expires, added, param, active 

[luanluciano93 1994]

ALTER TABLE `bans` ADD `reason` INT(10) NOT NULL;

[p e o p l e 50]

Deu certo, muito obrigado <3