• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!
  • 2026 staff recruitment is open! Check it out and consider applying!

[8.4] Mysql

Q

Qunir

New Member
Joined
Aug 18, 2008
Messages
4
Reaction score
0
Witam. Mam problem z mysql. Mój problem polega na tym że jak chcę przywrócić postacie to wyskakuje mi taki błąd:
#1062 - Duplicate entry '1-0' for key 1
Click to expand...

Treść którą wklejam wygląda tak:
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`, `redskull`, `redskulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `hide_char`, `comment`) VALUES
(1, 'Qunir', 0, 6, 1, 100, 0, 185, 185, 15694800, 44, 44, 44, 44, 302, 0, 0, 35, 35, 0, 100, 1, 1002, 1003, 7, '', 10000, 1, 1238875112, 388671680, 1, 0, 0, 0, '', 1238875119, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869464, '1', 1, ''),
(2, 'Szymek', 0, 6, 1, 100, 1, 185, 185, 15694800, 44, 44, 44, 44, 302, 0, 0, 35, 35, 0, 100, 1, 1006, 1006, 7, '', 10000, 1, 1238874591, 392416005, 1, 0, 0, 0, '', 1238874775, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, ''),
(3, 'Druid', 0, 1, 1, 70, 2, 530, 530, 5246300, 0, 0, 0, 0, 128, 0, 56, 2105, 2105, 15880, 100, 1, 1000, 1000, 7, '', 50690, 1, 1238874960, 392416005, 1, 0, 0, 0, '', 1238874983, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, ''),
(4, 'Paladin', 0, 1, 1, 70, 3, 875, 875, 5246300, 0, 0, 0, 0, 128, 0, 21, 1070, 1070, 1, 100, 1, 1000, 1000, 7, '', 51380, 1, 1238874980, 388671680, 1, 0, 0, 0, '', 1238874988, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, ''),
(5, 'Knight', 0, 1, 1, 70, 4, 1220, 1220, 5246300, 0, 0, 0, 0, 128, 0, 9, 380, 380, 2, 100, 1, 1000, 1000, 7, '', 51725, 1, 1238875106, 388671680, 1, 0, 0, 0, '', 1238875111, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, '')
Click to expand...
 
Spróbuj tak
Code: 
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`, `redskull`, `redskulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `hide_char`, `comment`) VALUES
(10, 'Qunir', 0, 6, 1, 100, 0, 185, 185, 15694800, 44, 44, 44, 44, 302, 0, 0, 35, 35, 0, 100, 1, 1002, 1003, 7, '', 10000, 1, 1238875112, 388671680, 1, 0, 0, 0, '', 1238875119, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869464, '1', 1, ''),
(11, 'Szymek', 0, 6, 1, 100, 1, 185, 185, 15694800, 44, 44, 44, 44, 302, 0, 0, 35, 35, 0, 100, 1, 1006, 1006, 7, '', 10000, 1, 1238874591, 392416005, 1, 0, 0, 0, '', 1238874775, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, ''),
(12, 'Druid', 0, 1, 1, 70, 2, 530, 530, 5246300, 0, 0, 0, 0, 128, 0, 56, 2105, 2105, 15880, 100, 1, 1000, 1000, 7, '', 50690, 1, 1238874960, 392416005, 1, 0, 0, 0, '', 1238874983, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, ''),
(13, 'Paladin', 0, 1, 1, 70, 3, 875, 875, 5246300, 0, 0, 0, 0, 128, 0, 21, 1070, 1070, 1, 100, 1, 1000, 1000, 7, '', 51380, 1, 1238874980, 388671680, 1, 0, 0, 0, '', 1238874988, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, ''),
(14, 'Knight', 0, 1, 1, 70, 4, 1220, 1220, 5246300, 0, 0, 0, 0, 128, 0, 9, 380, 380, 2, 100, 1, 1000, 1000, 7, '', 51725, 1, 1238875106, 388671680, 1, 0, 0, 0, '', 1238875111, 0, 0, 201660000, 0, 10, 10, 10, 10, 0, 0, 0, 0, 0, '', 1238869465, '1', 1, '')
Tak nie powinien się powtarzać w bazie klucz id :)
 
Last edited:
Back
Top