[Problem] wierd bug

02/03/2015 13:29 MissinGDeaTh#1
i got this procuder and it was working fine with the scroll before, but now here's the problem

[Only registered and activated users can see links. Click Here To Register...]

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 
02/03/2015 16:24 Muhab*#2
Different premium eh ?
Each premium got his own JobIDs so add those JobIDs to your query too!
02/03/2015 17:17 MissinGDeaTh#3
Quote:
Originally Posted by Muhab Ashraf View Post
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.