Account already connected

[Hase]

Hello guys, I've got an problem.
Sometimes players teleport to CryWolf or Deeploren and they get disconnect, after that they get 'Account already connected'.
Many users can teleport to these maps, also I can teleport.
But few guys get that problem.
Help :)

[MentaL]

[afcka]

Mhm, you can change there status from MySQL MEMB_STAT table or you can make a Disconnect Option on your web so everyone can do it in there Control Panel

[Hase]

Yea, but I wanna know why they get it? >.>

When I start GS_CS everything is ok.
But after like an hour everyone who is warping to crywolf or deeploren - disconnected.

[Alin1337]

here are 2 fixes for you:

First disconnect all connected accounts by running this query on MSSQL:

use MuOnline
update MEMB_STAT set ConnectStat='0' where memb___id='ACCOUNTHERE'

Then secound:
To fix crywolf and deeploren warp edit /data/MapServerInfo.dat .
Put there your good data , don't put 127... or another IP , it must be your real ip because gameserver sends player to GSCS ip and port as you specify there!!

[Hase]

It didn't help,
When I start the GS_CS works for like 1 hours and after doesn't work anymore, I need to restart it again.

[KarLi]

do u get error on gs_cs.exe when u try to warp there?
Posted via Mobile Device

[Hase]

Nope .

[KarLi]

try using this script on sql

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 ON
GO

CREATE PROCEDURE WZ_CONNECT_MEMB

@uid varchar(20),
@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

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

if it wont work

check those threads.
http://forum.ragezone.com/f196/manua...nected-351831/
http://forum.ragezone.com/f196/resol...roblem-167123/
http://forum.ragezone.com/f196/fix-a...-issue-228382/

[Hase]

Thanks, also I see in GS_CS logs every few seconds

RUN ProcState_READYSIEGE() LEFT-MSEC:78589438
LEFT : SEC(78589), SIEGE-DAY(2012-02-25 17:59:49)
20:10:12 connect : [2525][127.0.0.1]
Connection Closed, dwIoSize == 0 (Index:2525)
20:10:12 (2525)logout : [127.0.0.1]
RUN ProcState_READYSIEGE() LEFT-MSEC:78588344
RUN ProcState_READYSIEGE() LEFT-MSEC:78587250
LEFT : SEC(78587), SIEGE-DAY(2012-02-25 17:59:47)
RUN ProcState_READYSIEGE() LEFT-MSEC:78586157
20:10:14 connect : [2526][127.0.0.1]
Connection Closed, dwIoSize == 0 (Index:2526)
20:10:14 (2526)logout : [127.0.0.1]
RUN ProcState_READYSIEGE() LEFT-MSEC:78585063
RUN ProcState_READYSIEGE() LEFT-MSEC:78583969
LEFT : SEC(78583), SIEGE-DAY(2012-02-25 17:59:43)
RUN ProcState_READYSIEGE() LEFT-MSEC:78582969
20:10:18 connect : [2527][127.0.0.1]
Connection Closed, dwIoSize == 0 (Index:2527)
20:10:18 (2527)logout : [127.0.0.1]
RUN ProcState_READYSIEGE() LEFT-MSEC:78581891
RUN ProcState_READYSIEGE() LEFT-MSEC:78580797
LEFT : SEC(78580), SIEGE-DAY(2012-02-25 17:59:40)
RUN ProcState_READYSIEGE() LEFT-MSEC:78579703
20:10:21 connect : [2528][127.0.0.1]
Connection Closed, dwIoSize == 0 (Index:2528)
20:10:21 (2528)logout : [127.0.0.1]
20:10:21 connect : [2529][127.0.0.1]
Connection Closed, dwIoSize == 0 (Index:2529)
20:10:22 (2529)logout : [127.0.0.1]

[KarLi]

did u tried changing ur OS Service pack ?

[Hase]

I already have Windows Server 2003 SP 1 Enterprise Edition.
Everything was okay a few days ago.

[KarLi]

but u didnt tried changing ur service pack what if u do and check if problem persists..