def DbActiveUser(self,user,active): #acitvates or deactivates an user sql = "UPDATE clients SET Active=%s WHERE User='******'" % (active,user) Database.alter(sql)
def DbAddRow(self,user,mac,ip4,ip6): #add a new user, or updating an exsiting one if len(mac) != 17 and len(ip4) < 7 and len(ip4) > 17: raise ValueError("somthing od with ip4/mac") elif self.get_info_client("User","IP4",ip4): sql = "UPDATE clients set Mac='%s', IP4='%s', IP6='%s', Active=1 WHERE User='******'" % (mac,ip4,ip6,user) else: sql = "INSERT INTO clients VALUES ('%s', '%s', '%s', '%s', 1) " % (user,mac,ip4,ip6) Database.alter(sql)
def DbUpdateRow(self,user,data): #updates one part in a user`s row # maybeh make a better check for it... if len(data) > 17: type = "IP6" elif len(data) == 17: type = "Mac" elif len(data) > 7: type = "IP4" else: raise ValueError("input error") sql = "UPDATE clients SET %s='%s', Active=1 WHERE User='******'" % (type,data,user) Database.alter(sql)
def updateStats(self, user, connections, tx, rx): sql = "select tx_total, rx_total, UNIX_TIMESTAMP(Time) from stats where User='******'" % (user) row = Database.get_row(sql) if row: tx_total = tx + row[0] rx_total = rx + row[1] sec = int(time.time() - row[2]) if sec > 0: txs = tx_total/sec rxs = rx_total/sec else: txs = 0 rxs = 0 sql= "UPDATE stats SET Connections=%i, tx_total=%i, rx_total=%i, txs=%i, rxs=%i, Time=FROM_UNIXTIME(%s) WHERE User='******'" % (connections,tx_total,rx_total,txs,rxs,time.time(),user) else: Time = time.time() sql = "INSERT INTO stats VALUES ('%s', %i, %i, %i, 0, 0,FROM_UNIXTIME(%s))" %(user,connections,tx,rx,Time) Database.alter(sql)
def DbActiveIp4(self, ip4, active): sql ="UPDATE clients SET Active=%i WHERE IP4='%s'" % (active,ip4) Database.alter(sql)