def wsync(self): db.execute( 'select word1 ,word2 ,word3 ,word4 ,word5 from user where id="%s"' % self.id) w0rds = db.fetchall()[0] self.word1 = words_fa(glist(w0rds, 0, None)) self.word2 = words_fa(glist(w0rds, 1, None)) self.word3 = words_fa(glist(w0rds, 2, None)) self.word4 = words_fa(glist(w0rds, 3, None)) self.word5 = words_fa(glist(w0rds, 4, None))
def get_id(id): db.execute('SELECT * FROM user where id="%s"' % id) iuser = db.fetchall() return glist(glist(iuser, 0, ''), 1, '')
def __init__(self, id): db.execute( 'SELECT id ,name ,mode ,ready ,fmode ,fmode2 ,fmode3 ,mode2 ,word1,word2,word3,word4,word5 ,sendtime FROM user where id="%s"' % id) ius = db.fetchall()[0] self.id = id self.name = glist(ius, 1, '') self.mode = glist(ius, 2, 'name') self.ready = glist(ius, 3, 'False') self.fmode = glist(ius, 4, None) self.fmode2 = glist(ius, 5, None) self.fmode3 = glist(ius, 6, None) self.mode2 = glist(ius, 7, None) self.word1 = words_fa(glist(ius, 8, None)) self.word2 = words_fa(glist(ius, 9, None)) self.word3 = words_fa(glist(ius, 10, None)) self.word4 = words_fa(glist(ius, 11, None)) self.word5 = words_fa(glist(ius, 12, None)) self.sendtime = int(ius[13]) self.modeed = ''
def atsync (self) : sql , db = dbsync() db.execute ("SELECT modint FROM user WHERE id='%s' " %self.id) myr = db.fetchall () [0] self.modint = glist(myr ,0 ,0)