Artur1996
Компетентный
Вот перевел сохранение акков на мускул но столкнулся с проблемой,сохраняет акк нормально но он не только свой аккаунт сохраняет,а все что находятся в таблице accounts. Например мой аккаунт Admin и есть еще 1 аккаунт Player если я выйду с сервера то аккаунт обновит и мой(Admin) и другой что в таблице (Player).
Вот код сохранения (ps MySQL r5):
Вот код сохранения (ps MySQL r5):
PHP:
stock SaveAccount(playerid)
{
if(gPlayerLogged[playerid] == false) return true;
new src[1024], name[32];
GetPlayerName(playerid, name, 32);
format(query,sizeof(query),"UPDATE `accounts` SET ");
format(src,40,"Level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,40,"Exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,40,"Sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,40,"PayDay=%d,",PlayerInfo[playerid][pPayDay]);
strcat(query,src,sizeof(query));
format(src,40,"Money=%d,",PlayerInfo[playerid][pMoney]);
strcat(query,src,sizeof(query));
format(src,40,"Admin=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,40,"Vrank=%d,",PlayerInfo[playerid][pVrank]);
strcat(query,src,sizeof(query));
format(src,40,"`Phousekey`=%d,",PlayerInfo[playerid][pPhousekey]);
strcat(query,src,sizeof(query));
format(src,40,"Housecash=%d,",PlayerInfo[playerid][pHousecash]);
strcat(query,src,sizeof(query));
format(src,40,"Leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,40,"Member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,40,"Rang=%d,",PlayerInfo[playerid][pRang]);
strcat(query,src,sizeof(query));
format(src,40,"MemberSkin=%d,",PlayerInfo[playerid][pMemberSkin]);
strcat(query,src,sizeof(query));
format(src,40,"Skin=%d,",PlayerInfo[playerid][pSkin]);
strcat(query,src,sizeof(query));
format(src,40,"Jobs=%d,",PlayerInfo[playerid][pJobs]);
strcat(query,src,sizeof(query));
format(src,40,"Birga=%d,",PlayerInfo[playerid][pBirga]);
strcat(query,src,sizeof(query));
format(src,40,"Car=%d,",PlayerInfo[playerid][pCar]);
strcat(query,src,sizeof(query));
format(src,40,"Color1=%d,",PlayerInfo[playerid][pColor1]);
strcat(query,src,sizeof(query));
format(src,40,"Color2=%d,",PlayerInfo[playerid][pColor2]);
strcat(query,src,sizeof(query));
format(src,40,"AZS=%d,",PlayerInfo[playerid][pAZS]);
strcat(query,src,sizeof(query));
format(src,40,"`Name`='%s'",name);
strcat(query,src,sizeof(query));
mysql_query(query);
return true;
}
