Ir para conteúdo
  • 0

Account Management


hadamais

Pergunta

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 por Hadamo
Link para o comentário
Compartilhar em outros sites

10 respostass a esta questão

Posts Recomendados

  • 0

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 por Hadamo
Link para o comentário
Compartilhar em outros sites

  • 0

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

Link para o comentário
Compartilhar em outros sites

  • 0

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 por VictorWebMaster
Link para o comentário
Compartilhar em outros sites

  • 0

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

Link para o comentário
Compartilhar em outros sites

  • 0

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.

Link para o comentário
Compartilhar em outros sites

Visitante
Este tópico está impedido de receber novos posts.
×
×
  • Criar Novo...