[Develerux]

Код:

new query[128];
mysql_format(Sql, query, sizeof(query), "SELECT * FROM `accounts` WHERE `username` = '%e' AND `password` = '%e' LIMIT 1", Account[playerid][ausername], MD5_Hash(Account[playerid][apassword]));
mysql_tquery(Sql, query, "OnPlayerAccountLoaded", "d", playerid);

Код:

pub:OnPlayerAccountLoaded(playerid) {
    if(cache_num_rows() == 1)
    {
	cache_get_value_int(0, "ID", Account[playerid][aID]);
	cache_get_value(0, "username", Account[playerid][ausername], 128);
	cache_get_value(0, "password", Account[playerid][apassword], 128);
	cache_get_value(0, "email", Account[playerid][aemail], 128);
	cache_get_value_int(0, "jegyezve", Account[playerid][ajegyezve]);
	cache_get_value(0, "IP", Account[playerid][IP], 16);
        CancelSelectTextDraw(playerid);
        SpawnPlayer(playerid);
        SendClientMessage(playerid,COLOR_GREEN,"Sikeresen bejelentkeztйl!");
        SendClientMessage(playerid,COLOR_GREEN,Account[playerid][aID]);
        SendClientMessage(playerid,COLOR_GREEN,Account[playerid][ausername]);
        SendClientMessage(playerid,COLOR_GREEN,Account[playerid][apassword]);
        SendClientMessage(playerid,COLOR_GREEN,Account[playerid][aemail]);
        SendClientMessage(playerid,COLOR_GREEN,Account[playerid][ajegyezve]);
        SendClientMessage(playerid,COLOR_GREEN,Account[playerid][IP]);
        LoadStats(playerid);
    } else SendClientMessage(playerid, COLOR_LIGHTRED, "Hiba: Hibбs felhasznбlуnйv vagy jelszу!");
    return 1;
}

And values not set. When I called SendClientMessage output is: ""
Sorry I have bad english skill.

[Develerux]

Bump

[Macronix]

Try this:

Код:

pub:OnPlayerAccountLoaded(playerid) {
	new str[512];
    if(cache_num_rows() == 1)
    {
	cache_get_value_int(0, "ID", Account[playerid][aID]);
	cache_get_value(0, "username", Account[playerid][ausername], 128);
	cache_get_value(0, "password", Account[playerid][apassword], 128);
	cache_get_value(0, "email", Account[playerid][aemail], 128);
	cache_get_value_int(0, "jegyezve", Account[playerid][ajegyezve]);
	cache_get_value(0, "IP", Account[playerid][IP], 16);
        CancelSelectTextDraw(playerid);
        SpawnPlayer(playerid);
        SendClientMessage(playerid,COLOR_GREEN,"Sikeresen bejelentkeztйl!");
	format(str, sizeof(str), "ID: %d | Name: %s | Password: %s | Email: %s | jegyezve: %s | IP: %s", Account[playerid][aID],Account[playerid][ausername],Account[playerid][apassword],Account[playerid][aemail],Account[playerid][ajegyezve],Account[playerid][IP]);
	SendClientMessage(playerid,COLOR_GREEN,str);
        LoadStats(playerid);
    } else SendClientMessage(playerid, COLOR_LIGHTRED, "Hiba: Hibбs felhasznбlуnйv vagy jelszу!");
    return 1;
}