AJAX: check if username exists on registration in realtime

It will be ported to vB 3.5

The instructions are up-to-date (see post #8 for more information).

Hello there!

vB 3.5 is using AJAX for inline moderation and stuff like that. Pretty neat and why should we wait for something like this? :devious:

What does this hack do?
In the registration page it checks if the username the user has entered already exists. If this is true he will get a message instantly telling me to change the desired name. The submit button will also be disabled so that he can't finish the registration unless he has chosen another username which is not yet taken.


Features:
* can be turned off or on via the AdminCP
* uses the vB phrases and can easily be translated
* the user gets the error message without reloading the page
* he/she can't complete the registration if the username is taken


Do I need to be an expert to install this hack?
No, not really.. You have to upload two files, edit one file, edit one template and add some custom CSS. Besides this there are 4 queries you need to run (see the point 'Warning:' for more information). Should be pretty easy and I'll support you as good as I can.


Demo:
You may take this for a test drive at my forums but please don't complete the registration unless you want to join my german community
http://www.pagodentreff.de/diskussio...m/register.php
Just use 'dominik.h' as a username and see what happens.


Problems?
Is the new phrase not showing up? Read this: https://vborg.vbsupport.ru/showpost....5&postcount=19



Warning:
This hack doesn't have an automatic installer. However you need to run 4 different queries for this hack to work. Those queries are for the settings in your AdminCP and for the phrases only. This hack won't affect your performance
If you feel uncomfortable with running queries you may drop me a private message and I'll see what I can do for you.


I will support this hack as good as I can but please keep your questions within this thread.

Please don't forget to click install because you get an update notification and other nice things

The screenshot is taken from my translated version.

This hack wouldn't be possible without the following article and the code: http://www.xml.com/pub/a/2005/02/09/...p-request.html

[Princeton]

it looks great! I'm gonna try this out.

/me was looking to code this same kind of ajax... great MRNase

[MrNase]

hehe

Please test it before you make it HOTM It worked for me and hopefully it'll work for you.

[Dean C]

You might want to credit xml.com for the AJAX JS code

[sql]INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (NULL, '0', 'registererror', 'The username you have chosen is already taken', '5000', '39');[/sql] have an error, have to drop the '5000', in it...

EDIT: btw, would be good to duplicate this process for the change username in profile...

[MrNase]

Originally Posted by nexialys

[sql]INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (NULL, '0', 'registererror', 'The username you have chosen is already taken', '5000', '39');[/sql] have an error, have to drop the '5000', in it...

I changed it to:
[sql]INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (NULL, '0', 'registererror', 'The username you have chosen is already taken', '', '39');[/sql]


Dean C: Ok, I did that. This was my first static try http://validhtml.com/xmlhttprequest/. I just took the code from it without thinking much about it's source :nervous:

nexialys: That's a good idea.. Iam going to sleep now but I'll keep that in mind for tomorrow

[Princeton]

MrNase,
I believe it should be:
[sql]INSERT INTO `phrase` (`phraseid`, `languageid`, `varname`, `text`, `phrasetypeid`) VALUES (NULL, '0', 'registererror', 'The username you have chosen is already taken', '39');[/sql]

[Princeton]

oh, by the way -- great hack/find. :up:

There's a lot we can do with this. ;D

[MrNase]

Have you installed it and does it work for you?

I fixed the small error in the downloadable file.. It happened because I added the , '39' without thinking about the number of the affected rows (I tried to modify 6 where there are only 5 ).

I added all phrases and settings manually so I couldn't test them. I hope they are working for you :rambo: