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>
73 lines
2.0 KiB
Transact-SQL
73 lines
2.0 KiB
Transact-SQL
|
|
CREATE TABLE dbo.TblIWebItemInfo
|
|
(
|
|
CreateID INT IDENTITY(1,1) PRIMARY KEY
|
|
, UID INT
|
|
, CID INT
|
|
, ItemPrototypeID SMALLINT
|
|
, Amount TINYINT
|
|
, MIN_DAMAGE TINYINT CHECK (MIN_DAMAGE IN (0,1,2,3,4,5,6))
|
|
, MAX_DAMAGE TINYINT CHECK (MAX_DAMAGE IN (0,1,2,3,4,5,6))
|
|
, ARMOR TINYINT CHECK (ARMOR IN (0,1,2,3,4,5,6))
|
|
, HIT_RATE TINYINT CHECK (HIT_RATE IN (0,1,2,3,4,5,6))
|
|
, EVADE TINYINT CHECK (EVADE IN (0,1,2,3,4,5,6))
|
|
, MAX_HP TINYINT CHECK (MAX_HP IN (0,1,2,3,4,5,6))
|
|
, HP_REGEN TINYINT CHECK (HP_REGEN IN (0,1,2,3,4,5,6))
|
|
, MAX_MP TINYINT CHECK (MAX_MP IN (0,1,2,3,4,5,6))
|
|
, MP_REGEN TINYINT CHECK (MP_REGEN IN (0,1,2,3,4,5,6))
|
|
, CRITICAL TINYINT CHECK (CRITICAL IN (0,1,2,3,4,5,6))
|
|
, BLOCK TINYINT CHECK (BLOCK IN (0,1,2,3,4,5,6))
|
|
, SPEED TINYINT CHECK (SPEED IN (0,1,2,3,4,5,6))
|
|
, MAGIC_POWER TINYINT CHECK (MAGIC_POWER IN (0,1,2,3,4,5,6))
|
|
, MAGIC_RESIST TINYINT CHECK (MAGIC_RESIST IN (0,1,2,3,4,5,6))
|
|
, ItemUID BIGINT NOT NULL DEFAULT(0)
|
|
)
|
|
|
|
GO
|
|
|
|
CREATE INDEX IDX_TblIWebItemInfo_U_CID ON dbo.TblIWebItemInfo (UID,CID)
|
|
|
|
GO
|
|
|
|
CREATE INDEX IDX_TblIWebItemInfo_ItemUID ON dbo.TblIWebItemInfo (ItemUID)
|
|
|
|
GO
|
|
|
|
CREATE Proc dbo.GetUserCharInfo_Web @UID INT
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
--출력 예전 서버군ID / CID / 이름 / 클래스 / 레벨 / 명성 / 마일리지
|
|
DECLARE @TblReports TABLE
|
|
(
|
|
OldServerGroupID INT
|
|
, CID INT
|
|
)
|
|
|
|
INSERT INTO @TblReports
|
|
SELECT OldServerGroupID,Char1 FROM UserInfo WHERE UID = @UID and Char1 > 0
|
|
|
|
INSERT INTO @TblReports
|
|
SELECT OldServerGroupID,Char2 FROM UserInfo WHERE UID = @UID and Char2 > 0
|
|
|
|
INSERT INTO @TblReports
|
|
SELECT OldServerGroupID,Char3 FROM UserInfo WHERE UID = @UID and Char3 > 0
|
|
|
|
INSERT INTO @TblReports
|
|
SELECT OldServerGroupID,Char4 FROM UserInfo WHERE UID = @UID and Char4> 0
|
|
|
|
INSERT INTO @TblReports
|
|
SELECT OldServerGroupID,Char5 FROM UserInfo WHERE UID = @UID and Char5 > 0
|
|
|
|
SELECT OldServerGroupID,A.CID,Name,Class,Level,Fame,Mileage
|
|
FROM @TblReports A JOIN CharInfo B ON A.CID = B.CID
|
|
ORDER BY OldServerGroupID
|
|
|
|
|
|
|
|
GO
|
|
|
|
|
|
|