USE [SRO_VT_SHARD] SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO -- ============================================= -- Author: <Zidane> -- Create date: <getdata ()> -- Description: <Varchar (128)> -- ============================================= CREATE PROCEDURE [dbo].[_PayGoldFTW] -------------------------- @Gold BIGINT -------------------------- AS BEGIN SET NOCOUNT ON; DECLARE @Fw1 Varchar(max), @Fw2 Varchar(max), @Fw3 Varchar(max), @G1 Varchar(max), @G2 Varchar(max), @G3 Varchar(max) SET @Fw1 =(SELECT[GuildID]FROM[dbo].[_SiegeFortress]WHERE[FortressID]=1) SET @Fw2 =(SELECT[GuildID]FROM[dbo].[_SiegeFortress]WHERE[FortressID]=3) SET @Fw3 =(SELECT[GuildID]FROM[dbo].[_SiegeFortress]WHERE[FortressID]=6) SET @G1=(SELECT[Name]FROM[dbo].[_Guild]WHERE[ID]=@Fw1) SET @G2=(SELECT[Name]FROM[dbo].[_Guild]WHERE[ID]=@Fw2) SET @G3=(SELECT[Name]FROM[dbo].[_Guild]WHERE[ID]=@Fw3) ---------------------- UPDATE[dbo].[_Guild] SET[Gold]=@Gold WHERE[ID]=@Fw1 OR[ID]=@Fw2 OR[ID]=@Fw3 PRINT 'Fortress war gold paid! Guilds winners: '+@G1+', '+@G2+', '+@G3 ---------------------- END GO
EXEC _PayGoldFTW '50000000000'