Call a Table [shop.gold] to a Job

[x0814328]

Hi
I have a Job, that makes each time a player gain a Master Reset he gains 1000golds but I can't call the table [Shop.gold] to my job.

My [Shop.gold] have this columns:

memb__id
gold

My JOB:

UPDATE Character
Set MasterReset=MasterReset+1 
From Character Join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Resets=100 AND Memb_Stat.ConnectStat = 0 and CtlCode=0 and MasterReset=0

I need to give 1000 golds for each player to reach the 100 reset.

Please somebody help me

[MentaL]

[DragonSeth]

Gold credits or zen?? im confuse

[x0814328]

Gold credits

[x0814328]

Please somebody help me ... I search on google but I can't resolve this problem alone because I dont understand SQL a lot.

[2009x2014]

Select & decleare @account 4 insert credits ?

Btw use collate database default if you have conflict in join querys.

[x0814328]

I just want to give 1000 credits for each player to reach the 100 reset but I dont want to put all accounts...

I want a thing like this (using my job)

UPDATE Character
Set MasterReset=MasterReset+1 
From Character Join Memb_Stat on Character.Accountid=Memb_Stat.memb___id
collate Latin1_general_CI_AS
WHERE Resets=100 AND Memb_Stat.ConnectStat = 0 and CtlCode=0 and MasterReset=0

"and UPDATE shop.gold
Set credits=credits+1000 "

[x0814328]

Use MuOnline
DECLARE @ConnectStattinyint DECLARE @memb___id varchar (10) SELECT @memb___id=memb___id,@ConnectStat=ConnectStat FROM memb_stat WHERE ConnectStat='1' UPDATE shop.gold SET credits=credits+15 where login=@memb___id

Something like this @4FUNer????