MySQL speichert nicht in die Datenbank!

Grapefruit · 5. Oktober 2014

[14:26:26] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:26] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:26] >> mysql_query( Connection handle: 1 )
[14:26:26] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[14:26:26] >> mysql_store_result( Connection handle: 1 )
[14:26:26] CMySQLHandler::StoreResult() - Result was stored.
[14:26:26] >> mysql_num_rows( Connection handle: 1 )
[14:26:26] CMySQLHandler::NumRows() - Returned 1 row(s)
[14:26:26] >> mysql_free_result( Connection handle: 1 )
[14:26:26] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:29] >> mysql_query( Connection handle: 1 )
[14:26:29] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[14:26:29] >> mysql_store_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::StoreResult() - Result was stored.
[14:26:29] >> mysql_fetch_row_format( Connection handle: 1 )
[14:26:29] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[14:26:29] >> mysql_free_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:29] >> mysql_query( Connection handle: 1 )
[14:26:29] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[14:26:29] >> mysql_store_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::StoreResult() - No data to store.
[14:26:29] >> mysql_fetch_row_format( Connection handle: 1 )
[14:26:29] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[14:26:29] >> mysql_free_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::FreeResult() - The result is already empty.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[14:26:29] >> mysql_real_escape_string( Connection handle: 1 )
[14:26:29] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[14:26:29] >> mysql_query( Connection handle: 1 )
[14:26:29] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[14:26:29] >> mysql_store_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::StoreResult() - Result was stored.
[14:26:29] >> mysql_fetch_int( Connection handle: 1 )
[14:26:29] CMySQLHandler::FetchRow() - Return: 1
[14:26:29] >> mysql_free_result( Connection handle: 1 )
[14:26:29] CMySQLHandler::FreeResult() - Result was successfully free'd.
[14:26:29] OnQueryError() - Called.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (0,'','2069.789550','1321.574584','2030.651977','1349.526123','2057.994384','1330.191040','10.897706','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=2069.789550,`maxY`=1321.574584,`minX`=2030.651977,`minY`=1349.526123,`flaggeX`=2057.994384,`flaggeY`=1330.191040,`flaggeZ`=10.897706,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (1,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (2,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (3,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (4,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (5,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (6,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (7,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (8,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (9,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (10,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (11,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (12,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (13,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (14,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (15,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (16,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (17,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (18,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (19,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (20,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (21,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (22,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (23,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (24,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (25,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (26,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (27,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (28,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.
[14:26:58] >> mysql_query( Connection handle: 1 )
[14:26:58] CMySQLHandler::Query(INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (29,'','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','0.000000','') ON DUPLICATE KEY UPDATE `owner`='',`maxX`=0.000000,`maxY`=0.000000,`minX`=0.000000,`minY`=0.000000,`flaggeX`=0.000000,`flaggeY`=0.000000,`flaggeZ`=0.000000,`erstellt`='';) - Successfully executed.

stock SaveGZ()
{
for(new i,string[500]; i<MAX_GZ; i++)
{
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
i,GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
format(string,sizeof(string),"%s ON DUPLICATE KEY UPDATE `owner`='%s',`maxX`=%f,`maxY`=%f,`minX`=%f,`minY`=%f,`flaggeX`=%f,`flaggeY`=%f,`flaggeZ`=%f,`erstellt`='%s';",
string, GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
mysql_query(string);
}
return 1;
}

Jeffry · 5. Oktober 2014

Das Query wird doch korrekt ausgeführt.
Wie sieht denn deine Datenbank aus? Es müssen doch Daten dort drin sein, in der "gangwar" Tabelle.

Grapefruit · 5. Oktober 2014

Es befinden sich auch Daten in gangwar in der ersten Zeile wird nur maxx und y, minx und y gespeichert dann kommen 29 Zeilen ohne Inhalt und am ende ist dann das resultat mit den ganzen daten.

Jeffry · 5. Oktober 2014

Also genau das was auch mit dem Query übergeben wird, dann stimmt das doch.
Ich verstehe dein Problem nicht ganz.

Deine Variablen im Server haben (bis auf die ID 0) alle keine Werte, daher werden auch an die Datenbank nur die Werte von ID 0 übergeben. Du siehst ja selbst, dass im Log alle Zeilen, bis auf die erste, auf 0 stehen.

Da solltest du dir mal den Code anschauen, mit dem du die Variablen

Code

GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]

befüllst.

Grapefruit · 5. Oktober 2014

Ich erklär es mal ausführlicher, also wenn ich Ingame mit dem Befehl /creategangzone eine Zone erstelle soll er dies Speichern. Das tut es auch nur das problem ist das er nicht eine Zeile erstellt sondern gleich 30 stück.

Jeffry · 5. Oktober 2014

Sag das doch gleich.

stock SaveGZ()
{
for(new i,string[500]; i<MAX_GZ; i++)
{
if(GZ[i][max_x] == 0.0 && GZ[i][min_x] == 0.0) continue;
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
i,GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
format(string,sizeof(string),"%s ON DUPLICATE KEY UPDATE `owner`='%s',`maxX`=%f,`maxY`=%f,`minX`=%f,`minY`=%f,`flaggeX`=%f,`flaggeY`=%f,`flaggeZ`=%f,`erstellt`='%s';",
string, GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
mysql_query(string);
}
return 1;
}

Dann sollte es nur eine Zeile erstellen.
Lösche natürlich vorher die Daten in der Datenbank, die jetzt noch drin sind.

Grapefruit · 5. Oktober 2014

Jetzt klappt das speichern perfekt, aber wie ich es schon kommen sehen habe funktioniert das laden nicht Aber trozdem bedanke ich mich schonmal bei dir!

stock LoadGZ()
{
new i = 0,string[500],str[64],counter = 0; for(; i<MAX_GZ; i++)
{
GZ[i][zid] = i;
format(string,sizeof(string),"UPDATE gangwar SET owner='%s',maxX='%f',maxY='%f',minX='%f',minY='%f',flaggeX='%f',flaggeY='%f',flaggeZ='%f',erstellt='%s' WHERE id='%d'",
GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt],i);
mysql_query(string);
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
if(GZ[i][erstellt] != 1)continue;
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
break;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(zoneid)
{
new string[500],str[64];
GZ[zoneid][zid] = zoneid;
format(string,sizeof(string),"UPDATE gangwar SET owner='%s',maxX='%f',maxY='%f',minX='%f',minY='%f',flaggeX='%f',flaggeY='%f',flaggeZ='%f',erstellt='%s' WHERE id='%d'",
GZ[zoneid][owner],GZ[zoneid][max_x],GZ[zoneid][max_y],GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],GZ[zoneid][erstellt],zoneid);
mysql_query(string);
format(str,64,"%d |Besitzer: '%s'",zoneid,FrakName(GZ[zoneid][owner]));
M_CreateZone(GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][max_x],GZ[zoneid][max_y],FrakColor(GZ[zoneid][owner]),str,FrakColor(GZ[zoneid][owner]));
GZ[zoneid][pickup] = CreatePickup(1314,1,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],0);
GZ[zoneid][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],20,0);
return 1;
}

Jeffry · 5. Oktober 2014

Schau dir mal hier die "LoadVehicles" Funktion an:
http://forum.sa-mp.com/showthread.php?t=186495

So musst du das auch machen.

UPDATE = Speichern
SELECT = Auslesen (das brauchst du!)

Grapefruit · 5. Oktober 2014

Hab das nun so gemacht, leider klappt das nicht.

stock LoadGZ()
{
new i = 0,string[500],str[64],counter = 0; for(; i<MAX_GZ; i++)
{
GZ[i][zid] = i;
format(string, sizeof(string), "SELECT * FROM gangwar");
mysql_query(string);
mysql_store_result();
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
if(GZ[i][erstellt] != 1)continue;
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
break;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(zoneid)
{
new string[500],str[64];
GZ[zoneid][zid] = zoneid;
format(string, sizeof(string), "SELECT * FROM gangwar");
mysql_query(string);
mysql_store_result();
format(str,64,"%d |Besitzer: '%s'",zoneid,FrakName(GZ[zoneid][owner]));
M_CreateZone(GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][max_x],GZ[zoneid][max_y],FrakColor(GZ[zoneid][owner]),str,FrakColor(GZ[zoneid][owner]));
GZ[zoneid][pickup] = CreatePickup(1314,1,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],0);
GZ[zoneid][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],20,0);
return 1;
}

[19:29:56] >> mysql_store_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::StoreResult() - No data to store.
[19:29:56] >> mysql_fetch_row_format( Connection handle: 1 )
[19:29:56] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[19:29:56] >> mysql_free_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::FreeResult() - The result is already empty.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[19:29:56] >> mysql_real_escape_string( Connection handle: 1 )
[19:29:56] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[19:29:56] >> mysql_query( Connection handle: 1 )
[19:29:56] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[19:29:56] >> mysql_store_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::StoreResult() - Result was stored.
[19:29:56] >> mysql_fetch_int( Connection handle: 1 )
[19:29:56] CMySQLHandler::FetchRow() - Return: 1
[19:29:56] >> mysql_free_result( Connection handle: 1 )
[19:29:56] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:29:56] OnQueryError() - Called.

Jeffry · 5. Oktober 2014

stock LoadGZ()
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new i = -1, counter = 0;
while(mysql_fetch_row(string))
{
i++;
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)continue;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}

Der Teil der "for(new x=0; x<strlen(string); x++)" Schleife kann auch mir sscanf ersetzt werden. Da ich aber kein sscanf nutze, gebe ich es dir so. Zudem finde ich es persönlich besser das so zu schreiben.

Grapefruit · 5. Oktober 2014

Muss ich das bei LoadGZ_ genauso machen oder soll ich es einfach lassen, wenn ja dann funktioniert es leider immer noch nicht.

[19:57:43] >> mysql_store_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::StoreResult() - No data to store.
[19:57:43] >> mysql_fetch_row_format( Connection handle: 1 )
[19:57:43] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[19:57:43] >> mysql_free_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::FreeResult() - The result is already empty.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[19:57:43] >> mysql_real_escape_string( Connection handle: 1 )
[19:57:43] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[19:57:43] >> mysql_query( Connection handle: 1 )
[19:57:43] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[19:57:43] >> mysql_store_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::StoreResult() - Result was stored.
[19:57:43] >> mysql_fetch_int( Connection handle: 1 )
[19:57:43] CMySQLHandler::FetchRow() - Return: 1
[19:57:43] >> mysql_free_result( Connection handle: 1 )
[19:57:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
[19:57:43] OnQueryError() - Called.

Jeffry · 5. Oktober 2014

Ja, nur ohne die while Schleife und mit:
format(string, sizeof(string), "SELECT * FROM gangwar WHERE id = %d", zoneid);

Grapefruit · 5. Oktober 2014

Hab das nun so, aber es geht leider immer noch nicht oder muss ich hinter id = %d noch minx = %f usw.?

stock LoadGZ_(zoneid)
{
new string[500],str[64];
GZ[zoneid][zid] = zoneid;
format(string, sizeof(string), "SELECT * FROM gangwar WHERE id = %d", zoneid);
mysql_query(string);
mysql_store_result();
format(str,64,"%d |Besitzer: '%s'",zoneid,FrakName(GZ[zoneid][owner]));
M_CreateZone(GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][max_x],GZ[zoneid][max_y],FrakColor(GZ[zoneid][owner]),str,FrakColor(GZ[zoneid][owner]));
GZ[zoneid][pickup] = CreatePickup(1314,1,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],0);
GZ[zoneid][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],20,0);
return 1;
}

Jeffry · 5. Oktober 2014

Da fehlt doch alles. Schau dir doch mal meinen Code und deinen Code an. Der Unterschied ist ja wohl nicht zu übersehen.

stock LoadGZ_(i)
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new counter = 0;
mysql_fetch_row(string);
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)return 1;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}

Das i mit zoneid zu ersetzen kannst du machen, musst du aber nicht.

Grapefruit · 5. Oktober 2014

Bekomme einen Error:

C:\Users\Eddy\Desktop\Projekt\Programm\gamemodes\gangwar.pwn(504) : error 024: "break" or "continue" is out of context
Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

1 Error.

Jeffry · 5. Oktober 2014

if(GZ[i][erstellt] != 1)continue;
Zu
if(GZ[i][erstellt] != 1)return 1;

Hab ich übersehen.

Grapefruit · 5. Oktober 2014

Es klappt leider immer noch nicht, trozdem Danke furs ganzen Tag helfen

Jeffry · 5. Oktober 2014

Poste den Code und den Log, so wie es jetzt ist.

Grapefruit · 5. Oktober 2014

stock LoadGZ()
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new i = -1, counter = 0;
while(mysql_fetch_row(string))
{
i++;
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)continue;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
}
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock LoadGZ_(i)
{
new string[500], str[64];
mysql_query("SELECT * FROM gangwar");
mysql_store_result();
new counter = 0;
mysql_fetch_row(string);
strins(string, "|", strlen(string));
new oldx=0;
new count=0;
for(new x=0; x<strlen(string); x++)
{
if(string[x]=='|')
{
count++;
new tmpstring[sizeof(string)]; tmpstring=string;
strdel(tmpstring, x, strlen(tmpstring));
strdel(tmpstring, 0, oldx+1);
switch(count)
{
case 2: GZ[i][owner] = strval(tmpstring);
case 3: GZ[i][max_x] = floatstr(tmpstring);
case 4: GZ[i][max_y] = floatstr(tmpstring);
case 5: GZ[i][min_x] = floatstr(tmpstring);
case 6: GZ[i][min_y] = floatstr(tmpstring);
case 7: GZ[i][flagge_x] = floatstr(tmpstring);
case 8: GZ[i][flagge_y] = floatstr(tmpstring);
case 9: GZ[i][flagge_z] = floatstr(tmpstring);
case 10: GZ[i][erstellt] = strval(tmpstring);
}
oldx=x;
}
}
GZ[i][zid] = i;
if(GZ[i][erstellt] != 1)return 1;
format(str,64,"%d |Besitzer: '%s'",i,FrakName(GZ[i][owner]));
M_CreateZone(GZ[i][min_x],GZ[i][min_y],GZ[i][max_x],GZ[i][max_y],FrakColor(GZ[i][owner]),str,FrakColor(GZ[i][owner]));
GZ[i][pickup] = CreatePickup(1314,1,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],0);
GZ[i][label] = Create3DTextLabel("Tippe '/angriff', um das Gebiet anzugreifen.\nTippe '/flagge', um die Flagge zu erobern.",Rot,GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],20,0);
counter ++;
return printf(" '%d' Gangzone(n) wurde(n) erfolgreich erstellt und geladen.",counter);
}
stock SaveGZ()
{
for(new i,string[500]; i<MAX_GZ; i++)
{
if(GZ[i][max_x] == 0.0 && GZ[i][min_x] == 0.0) continue;
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
i,GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
format(string,sizeof(string),"%s ON DUPLICATE KEY UPDATE `owner`='%s',`maxX`=%f,`maxY`=%f,`minX`=%f,`minY`=%f,`flaggeX`=%f,`flaggeY`=%f,`flaggeZ`=%f,`erstellt`='%s';",
string, GZ[i][owner],GZ[i][max_x],GZ[i][max_y],GZ[i][min_x],GZ[i][min_y],GZ[i][flagge_x],GZ[i][flagge_y],GZ[i][flagge_z],GZ[i][erstellt]);
mysql_query(string);
}
return 1;
}
stock SaveGZ_(zoneid)
{
new string[500];
format(string,sizeof(string),"INSERT INTO gangwar (id,owner,maxX,maxY,minX,minY,flaggeX,flaggeY,flaggeZ,erstellt) VALUES (%d,'%s','%f','%f','%f','%f','%f','%f','%f','%s')",
zoneid,GZ[zoneid][owner],GZ[zoneid][max_x],GZ[zoneid][max_y],GZ[zoneid][min_x],GZ[zoneid][min_y],GZ[zoneid][flagge_x],GZ[zoneid][flagge_y],GZ[zoneid][flagge_z],GZ[zoneid][erstellt]);
mysql_query(string);
return 1;
}

[21:06:24] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:24] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:24] >> mysql_query( Connection handle: 1 )
[21:06:24] CMySQLHandler::Query(SELECT * FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:06:24] >> mysql_store_result( Connection handle: 1 )
[21:06:24] CMySQLHandler::StoreResult() - Result was stored.
[21:06:24] >> mysql_num_rows( Connection handle: 1 )
[21:06:24] CMySQLHandler::NumRows() - Returned 1 row(s)
[21:06:24] >> mysql_free_result( Connection handle: 1 )
[21:06:24] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:27] >> mysql_query( Connection handle: 1 )
[21:06:27] CMySQLHandler::Query(SELECT `Passwort` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:06:27] >> mysql_store_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::StoreResult() - Result was stored.
[21:06:27] >> mysql_fetch_row_format( Connection handle: 1 )
[21:06:27] CMySQLHandler::FetchRow() - Return: 73eef00cc792ddc37ed99c801678057f
[21:06:27] >> mysql_free_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(acounts); - Escaped 7 characters to acounts.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Adresse); - Escaped 7 characters to Adresse.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:27] >> mysql_query( Connection handle: 1 )
[21:06:27] CMySQLHandler::Query(SELECT `Adresse` FROM `acounts` WHERE `Spielername` = 'TaigX') - An error has occured. (Error ID: 1146, Table 'samp.acounts' doesn't exist)
[21:06:27] >> mysql_store_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::StoreResult() - No data to store.
[21:06:27] >> mysql_fetch_row_format( Connection handle: 1 )
[21:06:27] CMySQLHandler::FetchRow() - You cannot call this function now. (Reason: Empty Result)
[21:06:27] >> mysql_free_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::FreeResult() - The result is already empty.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Adminlevel); - Escaped 10 characters to Adminlevel.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(Spielername); - Escaped 11 characters to Spielername.
[21:06:27] >> mysql_real_escape_string( Connection handle: 1 )
[21:06:27] CMySQLHandler::EscapeString(TaigX); - Escaped 5 characters to TaigX.
[21:06:27] >> mysql_query( Connection handle: 1 )
[21:06:27] CMySQLHandler::Query(SELECT `Adminlevel` FROM `accounts` WHERE `Spielername` = 'TaigX') - Successfully executed.
[21:06:27] >> mysql_store_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::StoreResult() - Result was stored.
[21:06:27] >> mysql_fetch_int( Connection handle: 1 )
[21:06:27] CMySQLHandler::FetchRow() - Return: 1
[21:06:27] >> mysql_free_result( Connection handle: 1 )
[21:06:27] CMySQLHandler::FreeResult() - Result was successfully free'd.
[21:06:27] OnQueryError() - Called.
[21:13:13] >> mysql_query( Connection handle: 1 )
[21:13:13] CMySQLHandler::Query(UPDATE accounts SET Adresse='255.255.255.255',Adminlevel=1 WHERE Spielername='TaigX') - Successfully executed.

Jeffry · 5. Oktober 2014

In dem Log steht gar nichts davon, daß heißt, dass du LoadGZ nirgends im Code aufrufst.