Printable View
Hi all i have problem with online count, and joinserver show errors when somebody is connecting (Can connect) but online count shows 0
Can somebody paste be working WZ_CONNECT_MEMB for 0.99.62TX?? Thanks
error-L1 : exec WZ_CONNECT_MEMB '460941','ServerName','62.81.16.6'
12:01:12a [460941] User Login [AuthType : NOCHARGE]
there you goQuote:
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
just use like the adanbr server files, they have much more bugs fixed etc...
Bery nice Liselotte, but wich table ? MuOnline, MULog, MuConnectLog :SQuote:
Originally Posted by Liselotte
Regards.
lalw..don't bump old threads ^_-Quote:
Originally Posted by munacional
MuOnline or Me_MuOnline (if using 6db).
Sorry this is for me.. don`t bump old threads ?. The liselotte answer is an answer to correct ( i thing ) the error of joinserver ( sqlstate bla bla bla. ) and they don`t have an answer yet, so i belive is not old ... but in don`t understand "bump" :( ( sorry i am argentino ) but any way, thanks for your answer.Quote:
Originally Posted by themad
:D
Regards.