[Shetch]

I have this code where a player gets kicked if he connects to the server without a registered nickname. Every time I connect, I het kicked although I am registered.

Код:

new query[128], name[MAX_PLAYER_NAME + 1];
GetPlayerName(playerid, name, sizeof(name));
mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `name` = '%e'", name);
printf("QUERY: %s", query);
mysql_tquery(mysql, query, "", "");

new rows, fields;
cache_get_data(rows, fields);
if(rows == 0)
{
    MessageKick(playerid, COLOR_RED, "Error: You must register on our website before playing.");
    return 1;
}
else
{
    cache_get_field_content(0, "password", player[playerid][p_password], 129);
    ShowPlayerDialog(playerid, DIALOG_LOG_IN, DIALOG_STYLE_PASSWORD, COLOR_WHITE_EMBEDDED"Log In", COLOR_WHITE_EMBEDDED"Welcome to "COLOR_BLUE_EMBEDDED"Reality Role-Play"COLOR_WHITE_EMBEDDED"!\nLog In by typing in your password below.", "Confirm", "Cancel");
    player[playerid][p_log_in_tries] = 3;
}

[Ranshand]

Change.

Код:

mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `name` = '%e'", name);

To.

Код:

mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `name` = '%s'", name);

[Shetch]

Quote:

Originally Posted by Ranshand Change. Код: mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `name` = '%e'", name); To. Код: mysql_format(mysql, query, sizeof(query), "SELECT * FROM `players` WHERE `name` = '%s'", name);

The '%e' is there to prevent MySQL injection. The query is correct, there's something worng with reading the data recieved.

[iZN]

pawn Код:

cache_get_data(rows, fields);
if(!rows)
{
    MessageKick(playerid, COLOR_RED, "Error: You must register on our website before playing.");
    return 1;
}
else
{
    cache_get_field_content(0, "password", player[playerid][p_password], 129);
    ShowPlayerDialog(playerid, DIALOG_LOG_IN, DIALOG_STYLE_PASSWORD, COLOR_WHITE_EMBEDDED"Log In", COLOR_WHITE_EMBEDDED"Welcome to "COLOR_BLUE_EMBEDDED"Reality Role-Play"COLOR_WHITE_EMBEDDED"!\nLog In by typing in your password below.", "Confirm", "Cancel");
    player[playerid][p_log_in_tries] = 3;
}

[Shetch]

Quote:

Originally Posted by iZN pawn Код: cache_get_data(rows, fields); if(!rows) {     MessageKick(playerid, COLOR_RED, "Error: You must register on our website before playing.");     return 1; } else {     cache_get_field_content(0, "password", player[playerid][p_password], 129);     ShowPlayerDialog(playerid, DIALOG_LOG_IN, DIALOG_STYLE_PASSWORD, COLOR_WHITE_EMBEDDED"Log In", COLOR_WHITE_EMBEDDED"Welcome to "COLOR_BLUE_EMBEDDED"Reality Role-Play"COLOR_WHITE_EMBEDDED"!\nLog In by typing in your password below.", "Confirm", "Cancel");     player[playerid][p_log_in_tries] = 3; }

I'm pretty sure 'rows == 0' is the same as '!rows'. Tried it, doesn't work.

[iZN]

Quote:

Originally Posted by Shetch I'm pretty sure 'rows == 0' is the same as '!rows'. Tried it, doesn't work.

Well, !row = row is not equal to and rows == 0 means rows equal to 0.

Try removing the 'return 1;'

[Shetch]

Nevermind, I fixed it myself. Used 'mysql_query' insted of 'mysql_tquery'.