MySQL Lese Fehler

Lieben User,

Ich bin seit einer zeit dabei einen SAMP Server zu schreiben,
Leider ist mir wohl ein fehler beim Laden unterlaufen. Leider weiß ich nicht woran es Liegt hier mal den Error der MYSQL Log:

[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("level")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("money")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("hp")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("alevel")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frak")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frang")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("donator")[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("carkeys")

Hier der SAMP Code:
public OnCheckPassword(playerid){new num_fields,num_rows; cache_get_data(num_rows,num_fields,database); if(num_rows==1) { //load player[playerid][level] = cache_get_field_content_int(0,"level",database); player[playerid][money] = cache_get_field_content_int(0,"money",database); player[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",database); player[playerid][hp] = cache_get_field_content_int(0,"hp",database); player[playerid][alevel] = cache_get_field_content_int(0,"alevel",database); player[playerid][frak] = cache_get_field_content_int(0,"frak",database); player[playerid][frang] = cache_get_field_content_int(0,"frang",database); player[playerid][donator] = cache_get_field_content_int(0,"donator",database); player[playerid][carkeys] = cache_get_field_content_int(0,"carkeys",database); player[playerid][db_id] = cache_get_field_content_int(0,"id",database); SetPlayerScore(playerid, player[playerid][level]); GivePlayerMoney(playerid, player[playerid][money]); SetPlayerHealth(playerid,player[playerid][hp]); SendClientMessage(playerid, COLOR_RED, player[playerid][alevel]); } else { SendClientMessage(playerid,COLOR_RED,"Das Passwort ist falsch."); ShowPlayerDialog(playerid,LOGIN_D,DIALOG_STYLE_PASSWORD,"Login","Gibt dein Passwort ein:","Okay","Abbrechen"); } return 1;}

Würde mich über schnelle hilfe freuen.

Zitat von GamerKing44

Benutze als SAMP Code statt Quelltext

Sorry wen ich so dumm frage aber wie geht das ich bin neu im forum

Zitat von Homez

Herzlich Willkommen im Breadfish Forum.

Danke und hier die Codes:

[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("level")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("money")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("hp")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("alevel")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frak")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frang")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("donator")
[20:23:05] [WARNING] CMySQLResult::GetRowDataByName - field not found ("carkeys")

public OnCheckPassword(playerid)
{
new num_fields,num_rows;
cache_get_data(num_rows,num_fields,database);
if(num_rows==1)
{
//load
player[playerid][level] = cache_get_field_content_int(0,"level",database);
player[playerid][money] = cache_get_field_content_int(0,"money",database);
player[playerid][spawnchange] = cache_get_field_content_int(0,"spawnchange",database);
player[playerid][hp] = cache_get_field_content_int(0,"hp",database);
player[playerid][alevel] = cache_get_field_content_int(0,"alevel",database);
player[playerid][frak] = cache_get_field_content_int(0,"frak",database);
player[playerid][frang] = cache_get_field_content_int(0,"frang",database);
player[playerid][donator] = cache_get_field_content_int(0,"donator",database);
player[playerid][carkeys] = cache_get_field_content_int(0,"carkeys",database);
player[playerid][db_id] = cache_get_field_content_int(0,"id",database);
SetPlayerScore(playerid, player[playerid][level]);
GivePlayerMoney(playerid, player[playerid][money]);
SetPlayerHealth(playerid,player[playerid][hp]);
SendClientMessage(playerid, COLOR_RED, player[playerid][alevel]);
}
else
{
//Passwort falsch
SendClientMessage(playerid,COLOR_RED,"Das eingegebene Passwort ist falsch.");
ShowPlayerDialog(playerid,LOGIN_D,DIALOG_STYLE_PASSWORD,"Login","Gibt bitte dein Passwort ein:","Okay","Abbrechen");
}
return 1;
}

enum players{
db_id,
level,
money,
spawnchange,
hp,
alevel,
frak,
frang,
donator,
carkeys
}

Ja eigentlich schon,
http://puu.sh/gyz1N/f80ccf3e2a.png

Ja ich verbinde mich richtig mit der datenbank sonst könnte ich mich auch nicht registrieren.

enum players{
db_id,
level,
money,
spawnchange,
hp,
alevel,
frak,
frang,
donator,
carkeys
}
new player[MAX_PLAYERS][players];[pwn]

C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : error 028: invalid subscript (not an array or too many subscripts): "players"
C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : warning 215: expression has no effect
C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : error 001: expected token: ";", but found "]"
C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : error 029: invalid expression, assumed zero
C:\Program Files (x86)\RockStar Games\Grand Theft Auto San Andreas - Multiplayer\SA-MP Server\gamemodes\BE.pwn(399) : fatal error 107: too many error messages on one line

Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase

4 Errors.

Immer noch der gleiche error

[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("level")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("money")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("spawnchange")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("hp")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("alevel")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frak")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("frang")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("donator")
[16:46:10] [WARNING] CMySQLResult::GetRowDataByName - field not found ("carkeys")

Zitat von OfflineGamer

Wir sind hier im MTA Bereich nicht SAMP!

Ups Sorry, error ist immernoch da...