clockwerk-www – Rev 5
?pathlinks?
<?php
/*********************************************************************************
* env.mysql.php v1.0.0 for OpenSim by Fumi.Iseki 2011 1/27
*
* Copyright (c) 2011 http://www.nsl.tuis.ac.jp/
*
* supported versions of OpenSim are 0.6.7, 0.6.8, 0.6.9, 0.7 and 0.7.1Dev
* tools.func.php is needed
* mysql.func.php is needed
*
*********************************************************************************/
/*********************************************************************************
* Function List
// for Currency
function env_set_money_transaction($sourceId, $destId, $amount, $type, $falgs, $desc, $prminvent, $nxtowner, $ip)
function env_get_money_balance($uuid)
**********************************************************************************/
/////////////////////////////////////////////////////////////////////////////////////
//
// Load Function
//
require_once(ENV_HELPER_PATH.'/../include/tools.func.php');
require_once(ENV_HELPER_PATH.'/../include/mysql.func.php');
/////////////////////////////////////////////////////////////////////////////////////
//
// for Currency
function env_set_money_transaction($sourceId, $destId, $amount, $type, $falgs, $desc, $prminvent, $nxtowner, $ip)
{
if (!isNumeric($amount)) return;
if (!isGUID($sourceId)) $sourceId = '00000000-0000-0000-0000-000000000000';
if (!isGUID($destId)) $destId = '00000000-0000-0000-0000-000000000000';
$region = '00000000-0000-0000-0000-000000000000';
$client = $sourceId;
if ($client=='00000000-0000-0000-0000-000000000000') $client = $destId;
$avt = opensim_get_avatar_session($client);
if ($avt!=null) $region = $avt['regionID'];
$db = null;
if (defined('CURRENCY_DB_HOST')) {
$db = new DB(CURRENCY_DB_HOST, CURRENCY_DB_NAME, CURRENCY_DB_USER, CURRENCY_DB_PASS);
}
else {
$db = new DB(OPENSIM_DB_HOST, OPENSIM_DB_NAME, OPENSIM_DB_USER, OPENSIM_DB_PASS);
}
if ($db==null) return;
$sql = "INSERT INTO ".CURRENCY_TRANSACTION_TBL." (sourceId,destId,amount,flags,aggregatePermInventory,".
"aggregatePermNextOwner,description,transactionType,timeOccurred,RegionGenerated,ipGenerated) ".
"VALUES ('".
$sourceId."','".
$destId."','".
$amount."','".
$db->escape($flags)."','".
$db->escape($prminvent)."','".
$db->escape($nxtowner)."','".
$db->escape($desc)."','".
$db->escape($type)."','".
time()."','".
$region."','".
$db->escape($ip)."')";
$db->query($sql);
$db->close();
}
function env_get_money_balance($uuid)
{
if (!isGUID($uuid)) return -1;
$scash = 0;
$dcash = 0;
$db = null;
if (defined('CURRENCY_DB_HOST')) {
$db = new DB(CURRENCY_DB_HOST, CURRENCY_DB_NAME, CURRENCY_DB_USER, CURRENCY_DB_PASS);
}
else {
$db = new DB(OPENSIM_DB_HOST, OPENSIM_DB_NAME, OPENSIM_DB_USER, OPENSIM_DB_PASS);
}
if ($db==null) return 0;
$db->query("SELECT SUM(amount) FROM ".CURRENCY_TRANSACTION_TBL." WHERE destId='". $uuid."'");
if ($db->Errno==0) list($dcash) = $db->next_record();
$db->query("SELECT SUM(amount) FROM ".CURRENCY_TRANSACTION_TBL." WHERE sourceId='".$uuid."'");
if ($db->Errno==0) list($scash) = $db->next_record();
$db->close();
$cash = (integer)$dcash - (integer)$scash;
return $cash;
}
?>