Postado Julho 25, 2014 11 anos Opa galera, ontem eu tava com o Rusherzin é ele me ajudou é deu tudo certo, ai fiz uma merda de troca a database e me fudi todo, agora consegui , ta tudo ok, so que na hora de configurar a samples do characters ta esse erro: #1062 - Duplicate entry '10' for key 'PRIMARY' Aki a sample: 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`, `promotion`, `deleted`, `description`) VALUES (10, 'Naruto Sample', 1, 1, 1, 10, 1, 180, 180, 0, 0, 0, 0, 0, 496, 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, ''), (11, 'Sasuke Sample', 1, 1, 1, 10, 13, 180, 180, 0, 0, 0, 0, 0, 522, 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, ''), (12, 'Lee Sample', 1, 1, 1, 10, 25, 180, 180, 0, 0, 0, 0, 0, 471, 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, ''), (13, 'Sakura Sample', 1, 1, 1, 10, 34, 180, 180, 0, 0, 0, 0, 0, 515, 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, ''), (14, 'Gaara Sample', 1, 1, 1, 10, 50, 180, 180, 0, 0, 0, 0, 0, 67, 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, ''), (15, 'Neji Sample', 1, 1, 1, 10, 70, 180, 180, 0, 0, 0, 0, 0, 504, 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, ''), (16, 'Kiba Sample', 1, 1, 1, 10, 90, 180, 180, 0, 0, 0, 0, 0, 463, 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, ''), (17, 'Shikamaru Sample', 1, 1, 1, 10, 110, 180, 180, 0, 0, 0, 0, 0, 537, 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, ''), (18, 'Hinata Sample', 1, 1, 1, 10, 130, 180, 180, 0, 0, 0, 0, 0, 442, 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, ''), (19, 'Tenten Sample', 1, 1, 1, 10, 150, 180, 180, 0, 0, 0, 0, 0, 548, 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, ''), (20, 'Itachi Sample', 1, 1, 1, 10, 170, 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, ''), (21, 'Killer Bee Sample', 1, 1, 1, 10, 190, 180, 180, 0, 0, 0, 0, 0, 423, 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, ''), (22, 'Kakashi Sample', 1, 1, 1, 10, 200, 180, 180, 0, 0, 0, 0, 0, 451, 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, '') ALGUEM AJUDA? REP+
Postado Julho 25, 2014 11 anos Adicione apenas o account manager e reinstale o site, ele próprio cria os samples. 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, 0, 10, 10, 10, 0, 0); STYLLER OT 2022
Postado Julho 25, 2014 11 anos Autor blz vou tentar aki deu esse erro: #1136 - Column count doesn't match value count at row 1
Postado Julho 25, 2014 11 anos Na sua tabela PLAYERS deve ter alguma coluna a mais, é só arrumar no comando que te mandei, colocando as casa a mais no insert e nos value ... STYLLER OT 2022
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.