Nur das Pw
//edit
CREATE TABLE IF NOT EXISTS `Accounts` ( `AccID` int(11) NOT NULL AUTO_INCREMENT, `Name` varchar(24) NOT NULL, `Passwort` varchar(128) NOT NULL, `Registriert` int(11) NULL, `Level` int(11) NULL, `Adminlevel` int(11) NULL, `Premiumlevel` int(11) NULL, `Kills` int(11) NULL, `Deaths` int(11) NULL, `Skin` int(11) NULL, `Geld` int(11) NULL, PRIMARY KEY (`AccID`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;
Der MySQL log:
[16:34:55] ---------------------------
[16:34:55] MySQL Debugging activated (04/29/13)
[16:34:55] ---------------------------
[16:34:55] >> mysql_connect( )
[16:34:55] CMySQLHandler::CMySQLHandler() - constructor called.
[16:34:55] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "test" | Username: "root" ...
[16:34:55] CMySQLHandler::Connect() - Connection was successful.
[16:34:55] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[16:34:55] >> mysql_ping( Connection handle: 1 )
[16:34:55] CMySQLHandler::Ping() - Connection is still alive.
[16:34:55] >> mysql_query( Connection handle: 1 )
[16:34:55] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `Accounts` (`Name` varchar(24) NOT NULL AUTO_INCREMENT, `AccID` int(11) NOT NULL,`Passwort` varchar(128) NOT NULL, `Registriert` int(11) NULL,`Level` int(11) NULL, `Adminlevel` int(11) NULL,`Premiumlevel` int(11) NULL, `Kills` int(11) NULL,`Deaths` int(11) NULL, `Skin` int(11) NULL,`Geld` int(11) NULL, PRIMARY KEY (`AccID`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1;) - An error has occured. (Error ID: 1063, Incorrect column specifier for column 'Name')
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT * FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_num_rows( Connection handle: 1 )
[16:36:30] CMySQLHandler::NumRows() - Returned 0 row(s)
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Registriert); - Escaped 11 characters to Registriert.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Registriert FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Level FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Adminlevel FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Premiumlevel); - Escaped 12 characters to Premiumlevel.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Premiumlevel FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Kills FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Deaths); - Escaped 6 characters to Deaths.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Deaths FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Skin); - Escaped 4 characters to Skin.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Skin FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:36:30] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:30] >> mysql_query( Connection handle: 1 )
[16:36:30] CMySQLHandler::Query(SELECT Geld FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:30] >> mysql_store_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::StoreResult() - Result was stored.
[16:36:30] >> mysql_fetch_int( Connection handle: 1 )
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:36:30] >> mysql_free_result( Connection handle: 1 )
[16:36:30] CMySQLHandler::FreeResult() - The result is already empty.
[16:36:35] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:35] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:35] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:35] CMySQLHandler::EscapeString(123); - Escaped 3 characters to 123.
[16:36:35] >> mysql_query( Connection handle: 1 )
[16:36:35] CMySQLHandler::Query(INSERT INTO Accounts (Name, Passwort) VALUES ('CptMorganAW', '123')) - Successfully executed.
[16:36:35] >> mysql_query( Connection handle: 1 )
[16:36:35] CMySQLHandler::Query(INSERT INTO `Accounts` (Name,Passwort,Registriert,Level,Adminlevel,Premiumlevel,Kills,Deaths,Skin,Geld) VALUES('CptMorganAW','1) - An error has occured. (Error ID: 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 ''1' at line 1)
[16:36:35] >> mysql_store_result( Connection handle: 1 )
[16:36:35] CMySQLHandler::StoreResult() - No data to store.
[16:36:37] >> mysql_real_escape_string( Connection handle: 1 )
[16:36:37] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:36:37] >> mysql_query( Connection handle: 1 )
[16:36:37] CMySQLHandler::Query(SELECT Passwort FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.
[16:36:37] >> mysql_store_result( Connection handle: 1 )
[16:36:37] CMySQLHandler::StoreResult() - Result was stored.
[16:36:37] >> mysql_fetch_row_format( Connection handle: 1 )
[16:36:37] CMySQLHandler::FetchRow() - Return: 123
[16:36:37] >> mysql_free_result( Connection handle: 1 )
[16:36:37] CMySQLHandler::FreeResult() - Result was successfully free'd.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Registriert); - Escaped 11 characters to Registriert.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Registriert = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Level = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Adminlevel = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Premiumlevel); - Escaped 12 characters to Premiumlevel.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Premiumlevel = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Kills = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Deaths); - Escaped 6 characters to Deaths.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Deaths = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Skin); - Escaped 4 characters to Skin.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Skin = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[16:37:41] >> mysql_real_escape_string( Connection handle: 1 )
[16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.
[16:37:41] >> mysql_query( Connection handle: 1 )
[16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Geld = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.