Wo liegt mein Fehler ?
Code
[spoiler][/spoiler][13:02:49] [DEBUG] mysql_query - connection: 1, query: "INSERT INTO `accounts_scheine` (`userID`,'Username') VALUES ('1'", use_cache: true
[13:02:49] [DEBUG] CMySQLQuery::Execute - starting query execution
[13:02:49] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Username') VALUES ('1','reaL.')' at line 1
[13:02:49] [DEBUG] mysql_query - connection: 1, query: "INSERT INTO `accounts_settings` (`userID`,'Username') VALUES ('1", use_cache: true
[13:02:49] [DEBUG] CMySQLQuery::Execute - starting query execution
[13:02:49] [ERROR] CMySQLQuery::Execute - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''Username') VALUES ('1','reaL.')' at line 1
Code
new query[500];
format(query, sizeof(query), "INSERT INTO `accounts_scheine` (`userID`,'Username') VALUES ('%i','%s')", sInfo[playerid][db_id],sInfo[playerid][pName]);
mysql_query(dbhandle, query);
format(query, sizeof(query), "INSERT INTO `accounts_settings` (`userID`,'Username') VALUES ('%i','%s')", sInfo[playerid][db_id],sInfo[playerid][pName]);
mysql_query(dbhandle, query);