--Upgrade By #Khaled# -- DECLARE @WepRefID INT, @ArenaRefID INT, @OptLevel INT, @Data INT, @UP INT, @WepRefID2 INT
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 UPDATE _Items SET Data -= 200 WHERE ID64 = (SELECT ItemID FROM _Inventory WHERE CharID = @CharID and Slot = 15) END END
This might help you it needs a custom table and few modifications to this query. I am selling it so if you can't get this working I can't help you.
--Upgrade By #Khaled# --
DECLARE @WepRefID INT,
@ArenaRefID INT,
@OptLevel INT,
@Data INT,
@UP INT,
@WepRefID2 INT
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
UPDATE _Items SET Data -= 200 WHERE ID64 = (SELECT ItemID FROM _Inventory WHERE CharID = @CharID and Slot = 15)
END
END
This might help you it needs a custom table and few modifications to this query. I am selling it so if you can't get this working I can't help you.
can u send me ur skype then ? if u sell the upgrade scrolls
creating char works just fine when i create char with a unique name, BUT the problem start when i try to create a char with such existing name. it says Valid ID and get this ERROR :/
SHardManager - ODBC error while creating a new char 12/20/2016 - SRO Private Server - 10 Replies Hello !
I ve downloaded the Blue-Sro DB cuz it has a lot of good edits. I can make my char ,play etc... But when i make a new acc and try to make a new char i get an error in-game and at shardmaneger too. I tired it with 3-4 accs , sometimes it works but sometimes not and crash the shared manager.
I ve used db clearing queries , but still not working.
Please help me !
Thanks !
help me fix this error when creating patch!!! 02/09/2014 - Flyff Private Server - 9 Replies Help me fix this error please .
Img»Simple File Sharing and Storage.
Img»https://fbcdn-sphotos-b-a.akamaihd.net/hphoto s-ak-prn1/t1/15126_348198991985962_579784067_n.jpg
SMP error while creating account 11/01/2012 - Rappelz Private Server - 0 Replies SMP problem solved on my own *lol*
2nd LUA problem solved on my own, too XD
error while creating a new char 03/24/2012 - SRO Private Server - 2 Replies http://www10.0zz0.com/2012/03/23/22/244814214.jpg
error creating guild 03/22/2012 - Dekaron Private Server - 3 Replies every time I try to create guild'' says FAILED TO CREATE GUILD 'already restored the DB is more in the same things I've been editing each type before deleting manually give each guild did this annoying problem for my DB and Character.bak aloken I hope you can help me ...
![[Error] creating char error](https://www.elitepvpers.com/forum/iconimages/sro-private-server/error-creating-char-error_ltr.gif){kind=small}
