tag mismatch was tun?

Guten Tag,

ich habe hier:
if(!strlen(inputtext) < 4)return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde kein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
& hier:
if(SpielerInfo[playerid][pEingeloggt] == false) return 1;
Diesen Fehler Code?

C:\Users\Patrick\Desktop\IRP-City\gamemodes\Reallife-Skript.pwn(274) : warning 213: tag mismatch
C:\Users\Patrick\Desktop\IRP-City\gamemodes\Reallife-Skript.pwn(314) : warning 213: tag mismatch
Pawn compiler 3.2.3664	 	 	Copyright (c) 1997-2006, ITB CompuPhase




2 Warnings.

Gruße

Jeffry:
Meinst du so?
enum PD
{
boolean pEingeloggt,
pGeld,
pLevel,
};

Jeffry:

Ich weiß nicht warum aber ich glaub MySQL mag mich nicht.
Es funktioniert alles er stellt Verbindung her etc. aber wenn ich mich Registriere wird ncihts in der DB gespeichert.
MySQL Log:

[14:31:23] [DEBUG] mysql_escape_string - source: "FerienFreak", connection: 1, max_len: 24[14:31:23] [DEBUG] mysql_escape_string - source: "patrick", connection: 1, max_len: 50[14:31:23] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO (username, passwort) VALUES  ('FerienFreak',MD5('pat", callback: "(null)", format: "(null)"[14:31:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution[14:31:23] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(username, passwort) VALUES  ('FerienFreak',MD5('patrick')' at line 1

Wisst ihr was man machen kann?
#define MYSQL_HOST "127.0.0.1"
#define MYSQL_USER "root"
#define MYSQL_DATA "reallife server"
#define MYSQL_PASS ""

http://img5.fotos-hochladen.net/uploads/mysql7eylwxr06f.jpg

Jeffry:
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
new query[256], key[50];
if(dialogid == DIALOG_REGISTER)
{
if(!response)
{
return Kick(playerid);
}
if(strlen(inputtext) < 4)return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde kein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
format(key, 50, "%s", inputtext);
mysql_escape_string(NamePlayer(playerid), NamePlayer(playerid)), mysql_escape_string(key, key);
format(query, sizeof(query), "INSERT INTO (username, passwort) VALUES ('%s',MD5('%s')", NamePlayer(playerid), key);
mysql_tquery(mysqlHandle, query);
SendClientMessage(playerid, -1, "Dein Account wurde erstellt.");
printf("Account erstellt %s",NamePlayer(playerid));
GivePlayerMoney(playerid, 50000), SetPlayerScore(playerid, 10);
}
if(dialogid == DIALOG_LOGIN)
{
if(!response)
{
return Kick(playerid);
}
format(key, 50, "%s", inputtext);
mysql_escape_string(NamePlayer(playerid), NamePlayer(playerid)), mysql_escape_string(key, key);
format(query, sizeof(query), "SELECT * FROM user WHERE username='%s' AND password='%s'", NamePlayer(playerid), key);
mysql_tquery(mysqlHandle, query, "OnPasswordResponse", "i", playerid);
printf("Eingeloggt %s",NamePlayer(playerid));
}
return 1;
}

public UserCheck(playerid)
{
new num_rows, num_fields;
cache_get_data(num_rows, num_fields, mysqlHandle);
if(num_rows == 0)
{
//Register..
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde kein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
else
{
//Login..
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde ein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
return 1;
}
stock LoadAccount(playerid)
{
SpielerInfo[playerid][pEingeloggt] = true;
SpielerInfo[playerid][pGeld] = cache_get_field_content_int(0, "Geld", mysqlHandle), GivePlayerMoney(playerid, SpielerInfo[playerid][pGeld]);
SpielerInfo[playerid][pLevel] = cache_get_field_content_int(0, "Level", mysqlHandle), SetPlayerScore(playerid, SpielerInfo[playerid][pLevel]);
printf("Acc geladen (%s)",NamePlayer(playerid));
return 1;
}

stock SpielerSpeichern(playerid)
{
new query[50];
if(SpielerInfo[playerid][pEingeloggt] == false) return 1;
mysql_escape_string(NamePlayer(playerid), NamePlayer(playerid));
format(query, sizeof(query), "UPDATE user SET Geld='%i',Level='%i' WHERE username='%s'", GetPlayerMoney(playerid), GetPlayerScore(playerid), NamePlayer(playerid));
mysql_tquery(mysqlHandle, query);
printf("Acc gespeichert (%s)",NamePlayer(playerid));
return 1;
}

Jeffry:

Danke das du mir hilfst.

Hab immer noch ein fehler.

[15:34:07] [DEBUG] mysql_escape_string - source: "FerienFreak", connection: 1, max_len: 24
[15:34:07] [DEBUG] mysql_escape_string - source: "patrick", connection: 1, max_len: 50
[15:34:07] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO (username, passwort) VALUES  ('FerienFreak',MD5('pat", callback: "(null)", format: "(null)"
[15:34:07] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[15:34:07] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(username, passwort) VALUES  ('FerienFreak',MD5('patrick'))' at line 1

Hab einen Neuen Fehler?

[15:45:21] [DEBUG] cache_get_data - connection: 1
[15:45:21] [WARNING] cache_get_data - no active cache
[15:45:23] [DEBUG] mysql_escape_string - source: "FerienFreak", connection: 1, max_len: 24
[15:45:23] [DEBUG] mysql_escape_string - source: "patrick", connection: 1, max_len: 50
[15:45:23] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO user (`username`, `passwort`) VALUES ('FerienFreak',", callback: "(null)", format: "(null)"
[15:45:23] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[15:45:23] [ERROR] CMySQLQuery::Execute[] - (error #1146) Table 'reallife server.user' doesn't exist

Aber ich hab ne Frage ist der Command hier richtig?
ocmd:server(playerid)
{
new num_rows, num_fields;
cache_get_data(num_rows, num_fields, mysqlHandle);
if(num_rows == 0)
{
//Register..
ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde kein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
else
{
//Login..
ShowPlayerDialog(playerid, DIALOG_LOGIN, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde ein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
}
return 1;
}
public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
new query[256], key[50];
if(dialogid == DIALOG_REGISTER)
{
if(!response)
{
return Kick(playerid);
}
if(strlen(inputtext) < 4)return ShowPlayerDialog(playerid, DIALOG_REGISTER, DIALOG_STYLE_PASSWORD, "Anmeldung", "Es wurde kein Account unter diesem namen gefunden!", "Anmelden", "Abbrechen");
format(key, 50, "%s", inputtext);
mysql_escape_string(NamePlayer(playerid), NamePlayer(playerid)), mysql_escape_string(key, key);
format(query, sizeof(query), "INSERT INTO user (`username`, `passwort`) VALUES ('%s',MD5('%s'))", NamePlayer(playerid), key);
mysql_tquery(mysqlHandle, query);
SendClientMessage(playerid, -1, "Dein Account wurde erstellt.");
printf("Account erstellt %s",NamePlayer(playerid));
GivePlayerMoney(playerid, 50000), SetPlayerScore(playerid, 10);
}
if(dialogid == DIALOG_LOGIN)
{
if(!response)
{
return Kick(playerid);
}
format(key, 50, "%s", inputtext);
mysql_escape_string(NamePlayer(playerid), NamePlayer(playerid)), mysql_escape_string(key, key);
format(query, sizeof(query), "SELECT * FROM user WHERE username='%s' AND password='%s'", NamePlayer(playerid), key);
mysql_tquery(mysqlHandle, query, "OnPasswordResponse", "i", playerid);
printf("Eingeloggt %s",NamePlayer(playerid));
}
return 1;
}
Jeffry:

Habe ein bisschen ausprobiert doch es kommt das.

[16:09:47] [DEBUG] mysql_escape_string - source: "FerienFreak", connection: 1, max_len: 24[16:09:47] [DEBUG] mysql_escape_string - source: "patrick", connection: 1, max_len: 50[16:09:47] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO accounts (`Name`, `Passwort`) VALUES ('FerienFreak',", callback: "(null)", format: "(null)"[16:09:47] [DEBUG] CMySQLQuery::Execute[] - starting query execution[16:09:47] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.296 milliseconds[16:09:47] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving

http://www.fotos-hochladen.net/uploads/mysqlpw1m0n3r5k.jpg

Jeffry:

Es Funktioniert alles
Danke an alle vorallem Jeffry (y)