def get_info_client(self,get_type,search_type,search): if type(search) == str: sql = "select %s from clients where %s='%s'" % (get_type,search_type,search) else: # obs. maa vite type i database sql = "select %s from clients where %s={1}" % (get_type,search_type,search) return Database.get_row(sql)[0]
def active(self, type, search): if type(search) == str: sql = "select Active from clients where %s='%s'" % (type,user) else: # obs. maa vite type i database sql = "select Active from clients where %s={1}" % (type,search) active = Database.get_row(sql)[0] if active and active == 1: return True else: return False
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 getIp4(self, ip4): sql = sql = "select * from clients where IP4='%s'" % ip4 return Database.get_row(sql)