المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : مشكلة فى upgrade scroll

elbattawy1st
10-08-2014, 02:46 AM
انا كل ما اضيف ال produce دا
if (@JobID = 'skill id')
begin
DECLARE @OldItemCodeName varchar(128)
set @OldItemCodeName= 'ITEM_EU_TSWORD_14_B_RARE'
DECLARE @OldItemPlus int
set @OldItemPlus =7
DECLARE @NewItemCodeName varchar(128)
set @NewItemCodeName = ('ITEM_EU_TSWORD_15_A_RARE')
DECLARE @NewItemPlus int
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from _Inventory as inv inner join _Items as itm on inv.ItemID = itm.ID64 inner join _RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update _Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
return -3
end
يظهر زى الا فى الصورة دى
http://im59.gulfup.com/4gRFwl.png
ياريت حد يعرف الحل و يقولى
Hero
10-08-2014, 03:29 AM
يبقا اكيد غلط
مفيش اكتر من الحاجت دى موجودة غلط :] صعب تلاقى واحد رافع حاجة صح
elbattawy1st
10-08-2014, 03:31 AM
يعنى مفيش حل او ممكن يكون حد عارف ؟؟ :sad2:
Hero
10-08-2014, 11:52 AM
حضرتك لو اضافة سطر كان حد ساعدك لاكن دى اسكروال و باين اوى انها بيظة حاول تصلحها
Yui
11-08-2014, 12:17 PM
Here you go fixed code


if (@JobID = 'skill id')
begin
DECLARE @CharName16 varchar(128)
DECLARE @OldItemCodeName varchar(128)
set @OldItemCodeName= 'ITEM_EU_TSWORD_14_B_RARE'
DECLARE @OldItemPlus int
set @OldItemPlus =7
DECLARE @NewItemCodeName varchar(128)
set @NewItemCodeName = ('ITEM_EU_TSWORD_15_A_RARE')
DECLARE @NewItemPlus int
set @NewItemPlus = 0
DECLARE @ReplaceID int
SET @REPLACEID = (select top 1 ItemID from _Inventory as inv inner join _Items as itm on inv.ItemID = itm.ID64 inner join _RefObjCommon as common on itm.RefItemID = common.ID where inv.CharID = @CharID and common.CodeName128 = @olditemCodeName and itm.OptLevel >= @OldItemPlus)
if (@ReplaceID > 0)
begin
Update _Inventory set ItemID = 0 where ItemID = @ReplaceID and CharID = @CharID
select @CharName16 =CharName16 from _Char where CharID=@CharID
exec _ADD_ITEM_EXTERN @CharName16,@NewItemCodeName,1,@NewItemPlus
end
return -3
end
elbattawy1st
11-08-2014, 05:18 PM
thx Yui i love you :mf_lust::mf_lust::mf_lust::mf_lust::mf_lust:
Hero
11-08-2014, 06:41 PM
##