Ok, on more try....

For a non-Guild update upload :
The very first moment the character name is being thrown into the SQL engin is over here : update.php - line 242
Throw in a
echo $char;
on line 243.
You could dive more deeply if you add a
echo $name_escape;
on line 2432 in file wowdb.php.
If the right char names is being displayed (with the accents) and still returning the wrong member_id [echo it], throw away your MySQL package.

Also, see what shows up when a
echo $realm_name;
is being put on line 228 (same file).
If the realm isn't yours, put your PHP sub-system besides the MySQL package in the recycle bin.

Anyway, this problem should still have a simple solution, but it winds up on to 'how to setup correctly configure a Web/PHP/MySQL device": a very interesting subject, but it has nothing to do anymore with WoWRoster mathers ^^

Please correct me if I’m wrong.

Guess what...I might have solved it now by checking the php.ini

Original php.ini

; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header. To disable sending of the charset, simply
; set it to be empty.
;
; PHP's built-in default is text/html
default_mimetype = "text/html"
default_charset = "utf8"

changed to

; As of 4.0b4, PHP always outputs a character encoding by default in
; the Content-type: header. To disable sending of the charset, simply
; set it to be empty.
;
; PHP's built-in default is text/html
default_mimetype = "text/html"
;default_charset = "utf8"

and now it seems to work. I am still checking but I do see the correct messages now for non-guild members upload tries and me mainchar data is no longer overwritten...so far.

crossing fingers...and thanks again.

@lunzet:
Is this a server setting or will I find it in the code of the Roster?
I was not able to locate this file...

Holgiranemsi

/etc/php.ini on my Linux server (clarkconnect 4.0)

should be somewhere there on your FS too. Its not related to roster but too the php config.

Thanks for the reply.

GREAT! The only possible solution is not available. As most of the Users we have to share your MySQL-DB with other customers as we do not have a own server, its purchased per month and shared between several customers. So the default is the same for everybody and could not be changed.

Is there anything else what could be done from the Script?
Quote special signs when storing and reading so that there are differences and proper results searching for those names?

A french User of this tool should get nuts! Its more than usuall to have names like this, but maybe their MySQL-Server has a different default ;-(

Holgiranemsi

I am really surprised also that we are the only ones facing these issues. There must be more people with this issue out there but as you already stated...maybe other defaults, maybe newer software version. I am pretty sure that all the WoW users worldwide will have those fancy Charnames preferred...although I cannot understand.

Anyways....still crossing fingers that this was the solution to my issue...

Holgiranemsi wrote:A french User of this tool should get nuts! Its more than usual to have names like this, but maybe their MySQL-Server has a different default ;-(

Don't worry; I'm using 3 rosters on 3 Guilds on 2 realms.
These 3 Guilds have an average 60 % user base that uploads their character(s) - which means that more then 180 persons populates theses roster nearly daily (I also started to distribute UniLoader "by force" )
All members speak 'only' French - because that's where I'm living... :-)

My examples in this thread ware being done and based on French rosters !
The error didn't show up. Period.

Don't speak about differences between "espère" & "espéré", if these two words would be thrown in a SQL database as "espere" & "espere" (means identical words) then the hosters that sell theses kinds of buggy PHP installations would be out of business in no time.
So, this problem could not exist in France.

The French Roster translation is working nearly flawlessly

unfortunately i just detected that my issue by modifying the php.ini has not solved the issue....argh.

So, you know now what to do....

Take yourself a 'standard' web server

Ok, good for france ;-) rofl

But what to do to get it working properly in (some) areas of Germany ?
rofl

Holgiranemsi

@tuigii
May be it helps if you post your server settings (charset etc.) here for us?

Holgiranemsi

Holgiranemsi wrote:May be it helps if you post your server settings (charset etc.) here for us?

Did that already a couple of posts before ^^

Don't have any acces to my php.ini : but these are my 'host settings'
: http://60gp.ovh.net/test.php5 (using www.ovh.

Hi Folks, may be worth to try...

This fixed Our Problem that the TwinkMonitor was not able at all to build up references to Names with fancy characters. When the Script for any reason supresses the fancy Characters by "un-fancy" versions there might be the same CharName so that the data Will be overwritten.

For Example:
MainChar TéstChar
Twink TestChar (alt_TéstChar)
or
MainChar TestChár
Twink TestChar (alt_TestChár)

Those data does not work for us, now it works!

When the script converts both names to "TestChar" by replacing the fancy characters the effect might be to overwrite data.

The solution?
Call your Alt-Monitor in the Roster. At the end of the overview there is a Configuration-Button, press it and go to "Main/Twink Beziehungen"; translated it will be something like "Main/Twink Relations" (first entry in the Menu).

There you will find an entry called "Regex". I surfed the Wiki-Site to find out what the background is for this setting and it defines the search pattern to find the relationship between Twinks and Mains.

I changed this from "/alt_([\w]+)/i" to "/alt_([\S]+)/i" (without the ")
and did the extraordinary update to the relationship, also available from this configuration menu, and everything up from this moment was perfect!

The S means a bytewhise comparison while the w only acts for PHP-Words.
After this change it worked perfect for us !

Try it, hopefully this will also solve your problem!

Holgiranemsi

does not make any difference for me.

still investigating.....and upgrading software

does anyone know where to get older versions of the roster? 1.7.2 or even older?

Holgiranemsi,
This post isn't about Alt-Monitor and picking up alts in a guild

This is about a characters data being overwritten by another characters data with a similar name