[Release] Upgrade Scroll/Message

[​Exo]

Originally Posted by Syloxx

so explain me please why u said "@Gold is already declared in a Procedure"

looks like u didn't know that @Gold in _AddLogItem isn't for the character gold ?

What if .... you set the Gold to the character gold when the scroll is used..

[Syloxx]

Originally Posted by xExorcist

What if .... you set the Gold to the character gold when the scroll is used..

NEVER use the same variable for 2 different values ​​that have nothing to do with each other LOL

and please... please don't ask why

[KingDollar]

good a new flame war

[asanoftw]

Originally Posted by xExorcist

Since everyone acted like a pro.. and started commenting on the old shit..here's the Ready To Use Lines...
Simply this shit will get the RefID Of the items and compare them to a table if the ID exists it will change it to another one..
Table name in this example is Upgrade columns Are Req/Up

--Upgrade By #Khaled# --
DECLARE  @WepRefID INT,
         @ArenaRefID INT,
         @OptLevel INT,
         @Data INT,
         @UP INT,
         @WepRefID2 INT
         
         
         be cool man be cool shit shit shit shit
         
         SELECT @WepRefID = I.RefItemID
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         SELECT @WepRefID2 = I.ID64
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         
         SELECT @ArenaRefID = I.RefItemID
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=15
         
         SELECT @OptLevel = I.OptLevel
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON INV.ItemID =I.ID64
         WHERE CharID =@CharID AND Inv.Slot=13
         
         SELECT @Data = I.Data
         FROM SRO_VT_SHARD.._Inventory Inv
         INNER JOIN SRO_VT_SHARD.._Items I
         ON Inv.ItemID = I.ID64
         WHERE CharID = @CharID AND Inv.Slot=15
         
         SET @UP = (SELECT UP FROM Upgrade Where Req =@WepRefID)

IF EXISTS (SELECT * FROM SRO_VT_SHARD..Upgrade WHERE Req =@WepRefID)
BEGIN
If ( @OptLevel =8 And @Gold >=50000000000 AND @ArenaRefID='25834' AND @Data>=100)--Staff
BEGIN
UPDATE _Items SET RefItemID = @Up ,OptLevel=0 WHERE ID64=@WepRefID2
UPDATE _Char SET RemainGold =RemainGold-50000000000 WHERE CharID=@CharID
EXEC SRO_VT_SHARD.._STRG_DEL_ITEM_NoTX 1,@CharID,15
END
END

Edit this to match how you will use it.. but i guess you got the point..

be cool man be cool shit shit shit shit

[kingman77778]

thanks

[*-S.1T]

Thx for this release

[ipause]

good job