Escape mysql strings.

[Feche1320]

Any function/way to escape mysql letters such as : , - etc?

[drk]

https://wiki.multitheftauto.com/wiki/Mod ... ape_string

This?

[Cadu12]

What are you using? dbConnect or Modules MySQL? If dbConnect, there no need to do it.

[Feche1320]

I am using dbConnect, but I get an error when it wants to create a table with -, for example, race-dm-testmap gives me a MySQL warning and doesn't create it.

[Cadu12]

Hmm, then use Modules Mysql for mysql_escape_string, you can use both.

[Aibo]

I am using dbConnect, but I get an error when it wants to create a table with -, for example, race-dm-testmap gives me a MySQL warning and doesn't create it.

post your query, maybe?

[Feche1320]

I figured it out that it's becouse I can't use - on table names, I just fixed it with :gsub("-", "\_"), altough it's not the same.

[UAEpro]

you can use what ever you want except dots by using this " ` "

"INSERT INTO  `"..safestring( mapname ).."` (................." 

function safestring( pro ) 
        pro = string.gsub (pro, '%.', '-' ) 
    return pro 
end