MySQL HELP
#1

Hey Members,

I need ur small help regarding my code


my code
Код:
	mysql_format(database,query,sizeof(query),"SELECT * FROM Accounts WHERE Nick = '%e'",escpname(playerid));
    mysql_tquery(database,query,"OnAccountDataLoad","i","playerid");
forward public OnAccountDataLoad(playerid);
public OnAccountDataLoad(playerid)
{
    new rows,fields;
	cache_get_data(rows,fields,database);
    if(rows)
    {
		cache_get_field_content(0,"RegisterDate",PlayerInfo[playerid][RegisterDate],database, 40);
		cache_get_field_content(0,"LastOn",PlayerInfo[playerid][LastOn],database, 30);

		PlayerInfo[playerid][Level] = cache_get_field_content_int(0,"Admin");
		PlayerInfo[playerid][Helper] = cache_get_field_content_int(0,"Helper");
		PlayerInfo[playerid][dRank] = cache_get_field_content_int(0,"Donor");
		PlayerInfo[playerid][Kills] = cache_get_field_content_int(0,"Kills");
		PlayerInfo[playerid][Deaths] = cache_get_field_content_int(0,"Deaths");
		PlayerInfo[playerid][Score] = cache_get_field_content_int(0,"Score");
		PlayerInfo[playerid][Money] = cache_get_field_content_int(0,"Money");
    }
    return 1;
}
It saving and updating perfectly but not getting the data. in log i can't see anything wrong.

in log it show it load but that stats isn't giving to and it set his stat reset.
Reply


Messages In This Thread
MySQL HELP - by HydraHumza - 28.10.2015, 14:19
Re: MySQL HELP - by Dokins - 28.10.2015, 14:24
Re: MySQL HELP - by HydraHumza - 29.10.2015, 09:02
Re: MySQL HELP - by itsCody - 29.10.2015, 09:26
Re: MySQL HELP - by HydraHumza - 29.10.2015, 09:46
Re: MySQL HELP - by itsCody - 29.10.2015, 09:59
Re: MySQL HELP - by jlalt - 29.10.2015, 10:01

Forum Jump:


Users browsing this thread: 3 Guest(s)