Welcome to the Second Life Forums Archive

These forums are CLOSED. Please visit the new forums HERE

Second life + external DB

Mose Salomon
Registered User
Join date: 10 Jan 2007
Posts: 6
06-19-2007 02:55
Hallo, i have one question.

Example:

I have i 10 - 100 lands in Second Life. Each land has 1 or more partials. I have an external database and i send data from second life with HTTPRequest to my server script (PHP) that puts data in database.

How can i define uniqueness of an partial in one land?
How can i define uniqueness of an land in an SIM?

ps. Without defining unique names, because names of lands and partials are in Second life allowed to be the same.

thx in advance
Qie Niangao
Coin-operated
Join date: 24 May 2006
Posts: 7,138
06-19-2007 03:15
From: Mose Salomon
Hallo, i have one question.

Example:

I have i 10 - 100 lands in Second Life. Each land has 1 or more particles. I have an external database and i send data from second life with HTTPRequest to my server script (PHP) that puts data in database.

How can i define uniqueness of an partial in one land?
How can i define uniqueness of an land in an SIM?

ps. Without defining unique names, because names of lands and particles are in Second life allowed to be the same.

thx in advance


If you really mean "particles" then they must be emitted by a prim, for which you might use its UUID as a unique identifier.

But perhaps "parcels" is more germane. There seems to be no guaranteed way to identify a parcel, per se. As explored in several recent threads, combining the values returned by llGetParcelDetails() might be a good hint, but no certain uniqueness.

Of course, a *location* is uniquely associated with a parcel--though that association can change if the parcel is repartitioned. For some DB uses it may be helpful to have that location in global coordinates, the sum of llGetPos() and llGetRegionCorner().

Not sure what a "land" is here... perhaps a set of parcels set or deeded to a group? Groups themselves have UUIDs, and llGetParcelDetails() will return that.
Mose Salomon
Registered User
Join date: 10 Jan 2007
Posts: 6
06-19-2007 03:27
From: Qie Niangao
If you really mean "particles" then they must be emitted by a prim, for which you might use its UUID as a unique identifier.

But perhaps "parcels" is more germane. There seems to be no guaranteed way to identify a parcel, per se. As explored in several recent threads, combining the values returned by llGetParcelDetails() might be a good hint, but no certain uniqueness.

Of course, a *location* is uniquely associated with a parcel--though that association can change if the parcel is repartitioned. For some DB uses it may be helpful to have that location in global coordinates, the sum of llGetPos() and llGetRegionCorner().

Not sure what a "land" is here... perhaps a set of parcels set or deeded to a group? Groups themselves have UUIDs, and llGetParcelDetails() will return that.


I mean "partial" = part of a land
Galbraith Karami
Registered User
Join date: 12 Dec 2006
Posts: 25
06-19-2007 04:07
I remember reading on the wiki that parcels do have UUID... but it's bound to change as its extension or the like change.
Zoha Boa
Registered User
Join date: 12 Mar 2007
Posts: 2,893
06-19-2007 04:12
From: Mose Salomon

How can i define uniqueness of a land in an SIM?

Sim name and center X,Y coordinates of the land (0..255,0..255) maybe ?

I don't know if that position function exist.
_____________________
ZoHa Islands: SL Real Estate Management since 2007
Looking for land ? You will find it @ ZoHa Islands !

Orange Beach Mall: 50 000 sqm shopping fun



http://slurl.com/secondlife/ZoHa%20Islands/222/227/27
website: http://www.ZoHa-Islands.com
Ultralite Soleil
Registered User
Join date: 31 Aug 2006
Posts: 108
06-19-2007 04:40
Two parcels could have the same center point, so that wouldn't work 100% of the time.

You could put a unique identifier in the parcel description and parse it out with llGetParcelDetails.
Qie Niangao
Coin-operated
Join date: 24 May 2006
Posts: 7,138
06-19-2007 05:27
From: Ultralite Soleil
Two parcels could have the same center point, so that wouldn't work 100% of the time.
Right, but they'd have unique southwest corners, say, so you could have a little script that checks for matching results of llGetParcelDetails in 4m-by-4m "hops" till you found the corner (or, for when the corner boundary is zig-zagged, something like "southernmost point of westernmost extent";)--*unless* the parcels had completely identical details, which is possible, unless one can make it not be so... in which case the simpler alternative:
From: Ultralite Soleil
You could put a unique identifier in the parcel description and parse it out with llGetParcelDetails.
would work.

It would be very handy to be able to get the parcel's UUID, if indeed it exists, as Galbraith Karami suggests. Perhaps a jira feature request.
AWM Mars
Scarey Dude :¬)
Join date: 10 Apr 2004
Posts: 3,398
06-19-2007 07:00
I remember vaguely when I was doing some work with a remote cam, you can use the sim coordinates as a absolute position measuring from 0x0, I don't know if thats relevant?
_____________________
*** Politeness is priceless when received, cost nothing to own or give, yet many cannot afford -

Why do you only see typo's AFTER you have clicked submit? **
http://www.wba-advertising.com
http://www.nex-core-mm.com
http://www.eml-entertainments.com
http://www.v-innovate.com