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>
26 lines
690 B
Transact-SQL
26 lines
690 B
Transact-SQL
----------------------------------------------------------------------------------------------------------------------
|
|
-- UpdateCharSpell.sql
|
|
----------------------------------------------------------------------------------------------------------------------
|
|
/*
|
|
캐릭터 스펠 정보 변경 프로시져
|
|
*/
|
|
|
|
|
|
CREATE PROCEDURE dbo.UpdateCharSpell
|
|
@char_uid AS INT, /* 캐릭터 고유 아이디 */
|
|
@C_Spell AS varBINARY(1664) /* 스펠 (128 * 13 = 1664) */
|
|
AS
|
|
|
|
SET NOCOUNT ON
|
|
|
|
IF EXISTS (SELECT CID FROM CharSpell WHERE CID = @char_uid)
|
|
BEGIN
|
|
UPDATE CharSpell SET Spell = @C_Spell WHERE CID = @char_uid
|
|
END
|
|
ELSE
|
|
BEGIN
|
|
INSERT INTO CharSpell(CID,Spell)
|
|
VALUES (@char_uid,@C_Spell)
|
|
END
|
|
GO
|
|
스펠 |