Extra Characters in Membernames, Beta-Version

Posts from previous Beta sessions

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Sun Dec 16, 2007 9:28 pm

Hi Folks,
may be it was discussed before but I did not find it so I will try to bring up the discussion (one more time).

We have problems with Char-Names which have extra Characters.

For example:
A member has the name "Groar" and a Twink named "Gróar".

Both gets uploaded when I do the guild upload; the names are listed in the log. But only one of them chars and even the one with the extra character "Gróar" gets listed in the member list.

The one without the extra sign is not in the overview. It looks like the Roster 1.9.x does not accept those types of Charnames what is very popular for WoW-Players.

Any hint? Anything I could do or change?
Please let me know

Holgi
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby PleegWat » Sun Dec 16, 2007 10:09 pm

This is a 'feature' in mysql. According to the UTF-8 character set, o and ó should be considered the same letter. So mysql does so - when it runs into Gróar it sees a character with the name Groar in the DB, assumes it's the same character, and updates that.

There's no known workaround or fix.
I <3 /bin/bash
User avatar
PleegWat
WoWRoster.net Dev Team
WoWRoster.net Dev Team
 
Posts: 1636
Joined: Tue Jul 04, 2006 1:43 pm

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Sun Dec 16, 2007 11:28 pm

But why does it work in Roster 1.7 ?
There everything worked perfect.
Holgi
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Mon Dec 17, 2007 11:47 pm

I found a difference between Roster 1.7 and 1.9 (Beta).
The Charsets!
In 1.7. where the issue with the extra characters in charnames works perfect is defined as "latin1_swedish_ci".
In the beta files almost everything is defined to be "utf8_general_ci".
This charset does not differ those characters but the 1.7-charset does.

Is there any chance to change to the Charset which was used in Roster 1.7? Is there any command executable in the phpfrontend to switch to the other charset?

Holgi
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 3:23 am

This change was to facilitate those who port Roster to CMS modules/addons and use the Roster DB in ither web apps

They asked if the data in the DB could be consistent with other CMSs/Apps that store utf-8, the way we do now

Changing back to the latin charset will solve the similar character name problem, but would upset those who wish to use the Roster DB

There are only a few places that specifically set mysql to utf-8
lib/dbal/mysql.php
Comment or remove these lines
Code: Select all
      @mysql_query("SET NAMES 'utf8'");
      @mysql_query("SET CHARACTER SET 'utf8'");


lib/dbal/structure/mysql_structure.sql
Remove each instance of
Code: Select all
  DEFAULT CHARSET=utf8


lib/install.lib.php
Find
Code: Select all
$this->sql[] = 'CREATE TABLE `' . $name . '` (' . $query . ') ENGINE=MyISAM DEFAULT CHARSET=utf8;';

Replace with
Code: Select all
$this->sql[] = 'CREATE TABLE `' . $name . '` (' . $query . ') ENGINE=MyISAM';


Delete/Wipe your current Roster DB, delete conf.php, do these edits, then install Roster, then please report your results
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 4:21 am

It works PERFECT (again!).
Thanks a lot zanix, you absolutely made my day!!!!

Holgi
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 4:44 am

I would like to have something else tried for this as well

Do not do the changes above
Delete/Wipe your current Roster DB, delete conf.php, do the following edit, then install Roster, then please report your results

lib/dbal/structure/mysql_structure.sql
Find
Code: Select all
CREATE TABLE `renprefix_members` (
  `member_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(64) NOT NULL default '',


Change to
Code: Select all
CREATE TABLE `renprefix_members` (
  `member_id` int(11) unsigned NOT NULL auto_increment,
  `name` varchar(64) character set utf8 collate utf8_bin NOT NULL default '',
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 6:16 am

Hey Zanix,
regarding your first solution. It works. The only bad thing is that the whole "Memberlist" is not maintainable. If I enter the settings the menu for the different settings is available but could not be used. Nothing happens.
I will also try your 2nd solution.
Holgi
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 6:42 am

Are you talking about the alt relation reg_ex?
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 6:52 am

No, the first stated solution with all the changes in the DB-Installationfiles.
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Extra Characters in Membernames, Beta-Version

Postby Holgiranemsi » Tue Dec 18, 2007 7:10 am

btw, if I do the 2nd changes with the renprefix it does not work. the chars with the special characters do not show up.
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Re: Extra Characters in Membernames, Beta-Version

Postby Nefuh » Tue Dec 18, 2007 7:35 am

Hey all,

I had have the same problem.

I´ve got 2 Characters on EU-Anetheron.
My Mainchar Nefuh (Guildleader of Scum-From-Hell) and Néfuh.

When i updated always Néfuh will shown, but not Nefuh so in Roster my Guild have no leader ;)

I solved this problem´s by changing Line 338 in the update.lib.php from:

Code: Select all
$this->current_member = $char_name;


to:

Code: Select all
$this->current_member = utf8_encode($char_name);


So all Charnames will be converted to UTF8 so the Charname Néfuh will stored as Néfuh in the database.

By default the names will be decoded from UTF8 so it will be displayed as Néfuh in the memberlist without any edits?!

EDIT: Sry, i was to fast :( This is not a solutions it does not work.

Greets Nefuh
Last edited by Nefuh on Tue Dec 18, 2007 10:07 am, edited 1 time in total.
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 7:57 am

Can you post your CP.lua file for me
I would like to do some tests on my server
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Re: Extra Characters in Membernames, Beta-Version

Postby Nefuh » Tue Dec 18, 2007 8:02 am

Hey Zanix,

here´s my CharacterProfiler.lua.
Attachments
characterprofiler.zip
My CharacterProfiler.lua
(104.19 KiB) Downloaded 270 times
Administrator of the german User2User Community for WoWRoster.
Guild Master from Scum from Hell - Horde @ EU-Anetheron.
User avatar
Nefuh
WoWRoster.net Dev Team
WoWRoster.net Dev Team
Roster AddOn Dev
Roster AddOn Dev
 
Posts: 213
Joined: Fri Sep 15, 2006 8:34 pm
Location: Krefeld Germany

Extra Characters in Membernames, Beta-Version

Postby zanix » Tue Dec 18, 2007 10:09 am

Nefuh
Which characters are similar?
Read the Forum Rules, the WiKi, and Search before posting!
WoWRoster v2.1 - SigGen v0.3.3.523 - WoWRosterDF
User avatar
zanix
Admin
Admin
WoWRoster.net Dev Team
WoWRoster.net Dev Team
UA/UU Developer
UA/UU Developer
 
Posts: 5546
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

Next

Return to Archived

Who is online

Users browsing this forum: No registered users and 1 guest

cron