1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Split large list of emails & ip addresses by geolocation?

Discussion in 'BlackHat Lounge' started by tb303, Nov 16, 2014.

  1. tb303

    tb303 Power Member

    Joined:
    Dec 18, 2011
    Messages:
    601
    Likes Received:
    280
    There doesn't seem to be a forum for email stuff so i'll put this here ;)

    I have a large list of double optin emails ive collected. They are listed like this...
    ip,email

    I want to split this list into different countries by the ip address.

    Im thinking use something like www.iplocation.net and zennoposter to work through the list.

    This seems like an over complicated way of doing it so before I try to set it up does anyone have a simpler method?
     
  2. mardelltisdal99

    mardelltisdal99 Newbie

    Joined:
    Nov 13, 2014
    Messages:
    26
    Likes Received:
    1
    try to sort it out in Excel...
     
  3. Repulsor

    Repulsor Power Member

    Joined:
    Jun 11, 2013
    Messages:
    712
    Likes Received:
    267
    Location:
    PHP Scripting ;)
    One way would be to open it in excel, and group it based on IPs and sort it out with some manual work. Like grouping similar subnets and stuff.

    To make it more accurate, you should use a geo ip database, match each IP to the database, and group accordingly. Thats not that simple, but would be the accurate of all.
     
  4. tb303

    tb303 Power Member

    Joined:
    Dec 18, 2011
    Messages:
    601
    Likes Received:
    280
    there's getting on for 10000 email/ip combinations so no way im doing it manually.

    Looks like its zennoposter then or i might make a http request bot for it if the requests arn't too complex.
     
  5. tb303

    tb303 Power Member

    Joined:
    Dec 18, 2011
    Messages:
    601
    Likes Received:
    280