Hi,

I got this in my pvplog :


[5148] = {
["guild"] = "Clair de Lune",
["zone"] = "Vallée d'Alterac",
["subzone"] = "Donjon Loup-de-givre",
["enemy"] = 1,
["date"] = "12/28/06 02:23:38",
["name"] = "Elémentaire d'eau",
["lvlDiff"] = 0,
["honor"] = 0,
["win"] = 1,
["bg"] = 1,
["rank"] = "Sergent-chef",
}

The name Elémentaire d'eau made the update impossible (because of the "'".

Aniodon.

Data is escaped on insertion into the database so this should not be a problem

Please give the exact error that occurs

It seems to be parsed ^^

I get :

Code: Select all

 PvPLog cannot update
1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'eau' AND `date` = '2006-12-28 2:23:38'' at line 1
 

PS : deleting the "'" character in the name field gives no error, update success.

Code: Select all

SELECT `guild` FROM `roster_pvp2` WHERE `index` = '5148' AND `member_id` = '82' AND `name` = 'Elémentaire d'eau' AND `date` = '2006-12-28 2:23:38'


in the sql query

No idea ?

3 more guild mates cannot update because of this, /cry.

In lib/wowdb.php in line 2058, change:

Code: Select all

            $playerName = $playerInfo['name']; 

to

Code: Select all

            $playerName = $this->escape($playerInfo['name']); 

Thank you very much, will try it tonight

Works fine, thanks again.

Will this be fixed in next releases ? this may happen often on french server/localisation