Post reply

Reply to the message by Auge

Name:

E-mail: (optional, won't be displayed directly)

Leave this field empty:

Homepage: (optional)

Leave this field empty:

Location: (optional)

Remember me (cookie)

Category:

Subject:

Formatting help

skip to input

format text bold: [b]bold text[/b]
format text italic: [i]italic text[/i]
insert hyperlink: [link=http://example.com/]link text[/link] / [link]http://example.com/[/link]
set text color: [color=#rgb]colored text[/color]
font size: [size=small]small text[/size]; [size=large]large text[/size]
insert list: [list][*]list item[/list]
insert image: [img]http://example.com/image.jpg[/img]; left: [img=left]http://example.com/image.jpg[/img]; right: [img=right]http://example.com/image.jpg[/img]; thumbnail: [img=thumbnail]http://example.com/image.jpg[/img]; thumbnail left: [img=thumbnail-left]http://example.com/image.jpg[/img]; thumbnail right: [img=thumbnail-right]http://example.com/image.jpg[/img]
upload image: upload image ...
insert TeX code: [tex]TeX code[/tex]
insert code: [inlinecode]code[/inlinecode]; [code]code[/code]; [code=css]code[/code]; [code=html]code[/code]; [code=javascript]code[/code]; [code=perl]code[/code]; [code=php]code[/code]; [code=sql]code[/code]; [code=xml]code[/code]

:-)
;-)
:-P
:-D
:-|
:-(
:yes:
:no:
:ok:
:lol:
:lol2:
:lol3:
:cool:
:surprised:
:angry:
:crying:
:waving:
:confused:
:lookaround:
:clap:
:love:
:tick:

Message:

> Hello
> 
> > Very good. But I think that the SQL query that changes the user_name field to utf8_bin should be run [b]before[/b] the duplicate test. By doing that, Daniel and Däniel would be different usernames.
> 
> [b]*grmpf*[/b] Yes, you are right.
> 
> > Second, the user_name field needs to have a UNIQUE index.
> 
> The operation would fail, if there are (for wich reason ever) duplicates. Therefore the check has to be performed [i]before[/i] the unique index take place. One step after the other. :-)  
> 
> > If we find duplicates, we should show a list of all the duplicates and a link to the administrator control panel to edit the user name:
> > http://www.example.com/forum/index.php?mode=admin&edit_user=18
> 
> That's, what the prototype adumbrates. If there are rows in the result ([inlinecode]if (mysqli_num_rows($connid, $resCountNames) > 0)[/inlinecode]) the script will render a list of the non-unique names. At the moment it lacks a link to the admin interface for user handling (by the way: a good idea).
> 
> > This list should show the user id, user name and email address, since the user id is the only thing that is guaranteed unique and the email address is usefull if the administrator wants to contact the user. In order to do this, we need to do a second SQL query for each duplicate user name.
> 
> This might be doable in a single query. If we create a list, we can enrich this one list with all necessary informations.
> 
> Thank you so far for your useful input.
> 
> Tschö, Auge

E-mail notification on reply of this posting