Yes I see these all exist for individual grids, but not for a none grid 
specific search system like a search engine, a search engine is not able to 
search your database, and if I owned a grid I would never give a search engine 
access to my database, and with me wanting to start a search engine I am not 
going to ask for access to a grid database, I’m wanting to create a search 
engine just for virtual worlds where you can search for anything virtual world 
related, so you can search for grids, grids articles in the blog, articles that 
people who use virtual worlds, news on virtual worlds, and so forth, not create 
a inworld search.  Was thinking the land and users would be good, especially if 
you can get profile information, and on a note to the email yesterday about the 
GDPR their would only be an issue if I was to display information that is not 
already available on the internet, it would be a search engine searching sites 
that is public, and only looking at information that is available, it would 
follow all robots.txt requests and also all robots meta requests.

Sent from Mail for Windows 10

From: [email protected]
Sent: 05 July 2018 13:00
To: [email protected]
Subject: Opensim-dev Digest, Vol 48, Issue 5

Send Opensim-dev mailing list submissions to
        [email protected]

To subscribe or unsubscribe via the World Wide Web, visit
        http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev
or, via email, send a message with subject or body 'help' to
        [email protected]

You can reach the person managing the list at
        [email protected]

When replying, please edit your Subject line so it is more specific
than "Re: Contents of Opensim-dev digest..."


Today's Topics:

   1. Re: Introduction of a sitemap style system for users and land
      (Michel Beauregard)
   2. Re: diva search tool (Michel Beauregard)


----------------------------------------------------------------------

Message: 1
Date: Wed, 4 Jul 2018 20:21:10 +0000 (UTC)
From: Michel Beauregard <[email protected]>
To: <[email protected]>
Subject: Re: [Opensim-dev] Introduction of a sitemap style system for
        users and land
Message-ID: <[email protected]>
Content-Type: text/plain; charset=UTF-8

The following?? email present was? is already existing via Diva and other 
contibutors. 

?search php? source code for access registered datasnapshot information:
<?php
$dbug=false;
$sval=mysql_real_escape_string($_GET["sname"]);
echo "searching for ", $sval," \n";
if ( strlen($sval) <3){
? echo? "need more then two letters to make search please \n"; 
? return;
}

if ( strlen($sval) >63){
? echo? "not more then 63? letters to make search please \n"; 
? return;
}
?? ?
if (!preg_match("/^[a-zA-Z ]*$/",$sval)) {
? echo? "Only letters and white space allowed \n"; 
? return;
}

$sval="%".mysql_real_escape_string($_GET["sname"])."%";

$DB_HOST = "localhost";
$DB_USER = "opensim";
$DB_PASSWORD = "xxxxx";
$DB_NAME = "ossearch";

if ($dbug){
?? ?echo $sval;
?? ?echo "<br/>";
?? ?echo $DB_HOST ;
?? ?echo "<br/>";
?? ?echo $DB_USER;
?? ?echo "<br/>";
?? ?echo $DB_PASSWORD;
?? ?echo "<br/>";
?? ?}

$conn = mysqli_connect ($DB_HOST, $DB_USER, $DB_PASSWORD, $DB_NAME);

if (mysqli_connect_errno())
? {
? echo "Failed to connect to MySQL: " . mysqli_connect_error();
? }

//$sql = "SELECT * FROM `objects` WHERE `name` LIKE \'%Tulip%\' LIMIT 0, 30 ";
//$sql = "SELECT * FROM `objects` WHERE `name` LIKE '%Tulip%'? LIMIT 0, 30 ";
//$sql = "SELECT * FROM `objects` INNER JOIN `regions` ON `objects.regionuuid` 
= `regions.regionuuid` LIMIT 0, 30 ";
//$sql = "SELECT `regionuuid` FROM `objects`";
//$sql = "SELECT `regionname`, `regionuuid`, `regionhandle`, `url`, `owner`, 
`owneruuid` FROM `regions` WHERE 1 LIMIT 0, 30 ";
$sql = "SELECT `location`, `name`, `description` , `regionname` FROM `objects` 
INNER JOIN `regions` ON objects.`regionuuid`=regions.`regionuuid` WHERE `name`? 
LIKE? '".? $sval . "' LIMIT 0, 300 ";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
?? echo "found ".$result->num_rows." item(s)? clic on the link below TWO times 
to teleport to object? \n";
??? // output data of each row
??? while($row = $result->fetch_assoc()) {
//??????? echo "Name: " . $row["name"]. " - Description: " . 
$row["description"]. " RegionName" . $row["regionname"]." Location" . 
$row["location"]. "<br>";
??????? echo "NAME: " . $row["name"]. " - DESC: " . $row["description"]. "? - 
LOC? https://gimisa/region/"; . $row["regionname"]."/" . $row["location"];
??? }
} else {
??? echo "0 results";
}
$conn->close();
?>

As explain here http://metaverseink.com/docs/listing.html? To create your owne 
address search location using the above is as? simple as populating the 
opensim.ini file with? your site data. For exemple for my location? 
(3d.gimisa.ca:9000 ) the opensim.ini dataSnapshot? configuration is changed as 
follow with data_services pointing to metaverse search location in addition to 
my own internal location search facility :

[DataSnapshot]
??? index_sims = true
??? data_exposure = minimum

??? gridname = "GiMiSa"
??? ; 1 hour
??? default_snapshot_period = 13600
??? snapshot_cache_directory = "DataSnapshot"
??? 
data_services="http://192.168.2.105/register.php;http://metaverseink.com/cgi-bin/register.py";

The data_service register.php code is as follows:
<?php
//////////////////////////////////////////////////////////////////////////////
// register.php???????????????????????????????????????????????????????????? //
// (C) 2008, Fly-man-?????????????????????????????????????????????????????? //
// This file contains the registration of a simulator to the database?????? //
// and checks if the simulator is new in the database or a reconnected one? //
//????????????????????????????????????????????????????????????????????????? //
// If the simulator is old, check if the nextcheck date > registration????? //
// When the date is older, make a request to the Parser to grab new data??? //
//////////////////////////////////////////////////////////////////////////////

include("databaseinfo.php");
//establish connection to master db server
mysql_connect ($DB_HOST, $DB_USER, $DB_PASSWORD);
mysql_select_db ($DB_NAME);

$hostname = $_GET['host'];
$port = $_GET['port'];
$service = $_GET['service'];

if ($hostname != "" && $port != "" && $service == "online")
{
??? // Check if there is already a database row for this host
??? $checkhost = mysql_query("SELECT register FROM hostsregister WHERE " .
??????????? "host = '" . mysql_real_escape_string($hostname) . "' AND " .
??????????? "port = '" . mysql_real_escape_string($port) . "'");

??? // Get the request time as a timestamp for later
??? $timestamp = $_SERVER['REQUEST_TIME'];

??? // if greater than 1, check the nextcheck date
??? if (mysql_num_rows($checkhost) > 0)
??? {
??????? $update = "UPDATE hostsregister SET " .
??????????????? "register = '" . mysql_real_escape_string($timestamp) . "', " . 
??????????????? "nextcheck = '0', checked = '0', " .
??????????????? "failcounter = '0' " . ?
??????????????? "WHERE host = '" . mysql_real_escape_string($hostname) . "' AND 
" .
??????????????? "port = '" . mysql_real_escape_string($port) . "'";

??????? $runupdate = mysql_query($update);
??? }
??? else
??? {
??????? $register = "INSERT INTO hostsregister VALUES ".
??????????????????? "('" . mysql_real_escape_string($hostname) . "', " .
??????????????????? "'" . mysql_real_escape_string($port) . "', " .
??????????????????? "'" . mysql_real_escape_string($timestamp) . "', 0, 0, 0)";

??????? $runupdate = mysql_query($register);
??? }
}
elseif ($hostname != "" && $port != "" && $service = "offline")
{
??????? $delete = "DELETE FROM hostsregister " .
??????????????? "WHERE host = '" . mysql_real_escape_string($hostname) . "' AND 
" .
??????????????? "port = '" . mysql_real_escape_string($port) . "'";

??????? $rundelete = mysql_query($delete);
}
?>

More detail about diva search can be found here: 
http://www.metaverseink.com/blog/news/metaverse-ink-search-for-opensims/ . 
Please note Metaverse search facility is broken since about begining of the 
year as it was before and? as it was never intended for full fledge support as 
opensim searching tool. 

This article in hypergrid business give Maria's reflection on the subject in 
2014? 
https://www.hypergridbusiness.com/2014/07/two-ideas-for-better-search-for-opensim/

(Happy 4th of July to our Americain friends .)

hope the above is? helpfull. GiMiSa 


------------------------------

Message: 2
Date: Thu, 5 Jul 2018 10:50:21 +0000 (UTC)
From: Michel Beauregard <[email protected]>
To: <[email protected]>
Subject: Re: [Opensim-dev] diva search tool
Message-ID: <[email protected]>
Content-Type: text/plain; charset=UTF-8

I forgot to mention the search option of metaversinkl.? That? 2007 web page? is 
not that easy to find :
http://metaverseink.com/docs/tips.html

Interesting is the searcheable elements: product, place,sim, notecard please 
also note that the description field of an objject can be search. 
Naturaly the php coding posted earlier does not offer that depth of searching 
but ones know that the information is available.
GiMiSa



------------------------------

_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev


End of Opensim-dev Digest, Vol 48, Issue 5
******************************************

_______________________________________________
Opensim-dev mailing list
[email protected]
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-dev

Reply via email to