Special Accents

[Dragon1]

Hi we have a problem with updating and removing old records of users that use special accents as operate in a multi- language zone this is a big problem for us e.g. we currently have a client who has signed on SUREÑA but the paypal update failed to compleat due to a problem with our fire wall. so tried to update manualy but we are tolld update faile we if we try to delete this user the delete fails. this has happened before.

can you help we have the same problem with german and french accents

Thanks
Paul

[Dragon1]

Alan or any other moderator i need a reply on this subject as it is a major issue to us

[alan]

Can you remove the records directly in the database using SQL? Refer to http://www.patronsoft.com/forum/viewtopic.php?t=1514 for more information.
_________________
~ Patronsoft Limited ~

[Dragon1]

Thats not the point Alan the point is that we have users who sign up with these accents and we cannot edit or change there accounts.

we will try removing as you sugest but we work in a spanish speaking and europian envorionment with muliligual clients french german italian etc all of whom use accents

[alan]

Well, it looks like the default datasource dbf only support 7-bit encoding (i.e. not include accents character, 1-127 within ASCII).

You might need to insert some javascript check in signup_form.php to valid the username first.
_________________
~ Patronsoft Limited ~

[Dragon1]

ok so this is a firstspot problem i am not about to start messing with the pages which you have set up so please come up with a fix and tell us how and where to install it.

thanks

[alan]

Okay, we will post a quick fix (i.e. validation check) on the PHP soon.
_________________
~ Patronsoft Limited ~

[Dragon1]

please let us know as soon as you can as this is causing us a big problem
all the best
Paul

[alan]

Please copy and paste the following code at line 43 of signup_form.php (delete the existing code at line 43):

<form name="form1" method="post" action="fs_signup.php" onSubmit="return inputCheck()">
<script type="text/javascript">

function check_username(un) {
for (var i = 0; i < un.length; i++){
// ASCII 48-57(Number0-9), 65-90(A-Z), 97-122(a-z), 45(-), 95(_)
if ((un.charCodeAt(i)>=48 && un.charCodeAt(i) <=57) ||
(un.charCodeAt(i)>=65 && un.charCodeAt(i) <=90) ||
(un.charCodeAt(i)>=97 && un.charCodeAt(i) <=122)||
(un.charCodeAt(i)==45) ||
(un.charCodeAt(i)==95)
){}
else return false;
}
return true;
}

function inputCheck() {
var un = document.form1.username.value

if (check_username(un) == false){
alert("User ID cannot meet the username criteria."+
'\n\n------<<Username Criteria>>------ \n1) it is case sensitive \n2)'+
'support number, alphabet, underscore (_) and dash (-) \n3) within 20 characters in length');
document.form1.username.focus();
document.form1.username.select();
return false;
}
return true;
}

</script>
<input type="hidden" name="failed_url2" value=login_form.php>
_________________
~ Patronsoft Limited ~

[tgeadmin]

Hi there,

I´ve got the same problem with special character such as @

I tried this workaround and paste it into line 43 (where no code is)
and get the errormessage on self-sign webpage
Parse Error: parse error, unexpected '<' in C:\ ......\authsrv\signup_form.php on line 43

what´s wrong?