[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.