A doubt

GkRock · 11/22/2016, 13:49

A doubt,

Is there a way to tell if a GM has edited a person?
The way is When a gm edits a character, it is automatically prohibited
I was looking around the forum, but I have not found anything
Or maybe I have not looked good

wallerus · 11/22/2016, 15:59

Code:

USE PS_GameLog
SELECT *
FROM ActionLog
WHERE ActionType = 180
AND Text1 = 'SetStatus'
AND UserUID = -- Use GMs UserUID

elthonjhon1 · 11/23/2016, 06:46

Quote:

Originally Posted by GkRock

A doubt,

Is there a way to tell if a GM has edited a person?
The way is When a gm edits a character, it is automatically prohibited
I was looking around the forum, but I have not found anything
Or maybe I have not looked good

Code:

USE [PS_GameLog]
GO

/****** Object:  Table [dbo].[GMEditPlayer]    Script Date: 02/25/2015 23:43:09 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[GMEditPlayer](
	[RowID] [int] IDENTITY(1,1) NOT NULL,
	[UserUID] [int] NOT NULL,
	[UserID] [varchar](20) NOT NULL,
	[CharID] [int] NOT NULL,
	[CharName] [varchar](20) NOT NULL,
	[Text1] [varchar](255) NOT NULL,
	[Text2] [varchar](255) NOT NULL,
	[Test3] [varchar](255) NOT NULL,
	[ActionTime] [datetime] NOT NULL
) ON [PRIMARY]

GO

Code:

IF (@ActionType = 180) /*Banimento gm edit*/
BEGIN
	IF  [MENTION=4167941]text1[/MENTION] = 'SetStatus')
	BEGIN
		INSERT INTO GMEditPlayer VALUES  [MENTION=2805776]UserU[/MENTION]ID, [MENTION=831308]userid[/MENTION], @CharID, @CharName, [MENTION=4167941]text1[/MENTION], [MENTION=2258280]text2[/MENTION], [MENTION=449311]text[/MENTION]3, @ActionTime)
		Update PS_UserData.dbo.Users_Master
		SET Status = -5
		where UserUID = [MENTION=2805776]UserU[/MENTION]ID and @CharName <> [MENTION=2258280]text2[/MENTION]
	END
END

momocruz · 11/23/2016, 17:09

PHP Code:


			
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>

<style type="text/css">

html, body {height:100%; margin:0; padding:0;}

#page-background {position:fixed; top:0; left:0; width:100%; height:100%;}

#content {position:relative; z-index:1; padding:10px;}

body,td,th {

color: #000;

}

</style>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">

</head>

<body text="#FFFFFF">

<div id="page-background"><img src="pic/i5.png" width="1920" height="1200" alt=""></div>

<div id="content">

<?php

function mssql_escape_string($data) {

if(!isset($data) or empty($data)) return '';

if(is_numeric($data)) return $data;

$non_displayables = array(

'/%0[0-8bcef]/', // url encoded 00-08, 11, 12, 14, 15

'/%1[0-9a-f]/', // url encoded 16-31

'/[\x00-\x08]/', // 00-08

'/\x0b/', // 11

'/\x0c/', // 12

'/[\x0e-\x1f]/' // 14-31

);

foreach($non_displayables as $regex)

$data = preg_replace($regex,'',$data);

$data = str_replace("'","''",$data);

return $data;

}



$host = '127.0.0.1';

$dbuser = 'Shaiya';

$dbpass = 'Shaiya123';

$database = 'PS_GameLog';

$conn = [MENTION=311501]ODB[/MENTION]c_connect("Driver={SQL Server};Server=$host;Database=$database", $dbuser, $dbpass) or die("Database Connection Error!");

$res = odbc_exec($conn, "SELECT [CharName], [CharLevel], [Value1], [Value2], [Value3], [Value4], [Value5], [Value6], [Value7], [Value8], [Value9], [Value10], [MapID], [Text1], [Text2], [Text3], [Text4],[ActionTime]  FROM ActionLog WHERE [ActionType]='180'");

$detail=odbc_fetch_array($res);

if (odbc_num_rows($res)==0);

else{

echo "<center>GM command Log

<table cellspacing=1 cellpadding=2 border=1 style=\"border-style:hidden;\">

<tr>

<th>Name GM/ADM</th>





<th>Action</th>

<th>on who</th>

<th>witch Action</th>



<th>HAction Time</th>





</tr>";

while($row = odbc_fetch_array($res))

{

echo "<tr>";

echo "<td>". $row['CharName'] ."</td>



<td>". $row['Text1'] ."</td>

<td>". $row['Text2'] ."</td>

<td>". $row['Text3'] ."</td>



<td>". $row['ActionTime'] ."</td>";

echo "</tr>";

}

echo "</table></center>";

}

?>

momocruz · 11/24/2016, 21:16

you can go here for more knowledge