MySQL speichert nicht in die Datenbank!

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
  • [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;
    }

  • 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.

  • 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.


  • Sag das doch gleich. :fun:


    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.

  • 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;
    }

  • 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.

    Einmal editiert, zuletzt von Grapefruit ()

  • 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.

  • 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.

  • 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;
    }

  • 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.

    3HZXdYd.png

    Einmal editiert, zuletzt von Jeffry ()

  • 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.