[borjomi]

try func SQL_QuoteString(Handle:db, quoted_name, len, name);
and then use quoted_name instead name

[wint5555]

Originally Posted by NucL3ra Copy this entirely: PHP Code: public GetNewRank_QueryHandler(iFailState, Handle:hQuery, szError[], iErrnum, cData[], iSize, Float:fQueueTime) {     new id = cData[0]     if( iFailState != TQUERY_SUCCESS )     {         return log_amx("TOP15 SQL: SQL Error #%d - %s", iErrnum, szError)     }       new steam[32], authid[32], names[32], name[32], i = 0     get_user_authid(id, steam, 31)     get_user_name(id, names, 31)       while( SQL_MoreResults(hQuery) )     {         i++         if(equal(steam, "VALVE_ID_LAN") || equal(steam, "STEAM_ID_LAN") || strlen(steam) > 18)         {             SQL_ReadResult(hQuery, 0, name, 31)             if( equal(name, names) )             {                 ColorChat(0, GREEN, "[XJ]^x03 %s^x01 is now on place ^x03%d^x01 in^x03 %s^x01", names, i, cData[1] == PRO_TOP ? "Pro 15" : "Noob 15");                 break;             }         }         else         {             SQL_ReadResult(hQuery, 0, authid, 31)             if( equal(authid, steam) )             {                 ColorChat(0, GREEN, "[XJ]^x03 %s^x01 is now on place ^x03%d^x01 in^x03 %s^x01", names, i, cData[1] == PRO_TOP ? "Pro 15" : "Noob 15");                 break;             }         }         SQL_NextRow(hQuery)     }       return PLUGIN_CONTINUE     }

still cant show~

[NucL3ra]

Shouldn't this work ?

	replace_all(name, 31, "\", "")
	replace_all(name, 31, "`", "")
	replace_all(name, 31, "'", "")

[wint5555]

Originally Posted by NucL3ra Shouldn't this work ? replace_all(name, 31, "\", "") replace_all(name, 31, "`", "") replace_all(name, 31, "'", "")

u mean edit to names?

[NucL3ra]

Nope, it just edits the variable that saves the names before sending them into SQL.

The players' name will remain the same.

[wint5555]

Originally Posted by NucL3ra Nope, it just edits the variable that saves the names before sending them into SQL. The players' name will remain the same.

how to do ?

[NucL3ra]

It is already there but it renames with ' , ` too. Just delete that symbols.

[STI-ScorpioN]

I tried to give an example of replacing the signs on signs UNICDE and then in the php to change it back to utf-8 - but the editor of this forum turns me on versions of Unicode characters utf

[fiodor]

to remove the invalid characters in SQL is a function: SQL_QuoteString

[wint5555]

Originally Posted by NucL3ra It is already there but it renames with ' , ` too. Just delete that symbols.

have two replace_all(name, 31, "`", "\`")

del which one?