طلب في vsro multi tool

[Mohamed ElKersh]

دلواقتي في اسكرولة انا عاوز اول ميضربها يكتبله في الشات تحت Succsecfly مثلا او اي حاجة انا اخترها
بمعني
انا دلواقتي اسكرولة Reset skills اول ميضربها و الاسكلات ترجع يكتبله تحت في الشات private يكتبله رسالة

زي كدة موضوع mastery skills لو حد جبلي الكويري ده هفرح اووي والله :] علشان محتاجه اووي

ديه مثلا اهم 3 كويرهات اسكرولات عاوز احطلهم السيستم ده اعمل ايه
ديه في addtimedjob
if(@JobID= '*****')
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(_RefSkill.ReqLearn_SP) FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130'
SELECT @TotalSPMastery = SUM(_RefLevel.Exp_M) FROM _CharSkillMastery, _RefLevel WHERE _RefLevel.Lvl=_CharSkillMastery.Level AND _CharSkillMastery.CharID=@CharID AND _CharSkillMastery.Level <= '130'
UPDATE _Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE _CharSkill FROM _RefSkill, _CharSkill WHERE _RefSkill.ID=_CharSkill.SkillID AND _CharSkill.CharID=@CharID AND _RefSkill.ReqCommon_MasteryLevel1 <= '130' AND _RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '110'
end

timed job
if(@JobID = '*****')
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from _Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE _Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
end

addlogitem
--Gender
IF (@Operation = 41) -- If item used!
Begin
IF (@ItemRefID = *****) -- RefObjCommon ID
Begin
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Declare @RefItemID INT = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,2 4412) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,2 4411) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
End
End
End

[Mohamed ElKersh]

رد

[HLP]

اتفضل
Scroll Skills recall
addlogitem
IF (@Operation = 41 and @ItemRefID = 42091) -- Scroll Skills recall
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(SRO_VT_SHARD.dbo._RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(SRO_VT_SHARD.dbo._RefLevel.Exp_M) FROM SRO_VT_SHARD.dbo._CharSkillMastery, SRO_VT_SHARD.dbo._RefLevel WHERE SRO_VT_SHARD.dbo._RefLevel.Lvl=SRO_VT_SHARD.dbo._C harSkillMastery.Level AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.dbo._CharSkillMastery.Level <= '120'
UPDATE SRO_VT_SHARD.dbo._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.dbo._CharSkill FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120' and SRO_VT_SHARD.dbo._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())


Scroll Rest Stats
addlogitem

IF (@Operation = 41) and (@ItemRefID = 42078)
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE SRO_VT_SHARD.dbo._Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
end


Scroll Devils Gender Switch Tool
addlogitem

IF (@Operation = 41) -- If item used Scroll Devils Gender Switch Tool
Begin
IF (@ItemRefID = 42087) -- RefObjCommon ID
Begin
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Set @RefItemID = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,2 4412,41816,41818,41819) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41817',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41818 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41814',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41819 --@Angle S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41815',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41816 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())

End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,2 4411,41815,41814,41817) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41816',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41815 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41818',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41817 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41819',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41814 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
End
End
End


حتغير 'Your Message here ' بي اللي انت عايزه

[Mohamed ElKersh]

اتفضل
Scroll Skills recall
addlogitem
IF (@Operation = 41 and @ItemRefID = 42091) -- Scroll Skills recall
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(SRO_VT_SHARD.dbo._RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(SRO_VT_SHARD.dbo._RefLevel.Exp_M) FROM SRO_VT_SHARD.dbo._CharSkillMastery, SRO_VT_SHARD.dbo._RefLevel WHERE SRO_VT_SHARD.dbo._RefLevel.Lvl=SRO_VT_SHARD.dbo._C harSkillMastery.Level AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.dbo._CharSkillMastery.Level <= '120'
UPDATE SRO_VT_SHARD.dbo._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.dbo._CharSkill FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120' and SRO_VT_SHARD.dbo._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())


Scroll Rest Stats
addlogitem

IF (@Operation = 41) and (@ItemRefID = 42078)
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE SRO_VT_SHARD.dbo._Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
end


Scroll Devils Gender Switch Tool
addlogitem

IF (@Operation = 41) -- If item used Scroll Devils Gender Switch Tool
Begin
IF (@ItemRefID = 42087) -- RefObjCommon ID
Begin
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Set @RefItemID = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,2 4412,41816,41818,41819) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41817',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41818 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41814',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41819 --@Angle S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41815',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41816 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())

End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,2 4411,41815,41814,41817) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41816',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41815 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41818',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41817 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41819',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41814 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
End
End
End


حتغير 'Your Message here ' بي اللي انت عايزه

حضرتك مجربه ؟

[Mohamed ElKersh]

بايظ
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 120
Must declare the scalar variable "@CharName".
Msg 137, Level 15, State 2, Procedure _AddLogItem, Line 134
Must declare the scalar variable "@CharName".


يا عممم جربه ونبييي

[HLP]

ههههههههههه
يا حبيبي مش بايظ
ده عايز Declare ل ChaName
اتفضل
Declare @Charname varchar (68) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @Charid)

IF (@Operation = 41 and @ItemRefID = 42091) -- Scroll Skills recall
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(SRO_VT_SHARD.dbo._RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(SRO_VT_SHARD.dbo._RefLevel.Exp_M) FROM SRO_VT_SHARD.dbo._CharSkillMastery, SRO_VT_SHARD.dbo._RefLevel WHERE SRO_VT_SHARD.dbo._RefLevel.Lvl=SRO_VT_SHARD.dbo._C harSkillMastery.Level AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.dbo._CharSkillMastery.Level <= '120'
UPDATE SRO_VT_SHARD.dbo._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.dbo._CharSkill FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120' and SRO_VT_SHARD.dbo._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
END

IF (@Operation = 41) and (@ItemRefID = 42078)
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE SRO_VT_SHARD.dbo._Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
end

IF (@Operation = 41) -- If item used Scroll Devils Gender Switch Tool
Begin
IF (@ItemRefID = 42087) -- RefObjCommon ID
Begin
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Set @RefItemID = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,2 4412,41816,41818,41819) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41817',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41818 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41814',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41819 --@Angle S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41815',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41816 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())

End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,2 4411,41815,41814,41817) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41816',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41815 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41818',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41817 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41819',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41814 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
End
End
End

[Mohamed ElKersh]

ههههههههههه
يا حبيبي مش بايظ
ده عايز Declare ل ChaName
اتفضل
Declare @Charname varchar (68) = (SELECT CharName16 FROM SRO_VT_SHARD.dbo._Char WHERE CharID = @Charid)

IF (@Operation = 41 and @ItemRefID = 42091) -- Scroll Skills recall
begin
declare @TotalSP int
declare @TotalSPMastery int
SELECT @TotalSP = SUM(SRO_VT_SHARD.dbo._RefSkill.ReqLearn_SP) FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120'
SELECT @TotalSPMastery = SUM(SRO_VT_SHARD.dbo._RefLevel.Exp_M) FROM SRO_VT_SHARD.dbo._CharSkillMastery, SRO_VT_SHARD.dbo._RefLevel WHERE SRO_VT_SHARD.dbo._RefLevel.Lvl=SRO_VT_SHARD.dbo._C harSkillMastery.Level AND SRO_VT_SHARD.dbo._CharSkillMastery.CharID=@CharID AND SRO_VT_SHARD.dbo._CharSkillMastery.Level <= '120'
UPDATE SRO_VT_SHARD.dbo._Char SET RemainSkillPoint=RemainSkillPoint+@TotalSP+@TotalS PMastery+200000 WHERE CharID=@CharID
DELETE SRO_VT_SHARD.dbo._CharSkill FROM SRO_VT_SHARD.dbo._RefSkill, SRO_VT_SHARD.dbo._CharSkill WHERE SRO_VT_SHARD.dbo._RefSkill.ID=SRO_VT_SHARD.dbo._Ch arSkill.SkillID AND SRO_VT_SHARD.dbo._CharSkill.CharID=@CharID AND SRO_VT_SHARD.dbo._RefSkill.ReqCommon_MasteryLevel1 <= '120' and SRO_VT_SHARD.dbo._RefSkill.ID NOT IN (1,70,40,2,8421,9354,9355,11162,9944,8419,8420,115 26,10625)
UPDATE SRO_VT_SHARD.dbo._CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '120'
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
END

IF (@Operation = 41) and (@ItemRefID = 42078)
begin
declare @Strength int
declare @Intellect int
declare @MaxLevel int
declare @RemainStatPoint int
select @MaxLevel = MaxLevel from SRO_VT_SHARD.dbo._Char where CharID = @CharID
set @RemainStatPoint = (@MaxLevel*3)-3
set @MaxLevel = @MaxLevel+19
UPDATE SRO_VT_SHARD.dbo._Char SET Strength=@MaxLevel, Intellect=@MaxLevel, RemainStatPoint=@RemainStatPoint WHERE CharID=@CharID
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
end

IF (@Operation = 41) -- If item used Scroll Devils Gender Switch Tool
Begin
IF (@ItemRefID = 42087) -- RefObjCommon ID
Begin
Declare @InvID INT = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0)
Set @RefItemID = (Select RefItemID From [SRO_VT_SHARD].[dbo].[_Items] Where ID64 = @InvID)
IF @RefItemID in (24414,24972,24974,24976,24978,24406,24408,24410,2 4412,41816,41818,41819) -- IF found your Devil is Male
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24413',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24414 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24971',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24972 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24973',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24974 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24975',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24976 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24977',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24978 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24405',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24406 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24407',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24408 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24409',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24410 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24411',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24412 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41817',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41818 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41814',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41819 --@Angle S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41815',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41816 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())

End
ELSE IF @RefItemID in (24413,24971,24973,24975,24977,24405,24407,24409,2 4411,41815,41814,41817) -- IF found your Devil is Female
Begin
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24414',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24413 --@Devil B Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24972',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24971 --@Devil A Red Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24974',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24973 --@Devil A Yellow Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24976',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24975 --@Devil A Blue Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24978',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24977 --@Devil S Event
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24406',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24405 --@Devil A Red Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24408',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24407 --@Devil A Yellow Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24410',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24409 --@Devil A Blue Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='24412',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 24411 --@Devil S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41816',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41815 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41818',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41817 --@Angel S Mall
Update [SRO_VT_SHARD].[dbo].[_Items] Set RefItemID='41819',CreaterName='iLegend' Where ID64 = (Select ItemID From [SRO_VT_SHARD].[dbo].[_Inventory] Where CharID = @CharID and Slot = '13' and ItemID > 0) and RefItemID = 41814 --@Angel S Mall
Insert Into [dbo].[iLegend_Tool] (Service,Type,Target,Message,Date) Values (1,'Private',@CharName,'Your Message here ',Getdate())
End
End
End

سؤال غبي بس
انت جربته ؟

[HLP]

سؤال غبي بس
انت جربته ؟

ايو جرب و حيشتغل معك بس غير @ItemRefID برقم سكرول بيتعك

[Mohamed ElKersh]

شكرا جدا
تم الحل

[HLP]

انا في الخدمة

[Mohamed ElKersh]

انا في الخدمة

تستحق تكون مشرف والله
رشح نفسك

[M.HADAD]

##