Gesior 0.3.6 Problems

[zayat]

My 1st problem

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

This Occur when I login and open account management.

2nd :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'swev.guilds' doesn't exist' in D:\xampp\htdocs\pot\OTS_Base_List.php:278 Stack trace: #0 D:\xampp\htdocs\pot\OTS_Base_List.php(278): PDO->query('SELECT COUNT(`g...') #1 D:\xampp\htdocs\guilds.php(62): OTS_Base_List->count() #2 D:\xampp\htdocs\index.php(129): include('D:\xampp\htdocs...') #3 {main} thrown in D:\xampp\htdocs\pot\OTS_Base_List.php on line 278

When I open guilds.

3rd :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'swev.bans' doesn't exist' in D:\xampp\htdocs\bans.php:4 Stack trace: #0 D:\xampp\htdocs\bans.php(4): PDO->query('SELECT `bans`.`...') #1 D:\xampp\htdocs\index.php(243): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\bans.php on line 4

When I open banishments.

4th :

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'swev.bans' doesn't exist' in D:\xampp\htdocs\namelocks.php:37 Stack trace: #0 D:\xampp\htdocs\namelocks.php(37): PDO->query('SELECT `players...') #1 D:\xampp\htdocs\index.php(207): include('D:\xampp\htdocs...') #2 {main} thrown in D:\xampp\htdocs\namelocks.php on line 37

When I open namelocks!

 

[sn3ejk]

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;

 

[Raggaer]

1st, 3rd, 4th Problem

 Table 'swev.bans' doesn't exist

You need to create the table called bans

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;

2nd Problem

Table 'swev.guilds' doesn't exist

You need to create table called guilds

CREATE TABLE `guilds`
(
	`id` INT NOT NULL AUTO_INCREMENT,
	`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
	`name` VARCHAR(255) NOT NULL,
	`ownerid` INT NOT NULL,
	`creationdata` INT NOT NULL,
	`motd` VARCHAR(255) NOT NULL,
	PRIMARY KEY (`id`),
	UNIQUE (`name`, `world_id`)
) ENGINE = InnoDB;

 

[zayat]

All works perfect !
Thanks Raggaer and sn4ake <3
Rep++