Grilo
Membro
-
Registro em
-
Última visita
Tudo que Grilo postou
-
Editar o que no Modern AAC? As páginas padrões, adicionais, funções? PS: Área errada. Deveria estar aqui: http://www.tibiaking.com/forum/forum/252-suporte-de-websites/
-
http://www.vimp.com/en/ http://www.phpsugar.com/phpmelody.html http://launchpad6.com/en/video-cms/ Dentre muitos outros ( Link interessante http://www.xmarks.com/topic/video_cms )
-
É bem simples: - Extraia o arquivo .zip no seu diretório web (Example: C:\xampp\htdocs\ ) - Sem modificar o config.php, entre no site e espere a mensagem de erro MySQL (Imagem). Isso irá te mostrar tanto o resto das instruções de como instalar como também o que deverá ser importado no seu banco de dados. - Edite o config.php e modifique $config['page_admin_access'] com a(s) conta(s) de administrador(es). - Caso você já tenha um banco de dados ativo em seu OTServer, entre na pasta "special" e converta o banco de dados para que seja compatível com o Znote AAC ( http://127.0.0.1/special/ ) - Se divirta com o Znote AAC. Mais informações a respeito do projeto ZNote AAC: https://twitter.com/ZnoteAAC https://github.com/Znote/ZnoteAAC
-
Sim @Augusto @luanluciano93 Como disse, se colocar essa propaganda na home de todo tópico, além de "irritar" menos, não perderia a credibilidade do mesmo.
-
Não precisa retirá-la, a propaganda superior, por exemplo, não atrapalha em nada na navegação do fórum. Já pensou se a propaganda do Naruto ficasse em todo começo de tópico? Não atrapalharia ninguém
-
Não teria como colocar essa propaganda do Naruto apenas na página inicial, fórum inicial, ou em algum lugar que não atrapalhe tanto? Eu sei apertar o [X], mas realmente, é muito chato aparecer essa propaganda toda, toda, e toda hora que você entra em qualquer lugar do TibiaKing :/
-
-
Desculpe por reviver o tópico, só gostaria de dizer que demorou mais de um minuto para mostrar todos os erros do servidor (Monstros, Houses, Spells, etc), e é apenas por SQLITE
-
Tem War System?
-
UP ?
-
Tenho, vou te mandar PM pq não sei se pode mandar em tópico/post >.< @EDIT tenho menos de 10 posts e não to afim de flooda pra manda PM ¬.¬'' [email protected] só add, sorry moderação se não puder mandar e-mails, é culpa dos posts
-
Baixa o compilado, extrai, configura o config.lua e abre o executável >.<
-
Espero que agora esteja mais fácil de entender, esqueci de colocar o começo e o fim, coloquei só o meio <!--//Queries//--> <?PHP $lua = parse_ini_file($config['site']['server_path'].'/config.lua'); $ip = explode("*", $lua['ip']); $port = explode("*", $lua['loginPort']); $motd = explode("*", $lua['motd']); $accounts = $SQL->query('SELECT COUNT(*) FROM `accounts` WHERE `id`>0;')->fetch(); $players = $SQL->query('SELECT COUNT(*) FROM `players` WHERE `id`>0;')->fetch(); $query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$config['site']['players_group_id_block'].' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch(); $query2 = $SQL->query('SELECT `id`, `name` FROM `players` ORDER BY `id` DESC LIMIT 1;')->fetch(); $banned = $SQL->query('SELECT COUNT(*) FROM `bans` WHERE `id`>0;')->fetch(); $guilds = $SQL->query('SELECT COUNT(*) FROM `guilds` WHERE `id`>0;')->fetch(); ?> <!--//END Queries//--> gpedro isso não funcionou
-
Olá, eu formatei meu pc a uma semana, e ontem fui tentar re-instalar o site que eu havia feito o Backup, só que está dando o seguindo erro: A Linha 36 dele está assim: $query = $SQL->query('SELECT `players`.`name`,`players`.`id`,`players`.`level`, `players`.`experience`, `server_motd`.`id`, `server_motd`.`text` FROM `players`,`server_motd` WHERE `players`.`group_id` < '.$pgid.' AND `players`.`name` != "Account Manager" ORDER BY `players`.`level` DESC, `players`.`experience` DESC, `server_motd`.`id` DESC LIMIT 1;')->fetch(); O que está acontecendo?
-
Essa DB é compatível com o Gesior, e com o TFS que eu estou usando?
-
Qual a fonte ? se sabe? @EDIT Fonte que ta escrito "Open Tibia Server"
-
E a DB padrão dele? DROP 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 `map_store`; 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_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 `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 `groups`; CREATE TABLE `groups` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL COMMENT 'group name', `flags` BIGINT UNSIGNED NOT NULL DEFAULT 0, `access` INT NOT NULL, `maxdepotitems` INT NOT NULL, `maxviplist` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; INSERT INTO `groups` VALUES (3, 'a god', 134788128760, 1, 0, 0); INSERT INTO `groups` VALUES (2, 'a gamemaster', 137438953471, 1, 0, 0); INSERT INTO `groups` VALUES (1, 'player', 0, 0, 0, 0); CREATE TABLE `accounts` ( `id` INT NOT NULL AUTO_INCREMENT, `password` VARCHAR(255) /* VARCHAR(32) for MD5*/ NOT NULL DEFAULT '', `type` INT NOT NULL DEFAULT 1, `premdays` INT NOT NULL DEFAULT 0, `lastday` INT UNSIGNED NOT NULL DEFAULT 0, `key` VARCHAR(20) NOT NULL DEFAULT '0', `email` VARCHAR(255) NOT NULL DEFAULT '', `blocked` TINYINT(1) NOT NULL DEFAULT FALSE, `warnings` INT NOT NULL DEFAULT 0, `group_id` INT NOT NULL DEFAULT 1, PRIMARY KEY (`id`), FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ) 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, `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, `redskull` TINYINT(1) NOT NULL DEFAULT 0, `redskulltime` 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, `direction` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER', `loss_experience` INT NOT NULL DEFAULT '10' COMMENT 'NOT IN USE BY THE SERVER', `loss_mana` INT NOT NULL DEFAULT '10' COMMENT 'NOT IN USE BY THE SERVER', `loss_skills` INT NOT NULL DEFAULT '10' COMMENT 'NOT IN USE BY THE SERVER', `premend` INT NOT NULL DEFAULT 0 COMMENT 'NOT IN USE BY THE SERVER', `online` TINYINT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY (`name`), FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE, FOREIGN KEY (`group_id`) REFERENCES `groups`(`id`) ) ENGINE = InnoDB; INSERT INTO `players` VALUES (1, 'Account Manager', 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, 10, 10, 10, 0, 0); CREATE TABLE `bans` ( `type` INT NOT NULL COMMENT 'this field defines if its ip, accountban or namelock', `ip` INT UNSIGNED NOT NULL DEFAULT 0, `mask` INT UNSIGNED NOT NULL DEFAULT 4294967295, `player` INT UNSIGNED NOT NULL DEFAULT 0, `account` INT UNSIGNED NOT NULL DEFAULT 0, `time` INT UNSIGNED NOT NULL DEFAULT 0, `reason_id` INT NOT NULL DEFAULT 0, `action_id` INT NOT NULL DEFAULT 0, `comment` VARCHAR(60) NOT NULL DEFAULT '', `banned_by` INT UNSIGNED NOT NULL DEFAULT 0 ) ENGINE = InnoDB; CREATE TABLE `global_storage` ( `key` INT UNSIGNED NOT NULL, `value` INT NOT NULL, PRIMARY KEY (`key`) ) ENGINE = InnoDB; CREATE TABLE `guilds` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL COMMENT 'guild name - nothing else needed here', `ownerid` INT NOT NULL, `creationdata` INT NOT NULL, `motd` VARCHAR(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; CREATE TABLE `guild_invites` ( `player_id` INT UNSIGNED NOT NULL DEFAULT 0, `guild_id` INT UNSIGNED NOT NULL DEFAULT 0 ) ENGINE = InnoDB; CREATE TABLE `guild_ranks` ( `id` INT NOT NULL AUTO_INCREMENT, `guild_id` INT NOT NULL COMMENT 'guild', `name` VARCHAR(255) NOT NULL COMMENT 'rank name', `level` INT NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else', PRIMARY KEY (`id`), FOREIGN KEY (`guild_id`) REFERENCES `guilds`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; CREATE TABLE `house_lists` ( `house_id` INT NOT NULL, `listid` INT NOT NULL, `list` TEXT NOT NULL ) ENGINE = InnoDB; CREATE TABLE `houses` ( `id` INT NOT NULL AUTO_INCREMENT, `owner` INT NOT NULL, `paid` INT UNSIGNED NOT NULL DEFAULT 0, `warnings` TEXT NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; CREATE TABLE `player_deaths` ( `player_id` INT NOT NULL, `time` BIGINT UNSIGNED NOT NULL DEFAULT 0, `level` INT NOT NULL DEFAULT 1, `killed_by` VARCHAR(255) NOT NULL, `is_player` TINYINT(1) NOT NULL DEFAULT 1, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; CREATE TABLE `player_depotitems` ( `player_id` INT NOT NULL, `depot_id` INT NOT NULL DEFAULT 0, `sid` INT NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots', `pid` INT NOT NULL DEFAULT 0, `itemtype` INT NOT NULL, `count` INT NOT NULL DEFAULT 0, `attributes` BLOB NOT NULL, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE, KEY (`player_id`, `depot_id`), UNIQUE KEY (`player_id`, `sid`) ) 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, 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(4) NOT NULL DEFAULT 0, `value` INT UNSIGNED NOT NULL DEFAULT 0, `count` INT UNSIGNED NOT NULL DEFAULT 0, 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, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; CREATE TABLE `player_storage` ( `player_id` INT NOT NULL DEFAULT 0, `key` INT UNSIGNED NOT NULL DEFAULT 0, `value` INT NOT NULL DEFAULT 0, FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; CREATE TABLE `player_viplist` ( `player_id` INT NOT NULL COMMENT 'id of player whose viplist entry it is', `vip_id` INT NOT NULL COMMENT 'id of target player of viplist entry', FOREIGN KEY (`player_id`) REFERENCES `players`(`id`) ON DELETE CASCADE, FOREIGN KEY (`vip_id`) REFERENCES `players`(`id`) ON DELETE CASCADE ) ENGINE = InnoDB; CREATE TABLE `map_store` ( `house_id` int(10) unsigned NOT NULL, `data` blob NOT NULL, KEY `house_id` (`house_id`) ) ENGINE = InnoDB; CREATE TABLE `tiles` ( `id` INT NOT NULL AUTO_INCREMENT, `x` INT NOT NULL, `y` INT NOT NULL, `z` INT NOT NULL, PRIMARY KEY(`id`) ) ENGINE = InnoDB; CREATE TABLE `tile_items` ( `tile_id` INT NOT NULL, `sid` INT NOT NULL, `pid` INT NOT NULL DEFAULT 0, `itemtype` INT NOT NULL, `count` INT NOT NULL DEFAULT 0, `attributes` BLOB NOT NULL, FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE, INDEX (`sid`) ) ENGINE = InnoDB; CREATE TABLE `tile_store` ( `house_id` INT(11) NOT NULL, `data` LONGBLOB NOT NULL, FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE ) ENGINE = InnoDB; DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `account` = OLD.`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 `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `player` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END| CREATE TRIGGER `oncreate_guilds` AFTER INSERT ON `guilds` FOR EACH ROW BEGIN INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('the Leader', 3, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Vice-Leader', 2, NEW.`id`); INSERT INTO `guild_ranks` (`name`, `level`, `guild_id`) VALUES ('a Member', 1, NEW.`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| DELIMITER ; Desculpa o tamanho, não sei se tem spoiler
-
Fox B. é compatível com o servidor que eu mencionei?
-
Olá usuários do Tibia King Estou ajudando um colega meu mas estou com um sério problema, ele está usando o servidor abaixo: [8.70] The Forgotten Server v0.2.10 (Mystic Spirit) http://tibiaking.com/forum/topic/1955-870-the-forgotten-server-v0210-mystic-spirit/ Qual website seria "100% compatível" com esse servidor? Att. Grilo agradeço desde já
