| hellsong |
23-10-2014 01:30 PM |
qurey
بسم الله الرحمن الرحيم
كنت عاوز شرح كوير 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'
:mf_swordfight: |
