new string[128];
mysql_escape_string(inputtext,inputtext,dbhandle,100);
format(string,sizeof(string),"INSERT INTO `accounts` (`Name`, `Passwort`,`Level`,`Admin`,`Geld`,`Filliale`,`Bank`,`Leader`,`Member`,`Job`,`Bankkarte`) VALUES ('%s','%s',1,0,'%i',0,0,0,0,0,0)",SpielerName(playerid),inputtext,Startgeld);
mysql_tquery(dbhandle,string);
Kann mir jemand helfen? Sobald ich mich einlogge soll das Passwort ( der Inputtext) und der Rest in die Datenbank eingetragen werden. Dies gescheht aber nicht.
Log:
[16:37:48] [DEBUG] mysql_format - connection: 1, len: 64, format: "SELECT * FROM `accounts` WHERE `Name`='%e'"
[16:37:48] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name`='Hagz'", callback: "CheckSpieler", format: "d"
[16:37:48] [DEBUG] CMySQLQuery::Execute[CheckSpieler] - starting query execution
[16:37:48] [DEBUG] CMySQLQuery::Execute[CheckSpieler] - query was successfully executed within 0.204 milliseconds
[16:37:48] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:37:48] [DEBUG] Calling callback "CheckSpieler"..
[16:37:48] [DEBUG] cache_get_row_count - connection: 1
[16:37:48] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[16:38:08] [DEBUG] mysql_escape_string - source: "1234", connection: 1, max_len: 100
[16:38:08] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`Name`, `Passwort`,`Level`,`Admin`,`Geld", callback: "(null)", format: "(null)"
[16:38:08] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `accounts` (`Name`, `Passwort`,`Level`,`Admin`,`Geld", callback: "(null)", format: "(null)"
[16:38:08] [DEBUG] mysql_format - connection: 1, len: 128, format: "SELECT * FROM `accounts` WHERE `Name`='%e'"
[16:38:08] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name`='Hagz'", callback: "SpielerLaden", format: "d"
[16:38:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:38:08] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 '' at line 1
[16:38:08] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[16:38:08] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[16:38:08] [ERROR] CMySQLQuery::Execute[] - (error #1064) 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 '' at line 1
[16:38:08] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[16:38:08] [DEBUG] CMySQLQuery::Execute[SpielerLaden] - starting query execution
[16:38:08] [DEBUG] CMySQLQuery::Execute[SpielerLaden] - query was successfully executed within 0.143 milliseconds
[16:38:08] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[16:38:08] [DEBUG] Calling callback "SpielerLaden"..
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Level", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Geld", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Admin", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Filliale", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Bank", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Leader", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Member", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Job", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] cache_get_field_content_int - row: 0, field_name: "Bankkarte", connection: 1
[16:38:08] [ERROR] CMySQLResult::GetRowDataByName() - invalid row index ('0')
[16:38:08] [ERROR] cache_get_field_content_int - invalid datatype
[16:38:08] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
