Hi all.

One Person in my Guild has bad nickname with Apostophe inside (Arrow'man).
What can i do in that sitation? MB there is entry point where i can add htmlspecialchars function? Check all bot's code - very difficult job, I think. Any ideas? MB any one had such problem? Thx you all.

Errors in log:
--------
MySQL ERROR(# 3) on query: SELECT char_id FROM guildbot_users WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 4) on query: SELECT char_id FROM guildbot_users WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 5) on query: SELECT user_level FROM guildbot_users WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 6) on query: SELECT char_id, user_level FROM guildbot_users WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 7) on query: INSERT INTO guildbot_users (char_id, nickname, added_by, added_at, user_level, notify) VALUES('268606455', 'Arrow'man', 'Guildbot', '1260525223', '2', '1')
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 'man', 'Guildbot', '1260525223', '2', '1')' at line 1Guildbot [BUDDY]  [BUDDY-ADD]     Arrow'man
Guildbot [TELL] [OUT]   -> Arrow'man: Guildbot has added you to the bot.
MySQL ERROR(# on query: SELECT * FROM whois WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 9) on query: SELECT * FROM craftingclass WHERE name = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 10) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, updated) VALUES ('268606455', 'Arrow'man', '38', 'Ranger', '', '', 204687, 1, '1260525223') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  updated = VALUES(updated)
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 'man', '38', 'Ranger', '', '', 204687, 1, '1260525223') ON DUPLICATE KEY UPDATE ' at line 1Guildbot [BUDDY]    [LOG]   Arrow'man changed status [1] (not on notify)
MySQL ERROR(# 11) on query: SELECT char_id FROM guildbot_users WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 12) on query: SELECT char_id FROM guildbot_users WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 13) on query: SELECT * FROM whois WHERE nickname = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 14) on query: SELECT * FROM craftingclass WHERE name = 'Arrow'man'
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 'man'' at line 1MySQL ERROR(# 15) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, updated) VALUES ('268606455', 'Arrow'man', '38', 'Ranger', '', '', 204687, 1, '1260525223') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  updated = VALUES(updated)
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 'man', '38', 'Ranger', '', '', 204687, 1, '1260525223') ON DUPLICATE KEY UPDATE ' at line 1MySQL ERROR(# 16) on query: SELECT char_id FROM guildbot_users WHERE nickname = 'Arrow'man'
------

P.S: Sorry for my english

Since it seems AoC is allowig such names, we have no other option but to support it.

But as it stands, this is going to break things badly.

It's not only mysql making trouble, lot's of regular expressions assume only letters in the nicks.

Its probly RU and PL that allow char other then letters..
EU client/server do not allow ' etc