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>
40 lines
609 B
Transact-SQL
40 lines
609 B
Transact-SQL
|
|
ALTER TABLE TblGuildInfo
|
|
ADD tChangeState SMALLDATETIME
|
|
|
|
GO
|
|
|
|
UPDATE TblGuildInfo
|
|
SET tnNationType = 101
|
|
WHERE tnNationType = 0
|
|
|
|
GO
|
|
|
|
UPDATE TblGuildInfo
|
|
SET tnNationType = 105
|
|
WHERE tnNationType = 1
|
|
|
|
GO
|
|
|
|
-- ADD Equip column
|
|
ALTER PROCEDURE dbo.GetCharInfo
|
|
@UID AS INT
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
SELECT UID, Name, Sex, Hair, Face, Nationality, Class, Fame, Mileage, Guild, Party, Level, Gold, IP, STR, DEX, CON, Intell, WIS, HP, MP,
|
|
Exp , Chance,Equip
|
|
FROM CharInfo WHERE UID = @UID
|
|
|
|
GO
|
|
|
|
-- add nCampID
|
|
ALTER TABLE TblGuildMember
|
|
ADD nCampID INT default(0)
|
|
|
|
GO
|
|
|
|
update TblGuildMember
|
|
set nCampID = 0
|