 |
|
| Mr Z!dane |
09-04-2013 12:25 PM |
Query For FTW Gold
كود PHP:
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
كود PHP:
EXEC _PayGoldFTW '50000000000'
http://img259.imageshack.us/img259/5585/semttuloglw.png
مــنقــول ! |
Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions, Inc.