special characters in charname database overwrite

CharacterProfiler.lua file uploading issues

Re: special characters in charname database overwrite

Postby tuigii » Wed Jun 27, 2007 5:30 am

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.
Last edited by tuigii on Wed Jun 27, 2007 5:32 am, edited 1 time in total.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Re: special characters in charname database overwrite

Postby lunzet » Wed Jun 27, 2007 8:43 pm

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.
User avatar
lunzet
WR.net Journeyman
WR.net Journeyman
 
Posts: 119
Joined: Sat Jan 13, 2007 1:23 pm

special characters in charname database overwrite

Postby Holgiranemsi » Wed Jun 27, 2007 9:13 pm

@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
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Re: special characters in charname database overwrite

Postby lunzet » Wed Jun 27, 2007 10:26 pm

/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.
User avatar
lunzet
WR.net Journeyman
WR.net Journeyman
 
Posts: 119
Joined: Sat Jan 13, 2007 1:23 pm

special characters in charname database overwrite

Postby Holgiranemsi » Wed Jun 27, 2007 10:38 pm

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
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

Re: special characters in charname database overwrite

Postby lunzet » Wed Jun 27, 2007 11:25 pm

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...
User avatar
lunzet
WR.net Journeyman
WR.net Journeyman
 
Posts: 119
Joined: Sat Jan 13, 2007 1:23 pm

Re: special characters in charname database overwrite

Postby tuigii » Thu Jun 28, 2007 5:41 am

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" :mrgreen: )
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
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

Re: special characters in charname database overwrite

Postby lunzet » Thu Jun 28, 2007 5:52 am

unfortunately i just detected that my issue by modifying the php.ini has not solved the issue....argh.
User avatar
lunzet
WR.net Journeyman
WR.net Journeyman
 
Posts: 119
Joined: Sat Jan 13, 2007 1:23 pm

Re: special characters in charname database overwrite

Postby tuigii » Thu Jun 28, 2007 9:43 pm

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

Take yourself a 'standard' web server :mrgreen:
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

special characters in charname database overwrite

Postby Holgiranemsi » Fri Jun 29, 2007 5:35 pm

Ok, good for france ;-) rofl

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

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

special characters in charname database overwrite

Postby Holgiranemsi » Fri Jun 29, 2007 5:36 pm

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

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

Re: special characters in charname database overwrite

Postby tuigii » Sun Jul 01, 2007 6:55 am

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.
User avatar
tuigii
WR.net Master
WR.net Master
 
Posts: 891
Joined: Wed Dec 27, 2006 12:57 pm
Location: Somewhere in the South Ouest of France

special characters in charname database overwrite

Postby Holgiranemsi » Mon Jul 02, 2007 10:50 pm

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
Last edited by Holgiranemsi on Mon Jul 02, 2007 11:26 pm, edited 2 times in total.
Holgiranemsi
WR.net Journeyman
WR.net Journeyman
 
Posts: 88
Joined: Fri Feb 16, 2007 12:28 pm

special characters in charname database overwrite

Postby lunzet » Tue Jul 03, 2007 2:10 am

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?
Last edited by lunzet on Tue Jul 03, 2007 6:15 am, edited 1 time in total.
User avatar
lunzet
WR.net Journeyman
WR.net Journeyman
 
Posts: 119
Joined: Sat Jan 13, 2007 1:23 pm

special characters in charname database overwrite

Postby zanix » Tue Jul 03, 2007 7:08 am

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
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: 5543
Joined: Mon Jul 03, 2006 8:29 am
Location: Idaho Falls, Idaho
Realm: Doomhammer (PvE) - US

PreviousNext

Return to Uploading

Who is online

Users browsing this forum: No registered users and 0 guests