class statlogging():
    db = None
    cur = None

    def connect(self):
        self.db = pg2.connect (database="statslog", user="society", password="1234")
        logger.info("Connected to statslogging db!")
        return self.db

    def log(self, name=None, ip='', action='', extra=''):
        if self.db == None:
            self.db = self.connect()
        self.cur = self.db.cursor()
        query = """INSERT INTO stats (date, ip, action, extra)
                    VALUES ('%s', '%s', '%s', '%s');""" % ( datetime.now(), ip, action, extra)
        self.cur.execute(query)
        self.db.commit ()
        logger.info(query)

    def close(self):
        self.cur.close()
        self.db.close()