5120 lines
84 KiB
Transact-SQL
5120 lines
84 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 [LosaLogData];
|
|
GO
|
|
-- query 1
|
|
CREATE PROCEDURE [dbo].[game_pingpong]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2
|
|
CREATE PROCEDURE [dbo].[game_login_serverid_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 3
|
|
CREATE PROCEDURE [dbo].[game_server_connection_on]
|
|
(
|
|
@p1 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 4
|
|
CREATE PROCEDURE [dbo].[game_server_delete]
|
|
(
|
|
@p1 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 5
|
|
CREATE PROCEDURE [dbo].[game_encode_get_fix_key]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 6
|
|
CREATE PROCEDURE [dbo].[game_hero_price_get_data]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 7
|
|
CREATE PROCEDURE [dbo].[game_login_get_data]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 8
|
|
CREATE PROCEDURE [dbo].[game_login_save]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 9
|
|
CREATE PROCEDURE [dbo].[game_login_init_user]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 10
|
|
CREATE PROCEDURE [dbo].[game_login_init_server]
|
|
(
|
|
@p1 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 11
|
|
CREATE PROCEDURE [dbo].[game_game_get_data]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 12
|
|
CREATE PROCEDURE [dbo].[game_game_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 bigint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 datetime = 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 13
|
|
CREATE PROCEDURE [dbo].[game_game_renpoint_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 14
|
|
CREATE PROCEDURE [dbo].[game_game_heroexp_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 15
|
|
CREATE PROCEDURE [dbo].[game_game_heroexp_init]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 16
|
|
CREATE PROCEDURE [dbo].[game_config_keyboard_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 17
|
|
CREATE PROCEDURE [dbo].[game_award_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 18
|
|
CREATE PROCEDURE [dbo].[game_award_get_level]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 19
|
|
CREATE PROCEDURE [dbo].[game_class_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 20
|
|
CREATE PROCEDURE [dbo].[game_record_battle_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 21
|
|
CREATE PROCEDURE [dbo].[game_item_etc_get_data_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 22
|
|
CREATE PROCEDURE [dbo].[game_item_extra_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 23
|
|
CREATE PROCEDURE [dbo].[game_questcomplete_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 24
|
|
CREATE PROCEDURE [dbo].[game_quest_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 25
|
|
CREATE PROCEDURE [dbo].[game_character_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 26
|
|
CREATE PROCEDURE [dbo].[game_item_get_data_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 27
|
|
CREATE PROCEDURE [dbo].[game_ability_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 28
|
|
CREATE PROCEDURE [dbo].[game_item_medal_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 29
|
|
CREATE PROCEDURE [dbo].[game_item_medal_extend_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 30
|
|
CREATE PROCEDURE [dbo].[game_event_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 31
|
|
CREATE PROCEDURE [dbo].[game_character_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 smallint = NULL
|
|
, @p19 smallint = NULL
|
|
, @p20 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 32
|
|
CREATE PROCEDURE [dbo].[game_character_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 33
|
|
CREATE PROCEDURE [dbo].[game_character_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 34
|
|
CREATE PROCEDURE [dbo].[game_character_sava]
|
|
(
|
|
@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 smallint = NULL
|
|
, @p20 smallint = NULL
|
|
, @p21 int = NULL
|
|
, @p22 tinyint = NULL
|
|
, @p23 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 35
|
|
CREATE PROCEDURE [dbo].[game_character_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 36
|
|
CREATE PROCEDURE [dbo].[game_character_delete_limitdate]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 37
|
|
CREATE PROCEDURE [dbo].[game_character_regdate_save]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 38
|
|
CREATE PROCEDURE [dbo].[game_character_rental_history]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 39
|
|
CREATE PROCEDURE [dbo].[game_character_rental_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 40
|
|
CREATE PROCEDURE [dbo].[game_class_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 tinyint = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 tinyint = NULL
|
|
, @p26 int = NULL
|
|
, @p27 int = NULL
|
|
, @p28 int = NULL
|
|
, @p29 tinyint = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 tinyint = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 int = NULL
|
|
, @p37 tinyint = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 41
|
|
CREATE PROCEDURE [dbo].[game_class_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 42
|
|
CREATE PROCEDURE [dbo].[game_class_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 tinyint = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 tinyint = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 tinyint = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 tinyint = NULL
|
|
, @p26 int = NULL
|
|
, @p27 int = NULL
|
|
, @p28 int = NULL
|
|
, @p29 tinyint = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 tinyint = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 int = NULL
|
|
, @p37 tinyint = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 tinyint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 43
|
|
CREATE PROCEDURE [dbo].[game_item_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
|
|
, @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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 44
|
|
CREATE PROCEDURE [dbo].[game_item_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 45
|
|
CREATE PROCEDURE [dbo].[game_item_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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 46
|
|
CREATE PROCEDURE [dbo].[game_item_etc_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
|
|
, @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
|
|
, @p57 int = NULL
|
|
, @p58 int = NULL
|
|
, @p59 int = NULL
|
|
, @p60 int = NULL
|
|
, @p61 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 47
|
|
CREATE PROCEDURE [dbo].[game_item_etc_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 48
|
|
CREATE PROCEDURE [dbo].[game_item_etc_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
|
|
, @p57 int = NULL
|
|
, @p58 int = NULL
|
|
, @p59 int = NULL
|
|
, @p60 int = NULL
|
|
, @p61 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 49
|
|
CREATE PROCEDURE [dbo].[game_item_extra_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 smallint = NULL
|
|
, @p10 datetime = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 smallint = NULL
|
|
, @p19 datetime = NULL
|
|
, @p20 int = NULL
|
|
, @p21 int = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 int = NULL
|
|
, @p26 int = NULL
|
|
, @p27 smallint = NULL
|
|
, @p28 datetime = NULL
|
|
, @p29 int = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 int = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 smallint = NULL
|
|
, @p37 datetime = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 int = NULL
|
|
, @p42 int = NULL
|
|
, @p43 int = NULL
|
|
, @p44 int = NULL
|
|
, @p45 smallint = NULL
|
|
, @p46 datetime = NULL
|
|
, @p47 int = NULL
|
|
, @p48 int = NULL
|
|
, @p49 int = NULL
|
|
, @p50 int = NULL
|
|
, @p51 int = NULL
|
|
, @p52 int = NULL
|
|
, @p53 int = NULL
|
|
, @p54 smallint = NULL
|
|
, @p55 datetime = NULL
|
|
, @p56 int = NULL
|
|
, @p57 int = NULL
|
|
, @p58 int = NULL
|
|
, @p59 int = NULL
|
|
, @p60 int = NULL
|
|
, @p61 int = NULL
|
|
, @p62 int = NULL
|
|
, @p63 smallint = NULL
|
|
, @p64 datetime = NULL
|
|
, @p65 int = NULL
|
|
, @p66 int = NULL
|
|
, @p67 int = NULL
|
|
, @p68 int = NULL
|
|
, @p69 int = NULL
|
|
, @p70 int = NULL
|
|
, @p71 int = NULL
|
|
, @p72 smallint = NULL
|
|
, @p73 datetime = NULL
|
|
, @p74 int = NULL
|
|
, @p75 int = NULL
|
|
, @p76 int = NULL
|
|
, @p77 int = NULL
|
|
, @p78 int = NULL
|
|
, @p79 int = NULL
|
|
, @p80 int = NULL
|
|
, @p81 smallint = NULL
|
|
, @p82 datetime = NULL
|
|
, @p83 int = NULL
|
|
, @p84 int = NULL
|
|
, @p85 int = NULL
|
|
, @p86 int = NULL
|
|
, @p87 int = NULL
|
|
, @p88 int = NULL
|
|
, @p89 int = NULL
|
|
, @p90 smallint = NULL
|
|
, @p91 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 50
|
|
CREATE PROCEDURE [dbo].[game_item_extra_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 51
|
|
CREATE PROCEDURE [dbo].[game_item_extra_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 smallint = NULL
|
|
, @p10 datetime = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 smallint = NULL
|
|
, @p19 datetime = NULL
|
|
, @p20 int = NULL
|
|
, @p21 int = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 int = NULL
|
|
, @p26 int = NULL
|
|
, @p27 smallint = NULL
|
|
, @p28 datetime = NULL
|
|
, @p29 int = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 int = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 smallint = NULL
|
|
, @p37 datetime = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 int = NULL
|
|
, @p42 int = NULL
|
|
, @p43 int = NULL
|
|
, @p44 int = NULL
|
|
, @p45 smallint = NULL
|
|
, @p46 datetime = NULL
|
|
, @p47 int = NULL
|
|
, @p48 int = NULL
|
|
, @p49 int = NULL
|
|
, @p50 int = NULL
|
|
, @p51 int = NULL
|
|
, @p52 int = NULL
|
|
, @p53 int = NULL
|
|
, @p54 smallint = NULL
|
|
, @p55 datetime = NULL
|
|
, @p56 int = NULL
|
|
, @p57 int = NULL
|
|
, @p58 int = NULL
|
|
, @p59 int = NULL
|
|
, @p60 int = NULL
|
|
, @p61 int = NULL
|
|
, @p62 int = NULL
|
|
, @p63 smallint = NULL
|
|
, @p64 datetime = NULL
|
|
, @p65 int = NULL
|
|
, @p66 int = NULL
|
|
, @p67 int = NULL
|
|
, @p68 int = NULL
|
|
, @p69 int = NULL
|
|
, @p70 int = NULL
|
|
, @p71 int = NULL
|
|
, @p72 smallint = NULL
|
|
, @p73 datetime = NULL
|
|
, @p74 int = NULL
|
|
, @p75 int = NULL
|
|
, @p76 int = NULL
|
|
, @p77 int = NULL
|
|
, @p78 int = NULL
|
|
, @p79 int = NULL
|
|
, @p80 int = NULL
|
|
, @p81 smallint = NULL
|
|
, @p82 datetime = NULL
|
|
, @p83 int = NULL
|
|
, @p84 int = NULL
|
|
, @p85 int = NULL
|
|
, @p86 int = NULL
|
|
, @p87 int = NULL
|
|
, @p88 int = NULL
|
|
, @p89 int = NULL
|
|
, @p90 smallint = NULL
|
|
, @p91 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 52
|
|
CREATE PROCEDURE [dbo].[game_award_level_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 53
|
|
CREATE PROCEDURE [dbo].[game_award_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
|
|
, @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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 54
|
|
CREATE PROCEDURE [dbo].[game_award_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 55
|
|
CREATE PROCEDURE [dbo].[game_award_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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 56
|
|
CREATE PROCEDURE [dbo].[game_ability_add]
|
|
(
|
|
@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 int = NULL
|
|
, @p12 datetime = NULL
|
|
, @p13 int = 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 int = NULL
|
|
, @p23 datetime = NULL
|
|
, @p24 int = 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 int = NULL
|
|
, @p34 datetime = NULL
|
|
, @p35 int = NULL
|
|
, @p36 tinyint = NULL
|
|
, @p37 tinyint = NULL
|
|
, @p38 tinyint = NULL
|
|
, @p39 tinyint = NULL
|
|
, @p40 tinyint = NULL
|
|
, @p41 tinyint = NULL
|
|
, @p42 tinyint = NULL
|
|
, @p43 tinyint = NULL
|
|
, @p44 int = NULL
|
|
, @p45 datetime = NULL
|
|
, @p46 int = NULL
|
|
, @p47 tinyint = NULL
|
|
, @p48 tinyint = NULL
|
|
, @p49 tinyint = NULL
|
|
, @p50 tinyint = NULL
|
|
, @p51 tinyint = NULL
|
|
, @p52 tinyint = NULL
|
|
, @p53 tinyint = NULL
|
|
, @p54 tinyint = NULL
|
|
, @p55 int = NULL
|
|
, @p56 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 57
|
|
CREATE PROCEDURE [dbo].[game_ability_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 58
|
|
CREATE PROCEDURE [dbo].[game_ability_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 int = NULL
|
|
, @p12 datetime = NULL
|
|
, @p13 int = 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 int = NULL
|
|
, @p23 datetime = NULL
|
|
, @p24 int = 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 int = NULL
|
|
, @p34 datetime = NULL
|
|
, @p35 int = NULL
|
|
, @p36 tinyint = NULL
|
|
, @p37 tinyint = NULL
|
|
, @p38 tinyint = NULL
|
|
, @p39 tinyint = NULL
|
|
, @p40 tinyint = NULL
|
|
, @p41 tinyint = NULL
|
|
, @p42 tinyint = NULL
|
|
, @p43 tinyint = NULL
|
|
, @p44 int = NULL
|
|
, @p45 datetime = NULL
|
|
, @p46 int = NULL
|
|
, @p47 tinyint = NULL
|
|
, @p48 tinyint = NULL
|
|
, @p49 tinyint = NULL
|
|
, @p50 tinyint = NULL
|
|
, @p51 tinyint = NULL
|
|
, @p52 tinyint = NULL
|
|
, @p53 tinyint = NULL
|
|
, @p54 tinyint = NULL
|
|
, @p55 int = NULL
|
|
, @p56 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 59
|
|
CREATE PROCEDURE [dbo].[game_fish_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 int = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 int = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 int = NULL
|
|
, @p14 tinyint = NULL
|
|
, @p15 int = NULL
|
|
, @p16 tinyint = NULL
|
|
, @p17 int = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 int = NULL
|
|
, @p20 tinyint = NULL
|
|
, @p21 int = NULL
|
|
, @p22 tinyint = NULL
|
|
, @p23 int = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 int = NULL
|
|
, @p26 tinyint = NULL
|
|
, @p27 int = NULL
|
|
, @p28 tinyint = NULL
|
|
, @p29 int = NULL
|
|
, @p30 tinyint = NULL
|
|
, @p31 int = NULL
|
|
, @p32 tinyint = NULL
|
|
, @p33 int = NULL
|
|
, @p34 tinyint = NULL
|
|
, @p35 int = NULL
|
|
, @p36 tinyint = NULL
|
|
, @p37 int = NULL
|
|
, @p38 tinyint = NULL
|
|
, @p39 int = NULL
|
|
, @p40 tinyint = NULL
|
|
, @p41 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 60
|
|
CREATE PROCEDURE [dbo].[game_fish_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 61
|
|
CREATE PROCEDURE [dbo].[game_fish_get_data_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 62
|
|
CREATE PROCEDURE [dbo].[game_fish_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 tinyint = NULL
|
|
, @p3 int = NULL
|
|
, @p4 tinyint = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 tinyint = NULL
|
|
, @p9 int = NULL
|
|
, @p10 tinyint = NULL
|
|
, @p11 int = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 int = NULL
|
|
, @p14 tinyint = NULL
|
|
, @p15 int = NULL
|
|
, @p16 tinyint = NULL
|
|
, @p17 int = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 int = NULL
|
|
, @p20 tinyint = NULL
|
|
, @p21 int = NULL
|
|
, @p22 tinyint = NULL
|
|
, @p23 int = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 int = NULL
|
|
, @p26 tinyint = NULL
|
|
, @p27 int = NULL
|
|
, @p28 tinyint = NULL
|
|
, @p29 int = NULL
|
|
, @p30 tinyint = NULL
|
|
, @p31 int = NULL
|
|
, @p32 tinyint = NULL
|
|
, @p33 int = NULL
|
|
, @p34 tinyint = NULL
|
|
, @p35 int = NULL
|
|
, @p36 tinyint = NULL
|
|
, @p37 int = NULL
|
|
, @p38 tinyint = NULL
|
|
, @p39 int = NULL
|
|
, @p40 tinyint = NULL
|
|
, @p41 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 63
|
|
CREATE PROCEDURE [dbo].[game_friend_list_asc]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 64
|
|
CREATE PROCEDURE [dbo].[game_friend_join_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 65
|
|
CREATE PROCEDURE [dbo].[game_friend_join_in]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 66
|
|
CREATE PROCEDURE [dbo].[game_friend_check_member]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 67
|
|
CREATE PROCEDURE [dbo].[game_friend_join_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 68
|
|
CREATE PROCEDURE [dbo].[game_friend_join_app]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 69
|
|
CREATE PROCEDURE [dbo].[game_friend_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 70
|
|
CREATE PROCEDURE [dbo].[game_friend_dev_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 71
|
|
CREATE PROCEDURE [dbo].[game_friend_best_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 72
|
|
CREATE PROCEDURE [dbo].[game_friend_best_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 73
|
|
CREATE PROCEDURE [dbo].[game_friend_best_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 74
|
|
CREATE PROCEDURE [dbo].[game_friend_best_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 75
|
|
CREATE PROCEDURE [dbo].[game_friend_best_add_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 76
|
|
CREATE PROCEDURE [dbo].[game_record_battle_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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 77
|
|
CREATE PROCEDURE [dbo].[game_quest_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
|
|
, @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
|
|
, @p57 int = NULL
|
|
, @p58 int = NULL
|
|
, @p59 int = NULL
|
|
, @p60 int = NULL
|
|
, @p61 int = NULL
|
|
, @p62 int = NULL
|
|
, @p63 int = NULL
|
|
, @p64 int = NULL
|
|
, @p65 int = NULL
|
|
, @p66 int = NULL
|
|
, @p67 int = NULL
|
|
, @p68 int = NULL
|
|
, @p69 int = NULL
|
|
, @p70 int = NULL
|
|
, @p71 int = NULL
|
|
, @p72 int = NULL
|
|
, @p73 int = NULL
|
|
, @p74 int = NULL
|
|
, @p75 int = NULL
|
|
, @p76 int = NULL
|
|
, @p77 int = NULL
|
|
, @p78 int = NULL
|
|
, @p79 int = NULL
|
|
, @p80 int = NULL
|
|
, @p81 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 78
|
|
CREATE PROCEDURE [dbo].[game_quest_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 79
|
|
CREATE PROCEDURE [dbo].[game_quest_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
|
|
, @p57 int = NULL
|
|
, @p58 int = NULL
|
|
, @p59 int = NULL
|
|
, @p60 int = NULL
|
|
, @p61 int = NULL
|
|
, @p62 int = NULL
|
|
, @p63 int = NULL
|
|
, @p64 int = NULL
|
|
, @p65 int = NULL
|
|
, @p66 int = NULL
|
|
, @p67 int = NULL
|
|
, @p68 int = NULL
|
|
, @p69 int = NULL
|
|
, @p70 int = NULL
|
|
, @p71 int = NULL
|
|
, @p72 int = NULL
|
|
, @p73 int = NULL
|
|
, @p74 int = NULL
|
|
, @p75 int = NULL
|
|
, @p76 int = NULL
|
|
, @p77 int = NULL
|
|
, @p78 int = NULL
|
|
, @p79 int = NULL
|
|
, @p80 int = NULL
|
|
, @p81 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 80
|
|
CREATE PROCEDURE [dbo].[game_quest_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 81
|
|
CREATE PROCEDURE [dbo].[game_questcomplete_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
|
|
, @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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 82
|
|
CREATE PROCEDURE [dbo].[game_questcomplete_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 83
|
|
CREATE PROCEDURE [dbo].[game_questcomplete_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
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 84
|
|
CREATE PROCEDURE [dbo].[game_quest_board_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 85
|
|
CREATE PROCEDURE [dbo].[game_fame_give_point]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = 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 varchar(1024) = NULL
|
|
, @p13 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 86
|
|
CREATE PROCEDURE [dbo].[game_event_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 87
|
|
CREATE PROCEDURE [dbo].[game_event_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 88
|
|
CREATE PROCEDURE [dbo].[game_event_get_createIDX]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 89
|
|
CREATE PROCEDURE [dbo].[game_event_openbeta_coin_log]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 90
|
|
CREATE PROCEDURE [dbo].[game_guild_use_item]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 91
|
|
CREATE PROCEDURE [dbo].[game_guild_create_guild]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 varchar(1024) = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 92
|
|
CREATE PROCEDURE [dbo].[game_guild_user_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 93
|
|
CREATE PROCEDURE [dbo].[game_guild_login_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 94
|
|
CREATE PROCEDURE [dbo].[game_guild_fail_add_peso]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 96
|
|
CREATE PROCEDURE [dbo].[game_guild_join_my_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 97
|
|
CREATE PROCEDURE [dbo].[game_guild_join_self_init]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 98
|
|
CREATE PROCEDURE [dbo].[game_guild_member_out_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 99
|
|
CREATE PROCEDURE [dbo].[game_guild_msg_init]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 100
|
|
CREATE PROCEDURE [dbo].[game_guild_join_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 101
|
|
CREATE PROCEDURE [dbo].[game_guild_member_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 102
|
|
CREATE PROCEDURE [dbo].[game_guild_member_get_list2]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 103
|
|
CREATE PROCEDURE [dbo].[game_guild_member_get_list3]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 104
|
|
CREATE PROCEDURE [dbo].[game_guild_intro_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 105
|
|
CREATE PROCEDURE [dbo].[game_guild_change_guildname]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 106
|
|
CREATE PROCEDURE [dbo].[game_guild_join_in]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 107
|
|
CREATE PROCEDURE [dbo].[game_guild_member_get_masters]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 108
|
|
CREATE PROCEDURE [dbo].[game_guild_join_self_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 109
|
|
CREATE PROCEDURE [dbo].[game_guild_join_app]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 110
|
|
CREATE PROCEDURE [dbo].[game_guild_join_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 112
|
|
CREATE PROCEDURE [dbo].[game_guild_member_self_out]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 113
|
|
CREATE PROCEDURE [dbo].[game_guild_change_master]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 114
|
|
CREATE PROCEDURE [dbo].[game_guild_position_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 115
|
|
CREATE PROCEDURE [dbo].[game_guild_member_out]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 116
|
|
CREATE PROCEDURE [dbo].[game_guild_user_nick_get_data]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 117
|
|
CREATE PROCEDURE [dbo].[game_guild_mark_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 118
|
|
CREATE PROCEDURE [dbo].[game_guild_mark_log_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 bigint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 119
|
|
CREATE PROCEDURE [dbo].[game_guild_mark_log_get_self_idx]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 120
|
|
CREATE PROCEDURE [dbo].[game_guild_mark_log_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 121
|
|
CREATE PROCEDURE [dbo].[game_get_ladderpoint]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 122
|
|
CREATE PROCEDURE [dbo].[game_region_get_compen]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 123
|
|
CREATE PROCEDURE [dbo].[game_region_compen_delete]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 varchar(1024) = NULL
|
|
, @p4 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 124
|
|
CREATE PROCEDURE [dbo].[game_present_add]
|
|
(
|
|
@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 125
|
|
CREATE PROCEDURE [dbo].[game_present_add_idx]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = 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
|
|
, @p11 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 126
|
|
CREATE PROCEDURE [dbo].[game_present_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 127
|
|
CREATE PROCEDURE [dbo].[game_present_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 128
|
|
CREATE PROCEDURE [dbo].[game_present_delete_all]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 129
|
|
CREATE PROCEDURE [dbo].[game_present_count]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 130
|
|
CREATE PROCEDURE [dbo].[game_member_namecheck_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 131
|
|
CREATE PROCEDURE [dbo].[game_member_get_count]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 132
|
|
CREATE PROCEDURE [dbo].[game_member_get_userNickname_count]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 133
|
|
CREATE PROCEDURE [dbo].[game_member_change_userNickname]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 varchar(1024) = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 varchar(1024) = NULL
|
|
, @p7 varchar(1024) = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 134
|
|
CREATE PROCEDURE [dbo].[game_get_nickname]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 135
|
|
CREATE PROCEDURE [dbo].[game_get_limitType]
|
|
(
|
|
@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 141
|
|
CREATE PROCEDURE [dbo].[game_config_keyboard_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 142
|
|
CREATE PROCEDURE [dbo].[game_item_medal_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 datetime = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 datetime = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 datetime = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 datetime = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 datetime = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 datetime = NULL
|
|
, @p26 int = NULL
|
|
, @p27 int = NULL
|
|
, @p28 int = NULL
|
|
, @p29 datetime = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 datetime = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 int = NULL
|
|
, @p37 datetime = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 143
|
|
CREATE PROCEDURE [dbo].[game_item_medal_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 144
|
|
CREATE PROCEDURE [dbo].[game_item_medal_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 datetime = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 datetime = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 int = NULL
|
|
, @p13 datetime = NULL
|
|
, @p14 int = NULL
|
|
, @p15 int = NULL
|
|
, @p16 int = NULL
|
|
, @p17 datetime = NULL
|
|
, @p18 int = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 datetime = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 int = NULL
|
|
, @p25 datetime = NULL
|
|
, @p26 int = NULL
|
|
, @p27 int = NULL
|
|
, @p28 int = NULL
|
|
, @p29 datetime = NULL
|
|
, @p30 int = NULL
|
|
, @p31 int = NULL
|
|
, @p32 int = NULL
|
|
, @p33 datetime = NULL
|
|
, @p34 int = NULL
|
|
, @p35 int = NULL
|
|
, @p36 int = NULL
|
|
, @p37 datetime = NULL
|
|
, @p38 int = NULL
|
|
, @p39 int = NULL
|
|
, @p40 int = NULL
|
|
, @p41 datetime = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 145
|
|
CREATE PROCEDURE [dbo].[game_item_medal_extend_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 tinyint = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 int = NULL
|
|
, @p26 int = NULL
|
|
, @p27 tinyint = NULL
|
|
, @p28 int = NULL
|
|
, @p29 int = NULL
|
|
, @p30 tinyint = NULL
|
|
, @p31 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 146
|
|
CREATE PROCEDURE [dbo].[game_item_medal_extend_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 147
|
|
CREATE PROCEDURE [dbo].[game_item_medal_extend_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 tinyint = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 tinyint = NULL
|
|
, @p7 int = NULL
|
|
, @p8 int = NULL
|
|
, @p9 tinyint = NULL
|
|
, @p10 int = NULL
|
|
, @p11 int = NULL
|
|
, @p12 tinyint = NULL
|
|
, @p13 int = NULL
|
|
, @p14 int = NULL
|
|
, @p15 tinyint = NULL
|
|
, @p16 int = NULL
|
|
, @p17 int = NULL
|
|
, @p18 tinyint = NULL
|
|
, @p19 int = NULL
|
|
, @p20 int = NULL
|
|
, @p21 tinyint = NULL
|
|
, @p22 int = NULL
|
|
, @p23 int = NULL
|
|
, @p24 tinyint = NULL
|
|
, @p25 int = NULL
|
|
, @p26 int = NULL
|
|
, @p27 tinyint = NULL
|
|
, @p28 int = NULL
|
|
, @p29 int = NULL
|
|
, @p30 tinyint = NULL
|
|
, @p31 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 148
|
|
CREATE PROCEDURE [dbo].[game_ranking_hero_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 149
|
|
CREATE PROCEDURE [dbo].[game_ranking_hero_topN]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 150
|
|
CREATE PROCEDURE [dbo].[game_item_extra_get_customidx]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 151
|
|
CREATE PROCEDURE [dbo].[game_trade_add]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 bigint = NULL
|
|
, @p6 int = NULL
|
|
, @p7 int = NULL
|
|
, @p8 varchar(1024) = NULL
|
|
, @p9 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 152
|
|
CREATE PROCEDURE [dbo].[game_trade_get_self_index]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 153
|
|
CREATE PROCEDURE [dbo].[game_trade_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 155
|
|
CREATE PROCEDURE [dbo].[game_log_class_buytime]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 156
|
|
CREATE PROCEDURE [dbo].[game_log_level_playtime]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 bigint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 157
|
|
CREATE PROCEDURE [dbo].[game_hq_get_count]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 158
|
|
CREATE PROCEDURE [dbo].[game_hq_add]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 159
|
|
CREATE PROCEDURE [dbo].[game_hq_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 160
|
|
CREATE PROCEDURE [dbo].[game_hq_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 smallint = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 161
|
|
CREATE PROCEDURE [dbo].[game_get_age_from_id]
|
|
(
|
|
@p1 varchar(1024) = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 162
|
|
CREATE PROCEDURE [dbo].[game_event_chuchun_get_data]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 163
|
|
CREATE PROCEDURE [dbo].[game_event_chuchun_save]
|
|
(
|
|
@p1 int = 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 166
|
|
CREATE PROCEDURE [dbo].[game_character_rentaltime_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = 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 2000
|
|
CREATE PROCEDURE [dbo].[game_server_add]
|
|
(
|
|
@p1 bigint = NULL
|
|
, @p2 varchar(1024) = NULL
|
|
, @p3 int = NULL
|
|
, @p4 varchar(1024) = NULL
|
|
, @p5 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2002
|
|
CREATE PROCEDURE [dbo].[game_member_total_count]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2003
|
|
CREATE PROCEDURE [dbo].[game_guild_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2004
|
|
CREATE PROCEDURE [dbo].[game_guild_join_init]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2005
|
|
CREATE PROCEDURE [dbo].[game_guild_delete]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2006
|
|
CREATE PROCEDURE [dbo].[game_guild_battle_record_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2007
|
|
CREATE PROCEDURE [dbo].[game_guild_ranking_point_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2008
|
|
CREATE PROCEDURE [dbo].[game_region_get_point]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2009
|
|
CREATE PROCEDURE [dbo].[game_region_save]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
, @p3 int = NULL
|
|
, @p4 int = NULL
|
|
, @p5 int = NULL
|
|
, @p6 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2010
|
|
CREATE PROCEDURE [dbo].[game_region_player_count]
|
|
(
|
|
@p1 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
GO
|
|
-- query 2011
|
|
CREATE PROCEDURE [dbo].[game_region_season_end_data_init]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2012
|
|
CREATE PROCEDURE [dbo].[game_region_season_end]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2013
|
|
CREATE PROCEDURE [dbo].[game_region_season_end_server_close]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2014
|
|
CREATE PROCEDURE [dbo].[game_region_backup_point]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2015
|
|
CREATE PROCEDURE [dbo].[game_region_backup_compen]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2016
|
|
CREATE PROCEDURE [dbo].[game_game_sexp_deduct_init]
|
|
AS
|
|
SET NOCOUNT ON;
|
|
RETURN 0;
|
|
GO
|
|
-- query 2017
|
|
CREATE PROCEDURE [dbo].[game_trade_get_list]
|
|
(
|
|
@p1 int = NULL
|
|
, @p2 int = NULL
|
|
)
|
|
AS
|
|
SET NOCOUNT ON;
|
|
SELECT TOP 0 0 AS stub;
|
|
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
|