|
|
- %%%------------------------------------
- %%% @Module : consume_rank_act.hrl
- %%% @Author : fwx
- %%% @Created : 2018-1-5
- %%% @Description: 充值消费榜活动
- %%%------------------------------------
-
- -define(RANK_TYPE_RECHARGE, 381). %% 充值
- -define(RANK_TYPE_CONSUME, 382). %% 消费
-
- %% 榜单的角色信息
- %% 注意:需要排序的话,使用value、second_value、third_value,不要用其他字段
- -record(rank_role, {
- role_key = undefined, % 玩家唯一键 {RankType, Roleid}
- rank_type = 0, % 榜单类型
- sub_type = 0, % 活动子类型
- role_id = 0, % 角色id
- is_public = 0, % 是否公开金额 0-不公开 1-公开
- award_state = [], % 奖励领取状态 0-未领取 1-已领取
- value = 0, % 值 (排序值)
- second_value = 0, % 保留值
- third_value = 0, % 保留值
- time = 0, % 时间
- rank = 0 % 排名
- }).
-
- %% 进程状态
- -record(rank_state, {
- rank_maps = maps:new(), % {RankType, SubType} => [#rank_role{}|...]
- role_maps = maps:new(), % {RankType, SubType} => [#rank_role{}|...]
- rank_limit = maps:new() % {RankType, SubType} => Limit
- }).
-
-
- %%-----------------select--------------------%%
- -define(sql_rank_role_select, <<"
- SELECT
- rank_type, sub_type, player_id, is_public, award_state, value, second_value, third_value, time
- FROM consume_rank_act">>).
-
- %%-----------------update--------------------%%
- -define(sql_rank_role_update,
- <<"update `consume_rank_act` set `is_public` = ~p where rank_type = ~p and sub_type = ~p and player_id = ~p">>).
-
- %--------------replace-----------%
- -define(sql_rank_role_save, <<"
- replace into consume_rank_act(
- rank_type, sub_type, player_id, is_public, award_state, value, second_value, third_value, time
- ) values(~p, ~p, ~p, ~p, '~s', ~p, ~p, ~p, ~p)">>).
-
- %--------------delete--------------%
- -define(sql_rank_role_delete_by_role_id, <<"delete from consume_rank_act
- where rank_type = ~p and sub_type = ~p and player_id = ~p">>).
-
- %---------删除活动子类对应数据-----------%
- -define(sql_rank_role_clear,
- <<"delete from `consume_rank_act` where rank_type = ~p and sub_type = ~p">>).
|
