[HELP] View transactions

gmroger · 07/30/2015, 07:02

Hello, I have a question.

I was wondering how I could view the transactions that players do in my server, I wanted to know if there was a script where I could just put a players name and it would show me all the transaction he or she made, or something similar to this.

(Yes, I used the search function and found nothing).

Boul27 · 07/30/2015, 08:18

Yep there is a possibility.

Here is a general query to see what char receive :
SELECT * FROM [PS_GameLog].[dbo].[ActionLog] where ActionType = 115 and upper(CharName) = 'CHARNAME';

And here, to see what they sell :
SELECT * FROM [PS_GameLog].[dbo].[ActionLog]where ActionType = 116 and upper(CharName) = 'CHARNAME';

If you can understant the result, so you can modify the query to only have the informations you wants to have

Hope it help you.

You can ask me more question/detail if you don't really understand

momocruz · 07/30/2015, 08:31

Here you have Something like " Trade LOG "
Made From this

And if you read this release you can learn many thing ALONE

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="TROC Reccord"></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 = @odbc_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]='116'");

$detail=odbc_fetch_array($res);

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

else{

echo "<center>Troc Records

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

<tr>

<th>Celui qui donne</th>

<th>Level</th>

<th>Item ID</th>

<th>Quantité</th>

<th>Lieu</th>

<th>Nom de L'item</th>

<th>Nom du receveur</th>

<th>Fait le</th>



</tr>";

while($row = odbc_fetch_array($res))

{

echo "<tr>";

echo "

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

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

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

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

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

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

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

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

echo "</tr>";

}

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

}

?>

wallerus · 07/30/2015, 16:33

Do you not already have a Transaction Log? If yes then use this.

Code:

SELECT * FROM PS_GameLog.dbo.TransactionLog
WHERE CharID='insert charID'
SORT BY DateTime DESC

It's been months since I've looked at a Shaiya DB, but I think that's the correct location for the Transaction Log. Alternatively, you could use

which has this feature plus more already implemented.