Hello, if someone has single quotes in nick name (pwn'd), my plugin that uses SQL connection crashes if it tries to put the nickname into database because of non-escaped character that breaks the query. I tried removing it from the nickname by using replace(name, 31, "'", ""), but it didn't do anything; the single quotes still remain not removed.
How can I possibly remove the single quotes from one's nickname?