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)
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)
