OpenSimulator - User contributions [en]

Profile

2012-01-02T07:18:04Z

Shanea: /* PHP for web server (Profile.php) */

__NOTOC__
{{Quicklinks}}
 

Please note: This page is incomplete and refers to some third party module. OpenSimulator developers are not responsible for third party code (or indeed for OpenSimulator code itself, but that's a different point).

Makes it possible to see people's Profile.
Please note that these are third party modules which you use at your own risk!
OpenSimulator takes no responsibility for these modules.

=== Through PHP ===

In the latest version Profile module is already ready to be used
* Install the Profile.sql file on your database (xampp http://www.apachefriends.org)
* Enable the Profile Module in your Opensim.ini file. 
* Upload the profile.php to your web server(xampp http://www.apachefriends.org).

=== Changes in the OpenSim.ini file ===

<source lang=text>
[Profile]
Module = "OpenProfileModule"
ProfileURL = "http://yourwebserverip/profile.php"
</source>

When you did it right, reboot your region and try to create your profile. Check the database to see that it has written your data.

P.D: Work only in in same grid no Hg enabeled

=== SQL file to import (profile.txt)===
<source lang=text>

CREATE TABLE IF NOT EXISTS `profile_classifieds`
(

`classifieduuid` char(36) NOT NULL,
`creatoruuid` char(36) NOT NULL,

`creationdate` int(20) NOT NULL,
`expirationdate` int(20) NOT NULL,

`category` varchar(20) NOT NULL,
`name` varchar(255) NOT NULL,

`description` text NOT NULL,
`parceluuid` char(36) NOT NULL,

`parentestate` int(11) NOT NULL,
`snapshotuuid` char(36) NOT NULL,

`simname` varchar(255) NOT NULL,
`posglobal` varchar(255) NOT NULL,

`parcelname` varchar(255) NOT NULL,
`classifiedflags` int(8) NOT NULL,

`priceforlisting` int(5) NOT NULL,
PRIMARY KEY (`classifieduuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile_notes` (

`useruuid` varchar(36) NOT NULL,

`targetuuid` varchar(36) NOT NULL,

`notes` text NOT NULL,
UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile_picks` (

`pickuuid` varchar(36) NOT NULL,
`creatoruuid` varchar(36) NOT NULL,

`toppick` enum('true','false') NOT NULL,
`parceluuid` varchar(36) NOT NULL,

`name` varchar(255) NOT NULL,

`description` text NOT NULL,

`snapshotuuid` varchar(36) NOT NULL,

`user` varchar(255) NOT NULL,

`originalname` varchar(255) NOT NULL,

`simname` varchar(255) NOT NULL,

`posglobal` varchar(255) NOT NULL,

`sortorder` int(2) NOT NULL,

`enabled` enum('true','false') NOT NULL,
PRIMARY KEY (`pickuuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile` (

`useruuid` varchar(36) NOT NULL,

`profilePartner` varchar(36) NOT NULL,

`profileAllowPublish` binary(1) NOT NULL,

`profileMaturePublish` binary(1) NOT NULL,

`profileURL` varchar(255) NOT NULL,

`profileWantToMask` int(3) NOT NULL,

`profileWantToText` text NOT NULL,

`profileSkillsMask` int(3) NOT NULL,

`profileSkillsText` text NOT NULL,

`profileLanguages` text NOT NULL,

`profileImage` varchar(36) NOT NULL,

`profileAboutText` text NOT NULL,

`profileFirstImage` varchar(36) NOT NULL,

`profileFirstText` text NOT NULL,
PRIMARY KEY (`useruuid`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile_settings` (

`useruuid` varchar(36) NOT NULL,

`imviaemail` enum('true','false') NOT NULL,

`visible` enum('true','false') NOT NULL,

`email` varchar(254) NOT NULL,
PRIMARY KEY (`useruuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

</source >

=== PHP for web server (Profile.php)===
<source lang=text>

<?PHP
$dbName = "comunity";

$dbHost = "localhost";

$dbUser = "root";

$dbPassword ="";

mysql_connect ($dbHost,$dbUser,$dbPassword);
mysql_select_db ($dbName);

$zeroUUID = "00000000-0000-0000-0000-000000000000";
$xmlrpc_server = xmlrpc_server_create();

xmlrpc_server_register_method($xmlrpc_server, "avatarclassifiedsrequest",
"avatarclassifiedsrequest");

function avatarclassifiedsrequest($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['uuid'];

$result = mysql_query("SELECT * FROM profile_classifieds WHERE ".
"creatoruuid = '". mysql_escape_string($uuid) ."'");

$data = array();

while (($row = mysql_fetch_assoc($result)))
{
$data[] = array(
"classifiedid" => $row["classifieduuid"],
"name" => $row["name"]);
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Classifieds Update

xmlrpc_server_register_method($xmlrpc_server, "classified_update",
"classified_update");

function classified_update($method_name, $params, $app_data)
{
global $zeroUUID;

$req = $params[0];

$classifieduuid = $req['classifiedUUID'];
$creator = $req['creatorUUID'];
$category = $req['category'];
$name = $req['name'];
$description = $req['description'];
$parceluuid = $req['parcelUUID'];
$parentestate = $req['parentestate'];
$snapshotuuid = $req['snapshotUUID'];
$simname = $req['sim_name'];
$globalpos = $req['globalpos'];
$parcelname = $req['parcelname'];
$classifiedflag = $req['classifiedFlags'];
$priceforlist = $req['classifiedPrice'];

// Check if we already have this one in the database
$check = mysql_query("SELECT COUNT(*) FROM profile_classifieds WHERE ".
"classifieduuid = '". mysql_escape_string($classifieduuid) ."'");

while ($row = mysql_fetch_row($check))
{
$ready = $row[0];
}

if ($ready == 0)
{
// Doing some late checking
// Should be done by the module but let's see what happens when
// I do it here

if($parcelname == "")
$parcelname = "Unknown";

if($parceluuid == "")
$parceluuid = $zeroUUID;

if($description == "")
$description = "No Description";

if($classifiedflag == 2)
{
$creationdate = time();
$expirationdate = time() + (7 * 24 * 60 * 60);
}
else
{
$creationdate = time();
$expirationdate = time() + (365 * 24 * 60 * 60);
}

$insertquery = "INSERT INTO profile_classifieds VALUES ".
"('". mysql_escape_string($classifieduuid) ."',".
"'". mysql_escape_string($creator) ."',".
"". mysql_escape_string($creationdate) .",".
"". mysql_escape_string($expirationdate) .",".
"'". mysql_escape_string($category) ."',".
"'". mysql_escape_string($name) ."',".
"'". mysql_escape_string($description) ."',".
"'". mysql_escape_string($parceluuid) ."',".
"". mysql_escape_string($parentestate) .",".
"'". mysql_escape_string($snapshotuuid) ."',".
"'". mysql_escape_string($simname) ."',".
"'". mysql_escape_string($globalpos) ."',".
"'". mysql_escape_string($parcelname) ."',".
"". mysql_escape_string($classifiedflag) .",".
"". mysql_escape_string($priceforlist) .")";

// Create a new record for this classified
$result = mysql_query($insertquery);
}
else
{

}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Classifieds Delete

xmlrpc_server_register_method($xmlrpc_server, "classified_delete",
"classified_delete");

function classified_delete($method_name, $params, $app_data)
{
$req = $params[0];

$classifieduuid = $req['classifiedID'];

$result = mysql_query("DELETE FROM profile_classifieds WHERE ".
"classifieduuid = '".mysql_escape_string($classifieduuid) ."'");

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

#
# Picks
#

# Avatar Picks Request

xmlrpc_server_register_method($xmlrpc_server, "avatarpicksrequest", "avatarpicksrequest");

function avatarpicksrequest($method_name, $params, $app_data)
{
$req = $params[0];
$uuid = $req['uuid'];
$data = array();
$result = mysql_query("SELECT `pickuuid`,`name` FROM profile_picks WHERE ". "creatoruuid = '". mysql_escape_string($uuid) ."'");

while (($row = mysql_fetch_assoc($result)))
{
$data[] = array(
"pickid" => $row["pickuuid"],
"name" => $row["name"]);
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Request Picks for User

xmlrpc_server_register_method($xmlrpc_server, "pickinforequest",
"pickinforequest");

function pickinforequest($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$pick = $req['pick_id'];

$data = array();

$result = mysql_query("SELECT * FROM profile_picks WHERE ".
"creatoruuid = '". mysql_escape_string($uuid) ."' AND ".
"pickuuid = '". mysql_escape_string($pick) ."'");

$row = mysql_fetch_assoc($result);
if ($row != False)
{
if ($row["description"] == null || $row["description"] == "")
$row["description"] = "No description given";

$data[] = array(
"pickuuid" => $row["pickuuid"],
"creatoruuid" => $row["creatoruuid"],
"toppick" => $row["toppick"],
"parceluuid" => $row["parceluuid"],
"name" => $row["name"],
"description" => $row["description"],
"snapshotuuid" => $row["snapshotuuid"],
"user" => $row["user"],
"originalname" => $row["originalname"],
"simname" => $row["simname"],
"posglobal" => $row["posglobal"],
"sortorder"=> $row["sortorder"],
"enabled" => $row["enabled"]);
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Picks Update

xmlrpc_server_register_method($xmlrpc_server, "picks_update",
"picks_update");

function picks_update($method_name, $params, $app_data)
{
global $zeroUUID;

$req = $params[0];

$pickuuid = $req['pick_id'];
$creator = $req['creator_id'];
$toppick = $req['top_pick'];
$name = $req['name'];
$description = $req['desc'];
$parceluuid = $req['parcel_uuid'];
$snapshotuuid = $req['snapshot_id'];
$user = $req['user'];
$simname = $req['sim_name'];
$posglobal = $req['pos_global'];
$sortorder = $req['sort_order'];
$enabled = $req['enabled'];

if($parceluuid == "")
$parceluuid = $zeroUUID;

if($description == "")
$description = "No Description";

// Check if we already have this one in the database
$check = mysql_query("SELECT COUNT(*) FROM profile_picks WHERE ".
"pickuuid = '". mysql_escape_string($pickuuid) ."'");

$row = mysql_fetch_row($check);

if ($row[0] == 0)
{
if($user == null || $user == "")
$user = "Unknown";

//The original parcel name is the same as the name of the
//profile pick when a new profile pick is being created.
$original = $name;

$query = "INSERT INTO profile_picks VALUES ".
"('". mysql_escape_string($pickuuid) ."',".
"'". mysql_escape_string($creator) ."',".
"'". mysql_escape_string($toppick) ."',".
"'". mysql_escape_string($parceluuid) ."',".
"'". mysql_escape_string($name) ."',".
"'". mysql_escape_string($description) ."',".
"'". mysql_escape_string($snapshotuuid) ."',".
"'". mysql_escape_string($user) ."',".
"'". mysql_escape_string($original) ."',".
"'". mysql_escape_string($simname) ."',".
"'". mysql_escape_string($posglobal) ."',".
"'". mysql_escape_string($sortorder) ."',".
"'". mysql_escape_string($enabled) ."')";
}
else
{
$query = "UPDATE profile_picks SET " .
"parceluuid = '". mysql_escape_string($parceluuid) . "', " .
"name = '". mysql_escape_string($name) . "', " .
"description = '". mysql_escape_string($description) . "', " .
"snapshotuuid = '". mysql_escape_string($snapshotuuid) . "' WHERE ".
"pickuuid = '". mysql_escape_string($pickuuid) ."'";
}

$result = mysql_query($query);
if ($result != False)
$result = True;

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

# Picks Delete

xmlrpc_server_register_method($xmlrpc_server, "picks_delete",
"picks_delete");

function picks_delete($method_name, $params, $app_data)
{
$req = $params[0];

$pickuuid = $req['pick_id'];

$result = mysql_query("DELETE FROM profile_picks WHERE ".
"pickuuid = '".mysql_escape_string($pickuuid) ."'");

if ($result != False)
$result = True;

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

#
# Notes
#

# Avatar Notes Request

xmlrpc_server_register_method($xmlrpc_server, "avatarnotesrequest",
"avatarnotesrequest");

function avatarnotesrequest($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$targetuuid = $req['uuid'];

$result = mysql_query("SELECT notes FROM profile_notes WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");

$row = mysql_fetch_row($result);
if ($row == False)
$notes = "";
else
$notes = $row[0];

$data[] = array(
"targetid" => $targetuuid,
"notes" => $notes);

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Avatar Notes Update

xmlrpc_server_register_method($xmlrpc_server, "avatar_notes_update",
"avatar_notes_update");

function avatar_notes_update($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$targetuuid = $req['target_id'];
$notes = $req['notes'];

// Check if we already have this one in the database

$check = mysql_query("SELECT COUNT(*) FROM profile_notes WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");

$row = mysql_fetch_row($check);

if ($row[0] == 0)
{
// Create a new record for this avatar note
$result = mysql_query("INSERT INTO profile_notes VALUES ".
"('". mysql_escape_string($uuid) ."',".
"'". mysql_escape_string($targetuuid) ."',".
"'". mysql_escape_string($notes) ."')");
}
else if ($notes == "")
{
// Delete the record for this avatar note
$result = mysql_query("DELETE FROM profile_notes WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");
}
else
{
// Update the existing record
$result = mysql_query("UPDATE profile_notes SET ".
"notes = '". mysql_escape_string($notes) ."' WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");
}

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

# Profile bits

xmlrpc_server_register_method($xmlrpc_server, "avatar_properties_request",
"avatar_properties_request");

function avatar_properties_request($method_name, $params, $app_data)
{
global $zeroUUID;

$req = $params[0];

$uuid = $req['avatar_id'];

$result = mysql_query("SELECT * FROM profile WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."'");
$row = mysql_fetch_assoc($result);

if ($row != False)
{
$data[] = array(
"ProfileUrl" => $row["profileURL"],
"Image" => $row["profileImage"],
"AboutText" => $row["profileAboutText"],
"FirstLifeImage" => $row["profileFirstImage"],
"FirstLifeAboutText" => $row["profileFirstText"],
"Partner" => $row["profilePartner"],

//Return interest data along with avatar properties
"wantmask" => $row["profileWantToMask"],
"wanttext" => $row["profileWantToText"],
"skillsmask" => $row["profileSkillsMask"],
"skillstext" => $row["profileSkillsText"],
"languages" => $row["profileLanguages"]);
}
else
{
//Insert empty record for avatar.
//FIXME: Should this only be done when asking for ones own profile?
$sql = "INSERT INTO profile VALUES ( ".
"'". mysql_escape_string($uuid) ."', ".
"'$zeroUUID', 0, 0, '', 0, '', 0, '', '', ".
"'$zeroUUID', '', '$zeroUUID', '')";
$result = mysql_query($sql);

$data[] = array(
"ProfileUrl" => "",
"Image" => $zeroUUID,
"AboutText" => "",
"FirstLifeImage" => $zeroUUID,
"FirstLifeAboutText" => "",
"Partner" => $zeroUUID,

"wantmask" => 0,
"wanttext" => "",
"skillsmask" => 0,
"skillstext" => "",
"languages" => "");
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

xmlrpc_server_register_method($xmlrpc_server, "avatar_properties_update",
"avatar_properties_update");

function avatar_properties_update($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$profileURL = $req['ProfileUrl'];
$image = $req['Image'];
$abouttext = $req['AboutText'];
$firstlifeimage = $req['FirstLifeImage'];
$firstlifetext = $req['FirstLifeAboutText'];

$result=mysql_query("UPDATE profile SET ".
"profileURL='". mysql_escape_string($profileURL) ."', ".
"profileImage='". mysql_escape_string($image) ."', ".
"profileAboutText='". mysql_escape_string($abouttext) ."', ".
"profileFirstImage='". mysql_escape_string($firstlifeimage) ."', ".
"profileFirstText='". mysql_escape_string($firstlifetext) ."' ".
"WHERE useruuid='". mysql_escape_string($uuid) ."'"
);

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

// Profile Interests

xmlrpc_server_register_method($xmlrpc_server, "avatar_interests_update",
"avatar_interests_update");

function avatar_interests_update($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$wanttext = $req['wanttext'];
$wantmask = $req['wantmask'];
$skillstext = $req['skillstext'];
$skillsmask = $req['skillsmask'];
$languages = $req['languages'];

$result = mysql_query("UPDATE profile SET ".
"profileWantToMask = ". mysql_escape_string($wantmask) .",".
"profileWantToText = '". mysql_escape_string($wanttext) ."',".
"profileSkillsMask = ". mysql_escape_string($skillsmask) .",".
"profileSkillsText = '". mysql_escape_string($skillstext) ."',".
"profileLanguages = '". mysql_escape_string($languages) ."' ".
"WHERE useruuid = '". mysql_escape_string($uuid) ."'"
);

$response_xml = xmlrpc_encode(array(
'success' => True
));

print $response_xml;
}

// User Preferences

xmlrpc_server_register_method($xmlrpc_server, "user_preferences_request",
"user_preferences_request");

function user_preferences_request($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];

$result = mysql_query("SELECT imviaemail,visible,email FROM profile_settings WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."'");

$row = mysql_fetch_assoc($result);

if ($row != False)
{
$data[] = array(
"imviaemail" => $row["imviaemail"],
"visible" => $row["visible"],
"email" => $row["email"]);
}
else
{
//Insert empty record for avatar.
//NOTE: The 'false' values here are enums defined in database
$sql = "INSERT INTO profile_settings VALUES ".
"('". mysql_escape_string($uuid) ."', ".
"'false', 'false', '')";
$result = mysql_query($sql);

$data[] = array(
"imviaemail" => False,
"visible" => False,
"email" => "");
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

xmlrpc_server_register_method($xmlrpc_server, "user_preferences_update",
"user_preferences_update");

function user_preferences_update($method_name, $params, $app_data)
{

$req = $params[0];

$uuid = $req['avatar_id'];
$wantim = $req['imViaEmail'];
$directory = $req['visible'];

$result = mysql_query("UPDATE profile_settings SET ".
"imviaemail = '".mysql_escape_string($wantim) ."', ".
"visible = '".mysql_escape_string($directory) ."' WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."'");

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

#
# Process the request
#

$request_xml = $HTTP_RAW_POST_DATA;
xmlrpc_server_call_method($xmlrpc_server, $request_xml, '');
xmlrpc_server_destroy($xmlrpc_server);
?>

</source >

Profile

2012-01-02T07:17:05Z

Shanea: /* Through PHP */

__NOTOC__
{{Quicklinks}}
 

Please note: This page is incomplete and refers to some third party module. OpenSimulator developers are not responsible for third party code (or indeed for OpenSimulator code itself, but that's a different point).

Makes it possible to see people's Profile.
Please note that these are third party modules which you use at your own risk!
OpenSimulator takes no responsibility for these modules.

=== Through PHP ===

In the latest version Profile module is already ready to be used
* Install the Profile.sql file on your database (xampp http://www.apachefriends.org)
* Enable the Profile Module in your Opensim.ini file. 
* Upload the profile.php to your web server(xampp http://www.apachefriends.org).

=== Changes in the OpenSim.ini file ===

<source lang=text>
[Profile]
Module = "OpenProfileModule"
ProfileURL = "http://yourwebserverip/profile.php"
</source>

When you did it right, reboot your region and try to create your profile. Check the database to see that it has written your data.

P.D: Work only in in same grid no Hg enabeled

=== SQL file to import (profile.txt)===
<source lang=text>

CREATE TABLE IF NOT EXISTS `profile_classifieds`
(

`classifieduuid` char(36) NOT NULL,
`creatoruuid` char(36) NOT NULL,

`creationdate` int(20) NOT NULL,
`expirationdate` int(20) NOT NULL,

`category` varchar(20) NOT NULL,
`name` varchar(255) NOT NULL,

`description` text NOT NULL,
`parceluuid` char(36) NOT NULL,

`parentestate` int(11) NOT NULL,
`snapshotuuid` char(36) NOT NULL,

`simname` varchar(255) NOT NULL,
`posglobal` varchar(255) NOT NULL,

`parcelname` varchar(255) NOT NULL,
`classifiedflags` int(8) NOT NULL,

`priceforlisting` int(5) NOT NULL,
PRIMARY KEY (`classifieduuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile_notes` (

`useruuid` varchar(36) NOT NULL,

`targetuuid` varchar(36) NOT NULL,

`notes` text NOT NULL,
UNIQUE KEY `useruuid` (`useruuid`,`targetuuid`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile_picks` (

`pickuuid` varchar(36) NOT NULL,
`creatoruuid` varchar(36) NOT NULL,

`toppick` enum('true','false') NOT NULL,
`parceluuid` varchar(36) NOT NULL,

`name` varchar(255) NOT NULL,

`description` text NOT NULL,

`snapshotuuid` varchar(36) NOT NULL,

`user` varchar(255) NOT NULL,

`originalname` varchar(255) NOT NULL,

`simname` varchar(255) NOT NULL,

`posglobal` varchar(255) NOT NULL,

`sortorder` int(2) NOT NULL,

`enabled` enum('true','false') NOT NULL,
PRIMARY KEY (`pickuuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile` (

`useruuid` varchar(36) NOT NULL,

`profilePartner` varchar(36) NOT NULL,

`profileAllowPublish` binary(1) NOT NULL,

`profileMaturePublish` binary(1) NOT NULL,

`profileURL` varchar(255) NOT NULL,

`profileWantToMask` int(3) NOT NULL,

`profileWantToText` text NOT NULL,

`profileSkillsMask` int(3) NOT NULL,

`profileSkillsText` text NOT NULL,

`profileLanguages` text NOT NULL,

`profileImage` varchar(36) NOT NULL,

`profileAboutText` text NOT NULL,

`profileFirstImage` varchar(36) NOT NULL,

`profileFirstText` text NOT NULL,
PRIMARY KEY (`useruuid`)
)
ENGINE=MyISAM DEFAULT CHARSET=latin1;

CREATE TABLE IF NOT EXISTS `profile_settings` (

`useruuid` varchar(36) NOT NULL,

`imviaemail` enum('true','false') NOT NULL,

`visible` enum('true','false') NOT NULL,

`email` varchar(254) NOT NULL,
PRIMARY KEY (`useruuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

</source >

=== PHP for web server (Propfile.php)===
<source lang=text>

<?PHP
$dbName = "comunity";

$dbHost = "localhost";

$dbUser = "root";

$dbPassword ="";

mysql_connect ($dbHost,$dbUser,$dbPassword);
mysql_select_db ($dbName);

$zeroUUID = "00000000-0000-0000-0000-000000000000";
$xmlrpc_server = xmlrpc_server_create();

xmlrpc_server_register_method($xmlrpc_server, "avatarclassifiedsrequest",
"avatarclassifiedsrequest");

function avatarclassifiedsrequest($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['uuid'];

$result = mysql_query("SELECT * FROM profile_classifieds WHERE ".
"creatoruuid = '". mysql_escape_string($uuid) ."'");

$data = array();

while (($row = mysql_fetch_assoc($result)))
{
$data[] = array(
"classifiedid" => $row["classifieduuid"],
"name" => $row["name"]);
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Classifieds Update

xmlrpc_server_register_method($xmlrpc_server, "classified_update",
"classified_update");

function classified_update($method_name, $params, $app_data)
{
global $zeroUUID;

$req = $params[0];

$classifieduuid = $req['classifiedUUID'];
$creator = $req['creatorUUID'];
$category = $req['category'];
$name = $req['name'];
$description = $req['description'];
$parceluuid = $req['parcelUUID'];
$parentestate = $req['parentestate'];
$snapshotuuid = $req['snapshotUUID'];
$simname = $req['sim_name'];
$globalpos = $req['globalpos'];
$parcelname = $req['parcelname'];
$classifiedflag = $req['classifiedFlags'];
$priceforlist = $req['classifiedPrice'];

// Check if we already have this one in the database
$check = mysql_query("SELECT COUNT(*) FROM profile_classifieds WHERE ".
"classifieduuid = '". mysql_escape_string($classifieduuid) ."'");

while ($row = mysql_fetch_row($check))
{
$ready = $row[0];
}

if ($ready == 0)
{
// Doing some late checking
// Should be done by the module but let's see what happens when
// I do it here

if($parcelname == "")
$parcelname = "Unknown";

if($parceluuid == "")
$parceluuid = $zeroUUID;

if($description == "")
$description = "No Description";

if($classifiedflag == 2)
{
$creationdate = time();
$expirationdate = time() + (7 * 24 * 60 * 60);
}
else
{
$creationdate = time();
$expirationdate = time() + (365 * 24 * 60 * 60);
}

$insertquery = "INSERT INTO profile_classifieds VALUES ".
"('". mysql_escape_string($classifieduuid) ."',".
"'". mysql_escape_string($creator) ."',".
"". mysql_escape_string($creationdate) .",".
"". mysql_escape_string($expirationdate) .",".
"'". mysql_escape_string($category) ."',".
"'". mysql_escape_string($name) ."',".
"'". mysql_escape_string($description) ."',".
"'". mysql_escape_string($parceluuid) ."',".
"". mysql_escape_string($parentestate) .",".
"'". mysql_escape_string($snapshotuuid) ."',".
"'". mysql_escape_string($simname) ."',".
"'". mysql_escape_string($globalpos) ."',".
"'". mysql_escape_string($parcelname) ."',".
"". mysql_escape_string($classifiedflag) .",".
"". mysql_escape_string($priceforlist) .")";

// Create a new record for this classified
$result = mysql_query($insertquery);
}
else
{

}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Classifieds Delete

xmlrpc_server_register_method($xmlrpc_server, "classified_delete",
"classified_delete");

function classified_delete($method_name, $params, $app_data)
{
$req = $params[0];

$classifieduuid = $req['classifiedID'];

$result = mysql_query("DELETE FROM profile_classifieds WHERE ".
"classifieduuid = '".mysql_escape_string($classifieduuid) ."'");

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

#
# Picks
#

# Avatar Picks Request

xmlrpc_server_register_method($xmlrpc_server, "avatarpicksrequest", "avatarpicksrequest");

function avatarpicksrequest($method_name, $params, $app_data)
{
$req = $params[0];
$uuid = $req['uuid'];
$data = array();
$result = mysql_query("SELECT `pickuuid`,`name` FROM profile_picks WHERE ". "creatoruuid = '". mysql_escape_string($uuid) ."'");

while (($row = mysql_fetch_assoc($result)))
{
$data[] = array(
"pickid" => $row["pickuuid"],
"name" => $row["name"]);
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Request Picks for User

xmlrpc_server_register_method($xmlrpc_server, "pickinforequest",
"pickinforequest");

function pickinforequest($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$pick = $req['pick_id'];

$data = array();

$result = mysql_query("SELECT * FROM profile_picks WHERE ".
"creatoruuid = '". mysql_escape_string($uuid) ."' AND ".
"pickuuid = '". mysql_escape_string($pick) ."'");

$row = mysql_fetch_assoc($result);
if ($row != False)
{
if ($row["description"] == null || $row["description"] == "")
$row["description"] = "No description given";

$data[] = array(
"pickuuid" => $row["pickuuid"],
"creatoruuid" => $row["creatoruuid"],
"toppick" => $row["toppick"],
"parceluuid" => $row["parceluuid"],
"name" => $row["name"],
"description" => $row["description"],
"snapshotuuid" => $row["snapshotuuid"],
"user" => $row["user"],
"originalname" => $row["originalname"],
"simname" => $row["simname"],
"posglobal" => $row["posglobal"],
"sortorder"=> $row["sortorder"],
"enabled" => $row["enabled"]);
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Picks Update

xmlrpc_server_register_method($xmlrpc_server, "picks_update",
"picks_update");

function picks_update($method_name, $params, $app_data)
{
global $zeroUUID;

$req = $params[0];

$pickuuid = $req['pick_id'];
$creator = $req['creator_id'];
$toppick = $req['top_pick'];
$name = $req['name'];
$description = $req['desc'];
$parceluuid = $req['parcel_uuid'];
$snapshotuuid = $req['snapshot_id'];
$user = $req['user'];
$simname = $req['sim_name'];
$posglobal = $req['pos_global'];
$sortorder = $req['sort_order'];
$enabled = $req['enabled'];

if($parceluuid == "")
$parceluuid = $zeroUUID;

if($description == "")
$description = "No Description";

// Check if we already have this one in the database
$check = mysql_query("SELECT COUNT(*) FROM profile_picks WHERE ".
"pickuuid = '". mysql_escape_string($pickuuid) ."'");

$row = mysql_fetch_row($check);

if ($row[0] == 0)
{
if($user == null || $user == "")
$user = "Unknown";

//The original parcel name is the same as the name of the
//profile pick when a new profile pick is being created.
$original = $name;

$query = "INSERT INTO profile_picks VALUES ".
"('". mysql_escape_string($pickuuid) ."',".
"'". mysql_escape_string($creator) ."',".
"'". mysql_escape_string($toppick) ."',".
"'". mysql_escape_string($parceluuid) ."',".
"'". mysql_escape_string($name) ."',".
"'". mysql_escape_string($description) ."',".
"'". mysql_escape_string($snapshotuuid) ."',".
"'". mysql_escape_string($user) ."',".
"'". mysql_escape_string($original) ."',".
"'". mysql_escape_string($simname) ."',".
"'". mysql_escape_string($posglobal) ."',".
"'". mysql_escape_string($sortorder) ."',".
"'". mysql_escape_string($enabled) ."')";
}
else
{
$query = "UPDATE profile_picks SET " .
"parceluuid = '". mysql_escape_string($parceluuid) . "', " .
"name = '". mysql_escape_string($name) . "', " .
"description = '". mysql_escape_string($description) . "', " .
"snapshotuuid = '". mysql_escape_string($snapshotuuid) . "' WHERE ".
"pickuuid = '". mysql_escape_string($pickuuid) ."'";
}

$result = mysql_query($query);
if ($result != False)
$result = True;

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

# Picks Delete

xmlrpc_server_register_method($xmlrpc_server, "picks_delete",
"picks_delete");

function picks_delete($method_name, $params, $app_data)
{
$req = $params[0];

$pickuuid = $req['pick_id'];

$result = mysql_query("DELETE FROM profile_picks WHERE ".
"pickuuid = '".mysql_escape_string($pickuuid) ."'");

if ($result != False)
$result = True;

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

#
# Notes
#

# Avatar Notes Request

xmlrpc_server_register_method($xmlrpc_server, "avatarnotesrequest",
"avatarnotesrequest");

function avatarnotesrequest($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$targetuuid = $req['uuid'];

$result = mysql_query("SELECT notes FROM profile_notes WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");

$row = mysql_fetch_row($result);
if ($row == False)
$notes = "";
else
$notes = $row[0];

$data[] = array(
"targetid" => $targetuuid,
"notes" => $notes);

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

# Avatar Notes Update

xmlrpc_server_register_method($xmlrpc_server, "avatar_notes_update",
"avatar_notes_update");

function avatar_notes_update($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$targetuuid = $req['target_id'];
$notes = $req['notes'];

// Check if we already have this one in the database

$check = mysql_query("SELECT COUNT(*) FROM profile_notes WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");

$row = mysql_fetch_row($check);

if ($row[0] == 0)
{
// Create a new record for this avatar note
$result = mysql_query("INSERT INTO profile_notes VALUES ".
"('". mysql_escape_string($uuid) ."',".
"'". mysql_escape_string($targetuuid) ."',".
"'". mysql_escape_string($notes) ."')");
}
else if ($notes == "")
{
// Delete the record for this avatar note
$result = mysql_query("DELETE FROM profile_notes WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");
}
else
{
// Update the existing record
$result = mysql_query("UPDATE profile_notes SET ".
"notes = '". mysql_escape_string($notes) ."' WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."' AND ".
"targetuuid = '". mysql_escape_string($targetuuid) ."'");
}

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

# Profile bits

xmlrpc_server_register_method($xmlrpc_server, "avatar_properties_request",
"avatar_properties_request");

function avatar_properties_request($method_name, $params, $app_data)
{
global $zeroUUID;

$req = $params[0];

$uuid = $req['avatar_id'];

$result = mysql_query("SELECT * FROM profile WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."'");
$row = mysql_fetch_assoc($result);

if ($row != False)
{
$data[] = array(
"ProfileUrl" => $row["profileURL"],
"Image" => $row["profileImage"],
"AboutText" => $row["profileAboutText"],
"FirstLifeImage" => $row["profileFirstImage"],
"FirstLifeAboutText" => $row["profileFirstText"],
"Partner" => $row["profilePartner"],

//Return interest data along with avatar properties
"wantmask" => $row["profileWantToMask"],
"wanttext" => $row["profileWantToText"],
"skillsmask" => $row["profileSkillsMask"],
"skillstext" => $row["profileSkillsText"],
"languages" => $row["profileLanguages"]);
}
else
{
//Insert empty record for avatar.
//FIXME: Should this only be done when asking for ones own profile?
$sql = "INSERT INTO profile VALUES ( ".
"'". mysql_escape_string($uuid) ."', ".
"'$zeroUUID', 0, 0, '', 0, '', 0, '', '', ".
"'$zeroUUID', '', '$zeroUUID', '')";
$result = mysql_query($sql);

$data[] = array(
"ProfileUrl" => "",
"Image" => $zeroUUID,
"AboutText" => "",
"FirstLifeImage" => $zeroUUID,
"FirstLifeAboutText" => "",
"Partner" => $zeroUUID,

"wantmask" => 0,
"wanttext" => "",
"skillsmask" => 0,
"skillstext" => "",
"languages" => "");
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

xmlrpc_server_register_method($xmlrpc_server, "avatar_properties_update",
"avatar_properties_update");

function avatar_properties_update($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$profileURL = $req['ProfileUrl'];
$image = $req['Image'];
$abouttext = $req['AboutText'];
$firstlifeimage = $req['FirstLifeImage'];
$firstlifetext = $req['FirstLifeAboutText'];

$result=mysql_query("UPDATE profile SET ".
"profileURL='". mysql_escape_string($profileURL) ."', ".
"profileImage='". mysql_escape_string($image) ."', ".
"profileAboutText='". mysql_escape_string($abouttext) ."', ".
"profileFirstImage='". mysql_escape_string($firstlifeimage) ."', ".
"profileFirstText='". mysql_escape_string($firstlifetext) ."' ".
"WHERE useruuid='". mysql_escape_string($uuid) ."'"
);

$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => mysql_error()
));

print $response_xml;
}

// Profile Interests

xmlrpc_server_register_method($xmlrpc_server, "avatar_interests_update",
"avatar_interests_update");

function avatar_interests_update($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];
$wanttext = $req['wanttext'];
$wantmask = $req['wantmask'];
$skillstext = $req['skillstext'];
$skillsmask = $req['skillsmask'];
$languages = $req['languages'];

$result = mysql_query("UPDATE profile SET ".
"profileWantToMask = ". mysql_escape_string($wantmask) .",".
"profileWantToText = '". mysql_escape_string($wanttext) ."',".
"profileSkillsMask = ". mysql_escape_string($skillsmask) .",".
"profileSkillsText = '". mysql_escape_string($skillstext) ."',".
"profileLanguages = '". mysql_escape_string($languages) ."' ".
"WHERE useruuid = '". mysql_escape_string($uuid) ."'"
);

$response_xml = xmlrpc_encode(array(
'success' => True
));

print $response_xml;
}

// User Preferences

xmlrpc_server_register_method($xmlrpc_server, "user_preferences_request",
"user_preferences_request");

function user_preferences_request($method_name, $params, $app_data)
{
$req = $params[0];

$uuid = $req['avatar_id'];

$result = mysql_query("SELECT imviaemail,visible,email FROM profile_settings WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."'");

$row = mysql_fetch_assoc($result);

if ($row != False)
{
$data[] = array(
"imviaemail" => $row["imviaemail"],
"visible" => $row["visible"],
"email" => $row["email"]);
}
else
{
//Insert empty record for avatar.
//NOTE: The 'false' values here are enums defined in database
$sql = "INSERT INTO profile_settings VALUES ".
"('". mysql_escape_string($uuid) ."', ".
"'false', 'false', '')";
$result = mysql_query($sql);

$data[] = array(
"imviaemail" => False,
"visible" => False,
"email" => "");
}

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

xmlrpc_server_register_method($xmlrpc_server, "user_preferences_update",
"user_preferences_update");

function user_preferences_update($method_name, $params, $app_data)
{

$req = $params[0];

$uuid = $req['avatar_id'];
$wantim = $req['imViaEmail'];
$directory = $req['visible'];

$result = mysql_query("UPDATE profile_settings SET ".
"imviaemail = '".mysql_escape_string($wantim) ."', ".
"visible = '".mysql_escape_string($directory) ."' WHERE ".
"useruuid = '". mysql_escape_string($uuid) ."'");

$response_xml = xmlrpc_encode(array(
'success' => True,
'data' => $data
));

print $response_xml;
}

#
# Process the request
#

$request_xml = $HTTP_RAW_POST_DATA;
xmlrpc_server_call_method($xmlrpc_server, $request_xml, '');
xmlrpc_server_destroy($xmlrpc_server);
?>

</source >

Offline Messaging

2012-01-02T07:16:15Z

Shanea: /* Through PHP module */

__NOTOC__
{{Quicklinks}}
 

Offline messaging makes it possible to send IM's to people that are not online and saves the messages directly to a database. 
Please note that these are third party modules which you use at your own risk! 
OpenSimulator takes no responsibility for these modules.

=== Through PHP module ===

In the latest version offline module is already ready to be used
* Install the Offline_IM.sql file on your database [http://www.apachefriends.org xampp]
* Enable the Offline Messaging Module in your Opensim.ini file. 
* Upload the offline.php to your web server [http://www.apachefriends.org xampp]

=== Changes in the OpenSim.ini file ===

<source lang=text>
[Messaging]
; Control which region module is used for instant messaging.
; Default is InstantMessageModule (this is the name of the core IM module as well as the setting)
InstantMessageModule = InstantMessageModule
; MessageTransferModule = MessageTransferModule
OfflineMessageModule = OfflineMessageModule
OfflineMessageURL = http://yourserver/offline.php
MuteListModule = MuteListModule
MuteListURL = http://yourserver/mute.php
ForwardOfflineGroupMessages = true
</source>

When you did it right, reboot your region and try to send a message to an offline person. Check the database to see that it has written a record.

Next time that person logs in, he will get the message and the database will be updated

P.D: The MuteListModule and URL must be uncommented in order for the offline module to work, even if there is no mute.php file in the web folder.

=== SQL file to load (Offline_IM.txt)===
<source lang=text>

CREATE TABLE IF NOT EXISTS `Offline_IM` (
`uuid` varchar(36) NOT NULL,
`message` text NOT NULL,
KEY `uuid` (`uuid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

</source >

=== PHP for web server (offline.php)===
<source lang=text>
<?php
$dbName = "comunity";
$dbHost = "localhost";
$dbUser = "root";
$dbPassword ="";

define("C_DB_TYPE","mysql");
define("C_DB_HOST",$dbHost);
define("C_DB_NAME",$dbName);
define("C_DB_USER",$dbUser);
define("C_DB_PASS",$dbPassword);
define("C_OFFLINE_IM_TBL", "Offline_IM");
include("mysql.php");
$DbLink = new DB;
$method = $_SERVER["PATH_INFO"];
if ($method == "/SaveMessage/")
{
$msg = $HTTP_RAW_POST_DATA;
$start = strpos($msg, "?>");
if ($start != -1)
{
$start+=2;
$msg = substr($msg, $start);
$parts = split("[<>]", $msg);
$to_agent = $parts[12];
$DbLink->query("insert into ".C_OFFLINE_IM_TBL." (uuid, message) values ('" .
mysql_escape_string($to_agent) . "', '" .
mysql_escape_string($msg) . "')");
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?><boolean>true</boolean>";
}
else
{
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?><boolean>false</boolean>";
}
exit;
}
if ($method == "/RetrieveMessages/")
{
$parms = $HTTP_RAW_POST_DATA;
$parts = split("[<>]", $parms);
$agent_id = $parts[6];
$DbLink->query("select message from ".C_OFFLINE_IM_TBL." where uuid='" .
mysql_escape_string($agent_id) . "'");
echo "<?xml version=\"1.0\" encoding=\"utf-8\"?><ArrayOfGridInstantMessage xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\">";
while(list($message) = $DbLink->next_record())
{
echo $message;
}
echo "</ArrayOfGridInstantMessage>";
$DbLink->query("delete from ".C_OFFLINE_IM_TBL." where uuid='" .
mysql_escape_string($agent_id) . "'");
exit;
}
?>
</source >