Nevar pievienot vairāk kā 25 tēmas
Tēmai ir jāsākas ar burtu vai ciparu, tā var saturēt domu zīmes ('-') un var būt līdz 35 simboliem gara.
57 rindas
2.5 KiB
57 rindas
2.5 KiB
%%%------------------------------------
|
|
%%% @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">>).
|