Query for Pay FTW Gold in Guild Storage

PHP Code:

---

USE [SRO_VT_SHARD]
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:        <Nukertube>
-- 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

PHP Code:

---

EXEC _PayGoldFTW '50000000000' 


---

http://img259.imageshack.us/img259/5585/semttuloglw.png

This change the gold which i take it for win in FTW ?

Nice query :):

xD Ty

AweSome

Change it to coins or something :P ... thanks

yes for example Anything except Gold like ' Gold coin , Arena , etc '

ok Bro
i will try ^^

Can you please make a query for only constantinople fortress war, I mean make query give gold to only constantinople fw , waiting you

Nukertube Welcome Back

http://forum.ragezone.com/f722/nucke...w-good-923901/

Pay Constantinople too

Query For CT only

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

    @Fw4 Varchar(max),
    @G4 Varchar(max)
    SET @Fw4 =(SELECT[GuildID]FROM[dbo].[_SiegeFortress]WHERE[FortressID]=4)
    SET @G4=(SELECT[Name]FROM[dbo].[_Guild]WHERE[ID]=@Fw4)
     ----------------------
    UPDATE[dbo].[_Guild]
    SET[Gold]=@Gold
    WHERE[ID]=@Fw4
    PRINT 'Fortress war gold paid! Guilds winners: '+@G4
    Print 'Thanks For your Trust guys XD "NuckerTube"'
    ----------------------
END
GO  
EXEC _PayGoldFT '50000000000' 


---

Nice query, but i have one request. EXEC _PayGoldFT 'PRICE'. is the gold of win for FTW?. can not be just the gold that has met the FTW? or another query to make it so? thanks you

i want it to get paid automatically -_-
like make the stored procedure set the gold FTW = @Gold when the DB Get updated with the latest winner of FTW
i will work on that but good one :P: