[Release] DarksTeam MuServer 0.99.60/62T (1.0M) Beta 15

linkzero

Member
Joined
Jun 16, 2015
Messages
61
Reaction score
2
I have problem with windows start up

error-L1 : CloseClient INVALID_SOCKET"

Example of gameserver log:

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_SOCKET
17:00:53 connect : [4809][190.224.207.253]
error-L1 : CloseClient INVALID_SOCKET
17:00:56 connect : [4810][200.29.248.26]
17:00:57 connect : [4811][201.254.76.67]
17:00:59 join send : (4811)maxxxx
error-L1 : CloseClient INVALID_SOCKET
17:00:59 login [201.254.76.67] : [maxxxx] numer:12791/ db:1
17:00:59 [maxxxx][] BillType : (3)
U need use this jobs in Query Analizer to fix it.

-----------------------------x-----------------------

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

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

------------------------------------------x-------------------------

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

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS OFF
GO

CREATE PROCEDURE WZ_CONNECT_MEMB
@uid varchar(10),
@server varchar(20),
@uip varchar(20)
AS

Begin

BEGIN TRANSACTION

SET NOCOUNT ON

IF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED) WHERE memb___id = @uid )
Begin
UPDATE MEMB_STAT
SET ip = @uip , connectstat = 1 , servername = @server , ConnectTM = (getdate())
WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ip,connectstat,servername)
valueS (@uid,@uip,1,@server )
End
IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE
COMMIT TRANSACTION

--写入登录记录
IF EXISTS ( SELECT UserID FROM UserLogin WITH (READUNCOMMITTED) WHERE UserID = @uid )
Begin
UPDATE UserLogin
SET LoginIP=@uip,Server=@server,LoginTM = (getdate()),OnlineSec=0,GiveMoney=0,logoutTM=null
WHERE UserID = @uid
End
ELSE
Begin
INSERT INTO UserLogin (UserID,LoginIP,Server,LoginTM,OnlineSec,GiveMoney )
values (@uid,@uip,@server,getdate(),0,0)
End
--自动封服务器不准进入的人物
declare @SmallestZS int
declare @LargestZS int
declare @Type int
select @Type=Type from SetServerList where ServerName=@server

if (@Type>0) begin

select @SmallestZS=Smallest_ZS from SetServerList where ServerName=@server
select @LargestZS=Largest_ZS from SetServerList where ServerName=@server

if not (@SmallestZS is null) begin
update 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)
end
end
DELETE 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)

SET NOCOUNT OFF
End
GO
SET QUOTED_IDENTIFIER OFF
GO
SET ANSI_NULLS ON
GO

i test with there querry but i have another problem at use.

Server: Msg 446, Level 16, State 9, Procedure WZ_CONNECT_MEMB, Line 61
Cannot resolve collation conflict for equal to operation.

I have vps with Windows server 2008 r2 enterprice sp1
Sql server 2008 r2 enterprice
 
Last edited:

yuritarsis

New Member
Joined
May 4, 2012
Messages
24
Reaction score
1
USE SQL 2000!

I have problem with windows start up

error-L1 : CloseClient INVALID_SOCKET"



i test with there querry but i have another problem at use.

Server: Msg 446, Level 16, State 9, Procedure WZ_CONNECT_MEMB, Line 61
Cannot resolve collation conflict for equal to operation.

I have vps with Windows server 2008 r2 enterprice sp1
Sql server 2008 r2 enterprice


USE SQL 2000!
 

lxdidai

New Member
Joined
Jul 8, 2015
Messages
11
Reaction score
0
DarkMaster , Does it support Chs?

When you create a role, Can not use Chinese character name for game.

Please help me , thank you very much!
 

linkzero

Member
Joined
Jun 16, 2015
Messages
61
Reaction score
2
Искам да благодаря на Дарк за страхотните файлове , и реших и аз малко да помогна. Не е кой знае какво но подредих малко gate.txt & monster.txt за да са по лесни за разбиране !

use ur gate and gameserver.exe standby on white... and no respond.
 

Urban

Member
Joined
Oct 18, 2013
Messages
46
Reaction score
10
hi, i have this problem 14.07: error-L3 : 10054 (D:\WORK\MU_UNICODE_WORK\MuGameServer\SOURCE\wsJoinServerCli.cpp 131


:c help me please
 

lxdidai

New Member
Joined
Jul 8, 2015
Messages
11
Reaction score
0
如何让游戏服务端支持CHS,创建中文角色名称? Link大师,@linkzero
 

linkzero

Member
Joined
Jun 16, 2015
Messages
61
Reaction score
2
GameServer Log:
WSARecv[] failed with error 10038.


So i will get started with simple information.
Fist to get you know about this error.
This error will appear on your gameserver window if you :
1. Attack monsters and got disconnect
2. Try move to other map
3. Try login ingame

So let's see what are this problems 1 by 1, i will tell you details how to check them easy.
First you will need to get to this error in your gameserver window. Then you can follow this steps

1. Attack Monsters and got disconnect
- This problems appears when your attack speed is overlimit and got detected as hack speed.
To fix this problem you will need to open Data/commonserver.cfg and Edit Anti Hack Configs
2. Try move to other map
- This problems appears when you try move for example Crywolf, but your character isnt teleported, and after you move the character you got disconnect and this error appears in gameserver window.
To fix this you will open Data/MapServerInfo.dat
And delete the Map Settings, it must be like this

Code:
0
	0		0		1		SIPHere	55901
	9		0		0		SIPHere	55909
end


//--------------------------------------------------------------------------------//
//	SrvCode		MoveAbleOption	Map		DestServerCode            //
//--------------------------------------------------------------------------------//
1


	0 		0 		30 		9
	0 		0 		31 		9
	0 		0 		34 		9
	0		0		41		9
	0		0		42		9




        9		1		30		-1
	9		1		31		-1
	9	        1	        34	        -1
	9		1		41		-1
	9		1		42		-1
end

To become like this:

Code:
0
	0		0		1		SIPHere	55901
	9		0		0		SIPHere	55909
end


//--------------------------------------------------------------------------------//
//	SrvCode		MoveAbleOption	Map		DestServerCode            //
//--------------------------------------------------------------------------------//
1


end

3.Try login in client
- This error appears when you try login in your account from client.
Why its not connecting?
It's simply. Your Client version is just different protocol type
If you are using other protocol type you will need to change in server side to support this protocol.
Manual its Data/Commonserver.cfg > Language = ?
Remember you must be sure that your GameServer supports this packages else it will still not work.
So if its still not working then your gameserver not support other protocols
 
  • Like
Reactions: lxdidai

AnDeR

Member
Joined
Jul 12, 2009
Messages
50
Reaction score
1
I noticed that the characters to be created they do not start with the rings of lvl 40 and 80 to be dropped
 

lxdidai

New Member
Joined
Jul 8, 2015
Messages
11
Reaction score
0
你只能语言此服务器,越南语。我与我的用户有同样的问题

Pwrd By Google Traslate

能否通过修改GameServer默认编码的内存地址来支持Chs? 目前已全部支持中文,创建中文角色名以及中文战盟名称除外。

请求帮助!
 

lxdidai

New Member
Joined
Jul 8, 2015
Messages
11
Reaction score
0
So i will get started with simple information.
Fist to get you know about this error.
This error will appear on your gameserver window if you :
1. Attack monsters and got disconnect
2. Try move to other map
3. Try login ingame
...

Thank you very much! this problem has been solved.
 

lxdidai

New Member
Joined
Jul 8, 2015
Messages
11
Reaction score
0
When I set Data/commonserver.cfg and Language = 3(Chs), Under the premise of using the china client , everything is normal.

In addition to using the Chinese character to create a role name.

Why there is such a problem? @linkzero @DarkMaster
 
Last edited: