Qenz
Умник
PHP:
SaveAccount(playerid) { // Сохранение аккаунта.
if(pInfo[playerid][pLogged] == true) { // Проверка, если аккаунт авторизован.
CheckMySQLConnection(); // Проверяем, подключена ли БД.
new
query[186],
sqlname[MAX_PLAYER_NAME],
sqlpass[64];
mysql_real_escape_string(pInfo[playerid][pName], sqlname);
mysql_real_escape_string(pInfo[playerid][pPassword], sqlpass);
format(query, sizeof(query), "UPDATE `Accounts` SET `Nickname` = '%s', `Password` = '%s', `Member` = '%i', `Skin` = '%i', `Money` = '%i', `Admin` = '%i', `Job` = '%i', `JailTime` = '%i', `MuteTime` = '%i' WHERE `ID` = '%i'",
sqlname,
sqlpass,
pInfo[playerid][pMember],
pInfo[playerid][pSkin],
pInfo[playerid][pMoney],
pInfo[playerid][pAdmin],
pInfo[playerid][pJob],
pInfo[playerid][pJailTime],
pInfo[playerid][pMuteTime],
pInfo[playerid][pID]);
mysql_query(query); // Отправляем запрос
}
return 1;
}
