Sociopata

Qualquer coisa tbm eu postei um tuto de libera as portas desse mesmo modem do dar uma procurada

tem como posta uma screen para mim ver como q ta?

sqlDatabase = "otserver" Procure por isso e deixe assim sqlDatabase = "forgottenserver.s3db"

libera em ambos para garantir ou se não conseguir apenas no modem

http://tibiaking.com/forum/topic/9212-colocando-seu-site-online-pelo-8090-e-desbloqueando-a-porta-8090/

ja liberou as portas do xammp e do modem?

vlw pelo comentário, mas ai qualquer coisa só mudar a background vo mexe aki ainda , pra dexa mais bacana

xammp 1.7.3 gesior http://tibiaking.com/forum/topic/27253-gesior-25-editado/

fala turma vim trazer hoje um gesior que eu andei mexendo, e vou continuar editando, mas enquanto isso ta aqui DOWNLOAD SCAN

tenta ae fera CREATE TABLE IF NOT EXISTS `players` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `world_id` tinyint(2) unsigned NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `account_id` int(11) NOT NULL DEFAULT '0', `level` int(11) NOT NULL DEFAULT '1', `vocation` int(11) NOT NULL DEFAULT '0', `health` int(11) NOT NULL DEFAULT '150', `healthmax` int(11) NOT NULL DEFAULT '150', `experience` bigint(20) NOT NULL DEFAULT '0', `lookbody` int(11) NOT NULL DEFAULT '0', `lookfeet` int(11) NOT NULL DEFAULT '0', `lookhead` int(11) NOT NULL DEFAULT '0', `looklegs` int(11) NOT NULL DEFAULT '0', `looktype` int(11) NOT NULL DEFAULT '136', `lookaddons` int(11) NOT NULL DEFAULT '0', `maglevel` int(11) NOT NULL DEFAULT '0', `mana` int(11) NOT NULL DEFAULT '0', `manamax` int(11) NOT NULL DEFAULT '0', `manaspent` int(11) NOT NULL DEFAULT '0', `soul` int(10) unsigned NOT NULL DEFAULT '0', `town_id` int(11) NOT NULL DEFAULT '0', `posx` int(11) NOT NULL DEFAULT '0', `posy` int(11) NOT NULL DEFAULT '0', `posz` int(11) NOT NULL DEFAULT '0', `conditions` blob NOT NULL, `cap` int(11) NOT NULL DEFAULT '0', `sex` int(11) NOT NULL DEFAULT '0', `lastlogin` bigint(20) unsigned NOT NULL DEFAULT '0', `lastip` int(10) unsigned NOT NULL DEFAULT '0', `save` tinyint(1) NOT NULL DEFAULT '1', `skull` tinyint(1) unsigned NOT NULL DEFAULT '0', `skulltime` int(11) NOT NULL DEFAULT '0', `rank_id` int(11) NOT NULL DEFAULT '0', `guildnick` varchar(255) NOT NULL DEFAULT '', `lastlogout` bigint(20) unsigned NOT NULL DEFAULT '0', `blessings` tinyint(2) NOT NULL DEFAULT '0', `balance` bigint(20) NOT NULL DEFAULT '0', `stamina` bigint(20) NOT NULL DEFAULT '151200000' COMMENT 'stored in miliseconds', `direction` int(11) NOT NULL DEFAULT '2', `loss_experience` int(11) NOT NULL DEFAULT '100', `loss_mana` int(11) NOT NULL DEFAULT '100', `loss_skills` int(11) NOT NULL DEFAULT '100', `loss_containers` int(11) NOT NULL DEFAULT '100', `loss_items` int(11) NOT NULL DEFAULT '100', `premend` int(11) NOT NULL DEFAULT '0' COMMENT 'NOT IN USE BY THE SERVER', `online` tinyint(1) NOT NULL DEFAULT '0', `marriage` int(10) unsigned NOT NULL DEFAULT '0', `marrystatus` int(10) unsigned NOT NULL DEFAULT '0', `promotion` int(11) NOT NULL DEFAULT '0', `deleted` tinyint(1) NOT NULL DEFAULT '0', `description` varchar(255) NOT NULL DEFAULT '', `created` int(11) NOT NULL DEFAULT '0', `nick_verify` int(11) NOT NULL DEFAULT '0', `old_name` varchar(255) NOT NULL DEFAULT '', `hide_char` int(11) NOT NULL DEFAULT '0', `worldtransfer` int(11) NOT NULL DEFAULT '0', `comment` text NOT NULL, `show_outfit` tinyint(4) NOT NULL DEFAULT '1', `show_eq` tinyint(4) NOT NULL DEFAULT '1', `show_bars` tinyint(4) NOT NULL DEFAULT '1', `show_skills` tinyint(4) NOT NULL DEFAULT '1', `show_quests` tinyint(4) NOT NULL DEFAULT '1', `goals` int(11) NOT NULL DEFAULT '0', `wins` int(11) NOT NULL DEFAULT '0', `total` int(11) NOT NULL DEFAULT '0', `exphist_lastexp` bigint(255) NOT NULL DEFAULT '0', `exphist1` bigint(255) NOT NULL DEFAULT '0', `exphist2` bigint(255) NOT NULL DEFAULT '0', `exphist3` bigint(255) NOT NULL DEFAULT '0', `exphist4` bigint(255) NOT NULL DEFAULT '0', `exphist5` bigint(255) NOT NULL DEFAULT '0', `exphist6` bigint(255) NOT NULL DEFAULT '0', `exphist7` bigint(255) NOT NULL DEFAULT '0', `onlinetimetoday` bigint(255) NOT NULL DEFAULT '0', `onlinetime1` bigint(255) NOT NULL DEFAULT '0', `onlinetime2` bigint(255) NOT NULL DEFAULT '0', `onlinetime3` bigint(255) NOT NULL DEFAULT '0', `onlinetime4` bigint(255) NOT NULL DEFAULT '0', `onlinetime5` bigint(255) NOT NULL DEFAULT '0', `onlinetime6` bigint(255) NOT NULL DEFAULT '0', `onlinetime7` bigint(255) NOT NULL DEFAULT '0', `onlinetimeall` bigint(255) NOT NULL DEFAULT '0', `frags` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`,`deleted`), KEY `account_id` (`account_id`), KEY `group_id` (`group_id`), KEY `online` (`online`), KEY `deleted` (`deleted`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `marrystatus`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`, `goals`, `wins`, `total`, `exphist_lastexp`, `exphist1`, `exphist2`, `exphist3`, `exphist4`, `exphist5`, `exphist6`, `exphist7`, `onlinetimetoday`, `onlinetime1`, `onlinetime2`, `onlinetime3`, `onlinetime4`, `onlinetime5`, `onlinetime6`, `onlinetime7`, `onlinetimeall`, `frags`) VALUES (1, 'Account Manager', 6, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 32360, 31782, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (2, 'Rook Sample', 1, 1, 1, 1, 0, 180, 180, 0, 0, 0, 0, 0, 110, 0, 0, 30, 30, 0, 0, 0, 160, 54, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (3, 'Sorcerer Sample', 1, 1, 1, 10, 1, 180, 180, 0, 0, 0, 0, 0, 110, 0, 0, 30, 30, 0, 0, 0, 160, 54, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (4, 'Druid Sample', 1, 1, 1, 10, 2, 180, 180, 0, 0, 0, 0, 0, 110, 0, 0, 30, 30, 0, 0, 0, 160, 54, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (5, 'Paladin Sample', 1, 1, 1, 10, 3, 180, 180, 0, 0, 0, 0, 0, 110, 0, 0, 30, 30, 0, 0, 0, 160, 54, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (6, 'Knight Sample', 1, 1, 1, 10, 4, 180, 180, 0, 0, 0, 0, 0, 110, 0, 0, 30, 30, 0, 0, 0, 160, 54, 7, '', 400, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0), (7, 'Testando Gm', 0, 6, 1, 150, 1, 146, 180, 54042300, 0, 0, 0, 0, 302, 0, 7, 10, 30, 2673, 0, 1, 162, 51, 7, '', 400, 1, 1315745305, 16777343, 1, 0, 0, 7, 'pqp', 1315745732, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 1, 0, 0, 0, 0, '', 1314191955, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 54042300, 0, 0, 0, 0, 0, 0, 0, 600, 0, 0, 720, 0, 600, 1140, 0, 3900, 9), (8, 'Fie', 0, 1, 6741027, 129, 4, 95, 95, 34686577, 0, 0, 0, 0, 128, 0, 0, 0, 0, 0, 0, 1, 160, 54, 7, '', 0, 1, 1315745239, 16777343, 1, 0, 0, 10, 'saw', 1315745256, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, 0, '', 1314192184, 0, '', 0, 0, '', 1, 1, 1, 1, 1, 0, 0, 0, 34686577, 0, 0, 0, 0, -10326890, -9028833, 0, 0, 0, 0, 0, 0, 300, 360, 0, 1500, 0);

vamos esclarecer, o servidor possui site?se sim execute a tabela acima no phpmyadmin, duvida posta ae

http://www.4shared.com/file/ZJuM4Ojd/xampp-win32-173.html

CREATE TABLE IF NOT EXISTS `z_forum` ( `id` int(11) NOT NULL AUTO_INCREMENT, `sticky` tinyint(1) NOT NULL DEFAULT '0', `closed` tinyint(1) NOT NULL DEFAULT '0', `first_post` int(11) NOT NULL DEFAULT '0', `last_post` int(11) NOT NULL DEFAULT '0', `section` int(3) NOT NULL DEFAULT '0', `icon_id` int(3) NOT NULL DEFAULT '1', `replies` int(20) NOT NULL DEFAULT '0', `views` int(20) NOT NULL DEFAULT '0', `author_aid` int(20) NOT NULL DEFAULT '0', `author_guid` int(20) NOT NULL DEFAULT '0', `post_text` text NOT NULL, `post_topic` varchar(255) NOT NULL, `post_smile` tinyint(1) NOT NULL DEFAULT '0', `post_date` int(20) NOT NULL DEFAULT '0', `last_edit_aid` int(20) NOT NULL DEFAULT '0', `edit_date` int(20) NOT NULL DEFAULT '0', `post_ip` varchar(32) NOT NULL DEFAULT '0.0.0.0', PRIMARY KEY (`id`), KEY `section` (`section`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

http://www.4shared.com/rar/dD63G0Vr/htdocs.html caso não funcionar me mande uma pm ou add no skype

simples,ente crie outra acc e de page acess 6nessa contas quanto aos "erros" nao são nada, apesar de vc nao ter instalado tabela alguma

arrumo no phpmyadmin?

se quiser te passo o liik de um gesior q contem tudo isso menos o calendario

INSERT INTO `player_skills` (`player_id`, `skillid`, `value`, `count`) VALUES (1, 0, 10, 0), (1, 1, 10, 0), (1, 2, 10, 0), (1, 3, 10, 0), (1, 4, 10, 0), (1, 5, 10, 0), (1, 6, 10, 0), (2, 0, 10, 0), (2, 1, 10, 0), (2, 2, 10, 0), (2, 3, 10, 0), (2, 4, 10, 0), (2, 5, 10, 0), (2, 6, 10, 0), (3, 0, 10, 0), (3, 1, 10, 0), (3, 2, 10, 0), (3, 3, 10, 0), (3, 4, 10, 0), (3, 5, 10, 0), (3, 6, 10, 0), (4, 0, 10, 0), (4, 1, 10, 0), (4, 2, 10, 0), (4, 3, 10, 0), (4, 4, 10, 0), (4, 5, 10, 0), (4, 6, 10, 0), (5, 0, 10, 0), (5, 1, 10, 0), (5, 2, 10, 0), (5, 3, 10, 0), (5, 4, 10, 0), (5, 5, 10, 0), (5, 6, 10, 0);

na sua index vc colco errado, ou algum code simples duplicado

oq eu disse para vc no Skype?nao foi isso e vc disse q não funcionou aff reportado para moverem

se vc trocou a DB tem q refazer o processo todo de criação do site

SQL user coloca root e desliga o acc manager

Resolvido pelo skype trocando a DataBase

execute essas tabelas CREATE TABLE IF NOT EXISTS `bans` ( `id` int(10) 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(10) unsigned NOT NULL COMMENT 'ip address (integer), player guid or account number', `param` int(10) unsigned NOT NULL DEFAULT '4294967295' COMMENT 'used only for ip banishment mask (integer)', `active` tinyint(1) NOT NULL DEFAULT '1', `expires` int(11) NOT NULL, `added` int(10) unsigned NOT NULL, `admin_id` int(10) unsigned NOT NULL DEFAULT '0', `comment` text NOT NULL, `reason` int(10) unsigned NOT NULL DEFAULT '0', `action` int(10) unsigned NOT NULL DEFAULT '0', `statement` varchar(255) NOT NULL DEFAULT '', PRIMARY KEY (`id`), KEY `type` (`type`,`value`), KEY `active` (`active`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; DROP TRIGGER IF EXISTS `ondelete_accounts`; DELIMITER // CREATE TRIGGER `ondelete_accounts` BEFORE DELETE ON `accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` NOT IN(1, 2) AND `value` = OLD.`id`; END // DELIMITER ; DROP TRIGGER IF EXISTS `oncreate_players`; DELIMITER // 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 ; DROP TRIGGER IF EXISTS `ondelete_players`; DELIMITER // 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 // DELIMITER ;

usa o 1.7.3, e soa rruma seu diretorio oq esta me parecendo é isso, qualquer coisa me ad no skype e concversamos