[viveka27]

MySQL Log:

Код:

[15:14:19] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[15:14:19] [WARNING] cache_get_data - no active cache
[15:14:19] [WARNING] cache_get_field_content - no active cache
[15:14:19] [ERROR] mysql_tquery - callback parameter count does not match format specifier length
[15:14:19] [WARNING] cache_get_data - no active cache

Code:

Код:

stock CheckAccount(playerid)
{
    new query[82];

 	format(query, sizeof(query), "SELECT * FROM `accounts` WHERE `Username` = '%s'", PlayerName(playerid));
	mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
	SendClientMessage(playerid, WHITE, "[DEBUG]: Mau #2");
	return 1;
}
public OnAccountCheck(playerid)
{
	SendClientMessage(playerid, WHITE, "[DEBUG]: Mau #3");
    new string[125];
	if(playerid != INVALID_PLAYER_ID) {

		new rows, fields;
		cache_get_data(rows, fields, handle);
		  if(rows) {
			cache_get_row(0,2,PlayerInfo[playerid][pKey],handle, 128);
			format(string, sizeof(string), "Selamat Datang Kembali Di %s, %s.", SERVER_NAME, PlayerName(playerid));
			SendClientMessage(playerid, GREY, string);
            SendClientMessage(playerid, WHITE, "[DEBUG]: Show Dialog Login");
			SendClientMessage(playerid, WHITE, "That name is currently registered, please log into your account.");
			ShowMainMenuDialog(playerid, 1);
		}
		else {
			format(string, sizeof(string), "Selamat Datang Di %s, %s.", SERVER_NAME, PlayerName(playerid));
			SendClientMessage(playerid, GREY, string);
            SendClientMessage(playerid, WHITE, "[DEBUG]: Show Dialog Register");
			SendClientMessage(playerid, WHITE, "That name is currently not registered.");
			SendClientMessage(playerid, WHITE, "If you wish to register, please input your password in the box below.");
			ShowMainMenuDialog(playerid, 2);
		}
	}
	return 1;
}

I Always Enter Wrong Password.I Can't Login.So cache_get_data and cache_get_row no working.Anyone please help me.Sorry for bad english.Thank You.

[Misiur]

Weird, are you sure your a_mysql.inc is updated to latest version?

If yes, try this:

pawn Код:

//Change
mysql_function_query(handle, query, true, "OnAccountCheck", "d", playerid);
//to
mysql_tquery(handle, query, "OnAccountCheck", "d", playerid);

[viveka27]

Still Same

Quote:

[18:51:27] [WARNING] cache_get_row_count - no active cache [18:51:49] [ERROR] mysql_tquery - callback parameter count does not match format specifier length [18:51:49] [WARNING] cache_get_row_count - no active cache [18:51:49] [WARNING] cache_get_field_content - no active cache [18:51:53] [ERROR] mysql_tquery - callback parameter count does not match format specifier length [18:51:53] [WARNING] cache_get_row_count - no active cache [18:51:53] [WARNING] cache_get_field_content - no active cache [18:51:53] [ERROR] mysql_tquery - callback parameter count does not match format specifier length [18:51:53] [WARNING] cache_get_row_count - no active cache

[x96664]

Why you don't increase the size of query and string ?
new query[82]; to new query[128]; or even bigger.

[viveka27]

I Have Set Query To 128 And 250 But Still Same