def up_cj(CP_ID,amount):
up_cj_sql = "UPDATE t_user_amount SET amount='%s' WHERE user_id='%s';" % (amount,CP_ID)
conn('db_wlt_caipiao',up_cj_sql)
se_cj_sql = "SELECT * FROM t_user_amount WHERE user_id='%s';" % (CP_ID)
r = conn('db_wlt_caipiao',se_cj_sql)
r = r[0]['amount']
return r
def up_tingdou(amount,userid):
up_tingdou_sql = "UPDATE game_user_account SET total_amount='%s', avail_amount='%s' WHERE userid='%s';" % (amount,amount,userid)
conn('db_wlt_gameplatform',up_tingdou_sql)
se_tingdou_sql = "SELECT total_amount FROM game_user_account WHERE userid='%s';" % (userid)
r = conn('db_wlt_gameplatform',se_tingdou_sql)
r = r[0]['total_amount']
return r
def up_tb(amount,userid):
up_tb_sql = "UPDATE game_customize_user_account SET available_coin='%s' WHERE user_id='%s';" % (amount,userid)
conn('db_wlt_gameplatform',up_tb_sql)
se_tb_sql = "SELECT * FROM game_customize_user_account WHERE user_id='%s';" % (userid)
r = conn('db_wlt_gameplatform',se_tb_sql)
r = r[0]['available_coin']
return r
def up_user_account(username,amount,type_id):
se_user_info = "SELECT user_id FROM `t_user` WHERE name = '%s'" % (username)
CP_ID = conn('db_wlt_caipiao',se_user_info)
print('彩票user_id:'+str(CP_ID))
logging.debug('彩票user_id:'+str(CP_ID))
CP_ID = CP_ID[0]['user_id']
select_user_sql = "SELECT GAME_ID,UID FROM passport_relationship WHERE CP_ID = '%s'" % (CP_ID)
r = conn('db_24cp_auth',select_user_sql)
passport_id = r[0]['UID']
userid = r[0]['GAME_ID']
print('游戏user_id:'+str(userid))
logging.debug('游戏user_id:'+str(userid))
if type_id == '1':
output = up_tingdou(amount,userid)
elif type_id == '2':
output = up_td(passport_id,amount)
elif type_id == '3':
output = up_tb(amount,userid)
elif type_id == '4':
output = up_cj(CP_ID,amount)
else:
print('金额类型不正确')
return output
def up_td(passport_id,amount):
se_td_sql = "SELECT * FROM points_user_total WHERE passport_id='%s';" % (passport_id)
r = conn('db_wlt_gamepoint',se_td_sql)
if r == []:
in_td_sql = "INSERT INTO `points_user_total` (`id`, `passport_id`, `points`, `used_points`, `overdue_date`, `delete_flag`, `raw_add_time`, `raw_update_time`, `type`) VALUES ('', '%s', '%s', '0', '0000-00-00 00:00:00', '0', now(), now(), '1');" % (passport_id,amount)
conn('db_wlt_gamepoint',in_td_sql)
else:
up_td_sql = "UPDATE points_user_total SET points='%s' WHERE passport_id='%s';" % (amount,passport_id)
conn('db_wlt_gamepoint',up_td_sql)
r = conn('db_wlt_gamepoint',se_td_sql)
r = r[0]['points']
return r
def up_user_account2(gameid,amount,type_id):
select_user_sql = "SELECT CP_ID,UID FROM passport_relationship WHERE GAME_ID = '%s'" % (gameid)
r = conn('db_24cp_auth',select_user_sql)
passport_id = r[0]['UID']
CP_ID = r[0]['CP_ID']
print('彩票user_id:'+str(CP_ID))
logging.debug('彩票user_id:'+str(CP_ID))
if type_id == '1':
output = up_tingdou(amount,gameid)
elif type_id == '2':
output = up_td(passport_id,amount)
elif type_id == '3':
output = up_tb(amount,gameid)
elif type_id == '4':
output = up_cj(CP_ID,amount)
else:
print('金额类型不正确')
return output
#!/usr/bin/env python3
#-*-coding:utf-8-*-
from tools.db.dbmodule import conn
import random
for x in range(1, 2011):
userid = random.randint(10000000, 90000000)
flowid = random.randint(10000000, 90000000)
sql = "INSERT INTO `db_wlt_gameplatform`.`game_inpour_order` (`flowid`, `userid`, `channelid`, `pay_no`, `bank_code`, `order_amount`, `amount`, `status`, `inpour_rate`, `delete_flag`, `raw_add_time`, `raw_update_time`, `pay_code`, `remark`, `channel_fee`, `convert_flowid`, `convert_orderid`) VALUES ('%s', '%s', '88', '', '', '1.0000', '1.0000', '2', '500.0000', '0', NOW(), NOW(), '', '', '0.0000', '0', '0');" % (
flowid, userid)
r = conn('db_wlt_gameplatform', sql)
def getmatch():
sql = 'SELECT SUM(add_count) AS count FROM game_activity_match_details where match_from = 1;' #当前购买的收费火柴
re = conn('db_wlt_gameplatform', sql)[0]['count']
return re
'robot2_zd_poker': robot2_zd_poker,
'robot2_zd_score': robot2_zd_score,
'robot2_wd_poker': robot2_wd_poker,
'robot2_wd_score': robot2_wd_score,
}
return robot2_pokers_score
if __name__ == "__main__":
try:
id = 8124467
sql = 'SELECT `poker` FROM game_biji_info where id =' + str(id)
#count = conn('db_game_yace','SELECT `id` FROM game_biji_info ORDER BY id DESC LIMIT 1;')
for i in range(8680195, 9124467, 2):
sql = 'SELECT `poker` FROM game_biji_info where id =' + str(i)
r = conn('db_game_yace', sql)
print(i)
i += 2
s = r[0]
poker = s['poker']
re = json.loads(poker)
player_pokers_score = player(re)
robot1_pokers_score = robot1(re)
robot2_pokers_score = robot2(re)
for m in ['td', 'zd', 'wd']:
player_td_poker_score = poker_type(
player_pokers_score['player_' + m + '_poker'])
if player_td_poker_score == player_pokers_score['player_' + m +
'_score']:
output = 'player验证通过=>' + str(player_pokers_score[
'player_' + m + '_poker']) + str(player_td_poker_score)
if __name__ == "__main__":
try:
print(
'''
脚本用于更新账号余额，example：python up_user_account.py [param1] [param2] [param3]
[param1] 登陆用户名
[param2] 金额
[param3] 类型(挺逗=>1|T点=>2|T币=>3|彩金=>4)
'''
)
username = sys.argv[1]
amount = sys.argv[2]
type_id = sys.argv[3]
se_user_info = "SELECT user_id FROM `t_user` WHERE name = '%s'" % (username)
user_id = conn('db_wlt_caipiao',se_user_info)
if user_id:
r = up_user_account(username,amount,type_id)
print("帐户金额更新成功，变更后的金额为:")
logging.debug(r)
print(r)
else:
gameid = username
r = up_user_account2(gameid,amount,type_id)
print("帐户金额更新成功，变更后的金额为:")
logging.debug(r)
print(r)
except Exception as e:
print(e)
#logging.debug(e)
print("请输入正确的参数")
'''
import sys
from tools.db.dbmodule import conn
import logging
logging.basicConfig(
level=logging.DEBUG, #将来布署到生产环境之后就修改成error级别了
format=
'%(asctime)s %(levelname)s %(module)s.%(funcName)s Line:%(lineno)d %(message)s',
filename='/home/www/logs/python/auto_test.log', #日志存放的目录
)
time = '2016-04-27'
sql = "SELECT batch_no from game_customize_pool_batch_info WHERE raw_add_time LIKE '" + time + "%' AND `status`<>2;"
all_batch_no = conn('db_wlt_gameplatform', sql)
sum_prize_amount = 0
sum_recharge_amount = 0
for batch_no in all_batch_no:
#print(batch_no['batch_no'])
sql2 = "SELECT SUM(prize_amount) as prize_amount,sum(recharge_amount) as recharge_amount FROM game_customize_pool_log WHERE batch_no='" + batch_no[
'batch_no'] + "';"
amount = conn('db_wlt_gameplatform', sql2)
prize_amount = amount[0]['prize_amount']
recharge_amount = amount[0]['recharge_amount']
recharge_amount = amount[0]['recharge_amount']
if prize_amount == None:
prize_amount = 0
if recharge_amount == None:
recharge_amount = 0
sum_prize_amount += prize_amount
