i want help in Fix Procedure 08/19/2018 - SRO Private Server - 5 Replies IF (@Operation = 41) -- If item used!
BEGIN
IF(@ItemRefID = '62745') +1 Plus Scroll
Declare miavOpt int
Declare melonewOpt int
Select miavOpt = OptLevel From SRO_VT_SHARD..dbo._Items Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = ChariD and Slot = '13' and ItemID>0)
Set melonewOpt = miavOpt+1)
Update SRO_VT_SHARD.dbo._Items Set OptLevel = melonewOpt Where ID64 = (Select ItemID From SRO_VT_SHARD.._Inventory Where CharID = ChariD and Slot =...
_AddTimedJob Procedure - Help me to fix it 08/17/2016 - SRO Private Server - 7 Replies Hello,
I'm using vsro database, and wanna to create a lottery item by following speps of this thread
I've successfully done every step, only have a prob with making the AddTimedJob Procedure well. I've made a simple copy + paste with a bit editing of @ JobID,but it doesn't work.
Guys, could any of you help me how I should fix it? :confused:
CODE: if @ JobID = '35129') ------- JobID = RefSkill ID
begin
SRO Private Server -> SRO PServer Quest…
