+
+ self.chans = []
+
+ chcurs = self.parent.db.cursor()
+ chcurs.execute("SELECT chname FROM chans WHERE bot = %s AND active = 1", (self.nick,))
+ chans = chcurs.fetchall()
+ chcurs.close()
+
+ for chrow in chans:
+ uscurs = self.parent.db.cursor()
+ uscurs.execute("SELECT user, level FROM chusers WHERE chan = %s", (chrow['chname'],))
+ usrow = uscurs.fetchone()
+ levels = {}
+ while usrow is not None:
+ levels[usrow['user']] = -usrow['level']
+ usrow = uscurs.fetchone()
+ uscurs.close()
+ self.chans.append(self.parent.newchannel(self, chrow['chname'], levels))