indicates that the players used by the program
Used : in game with game master /plc NICK
Check the table from database MYST_CHECK- CREATE TABLE [dbo].[MYST_CHECK](
- [strAccountID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
- [strUserId] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
- [strProgram] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
- [UpdateTime] [datetime] NULL
- )
复制代码- set ANSI_NULLS ON
- set QUOTED_IDENTIFIER ON
- go
- CREATE PROCEDURE [dbo].[INSERT_PROGRAM_CHECK_USER]
- @AccountID char(21),
- @CharID char(21),
- @Program varchar(1000)
- AS
- SET NOCOUNT ON;
- DELETE FROM MYST_CHECK WHERE STRACCOUNTID = @AccountID
- INSERT INTO MYST_CHECK (strAccountID,strUserId,strProgram,UpdateTime) VALUES (@AccountID,@CharID,replace(@Program, CHAR(13), ' '),GETDATE())
复制代码 |