MuteList - Revision history

Djphil: /* mutelist.php */

2018-05-11T19:10:24Z

‎mutelist.php

Djphil at 06:02, 10 May 2018

2018-05-10T06:02:39Z

Djphil: /* Mutelist Source Code */

2018-05-10T06:02:19Z

‎Mutelist Source Code

Djphil at 06:00, 10 May 2018

2018-05-10T06:00:29Z

Djphil at 05:59, 10 May 2018

2018-05-10T05:59:49Z

Djphil: Created page with "{{Quicklinks}} = Mutelist Overview = OpenSimMutelist add-on module for OpenSimulator == What is "Mutelist" in OpenSimulator? == ''Mutelist'' is ... == How it works? == Coming ..."

2018-05-09T08:21:54Z

Created page with "{{Quicklinks}} = Mutelist Overview = OpenSimMutelist add-on module for OpenSimulator == What is "Mutelist" in OpenSimulator? == ''Mutelist'' is ... == How it works? == Coming ..."

New page

{{Quicklinks}}
= Mutelist Overview =
OpenSimMutelist add-on module for OpenSimulator
== What is "Mutelist" in OpenSimulator? ==
''Mutelist'' is ...
== How it works? ==
Coming soon ...
== Compiling the module ==
Coming soon ...
== First time installation and configuration ==
Coming soon ...

== Mutelist Table Structure ==
{| style="border:1px solid #ccc;"
|- style="background:#cce;"
! Field
! Type
! Collation
! Attributes
! Null
! Default
! Extra
|-
| '''[[#agentid|AgentID]]''' || char(36) || utf8_unicode_ci || || NOT NULL || ||

|-style="background:#eee;"
| '''[[#muteid|MuteID]]''' || char(36) || utf8_unicode_ci || || NOT NULL || ||

|-
| '''[[#mutename|MuteName]]''' || varchar(255) || utf8_unicode_ci || || NOT NULL || ||

|-style="background:#eee;"
| '''[[#type|type]]''' || int(11) || utf8_unicode_ci || UNSIGNED || NOT NULL || ||

|-
| '''[[#flags|flags]]''' || int(11) || utf8_unicode_ci || UNSIGNED || NOT NULL || ||

|-style="background:#eee;"
| '''[[#stamp|Stamp]]''' || timestamp || utf8_unicode_ci || DEFAULT || NOT NULL || ''CURRENT_TIMESTAMP'' ||
|}

== Mutelist Table Fields ==
;<div id="agentid">'''AgentID'''</div>
:The UUID of ...
;<div id="muteid">'''MuteID'''</div>
:The UUID of ...
;<div id="mutename">'''MuteName'''</div>
:The Name of ...
;<div id="type">'''type'''</div>
:The type of ...
;<div id="flags">'''flags'''</div>
:The flags of ...
;<div id="stamp">'''Stamp'''</div>
:The Stamp of ...

== mutelist.sql ==
<source lang="sql">
CREATE TABLE IF NOT EXISTS `mutelist` (
`AgentID` char(36) COLLATE utf8_unicode_ci NOT NULL,
`MuteID` char(36) COLLATE utf8_unicode_ci NOT NULL,
`MuteName` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`type` int(11) UNSIGNED NOT NULL,
`flags` int(11) UNSIGNED NOT NULL,
`Stamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
UNIQUE KEY `AgentID_2` (`AgentID`,`MuteID`) USING BTREE,
KEY `AgentID` (`AgentID`) USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
</source>

== databaseinfo.php ==
<source lang="php">
<?php
$DB_HOST = "localhost";
$DB_USER = "root";
$DB_PASSWORD = "";
$DB_NAME = "osmodules";
?>
</source>

== mutelist.php ==
<source lang="php">
<?php
include("databaseinfo.php");

// Attempt to connect to the database with the mutelist table
try {
$db = new PDO("mysql:host=$DB_HOST;dbname=$DB_NAME", $DB_USER, $DB_PASSWORD);
$db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
}
catch(PDOException $e)
{
echo "Error connecting to the database with the mutelist table\n";
file_put_contents('PDOErrors.txt', $e->getMessage() . "\n-----\n", FILE_APPEND);
exit;
}
###################### No user serviceable parts below #####################
function get_error_message($result)
{
global $db;
if (!$result)
return "";
$errorInfo = $db->errorInfo();
return $errorInfo[2];
}
#
# The XMLRPC server object
#
$xmlrpc_server = xmlrpc_server_create();
#
# Return list of muted agents and objects
#
xmlrpc_server_register_method($xmlrpc_server, "mutelist_request", "mutelist_request");
function mutelist_request($method_name, $params, $app_data)
{
global $db;
$req = $params[0];
$avatarUUID = $req['avataruuid'];
$query = $db->prepare("SELECT * FROM mutelist WHERE AgentID = ?");
$result = $query->execute( array($avatarUUID) );
$mutelist = "";
if ($query->rowCount() > 0)
{
while ($row = $query->fetch(PDO::FETCH_ASSOC))
{
$mutelist .= $row["type"] . " ";
$mutelist .= $row["MuteID"] . " ";
$mutelist .= $row["MuteName"] . "|";
$mutelist .= $row["flags"] . "\n";
}
}
$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => get_error_message($result),
'mutelist' => $mutelist
));
print $response_xml;
}
#
# Remove an event notify reminder request
#
xmlrpc_server_register_method($xmlrpc_server, "mutelist_update", "mutelist_update");
function mutelist_update($method_name, $params, $app_data)
{
global $db;
$req = $params[0];
$avatarUUID = $req['avataruuid'];
$muteUUID = $req['muteuuid'];
$name = $req['name'];
$type = $req['type'];
$flags = $req['flags'];
$query = $db->prepare("INSERT INTO mutelist VALUES (?, ?, ?, ?, ?, NOW())");
$result = $query->execute(
array($avatarUUID, $muteUUID, $name, $type, $flags) );
$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => get_error_message($result)
));
print $response_xml;
}
#
# Remove an event notify reminder request
#
xmlrpc_server_register_method($xmlrpc_server, "mutelist_remove", "mutelist_remove");
function mutelist_remove($method_name, $params, $app_data)
{
global $db;
$req = $params[0];
$avatarUUID = $req['avataruuid'];
$muteUUID = $req['muteuuid'];
$query = $db->prepare("DELETE FROM mutelist WHERE" .
" AgentID = ? AND MuteID = ?");
$result = $query->execute( array($avatarUUID, $muteUUID) );
$response_xml = xmlrpc_encode(array(
'success' => $result,
'errorMessage' => get_error_message($result)
));
print $response_xml;
}
#
# Process the request
#
$request_xml = file_get_contents("php://input");
xmlrpc_server_call_method($xmlrpc_server, $request_xml, '');
xmlrpc_server_destroy($xmlrpc_server);
?>
</source>

== Mutelist Source Code ==
OpenSim Mutelist source code is available on github @ [https://github.com/kcozens/OpenSimMutelist OpenSimMutelist]

@@ Line 2: / Line 2: @@
 <div style="background-color:#FFA0A0; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">
-'''Caution !''' Valid with MuteList Addons and OpenSimulator v0.9.0. For OpenSim v0.9.1, MuteList is a Core module.
+'''Caution !''' Valid with MuteList Add-on and OpenSimulator v0.9.0. For OpenSim v0.9.1, MuteList is a Core module.
 </div>
 <br />

@@ Line 2: / Line 2: @@
 <div style="background-color:#FFA0A0; padding:10px; padding-bottom:5px; border: 1px #FF544F solid">
-'''Caution !''' Valid with MuteList Addons and OpenSimulator v0.9.0.0. For OpenSim v0.9.1, MuteList is a Core module.
+'''Caution !''' Valid with MuteList Addons and OpenSimulator v0.9.0. For OpenSim v0.9.1, MuteList is a Core module.
 </div>
 = Mutelist Overview =

@@ Line 156: / Line 156: @@
      $flags      = $req['flags'];
      $query = $db->prepare("INSERT INTO mutelist VALUES (?, ?, ?, ?, ?, NOW())");
-     $result = $query->execute(
+     $result = $query->execute(array($avatarUUID, $muteUUID, $name, $type, $flags) );
-                    array($avatarUUID, $muteUUID, $name, $type, $flags) );
      $response_xml = xmlrpc_encode(array(
          'success'      => $result,
@@ Line 174: / Line 173: @@
      $avatarUUID = $req['avataruuid'];
      $muteUUID   = $req['muteuuid'];
-     $query = $db->prepare("DELETE FROM mutelist WHERE" .
+     $query = $db->prepare("DELETE FROM mutelist WHERE "." AgentID = ? AND MuteID = ?");
-                          " AgentID = ? AND MuteID = ?");
      $result = $query->execute( array($avatarUUID, $muteUUID) );
      $response_xml = xmlrpc_encode(array(

@@ Line 192: / Line 192: @@
 </source>
-== Mutelist Source Code ==
+== Mutelist Add-on Module Source Code ==
 OpenSim Mutelist source code is available on github @ [https://github.com/kcozens/OpenSimMutelist OpenSimMutelist]

@@ Line 1: / Line 1: @@
 {{Quicklinks}}
 = Mutelist Overview =
 OpenSimMutelist add-on module for OpenSimulator