Jump to content
Addicted2 Romania
Aplicatiile pentru functia de "Helper" pentru serverul de Minecraft sunt deschise !

Cum Fixezi Eroarea :"error-L1 : Closeclient Invalid_Socket"


Recommended Posts

Exemplu Eroare


17:00:32 connect : [4806][]17:00:33 connect : [4807][]17:00:43 connect : [4808][]17:00:53 (4803)logout : []error-L1 : CloseClient INVALID_SOCKET17:00:53 connect : [4809][]error-L1 : CloseClient INVALID_SOCKET17:00:56 connect : [4810][]17:00:57 connect : [4811][]17:00:59 join send : (4811)maxxxxerror-L1 : CloseClient INVALID_SOCKET17:00:59 login [] : [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]

[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]


Link to comment
Share on other sites

This topic is now closed to further replies.
  • Create New...