def reg_user(req, data): if data['utype']=='gyq': logo = '/static/zhiyuw/cy_images/images/gengyunqun.png' else: logo = '/static/zhiyuw/cy_images/images/kaituoquan.png' sql = '''insert into ww_member (username, nickname, password, email, logo, created, regip, status, utype, site_id, bgmusic, credits) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, '%s', %s, '%s', 1) ''' % (data['username'], data['username'], fun.mk_md5(data['password']), data['email'], logo, fun.now(), data['ip'], data['utype'], fun.get_site_id(req), '/static/members/cy_images/music/gohome.mp3') # print sql try: r = unio().executeInsert(sql) if not r: return -1 if data['utype']=='gyq': sql = '''insert into ww_member_normal (id) values (%s)''' % r r2 = unio().execute(sql) elif data['utype']=='ktq': sql = '''insert into ww_member_vip (id) values (%s)''' % r r2 = unio().execute(sql) if r2: sql = '''INSERT INTO ww_account (id) VALUES (%s)''' % r return unio().execute(sql) except Exception, e: print e return -2
def reg_user(req, data): if data['utype']=='gyq': logo = '/static/zhiyuw/cy_images/images/gengyunqun.png' else: logo = '/static/zhiyuw/cy_images/images/kaituoquan.png' sql = '''insert into ww_member (username, nickname, password, phone, email, logo, created, regip, status, utype, site_id, bgmusic, credits) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, '%s', %s, '%s', 1) ''' % (data['username'], data['username'], fun.mk_md5(data['password']), data['username'], data['email'], logo, fun.now(), data['ip'], data['utype'], fun.get_site_id(req), '/static/members/cy_images/music/gohome.mp3') # print sql try: r = unio().executeInsert(sql) if not r: return -1 if data['utype']=='gyq': sql = '''insert into ww_member_normal (id, shoujihao) values (%s, '%s')''' % (r, data.get('phone', '')) r2 = unio().execute(sql) elif data['utype']=='ktq': sql = '''insert into ww_member_vip (id, lianxifangshi) values (%s, '%s')''' % (r, data.get('phone', ''),) r2 = unio().execute(sql) if r2: sql = '''INSERT INTO ww_count (uid) VALUES (%s)''' % r return unio().execute(sql) except Exception, e: print e return -2
def auth(req, data): username = data.get('username') password = data.get('password') utype = data.get('utype') sql = '''select password,id,nickname,username,utype,email,bgmusic,credits,logo from ww_member where site_id=%s and (username='******' or email='%s' or phone='%s') ''' % (fun.get_site_id(req), username, username, username) # print sql r = unio().fetchOne(sql) # print r if not r: if utype=='gyq': sql = '''select password,ww_member.id,nickname,username,utype,email,bgmusic,credits,logo from ww_member, ww_member_normal where site_id=%s and ww_member.id=ww_member_normal.id and ww_member_normal.shoujihao='%s' ''' % (fun.get_site_id(req), username) # print sql r = unio().fetchOne(sql) if not r: sql = '''select password,ww_member.id,nickname,username,utype,email,bgmusic,credits,logo from ww_member, ww_member_vip where site_id=%s and ww_member.id=ww_member_vip.id and ww_member_vip.lianxifangshi='%s' ''' % (fun.get_site_id(req), username) # print sql r = unio().fetchOne(sql) if r and r.pop('password')==fun.mk_md5(password): sql = '''update ww_member set credits=credits+1 where id=%s''' % r['id'] unio().execute(sql) return fun.convert_dengji_list(r)[0]
def auth(req, data): username = data.get('username') password = data.get('password') sql = '''select password,id,nickname,username,utype,email,bgmusic,credits,logo from ww_member where site_id=%s and (username='******' or email='%s') ''' % (fun.get_site_id(req), username, username) # print sql r = unio().fetchOne(sql) # print r if not r: sql = '''select password,ww_member.id,nickname,username,utype,email,bgmusic,credits,logo from ww_member, ww_member_normal where site_id=%s and ww_member.id=ww_member_normal.id and ww_member_normal.shoujihao='%s' ''' % (fun.get_site_id(req), username) # print sql r = unio().fetchOne(sql) if r and r.pop('password')==fun.mk_md5(password): sql = '''update ww_member set credits=credits+1 where id=%s''' % r['id'] unio().execute(sql) return fun.convert_dengji_list(r)[0]
def reset_passwd(passwd, user_name): sql = '''UPDATE ww_member SET password='******' WHERE email='%s' AND status=1''' % (fun.mk_md5(passwd), user_name) # print sql return unio().execute(sql)