|
Not that I am an expert or anything (I know just enough SQL to be dangerous) but how about adding another row to the user table. I am sure you probably now have just the display name with it's HTML formatting and accented characters and all that fun stuff that you are trying to check against. If you were to add a row for the stripped user name which is the same name as the display name except for the formatting stripped out and you ran the comparisons against that row. At least then you only have to do the stripping once on the newly entered user name, not on every name in your database.
If a user has the display name "Jöhn" the user's stripped name would be "John". Now if anyone tries to use the names Jõhn, Jòhn, Jóhn, Jôhn, or John you would quickly find that the stripped name John is already in use and disallow the new user name.
You may be right
I may be crazy
-- Billy Joel --
Within you lies the power for good, use it!!!
|
|
|
|
|
What a simple solution.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
Chris Maunder wrote: In the end, though, if it's an unpopular decision then I'm open to persuasion.
What if I slapped some sense into a select group of people? 
--
Verletzen zerfetzen zersetzen zerstören
Doch es darf nicht mir gehören
Ich muss zerstören
|
|
|
|
|
My 1 for you this time . These characters must be allowed. Because with that only I identify if they are non-english people 
|
|
|
|
|
So I tried using my old name again. The website reported back that Jörgen Sigvardsson has already been registered. I then tought that maybe you have implemented an algorithm which treats { ö, o, ô, Ó, etc } as the same letter. So I changed my display name to Joergen Sigvardsson, and then tried to change it to Jörgen Sigvardsson. I still get the "already registered" error message. A search for Sigvardsson reveals this user: http://www.codeproject.com/script/profile/whos_who.asp?id=3435008
I suspect that account got created when I noticed that CP rejected accented letters. The date of that account's creation seem to match the date when I noticed that accented letters were rejected. Are accented letters back, and if so, how do I remove this "garbage account"?
--
Verletzen zerfetzen zersetzen zerstören
Doch es darf nicht mir gehören
Ich muss zerstören
|
|
|
|
|
The whole name filtering is being reworked to remove the band-aid I've applied and make it a little more robust and sensible.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
Sweet! I feel so naked without my dots.. 
--
Simulcast on Crazy People's Fillings
|
|
|
|
|
Here's one I thought I'd float by:
Since there are ocassional personal vendettas going on that use the voting system, I thought it would be interesting to aggregrate people's voting history and at the end of their profile append "This use likes ..., this use dislikes..."
And no, I'm not going to implement it (at least publicly ) but it'd certainly be interesting.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
I don't know why so many people are against anonymous voting. There’s nothing wrong with “vendetta” voting either, within reason. If I vote someone down because I hate his guts, or I’m board or whatever, there is nothing to stop other people voting it up. If enough people care my single one vote will be of little importance. In the same vein, if only one person has voted (or very few) regardless of how votes are collected the result isn’t statistically significant be it a five or a one. In general I try to reply if I’m going to vote someone down but sometimes I don’t if there are already replies expressing my sentiment or it’s just obvious and needs no explaining (Henize is a good example, although I done my fair share of replying too) or you just get lazy.
Steve
|
|
|
|
|
A follow-on idea: what about tallying up the votes and displaying the top 5 most popular & least popular members based on votes (forums only not articles).
"For fifty bucks I'd put my face in their soup and blow." - George Costanza ~ Web SQL Utility - asp.net app to query Access, SQL server, MySQL. Stores history, favourites.
|
|
|
|
|
Maybe each user's profile could show a list of the top 10 people who've given him the highest post votes (averaged)  [this list is only visible to him].
|
|
|
|
|
Wont it be nice to have a "Navigation" link on the Quick-Access-panel that's displayed on the lounge? For example :
[Panel Navigation^]So that we can keep browsing for all the message of the same type there.
|
|
|
|
|
I mistakenly posted at lounge 
Now i'm at right place
In CP if I take Lounge forum, it is showing some latest post from Subtle Bugs
Like follows.
(1)Understanding the Problem
(1)Scanner Initialization Drift
(5)Caution! No sign ahead!
(3)The latest neat thing
(1)Windows Installer BSOD
(1)Data reverting back to old data.
(5)1+1=3
The number of posts and replies in the left hand side is something looks bad for me because on left side we are used to number the items. If put it in the RHS that will be looking better.
What I meant is to display as follows. I think it’s something meaningful and beautiful than the current one. Hope Chris is there
• Understanding the Problem (1)
• Scanner Initialization Drift (1)
• Caution! No sign ahead! (5)
• The latest neat thing (3)
• Windows Installer BSOD (1)
• Data reverting back to old data. (1)
• 1+1=3 (5)
-Sarath.
"Great hopes make everything great possible" - Benjamin Franklin
|
|
|
|
|
Agreed
Nobody can give you wiser advice than yourself. - Cicero
|
|
|
|
|
|
The Osmosian Order wrote: This would not only discourage the wandering, off-topic posts so common in the forums
Well, even if i didn't like threaded discussions, i'd still be against any change for that reason
|
|
|
|
|
|
The Osmosian Order wrote: Order or chaos, take your pick. And live with it.
I like a little bit of both in my life. A healthy balance of order and chaos are what life is all about.
|
|
|
|
|
The Osmosian Order wrote: Order or chaos, take your pick. And live with it.
Every day. Order in code, chaos in people.
|
|
|
|
|
Having things as they are is more natural; real conversations evolve and wander. Also sometimes you need to reply to a reply to correct it for example.
Steve
|
|
|
|
|
The Osmosian Order wrote: discourage the wandering, off-topic posts so common in the forums,
Hey. That is one of the best bits of the CP community, how one post can spark off ideas in all different directions. That's how conversations work. The reason the CP community has been so succesfull is because of the conversational style of the forums.
|
|
|
|
|
How about YOU start by not diverting normal questions with talk of Plain English this and Osmosicult that.
Don't make me link you to specific occurances - you know darn well where YOU have taken a simple question totally OT with your responses.
|
|
|
|
|
|
Group discussions are hierachical, meandering, mutating things. They aren't relational objects. Even a formal business discussion will spliter into different branches.
The forums are designed to reflect the social aspect of a community and not try and represent a theoretical model based on schemas.
cheers,
Chris Maunder
CodeProject.com : C++ MVP
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
