[Help] Server Side 99.88+99.96
Guys, I found a way to solve account already connected problem in 99.88+99.96 Server, but the thing is, the command /kick or /disconnect send some info to JoinServer, and I wanna know what is sent to JoinServer, I'll put that in a PHP script for the user unlock his account from the server
Is there any way to do that?
I saw in 99.6x that there is some function related with MEMB_STAT table, but I dont know nothing about those functions. See below:
Function JC_USER_ONLINE
Quote:
CREATE FUNCTION DBO.JC_USER_ONLINE
(@ACC CHAR(10) )
RETURNS INT
AS
BEGIN
DECLARE @CONNECTSTAT TINYINT
SELECT @CONNECTSTAT=CONNECTSTAT FROM MEMB_STAT WHERE MEMB___ID=@ACC
IF(@CONNECTSTAT IS NULL OR @CONNECTSTAT = 1)
BEGIN
SET @CONNECTSTAT= 1
END
ELSE
BEGIN
SET @CONNECTSTAT= 0
END
RETURN @CONNECTSTAT
END
Function JC_USER_ONLINE1
Quote:
CREATE FUNCTION DBO.JC_USER_ONLINE1
(@ACC CHAR(10) )
RETURNS INT
AS
BEGIN
DECLARE @CONNECTSTAT TINYINT
SELECT @CONNECTSTAT=CONNECTSTAT FROM MEMB_STAT WHERE MEMB___ID=@ACC
IF(@CONNECTSTAT IS NULL OR @CONNECTSTAT = 0)
BEGIN
SET @CONNECTSTAT= 0
END
ELSE
BEGIN
SET @CONNECTSTAT= 1
END
RETURN @CONNECTSTAT
END
Function JS_USER_ONLINEJS
Quote:
CREATE FUNCTION DBO.JC_USER_ONLINEJS
(@ACC VARCHAR(10),@GAMEIDC VARCHAR(10))
RETURNS INT
AS
BEGIN
DECLARE @YACC VARCHAR(10)
DECLARE @CONNECTSTAT TINYINT
SET @CONNECTSTAT= 0
SELECT @YACC = GAMEIDC FROM ACCOUNTCHARACTER WHERE ID=@ACC
IF(@YACC IS NULL OR @YACC = @GAMEIDC)
SET @CONNECTSTAT = 1
RETURN @CONNECTSTAT
END
But the problem is, those functions dont exist in 99.88+99.96.
I found a Store Procedure in 99.6x that doesnt exist in 99.88+99.96, probably, can solve this:
[QUOTE]
CREATE PROCEDURE WZ_DISCONNECT_MEMB_1
@memb___id varchar(10)
AS
Begin
set nocount on
Declare @find_id varchar(10)
Declare @ConnectStat tinyint
Set @ConnectStat = 0 --
Re: [HELP] Server Side 99.88+99.96
Re: [HELP] Server Side 99.88+99.96