_AddTimedJob Procedure - Help me to fix it

[NagySandor96]

Hello,

I'm using vsro database, and wanna to create a lottery item by following speps of this

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?

CODE:

PHP Code:

if @ JobID = '35129') ------- JobID = RefSkill ID
   begin
declare @ charname6 varchar(64) 
Select @ charname6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @ CharID 
declare @ lottery Avatar varchar(129)
set @ lottery Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
    exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @ charname 6 @ lottery Avatar,1,0
   end 


Thnks,
NS

p.s.: there isn't any space nex to '@' in the PHP code

[Bizzyyyyy]

You are missing a '(' for your if function.

if (@JobID = '35129') ------- JobID = RefSkill ID
begin
declare @6 varchar(64)
Select @6=CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @D
declare @Avatar varchar(129)
set @Avatar = (SELECT TOP 1 GiftItems FROM SRO_VT_SHARD.dbo._LotteryNEWSTONE ORDER BY NEWID())
exec SRO_VT_SHARD.dbo._ADD_ITEM_EXTERN @6, @Avatar,1,0
end

The error message would be helpfull

[NagySandor96]

Here's a picture. Is it enough ?

[​Exo]

Originally Posted by NagySandor96

Here's a picture. Is it enough ?

ayy check your commas

[NagySandor96]

still the same error

[Bizzyyyyy]

remove the "end" after return @JobID and add a "," between your values...

[NagySandor96]

@ !
Everything works fine,but when I'm using the scroll in-game I dont get anything.
I guess the procedure isn't perfect. Could you help me? :/

#Problem has been solved
The correct Procedure which has to be added to SRO_VT_LOG>_AddLogItem Procedure

//attached the correct procedure//

[Spidy.]

^
Closed