Siman
Умник
Ребят, крашит при OnPlayerLogin не пойму в чем дело + не сохраняются аккаунт после того как удалил пару переменных с таблицы.
и сохранение
PHP:
stock OnPlayerLogin(playerid, password[])
{
new sqlpass[32],
str[2048],
name[32];
GetPlayerName(playerid, name, 32);
mysql_real_escape_string(password, sqlpass);
format(query, sizeof(query), "SELECT * FROM `"T_ACCOUNT"` WHERE `Key` = '%s' AND `Name` = '%s'", sqlpass, name);
mysql_query(query);
mysql_store_result();
if(mysql_num_rows() == 1)
{
mysql_fetch_row_format(str, "|");
sscanf(str, "p<|>s[32]s[32]s[32]iiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiiis[50]",
PlayerInfo[playerid][pName],
PlayerInfo[playerid][pKey],
PlayerInfo[playerid][pEmail],
PlayerInfo[playerid][pDrug],
PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSkin],
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pLead],
PlayerInfo[playerid][pWarn],
PlayerInfo[playerid][pWarnFam],
PlayerInfo[playerid][pMemb],
PlayerInfo[playerid][pRank],
PlayerInfo[playerid][pBanned],
PlayerInfo[playerid][pChyot],
PlayerInfo[playerid][pOtmus],
PlayerInfo[playerid][pOtad],
PlayerInfo[playerid][pSchy],
PlayerInfo[playerid][pSchy1],
PlayerInfo[playerid][pSmus],
PlayerInfo[playerid][pSmus1],
PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pAvot],
PlayerInfo[playerid][pScar],
PlayerInfo[playerid][pScar1],
PlayerInfo[playerid][pHouse],
PlayerInfo[playerid][pCar],
PlayerInfo[playerid][pCarColor1],
PlayerInfo[playerid][pCarColor2],
PlayerInfo[playerid][pMoney],
PlayerInfo[playerid][pText],
PlayerInfo[playerid][pAdminLevel],
PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pNumber],
PlayerInfo[playerid][pNumberMny],
PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pModels]);
mysql_free_result();
sscanf(PlayerInfo[playerid][pModels], "p<,>a<i>[5]",PlayerInfo[playerid][pModel]);
return true;
}
}
PHP:
stock SaveAccount(playerid)
{
if(GetPVarInt(playerid, "Logged") == 0) return 1;
new src[1024], name[32];
GetPlayerName(playerid, name, 32);
format(query,sizeof(query),"UPDATE "T_ACCOUNT" SET ");
format(src,40,"AdminLevel=%d,",PlayerInfo[playerid][pAdminLevel]);
strcat(query,src,sizeof(query));
format(src,40,"Level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,40,"Drug=%d,",PlayerInfo[playerid][pDrug]);
strcat(query,src,sizeof(query));
format(src,40,"Sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,40,"House=%d,",PlayerInfo[playerid][pHouse]);
strcat(query,src,sizeof(query));
format(src,40,"Level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,40,"Lead=%d,",PlayerInfo[playerid][pLead]);
strcat(query,src,sizeof(query));
format(src,40,"Warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,40,"WarnFam=%d,",PlayerInfo[playerid][pWarnFam]);
strcat(query,src,sizeof(query));
format(src,40,"Memb=%d,",PlayerInfo[playerid][pMemb]);
strcat(query,src,sizeof(query));
format(src,40,"Rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,40,"Ban=%d,",PlayerInfo[playerid][pBanned]);
strcat(query,src,sizeof(query));
format(src,40,"Chyot=%d,",PlayerInfo[playerid][pChyot]);
strcat(query,src,sizeof(query));
format(src,40,"Otmus=%d,",PlayerInfo[playerid][pOtmus]);
strcat(query,src,sizeof(query));
format(src,40,"Otad=%d,",PlayerInfo[playerid][pOtad]);
strcat(query,src,sizeof(query));
format(src,40,"Schy=%d,",PlayerInfo[playerid][pSchy]);
strcat(query,src,sizeof(query));
format(src,40,"Schy1=%d,",PlayerInfo[playerid][pSchy1]);
strcat(query,src,sizeof(query));
format(src,40,"Smus=%d,",PlayerInfo[playerid][pSmus]);
strcat(query,src,sizeof(query));
format(src,40,"Smus1=%d,",PlayerInfo[playerid][pSmus1]);
strcat(query,src,sizeof(query));
format(src,40,"Job=%d,",PlayerInfo[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,40,"Avot=%d,",PlayerInfo[playerid][pAvot]);
strcat(query,src,sizeof(query));
format(src,40,"Scar=%d,",PlayerInfo[playerid][pScar]);
strcat(query,src,sizeof(query));
format(src,40,"Scar1=%d,",PlayerInfo[playerid][pScar1]);
strcat(query,src,sizeof(query));
format(src,40,"House=%d,",PlayerInfo[playerid][pHouse]);
strcat(query,src,sizeof(query));
format(src,40,"Car=%d,",PlayerInfo[playerid][pCar]);
strcat(query,src,sizeof(query));
format(src,40,"Drugs=%d,",PlayerInfo[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,40,"CarColor1=%d,",PlayerInfo[playerid][pCarColor1]);
strcat(query,src,sizeof(query));
format(src,40,"CarColor2=%d,",PlayerInfo[playerid][pCarColor2]);
strcat(query,src,sizeof(query));
format(src,40,"Reg=%d,",PlayerInfo[playerid][pReg]);
strcat(query,src,sizeof(query));
format(src,40,"Money=%d,",PlayerInfo[playerid][pMoney]);
strcat(query,src,sizeof(query));
format(src,40,"Text=%d,",PlayerInfo[playerid][pText]);
strcat(query,src,sizeof(query));
format(src,40,"Exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,40,"Skin=%d,",PlayerInfo[playerid][pSkin]);
strcat(query,src,sizeof(query));
format(src,40,"pNumber=%d,",PlayerInfo[playerid][pNumber]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pModels], 50, "%i, %i, %i, %i, %i", PlayerInfo[playerid][pModel][0],
PlayerInfo[playerid][pModel][1], PlayerInfo[playerid][pModel][2], PlayerInfo[playerid][pModel][3], PlayerInfo[playerid][pModel][4]);
format(src,40,"pModels='%s',",PlayerInfo[playerid][pModels]);
strcat(query,src,sizeof(query));
format(src,40,"pNumberMny=%d,",PlayerInfo[playerid][pNumberMny]);
strcat(query,src,sizeof(query));
format(src,40,"pBank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,40," WHERE Name='%s'",name);
strcat(query,src,sizeof(query));
mysql_query(query);
return 1;
}