[LiamM]

Hey guys, I have a /changename cmd but I only jsut realized that people can put spaces and shit in there name and it fucks up the MySQL database. So whats the best way I could check if theres any spaces or unwanted characters in the players name?

[T0pAz]

mysql_real_escape_string.

[LiamM]

Quote:

Originally Posted by T0pAz mysql_real_escape_string.

Yes but... I mean.. if a player uses a space in his name, SetPlayerName will not work. So how can I return a message to say that they are not allowed to use a space in there name? I know about the mysql_real_escape_string.

[MP2]

pawn Код:

stock IsValidName(name[])
{
    if(strlen(name) < 3) return 0;
    new i, ch;
    while ((ch = name[i++]) && ((ch == '(') || (ch == ')') || (ch == '$') || (ch == '.') || (ch == '=') || (ch == '@') || (ch == ']') || (ch == '[') || (ch == '_') || ('0' <= ch <= '9') || ((ch |= 0x20) && ('a' <= ch <= 'z')))) {}
    return !ch;
}

[LiamM]

Thanks man, that really helped. Sorry for such a late reply too!