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