CommonDB.lua 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427
  1. local DB = require("common.DB")
  2. local LuaMongo = _G.lua_mongo
  3. local Config = require("Config")
  4. local Util = require("common.Util")
  5. local ObjHuman = require("core.ObjHuman")
  6. local YunYingLogic = require("yunying.YunYingLogic")
  7. local OpenAct = require("present.OpenAct")
  8. local DBUpdate = {_id=nil} -- 更新
  9. local DBUpdateField = {} -- 更新域
  10. local nVoucherInflateLen = 20 -- 代金券记录信息长度
  11. KEY_SERVER_START_TIME = "serverStartTime" -- 开服时间
  12. KEY_IDENTITY_MAX = "identityMax" -- 自增的最大的数字 从1开始
  13. KEY_UNION_IDENTITY_MAX = "unionIdentityMax" -- 自增的最大的数字 从1开始
  14. KEY_REWARD_INDEX = "rewardIndex" -- 好友排行榜奖励索引rewardIndex
  15. KEY_BAN_IP = "banIp" -- 被禁IP
  16. KEY_CHONGJI_ACT = "chongJiAct" -- 全服冲级活动 领取情况
  17. KEY_ACT_MONTH = "actMonth" -- 当前计算的真实月份
  18. KEY_UNION_WAR = "unionWar" -- 公会战
  19. KEY_ACT_MONTH_LIST = "actMonthList" -- 现实活动
  20. KEY_RESET_TIME = "resetTime"
  21. KEY_DRILL = "drill" -- 过关斩将信息(本期开始时间等)
  22. KEY_SHARE_PLATFORM_BOARD = "sharePlatformBoard" -- 分享排行
  23. KEY_BILLBOARD_AIM = "billboardAim" -- 排行榜达标记录
  24. KEY_JJC_LADDER = "jjcLadder" -- 天梯争霸信息
  25. KEY_VALLEY = "valley" -- 荣耀峡谷信息
  26. KEY_LIANYU = "lianyu" -- 绝望深渊信息
  27. KEY_MIDDLE_INFO = "middleInfo" -- 跨服链接信息
  28. KEY_CHAMPION_END_TIME = "championEndTime" -- 冠军竞技场本赛季结束时间
  29. KEY_DRAGON_NEST_CITIAO = "dragonNestCiTiao" -- 冰龙巢穴词条
  30. KEY_WORK_MAN = "workMan" -- 打工人活动
  31. KEY_OPEN_SERVER_TOPUP_TOP = "openServerTopupTop" -- 开服充值排名活动
  32. KEY_CIYUAN_MOZHU = "ciyuanMoZhu" -- 次元魔蛛
  33. KEY_YJ_TIME = "yjTreasureTime" -- 遗迹探险时间
  34. KEY_CDK_BATCH = "cdkBatchIdx" -- CDK批次序号
  35. KEY_WEEKLOOP_CARD_BATCH = "weekLoopCardBatch" -- 周活动-抽卡批次
  36. KEY_VOUCHER_INFLATE = "tVoucherInflateInfo" -- 代金券膨胀信息
  37. kEY_RECOMMENDLINEUP = "recommendlineup" -- 推荐阵容
  38. KEY_FIREWORKBONUS_TIME="fireWorksBonusTime" -- 烟花加成时间
  39. db = db or {
  40. serverStartTime = nil, -- 开服时间
  41. zhuanpanRecord = nil, -- 转盘中奖记录
  42. identityMax = nil, -- 自增的最大的数字 从1开始
  43. rewardIndex = nil, -- 好友排行榜奖励索引rewardIndex
  44. unionIdentityMax = nil, -- 自增的最大的数字 从1开始
  45. mergeSvrIndex = nil, -- 合服之后对应的服务器索引 比如如果10001,10003,100004合服了 这里的数据结构是{10001,10003,10004}
  46. banIp = {}, -- 被禁IP
  47. chongJiAct = {}, -- 全服冲级活动 领取情况
  48. actMonth = nil, -- 当前计算的真实月份
  49. unionWarState = nil, -- 当前工会战状态
  50. actMonthList = nil, -- 现实活动
  51. resetTime = nil, -- 确认是否重置数据
  52. middleInfo = {}, -- 跨服链接信息
  53. championEndTime = nil, -- 冠军竞技场本赛季结束时间
  54. dragonNestCiTiao = {}, -- 冰龙巢穴词条
  55. workMan = {}, -- 打工人活动
  56. ciyuanMoZhu = nil, -- 次元魔蛛
  57. yjTreasureTime = nil, -- 遗迹探险时间
  58. cdkBatchIdx = nil, -- CDK批次序号
  59. weekLoopCardBatch = nil, -- 周活动-抽卡批次
  60. tVoucherInflateInfo = {}, -- 代金券膨胀信息
  61. recommendlineup = {}, -- 推荐阵容
  62. fireWorksBonusTime = nil, -- 烟花加成时间
  63. }
  64. function init()
  65. LuaMongo.find(DB.db_common)
  66. if not LuaMongo.next(db) then
  67. LuaMongo.insert(DB.db_common, db)
  68. end
  69. end
  70. -- 修改db单个字段
  71. function updateValue(key, value)
  72. if not key then return end
  73. if not db then return end
  74. if value then
  75. DBUpdateField["$set"] = {[key]=value}
  76. DBUpdateField["$unset"] = nil
  77. else
  78. DBUpdateField["$set"] = nil
  79. DBUpdateField["$unset"] = {[key]=1}
  80. end
  81. DBUpdate._id = db._id
  82. db[key] = value
  83. LuaMongo.update(DB.db_common, DBUpdate, DBUpdateField)
  84. end
  85. function getCDKBatch()
  86. if not db then
  87. return
  88. end
  89. return db[KEY_CDK_BATCH] or 0
  90. end
  91. function setCDKBatch(idx)
  92. idx = idx + 1
  93. updateValue(KEY_CDK_BATCH,idx)
  94. end
  95. function getValueByKey(key)
  96. if not db then return end
  97. return db[key]
  98. end
  99. -- 同步db内容
  100. function reset()
  101. LuaMongo.find(DB.db_common)
  102. if not LuaMongo.next(db) then
  103. db = {banIp = {},}
  104. end
  105. print("db.serverStartTime:",db.serverStartTime)
  106. end
  107. -- 设置开服时间
  108. function setServerOpenTime(time)
  109. db.serverStartTime = time
  110. updateValue(KEY_SERVER_START_TIME, time)
  111. YunYingLogic.onServerOpenTime()
  112. OpenAct.onServerOpenTime()
  113. end
  114. function getServerOpenTime()
  115. if not db.serverStartTime then
  116. local t = Util.getDayStartTime()
  117. setServerOpenTime(t)
  118. end
  119. return db.serverStartTime
  120. end
  121. -- 获得当前是开服第几天(如果是开服第一天返回1)
  122. function getServerOpenDay()
  123. local openTime = getServerOpenTime()
  124. if openTime == 0 then
  125. return
  126. end
  127. local startTime = Util.getDayStartTime(openTime)
  128. local now = os.time()
  129. return math.ceil((now - startTime + 1) / 24 / 3600)
  130. end
  131. function getIdentityMax()
  132. if db.identityMax == nil then
  133. db.identityMax = math.random(10001, 20000)
  134. setIdentityMax(db.identityMax)
  135. elseif db.identityMax < 10001 then
  136. db.identityMax = math.random(10001, 20000) -- 兼容老规则下数据
  137. setIdentityMax(db.identityMax)
  138. end
  139. return db.identityMax
  140. end
  141. -- 虚拟ID,假的
  142. function getFakeIdentityMax()
  143. return math.random(1, 9999)
  144. end
  145. function setIdentityMax(idMax)
  146. updateValue(KEY_IDENTITY_MAX, idMax)
  147. end
  148. function getUnionIdentityMax()
  149. if db.unionIdentityMax == nil then
  150. db.unionIdentityMax = math.random(10001, 20000)
  151. setUnionIdentityMax(db.unionIdentityMax)
  152. elseif db.unionIdentityMax < 10001 then
  153. db.unionIdentityMax = math.random(10001, 20000) -- 兼容老规则下数据
  154. setUnionIdentityMax(db.unionIdentityMax)
  155. end
  156. return db.unionIdentityMax
  157. end
  158. function setUnionIdentityMax(idMax)
  159. updateValue(KEY_UNION_IDENTITY_MAX, idMax)
  160. end
  161. function getRewardIndex()
  162. return db.rewardIndex or 0
  163. end
  164. function setRewardIndex(rewardIndex)
  165. updateValue(KEY_REWARD_INDEX, rewardIndex)
  166. end
  167. function getMergeSvrIndex()
  168. return db.mergeSvrIndex
  169. end
  170. cnt = 1
  171. function setBanIp(ip,time)
  172. db.banIp[cnt] =db.banIp[cnt] or {}
  173. db.banIp[cnt].ip = ip
  174. db.banIp[cnt].time = time
  175. cnt = cnt + 1
  176. updateValue(KEY_BAN_IP, db.banIp)
  177. end
  178. function getBanIp(ip)
  179. for k,v in pairs(db.banIp) do
  180. if v.ip == ip then
  181. return v.ip,v.time
  182. end
  183. end
  184. return
  185. end
  186. function delBanIp(ip)
  187. for k,v in pairs(db.banIp) do
  188. if v.ip == ip then
  189. db.banIp[k] = nil
  190. end
  191. end
  192. updateValue(KEY_BAN_IP, db.banIp)
  193. end
  194. -- 全服创号 冲级活动
  195. function getSvrChongJiGet(id)
  196. local num = 0
  197. if not db.chongJiAct then
  198. return num
  199. end
  200. if db.chongJiAct[id] then
  201. num = db.chongJiAct[id] or 0
  202. end
  203. return num
  204. end
  205. function addSvrChongJiGet(id)
  206. db.chongJiAct = db.chongJiAct or {}
  207. db.chongJiAct[id] = db.chongJiAct[id] or 0
  208. db.chongJiAct[id] = db.chongJiAct[id] + 1
  209. updateValue(KEY_CHONGJI_ACT, db.chongJiAct)
  210. end
  211. function getActMonth()
  212. return db.actMonth or 0
  213. end
  214. function setActMonth(month)
  215. updateValue(KEY_ACT_MONTH, month)
  216. end
  217. function getActMonthList(id)
  218. local act = nil
  219. if not db.actMonthList then
  220. return act
  221. end
  222. if db.actMonthList[id] then
  223. act = db.actMonthList[id] or 0
  224. end
  225. return act
  226. end
  227. function setActMonthList(id, endTime, month)
  228. db.actMonthList = db.actMonthList or {}
  229. db.actMonthList[id] = db.actMonthList[id] or {}
  230. db.actMonthList[id].endTime = endTime
  231. db.actMonthList[id].month = month
  232. updateValue(KEY_ACT_MONTH_LIST, db.actMonthList)
  233. end
  234. function getResetTime()
  235. return db.resetTime or 0
  236. end
  237. function setResetTime(time)
  238. updateValue(KEY_RESET_TIME, time)
  239. end
  240. function getMiddleInfo()
  241. return db.middleInfo
  242. end
  243. function setMiddleInfo(ip, port, host)
  244. db.middleInfo.ip = ip
  245. db.middleInfo.port = port
  246. db.middleInfo.host = host
  247. updateValue(KEY_MIDDLE_INFO, db.middleInfo)
  248. end
  249. function getChampionEndTime()
  250. return db.championEndTime or 0
  251. end
  252. function setChampionEndTime(time)
  253. updateValue(KEY_CHAMPION_END_TIME, time)
  254. end
  255. function getDragonNestCitiao()
  256. return db.dragonNestCiTiao
  257. end
  258. function setDragonNestCitiao(list, time)
  259. db.dragonNestCiTiao.citiao = Util.copyTable(list)
  260. db.dragonNestCiTiao.time = time
  261. updateValue(KEY_DRAGON_NEST_CITIAO, db.dragonNestCiTiao)
  262. end
  263. function setWorkManState(state)
  264. db.workMan.state = state
  265. updateValue(KEY_WORK_MAN, db.workMan)
  266. end
  267. function setWorkManGroup(group)
  268. db.workMan.group = group
  269. updateValue(KEY_WORK_MAN, db.workMan)
  270. end
  271. function setWorkManTs(ts)
  272. db.workMan.time = ts
  273. updateValue(KEY_WORK_MAN, db.workMan)
  274. end
  275. function getWorkMan()
  276. return db.workMan
  277. end
  278. -- 获取合服时间
  279. function getMergeServerTime()
  280. return db.mergeServerTime or 0
  281. end
  282. -- 获得当前是合服第几天(如果是合服第一天返回1)
  283. function getServerMergeDay()
  284. local mergeTime = getMergeServerTime()
  285. if mergeTime == 0 then
  286. return
  287. end
  288. local startTime = Util.getDayStartTime(mergeTime)
  289. local now = os.time()
  290. return math.ceil((now - startTime + 1) / 24 / 3600)
  291. end
  292. function setMergeTime(ts)
  293. db.mergeServerTime = ts
  294. updateValue("mergeServerTime", db.mergeServerTime)
  295. end
  296. function getYjTreasureEndTime()
  297. return db.yjTreasureTime or 0
  298. end
  299. function setYjTreasureEndTime(time)
  300. updateValue(KEY_YJ_TIME, time)
  301. end
  302. function getWeekCardBatch()
  303. return db.weekLoopCardBatch or 0
  304. end
  305. function setWeekCardBatch(nValue)
  306. updateValue(KEY_WEEKLOOP_CARD_BATCH, nValue)
  307. end
  308. function getVoucherInflate()
  309. return db.tVoucherInflateInfo
  310. end
  311. function setVoucherInflate(szText, nTime)
  312. if not szText or 0 >= nTime then
  313. return
  314. end
  315. local nNowLen = #db.tVoucherInflateInfo
  316. if nNowLen >= nVoucherInflateLen then
  317. local nDelLen = nNowLen - nVoucherInflateLen + 1
  318. for i = nDelLen, 1, -1 do
  319. table.remove(db.tVoucherInflateInfo, i)
  320. end
  321. end
  322. table.insert(db.tVoucherInflateInfo, {szText = szText, nTime = nTime})
  323. updateValue(KEY_VOUCHER_INFLATE, db.tVoucherInflateInfo)
  324. end
  325. -- 获取阵容数据
  326. function getRecommendLineUp()
  327. return db.recommendlineup
  328. end
  329. -- 修改阵容数据
  330. function SetRecommendLineUp(tData)
  331. db.recommendlineup = tData
  332. updateValue(kEY_RECOMMENDLINEUP, db.recommendlineup)
  333. end
  334. -- 获取烟花加成时间
  335. function getFireWorksBonusTime()
  336. return db.fireWorksBonusTime or 0
  337. end
  338. -- 设置烟花加成时间
  339. function setFireWorkBonusTime(nValue)
  340. updateValue(KEY_FIREWORKBONUS_TIME,nValue)
  341. end
  342. function GetInFireWork()
  343. -- 获取当前时间
  344. local nNowTime = os.time()
  345. local currentDuration = getFireWorksBonusTime()
  346. -- 检查是否在加成内
  347. if nNowTime <= currentDuration then
  348. return true
  349. end
  350. return false
  351. end