LayerSro 100 Cap Balanced Game Database

USE [LAYERS_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 7/23/2015 8:59:55 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO


-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âÁ¸ ¾ÆÀÌÅÛ ·Î±× ÀÔ·Â Stored procedure ¼öÁ¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ðÀÔ
as
if @Operation = '16' and @ItemRefID between '136751' and '136754'
or @Operation = '16' and @ItemRefID between '136850' and '136853'
begin
exec [dbo].[_UpgradeSystem] @CharID , @Operation,@ItemRefID
end
if @Operation = '16' and @ItemRefID between '136858' and '136889' and @Operation = '16'
begin
exec SRO_VT_LOG.dbo._ITEM_EXCHANGE @CharID , @ItemRefID , @Operation end
if @Operation = '16' and @ItemRefID between '136890' and '136895' and @Operation = '16'
or @ItemRefID between '136937' and '136950'
begin
exec SRO_VT_LOG.[dbo].[_Titles] @CharID , @ItemRefID , @Operation end


if( @ItemRefID ='136896' and @Operation = '16') -- 50 immo !
Begin
Update SRO_VT_SHARD.dbo._Items set MagParamNum=1,MagParam1 = 0,MagParam2=0,MagParam3=0,MagParam4=0,MagParam5=0, MagParam6=0,MagParam7=0,MagParam8=0,MagParam9=0,Ma gParam10=0,MagParam11=0,MagParam12=0 where ID64 =
(select itemid from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID AND Slot = 13)
Update SRO_VT_SHARD.dbo._Items set MagParam1 = 214748364851 where ID64 =
(select itemid from SRO_VT_SHARD.dbo._Inventory where CharID = @CharID AND Slot = 13)

End
DECLARE @CharName varchar(65) = (Select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID)
if( @ItemRefID ='137036' and @Operation = '16') begin -- 50 immo !
DECLARE @Item_Code Varchar(256) = (Select top 1 CodeName from _SilkStone_Lot where ID between '1' and '9'
order by NEWID())
if @CharName not like '%G%]%'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code,1,0 end end

if( @ItemRefID ='137035' and @Operation = '16') begin -- 50 immo !
DECLARE @Item_Code1 Varchar(256) = (Select top 1 CodeName from _SilkStone_Lot where ID between '11' and '40'
order by NEWID())
if @CharName not like '%G%]%'
begin
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName,@Item_Code1,100,0 end end
if( @ItemRefID ='137034' and @Operation = '16') begin -- 50 immo !
DECLARE @Upper_Gold INT = '150000000', @Lower_Gold INT = '30000000'
DECLARE @Random_Gold INT = ROUND(((@Upper_GOLD - @Lower_GOLD -1) * RAND() + @Lower_GOLD), 0);

Update SRO_VT_SHARD.dbo._Char set RemainGold = RemainGold + @Random_Gold where CharID = @CharID end

If @ItemRefID = '137032' and @Operation = '16' begin delete from SRO_VT_SHARd.dbo._TimedJob where JobID = '1' and CharID = @CharID end
If @ItemRefID = '137033' and @Operation = '16' begin delete from SRO_VT_SHARd.dbo._TimedJob where JobID = '2' and CharID = @CharID end
If @ItemRefID = '137031' and @Operation = '16' begin delete from SRO_VT_SHARd.dbo._TimedJob where JobID = '136857' and CharID = @CharID
or JobID = '33789' and CharID = @CharID or JobID = '9278' and CharID = @CharID or JobID = '35567' and CharID = @CharID or JobID = '5412' and CharID = @CharID
or JobID = '9277' and CharID = @CharID or JobID = '9278' and CharID = @CharID or JobID = '5412' and CharID = @CharID or JobID = '33839' and CharID = @CharID
end
DECLARE @JID int = (select JID from SRO_VT_ACCOUNT.dbo.SK_Silk as asilk inner join SRO_VT_SHARD.dbo._User
as sjid On asilk.JID = sjid.UserJID where sjid.CharID = @CharID)
if @ItemRefID = '137015' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '20' where JID = @JID end
if @ItemRefID = '137016' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '20' where JID = @JID end
if @ItemRefID = '137017' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '23' where JID = @JID end
if @ItemRefID = '137018' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '25' where JID = @JID end
if @ItemRefID = '137019' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '28' where JID = @JID end
if @ItemRefID = '137020' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '30' where JID = @JID end
if @ItemRefID = '137021' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '33' where JID = @JID end
if @ItemRefID = '137022' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '38' where JID = @JID end
if @ItemRefID = '137023' and @Operation = '16' begin Update SRO_VT_ACCOUNT.dbo.SK_Silk
set silk_own = silk_own + '35' where JID = @JID end
IF @ItemRefID = '136952' and @Operation = '16'
and Exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID and JobType ='0') begin
update SRO_VT_Shard.dbo._CharTrijob set JobType = '2' where CharID = @CharID end
IF @ItemRefID = '136953' and @Operation = '16'
and Exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID and JobType ='0') begin
update SRO_VT_Shard.dbo._CharTrijob set JobType = '3' where CharID = @CharID end
IF @ItemRefID = '136954' and @Operation = '16'
and Exists (Select * from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID and JobType ='0') begin
update SRO_VT_Shard.dbo._CharTrijob set JobType = '1' where CharID = @CharID end
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
return -1
end
else if (@len_pos > 0 and @len_desc = 0)
begin
return -1
end
else if (@len_pos = 0 and @len_desc > 0)
begin
return -1
end
else if (@len_pos = 0 and @len_desc = 0)
begin
return -1
end
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
return -1
end