def update_game_manager_login_dat(uid, login_ip, login_time):
"""
更新管理员登录ip和时间
"""
sql = "UPDATE admin_manager SET last_login_ip='%s',last_login_time='%s' WHERE id=%s " % (
login_ip, login_time.strftime("%Y-%m-%d %H:%M:%S"), uid)
get_game_manager_mysql_connection().execute(sql)
def update_server(server_id, url, name, state, hidden, version,
open_server_time):
"""
更新新服务器
"""
sql = "SELECT * FROM server_list WHERE id = %s " % server_id
dat = mysql_connection.get_game_manager_mysql_connection().query(sql)
# print("dat: "+str(dat)+"notice: "+str(notice)+"version: "+str(version))
if dat:
sql = "UPDATE server_list SET " \
"id = %s, " \
"url = '%s', " \
"name = '%s', " \
"state = %s, " \
"hidden = %s, " \
"version = '%s', " \
"open_server_time = '%s' " \
"WHERE id = %s" %\
(server_id, url, name, state, hidden, version, open_server_time, server_id)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
else:
sql = "INSERT INTO server_list (id,url,name,state,hidden,version,open_server_time) VALUES (%s,'%s','%s',%s,%s,'%s','%s')" % (
server_id, url, name, state, hidden, version, open_server_time)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
return dat
def _insert_table(server_ids='',platform_id=0, endtime="", name="", item_id1=0, item_num1=0, item_id2=0, item_num2=0, item_id3=0, item_num3=0, gold=0, stone=0):
now_datetime = str(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
sql = "INSERT INTO gift_package(server_ids,platform_id,time, endtime, name,item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone) VALUES ('%s',%s,'%s','%s','%s',%s,%s,%s,%s,%s,%s,%s,%s)"\
% (server_ids,platform_id,now_datetime,endtime, name,item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def update_server(server_id, url, name, state, hidden, version,open_server_time):
"""
更新新服务器
"""
sql = "SELECT * FROM server_list WHERE id = %s " %server_id
dat = mysql_connection.get_game_manager_mysql_connection().query(sql)
# print("dat: "+str(dat)+"notice: "+str(notice)+"version: "+str(version))
if dat:
sql = "UPDATE server_list SET " \
"id = %s, " \
"url = '%s', " \
"name = '%s', " \
"state = %s, " \
"hidden = %s, " \
"version = '%s', " \
"open_server_time = '%s' " \
"WHERE id = %s" %\
(server_id, url, name, state, hidden, version, open_server_time, server_id)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
else:
sql = "INSERT INTO server_list (id,url,name,state,hidden,version,open_server_time) VALUES (%s,'%s','%s',%s,%s,'%s','%s')" % (server_id, url, name, state, hidden,version,open_server_time)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
return dat
def insert_game_manager(game_manager):
"""
插入一个管理员
"""
sql = "INSERT INTO admin_manager(account, password, name, description, permissions ) VALUES('%s','%s','%s','%s','%s')" % (
game_manager.account, hashlib.md5(game_manager.password).hexdigest(),
game_manager.name, game_manager.description, game_manager.permissions)
get_game_manager_mysql_connection().execute(sql)
def update_admin_password(game_manager):
'''
单纯修改密码
'''
sql = "update admin_manager set password = '******' where id = '{uid}';".\
format(password = hashlib.md5(game_manager.password).hexdigest(),
uid = game_manager.uid)
get_game_manager_mysql_connection().execute(sql)
def update_version_notice(notice, version):
"""
更新公告
"""
sql = "SELECT * FROM server_notice WHERE version = '%s' " %version
dat = mysql_connection.get_game_manager_mysql_connection().get(sql)
# print("dat: "+str(dat)+"notice: "+str(notice)+"version: "+str(version))
if dat:
mysql_connection.get_game_manager_mysql_connection().execute("UPDATE server_notice SET notice = '%s' WHERE version = '%s' " %(notice,version))
else:
mysql_connection.get_game_manager_mysql_connection().execute("INSERT INTO server_notice(notice,version) VALUES('%s','%s')" % (notice,version))
return dat
def insert_game_manager(game_manager):
"""
插入一个管理员
"""
sql = "INSERT INTO admin_manager(account, password, name, permissions,description) VALUES('%s','%s','%s','%s','%s')" %\
(game_manager.account,
hashlib.md5(game_manager.password).hexdigest(),
game_manager.name,
game_manager.permissions,
game_manager.description,
)
get_game_manager_mysql_connection().execute(sql)
def update_game_infomation(game_manager):
"""
修改一个管理员信息
"""
sql = "update admin_manager set account = '{account}' , name ='{name}', permissions = '{permission}', description='{description}' where account = '{account}';".\
format(account = game_manager.account,
password = hashlib.md5(game_manager.password).hexdigest(),
name = game_manager.name.encode('utf8'),
description = game_manager.description.encode('utf8'),
permission = game_manager.permissions,
)
get_game_manager_mysql_connection().execute(sql)
def insert_activity(server_id_lst, begin_time, time_length, time_distance, is_forced_open):
"""
插入新活动
id int not null primary key auto_increment,
server_id int not null default '0',//服务器id
content char(100) not null,//活动内容
begin_time datetime not null default '0',//开始时间
time_length int not null default '0',//时间长度
time_distance int not null default '0',//时间间隔
is_forced_open int not null default False //是否强制开启
"""
# now_datetime = str(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
sql = "INSERT INTO activity_list (server_id, begin_time,time_length,time_distance,is_forced_open) VALUES ('%s','%s',%s,%s, %s)" % (server_id_lst, str(begin_time), time_length, time_distance,is_forced_open)
# print(sql)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def del_admin_by_id(id):
sql = "delete from admin_manager where id = {id}".format(id=id)
sql_con = get_game_manager_mysql_connection()
try:
sql_con.query(sql)
except:
pass
def update_version_notice(notice, version):
"""
更新公告
"""
sql = "SELECT * FROM server_notice WHERE version = '%s' " % version
dat = mysql_connection.get_game_manager_mysql_connection().get(sql)
# print("dat: "+str(dat)+"notice: "+str(notice)+"version: "+str(version))
if dat:
mysql_connection.get_game_manager_mysql_connection().execute(
"UPDATE server_notice SET notice = '%s' WHERE version = '%s' " %
(notice, version))
else:
mysql_connection.get_game_manager_mysql_connection().execute(
"INSERT INTO server_notice(notice,version) VALUES('%s','%s')" %
(notice, version))
return dat
def get_server(server_id):
"""
获取服务器
"""
cur_ser = mysql_connection.get_game_manager_mysql_connection().query("SELECT * FROM server_list WHERE id = %s" % server_id)
if cur_ser:
return cur_ser[0]
else:
return None
def _insert_table(server_ids='',
platform_id=0,
endtime="",
name="",
item_id1=0,
item_num1=0,
item_id2=0,
item_num2=0,
item_id3=0,
item_num3=0,
gold=0,
stone=0):
now_datetime = str(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
sql = "INSERT INTO gift_package(server_ids,platform_id,time, endtime, name,item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone) VALUES ('%s',%s,'%s','%s','%s',%s,%s,%s,%s,%s,%s,%s,%s)"\
% (server_ids,platform_id,now_datetime,endtime, name,item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def get_manager_account_name():
"""
获取游戏管理员账号
"""
sql = "SELECT account,name FROM admin_manager"
data = get_game_manager_mysql_connection().query(sql)
if data:
return data
else:
return None
def get_server(server_id):
"""
获取服务器
"""
cur_ser = mysql_connection.get_game_manager_mysql_connection().query(
"SELECT * FROM server_list WHERE id = %s" % server_id)
if cur_ser:
return cur_ser[0]
else:
return None
def get_all_server(refresh=False):
"""
获取当前服务器列表
"""
if ServerListDat.is_need_refresh() or refresh:
connect = mysql_connection.get_game_manager_mysql_connection()
ServerListDat.cur_all_server_dat = connect.query("SELECT * FROM server_list")
ServerListDat.cur_refresh_time = datetime.datetime.now()
return ServerListDat.cur_all_server_dat
else:
return ServerListDat.cur_all_server_dat
def get_exchange_code(code):
"""
获取兑换码
"""
sql = "SELECT * FROM exchange_code WHERE code = '%s' " % code
dat = mysql_connection.get_game_manager_mysql_connection().query(sql)
if not dat:
print ("get_exchange_code:not exist ")
return None
return dat[0]
def get_all_server_dict(refresh=False):
"""
获取当前所有服务器的ID与网络地址的字典
"""
if ServerListDat.is_need_refresh() or refresh:
connect = mysql_connection.get_game_manager_mysql_connection()
result_dict = {}
server_dict = connect.query("SELECT id,url FROM server_list")
for res in server_dict:
result_dict[int(res['id'])] = res['url']
return result_dict
def get_exchange_code(code):
"""
获取兑换码
"""
sql = "SELECT * FROM exchange_code WHERE code = '%s' " % code
dat = mysql_connection.get_game_manager_mysql_connection().query(sql)
if not dat:
print("get_exchange_code:not exist ")
return None
return dat[0]
def edit(server_ids,platform_id, endtime, name, item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone,id):
"""
修改礼包
"""
sql = "UPDATE gift_package SET " \
"server_ids = '%s', " \
"platform_id = %s, " \
"endtime = '%s', " \
"name = '%s', " \
"item_id1 = %s, " \
"item_num1 = %s, " \
"item_id2 = %s, " \
"item_num2 = %s, " \
"item_id3 = %s, " \
"item_num3 = %s, " \
"gold = %s, " \
"stone = %s " \
"WHERE id = %s" %\
(server_ids, platform_id, endtime, name, item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone,id)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def get_all_server_dict(refresh=False):
"""
获取当前所有服务器的ID与网络地址的字典
"""
if ServerListDat.is_need_refresh() or refresh:
connect = mysql_connection.get_game_manager_mysql_connection()
result_dict = {}
server_dict = connect.query("SELECT id,url FROM server_list")
for res in server_dict:
result_dict[int(res['id'])] = res['url']
return result_dict
def get_all_server(refresh=False):
"""
获取当前服务器列表
"""
if ServerListDat.is_need_refresh() or refresh:
connect = mysql_connection.get_game_manager_mysql_connection()
ServerListDat.cur_all_server_dat = connect.query(
"SELECT * FROM server_list")
ServerListDat.cur_refresh_time = datetime.datetime.now()
return ServerListDat.cur_all_server_dat
else:
return ServerListDat.cur_all_server_dat
def edit(server_ids, platform_id, endtime, name, item_id1, item_num1, item_id2,
item_num2, item_id3, item_num3, gold, stone, id):
"""
修改礼包
"""
sql = "UPDATE gift_package SET " \
"server_ids = '%s', " \
"platform_id = %s, " \
"endtime = '%s', " \
"name = '%s', " \
"item_id1 = %s, " \
"item_num1 = %s, " \
"item_id2 = %s, " \
"item_num2 = %s, " \
"item_id3 = %s, " \
"item_num3 = %s, " \
"gold = %s, " \
"stone = %s " \
"WHERE id = %s" %\
(server_ids, platform_id, endtime, name, item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone,id)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def change_activity(activity_id, server_id_lst, begin_time, time_length, time_distance, is_forced_open, new, item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone, free, exp, equip, monster, star, discount, title, detail,label,title2,label2, detail2):
"""
free int not null default '0',
exp int not null default '0',
equip int not null default '0',
monster int not null default '0',
star int not null default '0',
修改新活动
"""
sql = "UPDATE activity_list SET " \
"server_id = '%s', " \
"begin_time = '%s', " \
"time_length = %s, " \
"time_distance = %s, " \
"is_forced_open = %s, " \
"new = '%s', " \
"item_id1 = %s, " \
"item_num1 = %s, " \
"item_id2 = %s, " \
"item_num2 = %s, " \
"item_id3 = %s, " \
"item_num3 = %s, " \
"gold = %s, " \
"stone = %s, " \
"free = %s, " \
"exp = %s, " \
"equip = %s, " \
"monster = %s, " \
"star = %s, " \
"discount = %s, " \
"title = '%s', " \
"label = '%s', " \
"detail = '%s', " \
"title2 = '%s', " \
"label2 = '%s', " \
"detail2 = '%s' " \
"WHERE activity_id = %s" %\
(server_id_lst, str(begin_time), time_length, time_distance, is_forced_open, new, item_id1, item_num1, item_id2, item_num2, item_id3, item_num3, gold, stone,free, exp, equip, monster, star, discount, title,label, detail, title2,label2, detail2, activity_id)
# print(sql)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def get_version_notice(version):
"""
获取服务器公告
"""
if ServerNotice.is_need_refresh():
sql = "SELECT * FROM server_notice WHERE version = '%s'" %version
notice = mysql_connection.get_game_manager_mysql_connection().query(sql)
if notice:
ServerNotice.cur_server_notice = notice[0]
else:
ServerNotice.cur_server_notice = None
return ServerNotice.cur_server_notice
else:
return ServerNotice.cur_server_notice
def get_all_notice():
"""
获取服务器公告
"""
if ServerNotice.is_need_refresh():
sql = "SELECT * FROM server_notice"
notice = mysql_connection.get_game_manager_mysql_connection().query(sql)
if notice:
ServerNotice.cur_server_notice = notice
else:
ServerNotice.cur_server_notice = ''
return ServerNotice.cur_server_notice
else:
return ServerNotice.cur_server_notice
def get_version_notice(version):
"""
获取服务器公告
"""
if ServerNotice.is_need_refresh():
sql = "SELECT * FROM server_notice WHERE version = '%s'" % version
notice = mysql_connection.get_game_manager_mysql_connection().query(
sql)
if notice:
ServerNotice.cur_server_notice = notice[0]
else:
ServerNotice.cur_server_notice = None
return ServerNotice.cur_server_notice
else:
return ServerNotice.cur_server_notice
def get_all_notice():
"""
获取服务器公告
"""
if ServerNotice.is_need_refresh():
sql = "SELECT * FROM server_notice"
notice = mysql_connection.get_game_manager_mysql_connection().query(
sql)
if notice:
ServerNotice.cur_server_notice = notice
else:
ServerNotice.cur_server_notice = ''
return ServerNotice.cur_server_notice
else:
return ServerNotice.cur_server_notice
def get_game_manager(account):
"""
获取游戏管理员账号
"""
sql = "SELECT * FROM admin_manager WHERE account='%s'" % account
data = get_game_manager_mysql_connection().get(sql)
if data:
_gm = GameManager()
_gm.uid = data['id']
_gm.account = data['account']
_gm.password = data["password"]
_gm.name = data["name"]
_gm.description = data["description"]
_gm.permissions = data["permissions"]
return _gm
else:
return None
def get_table():
row_list = []
temp = []
mysql_connect = get_game_manager_mysql_connection()
sql = "SELECT id, account, name,permissions, last_login_ip, last_login_time, description FROM admin_manager where permissions != 'Super';"
results = mysql_connect.query(sql)
for _dic in results:
temp.append(_dic['id'])
temp.append(_dic['account'])
temp.append(_dic['name'])
temp.append(game_manage_define.MANAGER_PERMISSION_EN_TO_CN[
_dic['permissions']])
temp.append(_dic['last_login_ip'])
temp.append(_dic['last_login_time'])
temp.append(_dic['description'])
row_list.extend([temp])
temp = []
return row_list
def output_csv():
"""
导出cvs数据
"""
print OUTPUT_PATH
if not os.path.exists(OUTPUT_PATH):
os.mkdir(OUTPUT_PATH)
sql = "SELECT time,code,gift_id FROM exchange_code"
dat = mysql_connection.get_game_manager_mysql_connection().query(sql)
output_file = file(OUTPUT_PATH + OUTPUT_FILE_NAME, "w")
names = ["time", "code", "gift_id"]
csv_writer = csv.DictWriter(output_file, fieldnames=names)
names_dict = {"time": "时间", "code": "兑换码", "gift_id": "礼包类型"}
csv_writer.writerow(names_dict)
csv_writer.writerows(dat)
output_file.close()
return OUTPUT_PATH + OUTPUT_FILE_NAME
def output_csv():
"""
导出cvs数据
"""
print OUTPUT_PATH
if not os.path.exists(OUTPUT_PATH):
os.mkdir(OUTPUT_PATH)
sql = "SELECT time,code,gift_id FROM exchange_code"
dat = mysql_connection.get_game_manager_mysql_connection().query(sql)
output_file = file(OUTPUT_PATH + OUTPUT_FILE_NAME, 'w')
names = ['time', 'code', 'gift_id']
csv_writer = csv.DictWriter(output_file, fieldnames=names)
names_dict = {'time': '时间', 'code': '兑换码', 'gift_id': '礼包类型'}
csv_writer.writerow(names_dict)
csv_writer.writerows(dat)
output_file.close()
return OUTPUT_PATH + OUTPUT_FILE_NAME
def get_game_manager_with_id(manager_id):
"""
用ID 获取管理员
"""
sql = "SELECT * FROM admin_manager WHERE id=%s" % manager_id
data = get_game_manager_mysql_connection().get(sql)
if data:
_gm = GameManager()
_gm.uid = data['id']
_gm.account = data['account']
_gm.password = data["password"]
_gm.name = data["name"]
_gm.description = data["description"]
_gm.permissions = data["permissions"]
_gm.last_login_ip = data["last_login_ip"]
_gm.last_login_time = data["last_login_time"]
return _gm
else:
return None
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_super_manager():
"""
获取超级管理员
"""
sql = "SELECT * FROM admin_manager WHERE permissions='%s'" % str('Super')
data = get_game_manager_mysql_connection().get(sql)
if data:
_gm = GameManager()
_gm.uid = data['id']
_gm.account = data['account']
_gm.username = data["password"]
_gm.name = data["name"]
_gm.description = data["description"]
_gm.permissions = data["permissions"]
_gm.last_login_ip = data["last_login_ip"]
_gm.last_login_time = data["last_login_time"]
print("super = " + str(_gm))
return _gm
else:
return None
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 clear_all():
"""
清楚gift_package
"""
mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM gift_package")
def clear_all():
"""
清楚指定服务器统计数据
"""
mysql_connection.get_game_manager_mysql_connection().execute(
"DELETE FROM exchange_code")
def delete(time):
"""
删除兑换码
"""
mysql_connection.get_game_manager_mysql_connection().execute(
"DELETE FROM exchange_code WHERE time = '%s' " % time)
def delete(id):
"""
删除礼包码
"""
mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM gift_package WHERE id = %s" % id)
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
def delete_server(server_id):
"""
移除表格
"""
sql = "DELETE FROM server_list WHERE id=%s" % server_id
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def update_game_manager_login_dat(uid, login_ip, login_time):
"""
更新管理员登录ip和时间
"""
sql = "UPDATE admin_manager SET last_login_ip='%s',last_login_time='%s' WHERE id=%s " % (login_ip, login_time.strftime("%Y-%m-%d %H:%M:%S"), uid)
get_game_manager_mysql_connection().execute(sql)
def delete_server(server_id):
"""
移除表格
"""
sql = "DELETE FROM server_list WHERE id=%s" % server_id
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def delete(time):
"""
删除兑换码
"""
mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM exchange_code WHERE time = '%s' " % time)
def clear_all():
"""
清楚gift_package
"""
mysql_connection.get_game_manager_mysql_connection().execute(
"DELETE FROM gift_package")
def _insert_table(code="", gift_id=0):
now_datetime = str(datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S"))
sql = "INSERT INTO exchange_code(time,code,gift_id) VALUES ('%s','%s',%s)" % (now_datetime, code, gift_id)
mysql_connection.get_game_manager_mysql_connection().execute(sql)
def clear_all():
"""
清楚指定服务器统计数据
"""
mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM exchange_code")
def delete(id):
"""
删除礼包码
"""
mysql_connection.get_game_manager_mysql_connection().execute(
"DELETE FROM gift_package WHERE id = %s" % id)
def delete_version_notice(version):
"""
移除公告
"""
sql = "DELETE FROM server_notice WHERE version = '%s' " %version
mysql_connection.get_game_manager_mysql_connection().execute(sql)
