Extra Characters in Membernames, Beta-Version

by **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

by **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.

by **Holgiranemsi** » Sun Dec 16, 2007 11:28 pm

But why does it work in Roster 1.7 ?
There everything worked perfect.
Holgi

by **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

by **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

by **Holgiranemsi** » Tue Dec 18, 2007 4:21 am

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

Holgi

by **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 '',

by **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

by **zanix** » Tue Dec 18, 2007 6:42 am

Are you talking about the alt relation reg_ex?

by **Holgiranemsi** » Tue Dec 18, 2007 6:52 am

No, the first stated solution with all the changes in the DB-Installationfiles.

by **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.

by **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

by **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

by **Nefuh** » Tue Dec 18, 2007 8:02 am

Hey Zanix,

here´s my CharacterProfiler.lua.

by **zanix** » Tue Dec 18, 2007 10:09 am

Nefuh
Which characters are similar?