From 5e7d446f792a5fba71606a71f6398e249446b1c7 Mon Sep 17 00:00:00 2001
From: clyhtsuriva <clyhtsuriva@gmail.com>
Date: Thu, 21 May 2020 09:18:58 +0200
Subject: Beaucoup de changements

---
 www/html/port_source.py | 68 +++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 68 insertions(+)
 create mode 100755 www/html/port_source.py

(limited to 'www/html/port_source.py')

diff --git a/www/html/port_source.py b/www/html/port_source.py
new file mode 100755
index 0000000..e3c8ab6
--- /dev/null
+++ b/www/html/port_source.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_source=%s ORDER BY heure DESC"
+    sql_count="SELECT COUNT(*) FROM paquet WHERE port_source=%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 source : """ + 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 venant 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>
+"""))
-- 
cgit v1.2.3