Beiträge von CptMorgan

    Hi,


    Ich habe folgendes problem, ich habe meinem stunt server mit diesem login system erstellt, aber er speichert nur das pw und den namen mehr nicht kein Geld kein Level! Ich habe das login System hiernach erstellt: Klick .


    Hier mal ein MySQL Debug log: Klick


    Danke schon mal!


    Mfg CptMorgan

    Hi,


    Wie lasse ich den Spieler in einem Auto Spawnen nach dem er sich einen Skin ausgesucht hat ? Wenn der der Spieler Disconnectet soll es weggehen.


    Mfg Cpt.Morgan

    Nur das Pw


    //edit



    Inhalt anzeigen

    SQL
    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;

    Inhalt anzeigen



    Der MySQL log:



    Inhalt anzeigen

    [16:34:55]

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] ---------------------------

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] MySQL Debugging activated (04/29/13)

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] ---------------------------

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55]

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] >> mysql_connect( )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] CMySQLHandler::CMySQLHandler() - constructor called.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "test" | Username: "root" ...

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] CMySQLHandler::Connect() - Connection was successful.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] >> mysql_ping( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] CMySQLHandler::Ping() - Connection is still alive.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:34:55] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [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')

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT * FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_num_rows( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::NumRows() - Returned 0 row(s)

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Registriert); - Escaped 11 characters to Registriert.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Registriert FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Level FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Adminlevel FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Premiumlevel); - Escaped 12 characters to Premiumlevel.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Premiumlevel FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Kills FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Deaths); - Escaped 6 characters to Deaths.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Deaths FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Skin); - Escaped 4 characters to Skin.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Skin FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::Query(SELECT Geld FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_fetch_int( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:30] CMySQLHandler::FreeResult() - The result is already empty.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] CMySQLHandler::EscapeString(123); - Escaped 3 characters to 123.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] CMySQLHandler::Query(INSERT INTO Accounts (Name, Passwort) VALUES ('CptMorganAW', '123')) - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [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)

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:35] CMySQLHandler::StoreResult() - No data to store.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] CMySQLHandler::Query(SELECT Passwort FROM Accounts WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] >> mysql_store_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] CMySQLHandler::StoreResult() - Result was stored.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] >> mysql_fetch_row_format( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] CMySQLHandler::FetchRow() - Return: 123

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] >> mysql_free_result( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:36:37] CMySQLHandler::FreeResult() - Result was successfully free'd.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Registriert); - Escaped 11 characters to Registriert.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Registriert = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Level = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Adminlevel = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Premiumlevel); - Escaped 12 characters to Premiumlevel.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Premiumlevel = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Kills); - Escaped 5 characters to Kills.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Kills = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Deaths); - Escaped 6 characters to Deaths.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Deaths = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Skin); - Escaped 4 characters to Skin.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Skin = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Accounts); - Escaped 8 characters to Accounts.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_real_escape_string( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::EscapeString(CptMorganAW); - Escaped 11 characters to CptMorganAW.

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] >> mysql_query( Connection handle: 1 )

    Inhalt anzeigen

    Inhalt anzeigen
    [16:37:41] CMySQLHandler::Query(UPDATE Accounts SET Geld = '-1' WHERE Name = 'CptMorganAW') - Successfully executed.

    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid))
    {
    mysql_SetInt("Accounts", "Registriert", PLYR[playerid][ P_Registered], "Name", GetName(playerid));
    mysql_SetInt("Accounts", "Level", PLYR[playerid][ P_Level ], "Name", GetName(playerid));
    mysql_SetInt("Accounts", "Adminlevel", PLYR[playerid][ P_Admin ], "Name", GetName(playerid));
    mysql_SetInt("Accounts", "Premiumlevel", PLYR[playerid][ P_Prem ], "Name", GetName(playerid));


    mysql_SetInt("Accounts", "Kills", PLYR[playerid][ P_Kills ], "Name", GetName(playerid));
    mysql_SetInt("Accounts", "Deaths", PLYR[playerid][ P_Deaths ], "Name", GetName(playerid));
    mysql_SetInt("Accounts", "Skin", PLYR[playerid][ P_Skin ], "Name", GetName(playerid));
    mysql_SetInt("Accounts", "Geld", PLYR[playerid][ P_Money ], "Name", GetName(playerid));
    }
    return 1;
    }
    Bitte und in meine DB steht i-wie alles auf -1 ausser pw und Name

    Hi,


    ich habe das Problem das wenn ich den Server Verlasse und wieder Join sind meine daten weg warum ?



    public OnPlayerDisconnect(playerid, reason)
    {
    PLYR[playerid][ P_Money ] = GetPlayerMoney(playerid);
    PLYR[playerid][ P_Money ] = GetPlayerScore(playerid);


    SavePlayer(playerid);
    return 1;
    }


    Mfg CptMorgan