MySQL speichert nicht in die Datenbank!

Schönen Abend breadfish,

mein problem liegt beim speichern, Ingame klappt das System wunderbar, aber es wird leider nichts in die Datenbank geschrieben.

MySQL_Log:

[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='2029.726684',maxY='1330.839477',minX='2053.801269',minY='1365.484130',flaggeX='2045.354370',flaggeY='1340.911376',flaggeZ='10.671875',erstellt='' WHERE id='0') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='1') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='2') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='3') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='4') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='5') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='6') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='7') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='8') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='9') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='10') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='11') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='12') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='13') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='14') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='15') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='16') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='17') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='18') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='19') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='20') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='21') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='22') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='23') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='24') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='25') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='26') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='27') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='28') - Successfully executed.
[22:01:02] >> mysql_query( Connection handle: 1 )
[22:01:02] CMySQLHandler::Query(UPDATE gangwar SET owner='',maxX='0.000000',maxY='0.000000',minX='0.000000',minY='0.000000',flaggeX='0.000000',flaggeY='0.000000',flaggeZ='0.000000',erstellt='' WHERE id='29') - Successfully executed.

Code:

stock SaveGZ()
{
for(new i,string[500]; i<MAX_GZ; 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);
}
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;
}

Mit freundlichen Grüßen
Grapefruit

Jetzt klappt garnichts mehr

Es wird immer noch nichts gespeichert, trozdem danke

Zitat von Jeffry

Hast du denn in deiner Datenbank schon eine Zeile stehen, also die Daten von der ersten GangZone?
Wenn nein, dann musst du das auch erst machen, nicht mit UPDATE aber mit INSERT.

Du könntest auch, um zwei verschiedene Strings zu vermeiden (einmal UPDATE und einmal INSERT) folgendes nutzen:
http://dev.mysql.com/doc/refman/5.1/de/i…-duplicate.html

Ich verstehe nicht genau was du meinst, bei mir wird in die Datenbank nichts eingetragen, also auch keine Daten von der ersten Gangzone. Wie mach ich das denn genau?

Zitat von CIBERKILLER

Er meint, dass du UPDATE verwendest, aber wenn es noch keine Zeile zum Updaten gibt ?

Ja, dies hab ich nun umgeändert, leider hat sich nichts verändert.

Zitat von CIBERKILLER

Er meint, dass du UPDATE verwendest, aber wenn es noch keine Zeile zum Updaten gibt ?

Deswegen REPLACE INTO oder so.

EDIT://
Bist du blind ?

Mit oder so kann ich nichts anfangen, aber trozdem Danke
Es steht dort zwar, aber es wird trozdem nichts in die Datenbank eingetragen.

Bin nun weiter gekommen, jetzt trägt er es endlich in die Datenbank, aber es werden 30 weitere Zeilen angelegt ohne Inhalt. Weiß jemand weiter?

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]);
mysql_query(string);
//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);
}
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;
}

Hab das noch in der Log gefunden:

[12:24:22] 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','')) - An error has occured. (Error ID: 1062, Duplicate entry '1' for key 'PRIMARY')
[12:24:22] >> mysql_query( Connection handle: 1 )

Wenn du eine andere Code stelle brauchst sag bescheid, ich weiß nähmlich nicht wo es passieren könnte das er soviele Tabellen erstellt außer unter save.

Jetzt wird wieder nichts in die Tabelle eingetragen, in der Log kommt auch nur dies:

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

Ups, dass hatte ich ausversehen mit gelöscht, aber das problem besteht leider weiter hin.