def balance3(qishu):
# 获取开奖号码
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from bj_10_auto where qishu = '" + qishu + "' ")
rs = cur.fetchall()
hm = [
rs[0]['ball_1'], rs[0]['ball_2'], rs[0]['ball_3'], rs[0]['ball_4'],
rs[0]['ball_5'], rs[0]['ball_6'], rs[0]['ball_7'], rs[0]['ball_8'],
rs[0]['ball_9'], rs[0]['ball_10']
]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute(
"select * from c_bet where type='北京赛车PK拾' and js=0 and qishu='" +
qishu + "' order by addtime asc")
rows = cur.fetchall()
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算第一球
str1 = unicode('冠军', 'utf-8')
if (row['mingxi_1'] == str1):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_1'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_1'])
lh = commonOne.Pk10_Auto(hm, 4, 0)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
lh = unicode(lh, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_1'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == lh):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第二球
str2 = unicode('亚军', 'utf-8')
if (row['mingxi_1'] == str2):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_2'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_2'])
lh = commonOne.Pk10_Auto(hm, 5, 0)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
lh = unicode(lh, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_2'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == lh):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第三球
str3 = unicode('第三名', 'utf-8')
if (row['mingxi_1'] == str3):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_3'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_3'])
lh = commonOne.Pk10_Auto(hm, 6, 0)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
lh = unicode(lh, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_3'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == lh):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第四球
str4 = unicode('第四名', 'utf-8')
if (row['mingxi_1'] == str4):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_4'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_4'])
lh = commonOne.Pk10_Auto(hm, 7, 0)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
lh = unicode(lh, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_4'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == lh):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第五球
str5 = unicode('第五名', 'utf-8')
if (row['mingxi_1'] == str5):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_5'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_5'])
lh = commonOne.Pk10_Auto(hm, 8, 0)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
lh = unicode(lh, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_5'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == lh):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第六球
str6 = unicode('第六名', 'utf-8')
if (row['mingxi_1'] == str6):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_6'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_6'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_6'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第七名
str7 = unicode('第七名', 'utf-8')
if (row['mingxi_1'] == str7):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_7'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_7'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_7'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第八名
str8 = unicode('第八名', 'utf-8')
if (row['mingxi_1'] == str8):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_8'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_8'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_8'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第九名
str9 = unicode('第九名', 'utf-8')
if (row['mingxi_1'] == str9):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_9'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_9'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_9'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第十名
str10 = unicode('第十名', 'utf-8')
if (row['mingxi_1'] == str10):
ds = commonOne.Pk10_Auto(hm, 10, rs[0]['ball_10'])
dx = commonOne.Pk10_Auto(hm, 9, rs[0]['ball_10'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_10'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算冠亚军和
strhe = unicode('冠亚军和', 'utf-8')
if (row['mingxi_1'] == strhe):
zh = commonOne.Pk10_Auto(hm, 1, 0)
dx = commonOne.Pk10_Auto(hm, 2, 0)
ds = commonOne.Pk10_Auto(hm, 3, 0)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(zh) or row['mingxi_2'] == ds
or row['mingxi_2'] == dx):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算龙虎
strhe = unicode('龍虎', 'utf-8')
if (row['mingxi_1'] == strhe):
strhe4 = unicode('1V10 龍虎', 'utf-8')
if (row['mingxi_3'] == strhe4):
zh = commonOne.Pk10_Auto(hm, 4, 0)
zh = unicode(zh, 'utf-8')
if (row['mingxi_2'] == zh):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
strhe4 = unicode('2V9 龍虎', 'utf-8')
if (row['mingxi_3'] == strhe4):
zh = commonOne.Pk10_Auto(hm, 5, 0)
zh = unicode(zh, 'utf-8')
if (row['mingxi_2'] == zh):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
strhe4 = unicode('3V8 龍虎', 'utf-8')
if (row['mingxi_3'] == strhe4):
zh = commonOne.Pk10_Auto(hm, 6, 0)
zh = unicode(zh, 'utf-8')
if (row['mingxi_2'] == zh):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
strhe4 = unicode('4V7 龍虎', 'utf-8')
if (row['mingxi_3'] == strhe4):
zh = commonOne.Pk10_Auto(hm, 7, 0)
zh = unicode(zh, 'utf-8')
if (row['mingxi_2'] == zh):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
strhe4 = unicode('5V6 龍虎', 'utf-8')
if (row['mingxi_3'] == strhe4):
zh = commonOne.Pk10_Auto(hm, 8, 0)
zh = unicode(zh, 'utf-8')
if (row['mingxi_2'] == zh):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
try:
mysql = "update bj_10_auto set ok=1 where qishu=" + qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
def balance12(qishu):
# 获取开奖号码
con = MySQLdb.connect( DB_HOST,DB_USER,DB_PASSWD,DB_NAME,charset='utf8' )
cur = con.cursor ( cursorclass = MySQLdb . cursors . DictCursor )
cur.execute("select * from c_auto_12 where qishu = '"+qishu+"' ")
rs = cur.fetchall()
hm = [rs[0]['ball_1'],rs[0]['ball_2'],rs[0]['ball_3'],rs[0]['ball_4'],rs[0]['ball_5']]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect( DB_HOST,DB_USER_P,DB_PASSWD_P,DB_NAME_PRI,charset='utf8' )
cur = con.cursor ( cursorclass = MySQLdb . cursors . DictCursor )
cur.execute("select * from c_bet where type='新疆时时彩' and js=0 and qishu='"+qishu+"' order by addtime asc")
print "select * from c_bet where type='新疆时时彩' and js=0 and qishu='"+qishu+"' order by addtime asc"
rows = cur.fetchall()
print rows
sum = len(rows)
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算第一球
str1=unicode('第一球','utf-8')
if (row['mingxi_1']==str1):
ds = commonOne.Ssc_Ds(rs[0]['ball_1'])
dx = commonOne.Ssc_Dx(rs[0]['ball_1'])
ds=unicode(ds,'utf-8')
dx=unicode(dx,'utf-8')
if(row['mingxi_2']==str(rs[0]['ball_1']) or row['mingxi_2']==ds or row['mingxi_2']== dx ):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第二球
str2=unicode('第二球','utf-8')
if(row['mingxi_1']==str2):
ds = commonOne.Ssc_Ds(rs[0]['ball_2'])
dx = commonOne.Ssc_Dx(rs[0]['ball_2'])
ds=unicode(ds,'utf-8')
dx=unicode(dx,'utf-8')
if(row['mingxi_2']==str(rs[0]['ball_2']) or row['mingxi_2']==ds or row['mingxi_2']== dx ):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第三球
str3=unicode('第三球','utf-8')
if(row['mingxi_1']==str3):
ds = commonOne.Ssc_Ds(rs[0]['ball_3'])
dx = commonOne.Ssc_Dx(rs[0]['ball_3'])
ds=unicode(ds,'utf-8')
dx=unicode(dx,'utf-8')
if(row['mingxi_2']==str(rs[0]['ball_3']) or row['mingxi_2']==ds or row['mingxi_2']==dx ):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第四球
str4=unicode('第四球','utf-8')
if(row['mingxi_1']==str4):
ds = commonOne.Ssc_Ds(rs[0]['ball_4'])
dx = commonOne.Ssc_Dx(rs[0]['ball_4'])
ds=unicode(ds,'utf-8')
dx=unicode(dx,'utf-8')
if(row['mingxi_2']==str(rs[0]['ball_4']) or row['mingxi_2']==ds or row['mingxi_2']==dx ):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第五球
str5=unicode('第五球','utf-8')
if(row['mingxi_1']==str5):
ds = commonOne.Ssc_Ds(rs[0]['ball_5'])
dx = commonOne.Ssc_Dx(rs[0]['ball_5'])
ds=unicode(ds,'utf-8')
dx=unicode(dx,'utf-8')
if(row['mingxi_2']==str(rs[0]['ball_5']) or row['mingxi_2']==ds or row['mingxi_2']==dx ):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
# 开始结算总和大小
strd=unicode('总和大','utf-8')
strx=unicode('总和小','utf-8')
if(row['mingxi_2']==strd or row['mingxi_2']==strx):
zonghe = commonOne.Ssc_Auto(hm,2)
zonghe=unicode(zonghe,'utf-8')
if(row['mingxi_2']==zonghe):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算总和单双
strd=unicode('总和单','utf-8')
strx=unicode('总和双','utf-8')
if(row['mingxi_2']==strd or row['mingxi_2']==strx):
zonghe = commonOne.Ssc_Auto(hm,3)
zonghe=unicode(zonghe,'utf-8')
if(row['mingxi_2']==zonghe):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算龙虎和
strl=unicode('龙','utf-8')
strh=unicode('虎','utf-8')
strhh=unicode('和','utf-8')
if(row['mingxi_2']==strl or row['mingxi_2']==strh or row['mingxi_2']==strhh):
longhu = commonOne.Ssc_Auto(hm,4)
longhu=unicode(longhu,'utf-8')
if(row['mingxi_2']==longhu):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算前三
strqs=unicode('前三','utf-8')
if(row['mingxi_1']==strqs):
qiansan = commonOne.Ssc_Auto(hm,5)
qiansan=unicode(qiansan,'utf-8')
if(row['mingxi_2']==qiansan):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算中三
strqzs=unicode('中三','utf-8')
if(row['mingxi_1']==strqzs):
zhongsan = commonOne.Ssc_Auto(hm,6)
zhongsan = unicode(zhongsan,'utf-8')
if(row['mingxi_2']==zhongsan):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算后三
strhs=unicode('后三','utf-8')
if(row['mingxi_1']==strhs):
housan = commonOne.Ssc_Auto(hm,7)
housan=unicode(housan,'utf-8')
if(row['mingxi_2']==housan):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算牛牛
strdn=unicode('斗牛','utf-8')
if(row['mingxi_1']==strdn):
if(row['mingxi_2'] in ['牛大','牛小']):
housan = commonOne.Ssc_Auto(hm,8,1)
elif(row['mingxi_2'] in ['牛单','牛双']):
housan = commonOne.Ssc_Auto(hm,8,2)
else:
housan = commonOne.Ssc_Auto(hm,8)
housan=unicode(housan,'utf-8')
if(row['mingxi_2']==housan):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算梭哈
strsh=unicode('梭哈','utf-8')
if(row['mingxi_1']==strsh):
typeall={'五条':1,'四条':2,'葫芦':3,'顺子':4,'三条':5,'两对':6,'一对':7,'散号':8}
housan = commonOne.Ssc_Auto(hm,9,typeall[str(row['mingxi_2'])])
housan=unicode(housan,'utf-8')
if(row['mingxi_2']==housan):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect( DB_HOST,DB_USER,DB_PASSWD,DB_NAME,charset='utf8' )
cur = con.cursor ( cursorclass = MySQLdb . cursors . DictCursor )
try:
mysql="update c_auto_12 set ok=1 where qishu="+qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
def balance8(qishu):
# 获取开奖号码
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from bj_8_auto where qishu = '" + qishu + "' ")
rs = cur.fetchall()
hm = [
rs[0]['ball_1'], rs[0]['ball_2'], rs[0]['ball_3'], rs[0]['ball_4'],
rs[0]['ball_5'], rs[0]['ball_6'], rs[0]['ball_7'], rs[0]['ball_8'],
rs[0]['ball_9'], rs[0]['ball_10'], rs[0]['ball_11'], rs[0]['ball_12'],
rs[0]['ball_13'], rs[0]['ball_14'], rs[0]['ball_15'], rs[0]['ball_16'],
rs[0]['ball_17'], rs[0]['ball_18'], rs[0]['ball_19'], rs[0]['ball_20']
]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from c_bet where type='北京快乐8' and js=0 and qishu='" +
qishu + "' order by addtime asc")
rows = cur.fetchall()
print rows
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算选一
str1 = unicode('选一', 'utf-8')
if (row['mingxi_1'] == str1):
mingxi = int(row['mingxi_2'])
if (mingxi in hm):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第二球
str2 = unicode('选二', 'utf-8')
if (row['mingxi_1'] == str2):
tz = row['mingxi_2'].split(",")
tz[0] = int(tz[0])
tz[1] = int(tz[1])
if ((tz[0] in hm) and (tz[1] in hm)):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第三球
str3 = unicode('选三', 'utf-8')
if (row['mingxi_1'] == str3):
tz = row['mingxi_2'].split(",")
tz[0] = int(tz[0])
tz[1] = int(tz[1])
tz[2] = int(tz[2])
i = 0
for value in tz:
if (int(value) in hm):
i += 1
if (i == 2):
temp = row['mingxi_3'].split(",")
date = temp[1].split(":")
odd = Decimal(date[1])
win = row['money'] * odd
mysql = "update c_bet set win=" + str(win) + ",odds=" + str(
odd) + " where id=" + str(row['id'])
row['win'] = win
cur.execute(mysql)
con.commit()
time.sleep(1.5)
commonOne.win_cbet(row)
elif (i == 3):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第四球
str4 = unicode('选四', 'utf-8')
if (row['mingxi_1'] == str4):
tz = row['mingxi_2'].split(",")
tz[0] = int(tz[0])
tz[1] = int(tz[1])
tz[2] = int(tz[2])
tz[3] = int(tz[3])
i = 0
for value in tz:
if (int(value) in hm):
i += 1
if (i == 2):
temp = row['mingxi_3'].split(",")
date = temp[2].split(":")
odd = Decimal(date[1])
win = row['money'] * odd
row['win'] = win
mysql = "update c_bet set win=" + str(win) + ",odds=" + str(
odd) + " where id=" + str(row['id'])
cur.execute(mysql)
con.commit()
time.sleep(1.5)
commonOne.win_cbet(row)
elif (i == 3):
temp = row['mingxi_3'].split(",")
date = temp[1].split(":")
odd = Decimal(date[1])
win = row['money'] * odd
row['win'] = win
mysql = "update c_bet set win=" + str(win) + ",odds=" + str(
odd) + " where id=" + str(row['id'])
cur.execute(mysql)
con.commit()
time.sleep(1.5)
commonOne.win_cbet(row)
elif (i == 4):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第五球
str5 = unicode('选五', 'utf-8')
if (row['mingxi_1'] == str5):
tz = row['mingxi_2'].split(",")
tz[0] = int(tz[0])
tz[1] = int(tz[1])
tz[2] = int(tz[2])
tz[3] = int(tz[3])
tz[4] = int(tz[4])
i = 0
for value in tz:
if (int(value) in hm):
i += 1
if (i == 3):
temp = row['mingxi_3'].split(",")
date = temp[2].split(":")
odd = Decimal(date[1])
win = row['money'] * odd
row['win'] = win
mysql = "update c_bet set win=" + str(win) + ",odds=" + str(
odd) + " where id=" + str(row['id'])
cur.execute(mysql)
con.commit()
time.sleep(1.5)
commonOne.win_cbet(row)
elif (i == 4):
temp = row['mingxi_3'].split(",")
date = temp[1].split(":")
odd = Decimal(date[1])
win = row['money'] * odd
row['win'] = win
mysql = "update c_bet set win=" + str(win) + ",odds=" + str(
odd) + " where id=" + str(row['id'])
cur.execute(mysql)
con.commit()
time.sleep(1.5)
commonOne.win_cbet(row)
elif (i == 5):
commonOne.win_cbet(row)
else:
commonOne.lost_cbet(row)
#开始结算第六球
strhz = unicode('和值', 'utf-8')
if (row['mingxi_1'] == strhz):
ds = commonOne.Kl8_Auto(hm, 1)
dx = commonOne.Kl8_Auto(hm, 2)
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
strhz = unicode('上中下', 'utf-8')
if (row['mingxi_1'] == strhz):
szx = commonOne.Kl8_Auto(hm, 3)
szx = unicode(szx, 'utf-8')
if (row['mingxi_2'] == szx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第八名
strhz = unicode('奇和偶', 'utf-8')
if (row['mingxi_1'] == strhz):
qho = commonOne.Kl8_Auto(hm, 4)
qho = unicode(qho, 'utf-8')
if (row['mingxi_2'] == qho):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
try:
mysql = "update bj_8_auto set ok=1 where qishu=" + qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
def balance4(qishu):
# 获取开奖号码
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from cq_ten_auto where qishu = '" + qishu + "' ")
rs = cur.fetchall()
hm = [
rs[0]['ball_1'], rs[0]['ball_2'], rs[0]['ball_3'], rs[0]['ball_4'],
rs[0]['ball_5'], rs[0]['ball_6'], rs[0]['ball_7'], rs[0]['ball_8']
]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute(
"select * from c_bet where type='重庆快乐十分' and js=0 and qishu='" +
qishu + "' order by addtime asc")
rows = cur.fetchall()
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算第一球
str1 = unicode('第一球', 'utf-8')
if (row['mingxi_1'] == str1):
ds = commonOne.G10_Ds(rs[0]['ball_1'])
dx = commonOne.G10_Dx(rs[0]['ball_1'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_1'])
hsds = commonOne.G10_HsDs(rs[0]['ball_1'])
fw = commonOne.G10_Fw(rs[0]['ball_1'])
zfb = commonOne.G10_Zfb(rs[0]['ball_1'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_1'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第二球
str2 = unicode('第二球', 'utf-8')
if (row['mingxi_1'] == str2):
ds = commonOne.G10_Ds(rs[0]['ball_2'])
dx = commonOne.G10_Dx(rs[0]['ball_2'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_2'])
hsds = commonOne.G10_HsDs(rs[0]['ball_2'])
fw = commonOne.G10_Fw(rs[0]['ball_2'])
zfb = commonOne.G10_Zfb(rs[0]['ball_2'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_2'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第三球
str3 = unicode('第三球', 'utf-8')
if (row['mingxi_1'] == str3):
ds = commonOne.G10_Ds(rs[0]['ball_3'])
dx = commonOne.G10_Dx(rs[0]['ball_3'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_3'])
hsds = commonOne.G10_HsDs(rs[0]['ball_3'])
fw = commonOne.G10_Fw(rs[0]['ball_3'])
zfb = commonOne.G10_Zfb(rs[0]['ball_3'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_3'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第四球
str4 = unicode('第四球', 'utf-8')
if (row['mingxi_1'] == str4):
ds = commonOne.G10_Ds(rs[0]['ball_4'])
dx = commonOne.G10_Dx(rs[0]['ball_4'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_4'])
hsds = commonOne.G10_HsDs(rs[0]['ball_4'])
fw = commonOne.G10_Fw(rs[0]['ball_4'])
zfb = commonOne.G10_Zfb(rs[0]['ball_4'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_4'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第五球
str5 = unicode('第五球', 'utf-8')
if (row['mingxi_1'] == str5):
ds = commonOne.G10_Ds(rs[0]['ball_5'])
dx = commonOne.G10_Dx(rs[0]['ball_5'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_5'])
hsds = commonOne.G10_HsDs(rs[0]['ball_5'])
fw = commonOne.G10_Fw(rs[0]['ball_5'])
zfb = commonOne.G10_Zfb(rs[0]['ball_5'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_5'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第六球
str6 = unicode('第六球', 'utf-8')
if (row['mingxi_1'] == str6):
ds = commonOne.G10_Ds(rs[0]['ball_6'])
dx = commonOne.G10_Dx(rs[0]['ball_6'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_6'])
hsds = commonOne.G10_HsDs(rs[0]['ball_6'])
fw = commonOne.G10_Fw(rs[0]['ball_6'])
zfb = commonOne.G10_Zfb(rs[0]['ball_6'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_6'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第七球
str7 = unicode('第七球', 'utf-8')
if (row['mingxi_1'] == str7):
ds = commonOne.G10_Ds(rs[0]['ball_7'])
dx = commonOne.G10_Dx(rs[0]['ball_7'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_7'])
hsds = commonOne.G10_HsDs(rs[0]['ball_7'])
fw = commonOne.G10_Fw(rs[0]['ball_7'])
zfb = commonOne.G10_Zfb(rs[0]['ball_7'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_7'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第八球
str8 = unicode('第八球', 'utf-8')
if (row['mingxi_1'] == str8):
ds = commonOne.G10_Ds(rs[0]['ball_8'])
dx = commonOne.G10_Dx(rs[0]['ball_8'])
wsdx = commonOne.G10_WsDx(rs[0]['ball_8'])
hsds = commonOne.G10_HsDs(rs[0]['ball_8'])
fw = commonOne.G10_Fw(rs[0]['ball_8'])
zfb = commonOne.G10_Zfb(rs[0]['ball_8'])
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
wsdx = unicode(wsdx, 'utf-8')
hsds = unicode(hsds, 'utf-8')
fw = unicode(fw, 'utf-8')
zfb = unicode(zfb, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_8'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx
or row['mingxi_2'] == wsdx or row['mingxi_2'] == hsds
or row['mingxi_2'] == fw or row['mingxi_2'] == zfb):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
# 开始结算总和大小
strd = unicode('总和大', 'utf-8')
strx = unicode('总和小', 'utf-8')
if (row['mingxi_2'] == strd or row['mingxi_2'] == strx):
zhdx = commonOne.G10_Auto(hm, 2)
zhdx = unicode(zhdx, 'utf-8')
strhe = unicode('和', 'utf-8')
if (zhdx == strhe):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.invalid_cbet(row)
elif (row['mingxi_2'] == zhdx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算总和单双
strd = unicode('总和单', 'utf-8')
strx = unicode('总和双', 'utf-8')
if (row['mingxi_2'] == strd or row['mingxi_2'] == strx):
zhds = commonOne.G10_Auto(hm, 3)
zhds = unicode(zhds, 'utf-8')
if (row['mingxi_2'] == zhds):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算总和尾数大小
strl = unicode('总和尾大', 'utf-8')
strh = unicode('总和尾小', 'utf-8')
if (row['mingxi_2'] == strl or row['mingxi_2'] == strh):
zhwsdx = commonOne.G10_Auto(hm, 4)
zhwsdx = unicode(zhwsdx, 'utf-8')
if (row['mingxi_2'] == zhwsdx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算龙虎
strl = unicode('龙', 'utf-8')
strh = unicode('虎', 'utf-8')
if (row['mingxi_2'] == strl or row['mingxi_2'] == strh):
lh = commonOne.G10_Auto(hm, 5)
lh = unicode(lh, 'utf-8')
if (row['mingxi_2'] == lh):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#连码
str1 = unicode('任选二', 'utf-8')
str2 = unicode('任选二组', 'utf-8')
str3 = unicode('任选三', 'utf-8')
str4 = unicode('任选四', 'utf-8')
str5 = unicode('任选五', 'utf-8')
if (row['mingxi_1'] == str1 or row['mingxi_1'] == str2
or row['mingxi_1'] == str3 or row['mingxi_1'] == str4
or row['mingxi_1'] == str5):
status = commonOne.G10_nextNum(hm, row['mingxi_1'],
row['mingxi_2'])
if (status == 1):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
try:
mysql = "update cq_ten_auto set ok=1 where qishu=" + qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
def balance13(qishu):
# 获取开奖号码
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from js_k3_auto where qishu = '" + qishu + "' ")
rs = cur.fetchall()
hm = [rs[0]['ball_1'], rs[0]['ball_2'], rs[0]['ball_3']]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from c_bet where type='江苏快3' and js=0 and qishu='" +
qishu + "' order by addtime asc")
print "select * from c_bet where type='江苏快3' and js=0 and qishu='" + qishu + "' order by addtime asc"
rows = cur.fetchall()
print rows
sum = len(rows)
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算第一球
str1 = unicode('和值', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.kuai3(hm, row['mingxi_2'], 1)
str1 = unicode('独胆', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.kuai3(hm, row['mingxi_2'], 3)
str1 = unicode('豹子', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.kuai3(hm, row['mingxi_2'], 4)
str1 = unicode('两连', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.kuai3(hm, row['mingxi_2'], 5)
str1 = unicode('对子', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.kuai3(hm, row['mingxi_2'], 6)
if (status == 1):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
try:
mysql = "update js_k3_auto set ok=1 where qishu=" + qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
def balance5(qishu):
# 获取开奖号码
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from c_auto_5 where qishu = '" + qishu + "' ")
rs = cur.fetchall()
hm = [rs[0]['ball_1'], rs[0]['ball_2'], rs[0]['ball_3']]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from c_bet where type='福彩3D' and js=0 and qishu='" +
qishu + "' order by addtime asc")
rows = cur.fetchall()
sum = len(rows)
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算第一球
str1 = unicode('第一球', 'utf-8')
if (row['mingxi_1'] == str1):
ds = commonOne.FC3D_Auto(hm, 4) #单双
dx = commonOne.FC3D_Auto(hm, 1) #大小
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_1'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第二球
str2 = unicode('第二球', 'utf-8')
if (row['mingxi_1'] == str2):
ds = commonOne.FC3D_Auto(hm, 5) #单双
dx = commonOne.FC3D_Auto(hm, 2) #大小
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_2'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算第三球
str3 = unicode('第三球', 'utf-8')
if (row['mingxi_1'] == str3):
ds = commonOne.FC3D_Auto(hm, 6) #单双
dx = commonOne.FC3D_Auto(hm, 3) #大小
ds = unicode(ds, 'utf-8')
dx = unicode(dx, 'utf-8')
if (row['mingxi_2'] == str(rs[0]['ball_3'])
or row['mingxi_2'] == ds or row['mingxi_2'] == dx):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算独胆
bd = unicode('独胆', 'utf-8')
if (row['mingxi_1'] == bd):
if (row['mingxi_2'] == str(rs[0]['ball_1'])
or row['mingxi_2'] == str(rs[0]['ball_2'])
or row['mingxi_2'] == str(rs[0]['ball_3'])):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算独胆
kd = unicode('跨度', 'utf-8')
if (row['mingxi_1'] == kd):
numSpan = max(abs(rs[0]['ball_1'] - rs[0]['ball_2']),
abs(rs[0]['ball_1'] - rs[0]['ball_3']),
abs(rs[0]['ball_2'] - rs[0]['ball_3']))
if (row['mingxi_2'] == str(numSpan)):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
# 开始结算总和大小
strhd = unicode('总和大', 'utf-8')
strhx = unicode('总和小', 'utf-8')
if (row['mingxi_2'] == strhd or row['mingxi_2'] == strhx):
zonghe = commonOne.FC3D_Auto(hm, 7)
zonghe = unicode(zonghe, 'utf-8')
if (row['mingxi_2'] == zonghe):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算总和单双
strhd = unicode('总和单', 'utf-8')
strhs = unicode('总和双', 'utf-8')
if (row['mingxi_2'] == strhd or row['mingxi_2'] == strhs):
zonghe = commonOne.FC3D_Auto(hm, 8)
zonghe = unicode(zonghe, 'utf-8')
if (row['mingxi_2'] == zonghe):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算龙虎和
strl = unicode('龙', 'utf-8')
strh = unicode('虎', 'utf-8')
strhh = unicode('和', 'utf-8')
if (row['mingxi_2'] == strl or row['mingxi_2'] == strh
or row['mingxi_2'] == strhh):
longhu = commonOne.FC3D_Auto(hm, 9)
longhu = unicode(longhu, 'utf-8')
if (row['mingxi_2'] == longhu):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
#开始结算3连
strsl = unicode('3连', 'utf-8')
if (row['mingxi_1'] == strsl):
qiansan = commonOne.FC3D_Auto(hm, 10)
qiansan = unicode(qiansan, 'utf-8')
if (row['mingxi_2'] == qiansan):
commonOne.win_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
try:
mysql = "update c_auto_5 set ok=1 where qishu=" + qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
def balance7(qishu):
# 获取开奖号码
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from c_auto_7 where nn = '" + qishu + "' ")
rs = cur.fetchall()
hm = [
rs[0]['n1'], rs[0]['n2'], rs[0]['n3'], rs[0]['n4'], rs[0]['n5'],
rs[0]['n6'], rs[0]['na'], rs[0]['x1'], rs[0]['x2'], rs[0]['x3'],
rs[0]['x4'], rs[0]['x5'], rs[0]['x6'], rs[0]['sx']
]
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
cur.execute("select * from c_bet where type='六合彩' and js=0 and qishu='" +
qishu + "' order by addtime asc")
rows = cur.fetchall()
for row in rows:
# cur.execute("select * from k_user where uid="+str(row['uid']))
# users = cur.fetchall()
# user =users[0]
# if(user['water_type']==2):
# sql = " update k_user_cash_record set discount_num="+str(row['fs'])+" where uid="+str(row['uid'])+" and cash_do_type = 3 and souce_id = "+str(row['id']);
# cur.execute(sql)
#开始结算选一
str1 = unicode('特码', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 1)
str1 = unicode('正码', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 2)
str1 = unicode('正特', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 3)
str1 = unicode('正1-6', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 4)
str1 = unicode('过关', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 5)
str1 = unicode('连码', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 6,
row['money'], row['id'])
connew = MySQLdb.connect(DB_HOST,
DB_USER_P,
DB_PASSWD_P,
DB_NAME_PRI,
charset='utf8')
curnew = connew.cursor(cursorclass=MySQLdb.cursors.DictCursor)
curnew.execute("select * from c_bet where id=" + str(row['id']))
data = curnew.fetchall()
row = data[0]
str1 = unicode('半波', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 7)
str1 = unicode('尾数', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 9)
str1 = unicode('生肖', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 10)
str1 = unicode('生肖连', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 11)
str1 = unicode('尾数连', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 12)
str1 = unicode('全不中', 'utf-8')
if (row['mingxi_1'] == str1):
status = commonOne.lhc(hm, row['mingxi_2'], row['mingxi_3'], 13)
if (status == 1):
#如果投注内容等于第二球开奖号码，则视为中奖
commonOne.win_cbet(row)
elif (status == 3):
#如果投注内容等于第一球开奖号码，则视为中奖
commonOne.invalid_cbet(row)
else:
#注单未中奖，修改注单内容
commonOne.lost_cbet(row)
con.commit()
cur.close()
con.close()
# 根据期数读取未结算的注单
con = MySQLdb.connect(DB_HOST, DB_USER, DB_PASSWD, DB_NAME, charset='utf8')
cur = con.cursor(cursorclass=MySQLdb.cursors.DictCursor)
try:
mysql = "update c_auto_7 set ok=1 where nn=" + qishu
cur.execute(mysql)
con.commit()
except MySQLdb.Error, e:
print "期数修改失败!!!"
quit()
