pdzinhow 1 Postado Novembro 20, 2008 Share Postado Novembro 20, 2008 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'balance' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:111 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(111): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Row_DAO.php(53): OTS_Player->load(1) #2 C:\xampp\htdocs\pot\OTS_Base_List.php(224): OTS_Row_DAO->__construct(1) #3 C:\xampp\htdocs\accountmanagement.php(62): OTS_Base_List->current() #4 C:\xampp\htdocs\index.php(134): include('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 111 nessa nova versão do gesior q ta como topico fixo! ta dando esse erro alguem sabe explicar como consertar isso? vlw!! Link para o comentário Compartilhar em outros sites More sharing options...
alissonlinneker 2 Postado Novembro 21, 2008 Share Postado Novembro 21, 2008 Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'balance' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:111 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(111): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Row_DAO.php(53): OTS_Player->load(1) #2 C:\xampp\htdocs\pot\OTS_Base_List.php(224): OTS_Row_DAO->__construct(1) #3 C:\xampp\htdocs\accountmanagement.php(62): OTS_Base_List->current() #4 C:\xampp\htdocs\index.php(134): include('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 111 nessa nova versão do gesior q ta como topico fixo! ta dando esse erro alguem sabe explicar como consertar isso? vlw!! sim... qualquer erro que ocorrer nos arquivos da pasta POT, é por causa sa dua DB que esta com algum problema, ou falta de campos... segue aqui a DB do meu OT pra vc poder configurar ae... lembre-se se que esta tabela eu uso no meu ot 8.22, vai resolver seu problema, pode apostar =D -- phpMyAdmin SQL Dump -- version 3.0.0 -- http://www.phpmyadmin.net -- -- Servidor: localhost -- Tempo de Geração: Nov 20, 2008 as 11:05 PM -- Versão do Servidor: 5.0.67 -- Versão do PHP: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Banco de Dados: `crisis` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `id` int(11) NOT NULL auto_increment, `password` varchar(255) NOT NULL default '', `type` int(11) NOT NULL default '1', `premdays` int(11) NOT NULL default '0', `lastday` int(10) unsigned NOT NULL default '0', `key` varchar(20) NOT NULL, `email` varchar(255) NOT NULL default '', `blocked` tinyint(1) NOT NULL default '0', `warnings` int(11) NOT NULL default '0', `group_id` int(11) NOT NULL default '1', `page_lastday` int(11) NOT NULL, `email_new` int(11) NOT NULL, `email_new_time` int(255) NOT NULL, `created` int(11) NOT NULL, `rlname` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `page_access` int(11) NOT NULL default '0', `email_code` varchar(255) NOT NULL default '0', `next_email` int(11) NOT NULL default '0', `premium_points` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=99062643 ; -- -- Gatilhos `accounts` -- DROP TRIGGER IF EXISTS `crisis1`.`ondelete_accounts`; DELIMITER // CREATE TRIGGER `crisis1`.`ondelete_accounts` BEFORE DELETE ON `crisis1`.`accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` != 1 AND `type` != 2 AND `value` = OLD.`id`; END // DELIMITER ; -- -------------------------------------------------------- -- -- Estrutura da tabela `bans` -- CREATE TABLE IF NOT EXISTS `bans` ( `type` int(11) NOT NULL COMMENT 'this field defines if its ip, accountban or namelock', `ip` int(10) unsigned NOT NULL default '0', `mask` int(10) unsigned NOT NULL default '4294967295', `player` int(10) unsigned NOT NULL default '0', `account` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `reason_id` int(11) NOT NULL default '0', `action_id` int(11) NOT NULL default '0', `comment` varchar(60) NOT NULL default '', `banned_by` int(10) unsigned NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `global_storage` -- CREATE TABLE IF NOT EXISTS `global_storage` ( `key` int(10) unsigned NOT NULL, `value` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `groups` -- CREATE TABLE IF NOT EXISTS `groups` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL COMMENT 'group name', `flags` bigint(20) unsigned NOT NULL default '0', `customflags` bigint(20) unsigned NOT NULL default '0', `access` int(11) NOT NULL, `violationaccess` int(11) NOT NULL, `maxdepotitems` int(11) NOT NULL, `maxviplist` int(11) NOT NULL, `outfit` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `guilds` -- CREATE TABLE IF NOT EXISTS `guilds` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL COMMENT 'guild name - nothing else needed here', `ownerid` int(11) NOT NULL, `creationdata` int(11) NOT NULL, `motd` varchar(255) NOT NULL, `rank` varchar(255) NOT NULL, `logo_gfx_name` int(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Gatilhos `guilds` -- DROP TRIGGER IF EXISTS `crisis1`.`oncreate_guilds`; DELIMITER // CREATE TRIGGER `crisis1`.`oncreate_guilds` AFTER INSERT ON `crisis1`.`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 // DELIMITER ; DROP TRIGGER IF EXISTS `crisis1`.`ondelete_guilds`; DELIMITER // CREATE TRIGGER `crisis1`.`ondelete_guilds` BEFORE DELETE ON `crisis1`.`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 // DELIMITER ; -- -------------------------------------------------------- -- -- Estrutura da tabela `guild_invites` -- CREATE TABLE IF NOT EXISTS `guild_invites` ( `player_id` int(10) unsigned NOT NULL default '0', `guild_id` int(10) unsigned NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `guild_ranks` -- CREATE TABLE IF NOT EXISTS `guild_ranks` ( `id` int(11) NOT NULL auto_increment, `guild_id` int(11) NOT NULL COMMENT 'guild', `name` varchar(255) NOT NULL COMMENT 'rank name', `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else', PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `houses` -- CREATE TABLE IF NOT EXISTS `houses` ( `id` int(11) NOT NULL auto_increment, `owner` int(11) NOT NULL, `paid` int(10) unsigned NOT NULL default '0', `warnings` int(11) NOT NULL default '0', `lastwarning` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL, `size` int(10) unsigned NOT NULL default '0', `town` int(10) unsigned NOT NULL default '0', `price` int(10) unsigned NOT NULL default '0', `rent` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=247 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `house_lists` -- CREATE TABLE IF NOT EXISTS `house_lists` ( `house_id` int(11) NOT NULL, `listid` int(11) NOT NULL, `list` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `players` -- CREATE TABLE IF NOT EXISTS `players` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) character set latin1 collate latin1_general_cs NOT NULL, `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 '110', `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 '400', `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', `redskull` tinyint(1) NOT NULL default '0', `redskulltime` bigint(20) NOT NULL default '0', `rank_id` int(11) NOT NULL default '0', `guildnick` varchar(255) character set latin1 collate latin1_general_ci NOT NULL default '', `lastlogout` bigint(20) unsigned NOT NULL default '0', `blessings` tinyint(2) NOT NULL default '0', `direction` int(11) NOT NULL default '0' COMMENT 'NOT IN USE BY THE SERVER', `loss_experience` int(11) NOT NULL default '10', `loss_mana` int(11) NOT NULL default '10', `loss_skills` int(11) NOT NULL default '10', `premend` int(11) NOT NULL default '0', `online` tinyint(4) NOT NULL default '0', `created` int(11) NOT NULL, `nick_verify` varchar(5) NOT NULL, `hide_char` int(11) NOT NULL default '0', `comment` text NOT NULL COMMENT 'Jogador do Crisis', `marriage` int(10) unsigned NOT NULL default '0', `promotion` int(11) NOT NULL default '0', `ban` tinyint(1) NOT NULL default '0', `balance` bigint(20) default '0', `matador` int(1) NOT NULL, `maistempodejogo` int(1) NOT NULL, `melhoresjogadores` int(1) NOT NULL, `x` int(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Gatilhos `players` -- DROP TRIGGER IF EXISTS `crisis1`.`oncreate_players`; DELIMITER // CREATE TRIGGER `crisis1`.`oncreate_players` AFTER INSERT ON `crisis1`.`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 `crisis1`.`ondelete_players`; DELIMITER // CREATE TRIGGER `crisis1`.`ondelete_players` BEFORE DELETE ON `crisis1`.`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 // DELIMITER ; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_deaths` -- CREATE TABLE IF NOT EXISTS `player_deaths` ( `player_id` int(11) NOT NULL, `time` bigint(20) unsigned NOT NULL default '0', `level` int(11) NOT NULL default '1', `killed_by` varchar(255) NOT NULL, `is_player` varchar(255) NOT NULL, KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_depotitems` -- CREATE TABLE IF NOT EXISTS `player_depotitems` ( `player_id` int(11) NOT NULL, `depot_id` int(11) NOT NULL default '0', `sid` int(11) 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(11) NOT NULL default '0', `itemtype` int(11) NOT NULL, `count` int(11) NOT NULL default '0', `attributes` blob NOT NULL, UNIQUE KEY `player_id_2` (`player_id`,`sid`), KEY `player_id` (`player_id`,`depot_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_items` -- CREATE TABLE IF NOT EXISTS `player_items` ( `player_id` int(11) NOT NULL default '0', `pid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `itemtype` int(11) NOT NULL default '0', `count` int(11) NOT NULL default '0', `attributes` blob NOT NULL, KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_skills` -- CREATE TABLE IF NOT EXISTS `player_skills` ( `player_id` int(11) NOT NULL default '0', `skillid` tinyint(4) NOT NULL default '0', `value` int(10) unsigned NOT NULL default '0', `count` int(10) unsigned NOT NULL default '0', KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_spells` -- CREATE TABLE IF NOT EXISTS `player_spells` ( `player_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_storage` -- CREATE TABLE IF NOT EXISTS `player_storage` ( `player_id` int(11) NOT NULL default '0', `key` int(10) unsigned NOT NULL default '0', `value` int(11) NOT NULL default '0', KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_viplist` -- CREATE TABLE IF NOT EXISTS `player_viplist` ( `player_id` int(11) NOT NULL COMMENT 'id of player whose viplist entry it is', `vip_id` int(11) NOT NULL COMMENT 'id of target player of viplist entry', KEY `player_id` (`player_id`), KEY `vip_id` (`vip_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_config` -- CREATE TABLE IF NOT EXISTS `server_config` ( `config` varchar(35) NOT NULL default '', `value` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_motd` -- CREATE TABLE IF NOT EXISTS `server_motd` ( `id` int(11) NOT NULL auto_increment, `text` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_record` -- CREATE TABLE IF NOT EXISTS `server_record` ( `record` int(11) NOT NULL, `timestamp` bigint(20) NOT NULL, PRIMARY KEY (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_reports` -- CREATE TABLE IF NOT EXISTS `server_reports` ( `id` int(11) NOT NULL auto_increment, `player_id` int(10) unsigned 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', `timestamp` bigint(20) NOT NULL default '0', `report` text NOT NULL, `reads` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `player_id` (`player_id`), KEY `reads` (`reads`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `tiles` -- CREATE TABLE IF NOT EXISTS `tiles` ( `id` int(11) NOT NULL auto_increment, `x` int(11) NOT NULL, `y` int(11) NOT NULL, `z` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8841 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `tile_items` -- CREATE TABLE IF NOT EXISTS `tile_items` ( `tile_id` int(11) NOT NULL, `sid` int(11) NOT NULL, `pid` int(11) NOT NULL default '0', `itemtype` int(11) NOT NULL, `count` int(11) NOT NULL default '0', `attributes` blob NOT NULL, KEY `tile_id` (`tile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_monsters` -- CREATE TABLE IF NOT EXISTS `z_monsters` ( `hide_creature` tinyint(1) NOT NULL default '0', `name` varchar(255) NOT NULL, `mana` int(11) NOT NULL, `exp` int(11) NOT NULL, `health` int(11) NOT NULL, `speed_lvl` int(11) NOT NULL default '1', `use_haste` tinyint(1) NOT NULL, `voices` text NOT NULL, `immunities` varchar(255) NOT NULL, `summonable` tinyint(1) NOT NULL, `convinceable` tinyint(1) NOT NULL, `race` varchar(255) NOT NULL, `gfx_name` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_news_big` -- CREATE TABLE IF NOT EXISTS `z_news_big` ( `hide_news` tinyint(1) NOT NULL default '0', `date` int(11) NOT NULL default '0', `author` varchar(255) NOT NULL, `author_id` int(11) NOT NULL, `image_id` int(3) NOT NULL default '0', `topic` varchar(255) NOT NULL, `text` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_news_tickers` -- CREATE TABLE IF NOT EXISTS `z_news_tickers` ( `date` int(11) NOT NULL default '1', `author` int(11) NOT NULL, `image_id` int(3) NOT NULL default '0', `text` text NOT NULL, `hide_ticker` tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_ots_comunication` -- CREATE TABLE IF NOT EXISTS `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_shop_history_item` -- CREATE TABLE IF NOT EXISTS `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_shop_history_pacc` -- CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_shop_offer` -- CREATE TABLE IF NOT EXISTS `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8859 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_spells` -- CREATE TABLE IF NOT EXISTS `z_spells` ( `name` varchar(255) NOT NULL, `spell` varchar(255) NOT NULL, `spell_type` varchar(255) NOT NULL, `mana` int(11) NOT NULL default '0', `lvl` int(11) NOT NULL default '0', `mlvl` int(11) NOT NULL default '0', `soul` int(11) NOT NULL default '0', `pacc` varchar(255) NOT NULL, `vocations` varchar(255) NOT NULL, `conj_count` int(11) NOT NULL default '0', `hide_spell` int(11) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Restrições para as tabelas dumpadas -- -- -- Restrições para a tabela `accounts` -- ALTER TABLE `accounts` ADD CONSTRAINT `accounts_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`); -- -- Restrições para a tabela `guild_ranks` -- ALTER TABLE `guild_ranks` ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `players` -- ALTER TABLE `players` ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`); -- -- Restrições para a tabela `player_deaths` -- ALTER TABLE `player_deaths` ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_depotitems` -- ALTER TABLE `player_depotitems` ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_items` -- ALTER TABLE `player_items` ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_skills` -- ALTER TABLE `player_skills` ADD CONSTRAINT `player_skills_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_spells` -- ALTER TABLE `player_spells` ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_storage` -- ALTER TABLE `player_storage` ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_viplist` -- ALTER TABLE `player_viplist` ADD CONSTRAINT `player_viplist_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `tile_items` -- ALTER TABLE `tile_items` ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE; Link para o comentário Compartilhar em outros sites More sharing options...
pdzinhow 1 Postado Novembro 21, 2008 Autor Share Postado Novembro 21, 2008 sim...qualquer erro que ocorrer nos arquivos da pasta POT, é por causa sa dua DB que esta com algum problema, ou falta de campos... segue aqui a DB do meu OT pra vc poder configurar ae... lembre-se se que esta tabela eu uso no meu ot 8.22, vai resolver seu problema, pode apostar =D -- phpMyAdmin SQL Dump -- version 3.0.0 -- http://www.phpmyadmin.net -- -- Servidor: localhost -- Tempo de Geração: Nov 20, 2008 as 11:05 PM -- Versão do Servidor: 5.0.67 -- Versão do PHP: 5.2.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; -- -- Banco de Dados: `crisis` -- -- -------------------------------------------------------- -- -- Estrutura da tabela `accounts` -- CREATE TABLE IF NOT EXISTS `accounts` ( `id` int(11) NOT NULL auto_increment, `password` varchar(255) NOT NULL default '', `type` int(11) NOT NULL default '1', `premdays` int(11) NOT NULL default '0', `lastday` int(10) unsigned NOT NULL default '0', `key` varchar(20) NOT NULL, `email` varchar(255) NOT NULL default '', `blocked` tinyint(1) NOT NULL default '0', `warnings` int(11) NOT NULL default '0', `group_id` int(11) NOT NULL default '1', `page_lastday` int(11) NOT NULL, `email_new` int(11) NOT NULL, `email_new_time` int(255) NOT NULL, `created` int(11) NOT NULL, `rlname` varchar(255) NOT NULL, `location` varchar(255) NOT NULL, `page_access` int(11) NOT NULL default '0', `email_code` varchar(255) NOT NULL default '0', `next_email` int(11) NOT NULL default '0', `premium_points` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=99062643 ; -- -- Gatilhos `accounts` -- DROP TRIGGER IF EXISTS `crisis1`.`ondelete_accounts`; DELIMITER // CREATE TRIGGER `crisis1`.`ondelete_accounts` BEFORE DELETE ON `crisis1`.`accounts` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` != 1 AND `type` != 2 AND `value` = OLD.`id`; END // DELIMITER ; -- -------------------------------------------------------- -- -- Estrutura da tabela `bans` -- CREATE TABLE IF NOT EXISTS `bans` ( `type` int(11) NOT NULL COMMENT 'this field defines if its ip, accountban or namelock', `ip` int(10) unsigned NOT NULL default '0', `mask` int(10) unsigned NOT NULL default '4294967295', `player` int(10) unsigned NOT NULL default '0', `account` int(10) unsigned NOT NULL default '0', `time` int(10) unsigned NOT NULL default '0', `reason_id` int(11) NOT NULL default '0', `action_id` int(11) NOT NULL default '0', `comment` varchar(60) NOT NULL default '', `banned_by` int(10) unsigned NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `global_storage` -- CREATE TABLE IF NOT EXISTS `global_storage` ( `key` int(10) unsigned NOT NULL, `value` int(11) NOT NULL, PRIMARY KEY (`key`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `groups` -- CREATE TABLE IF NOT EXISTS `groups` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL COMMENT 'group name', `flags` bigint(20) unsigned NOT NULL default '0', `customflags` bigint(20) unsigned NOT NULL default '0', `access` int(11) NOT NULL, `violationaccess` int(11) NOT NULL, `maxdepotitems` int(11) NOT NULL, `maxviplist` int(11) NOT NULL, `outfit` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `guilds` -- CREATE TABLE IF NOT EXISTS `guilds` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL COMMENT 'guild name - nothing else needed here', `ownerid` int(11) NOT NULL, `creationdata` int(11) NOT NULL, `motd` varchar(255) NOT NULL, `rank` varchar(255) NOT NULL, `logo_gfx_name` int(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -- Gatilhos `guilds` -- DROP TRIGGER IF EXISTS `crisis1`.`oncreate_guilds`; DELIMITER // CREATE TRIGGER `crisis1`.`oncreate_guilds` AFTER INSERT ON `crisis1`.`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 // DELIMITER ; DROP TRIGGER IF EXISTS `crisis1`.`ondelete_guilds`; DELIMITER // CREATE TRIGGER `crisis1`.`ondelete_guilds` BEFORE DELETE ON `crisis1`.`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 // DELIMITER ; -- -------------------------------------------------------- -- -- Estrutura da tabela `guild_invites` -- CREATE TABLE IF NOT EXISTS `guild_invites` ( `player_id` int(10) unsigned NOT NULL default '0', `guild_id` int(10) unsigned NOT NULL default '0' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `guild_ranks` -- CREATE TABLE IF NOT EXISTS `guild_ranks` ( `id` int(11) NOT NULL auto_increment, `guild_id` int(11) NOT NULL COMMENT 'guild', `name` varchar(255) NOT NULL COMMENT 'rank name', `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else', PRIMARY KEY (`id`), KEY `guild_id` (`guild_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `houses` -- CREATE TABLE IF NOT EXISTS `houses` ( `id` int(11) NOT NULL auto_increment, `owner` int(11) NOT NULL, `paid` int(10) unsigned NOT NULL default '0', `warnings` int(11) NOT NULL default '0', `lastwarning` int(10) unsigned NOT NULL default '0', `name` varchar(255) NOT NULL, `size` int(10) unsigned NOT NULL default '0', `town` int(10) unsigned NOT NULL default '0', `price` int(10) unsigned NOT NULL default '0', `rent` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=247 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `house_lists` -- CREATE TABLE IF NOT EXISTS `house_lists` ( `house_id` int(11) NOT NULL, `listid` int(11) NOT NULL, `list` text NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `players` -- CREATE TABLE IF NOT EXISTS `players` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) character set latin1 collate latin1_general_cs NOT NULL, `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 '110', `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 '400', `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', `redskull` tinyint(1) NOT NULL default '0', `redskulltime` bigint(20) NOT NULL default '0', `rank_id` int(11) NOT NULL default '0', `guildnick` varchar(255) character set latin1 collate latin1_general_ci NOT NULL default '', `lastlogout` bigint(20) unsigned NOT NULL default '0', `blessings` tinyint(2) NOT NULL default '0', `direction` int(11) NOT NULL default '0' COMMENT 'NOT IN USE BY THE SERVER', `loss_experience` int(11) NOT NULL default '10', `loss_mana` int(11) NOT NULL default '10', `loss_skills` int(11) NOT NULL default '10', `premend` int(11) NOT NULL default '0', `online` tinyint(4) NOT NULL default '0', `created` int(11) NOT NULL, `nick_verify` varchar(5) NOT NULL, `hide_char` int(11) NOT NULL default '0', `comment` text NOT NULL COMMENT 'Jogador do Crisis', `marriage` int(10) unsigned NOT NULL default '0', `promotion` int(11) NOT NULL default '0', `ban` tinyint(1) NOT NULL default '0', `balance` bigint(20) default '0', `matador` int(1) NOT NULL, `maistempodejogo` int(1) NOT NULL, `melhoresjogadores` int(1) NOT NULL, `x` int(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `account_id` (`account_id`), KEY `group_id` (`group_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=18 ; -- -- Gatilhos `players` -- DROP TRIGGER IF EXISTS `crisis1`.`oncreate_players`; DELIMITER // CREATE TRIGGER `crisis1`.`oncreate_players` AFTER INSERT ON `crisis1`.`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 `crisis1`.`ondelete_players`; DELIMITER // CREATE TRIGGER `crisis1`.`ondelete_players` BEFORE DELETE ON `crisis1`.`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 // DELIMITER ; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_deaths` -- CREATE TABLE IF NOT EXISTS `player_deaths` ( `player_id` int(11) NOT NULL, `time` bigint(20) unsigned NOT NULL default '0', `level` int(11) NOT NULL default '1', `killed_by` varchar(255) NOT NULL, `is_player` varchar(255) NOT NULL, KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_depotitems` -- CREATE TABLE IF NOT EXISTS `player_depotitems` ( `player_id` int(11) NOT NULL, `depot_id` int(11) NOT NULL default '0', `sid` int(11) 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(11) NOT NULL default '0', `itemtype` int(11) NOT NULL, `count` int(11) NOT NULL default '0', `attributes` blob NOT NULL, UNIQUE KEY `player_id_2` (`player_id`,`sid`), KEY `player_id` (`player_id`,`depot_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_items` -- CREATE TABLE IF NOT EXISTS `player_items` ( `player_id` int(11) NOT NULL default '0', `pid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `itemtype` int(11) NOT NULL default '0', `count` int(11) NOT NULL default '0', `attributes` blob NOT NULL, KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_skills` -- CREATE TABLE IF NOT EXISTS `player_skills` ( `player_id` int(11) NOT NULL default '0', `skillid` tinyint(4) NOT NULL default '0', `value` int(10) unsigned NOT NULL default '0', `count` int(10) unsigned NOT NULL default '0', KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_spells` -- CREATE TABLE IF NOT EXISTS `player_spells` ( `player_id` int(11) NOT NULL, `name` varchar(255) NOT NULL, KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_storage` -- CREATE TABLE IF NOT EXISTS `player_storage` ( `player_id` int(11) NOT NULL default '0', `key` int(10) unsigned NOT NULL default '0', `value` int(11) NOT NULL default '0', KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `player_viplist` -- CREATE TABLE IF NOT EXISTS `player_viplist` ( `player_id` int(11) NOT NULL COMMENT 'id of player whose viplist entry it is', `vip_id` int(11) NOT NULL COMMENT 'id of target player of viplist entry', KEY `player_id` (`player_id`), KEY `vip_id` (`vip_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_config` -- CREATE TABLE IF NOT EXISTS `server_config` ( `config` varchar(35) NOT NULL default '', `value` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_motd` -- CREATE TABLE IF NOT EXISTS `server_motd` ( `id` int(11) NOT NULL auto_increment, `text` text NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_record` -- CREATE TABLE IF NOT EXISTS `server_record` ( `record` int(11) NOT NULL, `timestamp` bigint(20) NOT NULL, PRIMARY KEY (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `server_reports` -- CREATE TABLE IF NOT EXISTS `server_reports` ( `id` int(11) NOT NULL auto_increment, `player_id` int(10) unsigned 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', `timestamp` bigint(20) NOT NULL default '0', `report` text NOT NULL, `reads` int(11) NOT NULL default '0', PRIMARY KEY (`id`), KEY `player_id` (`player_id`), KEY `reads` (`reads`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `tiles` -- CREATE TABLE IF NOT EXISTS `tiles` ( `id` int(11) NOT NULL auto_increment, `x` int(11) NOT NULL, `y` int(11) NOT NULL, `z` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=8841 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `tile_items` -- CREATE TABLE IF NOT EXISTS `tile_items` ( `tile_id` int(11) NOT NULL, `sid` int(11) NOT NULL, `pid` int(11) NOT NULL default '0', `itemtype` int(11) NOT NULL, `count` int(11) NOT NULL default '0', `attributes` blob NOT NULL, KEY `tile_id` (`tile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_monsters` -- CREATE TABLE IF NOT EXISTS `z_monsters` ( `hide_creature` tinyint(1) NOT NULL default '0', `name` varchar(255) NOT NULL, `mana` int(11) NOT NULL, `exp` int(11) NOT NULL, `health` int(11) NOT NULL, `speed_lvl` int(11) NOT NULL default '1', `use_haste` tinyint(1) NOT NULL, `voices` text NOT NULL, `immunities` varchar(255) NOT NULL, `summonable` tinyint(1) NOT NULL, `convinceable` tinyint(1) NOT NULL, `race` varchar(255) NOT NULL, `gfx_name` varchar(255) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_news_big` -- CREATE TABLE IF NOT EXISTS `z_news_big` ( `hide_news` tinyint(1) NOT NULL default '0', `date` int(11) NOT NULL default '0', `author` varchar(255) NOT NULL, `author_id` int(11) NOT NULL, `image_id` int(3) NOT NULL default '0', `topic` varchar(255) NOT NULL, `text` text NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_news_tickers` -- CREATE TABLE IF NOT EXISTS `z_news_tickers` ( `date` int(11) NOT NULL default '1', `author` int(11) NOT NULL, `image_id` int(3) NOT NULL default '0', `text` text NOT NULL, `hide_ticker` tinyint(1) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_ots_comunication` -- CREATE TABLE IF NOT EXISTS `z_ots_comunication` ( `id` int(11) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `type` varchar(255) NOT NULL, `action` varchar(255) NOT NULL, `param1` varchar(255) NOT NULL, `param2` varchar(255) NOT NULL, `param3` varchar(255) NOT NULL, `param4` varchar(255) NOT NULL, `param5` varchar(255) NOT NULL, `param6` varchar(255) NOT NULL, `param7` varchar(255) NOT NULL, `delete_it` int(2) NOT NULL default '1', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_shop_history_item` -- CREATE TABLE IF NOT EXISTS `z_shop_history_item` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `offer_id` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_shop_history_pacc` -- CREATE TABLE IF NOT EXISTS `z_shop_history_pacc` ( `id` int(11) NOT NULL auto_increment, `to_name` varchar(255) NOT NULL default '0', `to_account` int(11) NOT NULL default '0', `from_nick` varchar(255) NOT NULL, `from_account` int(11) NOT NULL default '0', `price` int(11) NOT NULL default '0', `pacc_days` int(11) NOT NULL default '0', `trans_state` varchar(255) NOT NULL, `trans_start` int(11) NOT NULL default '0', `trans_real` int(11) NOT NULL default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_shop_offer` -- CREATE TABLE IF NOT EXISTS `z_shop_offer` ( `id` int(11) NOT NULL auto_increment, `points` int(11) NOT NULL default '0', `itemid1` int(11) NOT NULL default '0', `count1` int(11) NOT NULL default '0', `itemid2` int(11) NOT NULL default '0', `count2` int(11) NOT NULL default '0', `offer_type` varchar(255) default NULL, `offer_description` text NOT NULL, `offer_name` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8859 ; -- -------------------------------------------------------- -- -- Estrutura da tabela `z_spells` -- CREATE TABLE IF NOT EXISTS `z_spells` ( `name` varchar(255) NOT NULL, `spell` varchar(255) NOT NULL, `spell_type` varchar(255) NOT NULL, `mana` int(11) NOT NULL default '0', `lvl` int(11) NOT NULL default '0', `mlvl` int(11) NOT NULL default '0', `soul` int(11) NOT NULL default '0', `pacc` varchar(255) NOT NULL, `vocations` varchar(255) NOT NULL, `conj_count` int(11) NOT NULL default '0', `hide_spell` int(11) NOT NULL default '0' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Restrições para as tabelas dumpadas -- -- -- Restrições para a tabela `accounts` -- ALTER TABLE `accounts` ADD CONSTRAINT `accounts_ibfk_1` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`); -- -- Restrições para a tabela `guild_ranks` -- ALTER TABLE `guild_ranks` ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `players` -- ALTER TABLE `players` ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `players_ibfk_2` FOREIGN KEY (`group_id`) REFERENCES `groups` (`id`); -- -- Restrições para a tabela `player_deaths` -- ALTER TABLE `player_deaths` ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_depotitems` -- ALTER TABLE `player_depotitems` ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_items` -- ALTER TABLE `player_items` ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_skills` -- ALTER TABLE `player_skills` ADD CONSTRAINT `player_skills_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_spells` -- ALTER TABLE `player_spells` ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_storage` -- ALTER TABLE `player_storage` ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `player_viplist` -- ALTER TABLE `player_viplist` ADD CONSTRAINT `player_viplist_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE, ADD CONSTRAINT `player_viplist_ibfk_2` FOREIGN KEY (`vip_id`) REFERENCES `players` (`id`) ON DELETE CASCADE; -- -- Restrições para a tabela `tile_items` -- ALTER TABLE `tile_items` ADD CONSTRAINT `tile_items_ibfk_1` FOREIGN KEY (`tile_id`) REFERENCES `tiles` (`id`) ON DELETE CASCADE; Pow vlw cara! agora so uma duvida eu uso o xamp 1.6.9 se n me engano a versão eh essa agora tipo eu botei o site la e talz so q n fica online pra ninguem so pra mim pq? tenho q fazer o q pra colocar ele on msm pra qualquer pessoa poder entrar? e vem k essa sua DB q vc postou ai pra mim pode copiar tudo + tudo msm ate com esses titulos q vc botou? q n da erro? ou so as partes sem os titulos q vc botou? vlw! Link para o comentário Compartilhar em outros sites More sharing options...
alissonlinneker 2 Postado Novembro 21, 2008 Share Postado Novembro 21, 2008 Pow vlw cara! agora so uma duvida eu uso o xamp 1.6.9 se n me engano a versão eh essa agora tipo eu botei o site la e talz so q n fica online pra ninguem so pra mim pq? tenho q fazer o q pra colocar ele on msm pra qualquer pessoa poder entrar? e vem k essa sua DB q vc postou ai pra mim pode copiar tudo + tudo msm ate com esses titulos q vc botou? q n da erro? ou so as partes sem os titulos q vc botou? vlw! a db c pode por tudo como q ta lah...depois c muda xD e quanto as pessoas nao poderem entrar no seu site.. verifica as portas... verifica firewall ou qualquer tipo de anti virus.. seu pc e de rede? ou a net vai direto pra ele? Link para o comentário Compartilhar em outros sites More sharing options...
Dlyd 6 Postado Novembro 21, 2008 Share Postado Novembro 21, 2008 Seção errada cara. Tente solucionar seus problema na área de suporte. Fechado. Link para o comentário Compartilhar em outros sites More sharing options...
Posts Recomendados