2283 lines
37 KiB
Transact-SQL
2283 lines
37 KiB
Transact-SQL
-- LosaDev 2014: stub procedures for queries the May 2012 scripts do not have.
|
|
-- Generated by tools\make-stubs.js from ls_query.ini. Replace a stub with a real procedure to make that feature work.
|
|
USE [LosaGame];
|
|
GO
|
|
-- query 1
|
|
CREATE PROCEDURE [dbo].[game_pingpong]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 6
|
|
CREATE PROCEDURE [dbo].[game_hero_price_get_data]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 121
|
|
CREATE PROCEDURE [dbo].[game_get_ladderpoint]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 136
|
|
CREATE PROCEDURE [dbo].[game_member_count]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 137
|
|
CREATE PROCEDURE [dbo].[game_member_add]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 139
|
|
CREATE PROCEDURE [dbo].[game_create_nickname]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 165
|
|
CREATE PROCEDURE [dbo].[game_log_concurrent]
|
|
(
|
|
@p1 bigint = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 int = NULL
|
|
, @p6 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 167
|
|
CREATE PROCEDURE [dbo].[USP_LTS_MEMBER_SHUTDOWNTIME]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 int = NULL
|
|
, @p3 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 168
|
|
CREATE PROCEDURE [dbo].[game_piece_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 169
|
|
CREATE PROCEDURE [dbo].[game_piece_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 170
|
|
CREATE PROCEDURE [dbo].[game_piece_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 171
|
|
CREATE PROCEDURE [dbo].[game_piece_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 172
|
|
CREATE PROCEDURE [dbo].[log_event_marble_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 173
|
|
CREATE PROCEDURE [dbo].[game_sbox_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 smallint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 smallint = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 174
|
|
CREATE PROCEDURE [dbo].[game_sbox_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 smallint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 smallint = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 175
|
|
CREATE PROCEDURE [dbo].[game_sbox_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 176
|
|
CREATE PROCEDURE [dbo].[game_sbox_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 177
|
|
CREATE PROCEDURE [dbo].[game_pet_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 178
|
|
CREATE PROCEDURE [dbo].[game_pet_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 179
|
|
CREATE PROCEDURE [dbo].[game_pet_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 180
|
|
CREATE PROCEDURE [dbo].[game_pet_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 181
|
|
CREATE PROCEDURE [dbo].[game_costume_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 182
|
|
CREATE PROCEDURE [dbo].[game_costume_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 datetime = NULL
|
|
, @p5 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 183
|
|
CREATE PROCEDURE [dbo].[game_costume_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 datetime = NULL
|
|
, @p7 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 184
|
|
CREATE PROCEDURE [dbo].[game_costume_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 185
|
|
CREATE PROCEDURE [dbo].[game_mission_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 186
|
|
CREATE PROCEDURE [dbo].[game_mission_set_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 187
|
|
CREATE PROCEDURE [dbo].[game_mission_set_init]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 188
|
|
CREATE PROCEDURE [dbo].[event_item_limited_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 189
|
|
CREATE PROCEDURE [dbo].[event_item_limited_set_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 190
|
|
CREATE PROCEDURE [dbo].[event_item_limited_set_init]
|
|
(
|
|
@p1 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 191
|
|
CREATE PROCEDURE [dbo].[game_attend_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 192
|
|
CREATE PROCEDURE [dbo].[game_attend_set_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 193
|
|
CREATE PROCEDURE [dbo].[game_guild_reward_set_attend]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 194
|
|
CREATE PROCEDURE [dbo].[game_guild_reward_set_guildRank]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 195
|
|
CREATE PROCEDURE [dbo].[game_guild_attend_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 196
|
|
CREATE PROCEDURE [dbo].[game_guild_attend_get_list]
|
|
(
|
|
@p1 datetime = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 197
|
|
CREATE PROCEDURE [dbo].[game_item_extra_get_list_dev]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 198
|
|
CREATE PROCEDURE [dbo].[game_channel_get_cp_userID]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 199
|
|
CREATE PROCEDURE [dbo].[game_guildHQ_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 200
|
|
CREATE PROCEDURE [dbo].[game_guildHQ_set_status]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 bigint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 201
|
|
CREATE PROCEDURE [dbo].[game_guildHQ_set_fit]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 bigint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 202
|
|
CREATE PROCEDURE [dbo].[game_guildHQ_ver_get_info]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 203
|
|
CREATE PROCEDURE [dbo].[game_guildHQ_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 204
|
|
CREATE PROCEDURE [dbo].[game_guildHQ_set_default_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 205
|
|
CREATE PROCEDURE [dbo].[game_personalHQ_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 206
|
|
CREATE PROCEDURE [dbo].[game_personalHQ_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 207
|
|
CREATE PROCEDURE [dbo].[game_personalHQ_get_user_info]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 208
|
|
CREATE PROCEDURE [dbo].[game_personalHQ_set_status]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 bigint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 209
|
|
CREATE PROCEDURE [dbo].[game_personalHQ_set_fit]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 bigint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 210
|
|
CREATE PROCEDURE [dbo].[game_personalHQ_set_default_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 211
|
|
CREATE PROCEDURE [dbo].[game_title_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 212
|
|
CREATE PROCEDURE [dbo].[game_title_set_status]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 213
|
|
CREATE PROCEDURE [dbo].[game_title_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 bigint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 214
|
|
CREATE PROCEDURE [dbo].[game_timeCash_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 215
|
|
CREATE PROCEDURE [dbo].[game_timeCash_set_cash]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 216
|
|
CREATE PROCEDURE [dbo].[game_timeCash_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 217
|
|
CREATE PROCEDURE [dbo].[game_accessory_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 218
|
|
CREATE PROCEDURE [dbo].[game_accessory_set_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 datetime = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 219
|
|
CREATE PROCEDURE [dbo].[game_accessory_set_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 220
|
|
CREATE PROCEDURE [dbo].[game_accessory_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 datetime = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 221
|
|
CREATE PROCEDURE [dbo].[game_gold_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 222
|
|
CREATE PROCEDURE [dbo].[game_gold_set_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 223
|
|
CREATE PROCEDURE [dbo].[game_gold_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 224
|
|
CREATE PROCEDURE [dbo].[game_gold_set_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 225
|
|
CREATE PROCEDURE [dbo].[game_gold_get_used_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 300
|
|
CREATE PROCEDURE [dbo].[game_custom_get_customidx]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 301
|
|
CREATE PROCEDURE [dbo].[game_costume_skin_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1000
|
|
CREATE PROCEDURE [dbo].[log_data_play_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1001
|
|
CREATE PROCEDURE [dbo].[log_data_character_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1002
|
|
CREATE PROCEDURE [dbo].[log_data_peso_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1003
|
|
CREATE PROCEDURE [dbo].[log_data_time_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1004
|
|
CREATE PROCEDURE [dbo].[log_item_class_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1005
|
|
CREATE PROCEDURE [dbo].[log_item_decoration_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
, @p10 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1006
|
|
CREATE PROCEDURE [dbo].[log_item_equip_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 varchar(1024) = NULL
|
|
, @p11 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1007
|
|
CREATE PROCEDURE [dbo].[log_item_special_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1008
|
|
CREATE PROCEDURE [dbo].[log_data_tutorial_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1009
|
|
CREATE PROCEDURE [dbo].[log_item_gold_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 smallint = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
, @p10 varchar(1024) = NULL
|
|
, @p11 varchar(1024) = NULL
|
|
, @p12 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1010
|
|
CREATE PROCEDURE [dbo].[log_present_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 smallint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1011
|
|
CREATE PROCEDURE [dbo].[log_data_trade_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 bigint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1012
|
|
CREATE PROCEDURE [dbo].[log_data_medal_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1013
|
|
CREATE PROCEDURE [dbo].[log_data_medal_extend_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1014
|
|
CREATE PROCEDURE [dbo].[log_data_quest_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1015
|
|
CREATE PROCEDURE [dbo].[log_data_pcroom_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1016
|
|
CREATE PROCEDURE [dbo].[log_data_localinfo_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 varchar(1024) = NULL
|
|
, @p6 varchar(1024) = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
, @p10 varchar(1024) = NULL
|
|
, @p11 varchar(1024) = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 varchar(1024) = NULL
|
|
, @p14 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1017
|
|
CREATE PROCEDURE [dbo].[log_data_piece_mix_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 smallint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1018
|
|
CREATE PROCEDURE [dbo].[log_data_piece_divide_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1019
|
|
CREATE PROCEDURE [dbo].[log_data_piece_obtain_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1020
|
|
CREATE PROCEDURE [dbo].[log_event_cash_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1021
|
|
CREATE PROCEDURE [dbo].[log_data_league_present_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1022
|
|
CREATE PROCEDURE [dbo].[log_item_sbox_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 smallint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 smallint = NULL
|
|
, @p9 varchar(1024) = NULL
|
|
, @p10 int = NULL
|
|
, @p11 varchar(1024) = NULL
|
|
, @p12 varchar(1024) = NULL
|
|
, @p13 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1030
|
|
CREATE PROCEDURE [dbo].[log_data_pet_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 int = NULL
|
|
, @p12 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1040
|
|
CREATE PROCEDURE [dbo].[log_data_gear_upgrade_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1050
|
|
CREATE PROCEDURE [dbo].[log_data_awake_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 smallint = NULL
|
|
, @p7 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1060
|
|
CREATE PROCEDURE [dbo].[log_item_costume_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1065
|
|
CREATE PROCEDURE [dbo].[log_item_accessory_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1070
|
|
CREATE PROCEDURE [dbo].[log_gameLog_set_log]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 varchar(1024) = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 varchar(1024) = NULL
|
|
, @p16 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 1500
|
|
CREATE PROCEDURE [dbo].[SC_ERROR_LOG_ADD]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 varchar(1024) = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2019
|
|
CREATE PROCEDURE [dbo].[game_league_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2020
|
|
CREATE PROCEDURE [dbo].[game_league_list_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2021
|
|
CREATE PROCEDURE [dbo].[game_league_team_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2022
|
|
CREATE PROCEDURE [dbo].[game_league_team_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2023
|
|
CREATE PROCEDURE [dbo].[game_league_my_team_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2024
|
|
CREATE PROCEDURE [dbo].[game_league_team_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2025
|
|
CREATE PROCEDURE [dbo].[game_league_team_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2026
|
|
CREATE PROCEDURE [dbo].[game_league_team_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2027
|
|
CREATE PROCEDURE [dbo].[game_league_team_delete_all]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2028
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2029
|
|
CREATE PROCEDURE [dbo].[game_league_backup]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2030
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_app_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2031
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_app_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2032
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_app_del]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2033
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_app_reg]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2034
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_app_list_del]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2035
|
|
CREATE PROCEDURE [dbo].[game_league_team_member_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2036
|
|
CREATE PROCEDURE [dbo].[game_league_team_point_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 smallint = NULL
|
|
, @p5 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2037
|
|
CREATE PROCEDURE [dbo].[game_factiontype_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2038
|
|
CREATE PROCEDURE [dbo].[game_league_winner_history]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 varchar(1024) = NULL
|
|
, @p6 varchar(1024) = NULL
|
|
, @p7 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2039
|
|
CREATE PROCEDURE [dbo].[game_league_reward_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 smallint = NULL
|
|
, @p4 smallint = NULL
|
|
, @p5 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2040
|
|
CREATE PROCEDURE [dbo].[game_league_history_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2041
|
|
CREATE PROCEDURE [dbo].[game_league_winner_info]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2042
|
|
CREATE PROCEDURE [dbo].[game_league_get_reward]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2043
|
|
CREATE PROCEDURE [dbo].[game_league_reward_del]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2044
|
|
CREATE PROCEDURE [dbo].[game_league_user_list_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 varchar(1024) = NULL
|
|
, @p7 smallint = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
, @p11 tinyint = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 int = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2045
|
|
CREATE PROCEDURE [dbo].[game_league_get_info]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2046
|
|
CREATE PROCEDURE [dbo].[game_league_round_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2047
|
|
CREATE PROCEDURE [dbo].[game_league_auth_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2048
|
|
CREATE PROCEDURE [dbo].[game_league_auth_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2049
|
|
CREATE PROCEDURE [dbo].[game_league_info_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2050
|
|
CREATE PROCEDURE [dbo].[game_league_round_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 int = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 int = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 int = NULL
|
|
, @p26 int = NULL
|
|
, @p27 int = NULL
|
|
, @p28 int = NULL
|
|
, @p29 int = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 int = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 int = NULL
|
|
, @p37 int = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 int = NULL
|
|
, @p42 int = NULL
|
|
, @p43 int = NULL
|
|
, @p44 int = NULL
|
|
, @p45 int = NULL
|
|
, @p46 int = NULL
|
|
, @p47 int = NULL
|
|
, @p48 int = NULL
|
|
, @p49 int = NULL
|
|
, @p50 int = NULL
|
|
, @p51 int = NULL
|
|
, @p52 int = NULL
|
|
, @p53 int = NULL
|
|
, @p54 int = NULL
|
|
, @p55 int = NULL
|
|
, @p56 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2051
|
|
CREATE PROCEDURE [dbo].[log_data_clover_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2052
|
|
CREATE PROCEDURE [dbo].[game_clover_info]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2053
|
|
CREATE PROCEDURE [dbo].[game_clover_info_update]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2054
|
|
CREATE PROCEDURE [dbo].[game_friend_clover_info_update]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2055
|
|
CREATE PROCEDURE [dbo].[game_clover_friend_receive_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2056
|
|
CREATE PROCEDURE [dbo].[game_present_add_tool]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 smallint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 smallint = NULL
|
|
, @p9 datetime = NULL
|
|
, @p10 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2057
|
|
CREATE PROCEDURE [dbo].[game_league_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2058
|
|
CREATE PROCEDURE [dbo].[game_league_backup_user]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2059
|
|
CREATE PROCEDURE [dbo].[game_league_user_reward_add]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2060
|
|
CREATE PROCEDURE [dbo].[game_league_user_reward_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2061
|
|
CREATE PROCEDURE [dbo].[game_league_user_reward_del]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2070
|
|
CREATE PROCEDURE [dbo].[game_event_bingo_number_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 tinyint = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 tinyint = NULL
|
|
, @p15 tinyint = NULL
|
|
, @p16 tinyint = NULL
|
|
, @p17 tinyint = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 tinyint = NULL
|
|
, @p20 tinyint = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 tinyint = NULL
|
|
, @p23 tinyint = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 tinyint = NULL
|
|
, @p26 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2071
|
|
CREATE PROCEDURE [dbo].[game_event_bingo_present_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 tinyint = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2072
|
|
CREATE PROCEDURE [dbo].[game_event_bingo_number_get]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2073
|
|
CREATE PROCEDURE [dbo].[game_event_bingo_present_get]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2074
|
|
CREATE PROCEDURE [dbo].[game_event_bingo_number_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 tinyint = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 tinyint = NULL
|
|
, @p15 tinyint = NULL
|
|
, @p16 tinyint = NULL
|
|
, @p17 tinyint = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 tinyint = NULL
|
|
, @p20 tinyint = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 tinyint = NULL
|
|
, @p23 tinyint = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 tinyint = NULL
|
|
, @p26 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2075
|
|
CREATE PROCEDURE [dbo].[game_event_bingo_present_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 tinyint = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2076
|
|
CREATE PROCEDURE [dbo].[log_event_bingo_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2080
|
|
CREATE PROCEDURE [dbo].[game_relative_reward_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2081
|
|
CREATE PROCEDURE [dbo].[game_relative_reward_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2082
|
|
CREATE PROCEDURE [dbo].[game_relative_ranking_week]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2083
|
|
CREATE PROCEDURE [dbo].[game_relative_add]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2084
|
|
CREATE PROCEDURE [dbo].[game_league_cheer_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2085
|
|
CREATE PROCEDURE [dbo].[game_league_cheer_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2086
|
|
CREATE PROCEDURE [dbo].[game_league_get_reward_cheer]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2087
|
|
CREATE PROCEDURE [dbo].[game_league_reward_cheer_del]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2088
|
|
CREATE PROCEDURE [dbo].[game_league_history_get_winner_team_info]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2089
|
|
CREATE PROCEDURE [dbo].[game_managetool_user_block]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 datetime = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 varchar(1024) = NULL
|
|
, @p6 varchar(1024) = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2090
|
|
CREATE PROCEDURE [dbo].[game_attendance_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2091
|
|
CREATE PROCEDURE [dbo].[game_attendance_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2092
|
|
CREATE PROCEDURE [dbo].[game_attendance_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2095
|
|
CREATE PROCEDURE [dbo].[game_spentGold_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2096
|
|
CREATE PROCEDURE [dbo].[game_spentGold_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2097
|
|
CREATE PROCEDURE [dbo].[game_popStore_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2098
|
|
CREATE PROCEDURE [dbo].[game_popStore_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2099
|
|
CREATE PROCEDURE [dbo].[game_event_PirateRoulette_number_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2100
|
|
CREATE PROCEDURE [dbo].[game_event_PirateRoulette_number_get]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2101
|
|
CREATE PROCEDURE [dbo].[game_event_PirateRoulette_number_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 tinyint = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 tinyint = NULL
|
|
, @p15 tinyint = NULL
|
|
, @p16 tinyint = NULL
|
|
, @p17 tinyint = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 tinyint = NULL
|
|
, @p20 tinyint = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 tinyint = NULL
|
|
, @p23 tinyint = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 tinyint = NULL
|
|
, @p26 tinyint = NULL
|
|
, @p27 tinyint = NULL
|
|
, @p28 tinyint = NULL
|
|
, @p29 tinyint = NULL
|
|
, @p30 tinyint = NULL
|
|
, @p31 tinyint = NULL
|
|
, @p32 tinyint = NULL
|
|
, @p33 tinyint = NULL
|
|
, @p34 tinyint = NULL
|
|
, @p35 tinyint = NULL
|
|
, @p36 tinyint = NULL
|
|
, @p37 tinyint = NULL
|
|
, @p38 tinyint = NULL
|
|
, @p39 tinyint = NULL
|
|
, @p40 tinyint = NULL
|
|
, @p41 tinyint = NULL
|
|
, @p42 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2102
|
|
CREATE PROCEDURE [dbo].[game_event_PirateRoulette_present_add]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2103
|
|
CREATE PROCEDURE [dbo].[game_event_PirateRoulette_present_get]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2104
|
|
CREATE PROCEDURE [dbo].[game_event_PirateRoulette_present_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 tinyint = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2105
|
|
CREATE PROCEDURE [dbo].[game_coin_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2106
|
|
CREATE PROCEDURE [dbo].[game_coin_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2107
|
|
CREATE PROCEDURE [dbo].[game_coin_set_updatedate]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2108
|
|
CREATE PROCEDURE [dbo].[log_item_bonus_gold_set_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 smallint = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 varchar(1024) = NULL
|
|
, @p11 varchar(1024) = NULL
|
|
, @p12 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|