SA-MP Forums Archive
In Mysql save... - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: In Mysql save... (/showthread.php?tid=114159)


In Mysql save... - lolmaster - 17.12.2009

Hi,

i will save PlayerInfo[playerid][pDrugs]
in MYSQL.

This is my Code to save & login.

Login:
Код:
LoginPlayer(playerid,pass[])
{
  new
		pName[MAX_PLAYER_NAME],
		query[256];

	GetPlayerName(playerid,pName,sizeof(pName));
	MySQLCheck();

	mysql_real_escape_string(pName,pName);
	mysql_real_escape_string(pass,pass);
	format(query,sizeof(query),"SELECT Money FROM `"TABLENAME"` WHERE Username = '%s' AND Password = md5('%s') LIMIT 1",pName,pass);
	mysql_query(query,LOGIN_THREAD_ID);
	LOGIN_PLAYER_ID = playerid;
	return 1;
}

And Save on Disconecct

Код:
public OnPlayerDisconnect(playerid,reason)
{
	if(pLogtimer[playerid] != 0) KillTimer(pLogtimer[playerid]);
	new
		query[300],
		pName[MAX_PLAYER_NAME];
		
	GetPlayerName(playerid,pName,sizeof(pName));
		
	if(LoggedIn[playerid])
	{
	  new Float:arm;
	  GetPlayerArmour(playerid,arm);
		format(query,sizeof(query),"UPDATE `"TABLENAME"` SET `Money`='%d'WHERE (`Username` = '%s')",GetPlayerMoney(playerid),pName);
		mysql_query(query);
	}
	return 1;
}
I will save my stats in on line .

an example:

savemysql_stats(FIELDNAME,PlayerInfo[playerid][pDrugs];
savemysql_stats(FIELDNAME,PlayerInfo[playerid][pMoney];

And on login:

loadmysql_stats(FIELD,Name,PlayerInfo[playerid][pMoney];
loadmysql_stats(FIELD,Name,PlayerInfo[playerid][pDrugs];
should somehow be so.
I would be very grateful for that.

Re: In Mysql save... - lolmaster - 18.12.2009

please help