[Problem] wierd bug

[MissinGDeaTh]

i got this procuder and it was working fine with the scroll before, but now here's the problem



procuder

PHP Code:

If  @ItemRefID = '69669' ---Remove Premium ----
Begin
DELETE FROM SRO_VT_SHARD.._TimedJob WHERE JobID in (67974,9278,67974,29723,35567,35567,35567,35567,9278,35567,5412,68083,68083,68083,68083,9278,68083,59695) AND CharID = @CharID
End 


_AddTimedJob for the char

PHP Code:

2547    17578    5    36754    1425385063    1111902513    3847    0    0    0    0    0    0    72339069018693575    0
2548    17578    5    36754    1425385063    1430866993    3783    86400    1423052263    65537    0    0    0    72339069018693575    0
2549    17578    5    36754    1425385063    1430866993    3769    86400    1423052263    196611    0    0    0    72339069018693575    0
2550    17578    5    36754    1425385063    1430866993    3795    86400    1423052263    196611    0    0    0    72339069018693575    0
2552    17578    5    36754    1425385063    1431391281    224    2419200    1425385063    262148    0    0    0    72339069018693575    0 


[Muhab*]

Different premium eh ?
Each premium got his own JobIDs so add those JobIDs to your query too!

[MissinGDeaTh]

Originally Posted by Muhab Ashraf

Different premium eh ?
Each premium got his own JobIDs so add those JobIDs to your query too!

here's the deal, i added IT.
those rows are from _AddTimedJob, has the JobID from the premium it wont be removed.