Displayed name duplicates...

Pages

AuthorTopic: Displayed name duplicates...
Law Bringer
Member # 2984
Profile Homepage #0
I was under the impression that you cannot set your displayed name to one that is already taken by someone else.

However, when I attempted to make a unique index in my member database, I saw that on the contrary there are quite a lot of duplicate displayed names - I first figured this was a mistake on my end, made while gathering the data or when entering it into the table.

But then I checked a few of them, and found that they really do have the same name:

+--------------------+------+
| displayed_name | id |
+--------------------+------+
| Sadie | 1471 |
| Sadie | 1472 |
| Sadie | 1473 |
| Angarahad | 5820 |
| Angarahad | 5821 |
| Archdragon | 5114 |
| Archdragon | 5115 |
| armando | 5387 |
| armando | 5388 |
| Bartz | 45 |
| Bartz | 1237 |
| clstem4ever | 5052 |
| clstem4ever | 5382 |
| Da Angry Pineapple | 3333 |
| Da Angry Pineapple | 3334 |
| Drizzt | 84 |
| Drizzt | 2475 |
| Ed Barnes | 1292 |
| Ed Barnes | 1293 |
| Exiled | 1411 |
| Exiled | 1574 |
| Fergus | 1440 |
| Fergus | 1458 |
| GvB Dragon | 1837 |
| GvB Dragon | 1838 |
| HappyNephil | 1426 |
| HappyNephil | 1427 |
| HeiltotheThief | 4375 |
| HeiltotheThief | 4601 |
| Ilumas | 3534 |
| Ilumas | 3535 |
| Jenson | 1547 |
| Jenson | 1548 |
| Mystery Man | 2350 |
| Mystery Man | 5823 |
| Nate | 1613 |
| Nate | 1614 |
| nick | 1404 |
| nick | 1632 |
| Saunders | 21 |
| Saunders | 5563 |
| sifright | 116 |
| sifright | 858 |
| Tim | 845 |
| Tim | 1598 |
| Titania Price | 2444 |
| Titania Price | 2447 |
| void* | 3856 |
| void* | 3857 |
+--------------------+------+
Am I missing something?

Edit: Well, Saunders and Mystery Man are obvious, but the rest?

Edit: On another note, I just combined tables to find out the most prolific topic starters:

+------+------------------------------+----------------+----------------+
| # | Name | Topics started | Average length |
+------+------------------------------+----------------+----------------+
| 4 | Kasumetoru Sai | 128 | 25.2422 |
| 4506 | Archmagus Micael | 125 | 17.5360 |
| 4045 | Kelandon | 70 | 25.4143 |
| 15 | Silent Motion | 65 | 12.1231 |
| 2210 | I'll Steal Your Toast | 61 | 23.4918 |
| 3431 | Student of Trinity | 56 | 17.6786 |
| 2339 | Zephyr Tempest. | 54 | 12.0556 |
| 3349 | Happa Tai Yattai | 54 | 20.9074 |
| 1 | Spidweb | 48 | 18.6667 |
| 4614 | Uhh... ben? | 48 | 21.5833 |
| 40 | A Hexagram Cel | 47 | 20.2340 |
| 3151 | Custer | 47 | 49.4681 |
| 2984 | An array cat | 44 | 41.8636 |
| 1528 | IRA Witch Herd | 43 | 21.5581 |
| 6 | *i | 42 | 22.5714 |
| 5991 | The Forgotten | 42 | 14.9762 |
| 5977 | Thralni, chicken god prophet | 41 | 40.9268 |
| 1993 | spy.there | 39 | 18.1795 |
| 5450 | Spring | 39 | 31.1026 |
| 4682 | Nicothodes | 35 | 14.7714 |
+------+------------------------------+----------------+----------------+


[ Wednesday, January 11, 2006 00:15: Message edited by: The Piper of Hamlin ]

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
...b10010b...
Member # 869
Profile Homepage #1
Well, I'll be jiggered. I suppose, then, that the only restriction on publicly displayed names is that you can't change your PDN to someone else's login name.

--------------------
The Empire Always Loses: This Time For Sure!
Posts: 9973 | Registered: Saturday, March 30 2002 08:00
Law Bringer
Member # 2984
Profile Homepage #2
Is your login name Thuryl?

Edit: Jiggered indeed.

—Alorael, who is not in fact Alorael.

[ Wednesday, January 11, 2006 00:34: Message edited by: OMGAlorael ]

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
Off With Their Heads
Member # 4045
Profile Homepage #3
Yes, his login name is Thuryl. And I think the only restriction on PDNs is that you can't change your PDN to anything that UBB doesn't want you to.

It's more random than one might think.

--------------------
Arancaytar: Every time you ask people to compare TM and Kel, you endanger the poor, fluffy kittens.
Smoo: Get ready to face the walls!
Ephesos: In conclusion, yarr.

Kelandon's Pink and Pretty Page!!: the authorized location for all things by me
The Archive of all released BoE scenarios ever
Posts: 7968 | Registered: Saturday, February 28 2004 08:00
Law Bringer
Member # 2984
Profile Homepage #4
Especially with punctuation marks, I've realized. You can have them in the middle, but not at the end, or something?

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
Shaper
Member # 5450
Profile Homepage #5
Yes. Stupid.

And omg, I have started 39 topics. I don't seem to remember that many. I thought only about 15, but...

And Aran, did you not say a couple of stat topics ago that your total topic count was still a single number?

EDIT: Omg, I said omg. And omg, I said omg three more times. Omg. There we go again... :rolleyes:

[ Wednesday, January 11, 2006 01:44: Message edited by: Spring ]

--------------------
I'll put a Spring in your step.
:ph34r:
Posts: 2396 | Registered: Saturday, January 29 2005 08:00
Law Bringer
Member # 2984
Profile Homepage #6
That's probably subconscious suggestion. *points at moniker*

quote:

And Aran, did you not say a couple of stat topics ago that your total topic count was still a single number?
And striving he must err... in my defence, you also underestimated your topic count. :P
Also, this only counts the PPP3 stuff that's currently still on the boards - I've started more that are in PPP1&2.

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
...b10010b...
Member # 869
Profile Homepage #7
*clears throat loudly*

Aran? No impersonating. You should know better.

--------------------
The Empire Always Loses: This Time For Sure!
Posts: 9973 | Registered: Saturday, March 30 2002 08:00
La Canaliste
Member # 5563
Profile #8
That is indeed interesting!
I wonder if some of those repeats with consecutive numbers were generated by an error on account creation.
Or if more people than we knew have had their accounts deleted...
*wonders if we still have an invisible newbie eater prowling*
Oh, the wonders of program logic!

--------------------
I am a mater of time and how .

Deep down, you know you should have voted for Alcritas!
Posts: 387 | Registered: Tuesday, March 1 2005 08:00
Law Bringer
Member # 2984
Profile Homepage #9
'twas but a test, your honor. :)

--

Also, UBB is not a program. It is more of a state of mind. A state of mind quite befitting for a board whose unofficial meme is "Leave your sanity at the door".

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
Shaper
Member # 3442
Profile Homepage #10
quote:
Originally written by Arancaytar:

'twas but a test, your honor. :)
There isn't a jury in the land that WOULDN'T seize this chance to lock up such a heinous man, with all his evil plas and nasty glares...

I hope the throw away the key...

As for UBB, it don't allow special characters either, like accents.

--------------------
And when you want to Live
How do you start?
Where do you go?
Who do you need to know?

Posts: 2864 | Registered: Monday, September 8 2003 07:00
? Man, ? Amazing
Member # 5755
Profile #11
Was Aran trying to have Alo's account eaten by UBB?

*this message sponsored by the OC - now with tasteful nudity*

--------------------
quote:
Originally written by Kelandon:

Well, I'm at least pretty sure that Salmon is losing.


Posts: 4114 | Registered: Monday, April 25 2005 07:00
Law Bringer
Member # 2984
Profile Homepage #12
My secret plans have been unveiled! I must flee! :eek:

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
Mongolian Barbeque
Member # 1528
Profile #13
I've started 43 topics?! Holy muffins on a turntable! How did that happen?
Posts: 907 | Registered: Monday, July 15 2002 07:00
Law Bringer
Member # 2984
Profile Homepage #14
Well, a lot of them are in RWG, of course.

+-------------------------+--------------------------+
| Topics Started by Icshi | in Forum: |
+-------------------------+--------------------------+
| 12 | General |
| 2 | Tech Support |
| 2 | Nethergate |
| 11 | Richard White Games |
| 4 | Blades of Avernum |
| 1 | Geneforge 2 |
| 6 | Blades of Avernum Editor |
| 5 | Geneforge Series |
+-------------------------+--------------------------+
Also, some of them are duplicates. Quite a lot, actually. They were started in one place and moved to the other, and are now archived in both forums.

+------+--------------------------+------------------------------------------------------------------+-------+---------------------+
| # | Forum | Title | Posts | Started |
+------+--------------------------+------------------------------------------------------------------+-------+---------------------+
| 8 | Richard White Games | Poor Man's Starbound? | 75 | 2002-12-05 14:44:00 |
| 208 | Blades of Avernum | Mountains | 13 | 2003-08-06 10:29:00 |
| 23 | Blades of Avernum Editor | Scenario Icons | 5 | 2004-03-25 09:01:00 |
| 366 | Blades of Avernum | Empress Prazac's Reign | 37 | 2004-03-26 17:34:00 |
| 44 | Blades of Avernum Editor | Kilt & Bagpipes Please | 10 | 2004-03-30 10:11:00 |
| 143 | Blades of Avernum Editor | Question About Custom Items | 5 | 2004-04-22 08:33:00 |
| 147 | Blades of Avernum Editor | Saved Game Files | 6 | 2004-04-24 08:55:00 |
| 520 | Blades of Avernum | Question about turn_on_debug_mode() | 2 | 2004-05-18 09:25:00 |
| 184 | Blades of Avernum Editor | Question about turn_on_debug_mode() | 2 | 2004-05-18 09:25:00 |
| 562 | Blades of Avernum | Morog's Scepter - Pinnacle of Weirdness | 2 | 2004-06-08 09:25:00 |
| 207 | Blades of Avernum Editor | Potion Questions | 2 | 2004-06-08 09:39:00 |
| 193 | Nethergate | Creepy Lady Wants Skulls Back | 4 | 2004-06-11 09:13:00 |
| 194 | Nethergate | The Puzzling Puzzle Box | 8 | 2004-06-15 10:17:00 |
| 1883 | General | Vlish & Illithid | 9 | 2004-07-22 11:05:00 |
| 90 | Richard White Games | We Have Been Assimilated! | 18 | 2004-07-29 13:40:00 |
| 1959 | General | Conan vs. Drizzt | 36 | 2004-08-21 11:03:00 |
| 2117 | General | Release date for Geneforge 3? | 17 | 2004-12-01 11:33:00 |
| 2221 | General | ResEdit in Classic Mode | 3 | 2005-02-13 14:41:00 |
| 2225 | General | Moving Registered Games from OS 9 to OS X | 14 | 2005-02-17 12:06:00 |
| 617 | Tech Support | Really Really Weird Downloading Bug | 12 | 2005-02-20 15:12:00 |
| 812 | Geneforge 2 | Another Pathetic & Premature Geneforge 3 Topic | 6 | 2005-03-11 10:13:00 |
| 3 | Geneforge Series | Another Pathetic & Premature Geneforge 3 Topic | 11 | 2005-03-11 10:13:00 |
| 788 | Geneforge Series | Another Pathetic & Premature Geneforge 3 Topic | 6 | 2005-03-11 10:13:00 |
| 13 | Geneforge Series | How Long Must We Endure This Interminable Wait?!? | 58 | 2005-03-23 13:39:00 |
| 2307 | General | Custom Titles: How Did You Get Yours? | 72 | 2005-03-25 17:58:00 |
| 23 | Geneforge Series | Startup Screen & Music | 16 | 2005-03-27 11:48:00 |
| 201 | Geneforge Series | Geneforge Tongue-Twisters & Limericks | 5 | 2005-05-20 17:00:00 |
| 642 | Tech Support | Strange Geneforge 3 Error | 7 | 2005-05-24 16:59:00 |
| 137 | Richard White Games | A Trip to the Confessional | 70 | 2005-06-25 11:31:00 |
| 2742 | General | Fatal Computer Game Marathon | 29 | 2005-08-15 18:00:00 |
| 2760 | General | ...And Who's Your Favorite Hero? | 34 | 2005-08-20 14:44:00 |
| 157 | Richard White Games | A Touching Tribute: A Satire in Song | 31 | 2005-08-21 16:10:00 |
| 160 | Richard White Games | An Exhaustive Semi-Chronological Short History of the White Cult | 28 | 2005-08-31 14:26:00 |
| 162 | Richard White Games | Forum 13 | 75 | 2005-09-06 16:25:00 |
| 2891 | General | DOCTOR WHO | 20 | 2005-10-09 21:25:00 |
| 2975 | General | General | 43 | 2005-11-14 16:41:00 |
| 3021 | General | Musicnames | 11 | 2005-12-03 17:56:00 |
| 176 | Richard White Games | A New Revelation, Hardly Worth Mentioning | 30 | 2005-12-04 19:11:00 |
| 177 | Richard White Games | Level Editor for Lost Souls? | 5 | 2005-12-09 17:42:00 |
| 178 | Richard White Games | Fossils & Diamonds | 19 | 2005-12-10 14:45:00 |
| 3043 | General | Christmas Music | 23 | 2005-12-10 19:38:00 |
| 180 | Richard White Games | To sink or not to sink, that is the question | 12 | 2005-12-15 14:38:00 |
| 183 | Richard White Games | Like Anyone Cares... | 36 | 2005-12-19 12:49:00 |
+------+--------------------------+------------------------------------------------------------------+-------+---------------------+


--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
Mongolian Barbeque
Member # 1528
Profile #15
Wow. I'm amazed at how many of those topics I had forgotten about until I saw their titles again. That brings back a lot of happy memories. Thanks for posting that, Aran!
Posts: 907 | Registered: Monday, July 15 2002 07:00
? Man, ? Amazing
Member # 5755
Profile #16
Awwww. How cute. Now when are you going to start grading them in the categories of usefulness, cleverness, humor, and evil? For some people, enjoying a sense of superiority becomes the overwhelming reason for participating in threads.

Edit - this gem is truly some fine work. If there was a pin, it should be used here.

*this message sponsored by wife swap, the swinging new series on fox*

[ Wednesday, January 11, 2006 14:19: Message edited by: Jumpin' Salmon ]

--------------------
quote:
Originally written by Kelandon:

Well, I'm at least pretty sure that Salmon is losing.


Posts: 4114 | Registered: Monday, April 25 2005 07:00
Law Bringer
Member # 335
Profile Homepage #17
quote:
Originally written by Jumpin' Salmon:

Was Aran trying to have Alo's account eaten by UBB?
My thoughts exactly.

—Alorael, who can finagle his post count, unique and unusual titles, and signature into plausible deniability. He already has a good name changing racket going. So... impersonation, here he comes!
Posts: 14579 | Registered: Saturday, December 1 2001 08:00
Law Bringer
Member # 2984
Profile Homepage #18
Interestingly enough, Drakefyre's topic count is only 28 (including PPP1, but not PPP2, which isn't yet indexed), and Alorael has a meagre 12!

+------+---------------------+--------------------------------------+-------+---------------------+
| # | Forum | Title | Posts | Started |
+------+---------------------+--------------------------------------+-------+---------------------+
| 72 | Blades of Avernum | be able to play with a vahnatai poll | 2 | 2002-11-16 04:09:00 |
| 700 | General | New Silver Inn v2.0 | 563 | 2003-03-10 11:44:00 |
| 945 | General | Personality Test | 62 | 2003-06-05 16:00:00 |
| 1958 | General | Today is a special day! | 43 | 2004-08-18 15:27:00 |
| 102 | Richard White Games | Huge images | 17 | 2004-09-12 15:57:00 |
| 2516 | General | EraserHead | 1 | 2005-06-06 23:11:00 |
| 2569 | General | General Moderator Election Poll | 35 | 2005-06-21 12:20:00 |
| 167 | Richard White Games | Proper behavior for raving cultists | 9 | 2005-10-04 10:03:00 |
| 3014 | General | Numbers | 61 | 2005-11-30 22:09:00 |
| 3031 | General | Farewell, pale imitation! | 36 | 2005-12-06 16:49:00 |
| 179 | Richard White Games | Our Anthem | 25 | 2005-12-12 20:14:00 |
| 228 | Nethergate | Nethergate News | 25 | 2005-12-22 12:34:00 |
+------+---------------------+--------------------------------------+-------+---------------------+
Is post count inversely related to topic count? o_O

Edit: The first of them, as one might wonder from the title, isn't actually Alo's. He's just the first non-deleted poster, and I failed to take that possibility into account in the program.

[ Wednesday, January 11, 2006 19:05: Message edited by: Arancaytar ]

--------------------
Encyclopaedia ErmarianaForum ArchivesForum StatisticsRSS [Topic / Forum]
My BlogPolarisI eat novels for breakfast.
Polaris is dead, long live Polaris.
Look on my works, ye mighty, and despair.
Posts: 8752 | Registered: Wednesday, May 14 2003 07:00
Agent
Member # 5814
Profile #19
Considering that "EraserHead" and "General Moderator Election Poll" were both official SpidWeb business, he's really only started nine topics.

--------------------
quote:
Originally written by Kelandon
Well, I'm at least pretty

Posts: 1115 | Registered: Sunday, May 15 2005 07:00
Master
Member # 4614
Profile Homepage #20
Sweet man. You ought to make the MySQL database files available on the Internet so we can download them and perform our own queries.

*sees that he has started exactly as many topics as Spidweb. Maybe I need to think of one more.*

--------------------
-ben4808
Posts: 3360 | Registered: Friday, June 25 2004 07:00
Guardian
Member # 2339
Profile #21
Aran, you've given me the feeling that I'm being watched.

I'd be willing to bet money that a large part of the 54 topics I have started were in the BoA forums back when I first joined a little over 3 years ago, when I spammed. A lot. I'm STILL canned.

But if there have been duplicate names, how is it that I STILL can't get rid of the period at the end of my displayed name? Reserved my foot, it's MY name!

--------------------
-Zephyr Tempest, your personal entertainer
Posts: 1779 | Registered: Monday, December 9 2002 08:00
Fire! Fire! Fire! Fire!
Member # 919
Profile #22
I have the same problem with Sir David, actually, which is why I am the last remnant of the gender-bending spree that came and went about a year ago. I don't mind it so much, though. I'm not particularly hostile toward newbies, but it's fun to confuse them sometimes.

Aran, would you mind posting my list of topics? I'm kind of curious now...

--------------------
And though the musicians would die, the music would live on in the imaginations of all who heard it.
-The Last Pendragon

Polaris = joy.

In case of emergency, break glass.
Posts: 3351 | Registered: Saturday, April 6 2002 08:00
Law Bringer
Member # 335
Profile Homepage #23
I'm actually surprised I started that many topics. I stay away, mostly. Let he who is without sin cast the first post and all that.

You might want to check New Silvar Inn v2.0. I think Saunders might have started that one with her dead account. The Personality Test might be mine, but I don't remember starting it.

Huge Images, EraserHead, and the General mod poll are all official business. Proper behavior for cultists is close to it.

That means as few as five of those threads may be non-official topics started by me. One of those is a post count topic and another is close to it. I really am a complete failure at contributing meaningfully.

I'd start a "Should Alorael be Canned?" poll, but that goes against my poll-starting ethos.

—Alorael, who is also somewhat worried by the proportion of threads initiated by him that are under the heading of RWG. That's really a bad sign. The fact that only one isn't General or RWG is even worse.
Posts: 14579 | Registered: Saturday, December 1 2001 08:00
...b10010b...
Member # 869
Profile Homepage #24
If it makes you feel any better, I think I may have started even fewer topics than that. Of the ones I can remember, one was on Misc, one was in BoA, one was in General and the rest were on the mod board (and hence invisible to mortal eyes).

--------------------
The Empire Always Loses: This Time For Sure!
Posts: 9973 | Registered: Saturday, March 30 2002 08:00

Pages