Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

Where to add the "extra" danish letters æ, ø, å in the scripts

Asked Modified Viewed 3,300 times
J
Jens Solvang
J
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
asked
Newbie

An old question, but I have not been able to find a complete explanation.


URL to your site: www.byogland-nyborg.dk
Version of PHPFusion: 7.02.07
Any mods you've made to your site: Added some drop-down menus in the theme Revision. Added æ,ø,å,ü, ä, Æ,Ø,Å,Ü,Ä in the list of letters which are allowed to use in the user names.
Version of PHP:
version 5.4
Version of MySQL: 5.0
Have you searched for your problem: (yes/no): Yes
If so, what terms did you try: Scandinavian letters
State the nature of your problem: I want to be able to add more letters to be allowed in user name and password and other places, where it can be useful for a Dane, but how many places has to be changed.
I have searched -0-9A and I have found the following php-scripts:
\administration\administrators.php
\administration\members.php
\administration\news.php
\administration\photoalbums.php
\administration\photos.php
\administration\updateuser.php
\administration\updateuser.php
\contact.php
\forum\postedit.php
\forum\postnewthread.php
\forum\postreply.php
\forum\postreply.php
\includes\classes\LostPassword.class.php
\includes\classes\UserFieldsInput.class.php
\infusions\news_letter_panel\news_letter_panel.php
\infusions\news_letter_panel\news_letter_subs.php
\htdocs\infusions\news_letter_panel\news_letter_uploads.php
\infusions\news_letter_panel\subscription.php
\register.php
\setup.php
\submit.php

Will You advice me to change -0-9A-Z_@\s to -0-9A-Z_@\sæøäöéåÆØÅÄÖÉ in all the scripts to make the danish site work with letters used in the danish language.
Of cource I have to change the locale-file too.

Thank You in advance. Jens Solvang
0 replies

13 posts

P
PolarFox
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
answered
Veteran Member

J
Jens Solvang
J
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
answered
Newbie

Thank You. Unfortunately the the links does not answer question:
Am I to change all the php-scripts - all of them. Of course I do not want to change the validation of e-mail-adresses.
Please notice that I happend to write wrong code.
I wrote: Will You advice me to change -0-9A-Z_@\s to -0-9A-Z_@\sæøäöéåÆØÅÄÖÉ ?

I now think it should be -0-9A-Z_@\s to -0-9A-Z_@æøäöéåÆØÅÄÖÉ\s

But in which scripts?

Regards Jens S.
0 replies
— 8 months later —
H
Homdax
H
Homdax 10
  • Fusioneer, joined since
  • Contributed 2,247 posts on the community forums.
  • Started 108 threads in the forums
answered
Fusioneer

Sorry for bumping a bit here, but I have reviewed all suggested solutions and I have done what Jens writes above, code resulting in:

Original code:
if (!preg_check("/^[-0-9A-Z_@\s]+$/i", $this->_userName)) {


Bad attempt due to utf-8 issues
if (!preg_check("/^[\w-0-9A-Z_@åäöÅÄÖ\s]+$/i", $this->_userName)) {


The I try to update a given user_name, like my own, and the Character exchange does indeed work, but it still throws an error:
Incorrect integer value: 'Rikard MÖ' for column 'userlog_user_id' at row 1

Hence I am inclined to believe that there is some strislash or other code character missing there somewhere.

Please complement the code I posted above with correct code, please do not tell me to go look elsewhere or to browse something else, since I will end up with no solution, If you know what characters in the code i am missing, please just copy paste my code and insert the missing characters.


å Å Ä ä Ö ö

if (!preg_check("/^[\w-0-9A-Z_@ å Å Ä ä Ö ö\s]+$/i", $this->_userName)) {
0 replies
F
Falk
F
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 12 questions
answered
Super Admin

You can try this for Swedish chars, I have found it to be the only viable solution in many scenarios.

if (!preg_check("/^[-0-9A-Z\xe6\xc6\xf8\xd8\xe5\xc5\xf6\xd6\xe4\xc4\/._@\s]+$/i", $this->_userName)) {
0 replies
H
Homdax
H
Homdax 10
  • Fusioneer, joined since
  • Contributed 2,247 posts on the community forums.
  • Started 108 threads in the forums
answered
Fusioneer

Jeez, how is that even related to characters...? it is not the numerical codes, or the ASCII, what are those, Domi? Rainbow?

Ok, seems to work, same or similar as above, but the error that appears when changing it remains:

Incorrect integer value: 'Rikard MÖ' for column 'userlog_user_id' at row 1


The error varies in so much as the character I change, is the one in the error.

Merged on Sep 01 2014 at 12:14:22:
So I updated another user, no werd characters involved, and it throws the same error:

Incorrect integer value: 'Tony' for column 'userlog_user_id' at row 1
Edited by Homdax on 01-09-2014 11:14,
0 replies
F
Falk
F
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 12 questions
answered
Super Admin

All in wounder, we can call it Rainbow ;) the best part is that it is all the Scandinavian letters in the row,
Where do you get this error?, In a query from trying to do what in what section?
0 replies
C
Chan
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,842 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
answered
Super Admin

The query is not even right.. how can you search A-Z in an ID column?
0 replies
J
JoiNNN
J
JoiNNN 10
  • Veteran Member, joined since
  • Contributed 850 posts on the community forums.
  • Started 100 threads in the forums
answered
Veteran Member

Quote

The query is not even right.. how can you search A-Z in an ID column?
- by hien
That!
It says "Incorrect integer value" which is obvious, better post the codes :)
0 replies
H
Homdax
H
Homdax 10
  • Fusioneer, joined since
  • Contributed 2,247 posts on the community forums.
  • Started 108 threads in the forums
answered
Fusioneer

Domi, the error appears on top of page, just below header, everytime I update/change a user_name.

What codes, Dan? There are no errors in the error log. The only code altered is the one you see above.

Please elaborate...
0 replies
J
JoiNNN
J
JoiNNN 10
  • Veteran Member, joined since
  • Contributed 850 posts on the community forums.
  • Started 100 threads in the forums
answered
Veteran Member

Oh, thought you are using some custom code because I didn't conceive such big error in Fusion core, but that's the core code and now I remember, it's the User Log, I posted a roadmap bug at the 8 dev site about this whole thing, the text on int fields, how the changes don't get logged properly and more stuff... Overall the whole User Log system HAS TO BE REDONE, it's just broken! I don't remember if I posted any fixes though.
0 replies
H
Homdax
H
Homdax 10
  • Fusioneer, joined since
  • Contributed 2,247 posts on the community forums.
  • Started 108 threads in the forums
answered
Fusioneer

Come on, you know me, Dan. I never use custom code unless I have to... ;)

I guess it is possible to use this as intended, despite of the error, please correct me if I am wrong.
0 replies
J
JoiNNN
J
JoiNNN 10
  • Veteran Member, joined since
  • Contributed 850 posts on the community forums.
  • Started 100 threads in the forums
answered
Veteran Member

Yes, since that it's and error related to the User Log only everything else should be OK.
0 replies
H
Homdax
H
Homdax 10
  • Fusioneer, joined since
  • Contributed 2,247 posts on the community forums.
  • Started 108 threads in the forums
answered
Fusioneer

ok, thanks...
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 13 posts
  • Votes 0 votes
  • Topic users 6 members

6 participants

F
F
Falk 148
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your Topics and Content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Provide with an URL to live example if one exists
• Please read the How to Report an Error post
• Please read and comply with the Code of Conduct

(¯·._.·(¯°·._.·°º*[ Project Manager ]*º°·._.·°¯)·._.·¯)
  • Super Admin, joined since
  • Contributed 6,201 posts on the community forums.
  • Started 639 threads in the forums
  • Answered 12 questions
H
H
Homdax 10
  • Fusioneer, joined since
  • Contributed 2,247 posts on the community forums.
  • Started 108 threads in the forums
J
J
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 2 threads in the forums
  • Started this discussions
C
C
Chan 0
Lead Developer of PHP-Fusion
  • Super Admin, joined since
  • Contributed 3,842 posts on the community forums.
  • Started 232 threads in the forums
  • Answered 6 questions
P
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
J
J
JoiNNN 10
  • Veteran Member, joined since
  • Contributed 850 posts on the community forums.
  • Started 100 threads in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet