Files

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