info
Grupo: Herói
Registrado: 01/05/08
Posts: 2.6k
Reputação: +536
Gênero: Masculino
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!
tenho ai tipo não excluo nada so executo a tabela na sql ou deleto oq tem e depois executo
info
Grupo: Herói
Registrado: 01/05/08
Posts: 2.6k
Reputação: +536
Gênero: Masculino
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.
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
info
Grupo: Artesão
Registrado: 20/04/15
Posts: 134
Reputação: +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