[Fehler] MySQL speichert Account nicht ab

Wichtiger Hinweis: Bitte ändert nicht manuell die Schriftfarbe auf schwarz sondern belasst es bei der Standardeinstellung. Somit tragt ihr dazu bei dass euer Text auch bei Verwendung unseren dunklen Forenstils noch lesbar ist!

Tipp: Ihr wollt längere Codeausschnitte oder Logfiles bereitstellen? Benutzt unseren eigenen PasteBin-Dienst Link
  • Und wie soll der "MySQL Profi" das ohne Code machen?


    Hups ganz vergessen :pinch:



    Unter OnPlayerDisconnect:
    SavePlayer(playerid);


    Und hier der Code:


    stock SavePlayer(playerid)
    {
    if(IsPlayerConnected(playerid) && !IsPlayerNPC(playerid)) //wir überprüfen ob der Spieler überhaupt noch Connected ist und ob er nicht ein NPC ist.
    {
    if(GetPVarInt(playerid,"Eingeloggt") == 1)
    {
    mysql_SetInt("accounts", "Level", GetPlayerScore(playerid), "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Geld", GetPlayerMoney(playerid), "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Adminlevel", SpielerInfo[playerid][Adminlevel], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Banned", SpielerInfo[playerid][Banned], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "TUT", SpielerInfo[playerid][TUT], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Geschlecht", SpielerInfo[playerid][Geschlecht], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Skin", SpielerInfo[playerid][Skin], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Spawnchange", SpielerInfo[playerid][Spawnchange], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Autoschein", SpielerInfo[playerid][pAutoschein], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Motorradschein", SpielerInfo[playerid][pMotorradschein], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Flugschein", SpielerInfo[playerid][pFlugschein], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "Bootschein", SpielerInfo[playerid][pBootschein], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "banngrund", SpielerInfo[playerid][banngrund], "Name", SpielerInfo[playerid][pName]);
    mysql_SetInt("accounts", "bname", SpielerInfo[playerid][bname], "Name", SpielerInfo[playerid][pName]);
    }
    }
    new querys[1024];
    format(querys, sizeof(querys), "UPDATE accounts SET IP = '%s' WHERE Name = '%s'", SpielerIP(playerid), SpielerName(playerid));
    mysql_query(querys);
    return 1;
    }

  • mysql_debug();



    Vielleicht siehst Du etwas.


    Code:


    SQL
    [04:44:12] >> mysql_num_rows( Connection handle: 1 )[04:44:12] CMySQLHandler::NumRows() - Returned 0 row(s)[04:44:14] >> mysql_query( Connection handle: 1 )[04:44:14] CMySQLHandler::Query(INSERT INTO accounts (Name, Password, PlayerPos, Skin) VALUES ('Mr.Pawn', '344907E89B981CAF221D05F597EB57A6AF408F15F4DD7895BBD1B96A2938EC24A7DCF23ACB94ECE0B6D7B0640358BC56BDB448194B9305311AFF038A834A079F', '1.0 2.0 3.0', '299')) - An error has occured. (Error ID: 1054, Unknown column 'Skin' in 'field list')[04:44:14] >> mysql_query( Connection handle: 1 )[04:44:14] CMySQLHandler::Query(SELECT * FROM accounts WHERE Name = 'Mr.Pawn') - Successfully executed.[04:44:14] >> mysql_store_result( Connection handle: 1 )[04:44:14] CMySQLHandler::StoreResult() - Result was stored.[04:44:14] >> mysql_fetch_row_format( Connection handle: 1 )[04:44:47] >> mysql_query( Connection handle: 1 )[04:44:47] CMySQLHandler::Query(UPDATE accounts SET Name = 'Mr.Pawn', Password = '', AdminLevel = 0, PlayerPos = '1959.964477 1342.748168 1959.964477', Money = 0 WHERE id = 0) - Successfully executed.[12:30:00]  [12:30:00] ---------------------------[12:30:00] MySQL Debugging activated (07/27/13)[12:30:00] ---------------------------[12:30:00]  [12:30:00] >> mysql_connect( )[12:30:00] CMySQLHandler::CMySQLHandler() - constructor called.[12:30:00] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "samp" | Username: "root" ...[12:30:00] CMySQLHandler::Connect() - Connection was successful.[12:30:00] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.[12:30:00] >> mysql_ping( Connection handle: 1 )[12:30:00] CMySQLHandler::Ping() - Connection is still alive.[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(CREATE TABLE IF NOT EXISTS `accounts` (`id` int(11)  AUTO_INCREMENT, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;) - Successfully executed.[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Name` varchar(64)) - An error has occured. (Error ID: 1060, Duplicate column name 'Name')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Passwort` varchar(128) NOT NULL) - An error has occured. (Error ID: 1060, Duplicate column name 'Passwort')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `IP` varchar(128) NOT NULL) - An error has occured. (Error ID: 1060, Duplicate column name 'IP')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Level` int(11) NOT NULL DEFAULT '1') - An error has occured. (Error ID: 1060, Duplicate column name 'Level')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Geld` int(11) NOT NULL DEFAULT '10000') - An error has occured. (Error ID: 1060, Duplicate column name 'Geld')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Adminlevel` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Adminlevel')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Banned` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Banned')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `TUT` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'TUT')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Geschlecht` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Geschlecht')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Skin` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Skin')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Spawnchange` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Spawnchange')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Autoschein` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Autoschein')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Motorradschein` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Motorradschein')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Flugschein` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Flugschein')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `Bootschein` int(11) NOT NULL DEFAULT '0') - An error has occured. (Error ID: 1060, Duplicate column name 'Bootschein')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `banngrund` varchar(128) NOT NULL) - An error has occured. (Error ID: 1060, Duplicate column name 'banngrund')[12:30:00] >> mysql_query( Connection handle: 1 )[12:30:00] CMySQLHandler::Query(ALTER TABLE `accounts` ADD `bname` varchar(60) NOT NULL) - An error has occured. (Error ID: 1060, Duplicate column name 'bname')[12:30:00]  [12:30:00] ---------------------------[12:30:00] MySQL Debugging activated (07/27/13)[12:30:00] ---------------------------[12:30:00]  [12:30:02]  [12:30:02] ---------------------------[12:30:02] MySQL Debugging activated (07/27/13)[12:30:02] ---------------------------[12:30:02]  [12:30:02]  [12:30:02] ---------------------------[12:30:02] MySQL Debugging activated (07/27/13)[12:30:02] ---------------------------[12:30:02]  [12:30:03]  [12:30:03] ---------------------------[12:30:03] MySQL Debugging activated (07/27/13)[12:30:03] ---------------------------[12:30:03]  [12:30:03]  [12:30:03] ---------------------------[12:30:03] MySQL Debugging activated (07/27/13)[12:30:03] ---------------------------[12:30:03]  [12:30:04]  [12:30:04] ---------------------------[12:30:04] MySQL Debugging activated (07/27/13)[12:30:04] ---------------------------[12:30:04]  [12:30:04]  [12:30:04] ---------------------------[12:30:04] MySQL Debugging activated (07/27/13)[12:30:04] ---------------------------[12:30:04]  [12:30:05]  [12:30:05] ---------------------------[12:30:05] MySQL Debugging activated (07/27/13)[12:30:05] ---------------------------[12:30:05]  [12:30:05]  [12:30:05] ---------------------------[12:30:05] MySQL Debugging activated (07/27/13)[12:30:05] ---------------------------[12:30:05]  [12:30:06]  [12:30:06] ---------------------------[12:30:06] MySQL Debugging activated (07/27/13)[12:30:06] ---------------------------[12:30:06]  [12:30:06]  [12:30:06] ---------------------------[12:30:06] MySQL Debugging activated (07/27/13)[12:30:06] ---------------------------[12:30:06]  [12:30:07]  [12:30:07] ---------------------------[12:30:07] MySQL Debugging activated (07/27/13)[12:30:07] ---------------------------[12:30:07]  [12:30:07]  [12:30:07] ---------------------------[12:30:07] MySQL Debugging activated (07/27/13)[12:30:07] ---------------------------[12:30:07]  [12:30:08]  [12:30:08] ---------------------------[12:30:08] MySQL Debugging activated (07/27/13)[12:30:08] ---------------------------[12:30:08]  [12:30:08]  [12:30:08] ---------------------------[12:30:08] MySQL Debugging activated (07/27/13)[12:30:08] ---------------------------[12:30:08]  [12:30:09]  [12:30:09] ---------------------------[12:30:09] MySQL Debugging activated (07/27/13)[12:30:09] ---------------------------[12:30:09]  [12:30:09]  [12:30:09] ---------------------------[12:30:09] MySQL Debugging activated (07/27/13)[12:30:09] ---------------------------[12:30:09]

  • do.de - Domain-Offensive - Domains für alle und zu super Preisen
  • Du versuchst Felder zur Tabelle "accounts" hinzu zu fügen, obwohl diese bereits bestehen.
    Außerdem wird dein MySQL Code zum Speichern eines Account garnicht ausgeführt.



    Bin jetzt mal Connectet auf dem Server.


    Code:


    SQL
    12:35:15] ---------------------------[12:35:15] MySQL Debugging activated (07/27/13)[12:35:15] ---------------------------[12:35:15]  [12:35:39] >> mysql_real_escape_string( Connection handle: 1 )[12:35:39] CMySQLHandler::EscapeString(Mr.Pawn3); - Escaped 8 characters to Mr.Pawn3.[12:35:39] >> mysql_query( Connection handle: 1 )[12:35:39] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Mr.Pawn3') - Successfully executed.[12:35:39] >> mysql_store_result( Connection handle: 1 )[12:35:39] CMySQLHandler::StoreResult() - Result was stored.[12:35:39] >> mysql_num_rows( Connection handle: 1 )[12:35:39] CMySQLHandler::NumRows() - Returned 0 row(s)[12:35:39] >> mysql_free_result( Connection handle: 1 )[12:35:39] CMySQLHandler::FreeResult() - Result was successfully free'd.[12:35:39] >> mysql_real_escape_string( Connection handle: 1 )[12:35:39] CMySQLHandler::EscapeString(Mr.Pawn3); - Escaped 8 characters to Mr.Pawn3.[12:35:39] >> mysql_query( Connection handle: 1 )[12:35:39] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Name` = 'Mr.Pawn3') - Successfully executed.[12:35:39] >> mysql_store_result( Connection handle: 1 )[12:35:39] CMySQLHandler::StoreResult() - Result was stored.[12:35:39] >> mysql_num_rows( Connection handle: 1 )[12:35:39] CMySQLHandler::NumRows() - Returned 0 row(s)[12:35:39] >> mysql_free_result( Connection handle: 1 )[12:35:39] CMySQLHandler::FreeResult() - Result was successfully free'd.[12:35:56] >> mysql_real_escape_string( Connection handle: 1 )[12:35:56] CMySQLHandler::EscapeString(Mr.Pawn3); - Escaped 8 characters to Mr.Pawn3.[12:35:56] >> mysql_real_escape_string( Connection handle: 1 )[12:35:56] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.[12:35:56] >> mysql_query( Connection handle: 1 )[12:35:56] CMySQLHandler::Query(INSERT INTO `accounts` (`Name`, `Passwort`) VALUES ('Mr.Pawn3', '123456')) - Successfully executed.[12:36:03]  [12:36:03] ---------------------------[12:36:03] MySQL Debugging activated (07/27/13)[12:36:03] ---------------------------[12:36:03]  [12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Level); - Escaped 5 characters to Level.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Level` = '1' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Geld); - Escaped 4 characters to Geld.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Geld` = '10000' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Adminlevel` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Banned); - Escaped 6 characters to Banned.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Banned` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(TUT); - Escaped 3 characters to TUT.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `TUT` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Geschlecht); - Escaped 10 characters to Geschlecht.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Geschlecht` = '2' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Skin); - Escaped 4 characters to Skin.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Skin` = '20' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Spawnchange); - Escaped 11 characters to Spawnchange.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Spawnchange` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Autoschein); - Escaped 10 characters to Autoschein.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Autoschein` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Motorradschein); - Escaped 14 characters to Motorradschein.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Motorradschein` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Flugschein); - Escaped 10 characters to Flugschein.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Flugschein` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Bootschein); - Escaped 10 characters to Bootschein.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `Bootschein` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(banngrund); - Escaped 9 characters to banngrund.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `banngrund` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(bname); - Escaped 5 characters to bname.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.[12:36:03] >> mysql_real_escape_string( Connection handle: 1 )[12:36:03] CMySQLHandler::EscapeString(Mr.Pawn); - Escaped 7 characters to Mr.Pawn.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE `accounts` SET `bname` = '0' WHERE `Name` = 'Mr.Pawn') - Successfully executed.[12:36:03] >> mysql_query( Connection handle: 1 )[12:36:03] CMySQLHandler::Query(UPDATE accounts SET IP = '255.255.255.255' WHERE Name = 'Mr.Pawn3') - Successfully executed.[12:36:03]  [12:36:03] ---------------------------[12:36:03] MySQL Debugging activated (07/27/13)[12:36:03] ---------------------------[12:36:03]

  • Du hast die mysql art von martin gemacht..
    da ist ein bug drin..
    er hat vergessen den namen herrauszufinden..


    GetPlayerName(playerid,SpielerInfo[playerid][pName],sizeof(SpielerInfo[playerid][pName]));


    füge das über die dateien zum speichern ein.