1 fortres tax all town i need help

[anapse]

i need 1 fortres example hotan and all city pay tax for 1 fortre

i have 1proced is

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_get_fortress]    Script Date: 07/02/2013 12:24:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_get_fortress]
AS
BEGIN
DECLARE @JName VARCHAR(32)
DECLARE @HName VARCHAR(32)
DECLARE @BName VARCHAR(32)
DECLARE @JTaxRatio INT
DECLARE @HTaxRatio INT
DECLARE @BTaxRatio INT
DECLARE @JGuildID INT
DECLARE @HGuildID INT
DECLARE @BGuildID INT

  select  @JGuildID=GuildID , @JTaxRatio =TaxRatio from _SiegeFortress where FortressID = 1
	select  @HGuildID=GuildID , @HTaxRatio =TaxRatio from _SiegeFortress where FortressID = 3
	select  @BGuildID=GuildID , @BTaxRatio =TaxRatio from _SiegeFortress where FortressID = 6
	select @JName=Name from _Guild where ID = @JGuildID
	select @HName=Name from _Guild where ID = @HGuildID
	select @BName=Name from _Guild where ID = @BGuildID

 SELECT @JName, @JTaxRatio, @HName, @HTaxRatio, @BName, @BTaxRatio
END

if i modif for

USE [SRO_VT_SHARD]
GO
/****** Object:  StoredProcedure [dbo].[_get_fortress]    Script Date: 07/02/2013 12:24:47 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[_get_fortress]
AS
BEGIN
DECLARE @JName VARCHAR(32)
DECLARE @HName VARCHAR(32)
DECLARE @BName VARCHAR(32)
DECLARE @JTaxRatio INT
DECLARE @HTaxRatio INT
DECLARE @BTaxRatio INT
DECLARE @JGuildID INT
DECLARE @HGuildID INT
DECLARE @BGuildID INT

  select  @JGuildID=GuildID , @JTaxRatio =TaxRatio from _SiegeFortress where FortressID = 3
	select  @HGuildID=GuildID , @HTaxRatio =TaxRatio from _SiegeFortress where FortressID = 3
	select  @BGuildID=GuildID , @BTaxRatio =TaxRatio from _SiegeFortress where FortressID = 3
	select @JName=Name from _Guild where ID = @JGuildID
	select @HName=Name from _Guild where ID = @HGuildID
	select @BName=Name from _Guild where ID = @BGuildID

 SELECT @JName, @JTaxRatio, @HName, @HTaxRatio, @BName, @BTaxRatio
END

is good?

[MentaL]

[anapse]

no help me? ok THX

[BadFist]

you need to put taxe manualy at each npc...

[anapse]

you need to put taxe manualy at each npc...

all gold for 1 fortre ?

i need all gold go 1 fortre

[BadFist]

yes you need to put only in dw,sm,alexn/s and const. bcz if you put only 1 fw taxe from jangan,bandit are going to hotan...(is a example)