Na falta de atenção, sem querer deletei o Account Manager da DB

e agora os players fazem as contas ma não consegue logar!

Como corrigir essa falha?

Obrigado!

Obs: Os samples tambem foram deletados

Voce deletou a conta deles, ou so os players?

A conta do Account Manager, e consequentemente tbm os samples

Me ajuda ai man, quero resetar nada não.

cheguei à executar isso:

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `pvp_blessing`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`) VALUES
(1, 'Account Manager', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 9, 0, 0, 0, 0, 0, 0, 0, 0, 160, 54, 7, '', 400, 0, 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, ''),
(2, 'Rook Sample', 0, 1, 1, 1, 0, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 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, ''),
(3, 'Sorcerer Sample', 0, 1, 1, 1, 1, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 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, ''),
(4, 'Druid Sample', 0, 1, 1, 1, 2, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 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, ''),
(5, 'Paladin Sample', 0, 1, 1, 1, 3, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 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, ''),
(6, 'Knight Sample', 0, 1, 1, 1, 4, 150, 150, 0, 0, 0, 0, 0, 110, 0, 0, 0, 0, 0, 0, 0, 0, 50, 50, 7, '', 400, 0, 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, '');

Mas não ta dando certo

é pq voce deletou a acc, e essa query so adiciona os players

execute essa query e depois a aque voce postou acima!

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `viptime`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`, `passed`, `block`, `refresh`, `nickname`, `avatar`, `about_me`) VALUES
(1, '1', '356a192b7913b04c54574d18c28d46e6395428ab', '', 65535, 1322335530, '', '', 0, 0, 1, 0, 1316710913, '', 0, 0, '', '', 2, '0', 0, 0, 0, 0, '', 0, 0, 0, 0, NULL, NULL, NULL);

Execute primeiro essa query

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES
(1, '1', '1', '', '65535', 1350574399, '', '0', 0, 0, 4, 1348337802, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0);

Depois essa

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `pvp_blessing`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`) VALUES
(1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 61, 93, 127, 0, 136, 0, 0, 0, 35, 35, 0, 0, 1, 95, 117, 7, '', 400, 0, 1349485002, 218147008, 1, 0, 0, 0, '', 1349485004, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(2, 'Rook Sample', 0, 1, 1, 8, 0, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471460, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471461, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471860, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471459, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471457, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),;

Execute primeiro essa query

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES
(1, '1', '1', '', '65535', 1350574399, '', '0', 0, 0, 4, 1348337802, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0);

 

Depois essa

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `pvp_blessing`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`) VALUES
(1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 61, 93, 127, 0, 136, 0, 0, 0, 35, 35, 0, 0, 1, 95, 117, 7, '', 400, 0, 1349485002, 218147008, 1, 0, 0, 0, '', 1349485004, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(2, 'Rook Sample', 0, 1, 1, 8, 0, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471460, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471461, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471860, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471459, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471457, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),;

Acabei de dizer o mesmo kkk

Galera obrigado, mas depois de todos os erros que deu...desisti e voltei pro 1/1

Mas vlw...rep amanhã;

Pode fechar!

Duvida sanada,

Topico reportado para moverem.

Atenciosamente,MrCatra

Movido!

Execute primeiro essa query

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`, `vip_time`) VALUES
(1, '1', '1', '', '65535', 1350574399, '', '0', 0, 0, 4, 1348337802, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, '', 0);

 

Depois essa

INSERT INTO `players` (`id`, `name`, `world_id`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `lookmount`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `rank_id`, `guildnick`, `lastlogout`, `blessings`, `pvp_blessing`, `balance`, `stamina`, `direction`, `loss_experience`, `loss_mana`, `loss_skills`, `loss_containers`, `loss_items`, `premend`, `online`, `marriage`, `promotion`, `deleted`, `description`, `created`, `nick_verify`, `old_name`, `hide_char`, `worldtransfer`, `comment`, `show_outfit`, `show_eq`, `show_bars`, `show_skills`, `show_quests`) VALUES
(1, 'Account Manager', 0, 1, 1, 8, 0, 180, 180, 4200, 61, 93, 127, 0, 136, 0, 0, 0, 35, 35, 0, 0, 1, 95, 117, 7, '', 400, 0, 1349485002, 218147008, 1, 0, 0, 0, '', 1349485004, 0, 0, 0, 151200000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(2, 'Rook Sample', 0, 1, 1, 8, 0, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471460, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(3, 'Sorcerer Sample', 0, 1, 1, 8, 1, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471461, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(4, 'Druid Sample', 0, 1, 1, 8, 2, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471860, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(5, 'Paladin Sample', 0, 1, 1, 8, 3, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471459, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),
(6, 'Knight Sample', 0, 1, 1, 8, 4, 180, 180, 4200, 61, 93, 127, 0, 128, 0, 0, 0, 35, 35, 0, 0, 1, 50, 50, 7, '', 400, 0, 1349471457, 218147008, 1, 0, 0, 0, '', 0, 0, 0, 0, 201660000, 0, 100, 100, 100, 100, 100, 0, 0, 0, 0, 0, '', 0, 0, '', 0, 0, '', 1, 1, 1, 1, 1),;

 

Acabei de dizer o mesmo kkk

Tu posto o do modern acc auehuaehuaehuaeh.. mas blz.

eu postei a query direto da db que eu tenho aqui!

fechado para evitar floods!