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.
68 rindas
3.3 KiB
68 rindas
3.3 KiB
%% ---------------------------------------------------------
|
|
%% Author: xyj
|
|
%% Email: 156702030@qq.com
|
|
%% Created: 2012-2-4
|
|
%% Description: buff, 温泉, 采矿 ets
|
|
%% --------------------------------------------------------
|
|
|
|
-define(ETS_BUFF, ets_buff). %% 玩家buff
|
|
|
|
%% BUFF状态表
|
|
-record(ets_buff, {
|
|
id = 0, %% 编号
|
|
pid = 0, %% 角色ID
|
|
type = 0, %% BUFF类型
|
|
goods_id = 0, %% 物品类型ID
|
|
effect_list = [], %% 效果[{coin,铜钱},{gold,元宝},...]
|
|
end_time = 0, %% 结束时间戳
|
|
scene = [] %% 场景限制
|
|
}).
|
|
|
|
%% ---------------------- #ets_buff.type ---------------------
|
|
|
|
-define(BUFF_EXP_KILL_MON, 1). %% 杀怪经验加成buff
|
|
-define(BUFF_DROP_KILL_MON, 2). %% 杀怪掉落加成buff
|
|
-define(BUFF_GWAR_DOMINATOR, 3). %% 主宰公会会长buff
|
|
-define(BUFF_GWAR_INSPIRE, 4). %% 公会争霸士气鼓舞buff
|
|
-define(BUFF_TEAM_SHOW, 5). %% 队伍显示被动buff(荆棘之心)
|
|
-define(BUFF_INTIMACY, 6). %% 好友度buff
|
|
% -define(BUFF_TEAM_EXP, 7). %% 组队经验加成buff
|
|
-define(BUFF_NOON_QUIZ, 8). %% 中午答题buff
|
|
-define(BUFF_VIP_IMMUNE, 10). %% 至尊vip无敌buff
|
|
-define(BUFF_CAMP_WAR, 15). %% 跨服团战buff加成
|
|
-define(BUFF_SKILL, 255). %% 技能产生的buff
|
|
%% 以下不会发给客户端
|
|
-define (BUFF_EXP_DUN_ACT, 256). %% 副本经验活动加成
|
|
|
|
%% ------------------ #ets_buff.effect_list ------------------
|
|
-define(BUFF_EFFECT_EXP_KILL_MON, exp_mon). %% 杀怪经验加成
|
|
-define(BUFF_EFFECT_DROP_KILL_MON, exp_drop). %% 杀怪掉落加成
|
|
-define(BUFF_EFFECT_ATTR, attr). %% 属性加成
|
|
-define(BUFF_EFFECT_VIP_IMMUNE, vip_immune). %% 至尊vip无敌
|
|
% -define(BUFF_EFFECT_INTIMACY, intimacy). %% 好友度
|
|
|
|
%% 插入buff
|
|
-define(sql_insert_buff, <<"insert into `buff` set pid = ~p, type = ~p, goods_id = ~p, effect_list = '~s', end_time = ~p, scene='~s' ">>).
|
|
%% 更新buff
|
|
-define(sql_update_buff, <<"update `buff` set goods_id = ~p, effect_list = '~s', end_time = ~p, scene='~s' where id = ~p ">>).
|
|
|
|
%% 查询buff
|
|
-define(sql_select_buff_all, <<"select id,pid,type,goods_id,effect_list,end_time,scene from `buff` where pid = ~p ">>).
|
|
%% 查询同类buff
|
|
-define(sql_select_buff_type, <<"select id from `buff` where pid = ~p and type =~p">>).
|
|
%% 查询某类过期buff信息
|
|
-define(sql_select_buff_type_expired, <<"select goods_id, end_time from `buff` where pid = ~p and type = ~p and end_time > 0 and end_time <= ~p">>).
|
|
%% 查询buff表最新id
|
|
-define(sql_select_buff_last_id,<<"select `id` from `buff` where `pid` = ~p and type = ~p and goods_id = ~p">>).
|
|
|
|
|
|
%% 删除buff
|
|
-define(sql_delete_buff, <<"delete from `buff` where id = ~p ">>).
|
|
%% 删除玩家buff
|
|
-define(sql_delete_player_buff, <<"delete from `buff` where pid = ~p ">>).
|
|
%% 删除玩家过期的buff
|
|
-define(sql_delete_player_expired_buff, <<"delete from `buff` where pid = ~p and end_time > 0 and end_time <= ~p">>).
|
|
%% 删除玩家某个类型buff
|
|
-define(sql_delete_player_buff_by_type, <<"delete from `buff` where pid = ~p and type = ~p">>).
|
|
%% 删除某个类型buff
|
|
-define(sql_delete_buff_by_type, <<"delete from `buff` where type = ~p">>).
|