DBhelp.closedb()
DBhelp = None
portarray = []
if count > 0:
validresult = True
for temp in result:
aport = ports.Port(
ip=temp['ip'],
port=temp['port'],
timesearch=temp['timesearch'],
state=temp['state'],
name=temp['name'],
product=temp['product'],
version=temp['version'],
script=SQLTool.decodestring(temp['script']),
detail=SQLTool.decodestring(temp['detail']),
head=SQLTool.decodestring(temp['head']),
city=temp['city'],
hackinfo=SQLTool.decodestring(temp['hackinfo']),
disclosure=SQLTool.decodestring(temp['disclosure']))
# aport=ports.Port(ip=temp[0],port=temp[1],timesearch=temp[2],state=temp[3],name=temp[4],product=temp[5],version=temp[6],script=temp[7])
portarray.append(aport)
print str(count) + ' ' + str(pagecount)
return portarray, count, pagecount
return [], 0, pagecount
def portshow(ip='',
port='',
result,content,count,col=DBhelp.searchtableinfo_byparams([table+' left join ip_maindata on snifferdata.ip=ip_maindata.ip'], [table+'.'+'ip','port','timesearch',table+'.'+'state','name','product','version','script','detail','head','city','hackinfo','disclosure'], request_params, values_params,limit=limit,order=table+'.'+'port',extra=extra,command=command)
except Exception,e:
print str(e)+'portcontrol 69'
if DBhelp is not None:
DBhelp.closedb()
return [],0,0
if DBhelp is not None:
DBhelp.closedb()
DBhelp=None
portarray=[]
if count>0:
validresult=True
for temp in result :
aport=ports.Port(ip=temp['ip'],port=temp['port'],timesearch=temp['timesearch'],state=temp['state'],name=temp['name'],product=temp['product'],version=temp['version'],script=SQLTool.decodestring(temp['script']),detail=SQLTool.decodestring(temp['detail']),head=SQLTool.decodestring(temp['head']),city=temp['city'],hackinfo=SQLTool.decodestring(temp['hackinfo']),disclosure=SQLTool.decodestring(temp['disclosure']))
# aport=ports.Port(ip=temp[0],port=temp[1],timesearch=temp[2],state=temp[3],name=temp[4],product=temp[5],version=temp[6],script=temp[7])
portarray.append(aport)
print str(count)+' '+str(pagecount)
return portarray,count,pagecount
return [],0,pagecount
def portshow(ip='',port='',timesearch='',state='',name='',product='',version='',script='',detail='',page='0',extra='',command='and',head='',city=''):
validresult=False
request_params=[]
values_params=[]
if ip!='':
request_params.append('ip')
values_params.append(SQLTool.formatstring(ip))
if port!='':
request_params.append('port')
