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_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 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)
def delete_server(server_id):
"""
移除表格
"""
sql = "DELETE FROM server_list WHERE id=%s" % server_id
mysql_connection.get_game_manager_mysql_connection().execute(sql)
