Thank you very much for your prompt reply Fred.

Please excuse my English. I did not know how to explain myself.

I need to deduce many sURL (the local coordinates) starting from the global ones that are in the tables.

I rephrase the question :
How can I get the "local" position = “514/434/21” knowing the "global" positions that are in the tables = “884/59/21” ?

Luisillo Contepomi

El 10/10/24 a las 21:20, Fred Beckhusen escribió:
Wrong question to ask.  These are not possible to get the answer you want from 
that table.  Its the local cordinate, and is not global.

The region.ini  have Location = 1000,996 in "region" table locX 256000
locY 254976 locZ null.

For global, divide by 256 to get the lower left coordinate of the region.

These a local coordinates :

X = 884.666
Y = 59.6383
Z = 21.0327


X i is  884 meters inside of  the region at 1000,996, so the global X is

Global X = 1000*256  + 884.666 = 256884.555
Global Y is 996 * 256 + 59.6383 and so on
Global Z is  21.0327  as it starts at 0.

Fred



________________________________
From: opensim-users-boun...@opensimulator.org 
<opensim-users-boun...@opensimulator.org> on behalf of 
opensim-users-requ...@opensimulator.org <opensim-users-requ...@opensimulator.org>
Sent: Thursday, October 10, 2024 7:00 AM
To: opensim-users@opensimulator.org <opensim-users@opensimulator.org>
Subject: Opensim-users Digest, Vol 110, Issue 1

Send Opensim-users mailing list submissions to
         opensim-users@opensimulator.org

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

You can reach the person managing the list at
         opensim-users-ow...@opensimulator.org

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


Today's Topics:

    1. The relationship between the data indicated in the table land
       or ossearch_parcels and ossearch_all_parcels "landingpoint" and
       the "real" landingpoint on the parcel (Luisillo Contepomi)


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

Message: 1
Date: Wed, 9 Oct 2024 19:55:40 +0200
From: Luisillo Contepomi <luisillocontep...@gmail.com>
To: opensim-users@opensimulator.org
Subject: [Opensim-users] The relationship between the data indicated
         in the table land or ossearch_parcels and ossearch_all_parcels
         "landingpoint" and the "real" landingpoint on the parcel
Message-ID: <4876adee-34b1-4efc-92d2-4143150c2...@gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed


Hi all,
I am spending time for days with this issue any help will be greatly
appreciated.

I am doing my webs for the grid totally new updating to mysqli and php7

I found a problem with locations for create surl

The region.ini  have Location = 1000,996 in "region" table locX 256000
locY 254976 locZ null.

a parcel named "recreo" is in the world /514/434/21

table=land
--------------
SELECT `UserLocationX`,`UserLocationY`,`UserLocationZ` FROM `land` WHERE
`Name` like '%recreo%';
884.666 59.6383 21.0327

table=os_search_allparcels
--------------------------
SELECT `landingpoint` FROM `os_search_allparcels` WHERE `parcelname`like
'%recreo%';
884.666/59.6383/21.0327

table=os_search_parcels
----------------------------------
SELECT `landingpoint` FROM `os_search_parcels` WHERE `parcelname`like
'%recreo%';
884.666/59.6383/21.0327

the same location numbers into three tables but
teleports to the indicated position are in middle of nowhere in the ocean.
all regions are 1024x1024

in the world the real position is
hop://grid.contepomi.net:8002/Colegio_Hotaru/514/434/21

Now my question is What is the mathematical relationship between the
position on the tables and the actual position of the landing point
marked on the plot?

How can obtain this "514/434/21" from the data in tables as "884/59/21" ?

Best regards,
Luisillo Contepomi


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

_______________________________________________
Opensim-users mailing list
Opensim-users@opensimulator.org
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users


End of Opensim-users Digest, Vol 110, Issue 1
*********************************************


_______________________________________________
Opensim-users mailing list
Opensim-users@opensimulator.org
http://opensimulator.org/cgi-bin/mailman/listinfo/opensim-users

Reply via email to