def portabstractshow(ip='',port='',timesearch='',state='',name='',product='',version='',script='',detail='',page='0',extra='',command='and',head='',city='',hackinfo='',disclosure=''):
localconfig=config.Config()
table=localconfig.porttable
iptable=localconfig.iptable
validresult=False
request_params=[]
values_params=[]
if ip!='':
request_params.append(table+'.'+'ip')
values_params.append(SQLTool.formatstring(ip))
if port!='':
request_params.append('port')
values_params.append(SQLTool.formatstring(port))
if timesearch!='':
request_params.append('timesearch')
values_params.append(SQLTool.formatstring(timesearch))
if state!='':
request_params.append(table+'.'+'state')
values_params.append(SQLTool.formatstring(state))
if name!='':
request_params.append('name')
values_params.append(SQLTool.formatstring(name))
if product!='':
request_params.append('product')
values_params.append(SQLTool.formatstring(product))
if version!='':
request_params.append('version')
values_params.append(SQLTool.formatstring(version))
if script!='':
request_params.append('script')
values_params.append(SQLTool.formatstring(script))
if detail!='':
request_params.append('detail')
values_params.append(SQLTool.formatstring(detail))
if head!='':
request_params.append('head')
values_params.append(SQLTool.formatstring(head))
if city!='':
request_params.append('city')
values_params.append(SQLTool.formatstring(city))
global DBhelp
DBhelp=SQLTool.DBmanager()
DBhelp.connectdb()
content=None
result=None
try:
result,content,count,col=DBhelp.searchtableinfo_byparams([table+' left join ip_maindata on snifferdata.ip=ip_maindata.ip'], ['count(*)'], request_params, values_params,extra=extra,command=command)
except Exception,e:
print str(e)+'portcontrol 58'
if DBhelp is not None:
DBhelp.closedb()
DBhelp=None
return [],0,0
#!/usr/bin/python
#coding:utf-8
from spidertool import SQLTool, config
from ..model import job
limitpage = 15
localconfig = config.Config()
def jobshow(jobname='',
jobstatus='',
username='',
taskid='',
jobport='',
result='',
page='0'):
validresult = False
request_params = []
values_params = []
if jobname != '':
request_params.append('taskname')
values_params.append(SQLTool.formatstring(jobname))
if jobstatus != '':
request_params.append('taskstatus')
values_params.append(SQLTool.formatstring(jobstatus))
if username != '':
request_params.append('username')
values_params.append(SQLTool.formatstring(username))
if taskid != '':
request_params.append('taskid')
def portshow(ip='',
port='',
timesearch='',
state='',
name='',
product='',
version='',
script='',
detail='',
page='0',
extra='',
command='and',
head='',
city='',
order='port'):
validresult = False
request_params = []
values_params = []
# 默认ip/page/extra都会传过来(一些端口的限制)
if ip != '':
request_params.append('ip')
values_params.append(SQLTool.formatstring(ip))
if port != '':
request_params.append('port')
values_params.append(SQLTool.formatstring(port))
if timesearch != '':
request_params.append('timesearch')
values_params.append(SQLTool.formatstring(timesearch))
if state != '':
request_params.append('state')
values_params.append(SQLTool.formatstring(state))
if name != '':
request_params.append('name')
values_params.append(SQLTool.formatstring(name))
if product != '':
request_params.append('product')
values_params.append(SQLTool.formatstring(product))
if version != '':
request_params.append('version')
values_params.append(SQLTool.formatstring(version))
if script != '':
request_params.append('script')
values_params.append(SQLTool.formatstring(script))
if detail != '':
request_params.append('detail')
values_params.append(SQLTool.formatstring(detail))
if head != '':
request_params.append('head')
values_params.append(SQLTool.formatstring(head))
if city != '':
request_params.append('city')
values_params.append(SQLTool.formatstring(city))
global DBhelp
DBhelp = SQLTool.DBmanager()
DBhelp.connectdb()
localconfig = config.Config()
port_table = localconfig.porttable #snifferdata
content = None
result = None
try:
result, content, count, col = DBhelp.searchtableinfo_byparams(
[port_table], ['count(*)'],
request_params,
values_params,
extra=extra,
command=command)
except Exception, e:
print str(e) + 'portcontrol 50'
if DBhelp is not None:
DBhelp.closedb()
DBhelp = None
return [], 0, 0
def mapshow(ip='',
port='',
state='',
name='',
product='',
version='',
searchcontent='',
isdic=1):
localconfig = config.Config()
table = localconfig.porttable
iptable = localconfig.iptable
validresult = False
request_params = []
values_params = []
if ip != '':
request_params.append(table + '.' + 'ip')
values_params.append(SQLTool.formatstring(ip))
if port != '':
request_params.append('port')
values_params.append(SQLTool.formatstring(port))
if state != '':
request_params.append(table + '.' + 'state')
values_params.append(SQLTool.formatstring(state))
if name != '':
request_params.append('name')
values_params.append(SQLTool.formatstring(name))
if product != '':
request_params.append('product')
values_params.append(SQLTool.formatstring(product))
if version != '':
request_params.append('version')
values_params.append(SQLTool.formatstring(version))
global DBhelp
DBhelp = SQLTool.DBmanager()
DBhelp.connectdb()
size = 0
content = None
result = None
sql = """"""
if isdic == 0:
if searchcontent == '':
sql = """SELECT city, COUNT(*) FROM ip_maindata GROUP BY city"""
else:
sql = """SELECT city, COUNT(*) FROM (SELECT ip AS ipitem FROM snifferdata WHERE MATCH (version , product , head , detail , script , hackinfo , disclosure , keywords) AGAINST ('%s' IN BOOLEAN MODE)
GROUP BY ip) AS iptable LEFT JOIN ip_maindata ON ipitem = ip_maindata.ip GROUP BY city""" % (
searchcontent)
else:
sql = """SELECT city, COUNT(*) FROM (SELECT ip AS ipitem FROM snifferdata WHERE """
request_params_length = len(request_params)
for k in range(0, request_params_length - 1):
sql = sql + request_params[k] + ' = ' + values_params[k] + ' and '
sql = sql + request_params[request_params_length -
1] + ' = ' + values_params[
request_params_length - 1] + ' '
sql = sql + """ GROUP BY ip) AS iptable LEFT JOIN ip_maindata ON ipitem = ip_maindata.ip GROUP BY city """
try:
result, content, count, col = DBhelp.searchtableinfo_byparams(
table=sql, usesql=1)
except Exception, e:
print str(e) + 'portcontrol 69'
if DBhelp is not None:
DBhelp.closedb()
return [], 0, 0
