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