Demoo Posted November 28, 2011 Share Posted November 28, 2011 Exemplu Eroare 17:00:32 connect : [4806][201.255.22.210]17:00:33 connect : [4807][190.224.207.143]17:00:43 connect : [4808][201.250.238.79]17:00:53 (4803)logout : [201.250.190.27]error-L1 : CloseClient INVALID_SOCKET17:00:53 connect : [4809][190.224.207.253]error-L1 : CloseClient INVALID_SOCKET17:00:56 connect : [4810][200.29.248.26]17:00:57 connect : [4811][201.254.76.67]17:00:59 join send : (4811)maxxxxerror-L1 : CloseClient INVALID_SOCKET17:00:59 login [201.254.76.67] : [maxxxx] numer:12791/ db:117:00:59 [maxxxx][] BillType : (3) Fix Eror-Query Analyzer if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[MEMB_STAT_GJ]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)drop table [dbo].[MEMB_STAT_GJ]GO[/b][b]CREATE TABLE [dbo].[MEMB_STAT_GJ] ([memb___id] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,[name] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,[ServerName] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[ServerCode] [int] NULL ,[IP] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,[TM] [datetime] NULL) ON [PRIMARY]GO[/code] [/b] [b][CODE]if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[WZ_CONNECT_MEMB]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)drop procedure [dbo].[WZ_CONNECT_MEMB]GO[/b][b]SET QUOTED_IDENTIFIER ONGOSET ANSI_NULLS OFFGO[/b][b]CREATE PROCEDURE WZ_CONNECT_MEMB@uid varchar(10),@server varchar(20),@uip varchar(20)AS[/b][b]Begin[/b][b]BEGIN TRANSACTION[/b][b]SET NOCOUNT ON[/b][b]IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )BeginUPDATE MEMB_STATSET ip = @uip , connectstat = 1 , servername = @server , ConnectTM = (getdate())WHERE memb___id = @uidEndELSEBeginINSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername)valueS (@uid,@uip,1,@server )EndIF(@@Error <> 0 )ROLLBACK TRANSACTIONELSECOMMIT TRANSACTION[/b][b]--写入登录记录IF EXISTS ( SELECT UserID FROM UserLogin WITH (READUNCOMMITTED) WHERE UserID = @uid )BeginUPDATE UserLoginSET LoginIP=@uip,Server=@server,LoginTM = (getdate()),OnlineSec=0,GiveMoney=0,logoutTM=nullWHERE UserID = @uidEndELSEBeginINSERT INTO UserLogin (UserID,LoginIP,Server,LoginTM,OnlineSec,GiveMoney )values (@uid,@uip,@server,getdate(),0,0)End--自动封服务器不准进入的人物declare @SmallestZS intdeclare @LargestZS intdeclare @Type intselect @Type=Type from SetServerList where ServerName=@server[/b][b]if (@Type>0) begin[/b][b]select @SmallestZS=Smallest_ZS from SetServerList where ServerName=@serverselect @LargestZS=Largest_ZS from SetServerList where ServerName=@server[/b][b]if not (@SmallestZS is null) beginupdate character set ctlcode=(ctlcode | 0x81) where [name] not in(SELECT NAME FROM WEB_ZS WHERE (ACC = @uid) AND (ZSCS >= @LargestZS) AND (ZSCS <= @SmallestZS)) AND (AccountID = @uid)endendDELETE FROM MEMB_STAT_GJ WHERE (memb___id = @uid and servername=@server)update character set ctlcode=(ctlcode | 0x81) where [name] in(SELECT name FROM MEMB_STAT_GJ WHERE (memb___id = @uid)) AND (AccountID = @uid)[/b][b]SET NOCOUNT OFFEndGOSET QUOTED_IDENTIFIER OFFGOSET ANSI_NULLS ONGO[/code][/b] Link to comment Share on other sites More sharing options...
Recommended Posts