Artificial Boy

((
List of Second Life Avatar Names known to SLNameWatch that are 42 characters long or longer.

mysql>
SELECT last_name, first_name
  FROM agents
  JOIN last_names ON (agents.ln_id = last_names.ln_id)
 WHERE (LENGTH(first_name) + LENGTH(last_name)) >= 42;
+-------------------+---------------------------------+
| last_name         | first_name                      |
+-------------------+---------------------------------+
| Barthelmess       | ewkhogbhgfraourtjgbrkyhity80478 |
| Beningbrough      | 123456789012345678901234567890  |
| Castaignede       | andersiidfsdhufvgsufvbstybesytf |
| Constantine       | filiperamonsilvacarvalhodasneve |
| Drevnerussky      | 1A2b3C4d5E6f7G8h9i0J1k2L3m4N5o6 |
| Fleischhacker     | ihjifuhasdgyfusgfydyugdyauksdgt |
| Huldschinsky      | NotonomeibutTazuruhamaMisomanju |
| Huldschinsky      | Shiftctrlalttfihslrtctlainteli1 |
| Juutilainen       | sssssssssssssssssssssssssssssss |
| Messerchmitt      | c1r3h1B2J3K4K6N8M9c0rlt643hClav |
| Raviprakash       | AxLvEjToKnJoGvYlHlJbNmBnGnYhYrF |
| Raviprakash       | CbSbsFbHmLkMoMyBuMyMyMMuuMHjBGj |
| Raviprakash       | CbSbsFbHmLkslMyBuMyMyMMuuMHjBGj |
| Rosentrauch       | asdasdasdasdasdasdasdasdadadsaa |
| Rozenschtrauch    | Duck157aKaBigBoSS666123456789   |
| Schneidermann     | llllllllllllllllllllllllllllll  |
| Schoonhoven       | abcdefghijklmnopqrstuvwxyz12345 |
| Shostakovich      | li1illiilil1illlililil1illiilIL |
| Shostakovich      | MYNAMEISREALLYLONGDONTYOULIKEIT |
| Slyusarenko       | ppppppppppppppppppppppppppppppp |
| Supermarine       | PilatoPhalanxAgAviadorCelestial |
| Swindlehurst      | Esperanzaaaaaaaaaaaaaaaaaaaaaaa |
| Swindlehurst      | Patriciaaaaaaaaaaaaaaaaaaaaaaaa |
| Szczepanski       | 0102030405060708090102030405060 |
| Szczepanski       | Maaariolamowiamionniewartjednej |
| Triskaidekaphobia | bigmrIraqimooshooporkfrom       |
| Triskaidekaphobia | chunkalunkamoonkaloonkalu       |
| Triskaidekaphobia | Immunoelectrophoretically       |
| Triskaidekaphobia | NickKristacovitchlalinski       |
| Triskaidekaphobia | ThisIsAnExtremelyLongName       |
| Triskaidekaphobia | VladimirNonAuCapitalismeu       |
| Wrigglesworth     | cr3GULAR3234simpl0cular3truXAM3 |
| Wrigglesworth     | GjkErdfyasKhu7t8wds3mq9ubvhnil1 |
| Wrigglesworth     | Pneumonoultramicroscopicsilicov |
| Wrigglesworth     | tommmmmmmmmmmmmmmmmmmmmmmmmmmmy |
+-------------------+---------------------------------+

Some of these accounts may be disabled. I didn’t check for that.

NWN: Adz Childs Counts Second Life Name Lengths
))

((
List of Second Life Last Names known to SLNameWatch that are 2 characters long, excluding last names not in use, sorted by usage.

mysql>
SELECT last_name, usage_count, status
  FROM last_names
 WHERE LENGTH(last_name) <= 2
   AND usage_count > 0
 ORDER BY usage_count DESC;
+-----------+-------------+--------+
| last_name | usage_count | status |
+-----------+-------------+--------+
| Oh        |       97286 |      2 |
| Ah        |        6751 |      2 |
| Ra        |        4365 |      2 |
| Xi        |        4338 |      2 |
| Li        |        1329 |      2 |
| Go        |        1300 |      2 |
| Ur        |         996 |      2 |
| Ay        |         876 |      2 |
| Qi        |         793 |      2 |
| Su        |         686 |      2 |
| Mu        |         630 |      2 |
| Yu        |         511 |      2 |
| Le        |         430 |      2 |
| Bu        |         425 |      2 |
| Ho        |         392 |      2 |
| Au        |         340 |      2 |
| An        |         326 |      2 |
| Ni        |         313 |      2 |
| Lu        |         303 |      2 |
| Ge        |         303 |      2 |
| Xu        |         299 |      2 |
| Oe        |         253 |      2 |
| Ng        |         225 |      2 |
| Oz        |          50 |      2 |
| MC        |          18 |      2 |
| Om        |          13 |      2 |
| Wu        |          10 |      2 |
| Si        |           2 |      2 |
+-----------+-------------+--------+
28 rows in set (0.04 sec)

Incidentally, these names are particularly hard to survey because with the in-world search there is no way to request the handful of Si’s (2) without requesting all the mass of Singh (14,747), Sideways (10,167), Siemens (7,114), Sicling (6,541), Sirbu (6,548), etc., with them. It ends up taking hundreds of search events just to find 2 lousy agents. I cringe every time that one comes up for counting. *sigh*
))

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

((
Distribution of Length of Second Life Full Names known to SLNameWatch. (Sum of length of first name and length of last name)

mysql>
SELECT LENGTH(first_name) + LENGTH(last_name) AS lengthOfFullName,
       COUNT(uuid)
  FROM agents
  JOIN last_names ON (agents.ln_id = last_names.ln_id)
 GROU BY lengthOfFullName;
+------------------+-------------+
| lengthOfFullName | count(uuid) |
+------------------+-------------+
|                4 |        1618 |
|                5 |       11920 |
|                6 |       62221 |
|                7 |      207707 |
|                8 |      535268 |
|                9 |     1032819 |
|               10 |     1582256 |
|               11 |     1961590 |
|               12 |     2085211 |
|               13 |     1932301 |
|               14 |     1607617 |
|               15 |     1209889 |
|               16 |      848121 |
|               17 |      559726 |
|               18 |      355397 |
|               19 |      220190 |
|               20 |      135594 |
|               21 |       83445 |
|               22 |       51475 |
|               23 |       33023 |
|               24 |       21632 |
|               25 |       22738 |
|               26 |       12265 |
|               27 |        4887 |
|               28 |        9672 |
|               29 |        2241 |
|               30 |        1650 |
|               31 |        1146 |
|               32 |         870 |
|               33 |         559 |
|               34 |         389 |
|               35 |         290 |
|               36 |         228 |
|               37 |         154 |
|               38 |         131 |
|               39 |          92 |
|               40 |          51 |
|               41 |          31 |
|               42 |          20 |
|               43 |          10 |
|               44 |           5 |
+------------------+-------------+
41 rows in set (29 min 15.01 sec)

Bar chart follows. Read the rest…

((
Second Life Last Name Usage Figures Grouped By Last Name Length. For the number of last names contributing to each group, see Length Distribution of SL Last Names.

mysql>
SELECT LENGTH(last_name) AS len, SUM(usage_count), AVG(usage_count)
  FROM last_names
 GROUP BY len;
+-----+------------------+------------------+
| len | SUM(usage_count) | AVG(usage_count) |
+-----+------------------+------------------+
|   2 |           123563 |        4412.9643 |
|   3 |           422033 |        2542.3675 |
|   4 |          1910360 |        2966.3975 |
|   5 |          2680595 |        2177.5751 |
|   6 |          2847973 |        1633.0120 |
|   7 |          2291388 |        1342.3480 |
|   8 |          1848338 |        1574.3935 |
|   9 |           982622 |        1308.4181 |
|  10 |           545722 |        1491.0437 |
|  11 |           184255 |        1109.9699 |
|  12 |            67832 |         892.5263 |
|  13 |            13924 |         409.5294 |
|  14 |              895 |          25.5714 |
|  15 |             1159 |          46.3600 |
|  16 |               26 |           1.0400 |
|  17 |             1172 |          68.9412 |
|  18 |                2 |           0.0385 |
+-----+------------------+------------------+
17 rows in set (0.19 sec)

Bar chart follows. Read the rest…

((
Distribution of Length of Second Life First Names known to SLNameWatch.

mysql>
SELECT LENGTH(first_name) AS lengthOfFn, COUNT(uuid)
  FROM agents
 GROUP BY lengthOfFn;
+------------+-------------+
| lengthOfFn | count(uuid) |
+------------+-------------+
|          1 |           6 |
|          2 |      165657 |
|          3 |      733233 |
|          4 |     1953604 |
|          5 |     2862937 |
|          6 |     2956376 |
|          7 |     2165063 |
|          8 |     1497033 |
|          9 |      914868 |
|         10 |      536728 |
|         11 |      309688 |
|         12 |      189267 |
|         13 |      110774 |
|         14 |       69335 |
|         15 |       42119 |
|         16 |       24929 |
|         17 |       18195 |
|         18 |        8970 |
|         19 |       24494 |
|         20 |        3817 |
|         21 |        2553 |
|         22 |        1739 |
|         23 |        1338 |
|         24 |        1017 |
|         25 |        1313 |
|         26 |         380 |
|         27 |         179 |
|         28 |         157 |
|         29 |         127 |
|         30 |         150 |
|         31 |         402 |
+------------+-------------+
31 rows in set (24 min 14.93 sec)

Bar chart follows. Read the rest…

((
Distribution of Length of Second Life Last Names known to SLNameWatch, excluding last names not in use.

mysql> SELECT LENGTH(last_name) AS len, COUNT(*)
FROM last_names WHERE usage_count > 0 GROUP BY len;
+-----+----------+
| len | COUNT(*) |
+-----+----------+
|   2 |       28 |
|   3 |      165 |
|   4 |      644 |
|   5 |     1230 |
|   6 |     1741 |
|   7 |     1703 |
|   8 |     1172 |
|   9 |      749 |
|  10 |      364 |
|  11 |      162 |
|  12 |       68 |
|  13 |       23 |
|  14 |        7 |
|  15 |        1 |
|  16 |        2 |
|  17 |        3 |
|  18 |        1 |
+-----+----------+
17 rows in set (0.01 sec)

Bar chart follows. Read the rest…

((
I have been researching the new Join Now facility. Here is what I have found so far.
When you go to one of the old registration portals, which were Join Now #0, Join Now #1, Join Now #2, Join Now #3, Join Now #4, Join Now #5, Join Now #6, Join Now #7, Join Now #8, Join Now #9, Join Now #10, Join Now #11, Join Now #12, Join Now #13, Join Now #14, Join Now #15, Join Now #16, Join Now #17, Join Now #18, Join Now #19, Join Now #20, Join Now #21, Join Now #22, and Join Now #23, there is now a chance to be redirected to a new Join Now system. I call the new system “Webster” based on the hostnames of the destination machines, webster0.lindenlab.com through webster9.lindenlab.com. To avoid confusion, I will refer to the previous secure-web0 through 23 system as “the old system”.
You still have a chance of staying on the old system, but it is more likely than not that you will be redirected to the Webster system. It does not seem to be deterministic, but doesn’t seem to be totally random, either. I cannot figure out the system, if there is one. I believe this falls in the category of A/B testing, which Linden Lab® previously announced.
In the old system, you are presented with a drop down of 40 last names to select for your new account, no matter how many last names are actually available system-wide. At this moment, there are 100 last names available through all the official join now pages, in aggregate. If you land on a secure-web page and are not redirected away from the old system, you will see only 40 of these names in the drop-down menu. The list depends on what secure-web# was used to form the url, and what time of day you visit. Go to two different secure-web# pages at the same time, and you will get two different lists of names. This state will last for 15 minutes or so, and then the names will shuffle around. They will stay in this state for another 15 minutes or so, etc. This is what made my web solution, Get The Last Name You Want possible.
The Webster system has some similar characteristics, with some key differences.
Linden Lab® makes an assumption that you start from an interesting first name, and you want to find a good last name for it. (As you can see from some comments on my previous post about SLNameWatch, this approach to selecting an account name is not universal.) Because of this assumption, you will not see a list of last names to choose from until you enter a first name. After you enter a desired first name, you press Get Available Last Names. Then, a drop down will be populated only with last names that have the desired first name available for it. Even thought this drop-down has a maximum capacity of 40 last names, I don’t believe the list is fixed as it is in the old system. In my limited tests it appears that if you chose a somewhat popular name that is still available, the Webster system will go OUTSIDE of its normal pool of 40 last names, and present you with a complete list of last names available for the given first name, assuming that said list is shorter than 40. This is difficult for me to verify without direct access to the database, but I have run one test and its seems to be the case.
Assuming my tests are accurate, I believe that Get The Last Name You Want is rendered obsolete. My recommendation to SLNameWatch users is to go directly to the non-specific official join now page and let yourself be re-directed. If you do not land on the Webster system (you can tell because the Webster system has a dozen images of avatars to chose from at the top of the page), then try again later. As always, you can stop by SLNameWatch home page to see what names are available system-wide, and to join an alert list to be notified when LL adds new names to the available pool so you can have the first crack at getting a great first name to go with a good last name. Kudos to LL for making their own Join Now system better, and for partially closing the gap between my add-on service, and the official registration system.
I will miss the small Refer-A-Friend bonuses. I will keep my eyes open for any additional services I can provide if LL should change the system again, or if the Webster system turns out to have any exploitable shortcomings. Thank you.
- Big Adz ))

((

I made this SLNameWatch Donation Kiosk in May, but I haven’t posted an announcement until now. I don’t regret working many hours on this project one bit, and I will probably work many more. I am having fun and learning alot about C# and libsecondlife that I wouldn’t have learned otherwise — much more than I signed up for, LOL. That is reward enough for now. I’m not about to give details about the maintenance costs of the SLNameWatch webserver and census robot, or claim that your financial support is desperately needed to keep it running — not yet, at least.

(If you are familiar with php+mysql web hosting costs and the hardware requirements for a libsecondlife bot, you can probably make a pretty accurate guess at my recurring costs.) Any “fictional currency” you “donate” goes directly to me to offset hours worked. I cannot guarantee that your donations will directly help make SLNameWatch better, but they will help my motivation. You can visit this kiosk (SLurl) if you use or have used SLNameWatch and are dying to show a token of your appreciation for my extensive human labor on this project so far. This kiosk is currently the only way you can donate Linden Dollars™ to SLNameWatch.com. The kiosk is located in the first-continent region of Milu (67, 47, 28). It is next to a Linden Road. In-world, you can also search Places for “slnamewatch” and teleport there.

Moving on, what the heck am I going to do with all these calling cards? As of 2008-07-12, eight hundred seventy (870) users have signed up for Second Life® accounts using SLNameWatch’s Join Now Page Catalog, a.k.a. the Get The Last Name You Want page since 2008-03-17 when I first started taking advantage of the refer-a-friend program. I have a calling card for each one, and though I thank each and every one of you, these calling cards are really cluttering up my main account’s inventory. The inventory system does not offer a way to archive them, or transfer them to an alt. I could use an alt account for all subsequent referrals. I’ll probably make that change soon. The child avatar thing can throw some people off a bit, so I will probably change the referral code to link to an account with an adult-av profile. The drawback is I almost certainly will not be online under this alt to answer the occasional first-day questions. The last thing I want to say today is that I’m interested to know more about what makes visitors interested in SLNameWatch.com, and what features they like or do not like, and what they would like to see more of. Are the usage counts interesting to you, or are you mostly here for the Join Now instance tracking feature? I think one way to gather this information is to start a forum on the slnamewatch.com website. Users will be invited to discuss possible features so that I can gauge a level of interest in them, and best make use of my time and energy.

I hope the forum will be a good place to assemble feature requests, bugs, suggestions, and success stories. Additionally, it might be a place to discuss outside forces, such as looming changes to Linden policy regarding last names. A change in last name policy has threatened to make SLNameWatch obsolete since before I even created it! Yet, this change in last name policy hasn’t happened so far… its been over year. I digress. Expect an announcement soon about a new forum in my little corner of SL™ where dreadfully boring things such as this can be discussed. YAY!

Take care and thank you all for using SLNameWatch!

-Big Adz ))

(( Adz’ cousin Gabriel Canning reminds me why I chose to be a kid avatar in SL™. I don’t know how to elaborate on that, in words. So, just take a look. ))

After the July 4 Milk N’ Kookies Show, everyone ran to the dance floor to dance. I ran into my cousin Gabe. He is my cousin because my Daddy Dom is Gabe’s mom’s brother. I think his Bob The Builder stuff is really cool. He has a really neat backpack filled with stuff like fat crayons, comic books, regular books, and a video game. He also has shoes you don’t have to tie. They have plastic straps. He also has these bright plastic bracelets on his ankles. When you take them off you can link them together in a chain! I’ve seen girls wear them mostly but I think the part about linking them together is cool and I am happy to see Gabe wear them because that means I can too I think and maybe the girls won’t laugh. I talked with Gabe a little bit while we danced to the music that closed the MnK show.

Read the rest…