this is the error in the log files
Quote:
L 06/06/2007 - 00:26:43: [AMXX] Plugin ("stats.amxx") is setting itself as failed.
L 06/06/2007 - 00:26:43: [AMXX] Plugin says: 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 'N^ 80^', kills='0', deaths='0'' at line 1
L 06/06/2007 - 00:26:43: [AMXX] Run time error 1 (plugin "stats.amxx") - forced exit
|
this is plugin code:
PHP Code:
Queries[1] = SQL_PrepareQuery(SqlConnection,"INSERT INTO steamids SET steamid='%s', name='%s', kills='0', deaths='0'",usersteam,clientname)
well the problem seems to be the name, why does it cause the error? maybe it has to get escaped? how to escape it in Pawn ?