%%%------------------------------------ %%% @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">>).