def logLastLogin(id): # insert session key try: db = DBmysql(config.databaseUserName, config.databasePassword, config.databaseName) sql = "UPDATE users SET lastlogin = NOW() WHERE id = %s" % id db.execSQL(sql) except Exception, e: log.log(2, "%s: %s" % (type(e), e)) sys.exit(1)
def learn(self, rip, lip, id): try: db = DBmysql(config.databaseUserName, config.databasePassword, config.databaseName) sql = "INSERT INTO connections (lip, rip, userid) VALUES('%s', '%s', %s) ON DUPLICATE KEY UPDATE rip = '%s', userid = %s" % (lip, rip, id, rip, id) log.log(3, "sql: %s" % (sql)) db.execSQL(sql) except Exception, e: log.log(2, "learn %s: %s" % (type(e), e)) sys.exit(1)
def learn(self, rip, lip, id): try: db = DBmysql(config.databaseUserName, config.databasePassword, config.databaseName) sql = "INSERT INTO connections (lip, rip, userid) VALUES('%s', '%s', %s) ON DUPLICATE KEY UPDATE rip = '%s', userid = %s" % ( lip, rip, id, rip, id) log.log(3, "sql: %s" % (sql)) db.execSQL(sql) except Exception, e: log.log(2, "learn %s: %s" % (type(e), e)) sys.exit(1)