Web URL to get a Resident's UUID?

[Sean Heavy]

My question:
Is there an URL to a web page or service that I can use to submit the SL username in order to return the Resident UUID?

This URL seems to work for most Residents, but about 10% return "Sorry, we did not find anything that matches."
https://search.secondlife.com/client_search.php?q=Sean.Heavy&s=People
I would submit an example of the error, but I'm not sure TOS allows me to share a link to a random Resident. (If this is not a TOS violation, please let me know and I'll post an example of one that fails.)

Background:
I am creating a database and web app for my own use to keep track of my customers. So far, I am just using my SL-Orders and SL-Transactions spreadsheets that I can download to see who purchased my items on the MP and in my shops. I am uploading these spreadsheets into my database. My web app setup is LAMP, (Linux, Apache, MySQL, PHP).

I want to include the UUID of all my customers in my database. I have been able to determine most avatar UUIDs with this URL:
https://search.secondlife.com/client_search.php?q=<USERNAME>&s=People
For me:
https://search.secondlife.com/client_search.php?q=Sean.Heavy&s=People
The UUID is in the first URL to:
http://world.secondlife.com/resident/<UUID>
In my case:
http://world.secondlife.com/resident/9ab87ce6-3048-402f-a8f6-f680925a12c3

In testing my automated script using this URL to find a random group of 24 of my customers, I get 3 that are not found which seems like a lot for such a small test.
(I also manually entered these URL/Residents to make sure it wasn't just my PHP script.) (FYI, I do a sleep 2 seconds before every search to avoid overloading the SL site.)

After logging into SL, I can use the in-world search to find those specific Residents, at which point I can get the UUID and copy/paste it to my database, but that would be a lot of manual, error prone work, which I am trying to avoid.

~Sean Heavy
 

[Rolig Loon]

You can get a user UUID from a legacy name with llRequestUserKey().  See the simple example script at http://wiki.secondlife.com/wiki/LlRequestUserKey#Examples

[Sean Heavy]

1 hour ago, Rolig Loon said:

You can get a user UUID from a legacy name with llRequestUserKey().  See the simple example script at http://wiki.secondlife.com/wiki/LlRequestUserKey#Examples

I am not doing this inside Second Life; so I don't have access to LSL. This is a web server in my office that I am connecting to SL web sites to update my home database with UUIDs of my customers. I am doing something similar to this:
http://wiki.secondlife.com/wiki/User:Jor3l_Boa/PHP/n2k.php

Edited October 24, 2019 by Sean Heavy

[Rolig Loon]

N2K, BlackHat, and a couple of other databases used to be popular ways to get resident UUIDs, in the days before llName2Key.  A couple of the third party viewers -- most prominently, Firestorm, also show a user's UUID if you open their profile in the viewer.  Most of those databases were always incomplete, because they relied on random collectors scattered around the grid.  They would typically miss newbie accounts for the first 6 months or more, until their owners had wandered into regions that housed a collector.  I haven't had any reason to use any of those databases since llName2Key and llRequestUserKey became available. If I really needed to get a user key from outside SL these days, I would probably write a short relay routine with an HTTP interface, plant it on a parcel in world, and then ping it through the web when I needed a UUID.

[Whirly Fizzle]

21 hours ago, Sean Heavy said:

In testing my automated script using this URL to find a random group of 24 of my customers, I get 3 that are not found which seems like a lot for such a small test.
(I also manually entered these URL/Residents to make sure it wasn't just my PHP script.) (FYI, I do a sleep 2 seconds before every search to avoid overloading the SL site.)

After logging into SL, I can use the in-world search to find those specific Residents, at which point I can get the UUID and copy/paste it to my database, but that would be a lot of manual, error prone work, which I am trying to avoid.

Do the 3 customers not found using your automated script have profiles flagged as adult?

[Sean Heavy]

1 hour ago, Whirly Fizzle said:

Do the 3 customers not found using your automated script have profiles flagged as adult?

I'm not sure I've ever seen a profile flagged as adult, but in any case, none of these have anything indicating they are flagged adult, once I am able to open the profile. And they are certainly not adult oriented in any way, i.e. photos or groups.

The only idea I can think is a privacy setting that prevents your profile from showing up in searches. I'm not sure why that would prevent it from showing up with a direct link to it.
Here are 2 of them that I can't even get the profile inside SL unless I am trying to add them to my group. When I do a people search for them, it comes up 'not found' even if I have 'adult' checked.

https://gyazo.com/71e1556c776888ae6bcca8ce1e7b1e1b
https://gyazo.com/1ee14ab365f35f79022556be19e8dbad

I am leaning towards just having my application spit out a list of usernames that are 'not found' residents that I can copy into a notecard in SL. That notecard could be read by an LSL script that would get the UUIDs and spit out the SQL I can use to update my database with the UUIDs. That, hopefully, would not be quite as error prone as doing it completely manually. And, LSL has functions that will return UUIDs.

[Whirly Fizzle]

Ok that makes sense that both those accounts are missing in search.
Neither account is in an active state.
If you check both their web profiles,  they will show "This name is unavailable".

Inactive accounts  (deleted at users request or banned etc) will not show in search.
They will however still show in the people picker - that you use to add to land/group ban list/allow list or when filing an AR.

[Sean Heavy]

15 minutes ago, Whirly Fizzle said:

Ok that makes sense that both those accounts are missing in search.
Neither account is in an active state.
If you check both their web profiles,  they will show "This name is unavailable".

Inactive accounts  (deleted at users request or banned etc) will not show in search.
They will however still show in the people picker - that you use to add to land/group ban list/allow list or when filing an AR.

This makes complete sense! Thank you @Whirly Fizzle! The problem just got cut to a third of what it was before.

Any idea about this third "NO RESULTS FOUND" Resident?
https://gyazo.com/e4129f1e9dbfcd77e5837088a1caf030

The search URL for that username fails:
https://search.secondlife.com/client_search.php?s=People&t=N&q=<username>
But the FireStorm in-world search works fine as can be seen in the Gyazo.

[Whirly Fizzle]

Yeah that one's odd.
I can see no reason why that name can't be found in web search. ALL accounts that are in an active state should be findable in web search.
Account appears active & it's found in legacy search just fine.

The only thing I can think of is there is a "banned" word somewhere in their profile, so it's filtered out of web search results.
I can't see any obvious problem words though. There is nothing dodgy when translating the profile text either.

Edited October 25, 2019 by Whirly Fizzle

[Whirly Fizzle]

I filed a JIRA issue, if you want to put a watch on it

BUG-227797 - Active account not findable in web search, but can be found in legacy search