Search the Community

Ae galera. To eu aqui de novo postando um OT. Dessa vez em 8.2 Mapa Master Ots com ServFull Coloquei no TFS para rodar 8.2 Bugs? Claro que tem, alem de ser 8.2 que é muito novo é global ou seja bugs tem sim. Cidades: [+]Carlin [+]Venore [+]Ab'dendriel [+]Ankrahmun [+]Port Rope [+]Edron [+]Svargrond Entre outras. Mais de 600 casas Mais de 150 quests Assim que sair o official realease eu atualizo o ot Na proxima versão vou botar meu mapa RockWar [+] Download. Download do Serv Espero que gostem, Até. PRA QUEM TAVA QUERENDO O DATABASE PRA PODER CRIAR O BANCO DE DADOS TA AQUI: 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 `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`; DROP TABLE IF EXISTS `server_record`; DROP TABLE IF EXISTS `server_motd`; DROP TABLE IF EXISTS `server_reports`; CREATE TABLE `server_motd` ( `id` INT NOT NULL AUTO_INCREMENT, `text` TEXT NOT NULL DEFAULT '', PRIMARY KEY (`id`) ) ENGINE = InnoDB; INSERT INTO `server_motd` VALUES (1, 'Welcome to The Forgotten Server!'); CREATE TABLE `server_record` ( `record` INT NOT NULL, `timestamp` BIGINT NOT NULL, PRIMARY KEY (`timestamp`) ) ENGINE = InnoDB; INSERT INTO `server_record` VALUES (0, 0); CREATE TABLE `server_reports` ( `id` INT NOT NULL AUTO_INCREMENT, `player_id` INT UNSIGNED NOT NULL DEFAULT 0, `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 DEFAULT '', `reads` INT NOT NULL DEFAULT 0, PRIMARY KEY (`id`), KEY (`player_id`), KEY (`reads`) ) ENGINE = InnoDB; CREATE TABLE `groups` ( `id` INT NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL COMMENT 'group name', `flags` BIGINT UNSIGNED NOT NULL DEFAULT 0, `customflags` BIGINT UNSIGNED NOT NULL DEFAULT 0, `access` INT NOT NULL, `violationaccess` INT NOT NULL, `maxdepotitems` INT NOT NULL, `maxviplist` INT NOT NULL, PRIMARY KEY (`id`) ) ENGINE = InnoDB; INSERT INTO `groups` VALUES (1, 'Player', 0, 0, 0, 0, 0, 0); INSERT INTO `groups` VALUES (2, 'Tutor', 16809984, 1, 1, 0, 0, 0); INSERT INTO `groups` VALUES (3, 'Senior Tutor', 68736352256, 3, 2, 1, 0, 0); INSERT INTO `groups` VALUES (4, 'Game Master', 492842123151, 63, 3, 2, 4000, 200); INSERT INTO `groups` VALUES (5, 'Community Manager', 542239465466, 1279, 4, 3, 6000, 300); INSERT INTO `groups` VALUES (6, 'God', 546534563834, 2047, 5, 3, 8000, 400); CREATE TABLE `accounts` ( `id` INT NOT NULL AUTO_INCREMENT, `password` VARCHAR(255) NOT NULL/* VARCHAR(32) NOT NULL COMMENT 'MD5'*//* VARCHAR(40) NOT NULL COMMENT 'SHA1'*/, `premdays` INT NOT NULL DEFAULT 0, `lastday` INT UNSIGNED NOT NULL DEFAULT 0, `email` VARCHAR(255) NOT NULL DEFAULT '', `key` VARCHAR(20) NOT NULL DEFAULT '0', `blocked` TINYINT(1) NOT NULL DEFAULT FALSE, `warnings` INT NOT NULL DEFAULT 0, `group_id` INT NOT NULL DEFAULT 1, `deleted` TINYINT(1) NOT NULL DEFAULT FALSE, `warned` TINYINT(1) NOT NULL DEFAULT FALSE, PRIMARY KEY (`id`), FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`) ) ENGINE = InnoDB; INSERT INTO `accounts` VALUES (1, '1', 65535, 0, '', '0', 0, 0, 1, 0, 0); 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` BIGINT 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 COMMENT 'player money in bank', `stamina` BIGINT NOT NULL DEFAULT 201660000, `direction` INT NOT NULL DEFAULT 2 COMMENT 'NOT IN USE BY THE SERVER', `loss_experience` INT NOT NULL DEFAULT 10, `loss_mana` INT NOT NULL DEFAULT 10, `loss_skills` INT NOT NULL DEFAULT 10, `loss_items` INT NOT NULL DEFAULT 10, `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, 201660000, 0, 10, 10, 10, 10, 0, 0); CREATE TABLE `bans` ( `id` INT UNSIGNED NOT NULL auto_increment, `type` TINYINT(1) NOT NULL COMMENT 'this field defines if its ip, account, player, or any else ban', `value` INT UNSIGNED NOT NULL COMMENT 'ip, player guid, account number', `param` INT UNSIGNED NOT NULL DEFAULT 4294967295 COMMENT 'mask', `active` TINYINT(1) NOT NULL DEFAULT TRUE, `expires` INT UNSIGNED 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, PRIMARY KEY (`id`), KEY `type` (`type`, `value`) ) 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` INT NOT NULL DEFAULT 0, `lastwarning` INT UNSIGNED NOT NULL DEFAULT 0, 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, 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` text 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 `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 ) ENGINE = InnoDB; DELIMITER | CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` != 1 AND `type` != 2 AND `value` = 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 `value` = 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 ; Desculpe to sem Tempo Alguem Pode Passar Scan!! Meu Fan? Posten Plx

TFS 0.2.13 rev. Modificado Por Gesior Retirado do OtLand e traduzido por Mim Muitos usuários querem o TFS 0.3 scripts, mas TFS 0.3 não é estável. Eu modifiquei o TFS 0.2.13 para meu servidor e postei aqui para outros hosters. Meu OTS uptime tem agora 70+. O que eu adicionei ao TFS 0.2.13: - basespeed in vocations.xml - você pode mudar a velocidade padrão de cada vocação - 220 é a velocidade padrão. <vocation id="1" name="Sorcerer" description="a sorcerer" basespeed="220" gaincap="10" ... - /invisible comando para GMs postado por Pedro B. - fixed bug with IP bans - no TFS 0.2.13 normal quando você Ban algum IP durava apenas até o servidor reiniciar, não as 24 horas, bug reportado aos desenvolvedores TFS. - IP bans loaded/saved em tempo real para a database (como no TFS 0.3) - Não há problemas com "unban IP", agora o hoster abre MySQL/SQLite database e o registro com IP ban, e o player pode fazer o login, não tem que reiniciar o servidor. - Mais opições no config.lua, bans configurável: --show how many HP player/monster heal showHealingDamage = "yes" -- show animatex text CRITICAL near player who do critical hit displayCriticalHitNotify = "yes" -- clean protection zones when clean map cleanProtectedZones = "yes" -- default 3 hours IP ban ipBanishmentTime = 3 * 60 * 60 -- default 1 day account ban - give one warning point always normalBanishmentTime = 1 * 24 * 60 * 60 -- default 3 days account ban - give warningsToFinalBan warning points always finalBanishmentTime = 3 * 24 * 60 * 60 -- it is permement ban, not real deletion from database warningsToDeletion = 4 -- when player has 3 warnings server ban for finalBanishmentTime warningsToFinalBan = 3 CREDITS: Todos desenvolvedores OpenTibia Todos desenvolvedores The Forgotten Server Pedro B. Gesior Download Map Editor Arquivo 100% limpo Scan:http://www.virustotal.com/pt/analisi...6b06b31b799d50

[Removido- Arquivo Infectado]

Gente Esse tópico foi retirado de outro forum!!! Bom meu trabalho foi só trazer esse projeto para o Xtibia É isso aew flwss OBS: Ot em SQL

Tópico retirado do OtFans!!! Many users want TFS 0.3 scripts, but TFS 0.3 isn't stable. I modifed TFS 0.2.13 for my server and post it here for other hosters. My OTS has uptime 70+ hours now. What I added to TFS 0.2.13:- basespeed in vocations.xml - you can change default move speed of each vocation - 220 is deafult speed -/invisible command for GMs posted by Pedro B. on ******.net forum - fixed bug with IP bans - in normal TFS 0.2.13 when you ban someone IP it's banned until server restart/crash, not for 24 hours, bug reported to TFS developer - IP bans loaded/saved in real time from/in database (like in TFS 0.3) - no more problems with "unban IP", now hoster open MySQL/SQLite database and delete record with IP ban, then player can login, don't have to restart server/reload anything - Extra options in config.lua, bans configurable: Link Para Download no SpeedyShare AQUI -TFS console version, all needed DLLs, data folder with modified commands.xml and vocations.xml, sources (modified) and official TFS documents included, compiled with parameter "-D__GLOBAL_STORAGE__" - you can use this distro with my graphic statistics (posted on Forum --> Web Applications)! Bom Gente é isso aew meu trabalho foi só trazer esse outro OT para o Xtibia Flwss

LINKS - Link do Ip Changer : Clique Aqui Link do Server - Clique Aqui Link de Como Abrir Server SQL - http://www.xtibia.com/forum/Como-Colocar-U...ine-t82720.html LINK DO SCAN ! ( Suspicious File = Dll ) http://www.virustotal.com/pt/analisis/ed99...88778d0c4145e12 --FIM DOS LINKS-- Retirado do OTFans - NO TEXTO DIZ QUE É 8.11 , MAS PODE TESTAR QUE É 8.2 E COM TODOS(ou pelo menos quase) OS ITEMS! Eu mesmo testei.

Links : SacusOTserv (SQL) 0.8.0 (Link Direto) Mirror 1 (RapidShare.com) ==FIM DOS LINKS== Features: Encontrado no : OTFans ! ============= Criador do Sacus OTSev: pollotex ( único crédito que achei ) ============= pollotex escreveu : Special Thanks to GM Neo for this SVN... Tradução : Um obrigado especial ao GM Neo por esta SVN... ============= Observações : O AVG Anti-Virus pode detectar o OT como um vírus.(Dll não reconhecida.) O Avast também. =============