Resolve "Account Already Connected" Problem

thp up !!!

Quote:

---

Originally Posted by Diabolik

thp up !!!

---

http://forum.ragezone.com/f197/relea...ct-dll-511299/

Hello

MapServerInfo

Quote:

---

0
0 0 1 Sdgmu.dyn.pl 55917
2 0 1 Sdgmu.dyn.pl 55901
19 0 0 Sdgmu.dyn.pl 55919
end

1
0 0 30 19
0 0 31 19
0 0 34 19

2 0 30 19
2 0 31 19
2 0 34 19

19 1 30 -1
19 1 31 -1
19 1 34 -1
end

---

And i dont have nothing in C:// / WINDOWS / system32 /Drivers / Etc / hosts


Please help:P?


What i must do to repeir this problem/bug , i must fast fix that.

Quote:

---

Originally Posted by kewtrewt

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).

---

is this for all versions including season 4?

i aso need T_T for session4

1) You DON