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.
75 rindas
3.9 KiB
75 rindas
3.9 KiB
%%%--------------------------------------
|
|
%%% @Module : custom_act_draw_record.hrl
|
|
%%% @Author : lhy
|
|
%%% @Created : 2019-06-01
|
|
%%% @Description: 定制活动抽奖记录
|
|
%%%--------------------------------------
|
|
|
|
-record(draw_record, {
|
|
draw_record_local = #{}, %% 本服抽奖记录 {Type, SubType} => [#draw_role{}|........]
|
|
draw_record_kf = #{} %% 跨服抽奖记录 {Type, SubType} => [#kf_draw_role{}|........]
|
|
}).
|
|
|
|
-record(draw_role, {
|
|
type = 0, %% 活动类型
|
|
sub_type = 0, %% 活动子类型
|
|
role_id = 0, %% 玩家id
|
|
grade_id = 0, %% 奖励档次id
|
|
time = 0 %% 时间
|
|
}).
|
|
|
|
-record(kf_draw_role, {
|
|
type = 0, %% 活动类型
|
|
sub_type = 0, %% 活动子类型
|
|
role_id = 0, %% 玩家id
|
|
server_id = 0, %% 服务器id
|
|
platform = "", %% 平台名字
|
|
server_num = 0, %% 所在的服标示
|
|
name = "", %% 名字
|
|
grade_id = 0, %% 奖励档次id
|
|
time = 0 %% 时间
|
|
}).
|
|
|
|
-record(draw_record_state, {
|
|
draw_maps = #{} %% {Type, SubType} => [#draw_role{}|.....]
|
|
}).
|
|
|
|
%% 跨服分区
|
|
-record(kf_draw_record_state, {
|
|
zone_max_id = #{}, %% ZoneType => ZoneMaxId
|
|
zone_maps = #{} %% {ZoneType, ZoneId} => [{Type, SubType} => [#kf_draw_role{}|.....]] 全服默认为{0,0}
|
|
}).
|
|
|
|
%% ------------------------------- 自定义添加 ----------------------------------------
|
|
%% 活动记录上限
|
|
-define(WISH_RECORD_NUM_LIMIT, 20). %% 欢乐许愿 许愿记录上限
|
|
|
|
%% --------------------------------------------- db local ------------------------------------------------------
|
|
-define(sql_custom_act_draw_record_delete,
|
|
<<"delete from `draw_record_act_local` where type=~p and sub_type = ~p ">>).
|
|
-define(sql_custom_act_draw_record_insert,
|
|
<<"insert into `draw_record_act_local` set type=~p, sub_type=~p, role_id=~p, grade_id=~p, time=~p">>).
|
|
-define(sql_custom_act_draw_record_role_select,
|
|
<<"select `type`, `sub_type`, `role_id`, `grade_id`, `time` from `draw_record_act_local` where `role_id`=~p ORDER BY id DESC">>).
|
|
-define(sql_custom_act_draw_record_select,
|
|
<<"select `type`, `sub_type`, `role_id`, `grade_id`, `time` from `draw_record_act_local` ORDER BY id DESC">>).
|
|
|
|
%% --------------------------------------------- db kf -----------------------------------------------------------
|
|
-define(sql_custom_act_draw_record_kf_select,
|
|
<<"select `type`, `sub_type`, `role_id`, `server_id`,`platform`,`server_num`, `name`, `grade_id`, `time` from `draw_record_kf_act` where `type`=~p and `server_id`=~p ORDER BY id DESC">>).
|
|
-define(sql_custom_act_draw_record_kf_whole_select,
|
|
<<"select `type`, `sub_type`, `role_id`, `server_id`,`platform`,`server_num`, `name`, `grade_id`, `time` from `draw_record_kf_act` where `type`=~p ORDER BY id DESC">>).
|
|
-define(sql_custom_act_draw_record_role_kf_insert,
|
|
<<"insert into `draw_record_kf_act` set type=~p, sub_type=~p, role_id=~p, server_id=~p,platform='~s',server_num=~p, name='~ts', grade_id=~p, time=~p">>).
|
|
-define(sql_custom_act_draw_record_role_kf_delete,
|
|
<<"delete from `draw_record_kf_act` where type=~p and sub_type = ~p and server_id = ~p">>).
|
|
-define(sql_custom_act_draw_record_role_kf_whole_delete,
|
|
<<"delete from `draw_record_kf_act` where type=~p and sub_type = ~p">>).
|
|
|
|
%% ---------------------------------------------- db kf_local --------------------------------------------------------
|
|
-define(sql_kf_draw_record_local_insert,
|
|
<<"insert into `draw_record_kf_act_local` set type=~p, sub_type=~p, role_id=~p, grade_id=~p, time=~p">>).
|
|
-define(sql_custom_act_draw_record_role_kf_select,
|
|
<<"select `type`, `sub_type`, `role_id`, `grade_id`, `time` from `draw_record_kf_act_local` where `role_id`=~p ORDER BY id DESC">>).
|
|
-define(sql_kf_draw_record_local_delete,
|
|
<<"delete from `draw_record_kf_act_local` where type=~p and sub_type = ~p ">>).
|