Please provide us with your table and procedure to be able to find out where is the problem.
Trigger
PHP Code:
USE [SRO_VT_SHARD]
GO
/****** Object: Trigger [dbo].[TR_AUTOEQUIP_DEPIEDRA] Script Date: 03/26/2017 00:19:39 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TRIGGER [dbo].[TR_AUTOEQUIP_DEPIEDRA] ON [dbo].[_Char] AFTER UPDATE
AS
BEGIN
declare [MENTION=351728]new[/MENTION]lvl as tinyint = (select CurLevel from inserted)
declare @charID as int = (select CharID from inserted)
if [MENTION=351728]new[/MENTION]lvl between 13 and 99
begin
declare [MENTION=1326241]REF[/MENTION]CharID int
declare @charname varchar(64)
declare @charLevel tinyint
set [MENTION=1326241]REF[/MENTION]CharID = (select RefObjID from SRO_VT_SHARD.dbo._Char where CharID = @charID)
set @charname = (select CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @charID)
set @charLevel = (select CurLevel from SRO_VT_SHARD.dbo._Char where CharID = @charID)
Declare [MENTION=1326241]REF[/MENTION]Mail INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='1')
Declare [MENTION=1326241]REF[/MENTION]MailID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = [MENTION=1326241]REF[/MENTION]Mail)
Declare [MENTION=1326241]REF[/MENTION]Weapon INT
Declare [MENTION=289336]weapon[/MENTION] INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='6')
Declare [MENTION=1326241]REF[/MENTION]WeaponID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = [MENTION=289336]weapon[/MENTION])
Declare [MENTION=289336]weapon[/MENTION]Type Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = [MENTION=1326241]REF[/MENTION]WeaponID)
Declare [MENTION=1830489]refs[/MENTION]hield INT
Declare [MENTION=662184]Shield[/MENTION] INT = (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='7')
Declare [MENTION=1830489]refs[/MENTION]hieldID INT = (Select RefItemID From SRO_VT_SHARD.dbo._Items Where ID64 = [MENTION=662184]Shield[/MENTION])
Declare [MENTION=662184]Shield[/MENTION]Type Tinyint = (Select Typeid4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = [MENTION=1830489]refs[/MENTION]hieldID)
declare @mail_codename varchar(250)
declare @chr_gender varchar(250)
declare @item_level varchar(250)
declare @itemcodename varchar(250)
select @mail_codename = CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where ID = [MENTION=1326241]REF[/MENTION]MailID
declare @degree varchar(25)
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 0
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 1
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 2
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 3
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 4
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 5
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 9
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 10
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 11
Update SRO_VT_SHARD.dbo._Inventory set ItemID = 0 where CharID = @charID and Slot = 12
if (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='6') != 0
begin
If ((Select TypeID4 from SRO_VT_SHARD.dbo._RefObjCommon where ID = (Select top 1 RefItemID from SRO_VT_SHARD.dbo._items where id64 = [MENTION=289336]weapon[/MENTION]))
= [MENTION=289336]weapon[/MENTION]Type ) -- Weapon
Begin
Set [MENTION=1326241]REF[/MENTION]Weapon = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment where
Service = 1 AND
TypeID1=3 AND --- Weapon
TypeID2=1 AND
TypeID3=6 AND
TypeID4 [MENTION=289336]weapon[/MENTION]Type
Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
having (MAX(ReqLevel1)<= [MENTION=351728]new[/MENTION]lvl)
Order By ReqLevel1 Desc
)
Update SRO_VT_SHARD.dbo._Items set RefItemID= [MENTION=1326241]REF[/MENTION]Weapon where ID64= [MENTION=289336]weapon[/MENTION]
Update SRO_VT_SHARD.dbo._Items set OptLevel= 4,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= [MENTION=289336]weapon[/MENTION]
END
end
if (Select ItemID From SRO_VT_SHARD.dbo._Inventory Where CharID=(Select CharID From SRO_VT_SHARD.dbo._Char Where CharID = @charID)
AND Slot ='7') != 0
begin
If ((Select ID from SRO_VT_SHARD.dbo._RefObjCommon where ID in (Select Refitemid from SRO_VT_SHARD.dbo._Items where ID64 = [MENTION=662184]Shield[/MENTION])) not in (62,3655))
Begin
Set [MENTION=1830489]refs[/MENTION]hield = (Select top 1 ID from SRO_VT_SHARD.dbo._ItemPoolAutoEquipment WITH (Nolock) where
Service = 1 AND
TypeID1=3 AND --- Shield
TypeID2=1 AND
TypeID3=4 AND
TypeID4 [MENTION=662184]Shield[/MENTION]Type
Group by SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.ID,SRO_VT_SHARD.dbo._ItemPoolAutoEquipment.reqlevel1
having (MAX(ReqLevel1)<= [MENTION=351728]new[/MENTION]lvl)
Order By ReqLevel1 Desc
)
Update SRO_VT_SHARD.dbo._Items set RefItemID= [MENTION=1830489]refs[/MENTION]hield where ID64= [MENTION=662184]Shield[/MENTION]
Update SRO_VT_SHARD.dbo._Items set OptLevel= 4,Variance= 34359738367,Data= 200, MagParamNum='2',MagParam1='30064771144',MagParam2= '30064771150' where ID64= [MENTION=662184]Shield[/MENTION]
END
end
IF [MENTION=351728]new[/MENTION]lvl >= 90 and [MENTION=351728]new[/MENTION]lvl <= 99
BEGIN
set @item_level = '10' --DG
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 85 and [MENTION=351728]new[/MENTION]lvl <= 89
BEGIN
set @item_level = '09' --DG
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 81 and [MENTION=351728]new[/MENTION]lvl <= 84
BEGIN
set @item_level = '09' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 77 and [MENTION=351728]new[/MENTION]lvl <= 80
BEGIN
set @item_level = '08' --DG
IF @item_level = '09'
begin
set @degree = '_C_RARE'
end
else if @item_level = '08'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 73 and [MENTION=351728]new[/MENTION]lvl <= 76
BEGIN
set @item_level = '08' --DG
IF @item_level = '09'
begin
set @degree = '_C_RARE'
end
else if @item_level = '08'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 69 and [MENTION=351728]new[/MENTION]lvl <= 72
BEGIN
set @item_level = '08' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 65 and [MENTION=351728]new[/MENTION]lvl <= 68
BEGIN
set @item_level = '07' --DG
IF @item_level = '08'
begin
set @degree = '_C_RARE'
end
else if @item_level = '07'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 61 and [MENTION=351728]new[/MENTION]lvl <= 64
BEGIN
set @item_level = '07' --DG
IF @item_level = '08'
begin
set @degree = '_C_RARE'
end
else if @item_level = '07'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 57 and [MENTION=351728]new[/MENTION]lvl <= 60
BEGIN
set @item_level = '07' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 53 and [MENTION=351728]new[/MENTION]lvl <= 56
BEGIN
set @item_level = '06' --DG
IF @item_level = '07'
begin
set @degree = '_C_RARE'
end
else if @item_level = '06'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 50 and [MENTION=351728]new[/MENTION]lvl <= 52
BEGIN
set @item_level = '06' --DG
IF @item_level = '07'
begin
set @degree = '_C_RARE'
end
else if @item_level = '06'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 47 and [MENTION=351728]new[/MENTION]lvl <= 49
BEGIN
set @item_level = '06' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 43 and [MENTION=351728]new[/MENTION]lvl <= 46
BEGIN
set @item_level = '05' --DG
IF @item_level = '06'
begin
set @degree = '_C_RARE'
end
else if @item_level = '05'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 40 and [MENTION=351728]new[/MENTION]lvl <= 42
BEGIN
set @item_level = '05' --DG
IF @item_level = '06'
begin
set @degree = '_C_RARE'
end
else if @item_level = '05'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 37 and [MENTION=351728]new[/MENTION]lvl <= 39
BEGIN
set @item_level = '05' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 34 and [MENTION=351728]new[/MENTION]lvl <= 36
BEGIN
set @item_level = '04' --DG
IF @item_level = '05'
begin
set @degree = '_C_RARE'
end
else if @item_level = '05'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 31 and [MENTION=351728]new[/MENTION]lvl <= 33
BEGIN
set @item_level = '04' --DG
IF @item_level = '05'
begin
set @degree = '_C_RARE'
end
else if @item_level = '04'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 29 and [MENTION=351728]new[/MENTION]lvl <= 30
BEGIN
set @item_level = '04' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 26 and [MENTION=351728]new[/MENTION]lvl <= 28
BEGIN
set @item_level = '03' --DG
IF @item_level = '04'
begin
set @degree = '_C_RARE'
end
else if @item_level = '03'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 23 and [MENTION=351728]new[/MENTION]lvl <= 25
BEGIN
set @item_level = '03' --DG
IF @item_level = '04'
begin
set @degree = '_C_RARE'
end
else if @item_level = '03'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl = 21 or [MENTION=351728]new[/MENTION]lvl = 22
BEGIN
set @item_level = '03' --DG
set @degree = '_C_RARE'
end
IF [MENTION=351728]new[/MENTION]lvl >= 18 and [MENTION=351728]new[/MENTION]lvl <= 20
BEGIN
set @item_level = '02' --DG
IF @item_level = '03'
begin
set @degree = '_C_RARE'
end
else if @item_level = '02'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 15 and [MENTION=351728]new[/MENTION]lvl <= 17
BEGIN
set @item_level = '02' --DG
IF @item_level = '03'
begin
set @degree = '_C_RARE'
end
else if @item_level = '02'
begin
set @degree = '_C_RARE'
end
end
IF [MENTION=351728]new[/MENTION]lvl >= 13 and [MENTION=351728]new[/MENTION]lvl <= 14
BEGIN
set @item_level = '02' --DG
set @degree = '_C_RARE'
end
if [MENTION=1326241]REF[/MENTION]CharID between 1907 and 1919 or [MENTION=1326241]REF[/MENTION]CharID between 14875 and 14887
begin
set @chr_gender = 'M' --male
end
if [MENTION=1326241]REF[/MENTION]CharID between 1920 and 1932 or [MENTION=1326241]REF[/MENTION]CharID between 14888 and 14900
begin
set @chr_gender = 'W' --female
end
if [MENTION=1326241]REF[/MENTION]CharID between 1907 and 1919 or [MENTION=1326241]REF[/MENTION]CharID between 1920 and 1932
begin
set @itemcodename = 'ITEM_CH_RING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,11,@itemcodename,200
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,12,@itemcodename,200
set @itemcodename = 'ITEM_CH_EARRING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,9,@itemcodename,200
set @itemcodename = 'ITEM_CH_NECKLACE_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,10,@itemcodename,200
end
if [MENTION=1326241]REF[/MENTION]CharID between 14875 and 14887 or [MENTION=1326241]REF[/MENTION]CharID between 14888 and 14900
begin
set @itemcodename = 'ITEM_EU_RING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,11,@itemcodename,200
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,12,@itemcodename,200
set @itemcodename = 'ITEM_EU_EARRING_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,9,@itemcodename,200
set @itemcodename = 'ITEM_EU_NECKLACE_' + @item_level + @degree + '_C_RARE'
EXEC SRO_VT_SHARD.dbo._FN_ADD_INITIAL_EQUIP_DEPI @charname,10,@itemcodename,200
end
{Update}RelicSro►Cap 110►mid rates►AutoEquipment D1~D11►Silk Per Hour&&&New Uniques 11/28/2014 - SRO PServer Advertising - 103 Replies http://i58.tinypic.com/2dloe1w.png
Hello Elitepvpers & Welcome TO Relic Sro
Introducing Relic Sro
When we started to plan for this server, we agreed to keep it exactly the same like ISRO system. And since the server is a LONG TERM server then we decided to add some events and features which will meet the needs of different and several players who have different point of views concerning having fun in a silkroad server.
We have dreamed of a server...
{Update}RelicSro►Cap 110►mid rates►AutoEquipment D1~D9►Silk Per Hour&&&More 10/30/2014 - SRO PServer Advertising - 18 Replies http://i58.tinypic.com/2dloe1w.png
Hello Elitepvpers & Welcome TO Relic Sro
Introducing Relic Sro
When we started to plan for this server, we agreed to keep it exactly the same like ISRO system. And since the server is a LONG TERM server then we decided to add some events and features which will meet the needs of different and several players who have different point of views concerning having fun in a silkroad server.
We have dreamed of a server...
(¯`·.»{Divin-Online}»(Cap130/PvE»3Silk/Hour»AutoEquipment»New System»Open25/9)«.·`) 10/15/2013 - SRO PServer Advertising - 123 Replies http://i.imagebanana.com/img/kgeuxn1k/divinlogo.jp g
Welcome To Divin Online
We hope that you enjoy in our server Divin-Online
We have many new stuff like (Weapons,Items,Mobs,Pets,Towns and more...)
.
