Scroll To remove adv From Any Item . [الأرشيف] - الموقع العربي الاول للعبة Silkroad Online

che_9299

15-12-2013, 08:18 PM

Scroll To remove adv From Any Item .
http://img338.imageshack.us/img338/7545/gif1302156586680.gif

النهارده هعمل موضوع عن سكرول بتشيل من اى ايتم معااك فى الانفتورى
بتشيل كل ال ADV اللى معاك على اى ايتم
ملحوظه دى بتشيل من على اكتر من الايتم يعنى لو معاك 20 ايتم مضروب عليه adv كلو هيتشال
يعنى علشان تستخدم على ايتم واحد لازم تخليه لوحده فى الانفتورى
الموضوع ده كان موجود قبل كده بس مكنش شغال وبيجيب ايررورات وناقص وكده
وده فيديو من السيرفر بتاعى http://www.youtube.com/watch?v=VheBhHmDWEo&feature=youtu.be
المهم
نبتدى
http://www4.0zz0.com/2013/03/12/17/990294461.png
اولا الاضافات فى الداتابيز
_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

http://www10.0zz0.com/2013/03/19/17/492044372.gif
تمام كده خلصنا الداتابيز
ندخل بقى على الميديا 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

وبكده نكون خلصنا ارجو ان ينال الموضوع اعجابكم
ارجو ان يفيد الناس .
DataBase Editor Pro/AutoEquipSystem/EveryScrolls/Helper/ANYTHING

نسيت وده لينك ال ddj http://www.multiupload.nl/9M7LQE2FGE

●♥ Marwan1337 ♥●

15-12-2013, 10:17 PM

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

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

[GM]Cra$h

17-12-2013, 07:55 PM

Awesome Work!! :13:

Hamza FiGo

18-12-2013, 04:09 PM

Thnx Bro. Nice Work

che_9299

24-12-2013, 02:14 AM

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

yoy

24-12-2013, 07:57 PM

:mf_rasta:

che_9299

24-12-2013, 08:50 PM

:idiot:

World

25-12-2013, 03:48 AM

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

che_9299

25-12-2013, 05:51 AM

الله يخليك

-[Cyril]-

25-12-2013, 02:38 PM

برنس و الله :moon:
استمر
:biker: :biker: :biker:

.-Carica-.

28-12-2013, 09:33 PM

_AddTimedJob

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

che_9299

28-12-2013, 09:49 PM

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-.

28-12-2013, 11:00 PM

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

تحته

END
--##end due to develop composite item

che_9299

28-12-2013, 11:14 PM

طب ده البرسيدور بتاعى اشتغل افهم منو بقى 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+@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 <= '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,D ata2,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,D ata2,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-.

29-12-2013, 01:03 PM

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

che_9299

29-12-2013, 01:15 PM

اشطه

Last_Fiddler

31-12-2013, 08:20 AM

السلام عليكم
تسلم ايدك شكرا

elfr3on2010

02-01-2014, 09:54 AM

تسلم ايدك

N00b™

06-01-2014, 12:33 PM

طب لو عايز ال ADV يرجع فى ال inv ?

che_9299

06-01-2014, 01:29 PM

صعب بس انا هافكرلك فيها :weight_lift2:

Bouken

06-01-2014, 10:21 PM

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 Slot = '13' and CharID=@CharID) and bOptType=2
end
end

**********************************
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 Slot between '13' and '14' and CharID=@CharID) and bOptType=2
end
end

أنا عدلت بس مجربتش المهم
الاول انوا يعدل على ايتم واحدة بس . بس لازم تحط الايتم فى المكان الى هتحطوا فى الاسكربت

و التانى يعدل على أكتر من ايتم و برضوا لازم تحط الايتمز فى المكان الى هتحطوا فى الاسكربت

ان شاء تشتغل :)

che_9299

07-01-2014, 08:01 AM

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 Slot = '13' and CharID=@CharID) and bOptType=2
end
end

**********************************
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 Slot between '13' and '14' and CharID=@CharID) and bOptType=2
end
end

أنا عدلت بس مجربتش المهم
الاول انوا يعدل على ايتم واحدة بس . بس لازم تحط الايتم فى المكان الى هتحطوا فى الاسكربت

و التانى يعدل على أكتر من ايتم و برضوا لازم تحط الايتمز فى المكان الى هتحطوا فى الاسكربت

ان شاء تشتغل :)

تمام شكرا على مجهودك بس هتبقى رخمه ان الواحد فى السيرفر بتاعو يقولهم حطو الايتم فى حته معينه وكده فاهمنى ..

Bouken

07-01-2014, 11:05 PM

تمام شكرا على مجهودك بس هتبقى رخمه ان الواحد فى السيرفر بتاعو يقولهم حطو الايتم فى حته معينه وكده فاهمنى ..

و هتبقى أوحش لما الرسالة تشيل كل ال ADV الى فى كل الايتمز

و رقم 13 هو أول خانة فى الشنطة

أما عن رخمه ان الواحد فى السيرفر بتاعو يقولهم حطو الايتم فى حته معينه

أمال اية لازمت الكلام ألى بتكتبوا فى الرسالة من جوا
مش بيكون شرح ليها و كيفية الاستخدام :)
ملحوظة: كل الناس بتستخدم برامج لعمل البلس و طبعا لازم يحطوا الايتم فى اول خانة :)

che_9299

08-01-2014, 05:48 AM

و هتبقى أوحش لما الرسالة تشيل كل ال ADV الى فى كل الايتمز

و رقم 13 هو أول خانة فى الشنطة

أما عن

أمال اية لازمت الكلام ألى بتكتبوا فى الرسالة من جوا
مش بيكون شرح ليها و كيفية الاستخدام :)
ملحوظة: كل الناس بتستخدم برامج لعمل البلس و طبعا لازم يحطوا الايتم فى اول خانة :)

مش هقولك غير تمام
علشان المشكله بردو ان كل واحد بيتعامل بدماغو انا شرحت الموضوع على دماغى وفكرتى مش اكتر كل واحد ممكن يعدل براحتو
ويعمل اللى هوه عايزو على العموم شكرا لاقتراحاتك وياريت تجربها وتعمل بيها موضوع كمان
اه نسيت ابقى جرب دى كمان يمكن تنفعك
WHERE Slot Between 1 AND 2'

ǍŋṰấҜấ

08-01-2014, 11:43 AM

NiCe Ya Ngm

:specool:

Tigger

14-05-2014, 10:14 AM

تمام استمر:oneeyedsmiley:

GusToma

22-05-2014, 05:32 PM

طب ال Skill effect نحطو فين في ال Txt

GusToma

22-05-2014, 06:23 PM

كلينت كراش قبل ما اللعبة تفتح

انا شاكك ان المشكلة في الملفات المتشفرة

مع اني فاكك التشفير عادي :(

GusToma

22-05-2014, 09:01 PM

كراش لما بختار الشخصية

GusToma

23-05-2014, 12:12 AM

تم حل المشكلة بس
انا بستعمل الايتم وكلو تمام

وبعمل Teleport بس ال ADV مش بيروح

che_9299

23-05-2014, 10:10 AM

هوه حضرتك بتبقى لابس الحاجه اللى عايز تشيل من عليها ال ADV
واتاكد ان مفيش اى غلطه فى البروسيدور

GusToma

23-05-2014, 11:05 AM

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

GusToma

23-05-2014, 11:10 AM

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddTimedJob] Script Date: 05/23/2014 11:09:41 ******/
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+@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 <= '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,D ata2,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,D ata2,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

zizo_back

04-07-2014, 10:17 AM

ممكن الddj تحميله من تانى علشان مش شغال
و شكرا على الموضوع الرائع

BuiLt4KiLl

07-08-2014, 03:26 PM

تمام ,, بس يا ريت تغير لينك الـ Download

Hamza FiGo

23-08-2014, 03:03 PM

تمام ,, بس يا ريت تغير لينك الـ Download

+1

Hamza FiGo

16-10-2014, 08:34 PM

Worked 100%

بس لما بستعمل البروسيدر بيعمل باج في الــ FGW بيخلي اللي يدخل يجيلة DC ولما اشل البروسيدر بتاعتك واحط بتاعتي الـ FGW تشتغل تمام

كدا انا شايل البروسيدر والاسكرول كدة ملهاش لازمة من غيرها. ياريت تقولنا فية اية بالظبط . شكرا

TY

Mostafa Shaaban

23-02-2015, 02:36 PM

طيب انا عايز الاسكرول اللي بتشيل من ايتم واحده بس ممكن ؟

:lulu1::lulu1::lulu1::lulu1::lulu1::lulu1:

ViP_BedoZ

23-02-2015, 03:34 PM

الله ينور أستمر:wink3:

Mostafa Shaaban

23-02-2015, 09:55 PM

Teslm

:59::59::59::59::59::59::59::59:

beboo99

13-11-2016, 10:29 AM

ياريت ملفات ال DDJ لان اللينك مش شغال
بارك الله فيك[/SIZE]