Register / Login wird nicht angezeigt.

//MySQL DATA
forward UserCheck(playerid);
public UserCheck(playerid)
{
new num_rows, num_fields;
cache_get_data(num_rows,num_fields,Handle);
SetPlayerVirtualWorld(playerid,1);
if(num_rows = 0)
{
//Register
ClearChat(playerid);
ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Neuanfang","Herzlich Willkommen,\n auf unserem Game Server: bitte gebe dein Password ein.","Register","Abbrechen");
}
else
{
//Login
ClearChat(playerid);
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Anmeldung","bitte gebe dein Password ein.","Login","Abbrechen");
}
return 1;
}

stock Spielername(playerid)
{
new Name[MAX_PLAYER_NAME];
GetPlayerName(playerid,Name,MAX_PLAYER_NAME);
return Name;
}


public OnPlayerConnect(playerid)
{

new query[256];
mysql_format(Handle, query, sizeof(query),"SELCET * FROM accounts WHERE Name='%e'",Spielername(playerid));
mysql_tquery(Handle,query,"UserCheck","i",playerid);
ClearChat(playerid);
TogglePlayerSpectating(playerid,1);
return 1;
}


enum Data{
db_id,
pName,
pLoggedIn,
pGeschlecht,
pSkin
};

Bitte umhilfe.

Zitat von Kevin_CaruZo

Was hast du bei OnPlayerRequst stehen?

public OnDialogResponse(playerid, dialogid, response, listitem, inputtext[])
{
return 1;
}

public OnPlayerClickPlayer(playerid, clickedplayerid, source)
{
return 1;
}

//MySQL DATA
forward UserCheck(playerid);
public UserCheck(playerid)
{
new num_rows, num_fields;
cache_get_data(num_rows,num_fields,Handle);
SetPlayerVirtualWorld(playerid,1);
if(num_rows = 0)
{
//Register
ClearChat(playerid);
ShowPlayerDialog(playerid,DIALOG_REGISTER,DIALOG_STYLE_PASSWORD,"Neuanfang","Herzlich Willkommen,\n auf unserem Game Server: bitte gebe dein Password ein.","Register","Abbrechen");
}
else
{
//Login
ClearChat(playerid);
ShowPlayerDialog(playerid,DIALOG_LOGIN,DIALOG_STYLE_PASSWORD,"Anmeldung","bitte gebe dein Password ein.","Login","Abbrechen");
}
return 1;
}

Zitat von Mogly1

Nur so ne Frage du kriegst keien Warnings errors?
weil das müsste so aussehen
if(num_rows == 0)

du hast nur
if(num_rows = 0)

Wird mir auch nicht mit == angezeigt.

Zitat von Mogly1

und sag mal was kommt

[21:53:00] [DEBUG] mysql_format - connection: 1, len: 256, format: "SELCET * FROM accounts WHERE Name='%e'"
[21:53:00] [DEBUG] mysql_tquery - connection: 1, query: "SELCET * FROM accounts WHERE Name='Emrys.'", callback: "UserCheck", format: "i"
[21:53:00] [DEBUG] CMySQLQuery::Execute[UserCheck] - starting query execution
[21:53:00] [ERROR] CMySQLQuery::Execute[UserCheck] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'SELCET * FROM accounts WHERE Name='Emrys.'' at line 1
[21:53:00] [DEBUG] CMySQLQuery::Execute[UserCheck] - error will be triggered in OnQueryError

Zitat von StarFir3

Wird überhaupt eine Verbindung zur Datenbank aufgebaut ?
Poste mal dein Mysql_log

Habs hinbekommen nur der Player spawnt noch nicht.