+ c = main.db.cursor()
+ c.execute("SELECT user, level FROM chusers WHERE chan = %s", (self.name,))
+ row = c.fetchone()
+ while row is not None:
+ self.levels[row['user']] = row['level']
+ row = c.fetchone()
+
+
+ def levelof(self, auth):
+ auth = auth.lower()
+ if auth in self.levels:
+ return self.levels[auth]
+ else:
+ return 0
+
+ def setlevel(self, auth, level, savetodb=True):
+ auth = auth.lower()
+ if savetodb:
+ c = main.db.cursor()
+ c.execute("REPLACE INTO chusers (chan, user, level) VALUES (%s, %s, %s)", (self.name, auth, level))
+ self.levels[auth] = level
+