Scroll To remove adv From Any Item .

[che_9299]

Scroll To remove adv From Any Item .


النهارده هعمل موضوع عن سكرول بتشيل من اى ايتم معااك فى الانفتورى
بتشيل كل ال ADV اللى معاك على اى ايتم
ملحوظه دى بتشيل من على اكتر من الايتم يعنى لو معاك 20 ايتم مضروب عليه adv كلو هيتشال
يعنى علشان تستخدم على ايتم واحد لازم تخليه لوحده فى الانفتورى
الموضوع ده كان موجود قبل كده بس مكنش شغال وبيجيب ايررورات وناقص وكده
وده فيديو من السيرفر بتاعى عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
المهم
نبتدى

اولا الاضافات فى الداتابيز
_AddTimedJob

   if(@JobID= '34003') -- Remover ADV Ticket added by CHE
		begin 
		Select @CharName16=CharName16 from _Char where CharID = @CharID 
		begin
		DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory 
		WHERE  CharID=@CharID) and bOptType=2
		end
		end

RefObjCommon

1	103062	ITEM_MALL_ADVDOWN	???? ???? ??? (???)	xxx	SN_ITEM_MALL_ADVDOWN	SN_ITEM_MALL_ADVDOWN_TT_DESC	1	0	3	3	13	14	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	Premium\etc\advdown.ddj	xxx	xxx	2236104

RefObjItem

2236104	1	2	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1000	????(?)	1	[USU1:SKILL_MALL_ADVDOWN]                                                                                                        	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0	0

Refskill

1	34003	12023	SKILL_MALL_ADVDOWN	???? ????	SKILL_MALL_ADVDOWN	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_MALL_ADVDOWN	xxx	SN_SKILL_MALL_ADVDOWN_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

RefskillGroup

12023	SKILL_MALL_ADVDOWN

تمام كده خلصنا الداتابيز
ندخل بقى على الميديا Media\Server_dep\Silkroad\textdata
itemdata_4500

1	103062	ITEM_MALL_ADVDOWN	???? ???? ??? (???)	xxx	SN_ITEM_MALL_ADVDOWN	SN_ITEM_MALL_ADVDOWN_TT_DESC	1	0	3	3	13	14	180000	3	0	1	1	1	255	0	1	0	0	129	0	0	0	0	0	0	0	-1	0	-1	0	-1	0	-1	0	-1	0	0	0	0	0	0	0	100	0	0	0	xxx	item\etc\drop_mall_scroll.bsr	Premium\etc\advdown.ddj	xxx	xxx	1	2	0	0	1	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0	0	0	0	0	0	0	0	0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	0.0	1000	????(?)	1	[USU1:SKILL_MALL_ADVDOWN]	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	-1	xxx	0	0

SkillEffect

1	귀환서 사용전	SKILL_MALL_ADVDOWN	0	FALSE	0	DEFAULT	none	none	none	none	none	none	none	none	0	0,0,0,0	ONE	none	none	none	none	none	none	none	0	1	
귀환서 사용전	SKILL_MALL_ADVDOWN	ACT_S	0	FALSE	none	none	0	0	0	0	1	0,0	AT_LOOP	MOV_NONE,0,0,0	0,0,0	false,0,0,0,0,false	system\	item_returnscroll.efp	none	0,0,0	none	0,0,0	none	0	none	none	none

Textdata_Object

1	SN_ITEM_MALL_ADVDOWN								Scroll Remove adv
1	SN_ITEM_MALL_ADVDOWN_TT_DESC								scroll to remove adv.

Skilldata_3500enc

1	34003	12023	SKILL_MALL_ADVDOWN	???? ????	SKILL_MALL_ADVDOWN	0	1	1	0	0	0	0	0	1000	0	0	0	3599	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	1	0	0	0	0	0	0	0	0	0	0	0	0	3	0	0	255	255	0	0	0	0	0	255	255	255	255	item\etc\mall_optlevel_upgrade_scroll_1.ddj	SN_SKILL_MALL_ADVDOWN	xxx	SN_SKILL_MALL_ADVDOWN_TT_DESC	xxx	0	0	3	1667396966	1851946342	1685418593	1500	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0	0

وبكده نكون خلصنا ارجو ان ينال الموضوع اعجابكم
ارجو ان يفيد الناس .
[SPOILER]DataBase Editor Pro/AutoEquipSystem/EveryScrolls/Helper/ANYTHING
[/SPOILER]
نسيت وده لينك ال ddj عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

[●♥ Marwan1337 ♥●]

تمــت المـوافقــة ,,


تمــام , شكــرآ..

[[GM]Cra$h]

Awesome Work!!

[Hamza FiGo]

Thnx Bro. Nice Work

[che_9299]

تم اضافة لينك DDJ بتاع السكرول

[yoy]

[che_9299]

[World]

اية الجمال دة ؟ :)

[che_9299]

الله يخليك

[-[Cyril]-]

برنس و الله
استمر

[.-Carica-.]

_AddTimedJob

مش راضى يضاف !!
هاتو صح :]ٍ

[che_9299]

 if(@JobID= '34003') 
		begin 
		Select @CharName16=CharName16 from _Char where CharID = @CharID 
		begin
		DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory 
		WHERE  CharID=@CharID) and bOptType=2
		end
		end

بعد as ها

[.-Carica-.]

معلش انا مش لاقى Sa دى ^^
مش بيطحط بعد

تحته

END
--##end due to develop composite item

[che_9299]

طب ده البرسيدور بتاعى اشتغل افهم منو بقى

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_AddTimedJob]    Script Date: 12/28/2013 22:12:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER   procedure [dbo].[_AddTimedJob]
@CharID            int,
@Category        tinyint,
@JobID            int,
@TimeToKeep    int,
@Data1            int,
@Data2            int,
--##begin due to develop composite item
@Data3            int,
@Data4            int,
@Data5            int,
@Data6            int,
@Data7            int,
@Data8            int,
@Serial64        bigint,
@JID            int
--##end due to develop composite item
as
       if(@JobID = '45000')
        BEGIN 
declare @CharName16 varchar(64) 
         Select @CharName16=CharName16 from _Char where CharID = @CharID 
         Update _Char Set CharName16 = '@'+ @CharName16 Where CharID = @CharID 
        END  
    if(@JobID = '45001')
        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  
if(@JobID	=	'34005')
begin

Update	_Char	Set	DailyPK	=	0	Where	CharID	=	@CharID
Update	_Char	Set	TotalPK	=	0	Where	CharID	=	@CharID
Update	_Char	Set	PKPenaltyPoint	=	0	Where	CharID	=	@CharID
end
    if(@JobID= '55000')
		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 <= '130' 
		end  
		if(@JobID= '34038') 
		begin 
			Update _Items Set MagParamNum = 0, MagParam1 = NULL, MagParam2 = NULL, MagParam3 = NULL, MagParam4 = NULL, MagParam5 = NULL, MagParam6 = NULL, MagParam7 = NULL, MagParam8 = NULL, MagParam9 = NULL, MagParam10 = NULL, MagParam11 = NULL, MagParam12 = NULL where ID64 in (select ItemID from _Inventoryforavatar where CharID = @CharID and Slot between 0 and 2 and ItemID>0)
		end
	
     if(@JobID= '34003') --
		begin 
		Select @CharName16=CharName16 from _Char where CharID = @CharID 
		begin
		DELETE FROM  _BindingOptionWithItem where nItemDBID IN (SELECT ItemID FROM _Inventory 
		WHERE  CharID=@CharID) and bOptType=2
		end
		end
      if(@JobID = '45010')---gift---
         begin
                    declare @tradenum  int
                    declare @gift varchar(128)
                    set @gift =('ITEM_ETC_SD_TOKEN_02')
                    SET @tradenum =(SELECT ABLECOUNT from _CharTrijobSafeTrade where CharID =@CharID )        
    if (@tradenum >=1)
    begin
select @CharName16 =CharName16  from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@gift,10,1
update _CharTrijobSafeTrade set AbleCount =0 where CharID =@CharID
end
end 

if
(@JobID= '99999')
		 BEGIN 
        DECLARE @CharName Varchar (MAX) 
     Select @CharName16=CharName16 from _Char where CharID = @CharID 
      Begin
     DELETE FROM _TimedJob WHERE Data2 between  1 AND 11000 AND CharID = @CharID 

   	end
   	end


    if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
                return -1
            if (@TimeToKeep <= 0)
                return -2
            declare @NewJobID int
            set @NewJobID = 0

            --##JobID 1 = Guild // JobID 2 = Thief/Hunter/Trader
            --##If you want to only have one not both, then just modify the line below!
            if (@JobID = 1 or @JobID = 2)
            BEGIN
                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
                values(@CharID, @Category, @JobID, 1, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
            ELSE
            BEGIN
                --##begin due to develop composite item
                insert into _TimedJob(CharID,Category,JobID,TimeToKeep,Data1,Data2,Data3,Data4,Data5,Data6,Data7,Data8,Serial64,JID)
                values(@CharID, @Category, @JobID, @TimeToKeep, @Data1, @Data2, @Data3, @Data4, @Data5, @Data6, @Data7, @Data8, @Serial64, @JID)
            END
                --##end due to develop composite item
            set @NewJobID = @@identity
            if (@@error <> 0 or @@rowcount = 0)
          return -3
    return @NewJobID

[.-Carica-.]

اوك تسلم يا برنس
هجربو اهو