Finding player stats?

Tradehappy · 05/13/2012, 01:12

Is there a way as a GM to see a players stats if any is given to them in game. This means if a GM gives a player stats on say hp is there a way to check a players stats to see if stas were added?

treica · 05/13/2012, 12:38

Yes of course i created a script to see what gm's is doing in game here be all.

Create a file named db_connect.php

Code:

<?php
error_reporting(E_ALL ^ E_NOTICE);
$host     = 'localhost';
$username = 'Server Name';
$pass     = 'Server Password';
$link = @mssql_connect($host, $username, $pass) or Die("Failed to connect to MSSQL server");
?>

This file GMlog.php

Code:

<?php
// Database configuration parameters
include "db_connect.php";
//Form Data
$ip = $_SERVER['REMOTE_ADDR'];
$count  = 1;

$query  = ('SELECT * FROM PS_GameLog.dbo.ActionLog WHERE ActionType=180');
$result = mssql_query($query);
echo "<html><head><STYLE TYPE=\"text/css\">
<!--
td { background:url(image.png) no-repeat; }
td.i0{ background-position: 0 0; width: 28px; height: 16px; } 
td.i1{ background-position: 0 -26px; width: 28px; height: 16px; } 
td.i2{ background-position: 0 -52px; width: 28px; height: 16px; } 
td.i3{ background-position: 0 -78px; width: 29px; height: 16px; } 
td.i4{ background-position: 0 -104px; width: 29px; height: 15px; } 
td.i5{ background-position: 0 -129px; width: 28px; height: 18px; } 
td.i6{ background-position: 0 -157px; width: 30px; height: 17px; } 
td.i7{ background-position: 0 -184px; width: 29px; height: 17px; } 
td.i8{ background-position: 0 -211px; width: 28px; height: 16px; } 
td.i9{ background-position: 0 -237px; width: 28px; height: 18px; } 
td.i10{ background-position: 0 -265px; width: 29px; height: 18px; } 
td.i11{ background-position: 0 -293px; width: 29px; height: 24px; } 
td.i12{ background-position: 0 -327px; width: 29px; height: 18px; } 
td.i13{ background-position: 0 -355px; width: 29px; height: 18px; } 
td.i14{ background-position: 0 -383px; width: 29px; height: 18px; } 
td.i15{ background-position: 0 -411px; width: 29px; height: 18px; } 
td.i16{ background-position: 0 -439px; width: 29px; height: 18px; } 
td.i17{ background-position: 0 -467px; width: 24px; height: 24px; } 
td.i18{ background-position: 0 -501px; width: 24px; height: 24px; } 
td.i19{ background-position: 0 -535px; width: 24px; height: 24px; } 
td.i20{ background-position: 0 -569px; width: 24px; height: 24px; } 
td.i21{ background-position: 0 -603px; width: 24px; height: 24px; } 
td.i22{ background-position: 0 -637px; width: 24px; height: 24px; } 
</STYLE>
<title>Item List</title></head>";
echo "<body><center>
      <table cellspacing=10 cellpadding=0 border=1 bgcolor=\"black\">
      <td style=\"color:#FC9700\" bgcolor=\"black\">Row</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">UserID</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">UserUID</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">CharID</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">CharName</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">Value</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">Text1</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">Text2</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">Text3</td>
	  <td style=\"color:#FC9700\" bgcolor=\"black\">Text4</td>";
while ($row = mssql_fetch_array($result)) {
	echo "<tr style=\"color:white\">";
	echo "<td>" . $row[Row] . "</td><td>" . $row[UserID] . "</td><td>" . $row[UserUID] . "</td><td>" . $row[CharID] ."</td><td>" . $row[CharName] . "</td><td>" . $row[Value] . "</td><td> " . $row[Text1] . "</td><td>" . $row[Text2] . "</td><td>" . $row[Text3] . "</td><td>" . $row[TEXT4] . "</td>";
	echo "</tr>";
	$count++;
}
echo "</table>";
echo "</html>";
?>

This script is using MSSQL Connect and will show you GM Action Log every command is using a GM in game will be show here.
Hope you like it enjoy.

Tradehappy · 05/15/2012, 16:40

Thanks for the reply. Now I have one more ? considering this subject. If a player is given stats by a gm it does not show in the database. I know that the set_*** will show in action logs but what I am looking for is to see a players current total stats on a logged in toon. Is there a way to obtain a players total stats on a toon. Example base STR shown in DB 400, given STR by GM 75, DB shows 400 is there any commands to see the missing 75?

~~taZツ~~ · 05/15/2012, 16:47

You might wanna try this:

Spoiler

It selects top 200 players from the server and display theyr exact stats.

This has been released on here, so i do not own any rights.

Tradehappy · 05/15/2012, 16:52

Thanks for the reply I will def try it out!!

Tradehappy · 05/22/2012, 20:44

Ok, just wanted to follow up on this post in case anyone has ?'s. This script does not show any added stats added from buffs are GM's. It does in other words give all regular stats by the player. The answer to the ? that I was asking is========

/quiery player name

this shows all stats/links/armor/weps/acc and even what color underwear the player has on. Hope some peps finds this useful.