مشكله SR_GameServer

[joesuef]

لما بستعمل سكرول المستري بيجبلي كده ف جيم سرفر و سكرول ما بتعملش حاجه ؟؟

Done Fixed and Scroll now Work fine =)

[MORJANA]

انت عدلت رقم الـID في البروسيدر بتاع الـ ADDLOOGITEM بتاع السكرول ؟
هات رقم الاي دي بتاع السكرول من الـrefobjcomon حطه بدل الرقم بتاع السكرول اللي في البروسيدر

[joesuef]

المشاركة الأصلية كتبت بواسطة MORJANA عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

انت عدلت رقم الـID في البروسيدر بتاع الـ ADDLOOGITEM بتاع السكرول ؟
هات رقم الاي دي بتاع السكرول من الـrefobjcomon حطه بدل الرقم بتاع السكرول اللي في البروسيدر

معدل نفس الرقم ال في refobjcommon هوا ف البروسيدر

[joesuef]

--------------------------Procedure--------------------------

USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 4/3/2017 3:38:54 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
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
declare @len_pos int
declare @len_desc int
declare @strDesc_separado varchar(128)
declare @len_desc1 int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³Ã¼
end
-- À¯·á ¾ÆÀÌÅÛ ±¸ÀÔÀ̸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
if (@Operation = 90 OR @Operation = 160)
begin
set @len_desc1 = CHARINDEX (']',@strDesc)
if(@len_desc1 = 9)
begin
set @strDesc = SUBSTRING(@strDesc,0,9)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 1)
end
else if(@len_desc1 = 10)
begin
set @strDesc = SUBSTRING(@strDesc,0,10)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 2)
end
if(@strDesc_separado >= 8)
begin
--set @strDesc_separado = @len_desc1
insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')
end
end
if(@Operation = 90)
begin
declare @iname varchar(129)
declare @iid int
declare @cname varchar(64)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
select @iname = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid
select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
if @strDesc_separado >= 7
begin
if @iname like 'ITEM_CH_%'
begin
set @iname = REPLACE(@iname,'ITEM_CH_','')
print @iname
end
if @iname like 'ITEM_EU_%'
begin
set @iname = REPLACE(@iname,'ITEM_EU_','')
print @iname
end
if @iname like '%_A_RARE'
begin
set @iname = REPLACE(@iname,'_A_RARE',' (Seal Of Star)')
print @iname
end
if @iname like '%_B_RARE'
begin
set @iname = REPLACE(@iname,'_B_RARE',' (Seal Of Moon)')
print @iname
end
if @iname like '%_C_RARE'
begin
set @iname = REPLACE(@iname,'_C_RARE',' (Seal Of Sun)')
print @iname
end
if @iname like '%_C'
begin
set @iname = REPLACE(@iname,'_C','')
print @iname
end
if @iname like '%_A'
begin
set @iname = REPLACE(@iname,'_A','')
print @iname
end
if @iname like '%_B'
begin
set @iname = REPLACE(@iname,'_B','')
print @iname
end

insert PlusNotice(Sent, Message)values(0,' Player ['+@cname + '] has increased [' + @iname + '] to [Plus ' + CAST(@strDesc_separado AS NVARCHAR) + ']')
end
end
--JOBWAR
DECLARE @JobLevel int = (select [Level] from SRO_VT_SHARD.dbo._CharTrijob where CharID = @CharID)
DECLARE @UserJID int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = @CharID)
if @ItemRefID = '47108' and @Operation ='41' -- scrolls de cosas
begin
if (@JobLevel >= 4)
begin
update SRO_VT_SHARD.dbo._CharTrijob set [Level] = 1 , Exp = 1,Contribution=1 where CharID = @CharID
if exists (select JID from SRO_VT_ACCOUNT.dbo.SK_Silk where JID = @UserJID)
begin
update SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = 2+silk_own where JID = @UserJID
insert into SRO_VT_SHARDLOG.dbo.Auto_Equipment_Checks (CharID,ItemLevel,Reload)Values(@CharID,'JobRestFo rSilks','No')
end
else
begin
insert into SRO_VT_ACCOUNT.dbo.SK_Silk(JID, silk_own,silk_gift,silk_point)values (@UserJID , 2,0,0);
insert into SRO_VT_SHARDLOG.dbo.Auto_Equipment_Checks (CharID,ItemLevel,Reload)Values(@CharID,'JobRestFo rSilks','No')
end
end
end


if @ItemRefID = '47074' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel2 varchar(64)
Select @Hwanlevel2=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 25 Where CharID = @CharID
End
if @ItemRefID = '47075' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel3 varchar(64)
Select @Hwanlevel3=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 26 Where CharID = @CharID
End
if @ItemRefID = '47076' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel4 varchar(64)
Select @Hwanlevel4=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 27 Where CharID = @CharID
End
if @ItemRefID = '47077' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel5 varchar(64)
Select @Hwanlevel5=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 28 Where CharID = @CharID
End
if @ItemRefID = '47078' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel6 varchar(64)
Select @Hwanlevel6=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 29 Where CharID = @CharID
End
if @ItemRefID = '47079' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel7 varchar(64)
Select @Hwanlevel7=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 30 Where CharID = @CharID
End
if @ItemRefID = '47080' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel8 varchar(64)
Select @Hwanlevel8=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 31 Where CharID = @CharID
End
if @ItemRefID = '47081' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel9 varchar(64)
Select @Hwanlevel9=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 32 Where CharID = @CharID
End
if @ItemRefID = '47082' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel10 varchar(64)
Select @Hwanlevel10=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 33 Where CharID = @CharID
End
if @ItemRefID = '47083' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel11 varchar(64)
Select @Hwanlevel11=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 34 Where CharID = @CharID
End
if @ItemRefID = '47084' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel12 varchar(64)
Select @Hwanlevel12=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 35 Where CharID = @CharID
End
if @ItemRefID = '47085' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel13 varchar(64)
Select @Hwanlevel13=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 36 Where CharID = @CharID
End
if @ItemRefID = '47086' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel14 varchar(64)
Select @Hwanlevel14=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 37 Where CharID = @CharID
End
if @ItemRefID = '47087' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel15 varchar(64)
Select @Hwanlevel15=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 38 Where CharID = @CharID
End
if @ItemRefID = '47088' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel16 varchar(64)
Select @Hwanlevel16=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 39 Where CharID = @CharID
End
if @ItemRefID = '47089' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel17 varchar(64)
Select @Hwanlevel17=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 40 Where CharID = @CharID
End
if @ItemRefID = '47090' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel18 varchar(64)
Select @Hwanlevel18=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 41 Where CharID = @CharID
End
if @ItemRefID = '47091' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel19 varchar(64)
Select @Hwanlevel19=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 42 Where CharID = @CharID
End

if @ItemRefID = '47092' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel20 varchar(64)
Select @Hwanlevel20=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 43 Where CharID = @CharID
End
if @ItemRefID = '47093' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel21 varchar(64)
Select @Hwanlevel21=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 44 Where CharID = @CharID
End
if @ItemRefID = '47094' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel22 varchar(64)
Select @Hwanlevel22=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 45 Where CharID = @CharID
End
if @ItemRefID = '47095' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel23 varchar(64)
Select @Hwanlevel23=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 46 Where CharID = @CharID
End
if @ItemRefID = '47096' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel24 varchar(64)
Select @Hwanlevel24=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 47 Where CharID = @CharID
End
if @ItemRefID = '47097' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel25 varchar(64)
Select @Hwanlevel25=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 48 Where CharID = @CharID
End
if @ItemRefID = '47098' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel26 varchar(64)
Select @Hwanlevel26=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 49 Where CharID = @CharID
End
if @ItemRefID = '47099' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel27 varchar(64)
Select @Hwanlevel27=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 50 Where CharID = @CharID
End
if @ItemRefID = '47100' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel28 varchar(64)
Select @Hwanlevel28=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 51 Where CharID = @CharID
End
if @ItemRefID = '47101' and @Operation ='41' -- scrolls de cosas
BEGIN
declare @Hwanlevel29 varchar(64)
Select @Hwanlevel29=HwanLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
Update SRO_VT_SHARD.dbo._Char Set HwanLevel = 52 Where CharID = @CharID
End
if @ItemRefID = '47116' and @Operation ='41' -- scrolls de cosas
begin
DECLARE @OldItemCodeName varchar(128)
set @OldItemCodeName= 'ITEM_CH_BLADE_11_SET_A_RARE'
DECLARE @OldItemPlus int
set @OldItemPlus =7
DECLARE @NewItemCodeName varchar(128)
set @NewItemCodeName = ('ITEM_CH_BLADE_11_SET_B_RARE')
DECLARE @NewItemPlus int
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
declare @charName16 varchar (128)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 = CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
if @ItemRefID = '47138' and @Operation ='41' -- scrolls de cosas
begin
DECLARE @OldItemCodeName1 varchar(128)
set @OldItemCodeName1= 'ITEM_CH_BOW_11_SET_A_RARE'
DECLARE @OldItemPlus1 int
set @OldItemPlus1 =7
DECLARE @NewItemCodeName1 varchar(128)
set @NewItemCodeName1 = ('ITEM_CH_BOW_11_SET_B_RARE')
DECLARE @NewItemPlus1 int
set @NewItemPlus1 = 0
DECLARE @ReplaceID1 int
SET @REPLACEID1 = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID1 > 0)
begin
declare @charName17 varchar (128)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName17 = CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
if @ItemRefID = '47139' and @Operation ='41' -- scrolls de cosas
begin
DECLARE @OldItemCodeName2 varchar(128)
set @OldItemCodeName2= 'ITEM_CH_TBLADE_11_SET_A_RARE'
DECLARE @OldItemPlus2 int
set @OldItemPlus2 =7
DECLARE @NewItemCodeName2 varchar(128)
set @NewItemCodeName2 = ('ITEM_CH_TBLADE_11_SET_B_RARE')
DECLARE @NewItemPlus2 int
set @NewItemPlus2 = 0
DECLARE @ReplaceID2 int
SET @REPLACEID2 = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID2 > 0)
begin
declare @charName18 varchar (128)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName18 = CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
if @ItemRefID = '47140' and @Operation ='41' -- scrolls de cosas
begin
DECLARE @OldItemCodeName3 varchar(128)
set @OldItemCodeName3= 'ITEM_CH_SHIELD_11_SET_A_RARE'
DECLARE @OldItemPlus3 int
set @OldItemPlus3 =7
DECLARE @NewItemCodeName3 varchar(128)
set @NewItemCodeName3 = ('ITEM_CH_SHIELD_11_SET_B_RARE')
DECLARE @NewItemPlus3 int
set @NewItemPlus3 = 0
DECLARE @ReplaceID3 int
SET @REPLACEID3 = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID3 > 0)
begin
declare @charName19 varchar (128)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName19 = CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
if @ItemRefID = '47141' and @Operation ='41' -- scrolls de cosas
begin
DECLARE @OldItemCodeName4 varchar(128)
set @OldItemCodeName4= 'ITEM_CH_SPEAR_11_SET_A_RARE'
DECLARE @OldItemPlus4 int
set @OldItemPlus4 =7
DECLARE @NewItemCodeName4 varchar(128)
set @NewItemCodeName4 = ('ITEM_CH_SPEAR_11_SET_B_RARE')
DECLARE @NewItemPlus4 int
set @NewItemPlus4 = 0
DECLARE @ReplaceID4 int
SET @REPLACEID4 = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID4 > 0)
begin
declare @charName20 varchar (128)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName20 = CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end
if @ItemRefID = '47142' and @Operation ='41' -- scrolls de cosas
begin
DECLARE @OldItemCodeName5 varchar(128)
set @OldItemCodeName5= 'ITEM_CH_SWORD_11_SET_A_RARE'
DECLARE @OldItemPlus5 int
set @OldItemPlus5 =7
DECLARE @NewItemCodeName5 varchar(128)
set @NewItemCodeName5 = ('ITEM_CH_SWORD_11_SET_B_RARE')
DECLARE @NewItemPlus5 int
set @NewItemPlus5 = 0
DECLARE @ReplaceID5 int
SET @REPLACEID5 = (select top 1 ItemID from SRO_VT_SHARD.dbo._Inventory as inv inner join SRO_VT_SHARD.dbo._Items as itm on inv.ItemID = itm.ID64 inner join SRO_VT_SHARD.dbo._RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID5 > 0)
begin
declare @charName21 varchar (128)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName21 = CharName16 from SRO_VT_SHARD.dbo._Char where CharID=@CharID
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
end

IF (@Operation = 41) -- scroll is used
BEGIN
IF (@ItemRefID = 47143) -- Auto-equipment
BEGIN
DECLARE @CharNameEQ VARCHAR(64) = (SELECT CharName16 from [SRO_VT_SHARD].[dbo].[_Char] WHERE CharID = @CharID)
EXEC [SRO_VT_SHARD].[dbo].[_ADD_AUTOEQUIP_GEAR] @CharNameEQ, 7
END
END
declare @USERID_2 varchar(64);
SET @USERID_2 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47111' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_2, @PkgID = NULL, @NumSilk = 50, @Price = 50
END
declare @USERID_3 varchar(64);
SET @USERID_3 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47117' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_3, @PkgID = NULL, @NumSilk = 100, @Price = 100
END
declare @USERID_4 varchar(64);
SET @USERID_4 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47118' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_4, @PkgID = NULL, @NumSilk = 200, @Price = 200
END
declare @USERID_5 varchar(64);
SET @USERID_5 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47119' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_5, @PkgID = NULL, @NumSilk = 300, @Price = 300
END
declare @USERID_6 varchar(64);
SET @USERID_6 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47120' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_6, @PkgID = NULL, @NumSilk = 400, @Price = 400
END
declare @USERID_7 varchar(64);
SET @USERID_7 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47121' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_7, @PkgID = NULL, @NumSilk = 500, @Price = 500
END
declare @USERID_8 varchar(64);
SET @USERID_8 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47144' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_8, @PkgID = NULL, @NumSilk = 600, @Price = 600
END
declare @USERID_9 varchar(64);
SET @USERID_9 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47145' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_9, @PkgID = NULL, @NumSilk = 700, @Price = 700
END
declare @USERID_10 varchar(64);
SET @USERID_10 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47146' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_10, @PkgID = NULL, @NumSilk = 800, @Price = 800
END
declare @USERID_11 varchar(64);
SET @USERID_11 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47147' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_11, @PkgID = NULL, @NumSilk = 900, @Price = 900
END
declare @USERID_12 varchar(64);
SET @USERID_12 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47148' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_12, @PkgID = NULL, @NumSilk = 1000, @Price = 1000
END
declare @USERID_13 varchar(64);
SET @USERID_13 = (Select StrUserID from SRO_VT_ACCOUNT.dbo.TB_User inner join sro_vt_shard.dbo._User
On SRO_VT_SHARD.dbo._User.UserJID = SRO_VT_ACCOUNT.dbo.TB_User.JID where SRO_VT_SHARD.dbo._User.CharID = @Charid)
if @ItemRefID = '47149' and @Operation ='41' -- scrolls de cosas
begin
--1--
EXEC [SRO_VT_ACCOUNT].[CGI].[CGI_WebPurchaseSilk] @OrderID = NULL, @UserID = @USERID_13, @PkgID = NULL, @NumSilk = 1, @Price = 1
END
declare @azar INT
declare @randomfile varchar(50)
declare @veremos varchar(50)
SELECT top 1 @azar = (ABS(CHECKSUM(NEWID())) % 10000) FROM Master.dbo.Syscolumns
select @randomfile = 'C:\MSSQLTips\' + convert(varchar, @azar) + '.txt'
SELECT dbo.WriteTextFile(@veremos, @randomfile, 0)
if @ItemRefID = '47150' and @Operation ='41' -- scrolls Tread
begin
update SRO_VT_SHARD.dbo._CharTrijob set [Level] = 1 , Exp = 1,Contribution=1 ,JobType =1 where CharID = @CharID
End
if @ItemRefID = '47151' and @Operation ='41' -- scrolls Hunter
begin
update SRO_VT_SHARD.dbo._CharTrijob set [Level] = 1 , Exp = 1,Contribution=1 ,JobType =3 where CharID = @CharID
End
if @ItemRefID = '47152' and @Operation ='41' -- scrolls thife
begin
update SRO_VT_SHARD.dbo._CharTrijob set [Level] = 1 , Exp = 1,Contribution=1 ,JobType =2 where CharID = @CharID
End
IF (@Operation = 90 AND @strDesc like '%Opt: +9%') BEGIN UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 8 WHERE Serial64 = @ItemSerial END
IF (@Operation=41 AND @ItemRefID BETWEEN 41932 AND 41937) ---------------- European Mastery Scrolls -------------------
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='513')
BEGIN
DECLARE @Wizard INT,@Warrior INT,@Rouge INT,@Warlock INT,@Bard INT,@Cleric INT
SELECT @Wizard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='514'
SELECT @Warrior=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='513'
SELECT @Rouge=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='515'
SELECT @Warlock=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='516'
SELECT @Bard=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='517'
SELECT @Cleric=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='518'
IF (@Wizard+@Warrior+@Rouge+@Warlock+@Bard+@Cleric<=' 110')
BEGIN
DECLARE @EuropeanMasteryType INT;
SET @EuropeanMasteryType = CASE
WHEN @ItemRefID=41932 --------------- Wizard
THEN 514
WHEN @ItemRefID=41933 --------------- Warrior
THEN 513
WHEN @ItemRefID=41934 --------------- Rouge
THEN 515
WHEN @ItemRefID=41935 --------------- Cleric
THEN 518
WHEN @ItemRefID=41936 --------------- Bard
THEN 517
WHEN @ItemRefID=41937 --------------- Warlock
THEN 516
END
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@EuropeanMasteryType
INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@EuropeanMasteryType
END
END
END
IF (@Operation=41 AND @ItemRefID BETWEEN 41925 AND 41931) ---------------- Chinese Mastery Scrolls -------------------
BEGIN
IF EXISTS (SELECT * FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE MasteryID='257')
BEGIN
DECLARE @Bicheon INT,@Heuksal INT,@Pacheon INT,@Cold INT,@Lightning INT,@Fire INT,@Force INT
SELECT @Bicheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='257'
SELECT @Heuksal=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='258'
SELECT @Pacheon=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='259'
SELECT @Cold=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='273'
SELECT @Lightning=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='274'
SELECT @Fire=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='275'
SELECT @Force=[Level] FROM SRO_VT_SHARD.dbo._CharSkillMastery WHERE CharID=@CharID AND MasteryID='276'
IF (@Bicheon+@Heuksal+@Pacheon+@Cold+@Lightning+@Fire +@Force <='220')
BEGIN
DECLARE @ChineseMasteryType INT;
SET @ChineseMasteryType = Case
WHEN @ItemRefID=41927 --------------- Bacheon
THEN 257
WHEN @ItemRefID=41926 --------------- Heuksal
THEN 258
WHEN @ItemRefID=41925 --------------- Pacheon
THEN 259
WHEN @ItemRefID=41930 --------------- Cold
THEN 273
WHEN @ItemRefID=41929 --------------- Lightning
THEN 274
WHEN @ItemRefID=41928 --------------- Fire
THEN 275
WHEN @ItemRefID=41931 --------------- Foce
THEN 276
END
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET [Level]='110' WHERE CharID=@CharID AND MasteryID=@ChineseMasteryType
INSERT SRO_VT_SHARD.dbo._CharSkill SELECT @CharID,SkillID,'1' FROM SRO_VT_SHARDLOG.dbo._CharacterSkills WHERE MasteryID=@ChineseMasteryType
END
END
END

[Mahmoud Rashwan]

هات الصورة واضحه

[joesuef]

المشاركة الأصلية كتبت بواسطة Mahmoud Rashwan عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

هات الصورة واضحه

خلاص يا باشا تسلم تم حل المشكله =)

[Mahmoud Rashwan]

نورتنا

[Mahmoud Rashwan]

##