الـجـروب الـرسـمى لـلـمـنـتـدى FaceBook | Official Group

**Mohamed ElKersh** · 13-03-2016, 05:34 PM

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

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

ديه مثلا اهم 3 كويرهات اسكرولات عاوز احطلهم السيستم ده اعمل ايه
ديه في addtimedjob

كود PHP:


			
                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+@TotalSPMastery+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,11526,10625) 

            UPDATE _CharSkillMastery SET Level='0' WHERE CharID=@CharID AND Level <= '110' 

        end

timed job

كود PHP:


			
            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

كود PHP:


			
     --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,24412) -- 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,24411) -- 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** · 13-03-2016, 07:29 PM

**HLP** · 14-03-2016, 07:44 AM

اتفضل
Scroll Skills recall
addlogitem

كود PHP:

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._CharSkill.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._CharSkillMastery.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+@TotalSPMastery+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._CharSkill.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,11526,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

كود PHP:

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

كود PHP:

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,24412,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,24411,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** · 14-03-2016, 09:30 PM

اقتباس:

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

اتفضل
Scroll Skills recall
addlogitem

كود PHP:

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._CharSkill.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._CharSkillMastery.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+@TotalSPMastery+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._CharSkill.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,11526,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

كود PHP:

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

كود PHP:

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,24412,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,24411,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** · 15-03-2016, 12:36 AM

بايظ

كود PHP:


			
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** · 15-03-2016, 07:31 AM

ههههههههههه
يا حبيبي مش بايظ
ده عايز Declare ل ChaName
اتفضل

كود PHP:

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._CharSkill.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._CharSkillMastery.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+@TotalSPMastery+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._CharSkill.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,11526,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,24412,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,24411,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** · 15-03-2016, 07:45 AM

اقتباس:

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

ههههههههههه
يا حبيبي مش بايظ
ده عايز Declare ل ChaName
اتفضل

كود PHP:

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._CharSkill.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._CharSkillMastery.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+@TotalSPMastery+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._CharSkill.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,11526,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,24412,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,24411,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** · 15-03-2016, 08:12 AM

اقتباس:

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

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

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

كود PHP:

@ItemRefID

برقم سكرول بيتعك

**Mohamed ElKersh** · 15-03-2016, 08:25 AM

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

**HLP** · 15-03-2016, 08:39 AM

انا في الخدمة

**Mohamed ElKersh** · 15-03-2016, 09:09 AM

اقتباس:

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

انا في الخدمة

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

**M.HADAD** · 15-03-2016, 09:50 AM

أدوات الموضوع
مشاهدة صفحة طباعة الموضوع أرسل هذا الموضوع إلى صديق
انواع عرض الموضوع
العرض العادي الانتقال إلى العرض المتطور الانتقال إلى العرض الشجري

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
Program : Vsro Multi Tool	Dev. iLegend	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	45	24-10-2024 02:57 PM
مشكله Vsro Multi Tool	MiShWo	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	2	25-03-2020 01:52 AM
Vsro multi tool	BeboSilkroad	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	2	26-07-2017 01:34 PM
vsro multi tool	loaymoataz123	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	5	14-04-2017 09:22 PM
سؤال عن vsro multi tool	Mohamed ElKersh	قسم الاسئلة و الاستفسارات لعمل السيرفرات الخاصة	4	13-03-2016 06:54 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	حفظ بياناتي ؟