Fatal ERROR: function fetchAll() on boolean

Postado Junho 16, 2016 9 anos

Bom pessoal, baixei o DBRelated 1.2 que esta disponível aqui no fórum.

Quando coloquei o site online deu o seguinte Error:

Error ID: #C-2
More info: ERROR: #C-2 : Class::ConfigLUA - LUA config file doesn't exist. Path: D:/DBZ/DBRelated/WoDBO OHFilaynneconfig.lua

File: C:\Xampp\htdocs\classes/configlua.php   Line: 24
File: C:\Xampp\htdocs\classes/configlua.php   Line: 12
File: C:\Xampp\htdocs\system/load.init.php   Line: 42
File: C:\Xampp\htdocs/index.php   Line: 18

Pois bem, congui arrumar, pois o config.php estava faltando uma BARRA (WoDBO OHFilaynne/";) no final da pasta do diretório.

Ficando assim:

<?PHP
# Account Maker Config
$config['site']['serverPath'] = "D:/DBZ/DBRelated/WoDBO OHFilaynne/";

Logo apos isso, acusou o seguinte Error:

Warning: parse_ini_file(./layouts/dbr/layout_config.ini): failed to open stream: No such file or directory in C:\Xampp\htdocs\system\load.compat.php on line 62

Warning: Invalid argument supplied for foreach() in C:\Xampp\htdocs\system\load.compat.php on line 63

Fatal error: Call to a member function fetchAll() on boolean in C:\Xampp\htdocs\pages\latestnews.php on line 97

Na pasta C:\Xampp\htdocs\layouts\dbr esta faltando o arquivo layout_config.ini então notei que na mesma pasta do layo -

uts tinha outra pasta, que continha esse arquivo, ae copiei ele para pasta dbr.

layout_config.ini

darkborder = "#D4C0A1"
lightborder = "#F1E0C6"
vdarkborder = "#505050"
news_title_color = "white"
logo_monster = "Demon"

Apos isso corrigiu 2 dos ERROS, mais ainda persiste o Fatal ERROR ://

Fatal error: Call to a member function fetchAll() on boolean in C:\Xampp\htdocs\pages\latestnews.php on line 97

Queria a ajuda do pessoal do forum, pra tentar arrumar isso é colocar este site para funcionar. E seria muito útil para todos que querem

fazer um projeto de DBZ usando o DBRealted já que ele possui as sorcer. Já que todos no tópico do servidor tiveram problemas com o

site.

DataBASE usada: MySQL.sql

Spoiler

ROP TRIGGER IF EXISTS `oncreate_players`;
DROP TRIGGER IF EXISTS `oncreate_guilds`;
DROP TRIGGER IF EXISTS `ondelete_players`;
DROP TRIGGER IF EXISTS `ondelete_guilds`;
DROP TRIGGER IF EXISTS `ondelete_accounts`;

DROP TABLE IF EXISTS `player_depotitems`;
DROP TABLE IF EXISTS `tile_items`;
DROP TABLE IF EXISTS `tiles`;
DROP TABLE IF EXISTS `bans`;
DROP TABLE IF EXISTS `house_lists`;
DROP TABLE IF EXISTS `houses`;
DROP TABLE IF EXISTS `player_items`;
DROP TABLE IF EXISTS `player_namelocks`;
DROP TABLE IF EXISTS `player_skills`;
DROP TABLE IF EXISTS `player_storage`;
DROP TABLE IF EXISTS `player_viplist`;
DROP TABLE IF EXISTS `player_spells`;
DROP TABLE IF EXISTS `player_deaths`;
DROP TABLE IF EXISTS `killers`;
DROP TABLE IF EXISTS `environment_killers`;
DROP TABLE IF EXISTS `player_killers`;
DROP TABLE IF EXISTS `guild_ranks`;
DROP TABLE IF EXISTS `guilds`;
DROP TABLE IF EXISTS `guild_invites`;
DROP TABLE IF EXISTS `global_storage`;
DROP TABLE IF EXISTS `players`;
DROP TABLE IF EXISTS `accounts`;
DROP TABLE IF EXISTS `server_record`;
DROP TABLE IF EXISTS `server_motd`;
DROP TABLE IF EXISTS `server_reports`;
DROP TABLE IF EXISTS `server_config`;
DROP TABLE IF EXISTS `account_viplist`;

CREATE TABLE `accounts`
(
   `id` INT NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(32) NOT NULL DEFAULT '',
   `password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/,
   `salt` VARCHAR(40) NOT NULL DEFAULT '',
   `premdays` INT NOT NULL DEFAULT 0,
   `lastday` INT UNSIGNED NOT NULL DEFAULT 0,
   `email` VARCHAR(255) NOT NULL DEFAULT '',
   `key` VARCHAR(32) NOT NULL DEFAULT '0',
   `blocked` TINYINT(1) NOT NULL DEFAULT FALSE COMMENT 'internal usage',
   `warnings` INT NOT NULL DEFAULT 0,
   `group_id` INT NOT NULL DEFAULT 1,
   PRIMARY KEY (`id`), UNIQUE (`name`)
) ENGINE = InnoDB;

INSERT INTO `accounts` VALUES (1, '1', '1', '', 65535, 0, '', '0', 0, 0, 1);

CREATE TABLE `players`
(
   `id` INT NOT NULL AUTO_INCREMENT,
   `name` VARCHAR(255) NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `group_id` INT NOT NULL DEFAULT 1,
   `account_id` INT NOT NULL DEFAULT 0,
   `level` INT NOT NULL DEFAULT 1,
   `vocation` INT NOT NULL DEFAULT 0,
   `health` INT NOT NULL DEFAULT 150,
   `healthmax` INT NOT NULL DEFAULT 150,
   `experience` BIGINT NOT NULL DEFAULT 0,
   `lookbody` INT NOT NULL DEFAULT 0,
   `lookfeet` INT NOT NULL DEFAULT 0,
   `lookhead` INT NOT NULL DEFAULT 0,
   `looklegs` INT NOT NULL DEFAULT 0,
   `looktype` INT NOT NULL DEFAULT 136,
   `lookaddons` INT NOT NULL DEFAULT 0,
   `maglevel` INT NOT NULL DEFAULT 0,
   `mana` INT NOT NULL DEFAULT 0,
   `manamax` INT NOT NULL DEFAULT 0,
   `manaspent` INT NOT NULL DEFAULT 0,
   `soul` INT UNSIGNED NOT NULL DEFAULT 0,
   `town_id` INT NOT NULL DEFAULT 0,
   `posx` INT NOT NULL DEFAULT 0,
   `posy` INT NOT NULL DEFAULT 0,
   `posz` INT NOT NULL DEFAULT 0,
   `conditions` BLOB NOT NULL,
   `cap` INT NOT NULL DEFAULT 0,
   `sex` INT NOT NULL DEFAULT 0,
   `lastlogin` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   `lastip` INT UNSIGNED NOT NULL DEFAULT 0,
   `save` TINYINT(1) NOT NULL DEFAULT 1,
   `skull` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0,
   `skulltime` INT NOT NULL DEFAULT 0,
   `rank_id` INT NOT NULL DEFAULT 0,
   `guildnick` VARCHAR(255) NOT NULL DEFAULT '',
   `lastlogout` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   `blessings` TINYINT(2) NOT NULL DEFAULT 0,
   `balance` BIGINT NOT NULL DEFAULT 0,
   `stamina` BIGINT NOT NULL DEFAULT 151200000 COMMENT 'stored in miliseconds',
   `direction` INT NOT NULL DEFAULT 2,
   `loss_experience` INT NOT NULL DEFAULT 100,
   `loss_mana` INT NOT NULL DEFAULT 100,
   `loss_skills` INT NOT NULL DEFAULT 100,
   `loss_containers` INT NOT NULL DEFAULT 100,
   `loss_items` INT NOT NULL DEFAULT 100,
   `premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER',
   `online` TINYINT(1) NOT NULL DEFAULT 0,
   `marriage` INT UNSIGNED NOT NULL DEFAULT 0,
   `promotion` INT NOT NULL DEFAULT 0,
   `deleted` INT NOT NULL DEFAULT 0,
   `description` VARCHAR(255) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`), UNIQUE (`name`, `deleted`),
   KEY (`account_id`), KEY (`group_id`),
   KEY (`online`), KEY (`deleted`),
   FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

INSERT INTO `players` VALUES (1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '');

CREATE TABLE `account_viplist`
(
   `account_id` INT NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `player_id` INT NOT NULL,
   KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),
   FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_deaths`
(
   `id` INT NOT NULL AUTO_INCREMENT,
   `player_id` INT NOT NULL,
   `date` BIGINT UNSIGNED NOT NULL,
   `level` INT UNSIGNED NOT NULL,
   PRIMARY KEY (`id`), INDEX (`date`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_depotitems`
(
   `player_id` INT NOT NULL,
   `sid` INT NOT NULL COMMENT 'any given range, eg. 0-100 is reserved for depot lockers and all above 100 will be normal items inside depots',
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   KEY (`player_id`), UNIQUE (`player_id`, `sid`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_items`
(
   `player_id` INT NOT NULL DEFAULT 0,
   `pid` INT NOT NULL DEFAULT 0,
   `sid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL DEFAULT 0,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   KEY (`player_id`), UNIQUE (`player_id`, `sid`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_namelocks`
(
   `player_id` INT NOT NULL DEFAULT 0,
   `name` VARCHAR(255) NOT NULL,
   `new_name` VARCHAR(255) NOT NULL,
   `date` BIGINT NOT NULL DEFAULT 0,
   KEY (`player_id`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_skills`
(
   `player_id` INT NOT NULL DEFAULT 0,
   `skillid` TINYINT(2) NOT NULL DEFAULT 0,
   `value` INT UNSIGNED NOT NULL DEFAULT 0,
   `count` INT UNSIGNED NOT NULL DEFAULT 0,
   KEY (`player_id`), UNIQUE (`player_id`, `skillid`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_spells`
(
   `player_id` INT NOT NULL,
   `name` VARCHAR(255) NOT NULL,
   KEY (`player_id`), UNIQUE (`player_id`, `name`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_storage`
(
   `player_id` INT NOT NULL DEFAULT 0,
   `key` VARCHAR(32) NOT NULL DEFAULT '0',
   `value` VARCHAR(255) NOT NULL DEFAULT '0',
   KEY (`player_id`), UNIQUE (`player_id`, `key`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_viplist`
(
   `player_id` INT NOT NULL,
   `vip_id` INT NOT NULL,
   KEY (`player_id`), KEY (`vip_id`), UNIQUE (`player_id`, `vip_id`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `killers`
(
   `id` INT NOT NULL AUTO_INCREMENT,
   `death_id` INT NOT NULL,
   `final_hit` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
   `unjustified` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
   PRIMARY KEY (`id`),
   FOREIGN KEY (`death_id`) REFERENCES `player_deaths`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `player_killers`
(
   `kill_id` INT NOT NULL,
   `player_id` INT NOT NULL,
   FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `environment_killers`
(
   `kill_id` INT NOT NULL,
   `name` VARCHAR(255) NOT NULL,
   FOREIGN KEY (`kill_id`) REFERENCES `killers`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `houses`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `owner` INT NOT NULL,
   `paid` INT UNSIGNED NOT NULL DEFAULT 0,
   `warnings` INT NOT NULL DEFAULT 0,
   `lastwarning` INT UNSIGNED NOT NULL DEFAULT 0,
   `name` VARCHAR(255) NOT NULL,
   `town` INT UNSIGNED NOT NULL DEFAULT 0,
   `size` INT UNSIGNED NOT NULL DEFAULT 0,
   `price` INT UNSIGNED NOT NULL DEFAULT 0,
   `rent` INT UNSIGNED NOT NULL DEFAULT 0,
   `doors` INT UNSIGNED NOT NULL DEFAULT 0,
   `beds` INT UNSIGNED NOT NULL DEFAULT 0,
   `tiles` INT UNSIGNED NOT NULL DEFAULT 0,
   `guild` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
   `clear` TINYINT(1) UNSIGNED NOT NULL DEFAULT FALSE,
   UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

CREATE TABLE `house_auctions`
(
   `house_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `player_id` INT NOT NULL,
   `bid` INT UNSIGNED NOT NULL DEFAULT 0,
   `limit` INT UNSIGNED NOT NULL DEFAULT 0,
   `endtime` BIGINT UNSIGNED NOT NULL DEFAULT 0,
   UNIQUE (`house_id`, `world_id`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE,
   FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `house_lists`
(
   `house_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `listid` INT NOT NULL,
   `list` TEXT NOT NULL,
   UNIQUE (`house_id`, `world_id`, `listid`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `house_data`
(
   `house_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `data` LONGBLOB NOT NULL,
   UNIQUE (`house_id`, `world_id`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tiles`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `house_id` INT UNSIGNED NOT NULL,
   `x` INT(5) UNSIGNED NOT NULL,
   `y` INT(5) UNSIGNED NOT NULL,
   `z` TINYINT(2) UNSIGNED NOT NULL,
   UNIQUE (`id`, `world_id`),
   KEY (`x`, `y`, `z`),
   FOREIGN KEY (`house_id`, `world_id`) REFERENCES `houses`(`id`, `world_id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `tile_items`
(
   `tile_id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `sid` INT NOT NULL,
   `pid` INT NOT NULL DEFAULT 0,
   `itemtype` INT NOT NULL,
   `count` INT NOT NULL DEFAULT 0,
   `attributes` BLOB NOT NULL,
   UNIQUE (`tile_id`, `world_id`, `sid`), KEY (`sid`),
   FOREIGN KEY (`tile_id`) REFERENCES `tiles`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

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,
   `checkdata` INT NOT NULL,
   `motd` VARCHAR(255) NOT NULL,
   PRIMARY KEY (`id`),
   UNIQUE (`name`, `world_id`)
) ENGINE = InnoDB;

CREATE TABLE `guild_invites`
(
   `player_id` INT NOT NULL DEFAULT 0,
   `guild_id` INT NOT NULL DEFAULT 0,
   UNIQUE (`player_id`, `guild_id`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE,
   FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

CREATE TABLE `guild_ranks`
(
   `id` INT NOT NULL AUTO_INCREMENT,
   `guild_id` INT NOT NULL,
   `name` VARCHAR(255) NOT NULL,
   `level` INT NOT NULL COMMENT '1 - leader, 2 - vice leader, 3 - member',
   PRIMARY KEY (`id`),
   FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

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;

CREATE TABLE `global_storage`
(
   `key` VARCHAR(32) NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `value` VARCHAR(255) NOT NULL DEFAULT '0',
   UNIQUE (`key`, `world_id`)
) ENGINE = InnoDB;

CREATE TABLE `server_config`
(
   `config` VARCHAR(35) NOT NULL DEFAULT '',
   `value` VARCHAR(255) NOT NULL DEFAULT '',
   UNIQUE (`config`)
) ENGINE = InnoDB;

INSERT INTO `server_config` VALUES ('db_version', 26);

CREATE TABLE `server_motd`
(
   `id` INT UNSIGNED NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `text` TEXT NOT NULL,
   UNIQUE (`id`, `world_id`)
) ENGINE = InnoDB;

INSERT INTO `server_motd` VALUES (1, 0, 'Welcome to The Forgotten Server!');

CREATE TABLE `server_record`
(
   `record` INT NOT NULL,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `timestamp` BIGINT NOT NULL,
   UNIQUE (`record`, `world_id`, `timestamp`)
) ENGINE = InnoDB;

INSERT INTO `server_record` VALUES (0, 0, 0);

CREATE TABLE `server_reports`
(
   `id` INT NOT NULL AUTO_INCREMENT,
   `world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
   `player_id` INT NOT NULL DEFAULT 1,
   `posx` INT NOT NULL DEFAULT 0,
   `posy` INT NOT NULL DEFAULT 0,
   `posz` INT NOT NULL DEFAULT 0,
   `timestamp` BIGINT NOT NULL DEFAULT 0,
   `report` TEXT NOT NULL,
   `reads` INT NOT NULL DEFAULT 0,
   PRIMARY KEY (`id`),
   KEY (`world_id`), KEY (`reads`),
   FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;

DELIMITER |

CREATE TRIGGER `ondelete_accounts`
BEFORE DELETE
ON `accounts`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `type` IN (3, 4) AND `value` = OLD.`id`;
END|

CREATE TRIGGER `oncreate_guilds`
AFTER INSERT
ON `guilds`
FOR EACH ROW
BEGIN
   INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Leader', 3, NEW.`id`);
   INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Vice-Leader', 2, NEW.`id`);
   INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('Member', 1, NEW.`id`);
END|

CREATE TRIGGER `ondelete_guilds`
BEFORE DELETE
ON `guilds`
FOR EACH ROW
BEGIN
UPDATE `players` SET `guildnick` = '', `rank_id` = 0 WHERE `rank_id` IN (SELECT `id` FROM `guild_ranks` WHERE `guild_id` = OLD.`id`);
END|

CREATE TRIGGER `oncreate_players`
AFTER INSERT
ON `players`
FOR EACH ROW
BEGIN
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 0, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 1, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 2, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 3, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 4, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 5, 10);
   INSERT INTO `player_skills` (`player_id`, `skillid`, `value`) VALUES (NEW.`id`, 6, 10);
END|

CREATE TRIGGER `ondelete_players`
BEFORE DELETE
ON `players`
FOR EACH ROW
BEGIN
DELETE FROM `bans` WHERE `type` IN (2, 5) AND `value` = OLD.`id`;
UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`;
END|

DELIMITER ;

Linha 97 acusada de ERROR: latestnews.php

Citar

$last_threads = $SQL->query('SELECT ' . $SQL->tableName('players') . '.' . $SQL->fieldName('name') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_text') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_topic') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_smile') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('replies') . ', ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('post_date') . ' FROM ' . $SQL->tableName('players') . ', ' . $SQL->tableName('z_forum') . ' WHERE ' . $SQL->tableName('players') . '.' . $SQL->fieldName('id') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('author_guid') . ' AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('section') . ' = 1 AND ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('first_post') . ' = ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('id') . ' ORDER BY ' . $SQL->tableName('z_forum') . '.' . $SQL->fieldName('last_post') . ' DESC LIMIT ' . $config['site']['news_limit'])->fetchAll();

Arquivo que foi acusado de ERROR: latestnews.php

latestnews.php

Editado Junho 16, 2016 9 anos por Fagundes14 (veja o histórico de edições)

Citar

Mention

Entrar

Fatal ERROR: function fetchAll() on boolean

Featured Replies

Participe da conversa

Quem Está Navegando 0

Conteúdo Similar

Estatísticas dos Fóruns

Informação Importante

Account

Navigation

Pesquisar

Entrar

Participe da conversa

Quem Está Navegando 0

Conteúdo Similar

[Shop System v7.0-alpha] Gesior para MYAAC Pix 100% Automatico MercadoPago(By underewar and Clyfe)

Gesior - Baiak-PvP 2020

MercadoPago Checkout Transparente (CC)

[PEDIDO] Ajuda Problema com criar contas no sample e não aparece vocacoes na pagina create character

Gesior/Onix Pbot

Estatísticas dos Fóruns

Informação Importante