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