|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||
| WoW Raid Manager :: Forums :: Support | |||
|
|||
 User of non standard letters in E107 Intergration |
| Author | Post |
| Smoosher |
| ||
 Joined: Mon May 19 2008, 01:29AM Posts: 4 | Ive currently got setup a E107 site intergrating into a forum and WRM site, all the users have been created in both most of the time however we recently had a member join who has a ø in his name which wouldnt create a user on the WRM site. Does WRM allow ø and other such char's as usernames? or is this a problem with the bridge between the 2, all my other users with standard letters have worked fine just this one. I did a search couldnt find anything, so any info would be grand Im all patched up on 3.2.0 at current | ||
| Back to top |
| Illydth |
| ||
  Joined: Mon Sep 24 2007, 02:51PM Posts: 1886 | The end result is this SHOULD work. WRM is built to be internationally aware and to support international characters, in alot of places it does. I'm a bit confused as to why this wouldn't work. You're using 3.2.0 fully patched and you're bridging to e107 correct? (using e107 auth?) You have the WRM tables installed into your e107 database and the bridge actually works on users with non-international characters? e107 creates the guy's login just fine I assume? He can log in to your e107 installation without a problem? In your phpraid_profile table does ANYTHING show up for him? Or does the login just fail when he attempts to log in? What error messages is he getting? Sorry about the mass of questions but I need to figure out where the problem might be. The bridge itself is pretty basic: It selects all the users from the e107 user table, and spins through them to find a username/password match (if($username == strtolower($data['user_loginname']) && $password == $data['user_password'])). There's no character stripping or manipulation in any way, so long as the character in the e107 database is correct and the character in the WRM Username Text Box is correct the whole thing should work. Please check the e107 database to ensure it properly supports international characters, I believe "UTF-8" Is a good character set that supports everything, but I may be off (I'm not an international expert). If it does, find that user in the e107 table and make sure the international character is stored properly there. If the stuff in the e107 table LOOKS right, there's something else you can do: in the auth directory in the auth_e107.php file there is a comment line on line 56 of the file which echos out the e107 username and password in plain text (the password is stored encrypted so you won't see the ACTUAL user password). Turn this comment on to see what the input box is being compared to to verify whether or not the if check is actually firing correctly or not. NOTE: THIS WILL PRINT OUT THE USERNAME AND PASSWORD FROM THE E107 DATABASE FOR EVERY USER THAT TRIES TO LOG IN. If you are doing this on a "live" site PLEASE remove external links to the WRM installation and do what you can to make sure other users aren't using the software during that time. Verify with that echo what is comming from the e107 database vs what's in the username box and see if all is well or not. --Illydth - Douglas Wagner - Site Admin | ||
| Back to top |
| Smoosher |
| ||
Joined: Mon May 19 2008, 01:29AM Posts: 4 | Ill try answer these the best i can. You have the WRM tables installed into your e107 database and the bridge actually works on users with non-international characters? Yup this is the first problem ive had first non UK char e107 creates the guy's login just fine I assume? He can log in to your e107 installation without a problem? Yup it also bridges over fine into my PHPBB3.0 forum creates the user with the funny char In your phpraid_profile table does ANYTHING show up for him? Or does the login just fail when he attempts to log in? What error messages is he getting? Nothing in the phpraid_prifle table when trying to login Login failedYou have specified an invalid username or password. Please try again. Please check the e107 database to ensure it properly supports international characters, I believe "UTF-8" Is a good character set that supports everything, but I may be off (I'm not an international expert). If it does, find that user in the e107 table and make sure the international character is stored properly there. Heres the problem, E107 seems to store the user as Rødtopp however when you view it via the site it shows at Rødtopp. Username fields are set to utf8_general_ci. I tried with my test user which was called Søs and i tried logging onto the raid signups with what it had stored in the E107 database Søs and it let me login fine any suggestions from anyone how to sort this one! appears e107 stores it and coverts it before showing, i should proberly go ask over there ^_^ but then again it works for the forum bridge 0_o [ Edited Sat Jul 12 2008, 01:17PM ] | ||
| Back to top |
| Diska |
| ||
 Joined: Mon Apr 07 2008, 09:03AM Posts: 46 | Those weird characters are UTF8 encoded, there's nothing wrong with that, that's normal, it's good even. I'm using WRM with e107 too (well, more in beta, it's not live yet), and I've got a user called Anër who gets stored as Anër in the database, and he was able to do everything just fine, so I'm kinda surprised to hear that you're having problems :s - Click Here - | ||
| Back to top |
| Moderators: Illydth |
Date / Time Search WoW Raid Manager Chatbox
Neme
andrew11
Illydth
Illydth
Illydth
Illydth
Illydth
Jonneh
Jonneh
ppbash
