[AJUDA] Gesior Acc

[kaboflow 9]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'reason' in 'field list'' in D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\pot\OTS_Account.php(955): OTS_AccountBan->find('7819824') #2 D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\accountmanagement.php(34): OTS_Account->isBanned() #3 D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\index.php(239): include('D:\Documents an...') #4 {main} thrown in D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\pot\OTS_AccountBan.php on line 55

 

 

no crea acc :,( no aceso a conta..

 

 

 

..

/**
* @package POT
* @version 0.1.6
* @since 0.1.5
* @author Wrzasq
* @copyright 2007 - 2008 © by Wrzasq
* @license http://www.gnu.org/licenses/lgpl-3.0.txt GNU Lesser General Public License, Version 3
*/

/**
* OTServ account ban.
*
* @package POT
* @version 0.1.6
* @since 0.1.5
*/
class OTS_AccountBan extends OTS_Ban
{
/**
* Ban data.
*
* @var array
* @version 0.1.6
* @since 0.1.5
*/
protected $data = array('type' => POT::BAN_ACCOUNT, 'param' => 0, 'active' => true, 'admin_id' => 0, 'comment' => '', 'reason' => 0);

/**
* Loads account ban with given id.
*
* @version 0.1.5
* @since 0.1.5
* @param int $id Ban ID.
* @throws PDOException On PDO operation error.
*/
public function load($id)
{
// SELECT query on database
$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('type') . ', ' . $this->db->fieldName('value') . ', ' . $this->db->fieldName('param') . ', ' . $this->db->fieldName('active') . ', ' . $this->db->fieldName('expires') . ', ' . $this->db->fieldName('added') . ', ' . $this->db->fieldName('admin_id') . ', ' . $this->db->fieldName('comment') . ', ' . $this->db->fieldName('reason') . ' FROM ' . $this->db->tableName('bans') . ' WHERE ' . $this->db->fieldName('type') . ' = ' . POT::BAN_ACCOUNT . ' AND ' . $this->db->fieldName('id') . ' = ' . (int) $id)->fetch();
}

/**
* Loads account ban by banned account ID.
*
* @version 0.1.5
* @since 0.1.5
* @param int $id Account's ID.
* @throws PDOException On PDO operation error.
*/
public function find($id)
{
// SELECT query on database
$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('type') . ', ' . $this->db->fieldName('value') . ', ' . $this->db->fieldName('param') . ', ' . $this->db->fieldName('active') . ', ' . $this->db->fieldName('expires') . ', ' . $this->db->fieldName('added') . ', ' . $this->db->fieldName('admin_id') . ', ' . $this->db->fieldName('comment') . ', ' . $this->db->fieldName('reason') . ' FROM ' . $this->db->tableName('bans') . ' WHERE ' . $this->db->fieldName('type') . ' = ' . POT::BAN_ACCOUNT . ' AND ' . $this->db->fieldName('value') . ' = ' . (int) $id)->fetch();
}
}

?>
" target="_blank">
/**
* @package POT
* @version 0.1.6
* @since 0.1.5
* @author Wrzasq
* @copyright 2007 - 2008 © by Wrzasq
* @license http://www.gnu.org/licenses/lgpl-3.0.txt GNU Lesser General Public License, Version 3
*/

/**
* OTServ account ban.
*
* @package POT
* @version 0.1.6
* @since 0.1.5
*/
class OTS_AccountBan extends OTS_Ban
{
/**
* Ban data.
*
* @var array
* @version 0.1.6
* @since 0.1.5
*/
protected $data = array('type' => POT::BAN_ACCOUNT, 'param' => 0, 'active' => true, 'admin_id' => 0, 'comment' => '', 'reason' => 0);

/**
* Loads account ban with given id.
*
* @version 0.1.5
* @since 0.1.5
* @param int $id Ban ID.
* @throws PDOException On PDO operation error.
*/
public function load($id)
{
// SELECT query on database
$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('type') . ', ' . $this->db->fieldName('value') . ', ' . $this->db->fieldName('param') . ', ' . $this->db->fieldName('active') . ', ' . $this->db->fieldName('expires') . ', ' . $this->db->fieldName('added') . ', ' . $this->db->fieldName('admin_id') . ', ' . $this->db->fieldName('comment') . ', ' . $this->db->fieldName('reason') . ' FROM ' . $this->db->tableName('bans') . ' WHERE ' . $this->db->fieldName('type') . ' = ' . POT::BAN_ACCOUNT . ' AND ' . $this->db->fieldName('id') . ' = ' . (int) $id)->fetch();
}

/**
* Loads account ban by banned account ID.
*
* @version 0.1.5
* @since 0.1.5
* @param int $id Account's ID.
* @throws PDOException On PDO operation error.
*/
public function find($id)
{
// SELECT query on database
$this->data = $this->db->query('SELECT ' . $this->db->fieldName('id') . ', ' . $this->db->fieldName('type') . ', ' . $this->db->fieldName('value') . ', ' . $this->db->fieldName('param') . ', ' . $this->db->fieldName('active') . ', ' . $this->db->fieldName('expires') . ', ' . $this->db->fieldName('added') . ', ' . $this->db->fieldName('admin_id') . ', ' . $this->db->fieldName('comment') . ', ' . $this->db->fieldName('reason') . ' FROM ' . $this->db->tableName('bans') . ' WHERE ' . $this->db->fieldName('type') . ' = ' . POT::BAN_ACCOUNT . ' AND ' . $this->db->fieldName('value') . ' = ' . (int) $id)->fetch();
}
}

?>
@gmail.com>

Editado Setembro 26, 2014 por kaboflow (veja o histórico de edições)

[Rusherzin 527]

Tenta executar essa query na Db:
 

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

[kaboflow 9]

ty duda sanada :*

Error

 

ajuda 

 

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'players.exphist_lastexp' in 'order clause'' in D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\exphist.php:21 Stack trace: #0 D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\exphist.php(21): PDO->query(' SELECT * FROM ...') #1 D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\index.php(82): include('D:\Documents an...') #2 {main} thrown in D:\Documents and Settings\Administrador\Escritorio\xampp\htdocs\exphist.php on line 21

[Rusherzin 527]

 ALTER TABLE `players` ADD `exphist_lastexp` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `exphist7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimetoday` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime1` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime2` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime3` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime4` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime5` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime6` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetime7` BIGINT( 255 ) NOT NULL DEFAULT '0',
ADD `onlinetimeall` BIGINT( 255 ) NOT NULL DEFAULT '0'; 

[kaboflow 9]

Rusherzin

 

graças homem que me ajudou muito: 3

[Thiagodourado1 3]

Em 26/09/2014 em 08:01, Rusherzin disse:

Tenta executar essa query na Db:
 

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

Obrigado cara , resolveu meu problema.