dúvida Account Management

[hadamais 2]

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

Editado Outubro 20, 2012 por Hadamo

[Piabeta Kun 359]

Voce deletou a conta deles, ou so os players?

[hadamais 2]

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

Editado Outubro 20, 2012 por Hadamo

[Piabeta Kun 359]

é 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);

[VictorWEBMaster 369]

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),;

Editado Outubro 21, 2012 por VictorWebMaster

[Piabeta Kun 359]

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

[hadamais 2]

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

Mas vlw...rep amanhã;

 

Pode fechar!

Editado Outubro 21, 2012 por Hadamo

[MrCatra 24]

Duvida sanada,

 

Topico reportado para moverem.

 

Atenciosamente,MrCatra

[Piabeta Kun 359]

Movido!

[VictorWEBMaster 369]

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.

[Piabeta Kun 359]

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

 

fechado para evitar floods!