Resolve "Account Already Connected" Problem

**Z80** · 01-09-06

Very sad, that none relly posted a "guide" for that problem. There are lots people here with the same prob.

1) You DON´T need a Loopback Adaptor. With Loopback Adaptor installed, no one could connect to the server.

2) Open with notepad the file: c:\windows\system32\drivers\etc\hosts

3) Edit your hosts - file as follows:
127.0.0.1 localhost
yourLANIP myservername
your LANIP yourDNS
your WANIP yourDNS
your RouterIP yourDNS

where:
yourLANIP is something like 192.168.0.10 (you will get it from Start->execute->cmd->ipconfig /all

myservername name of your computer (my computer -> properties -> computer name)

yourWANIP you will get this from either Start->execute->cmd->ipconfig /all, or from your no-ip update programm

yourDNS the name of your domaine or dyn-dns (i.e mymu.servegame.com) you will get this form either your ISP or your dyn-dns provider (no-ip.com etc..)

yourRouterIP is something like 192.168.0.1, this should be the gateway IP in your server TCP/IP configuration.

Then reboot your server.

My Hosts File:

127.0.0.1 localhost
192.168.0.1 mainserver
192.168.0.1 minasoptics.com.br
192.168.0.250 mainserver
192.168.0.250 minasoptics.com.br
201.17.146.186 minasoptics.com.br

My MapServerInfo.dat:

0
0 0 -1 S201.17.146.186 55901
1 0 1 S201.17.146.186 55903

end

// 2> . Maeb mobile impossible information of server (the server which is not to dignity server information the nil which could be register)
//
// ServerCode MoveAbleOption Map DestServerCode
// (Server cord) (mobile yes or no option) (Maeb) (destination server cord)
//-----------------------------------------------------------------------------
1
0 1 30 -1
0 1 31 -1
1 0 30 0
1 0 31 0
end

I put my startup.ini here:
[captions]
v0v=dataserver
v1v=dataserver
v2v=dataserver
v3v=connectserver
v4v=exdb
v5v=chatserver
v6v=joinserver
v7v=rankingserver
v8v=eventserver
v9v=gameservercs
v10v=gameserver
[paths]
v0v=dataserver0\
v1v=dataserver1\
v2v=dataserver2\
v3v=cs\
v4v=exdb\
v5v=chatserver\
v6v=joinserver\
v7v=rankingserver\
v8v=eventserver\
v9v=gameserver0\
v10v=gameserver1\
[exenames]
v0v=dataserver.exe
v1v=dataserver.exe
v2v=dataserver.exe
v3v=cs.exe
v4v=exdb.exe
v5v=chatserver.exe
v6v=joinserver.exe
v7v=mu_ranking_db_server.exe
v8v=wz_mu2003_event_server.exe
v9v=gameserver.exe
v10v=gameserver.exe
[parametrs]
v0v=55960 0
v1v=55962 1
v2v=55964 2
v3v=
v4v=:ip:
v5v=127.0.0.1
v6v=/p55970 /ca:ip: /cp55557
v7v=
v8v=
v9v=:ip: 55970 :ip: 55960 55901
v10v=:ip: 55970 :ip: 55962 55903
[waitintervals]
v0v=1000
v1v=1000
v2v=1000
v3v=1000
v4v=1000
v5v=1000
v6v=1000
v7v=1000
v8v=1000
v9v=1000
v10v=1000
[needrestart]
v0v=no
v1v=no
v2v=no
v3v=no
v4v=no
v5v=NO
v6v=no
v7v=no
v8v=no
v9v=no
v10v=no
[main]
enableautorestart=0
restartinterval=20
ipadd=192.168.0.250

If you still can´t enter into Valley of Loren, check your IPs in CS folder and MapServerInfo.dat.

**MentaL**

Resolve "Account Already Connected" Problem

**mig1st4ck** · 02-09-06

basicly the most important is the MapServerInfo.dat. the one you didn't posted.

here is mine.

0
0 0 -1 Smutug.myftp.org 55901
1 0 1 Smutug.myftp.org 55903
end

// 2> . Maeb mobile impossible information of server (the server which is not to dignity server information the nil which could be register)
//
// ServerCode MoveAbleOption Map DestServerCode
// (Server cord) (mobile yes or no option) (Maeb) (destination server cord)
//-----------------------------------------------------------------------------
1
0 1 30 -1
0 1 31 -1
1 0 30 0
1 0 31 0
end

Iportant you can't put symbols in your Ip. Don't use the no-ip in your DNS.
the - can't be read by the gameserver.

Also put in
Open with notepad the file: c:\windows\system32\drivers\etc\hosts

The same IP that you use. rederecting to your IP.

If you have rooter. redirect to your rooter IP.

Important 127.0.0.1 don't work here.

Mine is like this

192.168.1.2 mutug.myftp.org

I realy hope this can solve the problems unce for all.

**Sv@ike** · 02-09-06

mhhh, i thought that problem when this account already connected happens only when u exit game by pressing alt+f4...

**kewtrewt** · 02-09-06

I dont know how this can have any influence on that.
I had that problem, but i solved modifying the WZ_Disconnect procedure, because problem is there.
I will post later on today the right procedures (WZ_Connect and WZ_Disconnect).

**kewtrewt** · 02-09-06

How i was saying here are the procedures.

Code:

CREATE PROCEDURE WZ_CONNECT_MEMB 

@uid varchar(10),
@server varchar(15),
@uip varchar(15)
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,ConnectStat,ServerName,IP,  ConnectTM) values (
@uid,
'1',
@server,
@uip,
(getdate())
) 
End 

IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION

SET NOCOUNT OFF 
End
GO

and the Disconnect one:

Code:

CREATE PROCEDURE WZ_DISCONNECT_MEMB 

@uid varchar(10)
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 DisConnectTM = (getdate()), connectstat = '0'  WHERE memb___id = @uid
End
ELSE
Begin
INSERT INTO MEMB_STAT ( memb___id,ConnectStat,DisConnectTM) values (
@uid,
0,
(getdate())
) 
End 


IF(@@Error <> 0 )
ROLLBACK TRANSACTION
ELSE 
COMMIT TRANSACTION

SET NOCOUNT OFF 
End
GO

This work for me without any problem (with the condition that you have setted your server correctly).

**mig1st4ck** · 02-09-06

well i fixed that too. if you use the database from my release. you will have that already corrected.

**Gangztah** · 02-09-06

Originally Posted by kewtrewt

I dont know how this can have any influence on that.
I had that problem, but i solved modifying the WZ_Disconnect procedure, because problem is there.
I will post later on today the right procedures (WZ_Connect and WZ_Disconnect).

Yes the problem is in the stored procedures..

**Z80** · 03-09-06

Originally Posted by kewtrewt

I dont know how this can have any influence on that.
I had that problem, but i solved modifying the WZ_Disconnect procedure, because problem is there.
I will post later on today the right procedures (WZ_Connect and WZ_Disconnect).

I don't think so!
To enter in the CS server is just a redirecting. This has to do with IPs and ports.
If you look at the stored procedures WZ_CONNECT_MEMB OR WZ_DISCONNECT_MEMB there is nothing with redirecting. Those procedures handles just the status connectStat and the other entries of table MEMB_STAT.
I didn't change anything there. But anyway, any help and/or additional information is always welcomed.

To mig1st4ck:

You are absolutely right. I didn't post mine, because there are so many topics about the MapServerInfo.dat, that I thought, everyone has this set correctly.

**=Master=** · 03-09-06

pff ,that is not the problem, problems is procedures wz_connect_memb and wz_disconnect_memb (somthing like that),i already solved :D,pro is procedure could not find the name of server ;)

**Illupo** · 04-09-06

Don't understand ..... can i connect to my muserver by remote and local connection at the same time ???

my Hostfile:

Code:

127.0.0.1       localhost
192.168.1.134	Cooteck
192.168.1.134	namedns
82.63.xxx.xxx	namedns
192.168.1.2	Cooteck
192.168.1.2 	namedns

my MpaServerInfo.dat

Code:

0
	0		0		-1		S82.63.207.182	55901
	1		0		1		S82.63.207.182	55903
	2		0		1		S82.63.207.182	55904
	3		0		1		S82.63.207.182	55905
end

// 2> . Maeb mobile impossible information of server (the server which is not to dignity server information the nil which could be register)
//
//	ServerCode	MoveAbleOption	Map	DestServerCode
//	(Server cord) (mobile yes or no option) (Maeb) (destination server cord)
//-----------------------------------------------------------------------------
1
	0		1		30		-1
	0		1		31		-1
	1		0		30		0
	1		0		31		0
	2		0		30		0
	2		0		31		0
	3		0		30		0
	3		0		31		0
end

**Illupo** · 04-09-06

Don't understand ... can i connect to my muserver in remote and local connection at the same time????

this is my hostfile:

Code:

127.0.0.1       localhost
192.168.1.134	Cooteck
192.168.1.134	namedns
82.63.xxx.xxx	namedns
192.168.1.2	Cooteck
192.168.1.2 	namedns

this is my mapserverinfo.dat

Code:

0
	0		0		-1		S82.63.xxx.xxx	55901
	1		0		1		S82.63.xxx.xxx	55903
	2		0		1		S82.63.xxx.xxx	55904
	3		0		1		S82.63.xxx.xxx	55905
end

// 2> . Maeb mobile impossible information of server (the server which is not to dignity server information the nil which could be register)
//
//	ServerCode	MoveAbleOption	Map	DestServerCode
//	(Server cord) (mobile yes or no option) (Maeb) (destination server cord)
//-----------------------------------------------------------------------------
1
	0		1		30		-1
	0		1		31		-1
	1		0		30		0
	1		0		31		0
	2		0		30		0
	2		0		31		0
	3		0		30		0
	3		0		31		0
end

help me plz mig1st4ck

**Domination** · 04-09-06

yeah, i agree with you.
i think that the main problem is in the WZ_DISCONNECT_MEMB procedure.
coz it gives me an error in auth server time from time.

**_SmauG_** · 05-09-06

Can you post the procedure?
i hace this problem and i want to fix it

Thx

**limpamesa** · 05-09-06

Originally Posted by kewtrewt

I dont know how this can have any influence on that.
I had that problem, but i solved modifying the WZ_Disconnect procedure, because problem is there.
I will post later on today the right procedures (WZ_Connect and WZ_Disconnect).

Long day lol

**limpamesa** · 06-09-06

Originally Posted by kewtrewt

I dont know how this can have any influence on that.
I had that problem, but i solved modifying the WZ_Disconnect procedure, because problem is there.
I will post later on today the right procedures (WZ_Connect and WZ_Disconnect).

I have this problem too and I have seeing this 2 procedures. I think its causing lag because a lot of tables to access and update. In the old version it was so simple.

Can you put your WZ_Connect and WZ_Disconnect here for we see?

Thanks!

Resolve "Account Already Connected" Problem

Thread Tools

Resolve "Account Already Connected" Problem

Advertisement