%% ---------------------------------------------------------
%% Author:  xyj
%% Email:   156702030@qq.com
%% Created: 2011-12-13
%% Description: 物品装备SQL定义
%% --------------------------------------------------------

%% --------------------------------- 生成物品%% ---------------------------------
-define(SQL_GOODS_INSERT,
        <<"insert into goods set id=~p, role_id=~p, goods_id=~p, type=~p, subtype=~p, location=~p, cell=~p,
           num=~p, create_time=UNIX_TIMESTAMP(), expire_time=~p, bind=~p, extra_data='~ts' ">>).

%% --------------------------------- 获取物品 ---------------------------------
-define(SQL_GOODS_LIST_DEFAULT,
    <<"select id, role_id, goods_id, type, subtype, location, cell, num, create_time, expire_time, bind, extra_data">>).

-define(SQL_GOODS_SELECT_BY_ID,     <<?SQL_GOODS_LIST_DEFAULT/binary,
    <<" from `goods` where id=~p and role_id = ~p">>/binary >>).

-define(SQL_GOODS_LIST_BY_LOCATION, <<?SQL_GOODS_LIST_DEFAULT/binary,
    <<" from `goods` where role_id = ~p and location = ~p">>/binary >>).

%% --------------------------------- 物品更改 ---------------------------------
-define(SQL_GOODS_UPDATE_NUM,
    <<"update `goods` set num = ~p where id = ~p and role_id = ~p">>).
-define(SQL_GOODS_UPDATE_LOCATION_CELL,
    <<"update `goods` set location = ~p, cell = ~p, extra_data='~ts' where id = ~p and role_id = ~p">>).
-define(SQL_GOODS_UPDATE_LOCATION_CELL_BIND,
    <<"update `goods` set location = ~p, cell = ~p, bind=~p, extra_data='~ts' where id = ~p and role_id = ~p">>).
-define(SQL_GOODS_UPDATE_OTHER,
    <<"update `goods` set extra_data = '~ts' where id = ~p and role_id = ~p">>).
-define(SQL_GOODS_UPDATE_EXPIRE,
    <<"update `goods` set expire_time = ~p where id = ~p and role_id = ~p">>).
-define(SQL_GOODS_UPDATE_EXTRA, <<"update `goods_extra` set stren = ~p, exp = ~p, stage = ~p, dstone = '~s', stren_expend = ~p where gid = ~p">>).

-define(SQL_GOODS_UPDATE_INFO,
    <<"update goods set goods_id=~p,type=~p,subtype=~p,create_time=UNIX_TIMESTAMP(),extra_data='~ts' where id=~p and role_id=~p">>).

%% --------------------------------- 物品删除 ---------------------------------
-define(SQL_GOODS_DELETE_BY_ID,
    <<"delete from `goods` where `id` = ~p and `role_id` = ~p">>).

%% --------------------------------- 背包操作 ---------------------------------
-define(SQL_PLAYER_UPDATE_CELL,     <<"update `player_attr` set cell_num=~p where id=~p">>).
-define(SQL_PLAYER_UPDATE_STORAGE_NUM, <<"update `player_attr` set storage_num=~p where id=~p">>).

%% --------------------------------- 虚拟货币 ---------------------------------
-define (SQL_INSERT_CURRENCY,                   <<"INSERT INTO `player_special_currency`(`player_id`, `currency_id`, `num`) VALUES (~p, ~p, ~p)">>).

-define (SQL_UPDATE_CURRENCY,                   <<"UPDATE `player_special_currency` SET `num`=~p WHERE `player_id` = ~p AND `currency_id` = ~p">>).

-define (LOAD_CURRENCY,                         <<"SELECT `currency_id`, `num` FROM `player_special_currency` WHERE `player_id` = ~p">>).





%% --------------------------------- 礼包 ---------------------------------
-define(SQL_GIFT_QUEUE_DELETE,                  <<"delete from `gift_list` where player_id=~p ">>).

%% gift_card
-define(SQL_GIFT_CARD_INSERT,                   <<"insert into `gift_card` set player_id=~p, card_no='~s', type=~p, time=~p, status=1 ">>).
-define(SQL_GIFT_CARD_SELECT,                   <<"select status from `gift_card` where card_no='~s' ">>).
-define(SQL_GIFT_CARD_BASE_SELECT,              <<"select card_no from `base_gift_card` where accname='~s' limit 1 ">>).

-define(SQL_CHARGE_SELECT,                      <<"select id from `charge` where player_id=~p and status=1 limit 1 ">>).