csgo准星大小怎么改:如何解决红月战争问题

现在全是SF你去找GM商量吧!!@!@@!@@@!!@

建军后可以直接打仗的脚本

CREATE PROCEDURE RMS_ARMY_FINISHCREATEARMY
@Camp tinyint,
@ID int

AS
set nocount on

begin transaction RMS_ARMY_FINISHCREATEARMY

declare @ActivityDate datetime
declare @State int
set @ActivityDate=DateAdd(month,1,getdate())

select @State=State from tblArmyList1 where Camp=@Camp AND ID=@ID
if @@RowCount!=0 and @State<-1
begin
update tblArmyList1 set State=1,CreateTime=DateDiff(day,7,getdate()),ActivityPeriod=@ActivityDate where Camp=@Camp AND ID=@ID
EXEC RMS_ARMY_WRITEARMYLOG @ArmyID=@ID,@LogKind=\'ArmyCreation\'
end

commit transaction RMS_ARMY_FINISHCREATEARMY
GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

-------------------------------------------------------------------------------------------------------------

战争结束后可以直接宣战脚本

CREATE PROCEDURE RMS_ARMY_ENDWAR
@ArmyID1 int,
@ArmyID2 int

AS
set nocount on

begin transaction RMS_ARMY_ENDWAR

update tblArmyWarList1 set WarState=4 where (ArmyID=@ArmyID1 or ArmyID=@ArmyID2)
if @@ROWCOUNT!=0
begin
EXEC RMS_ARMY_WRITEWARLOG @ArmyID1=@ArmyID1,@ArmyID2=@ArmyID2,@LogKind=\'WarEnd\'
DECLARE @AllianceID1 int
DECLARE @AllianceID2 int
SET @AllianceID1=0
SET @AllianceID2=0

SELECT @AllianceID1=AllianceID FROM tblArmyAllianceList1 WHERE ArmyID=@ArmyID1
IF @AllianceID1=0
BEGIN
DELETE tblHiredSoldierList1 WHERE ArmyID=@ArmyID1
END
ELSE
BEGIN
DELETE tblHiredSoldierList1 WHERE ArmyID in (SELECT ArmyID FROM tblArmyAllianceList1 WHERE AllianceID=@AllianceID1)
END
SELECT @AllianceID1

SELECT @AllianceID2=AllianceID FROM tblArmyAllianceList1 WHERE ArmyID=@ArmyID2
IF @AllianceID2=0
BEGIN
DELETE tblHiredSoldierList1 WHERE ArmyID=@ArmyID2
END
ELSE
BEGIN
DELETE tblHiredSoldierList1 WHERE ArmyID in (SELECT ArmyID FROM tblArmyAllianceList1 WHERE AllianceID=@AllianceID2)
END
SELECT @AllianceID2
end

DELETE FROM tblArmyWarListLog1 where (ArmyID1=@ArmyID1 or ArmyID1=@ArmyID2) AND (ArmyID2=@ArmyID1 or ArmyID2=@ArmyID2)

commit transaction RMS_ARMY_ENDWAR
GO

-------------------------------------------------------------------------------------------------------------

退军直接可以加军简脚本

CREATE PROCEDURE RMS_ARMY_ADDREJOINSANCTION
@GameID varchar(14)
AS
set nocount on

begin transaction RMS_ARMY_ADDREJOINSANCTION

DELETE FROM tblArmyJoinSanctionList1 WHERE GameID=@GameID

commit transaction RMS_ARMY_ADDREJOINSANCTION

GO

SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO