NOTE: When cracking WPA/WPA2 passwords, make sure you check gpuhash.me first incase it's already been processed.

Home - General Discussion - How to sort the database by keys?

WARNING!
Due to the number of SCAMS going on in the PAID forum, PLEASE ask an ADMIN or MODERATOR to verify ALL found passwords to ensure you are not being SCAMMED.
DO NOT PAY until an ADMIN or MOD has verified them for you!


6 Results - Page 1 of 1 -
1
Author Message
Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sat, 01 Dec 2018 @ 21:43:31

Hello
There are 2 files.
1 file:
.txt weighs 600 gigabytes
there are lines of the form (mail:pass)
testmail@mail.com: 12345678
qwergty@hotmail.com: 123fdfgd112
0chgdvcewbc@aol.com: fggj34438hg8
.........

2 file:
200,000 lines of sight (mail)
qwergty@hotmail.com
2352355235@aol.com
...........

It is necessary from 1 file to pull out all the lines where, there is a match list of emails in 2 file

How to do it?


Avatar
freeroute
Moderator
Status: Trusted
Joined: Sat, 16 Jul 2016
Posts: 2348
Team:
Reputation: 7915 Reputation
Online
Sat, 01 Dec 2018 @ 23:16:37

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com


If I helped a +rep is appreciated!

: 13hDMK85KhVnPb2eTFBacHD6kDjKYFLudb
XMPP: freeroute@xmpp.jp

Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sun, 02 Dec 2018 @ 00:17:33

freeroute said:

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com

How to get the entire line with a password?


Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sun, 02 Dec 2018 @ 01:10:58

freeroute said:

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com


I apologize in advance for my English =)
There is 1.txt
Contains mail: pass

There is 2.txt
Contains mail. No password.

I want to compare 2.txt with 1.txt.

If in 1.txt there is a match in the mail list from 2.txt.

Then I need to output the entire mail: pass string from 1.txt


Avatar
alektrick

Status: n/a
Joined: Mon, 06 Aug 2018
Posts: 6
Team:
Reputation: 2 Reputation
Offline
Sun, 02 Dec 2018 @ 01:11:38

freeroute said:

Command: "cat file1.txt "

testmail@mail.com:12345678
qwergty@hotmail.com:123fdfgd112
0chgdvcewbc@aol.com:fggj34438hg8
testmail1@gmail.com:qwerty
newmail@co.uk:23456

Command: "cat file2.txt "

qwergty@hotmail.com
2352355235@aol.com
testmail1@gmail.com
newmail@co.uk

Emails can be found in the file1.txt only:
comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
0chgdvcewbc@aol.com
testmail@mail.com

Emails can be found in the file2.txt only:
comm -1 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
2352355235@aol.com

Emails can be found in both file:
comm -1 -2 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt )
newmail@co.uk
qwergty@hotmail.com
testmail1@gmail.com


I apologize in advance for my English
There is 1.txt
Contains mail:pass

There is 2.txt
Contains mail. No password.

I want to compare 2.txt with 1.txt.

If in 1.txt there is a match in the mail list from 2.txt.

Then I need to output the entire mail:pass string from 1.txt


Avatar
freeroute
Moderator
Status: Trusted
Joined: Sat, 16 Jul 2016
Posts: 2348
Team:
Reputation: 7915 Reputation
Online
Sun, 02 Dec 2018 @ 06:49:03

Command: "comm -2 -3 <(cut -d: -f 1 file1.txt | sort) <(sort file2.txt ) | grep -vf- file1.txt"

Output:
qwergty@hotmail.com:123fdfgd112
testmail1@gmail.com:qwerty
newmail@co.uk:23456


If I helped a +rep is appreciated!

: 13hDMK85KhVnPb2eTFBacHD6kDjKYFLudb
XMPP: freeroute@xmpp.jp


6 Results - Page 1 of 1 -
1

We have a total of 163692 messages in 20542 topics.
We have a total of 19308 registered users.
Our newest registered member is WeeJobbieMilzo.