[Help] Disconnect account/player

Results 1 to 2 of 2
  1. #1
    Member wazakai is offline
    MemberRank
    Sep 2016 Join Date
    73Posts

    idea [Help] Disconnect account/player

    Anyone have idea how to disconnect an account or player through website using PHP?


  2. #2
    Member crew is offline
    MemberRank
    May 2016 Join Date
    94Posts

    Re: [Help] Disconnect account/player

    Probably this one you need to make in PHP, which works on Procedure, when player press ESC, Exit Game/Select Server.

    USE [MuOnline]GO/****** Object: StoredProcedure [dbo].[WZ_DISCONNECT_MEMB] Script Date: 11/05/2018 20:38:53 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOALTER PROCEDURE [dbo].[WZ_DISCONNECT_MEMB]@uid varchar(20)ASBeginBEGIN TRANSACTIONSET NOCOUNT ONIF EXISTS ( SELECT memb___id FROM MEMB_STAT WITH (READUNCOMMITTED)WHERE memb___id = @uid )Begin-- ImperiaMUUPDATE MEMB_STAT SET DisConnectTM = (getdate()), ConnectStat = 0 , OnlineTime = OnlineTime+(DATEDIFF(mi,ConnectTM,getdate())) WHERE memb___id = @uid-- ImperiaMUUPDATE Character SET cLevel = 400 , MapNumber = 40, MapPosX = 225, MapPosY = 25, MapDir = 1, PkTime= 0 Where CtlCode = 32 And AccountID = @uidEndELSEBeginINSERT INTO MEMB_STAT ( memb___id,DisConnectTM,ConnectStat) valueS (@uid,(getdate()),0)EndIF(@@Error <> 0 )ROLLBACK TRANSACTIONELSECOMMIT TRANSACTIONSET NOCOUNT OFFEnd



Advertisement