Postado Junho 14, 2014 11 anos 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. Actions; Vip door Systema By Mock Movements; Piso que TELEPORTA apenas players PREMIUM
Postado Junho 14, 2014 11 anos Autor <?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>'; ?> Actions; Vip door Systema By Mock Movements; Piso que TELEPORTA apenas players PREMIUM
Postado Junho 14, 2014 11 anos Verifica se na sua tabela bans na database tem as seguintes colunas .. • id, type, value, comment, admin_id, expires, added, reason. STYLLER OT 2022
Postado Junho 14, 2014 11 anos Autor • Possui id, type, value, comment, admin_id, expires, added, param, active Actions; Vip door Systema By Mock Movements; Piso que TELEPORTA apenas players PREMIUM
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.