vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)
-   -   Miscellaneous Hacks - AJAX / Cool Registration (https://vborg.vbsupport.ru/showthread.php?t=142181)

Soliloquy 03-22-2007 02:18 AM

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 03-22-2007 02:59 AM

Quote:

Originally Posted by Soliloquy (Post 1209321)
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 03-22-2007 04:06 AM

Hi,
There is a problem with hebrew lang.

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

jagari 03-22-2007 05:26 AM

Does this work even with custom templates?

DPSR 03-22-2007 05:26 AM

Working fine here :D

Thanks Mr. Chad

PoetJA-1975 03-22-2007 08:08 AM

Quote:

Originally Posted by Mr Chad (Post 1208069)
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 03-22-2007 09:07 AM

great product !

subzero06 03-22-2007 12:50 PM

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

Kirk Y 03-22-2007 04:19 PM

Quote:

Originally Posted by PoetJA-1975 (Post 1209411)
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 03-24-2007 04:04 PM

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


All times are GMT. The time now is 11:26 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01257 seconds
  • Memory Usage 1,739KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete