- Регистрация
- 19 Окт 2019
- Сообщения
- 26
- Лучшие ответы
- 0
- Репутация
- 0
У меня есть код и он полностью рабочий.
Но стоит администратору выйти/перезайти и у него пропадает префикс. Я понял что он просто не сохраняется в БД, пытался настроить сохранение, но получилось только выгружать из БД префикс(Если в бд задать префикс и зайти на сервер, то префикс будет, а наоборот нет).
Вот всё связанное с сохранением:
PHP:
CMD:aprefix(playerid, params[])
{
new string[32];
if(PlayerInfo[playerid][pAdmin] < 13) return true;
if(PlayerInfo[params[0]][pAdmin] > PlayerInfo[playerid][pAdmin]) return SendClientMessage(playerid, 0xBFC0C2FF, "Àé-ÿé-ÿé!");
if(sscanf(params, "is[32]", params[0], params[1]))return SendClientMessage(playerid, -1, "/aprefix [id] [ïðåôèêñ]");
if(!IsPlayerConnected(params[0]))return true;
strmid(PlayerInfo[params[0]][aPrefix], params[1], 0, strlen(params[1]), 255);
SendClientMessage(playerid, -1, "Âû óñïåøíî óñòàíîâèëè èãðîêó ïðåôèêñ!");
mysql_format(connects, string, 32, "UPDATE `accounts` SET `aPrefix` = '%s' WHERE `Name` = '%s'",params[1],PlayerInfo[params[0]][pNames]);
mysql_function_query(connects, stringer, false, "", "");
return true;
}Вот всё связанное с сохранением:
PHP:
stock SaveAccounts()
{
foreach(Player,i) { if(IsPlayerConnected(i)) OnPlayerUpdateRL(i); }
}
PHP:
stock OnPlayerUpdateRL(playerid)
{
if(gPlayerLogged[playerid] == 1 && IsPlayerConnected(playerid))
{
if(saveplayer[playerid] != 0) return true;
saveplayer[playerid] = 5;
new sendername[24];
GetPlayerName(playerid,sendername,24);
new str[3148];
mysql_format(connects,str,sizeof(str),"UPDATE `"TABLE_ACCOUNT"` SET `pLevel` = '%d',`pPhousekey` = '%d',`pPbiskey` = '%d',`pPsbiskey` = '%d',`pHeadValue` = '%d',`pContract` = '%d',`pCar` = '%d',`pHelper` = '%d',`pAvig` = '%d',`prefix` = '%s',`aPrefix` = '%s'",
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pPhousekey],PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPsbiskey],
PlayerInfo[playerid][pHeadValue],PlayerInfo[playerid][pContract],
PlayerInfo[playerid][pCar][UseCar(playerid)], PlayerInfo[playerid][pHelper],PlayerInfo[playerid][pAvig],
PlayerInfo[playerid][prefix],PlayerInfo[playerid][aPrefix]);
mysql_format(connects,str,sizeof(str),"%s `pDonatemoney2` = '%d', `pDonateRank` = '%d',`pReg` = '%d',`pSex` = '%d',`pMuted` = '%d',`pExp` = '%d',`pCash` = '%d',`pKills` = '%d',`pJailed` = '%d',`pJailTime` = '%d',`pMats` = '%d',`pDrugs` = '%d',`pLeader` = '%d',`pMember` = '%d', ",str,
PlayerInfo[playerid][pDonatemoney2],
PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash],PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember]);
mysql_format(connects,str,sizeof(str),"%s `pRank` = '%d',`pJob` = '%d',`pVodPrava` = '%d',`pBizLic` = '%d',`pFlyLic` = '%d',`pBoatLic` = '%d',`pFishLic` = '%d',`pGunLic` = '%d', ",str,
PlayerInfo[playerid][pRank],PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pVodPrava],PlayerInfo[playerid][pBizLic],
PlayerInfo[playerid][pFlyLic],PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic],PlayerInfo[playerid][pGunLic]);
mysql_format(connects,str,sizeof(str),"%s `pSDPistol` = '%d',`pDesertEagle` = '%d',`pShotGun` = '%d',`pMP5` = '%d',`pAK47` = '%d',`pM4` = '%d',`pChar` = '%d',`pModel` = '%d', `pInGameDay` = '%i', `pInGameAFK` = '%i', `pLastDate` = '%i', ",str,
PlayerInfo[playerid][pSDPistol],
PlayerInfo[playerid][pDesertEagle],PlayerInfo[playerid][pShotGun],
PlayerInfo[playerid][pMP5],PlayerInfo[playerid][pAK47],
PlayerInfo[playerid][pM4],PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pModel],PlayerInfo[playerid][pInGameDay],PlayerInfo[playerid][pInGameAFK],getdate());
//
mysql_format(connects,str,sizeof(str),"%s `pSaveGun` = '%i', `pRealMoney` = '%i', `pVig` = '%i', `lockautoinvite` = %i, `pHousekey2` = %i, ",str,
PlayerInfo[playerid][pSaveGun],PlayerInfo[playerid][pRealMoney],PlayerInfo[playerid][pVig],lock_auto_invite[playerid],PlayerInfo[playerid][pHousekey2]);
mysql_format(connects,str,sizeof(str),"%s `pSaveGunID` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', ",str,
GunInfo[playerid][pWeapon][0],GunInfo[playerid][pWeapon][1],GunInfo[playerid][pWeapon][2],
GunInfo[playerid][pWeapon][3],GunInfo[playerid][pWeapon][4],GunInfo[playerid][pWeapon][5],
GunInfo[playerid][pWeapon][6],GunInfo[playerid][pWeapon][7],GunInfo[playerid][pWeapon][8],
GunInfo[playerid][pWeapon][9],GunInfo[playerid][pWeapon][10],GunInfo[playerid][pWeapon][11],
GunInfo[playerid][pWeapon][12]);
mysql_format(connects,str,sizeof(str),"%s `pSaveGunAmmo` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', ",str,
GunInfo[playerid][pAmmo][0],GunInfo[playerid][pAmmo][1],GunInfo[playerid][pAmmo][2],
GunInfo[playerid][pAmmo][3],GunInfo[playerid][pAmmo][4],GunInfo[playerid][pAmmo][5],
GunInfo[playerid][pAmmo][6],GunInfo[playerid][pAmmo][7],GunInfo[playerid][pAmmo][8],
GunInfo[playerid][pAmmo][9],GunInfo[playerid][pAmmo][10],GunInfo[playerid][pAmmo][11],
GunInfo[playerid][pAmmo][12]);
//
mysql_format(connects,str,sizeof(str),"%s `pPnumber` = '%d',`pPayDayHad` = '%d',`pWarns` = '%d',`punWarns` = '%d',`punWarnstime` = '%d',`pFuel` = '%d',`pRobTime` = '%d',`pExitTied` = '%d',`pExitTiedNomer` = '%d',`pGrabSkill` = '%d',`pGrabTime` = '%d',`pReportTime` = '%d',`pVerevka` = '%d',`pOtmbI4ka` = '%d',`pAutoTime` = '%d', ",str,
PlayerInfo[playerid][pPnumber],PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pWarns],PlayerInfo[playerid][punWarns],
PlayerInfo[playerid][punWarnstime],PlayerInfo[playerid][pFuel],
PlayerInfo[playerid][pRobTime],PlayerInfo[playerid][pExitTied],
PlayerInfo[playerid][pExitTiedNomer],PlayerInfo[playerid][pGrabSkill],
PlayerInfo[playerid][pGrabTime],PlayerInfo[playerid][pReportTime],
PlayerInfo[playerid][pVerevka],
PlayerInfo[playerid][pOtmbI4ka],PlayerInfo[playerid][pAutoTime]);
mysql_format(connects,str,sizeof(str),"%s `pAutoSkill` = '%d',`pMarried` = '%d',`pMuteTime` = '%d',`pMobile` = '%d',`pBank` = '%d',`pLocked2` = '%d',`pBoxSkill` = '%d',`pKongfuSkill` = '%d',`pKickboxSkill` = '%d',`pFightSkill` = '%d',`pFightSkil` = '%d',`pFightTime` = '%d',`pHospital` = '%d',`pIzol` = '%d',`pDostup` = '%d',`pZakonp` = '%d', ",str,
PlayerInfo[playerid][pAutoSkill],PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMuteTime],PlayerInfo[playerid][pMobile],
PlayerInfo[playerid][pBank],PlayerInfo[playerid][pLocked2],
PlayerInfo[playerid][pBoxSkill],PlayerInfo[playerid][pKongfuSkill],
PlayerInfo[playerid][pKickboxSkill],PlayerInfo[playerid][pFightSkill],
PlayerInfo[playerid][pFightSkil],PlayerInfo[playerid][pFightTime],
PlayerInfo[playerid][pHospital],PlayerInfo[playerid][pIzol],
PlayerInfo[playerid][pDostup],PlayerInfo[playerid][pZakonp]);
//
mysql_format(connects,str,sizeof(str),"%s `pCar` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pProz` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pFuelcar` = '%f,%f,%f,%f,%f,%f,%f,%f,%f,%f', ", str,
PlayerInfo[playerid][pCar][0], PlayerInfo[playerid][pCar][1], PlayerInfo[playerid][pCar][2], PlayerInfo[playerid][pCar][3], PlayerInfo[playerid][pCar][4], PlayerInfo[playerid][pCar][5], PlayerInfo[playerid][pCar][6], PlayerInfo[playerid][pCar][7], PlayerInfo[playerid][pCar][8], PlayerInfo[playerid][pCar][9],
PlayerInfo[playerid][pProz][0], PlayerInfo[playerid][pProz][1], PlayerInfo[playerid][pProz][2], PlayerInfo[playerid][pProz][3], PlayerInfo[playerid][pProz][4], PlayerInfo[playerid][pProz][5], PlayerInfo[playerid][pProz][6], PlayerInfo[playerid][pProz][7], PlayerInfo[playerid][pProz][8], PlayerInfo[playerid][pProz][9],
PlayerInfo[playerid][pFuelcar][0], PlayerInfo[playerid][pFuelcar][1], PlayerInfo[playerid][pFuelcar][2], PlayerInfo[playerid][pFuelcar][3], PlayerInfo[playerid][pFuelcar][4], PlayerInfo[playerid][pFuelcar][5], PlayerInfo[playerid][pFuelcar][6], PlayerInfo[playerid][pFuelcar][7], PlayerInfo[playerid][pFuelcar][8], PlayerInfo[playerid][pFuelcar][9]);
mysql_format(connects,str,sizeof(str),"%s `pPokraska` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pSpoiler` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pHood` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', ", str,
PlayerInfo[playerid][pPokraska][0], PlayerInfo[playerid][pPokraska][1], PlayerInfo[playerid][pPokraska][2], PlayerInfo[playerid][pPokraska][3], PlayerInfo[playerid][pPokraska][4], PlayerInfo[playerid][pPokraska][5], PlayerInfo[playerid][pPokraska][6], PlayerInfo[playerid][pPokraska][7], PlayerInfo[playerid][pPokraska][8], PlayerInfo[playerid][pPokraska][9],
PlayerInfo[playerid][pSpoiler][0], PlayerInfo[playerid][pSpoiler][1], PlayerInfo[playerid][pSpoiler][2], PlayerInfo[playerid][pSpoiler][3], PlayerInfo[playerid][pSpoiler][4], PlayerInfo[playerid][pSpoiler][5], PlayerInfo[playerid][pSpoiler][6], PlayerInfo[playerid][pSpoiler][7], PlayerInfo[playerid][pSpoiler][8], PlayerInfo[playerid][pSpoiler][9],
PlayerInfo[playerid][pHood][0], PlayerInfo[playerid][pHood][1], PlayerInfo[playerid][pHood][2], PlayerInfo[playerid][pHood][3], PlayerInfo[playerid][pHood][4], PlayerInfo[playerid][pHood][5], PlayerInfo[playerid][pHood][6], PlayerInfo[playerid][pHood][7], PlayerInfo[playerid][pHood][8], PlayerInfo[playerid][pHood][9]);
mysql_format(connects,str,sizeof(str),"%s `pVcol1` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pVcol2` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pKolesocar` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', ", str,
PlayerInfo[playerid][pVcol1][0], PlayerInfo[playerid][pVcol1][1], PlayerInfo[playerid][pVcol1][2], PlayerInfo[playerid][pVcol1][3], PlayerInfo[playerid][pVcol1][4], PlayerInfo[playerid][pVcol1][5], PlayerInfo[playerid][pVcol1][6], PlayerInfo[playerid][pVcol1][7], PlayerInfo[playerid][pVcol1][8], PlayerInfo[playerid][pVcol1][9],
PlayerInfo[playerid][pVcol2][0], PlayerInfo[playerid][pVcol2][1], PlayerInfo[playerid][pVcol2][2], PlayerInfo[playerid][pVcol2][3], PlayerInfo[playerid][pVcol2][4], PlayerInfo[playerid][pVcol2][5], PlayerInfo[playerid][pVcol2][6], PlayerInfo[playerid][pVcol2][7], PlayerInfo[playerid][pVcol2][8], PlayerInfo[playerid][pVcol2][9],
PlayerInfo[playerid][pKolesocar][0], PlayerInfo[playerid][pKolesocar][1], PlayerInfo[playerid][pKolesocar][2], PlayerInfo[playerid][pKolesocar][3], PlayerInfo[playerid][pKolesocar][4], PlayerInfo[playerid][pKolesocar][5], PlayerInfo[playerid][pKolesocar][6], PlayerInfo[playerid][pKolesocar][7], PlayerInfo[playerid][pKolesocar][8], PlayerInfo[playerid][pKolesocar][9]);
mysql_format(connects,str,sizeof(str),"%s `pExhaust` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pLamps` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pSideskirt` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', ", str,
PlayerInfo[playerid][pExhaust][0], PlayerInfo[playerid][pExhaust][1], PlayerInfo[playerid][pExhaust][2], PlayerInfo[playerid][pExhaust][3], PlayerInfo[playerid][pExhaust][4], PlayerInfo[playerid][pExhaust][5], PlayerInfo[playerid][pExhaust][6], PlayerInfo[playerid][pExhaust][7], PlayerInfo[playerid][pExhaust][8], PlayerInfo[playerid][pExhaust][9],
PlayerInfo[playerid][pLamps][0], PlayerInfo[playerid][pLamps][1], PlayerInfo[playerid][pLamps][2], PlayerInfo[playerid][pLamps][3], PlayerInfo[playerid][pLamps][4], PlayerInfo[playerid][pLamps][5], PlayerInfo[playerid][pLamps][6], PlayerInfo[playerid][pLamps][7], PlayerInfo[playerid][pLamps][8], PlayerInfo[playerid][pLamps][9],
PlayerInfo[playerid][pSideskirt][0], PlayerInfo[playerid][pSideskirt][1], PlayerInfo[playerid][pSideskirt][2], PlayerInfo[playerid][pSideskirt][3], PlayerInfo[playerid][pSideskirt][4], PlayerInfo[playerid][pSideskirt][5], PlayerInfo[playerid][pSideskirt][6], PlayerInfo[playerid][pSideskirt][7], PlayerInfo[playerid][pSideskirt][8], PlayerInfo[playerid][pSideskirt][9]);
mysql_format(connects,str,sizeof(str),"%s `pVozdyx` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pBamper1` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pBamper2` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', ", str,
PlayerInfo[playerid][pVozdyx][0], PlayerInfo[playerid][pVozdyx][1], PlayerInfo[playerid][pVozdyx][2], PlayerInfo[playerid][pVozdyx][3], PlayerInfo[playerid][pVozdyx][4], PlayerInfo[playerid][pVozdyx][5], PlayerInfo[playerid][pVozdyx][6], PlayerInfo[playerid][pVozdyx][7], PlayerInfo[playerid][pVozdyx][8], PlayerInfo[playerid][pVozdyx][9],
PlayerInfo[playerid][pBamper1][0], PlayerInfo[playerid][pBamper1][1], PlayerInfo[playerid][pBamper1][2], PlayerInfo[playerid][pBamper1][3], PlayerInfo[playerid][pBamper1][4], PlayerInfo[playerid][pBamper1][5], PlayerInfo[playerid][pBamper1][6], PlayerInfo[playerid][pBamper1][7], PlayerInfo[playerid][pBamper1][8], PlayerInfo[playerid][pBamper1][9],
PlayerInfo[playerid][pBamper2][0], PlayerInfo[playerid][pBamper2][1], PlayerInfo[playerid][pBamper2][2], PlayerInfo[playerid][pBamper2][3], PlayerInfo[playerid][pBamper2][4], PlayerInfo[playerid][pBamper2][5], PlayerInfo[playerid][pBamper2][6], PlayerInfo[playerid][pBamper2][7], PlayerInfo[playerid][pBamper2][8], PlayerInfo[playerid][pBamper2][9]);
mysql_format(connects,str,sizeof(str),"%s `pNitro` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `pBamper1` = '%i,%i,%i,%i,%i,%i,%i,%i,%i,%i', `use_car` = %i, ", str,
PlayerInfo[playerid][pNitro][0], PlayerInfo[playerid][pNitro][1], PlayerInfo[playerid][pNitro][2], PlayerInfo[playerid][pNitro][3], PlayerInfo[playerid][pNitro][4], PlayerInfo[playerid][pNitro][5], PlayerInfo[playerid][pNitro][6], PlayerInfo[playerid][pNitro][7], PlayerInfo[playerid][pNitro][8], PlayerInfo[playerid][pNitro][9],
PlayerInfo[playerid][pGidra][0], PlayerInfo[playerid][pGidra][1], PlayerInfo[playerid][pGidra][2], PlayerInfo[playerid][pGidra][3],PlayerInfo[playerid][pGidra][4],PlayerInfo[playerid][pGidra][5],PlayerInfo[playerid][pGidra][6],PlayerInfo[playerid][pGidra][7],PlayerInfo[playerid][pGidra][8],PlayerInfo[playerid][pGidra][9],use_car[playerid]);
//
mysql_format(connects,str,sizeof(str),"%s `pBanTime1` = '%d',`pBanData1` = '%d',`pHouse` = '%d',`pBanKol` = '%d',`pNarcoLomka` = '%d',`pKolesocar` = '%d',`pPokraska` = '%d',`pSpoiler` = '%d',`pHood` = '%d',`pExhaust` = '%d',`pLamps` = '%d',`pSideskirt` = '%d',`pVozdyx` = '%d',`pVcol1` = '%d',`pVcol2` = '%d',`pBamper1` = '%d',`pBamper2` = '%d', ",str,
PlayerInfo[playerid][pBanTime1],PlayerInfo[playerid][pBanData1],
PlayerInfo[playerid][pHouse], PlayerInfo[playerid][pBanKol],
PlayerInfo[playerid][pNarcoLomka],
PlayerInfo[playerid][pKolesocar][UseCar(playerid)],PlayerInfo[playerid][pPokraska][UseCar(playerid)],
PlayerInfo[playerid][pSpoiler][UseCar(playerid)],PlayerInfo[playerid][pHood][UseCar(playerid)],
PlayerInfo[playerid][pExhaust][UseCar(playerid)],PlayerInfo[playerid][pLamps][UseCar(playerid)],
PlayerInfo[playerid][pSideskirt][UseCar(playerid)],PlayerInfo[playerid][pVozdyx][UseCar(playerid)],
PlayerInfo[playerid][pVcol1][UseCar(playerid)],PlayerInfo[playerid][pVcol2][UseCar(playerid)],
PlayerInfo[playerid][pBamper1][UseCar(playerid)],PlayerInfo[playerid][pBamper2][UseCar(playerid)]);
mysql_format(connects,str,sizeof(str),"%s `pShapka` = '%d', `pOchki` = '%d', `pCorShapka` = '%s', `pCorOchki` = '%s', `pMarriedName` = '%s', `pBonus` = '%d', `pHealing` = '%d',", str,
PlayerInfo[playerid][pShapka],PlayerInfo[playerid][pOchki],PlayerInfo[playerid][pCorShapka],PlayerInfo[playerid][pCorOchki],PlayerInfo[playerid][pMarriedName],PlayerInfo[playerid][pBonus],PlayerInfo[playerid][pHealing]);
mysql_format(connects,str,sizeof(str),"%s `pNitro` = '%d',`pGidra` = '%d',`pMestoJail` = '%d',`pWanted` = '%d',`pHousecash` = '%d',`pTut` = '%d',`pNumbercar` = '%s',`pIpReg` = '%s',`pPM` = '%d',`pVveh` = '%d', `pStraf` = '%d', `pMakeleader` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pNitro][UseCar(playerid)],PlayerInfo[playerid][pGidra][UseCar(playerid)],
PlayerInfo[playerid][pMestoJail],PlayerInfo[playerid][pWanted],
PlayerInfo[playerid][pHousecash],PlayerInfo[playerid][pTut],
PlayerInfo[playerid][pNumbercar],PlayerInfo[playerid][pIpReg],
PlayerInfo[playerid][pPM],PlayerInfo[playerid][pVveh],PlayerInfo[playerid][pStraf],PlayerInfo[playerid][pMakeleader],sendername);
mysql_function_query(connects, str, false, "", "");
printf("Àêêàóíò %s áûë óñïåøíî ñîõðàí¸í.(%d)",PlayerInfo[playerid][pNames],strlen(str));
if(strlen(str) > 3048) printf("[Îøèáêà]: Àêêàóíò %s - %d [ÍÅ ÁÛË ÑÎÕÐÀͨÍ]",PlayerInfo[playerid][pNames],strlen(str));
}
else printf("Îøèáêà ñîõðàí¸íèÿ.");
return 1;
}