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 get_context_page(req, cate, id):
sql = '''select post.title, short_url, mobile_url
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory
where blog_blogcategory.slug='%s' and blog_blogcategory.id=cate.blogcategory_id
and cate.blogpost_id=post.id and post.site_id=%s and post.id<%s order by post.id desc limit 0,1''' % \
(cate, fun.get_site_id(req), id)
# print sql
pre_page = unio().fetchOne(sql)
sql = '''select post.title, short_url, mobile_url
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory
where blog_blogcategory.slug='%s' and blog_blogcategory.id=cate.blogcategory_id
and cate.blogpost_id=post.id and post.site_id=%s and post.id>%s limit 0,1''' % \
(cate, fun.get_site_id(req), id)
# print sql
next_page = unio().fetchOne(sql)
return pre_page, next_page
def get_nxt_list(req, n):
sql = '''select post.title, short_url as url, mobile_url, user_name, created, description, featured_image
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory blog_category
where post.status=2 and post.site_id=%s and blog_category.slug in ('zjmk','zxmk', 'rlzx', 'nxt') and cate.blogcategory_id=blog_category.id
and cate.blogpost_id=post.id order by updated desc limit 0,%s;''' % (fun.get_site_id(req),n)
# print sql
return unio().fetchAll(sql)
def get_context_page(req, cate, id):
sql = '''select post.title, short_url, mobile_url
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory
where blog_blogcategory.slug='%s' and blog_blogcategory.id=cate.blogcategory_id
and cate.blogpost_id=post.id and post.site_id=%s and post.id<%s order by post.id desc limit 0,1''' % \
(cate, fun.get_site_id(req), id)
# print sql
pre_page = unio().fetchOne(sql)
sql = '''select post.title, short_url, mobile_url
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory
where blog_blogcategory.slug='%s' and blog_blogcategory.id=cate.blogcategory_id
and cate.blogpost_id=post.id and post.site_id=%s and post.id>%s limit 0,1''' % \
(cate, fun.get_site_id(req), id)
# print sql
next_page = unio().fetchOne(sql)
return pre_page, next_page
def get_nxt_list(req, n):
sql = '''select post.title, short_url as url, mobile_url, user_name, created, description, featured_image
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory blog_category
where post.status=2 and post.site_id=%s and blog_category.slug in ('zjmk','zxmk', 'rlzx', 'nxt') and cate.blogcategory_id=blog_category.id
and cate.blogpost_id=post.id order by updated desc limit 0,%s;''' % (fun.get_site_id(req),n)
# print sql
return unio().fetchAll(sql)
def get_gyq_total(req, zhiwei=None):
if zhiwei:
sql = '''select count(ww_member.id) as total
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and normal.zhiwei='%s' and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
''' % (fun.get_site_id(req), zhiwei)
else:
sql = '''select count(ww_member.id) as total
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
''' % (fun.get_site_id(req))
# print sql
rt = unio().fetchOne(sql)
if rt:
return rt['total']
else:
return 1
def get_ktq_list(req, n, zhuanye=None, page=1):
index = (page-1)*n
if zhuanye:
sql = '''select vip.id, ww_member.logo, utype, zhuti, qiyeming, qiyewangzhi as url,qiyejianjie,ww_zhuanye.desc as zhuanye,
ww_member.credits, vip.qiyejianjie
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.zhuanye='%s' and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
order by ww_member.credits desc limit %s,%s''' % (fun.get_site_id(req), zhuanye, index, n)
else:
sql = '''select vip.id, ww_member.logo, utype, zhuti, qiyeming, qiyewangzhi as url,qiyejianjie,ww_zhuanye.desc as zhuanye,
ww_member.credits, vip.qiyejianjie
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
order by ww_member.credits desc limit %s,%s''' % (fun.get_site_id(req), index, n)
# print sql
rs = unio().fetchAll(sql)
return fun.convert_dengji_list(*rs)
def get_ktq_list(req, n, zhuanye=None, page=1):
index = (page-1)*n
if zhuanye:
sql = '''select vip.id, ww_member.logo, utype, zhuti, qiyeming, qiyewangzhi as url,qiyejianjie,ww_zhuanye.desc as zhuanye,
ww_member.credits, vip.qiyejianjie
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.zhuanye='%s' and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
order by id desc limit %s,%s''' % (fun.get_site_id(req), zhuanye, index, n)
else:
sql = '''select vip.id, ww_member.logo, utype, zhuti, qiyeming, qiyewangzhi as url,qiyejianjie,ww_zhuanye.desc as zhuanye,
ww_member.credits, vip.qiyejianjie
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
order by vip.id desc limit %s,%s''' % (fun.get_site_id(req), index, n)
# print sql
rs = unio().fetchAll(sql)
return fun.convert_dengji_list(*rs)
def get_gyq_list(req, n, zhiwei=None, page=1):
index = (page-1)*n
if zhiwei:
sql = '''select ww_member.id, utype,ww_zhiwei.desc as zhiwei,ww_member.logo,ww_member.nickname,
ww_member.credits, normal.zuoyouming
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and normal.zhiwei='%s' and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
order by normal.id desc limit %s,%s''' % (fun.get_site_id(req), zhiwei, index, n)
else:
sql = '''select ww_member.id, utype,ww_zhiwei.desc as zhiwei,ww_member.logo,ww_member.nickname,
ww_member.credits, normal.zuoyouming
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
order by normal.id desc limit %s,%s''' % (fun.get_site_id(req), index, n)
# print sql
rs = unio().fetchAll(sql)
return fun.convert_dengji_list(*rs)
def get_gyq_list(req, n, zhiwei=None, page=1):
index = (page-1)*n
if zhiwei:
sql = '''select ww_member.id, utype,ww_zhiwei.desc as zhiwei,ww_member.logo,ww_member.nickname,
ww_member.credits, normal.zuoyouming
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and normal.zhiwei='%s' and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
order by ww_member.credits desc limit %s,%s''' % (fun.get_site_id(req), zhiwei, index, n)
else:
sql = '''select ww_member.id, utype,ww_zhiwei.desc as zhiwei,ww_member.logo,ww_member.nickname,
ww_member.credits, normal.zuoyouming
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
order by ww_member.credits desc limit %s,%s''' % (fun.get_site_id(req), index, n)
# print sql
rs = unio().fetchAll(sql)
return fun.convert_dengji_list(*rs)
def get_ktq_total(req, zhuanye=None):
if zhuanye:
sql = '''select count(vip.id) as total
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.zhuanye='%s' and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
''' % (fun.get_site_id(req), zhuanye)
else:
sql = '''select count(vip.id) as total
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
''' % (fun.get_site_id(req))
# print sql
rt = unio().fetchOne(sql)
if rt:
return rt['total']
else:
return 1
def get_gyq_total(req, zhiwei=None):
if zhiwei:
sql = '''select count(ww_member.id) as total
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and normal.zhiwei='%s' and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
''' % (fun.get_site_id(req), zhiwei)
else:
sql = '''select count(ww_member.id) as total
from ww_member_normal normal,ww_member,ww_zhiwei
where ww_member.status=1 and ww_member.site_id=%s and ww_member.id=normal.id and ww_zhiwei.name=normal.zhiwei
''' % (fun.get_site_id(req))
# print sql
rt = unio().fetchOne(sql)
if rt:
return rt['total']
else:
return 1
def get_ktq_total(req, zhuanye=None):
if zhuanye:
sql = '''select count(vip.id) as total
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.zhuanye='%s' and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
''' % (fun.get_site_id(req), zhuanye)
else:
sql = '''select count(vip.id) as total
from ww_member_vip vip, ww_member, ww_zhuanye
where ww_member.status=1 and ww_member.site_id=%s and vip.id=ww_member.id and ww_zhuanye.name=vip.zhuanye
''' % (fun.get_site_id(req))
# print sql
rt = unio().fetchOne(sql)
if rt:
return rt['total']
else:
return 1
def auth_3rd(req, openid, utype):
sql = '''select password,id,nickname,username,utype,email,bgmusic,credits,logo
from ww_member
where site_id=%s and 3rd_id='%s' and 3rd_type='%s';''' % (fun.get_site_id(req), openid, utype)
# print sql
r = unio().fetchOne(sql)
if r:
sql = '''update ww_member set credits=credits+1 where id=%s''' % r['id']
unio().execute(sql)
return fun.convert_dengji_list(r)[0]
def get_cate_total(req, cate):
sql = '''select count(post.title) as total
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory blog_category
where post.status=2 and post.site_id=%s and blog_category.slug='%s' and cate.blogcategory_id=blog_category.id
and cate.blogpost_id=post.id''' % (fun.get_site_id(req), cate)
# print sql
rt = unio().fetchOne(sql)
if rt:
return rt['total']
else:
return 1
def get_cate_total(req, cate):
sql = '''select count(post.title) as total
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory blog_category
where post.status=2 and post.site_id=%s and blog_category.slug='%s' and cate.blogcategory_id=blog_category.id
and cate.blogpost_id=post.id''' % (fun.get_site_id(req), cate)
# print sql
rt = unio().fetchOne(sql)
if rt:
return rt['total']
else:
return 1
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 get_child_list(req, cate):
sql = '''select b.id, b.title, b.slug
from blog_blogcategory a, blog_blogcategory b
where a.slug='%s' and a.id=b.parent_id order by b.ord''' % cate
cate_list = unio().fetchAll(sql)
d = []
for i in cate_list:
sql = '''select d.short_url as url, d.mobile_url, d.title, d.description, d.user_name, d.updated, d.featured_image
from blog_blogpost_categories c, blog_blogpost d
where d.status=2 and d.site_id=%s and c.blogcategory_id=%s and c.blogpost_id=d.id
order by d.updated desc limit 0,10''' % (fun.get_site_id(req), i['id'])
d.append({'title':i['title'], 'more':i['slug'], 'cate_list':unio().fetchAll(sql)})
return d
def get_child_list(req, cate):
sql = '''select b.id, b.title, b.slug
from blog_blogcategory a, blog_blogcategory b
where a.slug='%s' and a.id=b.parent_id order by b.ord''' % cate
cate_list = unio().fetchAll(sql)
d = []
for i in cate_list:
sql = '''select d.short_url as url, d.mobile_url, d.title, d.description, d.user_name, d.updated, d.featured_image
from blog_blogpost_categories c, blog_blogpost d
where d.status=2 and d.site_id=%s and c.blogcategory_id=%s and c.blogpost_id=d.id
order by d.updated desc limit 0,10''' % (fun.get_site_id(req), i['id'])
d.append({'title':i['title'], 'more':i['slug'], 'cate_list':unio().fetchAll(sql)})
return d
def get_cate_list(req, cate, n, page=1):
if not page:
page = 1
else:
page = int(page)
if page<1:
return []
index = (page-1)*n
sql = '''select post.title, short_url as url, mobile_url, user_name, created, description, featured_image
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory blog_category
where post.status=2 and post.site_id=%s and blog_category.slug='%s' and cate.blogcategory_id=blog_category.id
and cate.blogpost_id=post.id order by created desc limit %s,%s;''' % (fun.get_site_id(req), cate, index, n)
# print sql
return unio().fetchAll(sql)
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 get_search_result(req, kw):
sql = '''select short_url as url, title, user_name, updated
from blog_blogpost
where status=2 and site_id='''+ str(fun.get_site_id(req)) +''' and title like '%%'''+kw+"%%'"
# print sql
return unio().fetchAll(sql)
def get_search_result(req, kw):
sql = '''select short_url as url, title, user_name, updated
from blog_blogpost
where post.status=2 and site_id='''+ str(fun.get_site_id(req)) +''' and title like '%%'''+kw+"%%'"
# print sql
return unio().fetchAll(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 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 get_cate_list(req, cate, n, page=1):
if not page:
page = 1
else:
page = int(page)
if page<1:
return []
index = (page-1)*n
sql = '''select post.title, short_url as url, mobile_url, user_name, created, description, featured_image
from blog_blogpost post, blog_blogpost_categories cate, blog_blogcategory blog_category
where post.status=2 and post.site_id=%s and blog_category.slug='%s' and cate.blogcategory_id=blog_category.id
and cate.blogpost_id=post.id order by post.created DESC limit %s,%s;''' % (fun.get_site_id(req), cate, index, n)
# print sql
return unio().fetchAll(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 get_user_article(data, req):
sql = '''select post.title, short_url as url, user_name, created
from blog_blogpost post
where post.site_id=%s and post.status=2 and post.user_id=%s order by updated desc limit 0,%s;''' % (fun.get_site_id(req), data.get('userid',0), 10)
# print sql
return unio().fetchAll(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, 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 get_user_article(data, req, page=1):
num = 10
start = (page-1) * num
end = start + num
sql = '''select post.title, short_url as url, mobile_url, featured_image, user_name, created
from blog_blogpost post
where post.site_id=%s and post.status=2 and post.user_id=%s order by updated desc limit %s,%s;''' % (fun.get_site_id(req), data.get('userid',0), start, end)
# print sql
return unio().fetchAll(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 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
