[hellsong]

بسم الله الرحمن الرحيم








كنت عاوز شرح كوير FTW War Gold بمعني ايه الي يتغير واغيرو لايه
الكويري

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'