old_contents: #!/usr/bin/python
  import pyshark
  import subprocess
  import sqlite3
  from sqlite3 import Error
  
  def create_connection(db_file):
      """ create a database connection to the SQLite database
          specified by the db_file
      :param db_file: database file
      :return: Connection object or None
      """
      try:
          conn = sqlite3.connect(db_file)
          return conn
      except Error as e:
          print(e)
   
      return None
   
  def read_bans(conn):
      """
      Query all rows in the tasks table
      :param conn: the Connection object
      :return:
      """
      cur = conn.cursor()
      cur.execute("SELECT * FROM ipblacklist")
   
      rows = cur.fetchall()
   
      for row in rows:
          lst2.append(row)
  	
  capture = pyshark.LiveCapture(interface='eth0')
  capture.sniff(timeout=50)
  #print len(capture)
  lst1=[]
  #IP bans
  lst2=[]
  
  def blockip(ip):
  	cmd="/sbin/iptables -A INPUT -s "+ip+" -j DROP"
  	print cmd
  	subprocess.call(cmd,shell=True)
   
  def blockIP1(ip):
  	cmd="/sbin/iptables -A INPUT -s "+ip+" -j DROP"
  	subprocess.call(cmd, shell=True)
  	subprocess.call("kill -9 $(/usr/bin/pgrep dumpcap)", shell=True)
  	subprocess.call("/usr/bin/kill -9 $(/usr/bin/pgrep tshark)", shell=True)
  	for i in range(len(capture)):
  		pack=capture[i]
  		print pack
  		lst1.append(pack['ip'].src)
  		#print lst1
  		ulst1=set(lst1)
  		#print ulst1
  		ulst1=list(ulst1)
  	for i in range(len(ulst1)):
  		ip=ulst1[i]
  		if ip in lst2:
  			blockIP1(ip)
  
  database = "C:\\sqlite\db\pythonsqlite.db"
  conn = create_connection(database)
  subprocess.call("kill -9 $(/usr/bin/pgrep dumpcap)", shell=True)
  subprocess.call("/usr/bin/kill -9 $(/usr/bin/pgrep tshark)", shell=True)    
  
new_contents: #!/usr/bin/python
  import pyshark
  import subprocess
  import sqlite3
  from sqlite3 import Error
  
  def create_connection(db_file):
      """ create a database connection to the SQLite database
          specified by the db_file
      :param db_file: database file
      :return: Connection object or None
      """
      try:
          conn = sqlite3.connect(db_file)
          return conn
      except Error as e:
          print(e)
   
      return None
   
  def read_bans(conn):
      """
      Query all rows in the tasks table
      :param conn: the Connection object
      :return:
      """
      cur = conn.cursor()
      cur.execute("SELECT * FROM ipblacklist")
   
      rows = cur.fetchall()
   
      for row in rows:
          lst2.append(row)
  	
  capture = pyshark.LiveCapture(interface='eth0')
  capture.sniff(timeout=50)
  #print len(capture)
  lst1=[]
  #IP bans
  lst2=[]
  
  def blockip(ip):
  	cmd="/sbin/iptables -A INPUT -s "+ip+" -j DROP"
  	print cmd
  	subprocess.call(cmd,shell=True)
   
  def blockIP1(ip):
  	cmd="/sbin/iptables -A INPUT -s "+ip+" -j DROP"
  	subprocess.call(cmd, shell=True)
  	subprocess.call("kill -9 $(/usr/bin/pgrep dumpcap)", shell=True)
  	subprocess.call("/usr/bin/kill -9 $(/usr/bin/pgrep tshark)", shell=True)
  	for i in range(len(capture)):
  		pack=capture[i]
  		print pack
  		lst1.append(pack['ip'].src)
  		#print lst1
  		ulst1=set(lst1)
  		#print ulst1
  		ulst1=list(ulst1)
  	for i in range(len(ulst1)):
  		ip=ulst1[i]
  		if ip in lst2:
  			blockIP1(ip)
  
  database = "ipbans.db"
  #Change to loc of ip bnas
  conn = create_connection(database)
  subprocess.call("kill -9 $(/usr/bin/pgrep dumpcap)", shell=True)
  subprocess.call("/usr/bin/kill -9 $(/usr/bin/pgrep tshark)", shell=True)    
  
subject: Update ipban.py