Web Wiz Forums - email address problem

Print Page | Close Window

email address problem

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=16718
Printed Date: 15 April 2026 at 3:29pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: email address problem

Posted By: likefuture
Subject: email address problem
Date Posted: 27 September 2005 at 11:27am

I just install a WWF on my computer for testing, I registered an account with the email address: mailto:likefuture@***.com - likefuture@***.com , and when I check the database, the address changed to likefuture@***.com. Who can help me to resolve this problem? thanks!

Replies:

Posted By: dj air
Date Posted: 27 September 2005 at 2:19pm

thisi s not a problem, this is a coding sytstem where all input is checked and if the work like is within the input. it changes like to the above.

this is to prevent SQL injections and hacking

Posted By: JJLatWebWiz
Date Posted: 27 September 2005 at 2:31pm

"LIKE" is used in SQL and so is transformed by WWF to "like" before it's stored in the database. This is by design and is meant to help prevent attacks called "SQL Injection". Except for http://forums.webwiz.net/forum_posts.asp?TID=16164#88573 - a minor bug , WWF transforms the data back to normal when it's required.

If you need to use the addresses outside of WWF, you could build a similar decodeString function.

Posted By: likefuture
Date Posted: 29 September 2005 at 6:11pm

thanks for your help. it seems WWF didn't transform it back. because when I try to send email to a member with the 'like...' address by the forum built-in email client, the 'functions_send_mail.asp' will report error 'likefuture@***.com is not a valid email address'

Posted By: JJLatWebWiz
Date Posted: 29 September 2005 at 6:35pm

You've found the "minor bug" I mentioned. The built-in WWF email client does not transform the data back. If you're comfortable modifying ASP code yourself, follow the link in my previous post to correct the problem yourself.

It's just 4 lines of code that you can copy and paste. Let me know if you're not comfortable doing the work yourself send me a PM and I can do the work for you. I'm not sure if -boRg- is going to implement this fix before the release of version 8.

-------------
p.s. I'm not affiliated with Web Wiz Guide in any way. I'm just an average Web Wiz user repaying my debt for the use of their fine forum by trying to help other Web Wiz Guide users.