[Help] Server Side 99.88+99.96

Results 1 to 3 of 3
  1. #1
    Upgraded ADM_KRIOK is offline
    MemberRank
    Jan 2005 Join Date
    MuLoKo - BrazilLocation
    235Posts

    [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
    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
    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
    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 --


  2. #2
    Upgraded ADM_KRIOK is offline
    MemberRank
    Jan 2005 Join Date
    MuLoKo - BrazilLocation
    235Posts

    Re: [HELP] Server Side 99.88+99.96

    help me pls

  3. #3
    Valued Member shuperh2 is offline
    MemberRank
    Apr 2006 Join Date
    MoldovaLocation
    102Posts

    Re: [HELP] Server Side 99.88+99.96

    i have the same problem!



Advertisement