def add_3rd_user(req, info, third_type): if third_type=='qq': openid = info['openId'] logo = info['figureurl_qq_2'] password = openid nickname = username = info['nickname'] elif third_type=='weixin': openid = info['unionid'] logo = info['headimgurl'] password = openid nickname = username = info['nickname'] # print username sql = '''select count(id) as num from ww_member where username='******';''' % username r = unio().fetchOne(sql) if r: username = '******' % (username, third_type) utype = '' if req.META.has_key('HTTP_X_FORWARDED_FOR'): ip = req.META['HTTP_X_FORWARDED_FOR'] else: ip = req.META['REMOTE_ADDR'] site_id = fun.get_site_id(req) bg_music = '/static/members/cy_images/music/gohome.mp3' sql = '''insert into ww_member (3rd_id, 3rd_type, username, nickname, password, logo, created, regip, status, utype, site_id, bgmusic, credits) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', 0, '%s', %s, '%s', 1) ''' % (openid, third_type, username, nickname, password, logo, fun.now(), ip, utype, site_id, bg_music) print sql try: return unio().executeInsert(sql) except Exception, e: print e print e.message return None
def post_qiye_comment(req, data): sql = '''insert into ww_qiye_comment (qiye_id, user_name, user_type, lianxi, qianbao, shuoshuo, created, ip, site_id) values ('%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s', '%s')''' % (data['qiye_id'], data['user_name'], data['user_type'], data['lianxi'], data['qianbao'], data['shuoshuo'].replace('\r\n', '<br>'), fun.now(), data['ip'], fun.get_site_id(req)) # print sql return unio().execute(sql)
def add_comments(req, data): sql = '''update blog_blogpost set comments_count=comments_count+1 where id=%s''' % data.get('object_pk') if unio().execute(sql)<0: return False sql = '''insert into django_comments (content_type_id, object_pk, site_id, user_id, user_name, user_email, user_url, comment, submit_date, ip_address, is_public, is_removed) values (14, '%s', %s, '%s', '%s', '%s', '%s', '%s', '%s', '%s', 1, 0)''' % (data['object_pk'], fun.get_site_id(req), data['id'], data['name'], data['email'], data.get('url',''), data['comment'], fun.now(), data['ip']) # print sql if unio().execute(sql)<0: return False return True
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 post_gbook(req, data): sql = '''insert into ww_gbook (name, tel, content, created, status, site_id) values ('%s', '%s', '%s', '%s', 1, %s)''' % \ (data['name'],data['tel'],data['content'].replace('\r\n', '<br>'), fun.now(), fun.get_site_id(req)) # print sql return unio().execute(sql)
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