Guten Tag,
Und zwar wenn ich einen Account erstelle, wird der nicht gespeichert beim Ausloggen.
Ich hoffe mal das ich hier einen MySQP Profil treffe,
der mir auch weiter helfen kann. 
Mit freunldichen Grüßen
Pawn0
[Fehler] MySQL speichert Account nicht ab
- CesarSkyNET
- Geschlossen
- Erledigt
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?
-
Und wie soll der "MySQL Profi" das ohne Code machen?
Hups ganz vergessen
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;
} -
IsPlayerConnected(playerid)
Du fragst nach einem Disconnect eines Spielers, ob der Spieler verbunden ist? ..
-
Du fragst nach einem Disconnect eines Spielers, ob der Spieler verbunden ist? ..
Habe es rausgetan aber funktioniert immer noch nicht
-
Verwende mal Debugnachrichten, um zu sehen, wie weit der Code ausgeführt wird und verwende den MySQL Debug Modus - vielleicht findest du im MySQL Log etwas hilfreiches.
-
Verwende mal Debugnachrichten, um zu sehen, wie weit der Code ausgeführt wird und verwende den MySQL Debug Modus - vielleicht findest du im MySQL Log etwas hilfreiches.
Wie erstell ich sowas ?
Habe sowas noch nie gemacht. -
Debugnachrichten: [ SCRIPTING ] Debugnachrichten
Und der MySQL Debug Modus wird mittels mysql_debug(); aktiviert. -
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] -
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. -
-
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:
SQL12: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.
-
breadfish.de
Hat das Thema geschlossen.
