Posts: 11
Threads: 5
Joined: Jun 2016
Hello!
I need someone who can help me with Database. In one database i got user:hash, in other i have email:user... How i can compare those to get email:hash, because it's not in same order, and one part is diffrent then other, little bit bigger. Thanks
Posts: 404
Threads: 2
Joined: Dec 2015
The operation you are trying to do is called Item Pairing. There are a few tools around that can do it, including an online one linked below.
Online:
https://hashes.org/tools.php?tool=list_merge
Download:
http://unifiedlm.com/Home
Posts: 11
Threads: 5
Joined: Jun 2016
(01-27-2017, 12:32 AM)Chick3nman Wrote: The operation you are trying to do is called Item Pairing. There are a few tools around that can do it, including an online one linked below.
Online: https://hashes.org/tools.php?tool=list_merge
Download: http://unifiedlm.com/Home
For example i got
Username1:Hash:Salt
and other part is
Username1:Email:Salt
So how i can fix
Posts: 404
Threads: 2
Joined: Dec 2015
You will need to reformat them most likely for either tool to handle them although ULM might work better in this case. It shouldnt be too difficult to remove the usernames and salts and reformat the list. Can easily be done with notepad++ or really any other tool that supports regex(sed, awk, grep, etc.).
Posts: 11
Threads: 5
Joined: Jun 2016
(01-27-2017, 12:43 AM)Chick3nman Wrote: You will need to reformat them most likely for either tool to handle them although ULM might work better in this case. It shouldnt be too difficult to remove the usernames and salts and reformat the list. Can easily be done with notepad++ or really any other tool that supports regex(sed, awk, grep, etc.).
But after i remove user and salt i will have just Emails, so how should i know which Emails to add to which User:Hash
Posts: 404
Threads: 2
Joined: Dec 2015
You will need to reformat the lines in such a way that the username or salt fields can be used to pair the emails with the hashes. It shouldn't be very difficult, here's an example format.
user:Hash$Salt
email:user
Using those formats, you can pair the email and the hash+salt.
Posts: 11
Threads: 5
Joined: Jun 2016
(01-27-2017, 01:02 AM)Chick3nman Wrote: You will need to reformat the lines in such a way that the username or salt fields can be used to pair the emails with the hashes. It shouldn't be very difficult, here's an example format.
user:Hash$Salt
email:user
Using those formats, you can pair the email and the hash+salt.
Yes, but problem is database i have is 3 mil while original User:Email:Salt i 8 million, i can't sort them even in A-Z format because there are some missing lines in between on 3 million one
Posts: 404
Threads: 2
Joined: Dec 2015
It should still be possible to both reformat and pair the lists.
Posts: 5,185
Threads: 230
Joined: Apr 2010