Producer Problem, please help

This producer only work if i have silk, but if i have 0 silk, it dosen't work.
please help!

if (@operation = 41) and (@itemrefid = 42702) begin declare @[Only registered and activated users can see links. Click Here To Register...]jid int;

set @[Only registered and activated users can see links. Click Here To Register...]jid = (select userjid from sro_vt_shard.._user where charid = @[Only registered and activated users can see links. Click Here To Register...]d);

if (select count(*) from sro_vt_account..sk_silk where jid = @[Only registered and activated users can see links. Click Here To Register...]jid) > 0

update sro_vt_account..sk_silk set silk_own = silk_own + 50 where jid = @[Only registered and activated users can see links. Click Here To Register...]jid; end

Are you really not able to do a simple change to this very simple query?
Seriously buddy, what have you learned so far over here these years asking questions over and over and over and over again?

You should start getting some SQL knowledge ... no offense, but this is just sad.

Quote:

Originally Posted by blapanda Are you really not able to do a simple change to this very simple query? Seriously buddy, what have you learned so far over here these years asking questions over and over and over and over again? You should start getting some SQL knowledge ... no offense, but this is just sad.

its sad to see the help section convert to advice section, thanks anyway i will do it by my self

#Request Topic Close please.