Anyone have idea how to disconnect an account or player through website using PHP? :laugh:
Printable View
Anyone have idea how to disconnect an account or player through website using PHP? :laugh:
Probably this one you need to make in PHP, which works on Procedure, when player press ESC, Exit Game/Select Server.
Quote:
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