HELP !! My money don't save MYSQL!
#3

Yes, when I make my account in-game automatically save in MySQL on 'accounts'

P.s: Thanks for fast reply!

EDIT: Here is OnAccountSave

Код:
script OnAccountSave(playerid)
{
	if(PlayerInfo[playerid][pLogged] == 0) return 1;
	new query[456], final[1028];
	format(query, sizeof(query), "UPDATE `Accounts` SET ");
	strcat(final,query);
 	format(query, sizeof(query), "`Level` = '%d',",PlayerInfo[playerid][pLevel]);
	strcat(final,query);
 	format(query, sizeof(query), "`Sex` = '%d',",PlayerInfo[playerid][pSex]);
	strcat(final,query);
 	format(query, sizeof(query), "`Skin` = '%d',",PlayerInfo[playerid][pSkin]);
	strcat(final,query);
 	format(query, sizeof(query), "`Hours` = '%d',",PlayerInfo[playerid][pHours]);
	strcat(final,query);
	format(query, sizeof(query), "`Minutes` = '%d',",PlayerInfo[playerid][pMinutes]);
	strcat(final,query);
	format(query, sizeof(query), "`Language` = '%d',",PlayerInfo[playerid][pLanguage]);
	strcat(final,query);
	format(query, sizeof(query), "`Admin` = '%d',",PlayerInfo[playerid][pAdmin]);
	strcat(final,query);
	format(query, sizeof(query), "`Helper` = '%d',",PlayerInfo[playerid][pHelper]);
	strcat(final,query);
	format(query, sizeof(query), "`Respect` = '%d',",PlayerInfo[playerid][pRespect]);
	strcat(final,query);
 	format(query, sizeof(query), "`Money` = '%d',",PlayerInfo[playerid][pMoney]);
	strcat(final,query);
	format(query, sizeof(query), "`Bank` = '%d',",PlayerInfo[playerid][pBank]);
	strcat(final,query);
 	format(query, sizeof(query), "`Age` = '%d',",PlayerInfo[playerid][pAge]);
	strcat(final,query);
	format(query, sizeof(query), "`Reports` = '%d',",PlayerInfo[playerid][pReports]);
	strcat(final,query);
	format(query, sizeof(query), "`Newbies` = '%d',",PlayerInfo[playerid][pNewbies]);
	strcat(final,query);
	format(query, sizeof(query), "`Warn` = '%d',",PlayerInfo[playerid][pWarn]);
	strcat(final,query);
	format(query, sizeof(query), "`MuteTime` = '%d',",PlayerInfo[playerid][pMuteTime]);
	strcat(final,query);
	format(query, sizeof(query), "`Mute` = '%d',",PlayerInfo[playerid][pMute]);
	strcat(final,query);
	format(query, sizeof(query), "`Banned` = '%d',",PlayerInfo[playerid][pBanned]);
	strcat(final,query);
	format(query, sizeof(query), "`BanDays` = '%d',",PlayerInfo[playerid][pBanDays]);
	strcat(final,query);
	format(query, sizeof(query), "`BannedBy` = '%s',",PlayerInfo[playerid][pBannedBy]);
	strcat(final,query);
	format(query, sizeof(query), "`MarkX` = '%f',",PlayerInfo[playerid][pMarkX]);
	strcat(final,query);
	format(query, sizeof(query), "`MarkY` = '%f',",PlayerInfo[playerid][pMarkY]);
	strcat(final,query);
	format(query, sizeof(query), "`MarkZ` = '%f',",PlayerInfo[playerid][pMarkZ]);
	strcat(final,query);
	format(query, sizeof(query), "`BannedReason` = '%s',",PlayerInfo[playerid][pBannedReason]);
	strcat(final,query);
	format(query, sizeof(query), "`Crashed` = '%d',",PlayerInfo[playerid][pCrashed]);
	strcat(final,query);
	format(query, sizeof(query), "`DrivingLicenseA` = '%d',",PlayerInfo[playerid][pDrivingLicenseA]);
	strcat(final,query);
	format(query, sizeof(query), "`DrivingLicenseB` = '%d',",PlayerInfo[playerid][pDrivingLicenseB]);
	strcat(final,query);
	format(query, sizeof(query), "`DrivingLicenseC` = '%d',",PlayerInfo[playerid][pDrivingLicenseC]);
	strcat(final,query);
	format(query, sizeof(query), "`WeaponLicense` = '%d',",PlayerInfo[playerid][pWeaponLicense]);
	strcat(final,query);
	format(query, sizeof(query), "`FlyingLicense` = '%d',",PlayerInfo[playerid][pFlyingLicense]);
	strcat(final,query);
	format(query, sizeof(query), "`NavigationLicense` = '%d',",PlayerInfo[playerid][pNavigationLicense]);
	strcat(final,query);
	format(query, sizeof(query), "`Work` = '%d',",PlayerInfo[playerid][pWork]);
	strcat(final,query);
	format(query, sizeof(query), "`AdminJailed` = '%d',",PlayerInfo[playerid][pAdminJailed]);
	strcat(final,query);
	format(query, sizeof(query), "`AdminJailedReason` = '%s',",PlayerInfo[playerid][pAdminJailedReason]);
	strcat(final,query);
	format(query, sizeof(query), "`AdminJailedMinutes` = '%d',",PlayerInfo[playerid][pAdminJailedMinutes]);
	strcat(final,query);
	format(query, sizeof(query), "`AdminJailedAdmin` = '%s',",PlayerInfo[playerid][pAdminJailedAdmin]);
	strcat(final,query);
	format(query, sizeof(query), "`AlreadyVoted` = '%s',",PlayerInfo[playerid][pAlreadyVoted]);
	strcat(final,query);
	format(query, sizeof(query), "`Tester` = '%d',",PlayerInfo[playerid][pTester]);
	strcat(final,query);
	format(query, sizeof(query), "`Recover` = '%s'",PlayerInfo[playerid][pRecover]);
	strcat(final,query);
	format(query, sizeof(query), " WHERE ID = %d", PlayerInfo[playerid][pID]);
	strcat(final,query);
	mysql_format(mysql, final, sizeof(final), "%s", final);
	mysql_query(mysql, final, false);
	return 1;
}
Reply


Messages In This Thread
HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:09
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:13
Re: HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:20
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:21
Re: HELP !! My money don't save MYSQL! - by MerryDeer - 22.09.2016, 16:21
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:23
Re: HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:33
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 16:34
Re: HELP !! My money don't save MYSQL! - by Flavv - 22.09.2016, 16:39
Re: HELP !! My money don't save MYSQL! - by Luis- - 22.09.2016, 18:14

Forum Jump:


Users browsing this thread: 1 Guest(s)