yzySrv/include/sql_dungeon.hrl

%%------------------------------------------------------------------------------
%% @Module  : sql_dungeon.hrl
%% @Author  : HHL
%% @Email   :
%% @Created : 2014.6.5
%% @Description: 副本系统sql文件
%%------------------------------------------------------------------------------

%%==================================================大闹天空：天空奇缘======================================================

%%--------------------------------所有副本日志数据------------------------------------
%% 查询全部副本日志.
-define(sql_dungeon_log_sel_all,
        <<"SELECT `role_id`, `dungeon_id`, `total_count`, `pass_count`, `record_level`, `pass_time`, `gift`, `diff_level`,
        `coin`, `beat` FROM `dungeon_log` WHERE role_id=~p">>).

%% 查询副本日志表.
-define(sql_select_dungeon_log, <<"select log from dungeon_log where role_id =~p">>).

%% 代替副本日志表.
-define(sql_replace_dungeon_log, <<"replace into dungeon_log (role_id, log) values (~p, '~s')">>).

%% 更新副本日志表.
-define(sql_update_dungeon_log, <<"update dungeon_log set log='~s' where role_id=~p">>).


%% 查询指定副本id副本日志.
-define(sql_dungeon_log_sel_type,
        <<"SELECT `role_id`, `dungeon_id`, `total_count`, `pass_count`, `record_level`, `pass_time`, `gift`,
        `diff_level` FROM `dungeon_log` WHERE `role_id` =~p AND `dungeon_id` =~p">>).

-define(sql_dungeon_log_sel_type2,
        <<"SELECT `dungeon_id`, `record_level`, `pass_time` FROM `dungeon_log` WHERE `role_id` =~p AND `dungeon_id` =~p">>).

%% 增加全部副本日志.
-define(sql_dungeon_log_add,
        <<"INSERT INTO `dungeon_log` (`role_id`, `dungeon_id`, `total_count`, `pass_count`, `record_level`, `pass_time`,
         `gift`, `diff_level`, `coin`, `beat`) VALUES (~p, ~p, ~p, ~p, ~p, ~p, ~p, '~s', ~p,  ~p);">>).

%% 更新全部副本日志.
-define(sql_dungeon_log_upd_count,
        <<"UPDATE `dungeon_log` SET `total_count`=~p, `pass_count`=~p, `record_level`=~p, `pass_time`=~p, `gift` =~p,
        `coin` =~p, `beat` =~p WHERE `role_id` =~p AND `dungeon_id` =~p">>).

%% 替换全部副本日志.
-define(sql_dungeon_log_upd,
        <<"REPLACE INTO `dungeon_log` (`role_id`, `dungeon_id`, `total_count`, `pass_count`, `record_level`, `pass_time`,
        `gift`, `diff_level`, `coin`, `beat`) VALUES (~p, ~p, ~p, ~p, ~p, ~p, ~p, '~s', ~p, ~p)">>).

%% 清空副本日志.
-define(sql_dungeon_log_clear,<<"truncate table `dungeon_log`">>).

%%------------------------------体力副本挂机表----------------------------------

%% 查询装备副本挂机表.
-define(sql_dun_sweep_sel,
        <<"SELECT `id`, `dungeon_id`, `begin_time`, `exp`, `wuhun`, `finish`, `auto_num`, `shake_type`, `bgold`, `coin` FROM `dungeon_sweep` WHERE `id` =~p">>).

%% 替换装备副本挂机表.
-define(sql_dun_sweep_rep,
        <<"REPLACE INTO `dungeon_sweep` (`id`, `dungeon_id`, `begin_time`, `exp`, `wuhun`, `finish`, `auto_num`, `shake_type`, `bgold`, `coin` ) VALUES (~p, ~p, ~p, ~p, ~p, ~p, ~p, ~p, ~p, ~p)">>).



%%--------------------------------多人副本-------------------------------------
%% 更新难度
-define(sql_up_dungeon_diff_lv,
        <<"UPDATE dungeon_log SET diff_level='~s' WHERE role_id=~p AND dungeon_id=~p">>).

%% 玩家多人副本的积分记录
-define(sql_in_mp_dun_score,
        <<"INSERT INTO dungeon_mp_score_exchange (role_id, total_score, temp_score,  is_get_score, time)VALUES(~p, ~p, ~p, ~p, ~p)">>).

%% 多人副本更新整个数据
-define(sql_up_mp_score_goods,
        <<"UPDATE dungeon_mp_score_exchange SET total_score=~p, temp_score=~p, is_get_score=~p, time=~p WHERE role_id=~p">>).

%% 多人副本同过id获取玩家的数据
-define(sql_se_mp_dun_score,
        <<"SELECT role_id, total_score, temp_score, is_get_score, time FROM dungeon_mp_score_exchange WHERE role_id=~p">>).

%% 多人副本所有记录
-define(sql_se_all_mp_dun_score,
        <<"SELECt role_id, total_score, temp_score, is_get_score, time FROM dungeon_mp_score_exchange">>).



%% 铜币副本的排行榜

%% 查找
-define(SQL_SELECT_COINDUN_RANK_ALL,
    <<"SELECT dun_type_id, dun_id, dun_lv, role_id, role_name, coin, time FROM dungeon_coin_rank where dun_type_id = ~p">>).

%% 更新
-define(SQL_REPLACE_COINDUN_RANK_BY_DUNID,
    <<"REPLACE INTO dungeon_coin_rank (dun_type_id, dun_id, dun_lv, role_id, role_name, coin, time) VALUES (~p, ~p, ~p, ~p, '~ts', ~p, ~p)">>).

%% 装备副本章节礼包日志
%% 查找
-define(SQL_SELECT_DUN_CHAPTER_GIFT,
    <<"SELECT role_id, chapter_id, star_num, is_get, time FROM dungeon_equip_chapter_gift where role_id = ~p">>).

%% 更新
-define(SQL_REPLACE_DUN_CHAPTER_GIFT,
    <<"REPLACE INTO dungeon_equip_chapter_gift (role_id, chapter_id, star_num, is_get, time) VALUES (~p, ~p, ~p, ~p, ~p)">>).


%% 闯关之路状态
-define(SQL_SELECT_PASS_FLOOR_BY_ID,
    <<"SELECT role_id, floor_id, is_pass, finish_list, score, less_hp, last_mon_floor_id, mon_id, mon_hp,
        mon_rule, master_career, master_name, master_content, time FROM dungeon_pass_floor WHERE role_id = ~p;">>).


%% 更新玩家闯关之路状态
-define(SQL_REPLACE_PASS_FLOOR_BY_ID,
    <<"REPLACE INTO dungeon_pass_floor(role_id, floor_id, is_pass, finish_list, score, less_hp, last_mon_floor_id,
    mon_id, mon_hp, mon_rule, master_career, master_name, master_content, time) VALUES
    (~p, ~p, ~p, '~s', ~p, ~p, ~p, ~p, ~p, ~p, ~p, '~ts', 't~s', ~p);">>).


%% 更新玩家闯关之路的裁判状态
-define(SQL_UPDATE_PASS_FLOOR_BY_ID,
    <<"UPDATE dungeon_pass_floor SET last_mon_floor_id=~p, mon_id=~p, mon_hp=~p, time=~p WHERE role_id=~p">>).


%% 更新玩家闯关之路的裁判状态
-define(SQL_UPDATE_RESET_PASS_FLOOR_BY_ID,
    <<"UPDATE dungeon_pass_floor SET floor_id=~p, is_pass=~p, score=~p, less_hp=~p, last_mon_floor_id=~p,
    mon_id=~p, mon_hp=~p, mon_rule=~p, master_career=~p, master_name='~ts', master_content='~ts', time=~p WHERE role_id=~p">>).


%% 闯关之路排行榜floor_rank init_all
-define(SQL_SELECT_FLOOR_RANK,
    <<"SELECT role_id, name, career, power, vip, lv, picture_addr, guild_name, high_floor_id, content, time FROM dungeon_floor_rank;">>).


%% floor_rank 更新
-define(SQL_REPLACE_FLOOR_RANK,
    <<"REPLACE INTO dungeon_floor_rank(role_id, name, career, power, vip, lv, picture_addr, guild_name, high_floor_id, content, time)
    VALUES(~p, '~ts', ~p, ~p, ~p, ~p, '~s', '~ts', ~p, '~ts', ~p);">>).


%% 神兵副本
%% 获取玩家的神兵副本数据
-define(SQL_SELECT_DUNGEON_GADARMS,
    <<"SELECT dun_lv, role_id, revive_time, role_hp, dun_time, count, is_pass, time FROM dungeon_god_arms WHERE role_id = ~p">>).


%% 神兵副本
%% 获取所有玩家的神兵副本数据
-define(SQL_SELECT_DUNGEON_GADARMS_ALL,
    <<"SELECT dun_lv, role_id, revive_time, role_hp, dun_time, count, is_pass, time FROM dungeon_god_arms">>).


%% 更新玩家的神兵副本数据
-define(SQL_REPLACE_DUNGEON_GADARMS,
    <<"REPLACE INTO dungeon_god_arms(dun_lv, role_id, revive_time, role_hp, dun_time, count, is_pass, time) VALUES
    (~p, ~p, ~p, ~p, ~p, ~p, ~p, ~p);">>).


%% 更新玩家的神兵副本的复活次数和血量
-define(SQL_UPDATE_DUNGEON_GADARMS_REVIVETIME,
    <<"UPDATE dungeon_god_arms SET revive_time=~p, role_hp=~p, time=~p WHERE dun_lv=~p AND role_id=~p">>).