LGram16
dd97ddec92
Move git root from Client/ to src/ to track all source code: - Client: Game client source (moved to Client/Client/) - Server: Game server source - GameTools: Development tools - CryptoSource: Encryption utilities - database: Database scripts - Script: Game scripts - rylCoder_16.02.2008_src: Legacy coder tools - GMFont, Game: Additional resources 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude <noreply@anthropic.com>
87 lines
1.8 KiB
Transact-SQL
87 lines
1.8 KiB
Transact-SQL
ALTER TABLE [TblCampInfo] ADD [tnSiegeCount] [tinyint] NULL
|
|
GO
|
|
|
|
ALTER TABLE [TblCampShopInfo] DROP COLUMN [TransferTime]
|
|
GO
|
|
|
|
DROP TABLE [TblCastleInfo]
|
|
GO
|
|
|
|
CREATE TABLE [TblCastleInfo] (
|
|
[nCastleID] [int] IDENTITY (1, 1) NOT NULL,
|
|
[nGuildID] [int] NULL,
|
|
[tnZone] [tinyint] NULL,
|
|
[tnChannel] [tinyint] NULL,
|
|
[tnName] [tinyint] NULL,
|
|
[tnSiegeCount] [tinyint] NULL,
|
|
[tnInvincibleCount] [tinyint] NULL,
|
|
[snTotalSiegeCount] [smallint] NULL,
|
|
[nTotalTaxMoney] [int] NULL,
|
|
[bRight] [varbinary] (10) NULL,
|
|
[fPosInX] [real] NULL,
|
|
[fPosInY] [real] NULL,
|
|
[fPosInZ] [real] NULL,
|
|
[fPosOutX] [real] NULL,
|
|
[fPosOutY] [real] NULL,
|
|
[fPosOutZ] [real] NULL,
|
|
[snItemID] [smallint] NULL,
|
|
[tnItemNum] [tinyint] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
CREATE TABLE [TblCastleTaxInfo] (
|
|
[nCastleID] [int] NULL,
|
|
[tnType] [tinyint] NULL,
|
|
[tnTax] [tinyint] NULL,
|
|
[nTempMoney] [int] NULL,
|
|
[nTaxMoney] [int] NULL,
|
|
[tnTaxChangable] [tinyint] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
CREATE TABLE [TblCastleMineralInfo] (
|
|
[nCastleID] [int] NULL ,
|
|
[snMineralID] [smallint] NULL ,
|
|
[snAmount] [smallint] NULL ,
|
|
[tnFlag] [tinyint] NULL
|
|
) ON [PRIMARY]
|
|
GO
|
|
|
|
|
|
DROP PROC USPCastleUpdate
|
|
GO
|
|
|
|
|
|
SET QUOTED_IDENTIFIER ON
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|
|
|
|
CREATE PROC USPCastleUpdate @nCastleID INT,@nGuildID INT,@tnSiegeCount TINYINT,
|
|
@tnInvincibleCount TINYINT,@snTotalSiegeCount SMALLINT,@nTotalTaxMoney INT,
|
|
@snItemID SMALLINT,@tnItemNum TINYINT
|
|
AS
|
|
SET NOCOUNT ON
|
|
|
|
DECLARE @RETURN INT
|
|
|
|
UPDATE TblCastleInfo
|
|
SET nGuildID = @nGuildID,tnSiegeCount = @tnSiegeCount,tnInvincibleCount = @tnInvincibleCount,
|
|
snTotalSiegeCount = @snTotalSiegeCount,nTotalTaxMoney = @nTotalTaxMoney,
|
|
snItemID = @snItemID,tnItemNum = @tnItemNum
|
|
WHERE nCastleID = @nCastleID
|
|
|
|
SET @RETURN = @@ROWCOUNT
|
|
|
|
SELECT @RETURN
|
|
|
|
|
|
|
|
GO
|
|
SET QUOTED_IDENTIFIER OFF
|
|
GO
|
|
SET ANSI_NULLS ON
|
|
GO
|
|
|