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)