Bug no gesior ajuda '-'

[Masao 0]

quando clico no link

... http://localhost/index.php?subtopic=accountmanagement

da esse error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'theforgottenserver.bans' doesn't exist' in C:\xampplite\htdocs\pot\OTS_AccountBan.php:55 Stack trace: #0 C:\xampplite\htdocs\pot\OTS_AccountBan.php(55): PDO->query('SELECT `id`, `t...') #1 C:\xampplite\htdocs\pot\OTS_Account.php(935): OTS_AccountBan->find('1') #2 C:\xampplite\htdocs\accountmanagement.php(30): OTS_Account->isBanned() #3 C:\xampplite\htdocs\index.php(171): include('C:\xampplite\ht...') #4 {main} thrown in C:\xampplite\htdocs\pot\OTS_AccountBan.php on line 55

'-'

[Kimoszin 1160]

Não existe a tabela bans no seu database.

Execute no db:

CREATE TABLE `bans`

(

	`id` INT UNSIGNED NOT NULL auto_increment,

	`type` TINYINT(1) NOT NULL COMMENT '1 - ip banishment, 2 - namelock, 3 - account banishment, 4 - notation, 5 - deletion',

	`value` INT UNSIGNED NOT NULL COMMENT 'ip address (integer), player guid or account number',

	`param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'used only for ip banishment mask (integer)',

	`active` TINYINT(1) NOT NULL DEFAULT TRUE,

	`expires` INT NOT NULL,

	`added` INT UNSIGNED NOT NULL,

	`admin_id` INT UNSIGNED NOT NULL DEFAULT 0,

	`comment` TEXT NOT NULL,

	`reason` INT UNSIGNED NOT NULL DEFAULT 0,

	`action` INT UNSIGNED NOT NULL DEFAULT 0,

	`statement` VARCHAR(255) NOT NULL DEFAULT '',

	PRIMARY KEY (`id`),

	KEY `type` (`type`, `value`),

	KEY `active` (`active`)

) ENGINE = InnoDB;

Editado Junho 7, 2012 por Kimoszin (veja o histórico de edições)