Producer Problem, please help

[devdash]

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 @jid int;

set @jid = (select userjid from sro_vt_shard.._user where charid = @d);

if (select count(*) from sro_vt_account..sk_silk where jid = @jid) > 0

update sro_vt_account..sk_silk set silk_own = silk_own + 50 where jid = @jid; end

[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.

[devdash]

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.