pyrot/irc/common/queries.py

def create_ifnot_onrecord(self, user):
    if not self.db.one("SELECT id FROM users WHERE LOWER(name)=LOWER('" + user + "') AND network='" + self.network + "'"):    # User not on record.
        self.db.run("INSERT INTO users (name, network) VALUES ('" + user + "', '" + self.network + "')")   # Create record.