Quote:
Originally Posted by Aeron*
So you are trying to say that your shit is going to work? What if i put a return scroll in slot 13? Ofc your shit is going to switch it to a modeled weapon, so please go ahead and learn to code.
|
5hahahahaha ! now you improved that you can't even ready a coad !
Quote:
Originally Posted by _Miss_AngeL_
too much useless codes ?:@
create table _5ara with 2columns (RefitemID and NewRefItemID) you can add NewRefItemID2,3...etc if u have more modles
PHP Code:
DECLARE @ID64 int =(SELECT ID64 FROM _Inventory WHERE CharID = @CharID and Slot = 13)
DECLARE @RefItemID int=(SELECT RefItemID FROM _Items WHERE ID64 = @ID64)
DECLARE @NewItemID int =(SELECT NewRefItemID From _5ara WHERE RefItemID = @RefItemID)
update _Items set RefItemID = @NewRefItemID WHERE ID64=@ID64
Run brain.exe , i hope it's installed.
goodjob stroxy ;) keep it up ^^ and sorry for that shitty aeron's reply he just want to act like a pro but i will not give him this chance ;)
|
look at this part little noob ^^
PHP Code:
DECLARE @RefItemID int=(SELECT RefItemID FROM _Items WHERE ID64 = @ID64)
DECLARE @NewItemID int =(SELECT NewRefItemID From _5ara WHERE RefItemID = @RefItemID)
simply return scroll ID isn't in _5ara , so return scroll don't have NewRefItemID so the update line will not change anything !
as you improved that you can't understand codes , i'll explain it more..
PHP Code:
DECLARE @NewItemID int =(SELECT NewRefItemID From _5ara WHERE RefItemID = @RefItemID)
update _Items set RefItemID = @NewItemID WHERE ID64=@ID64
simply RefItemID of return scroll not in _5ara
so @NewItemID is empty declare
so it will update _items with no changes -_-
understood Mr.Brainless ? :facepalm: