Second Life’s One-Letter First Names

6:53 am last names, research

((
List of Second Life Avatars With 1-Character First Names known to SLNameWatch, excluding banned/canceled accounts.

mysql> 
SELECT uuid, last_name, first_name 
  FROM (SELECT uuid, ln_id, first_name 
          FROM agents 
         WHERE length(first_name) <= 1 AND agents.status = 3) AS olfn 
  JOIN last_names ON (olfn.ln_id = last_names.ln_id) 
 ORDER BY last_name, first_name;
+----------------------------------+-----------+------------+
| uuid                             | last_name | first_name |
+----------------------------------+-----------+------------+
| 8a63f8e162e24806a1bbdb05066b4903 | Boa       | R          | 
| 1dcd4aced2734946a7eec1d29bee0b07 | Hax       | C          | 
| ff0b0187f160405bb03a7eb17a97ff05 | Linden    | H          | 
| 244195d6c9b74fd69229c3a8b2e60e81 | Linden    | M          | 
| 7d26bc84d06a436fa78adcddfe1dbdf4 | Linden    | Q          | 
+----------------------------------+-----------+------------+

libsecondlife’s example program, Key2Name, verifies this information. Also, sometimes the web-based search verifies it (H Linden, M Linden, Q Linden). It cannot be verified using in-world search. It is impossible to pull up these profiles in-game unless

  • you are standing next to them, or
  • you have their calling card or friendship, or
  • you search for their last name only and press the [next] button hundreds of times.

Enjoy
-Big Adz
))

9 Responses
  1. Seth Mandelbrot :

    Date: July 29, 2008 @ 15:16

    Or if

    -You have an inventory item (object, texture/snapshot, clothes, notecard, landmark, script, anim, gesture, sound) they created,
    -You are near an object which they created or own (or which contents they created),
    -You are on or near their land, or
    -You can find them through a group in which they are.

  2. Seth Mandelbrot :

    Date: July 29, 2008 @ 15:29

    Also, if you find one of their classifieds.

  3. Seth Mandelbrot :

    Date: July 29, 2008 @ 16:08

    Or use these links:

    R Boa
    secondlife:///app/agent/8a63f8e1-62e2-4806-a1bb-db05066b4903/about

    C Hax
    secondlife:///app/agent/1dcd4ace-d273-4946-a7ee-c1d29bee0b07/about

    H Linden
    secondlife:///app/agent/ff0b0187-f160-405b-b03a-7eb17a97ff05/about

    M Linden
    secondlife:///app/agent/244195d6-c9b7-4fd6-9229-c3a8b2e60e81/about

    Q Linden
    secondlife:///app/agent/7d26bc84-d06a-436f-a78a-dcddfe1dbdf4/about

  4. Adz :

    Date: July 29, 2008 @ 16:44

    I’m trying to make a point about limitations of in-world search. Let’s not get mired in the details. 😉

  5. Seth Mandelbrot :

    Date: July 29, 2008 @ 17:28

    What’s your point? This tool is very limited and I’m going to ignore the existence of others to make my point more dramatic?

    😉

  6. Adz :

    Date: July 29, 2008 @ 17:56

    exactly. please ignore any details whose falseness detracts from my point.

  7. Damen :

    Date: June 24, 2010 @ 04:03

    I have some tools that slap the key onto a string/url, it works great for checking if a name exists, not very good for the actual searching though.

    In regards to searching, it’s limited to 2 characters. You can create a group named “___!” where the underscores are spaces, it will never show in search, as the spaces in the group name do not count as a char in the search.

    I believe this was an issue with avatar names once upon a time, and currently still is with groups.

  8. Adz Childs :

    Date: June 27, 2010 @ 12:46

    Neat!

  9. Adz Childs :

    Date: June 27, 2010 @ 13:04

    I re-ran the query. Here’s the latest

    +———————————-+———–+————+
    | uuid | last_name | first_name |
    +———————————-+———–+————+
    | 8a63f8e162e24806a1bbdb05066b4903 | Boa | R |
    | ff0b0187f160405bb03a7eb17a97ff05 | Linden | H |
    | 244195d6c9b74fd69229c3a8b2e60e81 | Linden | M |
    | 7d26bc84d06a436fa78adcddfe1dbdf4 | Linden | Q |
    | 0aa3ecb2291f49c18d33e6d29931b0cd | Marsault | D |
    +———————————-+———–+————+

Leave a Comment

Your comment

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.