Postado Outubro 4, 2014 10 anos @DiigooMix, negativado por postar isso várias vezes em tópico que com outros assuntos ... LEIA AS REGRAS!
Postado Outubro 4, 2014 10 anos ah sim, obrigado, agora estou com erro no "Step 4" estou com esse erro: STEP 4 Add samples to DB: Query: SELECT `id`, `name`, `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`, `lastlogout`, `blessings`, `balance`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `create_ip`, `create_date`, `comment`, `hide_char` FROM `players` WHERE `name` = 'Account Manager' SQLSTATE: 42S22 Driver code: 1054 Error message: Unknown column 'skill_fist' in 'field list' ( ! ) Fatal error: Call to a member function fetch() on a non-object in D:\Program Files (x86)\VertrigoServ\www\Gesior2012-TFS-1.0\classes\player.php on line 37 Call Stack # Time Memory Function Location 1 0.0010 505400 {main}( ) ..\install.php:0 2 0.0340 1190072 Player->__construct( ) ..\install.php:359 3 0.0340 1190072 Player->load( ) ..\player.php:24 @Digo tente fazer o seguinte, execute essas tabelas que estou passando a vc e me fale se deu algum resultado CREATE TABLE IF NOT EXISTS `accounts` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL DEFAULT '', `password` varchar(255) NOT NULL, `salt` varchar(40) NOT NULL DEFAULT '', `premdays` int(11) NOT NULL DEFAULT '0', `lastday` int(10) unsigned NOT NULL DEFAULT '0', `email` varchar(255) NOT NULL DEFAULT '', `key` varchar(20) NOT NULL DEFAULT '0', `blocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'internal usage', `warnings` int(11) NOT NULL DEFAULT '0', `group_id` int(11) NOT NULL DEFAULT '1', `viptime` int(15) NOT NULL DEFAULT '0', `page_lastday` int(11) NOT NULL, `email_new` varchar(255) NOT NULL, `email_new_time` int(15) NOT NULL, `created` int(11) NOT NULL DEFAULT '0', `rlname` varchar(255) NOT NULL DEFAULT '', `location` varchar(255) NOT NULL DEFAULT '', `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', `vote` int(11) NOT NULL, `last_post` int(11) NOT NULL DEFAULT '0', `flag` varchar(255) NOT NULL, `vip_time` int(11) NOT NULL, PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6741028 ; 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 ; CREATE TABLE IF NOT EXISTS `player_skills` ( `player_id` int(11) NOT NULL DEFAULT '0', `skillid` tinyint(2) NOT NULL DEFAULT '0', `value` int(10) unsigned NOT NULL DEFAULT '0', `count` int(10) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `player_id_2` (`player_id`,`skillid`), KEY `player_id` (`player_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Participe da conversa
Você pode postar agora e se cadastrar mais tarde. Se você tem uma conta, faça o login para postar com sua conta.