PHP Code:
USE [SRO_VT_SHARD]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Made By: <Nukertube>
-- Edit By : <CoderWaxy>
-- Create date: <getdata ()>
-- Description: <Varchar (128)>
-- New: <ADD CT FTW Gold>
-- Work : <Tested By Me>
-- =============================================
CREATE PROCEDURE [dbo].[_PayGoldFT]
--------------------------
@Gold BIGINT
--------------------------
AS
BEGIN
SET NOCOUNT ON;
DECLARE
@Fw1 Varchar(max),
@Fw2 Varchar(max),
@Fw3 Varchar(max),
@Fw4 Varchar(max),
@G1 Varchar(max),
@G2 Varchar(max),
@G3 Varchar(max),
@G4 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 @Fw4 =(SELECT[GuildID]FROM[dbo].[_SiegeFortress]WHERE[FortressID]=4)
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)
SET @G4=(SELECT[Name]FROM[dbo].[_Guild]WHERE[ID]=@Fw4)
----------------------
UPDATE[dbo].[_Guild]
SET[Gold]=@Gold
WHERE[ID]=@Fw1
OR[ID]=@Fw2
OR[ID]=@Fw3
OR[ID]=@Fw4
PRINT 'Fortress war gold paid! Guilds winners: '+@G1+', '+@G2+', '+@G3+', '+@G4
----------------------
END
GO
EXEC _PayGoldFT '50000000000'
This Query USE FOR CT FTW not For bandit and hotan and jangan fortress only for 4 fortress war
Like IF it help you 
Where posts?
Reply With Quote
Originally Posted by denise456
