diff options
Diffstat (limited to 'www/html/port_destination.py')
-rwxr-xr-x | www/html/port_destination.py | 68 |
1 files changed, 68 insertions, 0 deletions
diff --git a/www/html/port_destination.py b/www/html/port_destination.py new file mode 100755 index 0000000..cae488d --- /dev/null +++ b/www/html/port_destination.py @@ -0,0 +1,68 @@ +#!/usr/bin/python3 +# -*- coding: utf-8 -*- + +import mod_python +from fonctions import baseHTML, connexionBD, lien + +def index(req): + req.content_type="text/html" + +#check si ip est bien la + try: + port=req.form["port"] + except KeyError: + mod_python.util.redirect(req, "index.py") + +#check si port a le bon format + try: + float(port) + except ValueError: + mod_python.util.redirect(req, "index.py") + + content=str() + +#sql part + conn=connexionBD() + cur=conn.cursor() + + sql="SELECT * FROM paquet WHERE port_destination=%s ORDER BY heure DESC" + sql_count="SELECT COUNT(*) FROM paquet WHERE port_destination=%s" + + cur.execute(sql, (port, )) + conn.commit() + data=cur.fetchall() + + cur.execute(sql_count, (port, )) + conn.commit() + count=cur.fetchone() + + conn.close() +#sql part + +#takes every lines from the select + for i in data : + content+=("""<tr>""" + +"""<td>""" + str(i[1]) + """</td>""" + +"""<td>""" + str(i[2]) + """</td>""" + +"""<td>""" + lien('ip_source.py?ip=' + str(i[3]), str(i[3])) + """</td>""" + +"""<td>""" + lien('ip_destination.py?ip=' + str(i[4]), str(i[4])) + """</td>""" + +"""<td>""" + lien('port_source.py?port=' + str(i[5]), str(i[5])) + """</td>""" + +"""<td>""" + lien('port_destination.py?port=' + str(i[6]), str(i[6])) + """</td>""" + +"""</tr>""") + +#write the html page + req.write(baseHTML("ATS - " + port,""" +<h1>Port destination : """ + port + """</h1> +<div id="tip" style="display:block;"> +Afin de voir le reverse DNS d'une adresse IP, cliquez sur cette dernière dans le tableau <button id="ok" onclick="toggle_div(this,'tip');">OK</button></div> +<p>Nombre de paquets en destination de """+ port + """ : <b>"""+ str(count[0])+ """</b></p> +<div id="tab"> +<table class="data_tab"> +<tr><th>Heure</th><th>Protocole</th><th>IP Source</th><th>IP Destination</th><th>Port Source</th><th>Port Destination</th></tr> +""" ++ content + +""" +</table> +</div> +<script src="tip.js"></script> +""")) |