def get_all_gift():
"""
获取当前礼包列表
"""
dat_lst = mysql_connection.get_game_manager_mysql_connection().query(
"SELECT * FROM gift_package")
gift_dict = dict()
for item in dat_lst:
act = dict()
id = int(item['id'])
platform_id = int(item['platform_id'])
server_int_lst = utils.string_split_to_int_list(
item['server_ids'], ',')
time = item['time'].date()
endtime = item['endtime'].date()
name = item['name']
item_id1 = int(item['item_id1'])
item_num1 = int(item['item_num1'])
item_id2 = int(item['item_id2'])
item_num2 = int(item['item_num2'])
item_id3 = int(item['item_id3'])
item_num3 = int(item['item_num3'])
gold = int(item['gold'])
stone = int(item['stone'])
act["id"] = id
act["platform_id"] = platform_id
act["server_int_lst"] = server_int_lst
act["time"] = time
act["endtime"] = endtime
act["name"] = name
act["item_id1"] = item_id1
act["item_num1"] = item_num1
act["item_id2"] = item_id2
act["item_num2"] = item_num2
act["item_id3"] = item_id3
act["item_num3"] = item_num3
act["gold"] = gold
act["stone"] = stone
gift_dict[id] = act
return gift_dict
def get_all_gift():
"""
获取当前礼包列表
"""
dat_lst = mysql_connection.get_game_manager_mysql_connection().query("SELECT * FROM gift_package")
gift_dict = dict()
for item in dat_lst:
act = dict()
id = int(item['id'])
platform_id = int(item['platform_id'])
server_int_lst = utils.string_split_to_int_list(item['server_ids'],',')
time = item['time'].date()
endtime = item['endtime'].date()
name = item['name']
item_id1 = int(item['item_id1'])
item_num1 = int(item['item_num1'])
item_id2 = int(item['item_id2'])
item_num2 = int(item['item_num2'])
item_id3 = int(item['item_id3'])
item_num3 = int(item['item_num3'])
gold = int(item['gold'])
stone = int(item['stone'])
act["id"] = id
act["platform_id"] = platform_id
act["server_int_lst"] = server_int_lst
act["time"] = time
act["endtime"] = endtime
act["name"] = name
act["item_id1"] = item_id1
act["item_num1"] = item_num1
act["item_id2"] = item_id2
act["item_num2"] = item_num2
act["item_id3"] = item_id3
act["item_num3"] = item_num3
act["gold"] = gold
act["stone"] = stone
gift_dict[id] = act
return gift_dict
def get_all_activity(refresh=False):
"""
获取当前活动列表
"""
if ActivityListDat.is_need_refresh() or refresh:
dat_lst = mysql_connection.get_game_manager_mysql_connection().query("SELECT * FROM activity_list")
ActivityListDat.activity_dict = dict()
for item in dat_lst:
act = dict()
id = int(item['id'])
act_id = int(item['activity_id'])
server_int_lst = utils.string_split_to_int_list(item['server_id'],',')
begin_date = item['begin_time'].date()
time_length = int(item['time_length'])
time_distance = int(item['time_distance'])
is_forced_open = int(item['is_forced_open'])
item_id1 = int(item['item_id1'])
item_num1 = int(item['item_num1'])
item_id2 = int(item['item_id2'])
item_num2 = int(item['item_num2'])
item_id3 = int(item['item_id3'])
item_num3 = int(item['item_num3'])
gold = int(item['gold'])
stone = int(item['stone'])
free = int(item['free'])
exp = int(item['exp'])
equip = int(item['equip'])
monster = int(item['monster'])
star = int(item['star'])
discount = int(item['discount'])
title = item['title']
label = item['label']
detail = item['detail']
title2 = item['title2']
label2 = item['label2']
detail2 = item['detail2']
new = item['new']
act["id"] = id
act["activity_id"] = act_id
act["server_int_lst"] = server_int_lst
act["begin_date"] = begin_date
act["time_length"] = time_length
act["time_distance"] = time_distance
act["is_forced_open"] = is_forced_open
act["item_id1"] = item_id1
act["item_num1"] = item_num1
act["item_id2"] = item_id2
act["item_num2"] = item_num2
act["item_id3"] = item_id3
act["item_num3"] = item_num3
act["gold"] = gold
act["stone"] = stone
act["free"] = free
act["exp"] = exp
act["equip"] = equip
act["monster"] = monster
act["star"] = star
act["discount"] = discount
act["title"] = title
act["label"] = label
act["detail"] = detail
act["title2"] = title2
act["label2"] = label2
act["detail2"] = detail2
act["new"] = new
ActivityListDat.activity_dict[act_id] = act
ActivityListDat.cur_refresh_time = datetime.datetime.now()
return ActivityListDat.activity_dict
else:
return ActivityListDat.activity_dict
