Miscellaneous Hacks - AJAX / Cool Registration

Removed.

[Soliloquy]

I installed this a couple of days ago and it mostly seems to be working great, except today I got three "vBulletin Database Error!" messages when somebody tried to register with an apostrophe in their name. No idea what was shown to the user but here's the error message from the email:

Invalid SQL:
SELECT COUNT(*) as username FROM `vB_user` WHERE `username` = 'Kneene'er';
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'er'' at line 1
Error Number : 1064
Script : http://www.exampleforum.com/ajax.php...am=Kneene%27er

[subzero06]

Originally Posted by Soliloquy

I installed this a couple of days ago and it mostly seems to be working great, except today I got three "vBulletin Database Error!" messages when somebody tried to register with an apostrophe in their name. No idea what was shown to the user but here's the error message from the email:

Invalid SQL:
SELECT COUNT(*) as username FROM `vB_user` WHERE `username` = 'Kneene'er';
MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'er'' at line 1
Error Number : 1064
Script : http://www.exampleforum.com/ajax.php...am=Kneene%27er

Yeah, im having the same problem.

[efil]

Hi,
There is a problem with hebrew lang.

when i insert a new user name in hebrew lang i get a strange characters.

[jagari]

Does this work even with custom templates?

[DPSR]

Working fine here

Thanks Mr. Chad

[PoetJA-1975]

Originally Posted by Mr Chad

is there any other fields with "name=register"

Thanx for responding MR CHAD - I'm not quite sure I understand though - Where would the "name=register" field be?

Thanx

Jacquii.

[ThorstenA]

great product !

[subzero06]

Anyones knows how to fix it so people can register with an apostrophe name.?

[Kirk Y]

Originally Posted by PoetJA-1975

Thanx for responding MR CHAD - I'm not quite sure I understand though - Where would the "name=register" field be?

Thanx

Jacquii.

Look in your Header/Footer templates. It doesn't necessarily need to be name=register either, if you're using JS Rollovers, you could have one of them named register.

[Ethelbert]

Hi, I have a little problem. Everything working fine except my username. When I type any username it's available or is in use and when I type my username (admin username) username will be cleaned and status will be Available...

Could you tell me how can I fix tis problem?

You can test it at: www.verejnadiskusia.sk - my username is drakeman

Thank you