Kann mir jemand einen DeleteAccount schreiben ich bin nicht so der beste in MySQL 
Ich habe schon angefangen komm nur beim querry nicht weiter...
stock DeleteAccount(playerid, pass[])
{
new query[124],Name[MAX_PLAYER_NAME];
GetPlayerName(playerid, Name, sizeof(Name));
mysql_real_escape_string(Name,Name);
format(query, sizeof(query), "");
mysql_query(query);
return true;
}
Datenbankname: accounts
Würde mich freuen wenn jemand helfen kann 
Ganz liebe Grüße,
kleinerOpa
format(query, sizeof(query), "DELETE FROM `accounts` WHERE `username` = '%s'", Name);
username ggf. abändern.
Danke dir!
Ich habe nun ein weiteres Problem.
Mein System Speichert nun nichts mehr in der Datebabnk ab.
Ich weiß zu 100% das es durch die Abfrage geht, ich habe es via "print" nachgeprüft.
Folgendes kann falsch sein....
1)
mysql_SetInt("accounts", "Registrierungsschritt", pInfo[playerid][RegStep], "Name", pInfo[playerid][pName]);
mysql_SetInt("accounts", "Geschlecht", pInfo[playerid][pGender], "Name", pInfo[playerid][pName]);
2)stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE %s SET %s = '%d' WHERE %s = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
Debug-Log:
[00:23:17] ---------------------------
[00:23:17] MySQL Debugging activated (01/05/13)
[00:23:17] ---------------------------
[00:23:17]
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(Registrierungsschritt); - Escaped 21 characters to Registrierungsschritt.
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(); - Escaped 0 characters to .
[00:23:48] >> mysql_query( Connection handle: 1 )
[00:23:48] CMySQLHandler::Query(SELECT Registrierungsschritt FROM accounts WHERE Name = '') - Successfully executed.
[00:23:48] >> mysql_store_result( Connection handle: 1 )
[00:23:48] CMySQLHandler::StoreResult() - Result was stored.
[00:23:48] >> mysql_fetch_int( Connection handle: 1 )
[00:23:48] >> mysql_free_result( Connection handle: 1 )
[00:23:48] CMySQLHandler::FreeResult() - Result was successfully free'd.
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(kleinerOpa); - Escaped 10 characters to kleinerOpa.
[00:23:48] >> mysql_query( Connection handle: 1 )
[00:23:48] CMySQLHandler::Query(SELECT * FROM accounts WHERE Name = 'kleinerOpa') - Successfully executed.
[00:23:48] >> mysql_store_result( Connection handle: 1 )
[00:23:48] CMySQLHandler::StoreResult() - Result was stored.
[00:23:48] >> mysql_num_rows( Connection handle: 1 )
[00:23:48] CMySQLHandler::NumRows() - Returned 1 row(s)
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(kleinerOpa); - Escaped 10 characters to kleinerOpa.
[00:23:48] >> mysql_query( Connection handle: 1 )
[00:23:48] CMySQLHandler::Query(SELECT * FROM accounts WHERE Name = 'kleinerOpa') - Successfully executed.
[00:23:48] >> mysql_store_result( Connection handle: 1 )
[00:23:48] CMySQLHandler::StoreResult() - Result was stored.
[00:23:48] >> mysql_num_rows( Connection handle: 1 )
[00:23:48] CMySQLHandler::NumRows() - Returned 1 row(s)
[00:23:48] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:48] CMySQLHandler::EscapeString(kleinerOpa); - Escaped 10 characters to kleinerOpa.
[00:23:48] >> mysql_query( Connection handle: 1 )
[00:23:48] CMySQLHandler::Query(DELETE FROM `accounts` WHERE Name = 'kleinerOpa') - Successfully executed.
[00:23:51] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:51] CMySQLHandler::EscapeString(kleinerOpa); - Escaped 10 characters to kleinerOpa.
[00:23:51] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:51] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
[00:23:51] >> mysql_query( Connection handle: 1 )
[00:23:51] CMySQLHandler::Query(INSERT INTO accounts (Name, Passwort) VALUES ('kleinerOpa', '123456')) - Successfully executed.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(Registrierungsschritt); - Escaped 21 characters to Registrierungsschritt.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(); - Escaped 0 characters to .
[00:23:58] >> mysql_query( Connection handle: 1 )
[00:23:58] CMySQLHandler::Query(UPDATE accounts SET Registrierungsschritt = '1' WHERE Name = '') - Successfully executed.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(accounts); - Escaped 8 characters to accounts.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(Geschlecht); - Escaped 10 characters to Geschlecht.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(Name); - Escaped 4 characters to Name.
[00:23:58] >> mysql_real_escape_string( Connection handle: 1 )
[00:23:58] CMySQLHandler::EscapeString(); - Escaped 0 characters to .
[00:23:58] >> mysql_query( Connection handle: 1 )
[00:23:58] CMySQLHandler::Query(UPDATE accounts SET Geschlecht = '1' WHERE Name = '') - Successfully executed.Weißt du was drüber 
deiner
stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE %s SET %s = '%d' WHERE %s = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
kann dir höchstens meinen stock anbieten der ein kleinen wenig anders aussieht.
meiner
stock mysql_SetInt(Table[], Field[], To, Where[], Where2[])
{
new query[128];
mysql_real_escape_string(Table, Table);
mysql_real_escape_string(Field, Field);
mysql_real_escape_string(Where, Where);
mysql_real_escape_string(Where2, Where2);
format(query, 128, "UPDATE `%s` SET `%s` = '%d' WHERE `%s` = '%s'", Table, Field, To, Where, Where2);
mysql_query(query);
return true;
}
in der fomat zeile fehlen ein paar ' '.. aber ob das nun der grund ist kann ich nicht sagen 
vlcht hilfts ja
edit:
falls das nicht das problem ist..
ist RegStep und pGender vielleicht als string im enum deklariert?
