Arkadaşlar devil blue ekledim ama basarken sorun yasiyorum blue devil harici dresslere falanda gidiyor
kullandigim prosedur
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID1 varchar (64)
select ItemID=@ItemID1 from _InventoryForAvatar where CharID = @CharID and Slot = '4'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '4' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID2 varchar (64)
select ItemID=@ItemID2 from _InventoryForAvatar where CharID = @CharID and Slot = '0'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '0' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID3 varchar (64)
select ItemID=@ItemID3 from _InventoryForAvatar where CharID = @CharID and Slot = '1'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '1' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID4 varchar (64)
select ItemID=@ItemID4 from _InventoryForAvatar where CharID = @CharID and Slot = '2'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '2' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID5 varchar (64)
select ItemID=@ItemID5 from _InventoryForAvatar where CharID = @CharID and Slot = '3'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '3' and ItemID>0)
END
Jobid kısmına hepsine hepsine refskill idlerini aynı yazdım diye olabilir mi
Üst üste post gönderildiği için tek mesajda birleştirildi:
kullandigim prosedur
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID1 varchar (64)
select ItemID=@ItemID1 from _InventoryForAvatar where CharID = @CharID and Slot = '4'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '4' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID2 varchar (64)
select ItemID=@ItemID2 from _InventoryForAvatar where CharID = @CharID and Slot = '0'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '0' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID3 varchar (64)
select ItemID=@ItemID3 from _InventoryForAvatar where CharID = @CharID and Slot = '1'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '1' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID4 varchar (64)
select ItemID=@ItemID4 from _InventoryForAvatar where CharID = @CharID and Slot = '2'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '2' and ItemID>0)
END
--
if(@JobID = '33834') --- Credit To Swagger1337
BEGIN
declare @ItemID5 varchar (64)
select ItemID=@ItemID5 from _InventoryForAvatar where CharID = @CharID and Slot = '3'
UPDATE dbo._Items set MagParamNum='6',MagParam1='858993459290',MagParam2= '257698037898',MagParam3='7301444403624',MagParam4= '34359738785',MagParam5='7301444403625',MagParam6='34359738786' WHERE ID64 = (select ItemID from _InventoryForAvatar where CharID = @CharID and Slot = '3' and ItemID>0)
END
Üst üste post gönderildiği için tek mesajda birleştirildi:
Jobid kısmına hepsine hepsine refskill idlerini aynı yazdım diye olabilir mi
Ekli dosyalar
