Cerere tutorial selectarea din baza de date.

[HiImCristi]

Salutare,am incercat multe metode dar totusi nu imi iese,as vrea ca atunci cand un player se conecteaza sa ii arata zilele care ii raman ca donator si am incercat asa dar imi arata 0/0/0 in baza de date merge perfect imi arata ziua,luna si anul din acel tabel...daca cineva stie cum l-as putea face as ramane recunoscator!

        if (PlayerData[playerid][pDonateRank] == 1)
        {
            format(string, sizeof(string), "* Ai activ Donate Rank Tip Bronze Donate (BD) pana pe data de %d /%d/%d .",PlayerData[playerid][pDonateZi] PlayerData[playerid][pDonateLuna], PlayerData[playerid][pDonateAn]);
            SendClientMessage(playerid, 0xFFFFCCFF,string);
        }

Edited March 3, 2016 by HiImCristi

[BuNiCu-RP]

new query[128];
new rows, fields;
forward OnPlayerDataLoaded(playerid);

#define pDonateZix 								"" // Nume field in baza de date (DonateZi)
#define pDonateLunax							"" // Nume field in baza de date (DonateLuna)
#define pDonateAnx								"" // Nume field in baza de date (DonateAn)

public OnPlayerConnect(playerid)
{
	new pname[MAX_PLAYER_NAME];
	GetPlayerName(playerid, pname, MAX_PLAYER_NAME);
	mysql_format(MySQL, query, sizeof(query), "SELECT * FROM `players` WHERE `Name` = '%e' LIMIT 1", pname);
	mysql_pquery(MySQL, query, "OnPlayerDataLoaded", "d", playerid);
	return 1;
}

public OnPlayerSpawn(playerid)
{
	new string[504]; // Large string !
	if (PlayerData[playerid][pDonateRank] == 1)
  {
    format(string, sizeof(string), "* Ai activ Donate Rank Tip Bronze Donate (BD) pana pe data de %d /%d/%d .", PlayerData[playerid][pDonateZi], PlayerData[playerid][pDonateLuna], PlayerData[playerid][pDonateAn]);
    SendClientMessage(playerid, 0xFFFFCCFF,string);
  }
	return 1;
}

public OnPlayerDataLoaded(playerid)
{
	cache_get_data(rows, fields);
	if(rows)
	{
		PlayerData[playerid][pDonateZi] = cache_get_row_int(0, pDonateZix);
		PlayerData[playerid][pDonateLuna] = cache_get_row_int(0, pDonateLunax);
		PlayerData[playerid][pDonateAn] = cache_get_row_int(0, pDonateAnx);
	}
	return 1;
}

Uite, sper sa te ajute !

[HiImCristi]

Ms,am rezolvat +1!