[request] Query add silk by guild name.

02/20/2020 17:40 TEVEZ_7#1

as a title said I need a query to add silk to guild members by guild name I searched and tried to make it by self but failed.
so i'm sure here I can found who can make it .
thx in adv.

Edit

this one work well

Spoiler

special thanks to @[Only registered and activated users can see links. Click Here To Register...]

02/20/2020 18:11 Devsome#2

Show us your tries, so we can help you

02/20/2020 18:22 sonzenbi#3

I think this will work

Spoiler

02/20/2020 20:46 TEVEZ_7#4

Quote:

Originally Posted by sonzenbi

I think this will work

Spoiler

declare @[Only registered and activated users can see links. Click Here To Register...] int = 100
declare @[Only registered and activated users can see links. Click Here To Register...] varchar(64) = 'VSRO'
update SRO_VT_ACCOUNT..SK_Silk set silk_own += @[Only registered and activated users can see links. Click Here To Register...] from SRO_VT_ACCOUNT..SK_Silk s
inner join SRO_VT_SHARD.._User u on u.UserJID = s.JID
inner join SRO_VT_SHARD.._GuildMember g on g.CharID = u.CharID
inner join SRO_VT_SHARD.._Guild gj on gj.ID = g.GuildID where gj.Name = @[Only registered and activated users can see links. Click Here To Register...]

that is it I was miss a small thing thank you !