Example #1
0
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)
Example #2
0
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
Example #3
0
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)
Example #4
0
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
Example #5
0
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)
Example #6
0
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)
Example #7
0
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)
Example #9
0
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)
Example #10
0
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)
Example #11
0
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
Example #12
0
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
Example #13
0
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
Example #14
0
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)
Example #15
0
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
Example #16
0
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
Example #17
0
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
Example #18
0
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]
Example #19
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
Example #20
0
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]
Example #21
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)
Example #22
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
Example #23
0
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
Example #24
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)
Example #25
0
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)
Example #26
0
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
Example #27
0
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
Example #28
0
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
Example #29
0
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
Example #32
0
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
Example #33
0
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
Example #34
0
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
Example #35
0
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
Example #37
0
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
Example #38
0
def clear_all():
    """
        清楚gift_package
    """
    mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM gift_package")
Example #39
0
def clear_all():
    """
        清楚指定服务器统计数据
    """
    mysql_connection.get_game_manager_mysql_connection().execute(
        "DELETE FROM exchange_code")
Example #40
0
def delete(time):
    """
        删除兑换码
    """
    mysql_connection.get_game_manager_mysql_connection().execute(
        "DELETE FROM exchange_code WHERE time = '%s' " % time)
Example #41
0
def delete(id):
    """
        删除礼包码
    """
    mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM gift_package WHERE id = %s" % id)
Example #42
0
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
Example #43
0
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)
Example #45
0
def delete_server(server_id):
    """
        移除表格
    """
    sql = "DELETE FROM server_list WHERE id=%s" % server_id
    mysql_connection.get_game_manager_mysql_connection().execute(sql)
Example #46
0
def delete(time):
    """
        删除兑换码
    """
    mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM exchange_code WHERE time = '%s' " % time)
Example #47
0
def clear_all():
    """
        清楚gift_package
    """
    mysql_connection.get_game_manager_mysql_connection().execute(
        "DELETE FROM gift_package")
Example #48
0
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)
Example #49
0
def clear_all():
    """
        清楚指定服务器统计数据
    """
    mysql_connection.get_game_manager_mysql_connection().execute("DELETE FROM exchange_code")
Example #50
0
def delete(id):
    """
        删除礼包码
    """
    mysql_connection.get_game_manager_mysql_connection().execute(
        "DELETE FROM gift_package WHERE id = %s" % id)
Example #51
0
def delete_version_notice(version):
    """
        移除公告
    """
    sql = "DELETE FROM server_notice WHERE version = '%s' " %version
    mysql_connection.get_game_manager_mysql_connection().execute(sql)