Du kan inte välja fler än 25 ämnen
Ämnen måste starta med en bokstav eller siffra, kan innehålla bindestreck ('-') och vara max 35 tecken långa.
68 rader
3.7 KiB
68 rader
3.7 KiB
%% ---------------------------------------------------------
|
|
%% 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 ">>).
|
|
|
|
|