GongFuServer/script/merge/MergeServerDefine.lua

--合服

--_G.lua_mongo 提供的接口
--[=[
    find()
    md5()
    id()
    next()
    client()
    remove()
    index()
    auth()
    count()
    update()
]=]--


--备份和恢复
--[=[
    备份
        mongodump --db 要备份的数据库名字 --out 备份文件存放目录
        如:  mongodump --db ckwy_fy_S350052 --out /cipan1/dumpDB/
        脚本: /server/dumpDB.sh    需要修改脚本中的数据库范围


    将备份文件恢复
        mongorestore --db 数据库存放目录  备份文件目录

        mongorestore --db=ckwy_fy_S350077 --drop /server/bin3/dumpDB/ckwy_fy_S350077  --增加 --drop参数，会先删除数据库，再恢复

        mongorestore --db=ckwy_fy_S3500002  /server/bin3/dumpDB/ckwy_fy_S3500002

        脚本: /server/restoreDB.sh  需要根据dumpDB.sh 修改脚本中的备份数据所在目录, 以及数据库范围

]=]--



--[=[
    --1.使用 newUniqueTag 代替 account
    --2. 合并数据逻辑
]=]--


KEY_CIYUAN_MOZHU = "ciyuanMoZhu"                -- 次元魔蛛的key

KEY_MERGE_TIME = "mergeServerTime"              -- 合服时间

---------------------同名-------------
NEW_NAME = "银月的青锋使"                        -- 玩家同名时的新名字 .. num
MAIL_ID = 7013                                  -- 同名玩家改名后补偿邮件的ID
MAIL_NUM = 500                                  -- 邮件补偿古玉数量


-------------------烟花----------------
KEY_FIREWORKBONUS_TIME = "fireWorksBonusTime"     -- 烟花加成时间key
FIRE_MAX_TIME = 43200                             -- 烟花最大加成时间(12h)


------------日志----------------------
SUCC_TAG = "succ"
ERR_TAG = "err"
CHANGENAME_TAG = "changeName"

--------------------------------------

-- 渠道ID
CHANNEL_ID_TAP = 1
CHANNEL_ID_SANLI_ANDOIRD = 2
CHANNEL_ID_SANLI_IOS = 3
CHANNEL_ID_SANLI_QQ = 4
CHANNEL_ID_SANLI_H5 = 5
CHANNEL_ID_SANLI_4399 = 6
CHANNEL_ID_SANLI_360 = 7

CHANNEL_ID_SANLI_SHIYOU = 10
CHANNEL_ID_TAP_WX = 11
CHANNEL_ID_SANLI_MINIGAME = 17


-- 数据库名中字符串部分的格式
DB_NAME_STR = "ckwy_fy_S"

-- 渠道对应的数据库名中数字部分的初始值
--!!! 当前项目 ckwy_fy_S350002 是1服的数据库, ckwy_fy_S350003 是2服的数据库, ckwy_fy_S350004 是3服的数据库, 以此类推...
CHANNEL_2_DBNUMBER = {
    -- TAP
    [CHANNEL_ID_TAP] = 350001,

    --三狸 Andorid/IOS
    [CHANNEL_ID_SANLI_ANDOIRD] = 350001,
    [CHANNEL_ID_SANLI_IOS] = 350001,

    -- 三狸QQ,360
    [CHANNEL_ID_SANLI_QQ] = 650001,
    [CHANNEL_ID_SANLI_360] = 650001,

    -- 三狸H5，4399
    [CHANNEL_ID_SANLI_H5] = 550001,
    [CHANNEL_ID_SANLI_4399] = 550001,

    -- 三狸视游
    [CHANNEL_ID_SANLI_SHIYOU] = 750001,

    -- 微信/抖音小游戏
    [CHANNEL_ID_TAP_WX] = 1150001,

    -- 三狸美团/淘宝小游戏
    [CHANNEL_ID_SANLI_MINIGAME] = 1750001,
}

-- 要进行合并的数据库所属渠道ID, 用于检测合错数据库的情况, 与下面的 MERGE_DB_TB 的值一一对应
-- 格式: 渠道Id, 区服Id, 标识(0-宿主服, 1-被合服, 2-被合服, 且被合并到另外一个跨服/渠道)
MERGE_CHECK_TB = {
    -- 木子/Tap
    [CHANNEL_ID_TAP] = {
        { {CHANNEL_ID_TAP, 311, 0},  {CHANNEL_ID_TAP, 312, 1} },
        { {CHANNEL_ID_TAP, 313, 0},  {CHANNEL_ID_TAP, 314, 1} },
        { {CHANNEL_ID_TAP, 315, 0},  {CHANNEL_ID_TAP, 316, 1} },
        { {CHANNEL_ID_TAP, 317, 0},  {CHANNEL_ID_TAP, 318, 1} },
        { {CHANNEL_ID_TAP, 319, 0},  {CHANNEL_ID_TAP, 320, 1} },

        { {CHANNEL_ID_TAP, 321, 0},  {CHANNEL_ID_TAP, 322, 1} },
        { {CHANNEL_ID_TAP, 323, 0},  {CHANNEL_ID_TAP, 324, 1} },
        { {CHANNEL_ID_TAP, 325, 0},  {CHANNEL_ID_TAP, 326, 1} },
        { {CHANNEL_ID_TAP, 327, 0},  {CHANNEL_ID_TAP, 328, 1} },
        { {CHANNEL_ID_TAP, 329, 0},  {CHANNEL_ID_TAP, 330, 1} },
    },

    -- 三狸功夫
    [CHANNEL_ID_SANLI_ANDOIRD] = {
        { {CHANNEL_ID_SANLI_ANDOIRD, 321, 0}, {CHANNEL_ID_SANLI_ANDOIRD, 322, 1} },
        { {CHANNEL_ID_SANLI_ANDOIRD, 323, 0}, {CHANNEL_ID_SANLI_ANDOIRD, 324, 1} },
        { {CHANNEL_ID_SANLI_ANDOIRD, 325, 0}, {CHANNEL_ID_SANLI_ANDOIRD, 326, 1} },
        { {CHANNEL_ID_SANLI_ANDOIRD, 327, 0}, {CHANNEL_ID_SANLI_ANDOIRD, 328, 1} },
        { {CHANNEL_ID_SANLI_ANDOIRD, 329, 0}, {CHANNEL_ID_SANLI_ANDOIRD, 330, 1} },
    },


    -- 三狸H5
    -- [CHANNEL_ID_SANLI_H5] = {
    --     { {CHANNEL_ID_SANLI_ANDOIRD, 41, 0},  {CHANNEL_ID_SANLI_H5, 31, 2}, {CHANNEL_ID_SANLI_H5, 32, 2} },
    --     { {CHANNEL_ID_SANLI_ANDOIRD, 43, 0},  {CHANNEL_ID_SANLI_H5, 33, 2}, {CHANNEL_ID_SANLI_H5, 34, 2} },
    --     { {CHANNEL_ID_SANLI_ANDOIRD, 45, 0},  {CHANNEL_ID_SANLI_H5, 35, 2}, {CHANNEL_ID_SANLI_H5, 36, 2} },
    --     { {CHANNEL_ID_SANLI_ANDOIRD, 47, 0},  {CHANNEL_ID_SANLI_H5, 37, 2}, {CHANNEL_ID_SANLI_H5, 38, 2} },
    --     { {CHANNEL_ID_SANLI_ANDOIRD, 49, 0},  {CHANNEL_ID_SANLI_H5, 39, 2}, {CHANNEL_ID_SANLI_H5, 40, 2} },
    -- },

    -- 三狸QQ
    -- [CHANNEL_ID_SANLI_QQ] = {
    --     { {CHANNEL_ID_SANLI_SHIYOU, 121, 0},  {CHANNEL_ID_SANLI_QQ, 191, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 122, 0},  {CHANNEL_ID_SANLI_QQ, 192, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 123, 0},  {CHANNEL_ID_SANLI_QQ, 193, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 124, 0},  {CHANNEL_ID_SANLI_QQ, 194, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 125, 0},  {CHANNEL_ID_SANLI_QQ, 195, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 126, 0},  {CHANNEL_ID_SANLI_QQ, 196, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 127, 0},  {CHANNEL_ID_SANLI_QQ, 197, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 128, 0},  {CHANNEL_ID_SANLI_QQ, 198, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 129, 0},  {CHANNEL_ID_SANLI_QQ, 199, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 130, 0},  {CHANNEL_ID_SANLI_QQ, 200, 2} },

    --     { {CHANNEL_ID_SANLI_SHIYOU, 131, 0},  {CHANNEL_ID_SANLI_QQ, 201, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 132, 0},  {CHANNEL_ID_SANLI_QQ, 202, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 133, 0},  {CHANNEL_ID_SANLI_QQ, 203, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 134, 0},  {CHANNEL_ID_SANLI_QQ, 204, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 135, 0},  {CHANNEL_ID_SANLI_QQ, 205, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 136, 0},  {CHANNEL_ID_SANLI_QQ, 206, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 137, 0},  {CHANNEL_ID_SANLI_QQ, 207, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 138, 0},  {CHANNEL_ID_SANLI_QQ, 208, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 139, 0},  {CHANNEL_ID_SANLI_QQ, 209, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 140, 0},  {CHANNEL_ID_SANLI_QQ, 210, 2} },

    --     { {CHANNEL_ID_SANLI_SHIYOU, 141, 0},  {CHANNEL_ID_SANLI_QQ, 211, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 142, 0},  {CHANNEL_ID_SANLI_QQ, 212, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 143, 0},  {CHANNEL_ID_SANLI_QQ, 213, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 144, 0},  {CHANNEL_ID_SANLI_QQ, 214, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 145, 0},  {CHANNEL_ID_SANLI_QQ, 215, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 146, 0},  {CHANNEL_ID_SANLI_QQ, 216, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 147, 0},  {CHANNEL_ID_SANLI_QQ, 217, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 148, 0},  {CHANNEL_ID_SANLI_QQ, 218, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 149, 0},  {CHANNEL_ID_SANLI_QQ, 219, 2} },
    --     { {CHANNEL_ID_SANLI_SHIYOU, 150, 0},  {CHANNEL_ID_SANLI_QQ, 220, 2} },

    -- },


    -- 三狸视游
    [CHANNEL_ID_SANLI_SHIYOU] = {
        { {CHANNEL_ID_SANLI_SHIYOU, 201, 0},  {CHANNEL_ID_SANLI_SHIYOU, 202, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 203, 0},  {CHANNEL_ID_SANLI_SHIYOU, 204, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 205, 0},  {CHANNEL_ID_SANLI_SHIYOU, 206, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 207, 0},  {CHANNEL_ID_SANLI_SHIYOU, 208, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 209, 0},  {CHANNEL_ID_SANLI_SHIYOU, 210, 1} },

        { {CHANNEL_ID_SANLI_SHIYOU, 211, 0},  {CHANNEL_ID_SANLI_SHIYOU, 212, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 213, 0},  {CHANNEL_ID_SANLI_SHIYOU, 214, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 215, 0},  {CHANNEL_ID_SANLI_SHIYOU, 216, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 217, 0},  {CHANNEL_ID_SANLI_SHIYOU, 218, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 219, 0},  {CHANNEL_ID_SANLI_SHIYOU, 220, 1} },

        { {CHANNEL_ID_SANLI_SHIYOU, 221, 0},  {CHANNEL_ID_SANLI_SHIYOU, 222, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 223, 0},  {CHANNEL_ID_SANLI_SHIYOU, 224, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 225, 0},  {CHANNEL_ID_SANLI_SHIYOU, 226, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 227, 0},  {CHANNEL_ID_SANLI_SHIYOU, 228, 1} },
        { {CHANNEL_ID_SANLI_SHIYOU, 229, 0},  {CHANNEL_ID_SANLI_SHIYOU, 230, 1} },
    },

    -- 三狸美团/淘宝
    [CHANNEL_ID_SANLI_MINIGAME] = {
        { {CHANNEL_ID_SANLI_ANDOIRD, 321, 0},  {CHANNEL_ID_SANLI_MINIGAME, 21, 2}, {CHANNEL_ID_SANLI_MINIGAME, 22, 2},  },
        { {CHANNEL_ID_SANLI_ANDOIRD, 323, 0},  {CHANNEL_ID_SANLI_MINIGAME, 23, 2}, {CHANNEL_ID_SANLI_MINIGAME, 24, 2},  },
        { {CHANNEL_ID_SANLI_ANDOIRD, 325, 0},  {CHANNEL_ID_SANLI_MINIGAME, 25, 2}, {CHANNEL_ID_SANLI_MINIGAME, 26, 2},  },
        { {CHANNEL_ID_SANLI_ANDOIRD, 327, 0},  {CHANNEL_ID_SANLI_MINIGAME, 27, 2}, {CHANNEL_ID_SANLI_MINIGAME, 28, 2}, },
        { {CHANNEL_ID_SANLI_ANDOIRD, 329, 0},  {CHANNEL_ID_SANLI_MINIGAME, 29, 2}, {CHANNEL_ID_SANLI_MINIGAME, 30, 2}, },
    },

    -- 微信/抖音小游戏
    [CHANNEL_ID_TAP_WX] = {
        { {CHANNEL_ID_TAP, 201, 0},  {CHANNEL_ID_TAP_WX, 1, 2}, },
        { {CHANNEL_ID_TAP, 205, 0},  {CHANNEL_ID_TAP_WX, 6, 2}, },

        { {CHANNEL_ID_TAP, 221, 0},  {CHANNEL_ID_TAP_WX, 21, 2}, },
        { {CHANNEL_ID_TAP, 225, 0},  {CHANNEL_ID_TAP_WX, 26, 2}, },

        { {CHANNEL_ID_TAP, 251, 0},  {CHANNEL_ID_TAP_WX, 41, 2}, },
        { {CHANNEL_ID_TAP, 255, 0},  {CHANNEL_ID_TAP_WX, 46, 2}, },

        { {CHANNEL_ID_TAP, 261, 0},  {CHANNEL_ID_TAP_WX, 51, 2}, },
        { {CHANNEL_ID_TAP, 265, 0},  {CHANNEL_ID_TAP_WX, 56, 2}, },

        { {CHANNEL_ID_TAP, 271, 0},  {CHANNEL_ID_TAP_WX, 61, 2}, },
        { {CHANNEL_ID_TAP, 275, 0},  {CHANNEL_ID_TAP_WX, 66, 2}, },

        { {CHANNEL_ID_TAP, 281, 0},  {CHANNEL_ID_TAP_WX, 71, 2}, },
        { {CHANNEL_ID_TAP, 285, 0},  {CHANNEL_ID_TAP_WX, 76, 2}, },

        { {CHANNEL_ID_TAP, 311, 0},  {CHANNEL_ID_TAP_WX, 101, 2}, {CHANNEL_ID_TAP_WX, 102, 2} },
        { {CHANNEL_ID_TAP, 313, 0},  {CHANNEL_ID_TAP_WX, 103, 2}, {CHANNEL_ID_TAP_WX, 104, 2} },
        { {CHANNEL_ID_TAP, 315, 0},  {CHANNEL_ID_TAP_WX, 105, 2}, {CHANNEL_ID_TAP_WX, 106, 2} },
        { {CHANNEL_ID_TAP, 317, 0},  {CHANNEL_ID_TAP_WX, 107, 2}, {CHANNEL_ID_TAP_WX, 108, 2} },
        { {CHANNEL_ID_TAP, 319, 0},  {CHANNEL_ID_TAP_WX, 109, 2}, {CHANNEL_ID_TAP_WX, 110, 2} },

        { {CHANNEL_ID_TAP, 321, 0},  {CHANNEL_ID_TAP_WX, 111, 2}, {CHANNEL_ID_TAP_WX, 112, 2} },
        { {CHANNEL_ID_TAP, 323, 0},  {CHANNEL_ID_TAP_WX, 113, 2}, {CHANNEL_ID_TAP_WX, 114, 2} },
        { {CHANNEL_ID_TAP, 325, 0},  {CHANNEL_ID_TAP_WX, 115, 2}, {CHANNEL_ID_TAP_WX, 116, 2} },
        { {CHANNEL_ID_TAP, 327, 0},  {CHANNEL_ID_TAP_WX, 117, 2}, {CHANNEL_ID_TAP_WX, 118, 2} },
        { {CHANNEL_ID_TAP, 329, 0},  {CHANNEL_ID_TAP_WX, 119, 2}, {CHANNEL_ID_TAP_WX, 120, 2} },
    },
}



--要进行数据合并的数据库列表, 每个value中第一个为目标数据库，其他为源数据库
--!!! 当前项目 ckwy_fy_S350002 是1服的数据库, ckwy_fy_S350003 是2服的数据库, ckwy_fy_S350004 是3服的数据库, 以此类推...
MERGE_DB_TB = {
    -- 木子
    -- {"ckwy_fy_S350022", "ckwy_fy_S350023"},
    -- {"ckwy_fy_S350024", "ckwy_fy_S350025"},
    -- {"ckwy_fy_S350026", "ckwy_fy_S350027"},
    -- {"ckwy_fy_S350028", "ckwy_fy_S350029"},
    -- {"ckwy_fy_S350030", "ckwy_fy_S350031"},

    -- -- 三狸安卓/H5
    -- {"ckwy_fy_S350042", "ckwy_fy_S350043", "ckwy_fy_S550032", "ckwy_fy_S550033"},
    -- {"ckwy_fy_S350044", "ckwy_fy_S350045", "ckwy_fy_S550034", "ckwy_fy_S550035"},
    -- {"ckwy_fy_S350046", "ckwy_fy_S350047", "ckwy_fy_S550036", "ckwy_fy_S550037"},
    -- {"ckwy_fy_S350048", "ckwy_fy_S350049", "ckwy_fy_S550038", "ckwy_fy_S550039"},
    -- {"ckwy_fy_S350050", "ckwy_fy_S350051", "ckwy_fy_S550040", "ckwy_fy_S550041"},

    -- -- 三狸QQ
    -- {"ckwy_fy_S650022", "ckwy_fy_S650023"},
    -- {"ckwy_fy_S650024", "ckwy_fy_S650025"},
    -- {"ckwy_fy_S650026", "ckwy_fy_S650027"},
    -- {"ckwy_fy_S650028", "ckwy_fy_S650029"},
    -- {"ckwy_fy_S650030", "ckwy_fy_S650031"},
}


--所有要处理的集合
COLLECTIONS = {
    ".char",                    -- 角色表, 可以直接插入
    ".mail"	,					-- 邮件，可以直接插入
    ".common",					-- 通用数据（开服时间)
    ".friend",					-- 好友数据库表， 可以直接插入
    ".boss_data",		    	-- boss记录表，	可以直接插入
    ".union",             		-- 工会数据表，	可以直接插入
    ".jjc",						-- 单人竞技场， 可以直接插入
    ".combat_video",			-- 战斗录像[本地记录 个人记录 单人竞技场 通天塔 王者争霸 战役记录],可以直接插入
    ".drill_data",        		-- 圣树试炼/过关斩将，可以直接插入
    ".union_war",   			-- 公会战，可以直接插入
    ".union_war_record",   		-- 公会战记录，	可以直接插入
    ".the_stars",          		-- 星空争霸，	可以直接插入
    ".abs_billboard",			-- 绝对时间排行榜记录，	可以直接插入
    ".middle_act_group",		-- 跨服活动分组记录， 暂时没使用，不管
    ".battle_shark",	    	-- 战役通关战报
    ".tower",	   				-- 全服通天塔 信息，	可以直接插入
    ".hero_pingfen",	   		-- 英雄评分信息用于排名， 可以直接插入           
    ".jjcGodWar",				-- 众神之战				，可以直接插入
    ".jjcGodWar_record",		-- 众神之战记录			，可以直接插入
    ".chat_record",        		-- 好友聊天记录			，可以直接插入
    ".jjcLadder",    	    	-- 天梯争霸				，可以直接插入
    ".jjcLadder_record",   		-- 天梯争霸记录			，可以直接插入
    ".yjTreasure",   			-- 遗迹探宝				， 可以直接插入
    ".yjTreasure_rank",   	    -- 遗迹探宝排行
    ".yjTreasure_role",   		-- 遗迹探宝角色信息		， 可以直接插入
    ".valley",   				-- 荣耀峡谷/龙族战场	，可以直接插入
    ".valley_record",   		-- 荣耀峡谷/龙族战场记录， 可以直接插入
    ".war_report",   	    	-- 战报[跨服记录 冠军联赛 王者争霸 天梯 切磋 系列排名存储记录]， 可以直接插入
    ".openServer_billboard",	-- 开服排行类活动，可以直接插入
    ".lost_temple",             -- 神庙
    ".common_rank",				-- 通用排行榜，可以直接插入
}

--源数据库中不需要插入目标数据库的集合列表
--[=[
    middle_act_group        暂时没用到这个集合，所以也只用目标数据库的集合
    the_stars               战神殿, 只保留宿主服的记录
    battle_shark            主线闯关录像, 只用宿主服的
]=]--
NO_INSERT_COLLECTIONS = {
    --[".common"] = 1,
    [".middle_act_group"] = 1,
    [".the_stars"] = 1,
    [".battle_shark"] = 1,
    [".jjcGodWar"] = 1,
    --[".jjcGodWar_record"] = 1,
    --[".tower"] = 1,
}


--用到char 集合中的 _id 字段的集合, 如果 char 集合中的 _id 有修改, 则这些集合中的 _id 也需要修改
NEED_CHANGE_COLLECTIONS = {
    [".friend"] = '1',
    [".mail"] = '1',
    [".union"] = '1',
    [".the_stars"] = '1',
    [".jjc"] = '1',
    [".combat_video"] = '1',
}