搜索
 找回密码
 加入

User Program Check

serdar79us 2011-7-13 01:43:25 1452
indicates that the players used by the program

Used :   in game with game master   /plc NICK

Check the table from database MYST_CHECK
  1. CREATE TABLE [dbo].[MYST_CHECK](
  2.         [strAccountID] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  3.         [strUserId] [char](21) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  4.         [strProgram] [varchar](max) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
  5.         [UpdateTime] [datetime] NULL
  6. )
复制代码
  1. set ANSI_NULLS ON
  2. set QUOTED_IDENTIFIER ON
  3. go


  4. CREATE PROCEDURE [dbo].[INSERT_PROGRAM_CHECK_USER]
  5. @AccountID char(21),
  6. @CharID char(21),
  7. @Program varchar(1000)
  8. AS
  9. SET NOCOUNT ON;

  10. DELETE FROM MYST_CHECK WHERE STRACCOUNTID = @AccountID

  11. INSERT INTO MYST_CHECK (strAccountID,strUserId,strProgram,UpdateTime) VALUES (@AccountID,@CharID,replace(@Program, CHAR(13), ' '),GETDATE())
复制代码

2 回复

雪皓松松
2011-7-13 00:50:01
点击查看详情
看不明白。。。。
serdar79us
2011-7-13 01:43:25
楼主
我希望你知道我用谷歌翻译

游戏游戏高手“/ PLC,NICK”的人,显示如果用户使用的程序。
高级模式
游客