Problema Last Login

[1Shot]

Salut. Vreau sa pun cand intri pe server si trebuie sa te loghezi sa iti apara: * Last Login: data/ora *. Problema este ca nu imi apare... apare asa: * Last Login: *

Adica pur si simplu data si ora nu apar... Nu stiu ce as fi putut face gresit, mie m-i se pare ca e totul ok... Va las mai jos scriptul:

La OnPlayerDisconnect:
	// LAST LOGIN
	new y,m,d,h,mi;
	getdate(y,m,d);
	gettime(h,mi);
	new str[184];
	mysql_format(SQL,str,sizeof(str), "UPDATE users SET `lastOn`='%02d.%02d.%d - %02d:%02d' WHERE `name`='%s'",d,m,y,h,mi,PlayerInfo[playerid][pNormalName]);
	mysql_tquery(SQL,str,"","");

La OnPlayerRequestClass:
		if (gPlayerAccount[playerid] != 0)
		{
            new LastLog[64], loginstring[128];
			cache_get_field_content(playerid, "lastOn", LastLog);
			format(loginstring,sizeof(loginstring), "Welcome to Server, %s!\nPlease enter your password below.\n\n{FFFFFF}* Last Login: %s *", Player, LastLog);
			ShowPlayerDialog(playerid,DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"Account Login",loginstring,"Login","Quit");
		}

In Baza de Date (La `users`):

`lastOn` varchar(50) NOT NULL DEFAULT '01/01/1970 01:01:01',

Multumesc!

[SherKan]

ceva de genu trebuie sa faci

			new laston[32], field[128];
			format(field,sizeof(field),"SELECT `lastOn` FROM `users` WHERE `name`='%s'",GetName(playerid));
			new Cache:last = mysql_query(SQL, field);
			if(cache_num_rows() > 0) cache_get_value(0, "lastOn", laston, 32);
			cache_delete(last);

trebuie sa interoghezi baza de date si sa ceri last login, nu merge doar 

cache_get_field_content(playerid, "lastOn", LastLog);

uita-te pe net cum functioneaza functia

Edited January 30, 2019 by SherKan

[Banditul]

Singura problema la care ma pot gandi e faptul ca

cache_get_field_content(playerid, "lastOn", LastLog);

Nu se afla intr-un cache activ

new Cache: result = mysql_query("SELECT lastOn FROM users WHERE Name = 'Nume'");
cache_get_field_content(playerid, "lastOn", LastLog);
cache_delete(result);

(Evident nu tocmai exact asa dar sa fie intr-un cache activ)

mysql_tquery("SELECT lastOn FROM users WHERE Name = 'Nume'", "Functie");

Functie()
{
	cache_get_field_content(playerid, "lastOn", LastLog);
}

Acelasi lucru ca mai sus dar se executa query in alt thread si raspunsul il priemsti intr-o functie

Sguestie de cum ar trebui sa faci ar fi ceva asemanator cu

		if (gPlayerAccount[playerid] != 0)
		{
            new LastLog[64], loginstring[128];

			mysql_format(SQLHandle, loginstring, sizeof(loginstring), "SELECT lastOn FROM users WHERE Name = '%s'", Nume);
			new Cache: result = mysql_query(SQLHandle, loginstring);
			cache_get_field_content(playerid, "lastOn", LastLog);
			cache_delete(result);

			format(loginstring,sizeof(loginstring), "Welcome to Server, %s!\nPlease enter your password below.\n\n{FFFFFF}* Last Login: %s *", Player, LastLog);
			ShowPlayerDialog(playerid,DIALOG_LOGIN2,DIALOG_STYLE_PASSWORD,"Account Login",loginstring,"Login","Quit");
		}

 

[1Shot]

Am facut, multumesc.