|
|
- %%-----------------------------------------------------------------------------
- %% @Module : lucky_flop
- %% @Author : WJQ
- %% @Created : 2019-07-17
- %% @Description: 幸运翻牌
- %%-----------------------------------------------------------------------------
-
- -define(NOT_GET, 0). %% 未抽取
- -define(HAS_GET, 1). %% 已抽取
-
- %% 玩家幸运翻牌数据
- -record(lucky_flop, {
- data_map = #{} %% #{SubType => #lucky_flop_data{}}
- }).
-
- %% 单个子类型数据
- -record(lucky_flop_data, {
- sub_type = 0, %% 活动子类型
- now_times = 0, %% 当前抽奖次数
- total_times = 0, %% 累计抽奖次数
- turn = 0, %% 当前抽奖轮数
- draw_rewards = [], %% 奖池列表[{奖励档次,是否已获取},...]
- receive_rewards = [], %% 已领取累计奖励列表[奖励档次,...]
- time = 0 %% 更新时间
- }).
-
- -define(SELECT_LUCKY_FLOP,
- <<"SELECT `sub_type`, `now_times`, `total_times`, `turn`, `draw_rewards`, `receive_rewards`, `time`
- FROM `lucky_flop` WHERE `role_id` = ~p ">>).
-
- -define(SELECT_ALL_LUCKY_FLOP,
- <<"SELECT `role_id`, `now_times`, `receive_rewards` FROM `lucky_flop` WHERE `sub_type` = ~p ">>).
-
- -define(REPLACE_LUCKY_FLOP,
- <<"REPLACE `lucky_flop`(`role_id`, `sub_type`, `now_times`, `total_times`, `turn`, `draw_rewards`, `receive_rewards`, `time`)
- VALUES(~p, ~p, ~p, ~p, ~p, '~s', '~s', ~p)">>).
-
- -define(DELETE_LUCKY_FLOP_BY_SUB_TYPE, <<"DELETE FROM `lucky_flop` WHERE `sub_type` = ~p">>).
-
- -define(DELETE_LUCKY_FLOP_ROLE, <<"DELETE FROM `lucky_flop` WHERE `role_id` = ~p AND `sub_type` IN (~s)">>).
|
