dúvida ajuda rapida pf!accounts

[sk8sk8ter 2]

achei isso no forum pensei que era pra mudar aquelas lenhas que aparecem um monte de numeros e letras na data base

 

e executei esse comando aki

 

update accounts set password = sha1('minhasenha')

 

e todas as contas mudaram a senha pra minhasenha como eu reverto isso pra voltar ao normal

[Bruno 535]

achei isso no forum pensei que era pra mudar aquelas lenhas que aparecem um monte de numeros e letras na data base

 

e executei esse comando aki

 

update accounts set password = sha1('minhasenha')

 

 

e todas as contas mudaram a senha pra minhasenha como eu reverto isso pra voltar ao normal

Se você tiver um backup é só aplicar, se não tiver, não vai ter como!

[sk8sk8ter 2]

tenho ai tipo não excluo nada so executo a tabela na sql ou deleto oq tem e depois executo

[Bruno 535]

Você pode pegar só a parte do insert accounts, ai você deleta executa novamente.

Não precisa excluir o banco todo, mas apenas os valores.

Certifique-se que está tudo ok antes de excluir.

[sk8sk8ter 2]

tenho essa tabela aki mais não to conseguindo me dis um passo a passo como fazer porfavor

 

 

INSERT INTO `accounts` (`id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `vip_time`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `last_post`, `flag`) VALUES
(1, 'god', 'kc8o8iod', '', 65535, 1433219419, '', '0', 0, 0, 1, 0, 1432746639, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, ''),
(488891, 'IGUINHO', '7fe3269e43e8ff7ca77ee11035b1cdc8a3a2df71', '', 8, 1433219419, 'igor.do.rap@hotmail.com', '', 0, 0, 1, 0, 1433029544, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(680541, 'SOFIA', 'a2aa399eb0b807e1d2c8333b7e456a9f7ed857d4', '', 9, 1433219419, 'sofia_tibia@hotmail.com', '5HFDTFT27F', 0, 0, 1, 0, 1433112334, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(919799, 'TESTE', '7110eda4d09e062aa5e4a390b0a572ac0d2c0220', '', 10, 1433218798, 'asdf@hotmail.com', '', 0, 0, 1, 0, 1433218807, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'bs'),
(1169128, 'BRUNONUNES', 'd24f9e1bbf1e298d129ca24f57bbb3e3792827bc', '', 9, 1433191182, 'br@hotmail.com', '', 0, 0, 1, 0, 1433197621, '', 0, 0, '', '', 0, '0', 0, 15, 0, 0, 'af'),
(1300048, 'JOAOPEDRO', '7e46785083547cebbfea8340f49d662c2689856b', '', 8, 1433219419, 'joaop_sampaio@hotmail.com', '', 0, 0, 1, 0, 1433028694, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(1413879, '3416638', 'cb39356a43840b6129e55805fc0ab03f19a03dca', '', 8, 1433219419, 'liberato_68@hotmail.com', '', 0, 0, 1, 0, 1433028149, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'az'),
(1587524, 'MASTERGM', '1192868b736391dbd3448f5d39fd2205555a7ba5', '', 992, 1433219419, 'hhhh@hotmail.com', '', 0, 0, 1, 0, 1432432873, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(1972351, 'WHIKIDO', '3adb6313def794171d0e53d9d2a8b2fde64cf9e7', '', 7, 1433219419, 'nicolas_rabelo@hotmail.com', '', 0, 0, 1, 0, 1432883965, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'fj'),
(2159118, 'TEPAS', '1192868b736391dbd3448f5d39fd2205555a7ba5', '', 992, 1433213470, 'tepas@hotmail.com', '', 0, 0, 6, 0, 1433213106, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, 'br'),
(2357482, 'KAYQUE157', 'ddf3ae1e22fe1c2a884e64555404773d4f1f3a5f', '', 8, 1433219419, 'kayque_arantina@hotmail.com', '', 0, 0, 1, 0, 1433033900, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(3231506, 'NASASHI', '18a81ff712bf9632eaf5fc31bab5c24a2c0f3f9f', '', 8, 1433219419, 'jdi@kf.com', '', 0, 0, 1, 0, 1433046763, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(3719787, 'LUAN', '18f81dd8cccea2419f4e61754562d1e41492141c', '', 9, 1433219419, 'luancesarskate@gmail.com', 'B56AZHVLVH', 0, 0, 1, 0, 1433114213, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(3829345, 'BRUNOSKATE', '098b8b00636c49ec16827c80941bd129755e273a', '', 992, 1433219419, 'brunobnm77@hotmail.com', '', 0, 0, 1, 0, 1432489103, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'af'),
(4364013, 'SK8SK8TER', '1192868b736391dbd3448f5d39fd2205555a7ba5', '', 992, 1433217265, 'aaa@hotmail.com', '', 0, 0, 1, 0, 1432845901, '', 0, 0, '', '', 0, '0', 0, 75, 0, 0, 'fk'),
(5942993, 'ATIRA', '475729dc6b83de4d8b5e1236ea29e5038d34eaac', '', 10, 1433192768, 'brunobnm77@hotmail.com.br.', '', 0, 0, 1, 0, 1433192824, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'af'),
(6007080, 'ROFIO', '363031b309814cc9b6369ca84af2951417a16b80', '', 8, 1433219419, 'rodrigoroad@hotmail.com', '', 0, 0, 1, 0, 1433030852, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(7557067, '062383', '048f2946e456f837e86f3c1459887d1691fb3309', '', 8, 1433200617, 'leoreis_marilan@hotmail.com', '', 0, 0, 1, 0, 1433034970, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(7621459, '311199', '47e4cb0f38dff06926eae4c9a94f05185930c433', '', 8, 1433219419, 'bafabussa@hotmail.com', '', 0, 0, 1, 0, 1433028153, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(8396301, 'STRADDS', '65413aa1255a999834512f9ef4a5cfdf0c21ea30', '', 992, 1433219419, 'brunobnm77@hotmail.com', '', 0, 0, 1, 0, 1433197549, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'af'),
(8551635, 'LINKYN', 'c32a08a6b75c9e4b36f7a754b561089679c0a2c1', '', 7, 1433219419, 'asuralink@hotmail.com', '', 0, 0, 1, 0, 1432946231, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(9088439, 'BRUNOMEDEIROS', 'cfc9ed01afa4a4621cfc1eecaa1acac54bd8569c', '', 10, 1433192670, 'brunobnm77@hotmail.com.br', '', 0, 0, 1, 0, 0, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'af'),
(9128417, '422175', '7cd5b57d418e1b997853d7835b3327330619131f', '', 9, 1433219419, 'iuridoedao@hotmail.com', '', 0, 0, 1, 0, 1433112922, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, ''),
(9475708, '654654', '22e4420d7a779bdbcfb127325aa68b3a72a9fab9', '', 6, 1433219419, 'jose_asdaoskd@hotmail.com', '', 0, 0, 1, 0, 1432824737, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(9510192, '6551020', '58340fc34d3683ef3dd94a6e6513cf3195785e25', '', 8, 1433219419, 'mds288@bol.com.br', '', 0, 0, 1, 0, 1433025351, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br'),
(9610595, 'MAKAKO', '8bcc6e9b5dfa1d8c0b4e11f97d9b2847fd9f078c', '', 7, 1433219419, 'aioros_humberto@hotmail.com', '', 0, 0, 1, 0, 1432928063, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'va'),
(9899291, 'MIKAIO123', '340cd031b03ee265e449af016f9b16443dc771b6', '', 8, 1433219419, 'guilhermemikaio@gmail.com', '', 0, 0, 1, 0, 1433030178, '', 0, 0, '', '', 0, '0', 0, 0, 0, 0, 'br');

 

resolvi uffa q sorte

[Mudrock 326]

Movido para a área de Duvidas Resolvidas

 

Obrigado