Andrik851
30.01.2019, 15:51
Помогите пожалуйста уже сломал себе всю голову не сохраняется тюнинг
сток тюнинга
stock SaveVehicleTuning(playerid)
{
new i1 = PlayerInfo[playerid][cCarId][0];
new i2 = PlayerInfo[playerid][cCarId][1];
new i3 = PlayerInfo[playerid][cCarId][2];
PlayerInfo[playerid][cVehcoms1][0]=GetVehicleComponentInSlot(i1, CARMODTYPE_SPOILER);
PlayerInfo[playerid][cVehcoms1][1]=GetVehicleComponentInSlot(i1, CARMODTYPE_HOOD);
PlayerInfo[playerid][cVehcoms1][2]=GetVehicleComponentInSlot(i1, CARMODTYPE_ROOF);
PlayerInfo[playerid][cVehcoms1][3]=GetVehicleComponentInSlot(i1, CARMODTYPE_SIDESKIRT);
PlayerInfo[playerid][cVehcoms1][4]=GetVehicleComponentInSlot(i1, CARMODTYPE_LAMPS);
PlayerInfo[playerid][cVehcoms1][5]=GetVehicleComponentInSlot(i1, CARMODTYPE_NITRO);
PlayerInfo[playerid][cVehcoms1][6]=GetVehicleComponentInSlot(i1, CARMODTYPE_EXHAUST);
PlayerInfo[playerid][cVehcoms1][7]=GetVehicleComponentInSlot(i1, CARMODTYPE_WHEELS);
PlayerInfo[playerid][cVehcoms1][8]=GetVehicleComponentInSlot(i1, CARMODTYPE_STEREO);
PlayerInfo[playerid][cVehcoms1][9]=GetVehicleComponentInSlot(i1, CARMODTYPE_HYDRAULICS);
PlayerInfo[playerid][cVehcoms1][10]=GetVehicleComponentInSlot(i1, CARMODTYPE_FRONT_BUMPER);
PlayerInfo[playerid][cVehcoms1][11]=GetVehicleComponentInSlot(i1, CARMODTYPE_REAR_BUMPER);
PlayerInfo[playerid][cVehcoms1][12]=GetVehicleComponentInSlot(i1, CARMODTYPE_VENT_RIGHT);
PlayerInfo[playerid][cVehcoms1][13]=GetVehicleComponentInSlot(i1, CARMODTYPE_VENT_LEFT);
format(PlayerInfo[playerid][cVehcom1], 64, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][cVehcoms1][0],PlayerInfo[playerid][cVehcoms1][1],PlayerInfo[playerid][cVehcoms1][2],
PlayerInfo[playerid][cVehcoms1][3],PlayerInfo[playerid][cVehcoms1][4],PlayerInfo[playerid][cVehcoms1][5],
PlayerInfo[playerid][cVehcoms1][6],PlayerInfo[playerid][cVehcoms1][7],PlayerInfo[playerid][cVehcoms1][8],
PlayerInfo[playerid][cVehcoms1][9],PlayerInfo[playerid][cVehcoms1][10],PlayerInfo[playerid][cVehcoms1][11],
PlayerInfo[playerid][cVehcoms1][12],PlayerInfo[playerid][cVehcoms1][13]);
PlayerInfo[playerid][cVehcoms2][0]=GetVehicleComponentInSlot(i2, CARMODTYPE_SPOILER);
PlayerInfo[playerid][cVehcoms2][1]=GetVehicleComponentInSlot(i2, CARMODTYPE_HOOD);
PlayerInfo[playerid][cVehcoms2][2]=GetVehicleComponentInSlot(i2, CARMODTYPE_ROOF);
PlayerInfo[playerid][cVehcoms2][3]=GetVehicleComponentInSlot(i2, CARMODTYPE_SIDESKIRT);
PlayerInfo[playerid][cVehcoms2][4]=GetVehicleComponentInSlot(i2, CARMODTYPE_LAMPS);
PlayerInfo[playerid][cVehcoms2][5]=GetVehicleComponentInSlot(i2, CARMODTYPE_NITRO);
PlayerInfo[playerid][cVehcoms2][6]=GetVehicleComponentInSlot(i2, CARMODTYPE_EXHAUST);
PlayerInfo[playerid][cVehcoms2][7]=GetVehicleComponentInSlot(i2, CARMODTYPE_WHEELS);
PlayerInfo[playerid][cVehcoms2][8]=GetVehicleComponentInSlot(i2, CARMODTYPE_STEREO);
PlayerInfo[playerid][cVehcoms2][9]=GetVehicleComponentInSlot(i2, CARMODTYPE_HYDRAULICS);
PlayerInfo[playerid][cVehcoms2][10]=GetVehicleComponentInSlot(i2, CARMODTYPE_FRONT_BUMPER);
PlayerInfo[playerid][cVehcoms2][11]=GetVehicleComponentInSlot(i2, CARMODTYPE_REAR_BUMPER);
PlayerInfo[playerid][cVehcoms2][12]=GetVehicleComponentInSlot(i2, CARMODTYPE_VENT_RIGHT);
PlayerInfo[playerid][cVehcoms2][13]=GetVehicleComponentInSlot(i2, CARMODTYPE_VENT_LEFT);
format(PlayerInfo[playerid][cVehcom2], 64, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][cVehcoms2][0],PlayerInfo[playerid][cVehcoms2][1],PlayerInfo[playerid][cVehcoms2][2],
PlayerInfo[playerid][cVehcoms2][3],PlayerInfo[playerid][cVehcoms2][4],PlayerInfo[playerid][cVehcoms2][5],
PlayerInfo[playerid][cVehcoms2][6],PlayerInfo[playerid][cVehcoms2][7],PlayerInfo[playerid][cVehcoms2][8],
PlayerInfo[playerid][cVehcoms2][9],PlayerInfo[playerid][cVehcoms2][10],PlayerInfo[playerid][cVehcoms2][11],
PlayerInfo[playerid][cVehcoms2][12],PlayerInfo[playerid][cVehcoms2][13]);
PlayerInfo[playerid][cVehcoms3][0]=GetVehicleComponentInSlot(i3, CARMODTYPE_SPOILER);
PlayerInfo[playerid][cVehcoms3][1]=GetVehicleComponentInSlot(i3, CARMODTYPE_HOOD);
PlayerInfo[playerid][cVehcoms3][2]=GetVehicleComponentInSlot(i3, CARMODTYPE_ROOF);
PlayerInfo[playerid][cVehcoms3][3]=GetVehicleComponentInSlot(i3, CARMODTYPE_SIDESKIRT);
PlayerInfo[playerid][cVehcoms3][4]=GetVehicleComponentInSlot(i3, CARMODTYPE_LAMPS);
PlayerInfo[playerid][cVehcoms3][5]=GetVehicleComponentInSlot(i3, CARMODTYPE_NITRO);
PlayerInfo[playerid][cVehcoms3][6]=GetVehicleComponentInSlot(i3, CARMODTYPE_EXHAUST);
PlayerInfo[playerid][cVehcoms3][7]=GetVehicleComponentInSlot(i3, CARMODTYPE_WHEELS);
PlayerInfo[playerid][cVehcoms3][8]=GetVehicleComponentInSlot(i3, CARMODTYPE_STEREO);
PlayerInfo[playerid][cVehcoms3][9]=GetVehicleComponentInSlot(i3, CARMODTYPE_HYDRAULICS);
PlayerInfo[playerid][cVehcoms3][10]=GetVehicleComponentInSlot(i3, CARMODTYPE_FRONT_BUMPER);
PlayerInfo[playerid][cVehcoms3][11]=GetVehicleComponentInSlot(i3, CARMODTYPE_REAR_BUMPER);
PlayerInfo[playerid][cVehcoms3][12]=GetVehicleComponentInSlot(i3, CARMODTYPE_VENT_RIGHT);
PlayerInfo[playerid][cVehcoms3][13]=GetVehicleComponentInSlot(i3, CARMODTYPE_VENT_LEFT);
format(PlayerInfo[playerid][cVehcom3], 64, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][cVehcoms3][0],PlayerInfo[playerid][cVehcoms3][1],PlayerInfo[playerid][cVehcoms3][2],
PlayerInfo[playerid][cVehcoms3][3],PlayerInfo[playerid][cVehcoms3][4],PlayerInfo[playerid][cVehcoms3][5],
PlayerInfo[playerid][cVehcoms3][6],PlayerInfo[playerid][cVehcoms3][7],PlayerInfo[playerid][cVehcoms3][8],
PlayerInfo[playerid][cVehcoms3][9],PlayerInfo[playerid][cVehcoms3][10],PlayerInfo[playerid][cVehcoms3][11],
PlayerInfo[playerid][cVehcoms3][12],PlayerInfo[playerid][cVehcoms3][13]);
}
сток сохранения аккаунта
stock SaveAccount(playerid)
{
if(PlayerLogged[playerid] == 0) return true;
new src[512];
/////////////////////////////////
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
format(src,sizeof(src),"ip='%s',", PlayerInfo[playerid][pPlIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"adminn=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cash=%d,",GetMoney(playerid));
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"morgan='%i',",PlayerInfo[playerid][pMorgan]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"morgantime='%i',",PlayerInfo[playerid][pMorganTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCreditss]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"totalcredits='%i',",PlayerInfo[playerid][pTotalCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rpr='%i',",PlayerInfo[playerid][pRPR]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"glasses='%i',",PlayerInfo[playerid][pGlasses]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rprgive='%i',",PlayerInfo[playerid][pRPRGive]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bolezn='%i',",PlayerInfo[playerid][pBolezn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cModel='%i',",PlayerInfo[playerid][cModel][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cX='%f',",PlayerInfo[playerid][cX][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cY='%f',",PlayerInfo[playerid][cY][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cZ='%f',",PlayerInfo[playerid][cZ][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFa='%f',",PlayerInfo[playerid][cFa][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel='%i',",PlayerInfo[playerid][cFuel][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cNumber='%s',",PlayerInfo[playerid][cNumber1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCarAr='%i',",PlayerInfo[playerid][cCarAr][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass='%i',",PlayerInfo[playerid][cClass][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor1='%i',",PlayerInfo[playerid][cColor1][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2='%i',",PlayerInfo[playerid][cColor1][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock='%i',",PlayerInfo[playerid][cLock][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost='%i',",PlayerInfo[playerid][cCost][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom1='%d',",PlayerInfo[playerid][cVehcom1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaintjob='%i',",PlayerInfo[playerid][cPaintjob][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawn='%i',",PlayerInfo[playerid][pSpawn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vb='%i',",PlayerInfo[playerid][pVb]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model2='%i',",PlayerInfo[playerid][cModel][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cX2='%f',",PlayerInfo[playerid][cX][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cY2='%f',",PlayerInfo[playerid][cY][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cZ2='%f',",PlayerInfo[playerid][cZ][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFa2='%f',",PlayerInfo[playerid][cFa][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel2='%i',",PlayerInfo[playerid][cFuel][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cNumber2='%s',",PlayerInfo[playerid][cNumber2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCarAr2='%i',",PlayerInfo[playerid][cCarAr][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass2='%i',",PlayerInfo[playerid][cClass][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2_1='%i',",PlayerInfo[playerid][cColor2][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2_2='%i',",PlayerInfo[playerid][cColor2][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock2='%i',",PlayerInfo[playerid][cLock][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost2='%i',",PlayerInfo[playerid][cCost][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom2='%d',",PlayerInfo[playerid][cVehcom2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaint2='%i',",PlayerInfo[playerid][cPaintjob][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model3='%i',",PlayerInfo[playerid][cModel][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cX3='%f',",PlayerInfo[playerid][cX][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cY3='%f',",PlayerInfo[playerid][cY][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cZ3='%f',",PlayerInfo[playerid][cZ][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFa3='%f',",PlayerInfo[playerid][cFa][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel3='%i',",PlayerInfo[playerid][cFuel][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cNumber3='%s',",PlayerInfo[playerid][cNumber3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCarAr3='%i',",PlayerInfo[playerid][cCarAr][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass3='%i',",PlayerInfo[playerid][cClass][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor3_1='%i',",PlayerInfo[playerid][cColor3][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor3_2='%i',",PlayerInfo[playerid][cColor3][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock3='%i',",PlayerInfo[playerid][cLock][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost3='%i',",PlayerInfo[playerid][cCost][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom3='%d',",PlayerInfo[playerid][cVehcom3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaint3='%i',",PlayerInfo[playerid][cPaintjob][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pCars='%i',",PlayerInfo[playerid][pCars]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"admpass='%i',",PlayerInfo[playerid][pAdmPass]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sendfamily='%i',", SendFamily[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sendadmin='%i',", SendAdmin[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showgzone='%i',", ShowGreenZone[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showlogo='%i',", ShowLogo[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showvk='%i',", ShowVk[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showdate='%i',", ShowDate[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showkeys='%i',", ShowKeys[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showspeed='%i',", ShowSpeed[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showogran='%i',", ShowOgran[playerid]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pWorkBook], 40, "%i, %i, %i, %i, %i, %i",
PlayerInfo[playerid][pWB][0], PlayerInfo[playerid][pWB][1],PlayerInfo[playerid][pWB][2]
,PlayerInfo[playerid][pWB][3],PlayerInfo[playerid][pWB][4], PlayerInfo[playerid][pWB][5]);
format(src,sizeof(src),"workbook='%s',",PlayerInfo[playerid][pWorkBook]);
strcat(query,src,sizeof(query));
if(GetPVarInt(playerid, "GunCheat") == 0)
{
for(new i = 0; i < 13; i++)
{
GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
}
format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
}
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE name='%s'",PlayerInfo[playerid][pSendername]);
strcat(query,src,sizeof(query));
mysql_tquery(dbHandle, query, "", "");
return true;
}
сток загрузки аккаунта
forward LoadAccount(playerid, tmp[]);
public LoadAccount(playerid, tmp[])
{
new string[128];
/*new string[64];
new playername[32];
GetPlayerName(playerid,playername,32);*/
new rows, fields;
cache_get_data(rows, fields);
if(!rows)
{
new logtires = 3 - PlayerLogTries[playerid];
PlayerLogTries[playerid]++;
if(PlayerLogTries[playerid] == 4) { SendClientMessage(playerid, COLOR_RED, "Вы были кикнуты по подозрению в взломе {ffffff}/q(uit)"); Kick(playerid); }
new login_str[512];
format(totalstring, 128, "{FFFFFF}Рады снова видеть Вас на сервере {27BBFA}Old RolePlay\n\n"); strcat(login_str, totalstring);
format(totalstring, 128, "{FFFFFF}Ваш аккаунт под ником {FA1E26}%s {FFFFFF}зарегистрирован на сервере\n",PlayerInfo[playerid][pSendername]); strcat(login_str, totalstring);
format(totalstring, 128, "Для игры на сервере, Вам необходимо ввести в окошко ниже свой пароль\n"); strcat(login_str, totalstring);
format(totalstring, 128, "Если Вы забыли свой пароль, то обратитесь к основателям сервера\n"); strcat(login_str, totalstring);
format(totalstring, 128, "Он будет запрашиваться каждый раз при входе на сервер\n\n"); strcat(login_str, totalstring);
format(totalstring, 128, "Введите пароль в поле, данное ниже:"); strcat(login_str, totalstring);
ShowPlayerDialog(playerid, D_ERRORPAS, 3, "{27FAAD}Авторизация", login_str, "Далее","Отмена");
format(string,128,"Вы ввели неправельный пароль от аккаунта. Осталось попыток для ввода: %d",logtires);
SendClientMessage(playerid, COLOR_WARNING, string);
return 1;
}
PlayerInfo[playerid][pID] = cache_get_row_int(0, 0, dbHandle);
cache_get_row(0, 1, PlayerInfo[playerid][pSendername], dbHandle, 32);
cache_get_row(0, 2, PlayerInfo[playerid][pPassword], dbHandle, 32);
cache_get_row(0, 3, PlayerInfo[playerid][pIP], dbHandle, 16);
PlayerInfo[playerid][pAdmin] = cache_get_row_int(0, 4, dbHandle);
cache_get_row(0, 5, PlayerInfo[playerid][pIpPassword], dbHandle, 32);
cache_get_row(0, 6, PlayerInfo[playerid][pMail], dbHandle, 64);
PlayerInfo[playerid][pLevel] = cache_get_row_int(0, 7, dbHandle);
PlayerInfo[playerid][pCash] = cache_get_row_int(0, 8, dbHandle);
PlayerInfo[playerid][pBank] = cache_get_row_int(0, 9, dbHandle);
PlayerInfo[playerid][pExp] = cache_get_row_int(0, 10, dbHandle);
cache_get_row(0, 11, PlayerInfo[playerid][pRegData], dbHandle, 16);
PlayerInfo[playerid][pLeader] = cache_get_row_int(0, 12, dbHandle);
PlayerInfo[playerid][pMember] = cache_get_row_int(0, 13, dbHandle);
PlayerInfo[playerid][pRank] = cache_get_row_int(0, 14, dbHandle);
PlayerInfo[playerid][pWarn] = cache_get_row_int(0, 15, dbHandle);
PlayerInfo[playerid][pSex] = cache_get_row_int(0, 16, dbHandle);
PlayerInfo[playerid][pModel] = cache_get_row_int(0, 17, dbHandle);
PlayerInfo[playerid][pChar] = cache_get_row_int(0, 18, dbHandle);
cache_get_row(0, 19, PlayerInfo[playerid][pLics], dbHandle, 16);
cache_get_row(0, 20, PlayerInfo[playerid][pGuns], dbHandle, 40);
cache_get_row(0, 21, PlayerInfo[playerid][pAmmos], dbHandle, 80);
PlayerInfo[playerid][pGunSkill][6] = cache_get_row_int(0, 22, dbHandle);
PlayerInfo[playerid][pMuted] = cache_get_row_int(0, 23, dbHandle);
PlayerInfo[playerid][pPick] = cache_get_row_int(0, 24, dbHandle);
PlayerInfo[playerid][pCheckTime] = cache_get_row_int(0, 25, dbHandle);
PlayerInfo[playerid][pNews] = cache_get_row_int(0, 26, dbHandle);
cache_get_row(0, 27, PlayerInfo[playerid][pPhones], dbHandle, 16);
cache_get_row(0, 28, PlayerInfo[playerid][pTexts], dbHandle, 20);
PlayerInfo[playerid][pMorgan] = cache_get_row_int(0, 29, dbHandle);
PlayerInfo[playerid][pMorganTime] = cache_get_row_int(0, 30, dbHandle);
PlayerInfo[playerid][pWanted] = cache_get_row_int(0, 31, dbHandle);
PlayerInfo[playerid][pWantedTime] = cache_get_row_int(0, 32, dbHandle);
cache_get_row(0, 33, PlayerInfo[playerid][pWantedWho], dbHandle, 32);
cache_get_row(0, 34, PlayerInfo[playerid][pWantedReason], dbHandle, 32);
PlayerInfo[playerid][pHeal] = cache_get_row_float(0, 35, dbHandle);
PlayerInfo[playerid][pDrugs] = cache_get_row_int(0, 36, dbHandle);
PlayerInfo[playerid][pMats] = cache_get_row_int(0, 37, dbHandle);
PlayerInfo[playerid][pCrimes] = cache_get_row_int(0, 38, dbHandle);
PlayerInfo[playerid][pJob] = cache_get_row_int(0, 39, dbHandle);
PlayerInfo[playerid][pMarried] = cache_get_row_int(0, 40, dbHandle);
cache_get_row(0, 41, PlayerInfo[playerid][pWhoMarried], dbHandle, 32);
cache_get_row(0, 42, PlayerInfo[playerid][pReferal], dbHandle, 32);
PlayerInfo[playerid][pRefMoney] = cache_get_row_int(0, 43, dbHandle);
PlayerInfo[playerid][pPayCheck] = cache_get_row_int(0, 44, dbHandle);
PlayerInfo[playerid][pFish] = cache_get_row_int(0, 45, dbHandle);
PlayerInfo[playerid][pLottery] = cache_get_row_int(0, 46, dbHandle);
PlayerInfo[playerid][pVIP] = cache_get_row_int(0, 47, dbHandle);
PlayerInfo[playerid][pTime] = cache_get_row_int(0, 48, dbHandle);
PlayerInfo[playerid][pFightStyle] = cache_get_row_int(0, 49, dbHandle);
PlayerInfo[playerid][pCreditss] = cache_get_row_int(0, 50, dbHandle);
PlayerInfo[playerid][pTotalCredits] = cache_get_row_int(0, 51, dbHandle);
PlayerInfo[playerid][pSkin1] = cache_get_row_int(0, 52, dbHandle);
PlayerInfo[playerid][pSkin2] = cache_get_row_int(0, 53, dbHandle);
PlayerInfo[playerid][pSkin3] = cache_get_row_int(0, 54, dbHandle);
PlayerInfo[playerid][pSpawnChange] = cache_get_row_int(0, 55, dbHandle);
PlayerInfo[playerid][pGunSkill][0] = cache_get_row_int(0, 56, dbHandle);
PlayerInfo[playerid][pGunSkill][1] = cache_get_row_int(0, 57, dbHandle);
PlayerInfo[playerid][pGunSkill][2] = cache_get_row_int(0, 58, dbHandle);
PlayerInfo[playerid][pGunSkill][3] = cache_get_row_int(0, 59, dbHandle);
PlayerInfo[playerid][pGunSkill][4] = cache_get_row_int(0, 60, dbHandle);
PlayerInfo[playerid][pGunSkill][5] = cache_get_row_int(0, 61, dbHandle);
PlayerInfo[playerid][pRPR] = cache_get_row_int(0, 62, dbHandle);
PlayerInfo[playerid][pGlasses] = cache_get_row_int(0, 63, dbHandle);
PlayerInfo[playerid][pSatiety] = cache_get_row_int(0, 64, dbHandle);
PlayerInfo[playerid][pRPRGive] = cache_get_row_int(0, 65, dbHandle);
PlayerInfo[playerid][pHealthS] = cache_get_row_float(0, 66, dbHandle);
PlayerInfo[playerid][pSportEXP] = cache_get_row_int(0, 67, dbHandle);
PlayerInfo[playerid][pOnline] = cache_get_row_int(0, 68, dbHandle);
PlayerInfo[playerid][pZakon] = cache_get_row_int(0, 69, dbHandle);
PlayerInfo[playerid][pBolezn] = cache_get_row_int(0, 70, dbHandle);
PlayerInfo[playerid][ProverkaIP] = cache_get_row_int(0, 71, dbHandle);
PlayerInfo[playerid][pHospital] = cache_get_row_int(0, 72, dbHandle);
PlayerInfo[playerid][pWatch] = cache_get_row_int(0, 73, dbHandle);
PlayerInfo[playerid][pCiggare] = cache_get_row_int(0, 74, dbHandle);
PlayerInfo[playerid][pSprunk] = cache_get_row_int(0, 75, dbHandle);
PlayerInfo[playerid][pMask] = cache_get_row_int(0, 76, dbHandle);
PlayerInfo[playerid][pPhoneBalance] = cache_get_row_int(0, 77, dbHandle);
PlayerInfo[playerid][pTruckSkill] = cache_get_row_int(0, 78, dbHandle);
PlayerInfo[playerid][cModel][0] = cache_get_row_int(0, 79, dbHandle);
PlayerInfo[playerid][cX][0] = cache_get_row_float(0, 80, dbHandle);
PlayerInfo[playerid][cY][0] = cache_get_row_float(0, 81, dbHandle);
PlayerInfo[playerid][cZ][0] = cache_get_row_float(0, 82, dbHandle);
PlayerInfo[playerid][cFa][0] = cache_get_row_float(0, 83, dbHandle);
PlayerInfo[playerid][cFuel][0] = cache_get_row_int(0, 84, dbHandle);
cache_get_row(0, 85, PlayerInfo[playerid][cNumber1], dbHandle, 64);
PlayerInfo[playerid][cCarAr][0] = cache_get_row_int(0, 86, dbHandle);
PlayerInfo[playerid][cClass][0] = cache_get_row_int(0, 87, dbHandle);
PlayerInfo[playerid][cColor1][0] = cache_get_row_int(0, 88, dbHandle);
PlayerInfo[playerid][cColor1][1] = cache_get_row_int(0, 89, dbHandle);
PlayerInfo[playerid][cLock][0] = cache_get_row_int(0, 90, dbHandle);
PlayerInfo[playerid][cCost][0] = cache_get_row_int(0, 91, dbHandle);
cache_get_row(0, 92, PlayerInfo[playerid][cVehcom1], dbHandle, 64);
PlayerInfo[playerid][cPaintjob][0] = cache_get_row_int(0, 93, dbHandle);
PlayerInfo[playerid][pSpawn] = cache_get_row_int(0, 94, dbHandle);
PlayerInfo[playerid][pVb] = cache_get_row_int(0, 95, dbHandle);
cache_get_row(0, 96, PlayerInfo[playerid][pWorkBook], dbHandle, 16);
PlayerInfo[playerid][pVIPDate] = cache_get_row_int(0, 97, dbHandle);
PlayerInfo[playerid][cModel][1] = cache_get_row_int(0, 98, dbHandle);
PlayerInfo[playerid][cX][1] = cache_get_row_float(0, 99, dbHandle);
PlayerInfo[playerid][cY][1] = cache_get_row_float(0, 100, dbHandle);
PlayerInfo[playerid][cZ][1] = cache_get_row_float(0, 101, dbHandle);
PlayerInfo[playerid][cFa][1] = cache_get_row_float(0, 102, dbHandle);
PlayerInfo[playerid][cFuel][1] = cache_get_row_int(0, 103, dbHandle);
cache_get_row(0, 104, PlayerInfo[playerid][cNumber2], dbHandle, 64);
PlayerInfo[playerid][cCarAr][1] = cache_get_row_int(0, 105, dbHandle);
PlayerInfo[playerid][cClass][1] = cache_get_row_int(0, 106, dbHandle);
PlayerInfo[playerid][cColor2][0] = cache_get_row_int(0, 107, dbHandle);
PlayerInfo[playerid][cColor2][1] = cache_get_row_int(0, 108, dbHandle);
PlayerInfo[playerid][cLock][1] = cache_get_row_int(0, 109, dbHandle);
PlayerInfo[playerid][cCost][1] = cache_get_row_int(0, 110, dbHandle);
cache_get_row(0, 111, PlayerInfo[playerid][cVehcom2], dbHandle, 64);
PlayerInfo[playerid][cPaintjob][1] = cache_get_row_int(0, 112, dbHandle);
PlayerInfo[playerid][cModel][2] = cache_get_row_int(0, 113, dbHandle);
PlayerInfo[playerid][cX][2] = cache_get_row_float(0, 114, dbHandle);
PlayerInfo[playerid][cY][2] = cache_get_row_float(0, 115, dbHandle);
PlayerInfo[playerid][cZ][2] = cache_get_row_float(0, 116, dbHandle);
PlayerInfo[playerid][cFa][2] = cache_get_row_float(0, 117, dbHandle);
PlayerInfo[playerid][cFuel][2] = cache_get_row_int(0, 118, dbHandle);
cache_get_row(0, 119, PlayerInfo[playerid][cNumber3], dbHandle, 64);
PlayerInfo[playerid][cCarAr][2] = cache_get_row_int(0, 120, dbHandle);
PlayerInfo[playerid][cClass][2] = cache_get_row_int(0, 121, dbHandle);
PlayerInfo[playerid][cColor3][0] = cache_get_row_int(0, 122, dbHandle);
PlayerInfo[playerid][cColor3][1] = cache_get_row_int(0, 123, dbHandle);
PlayerInfo[playerid][cLock][2] = cache_get_row_int(0, 124, dbHandle);
PlayerInfo[playerid][cCost][2] = cache_get_row_int(0, 125, dbHandle);
cache_get_row(0, 126, PlayerInfo[playerid][cVehcom3], dbHandle, 64);
PlayerInfo[playerid][cPaintjob][2] = cache_get_row_int(0, 127, dbHandle);
PlayerInfo[playerid][pCars] = cache_get_row_int(0, 128, dbHandle);
PlayerInfo[playerid][pAdmPass] = cache_get_row_int(0, 129, dbHandle);
PlayerInfo[playerid][pTimeSpec] = cache_get_row_int(0, 130, dbHandle);
PlayerInfo[playerid][pTimeRestart] = cache_get_row_int(0, 131, dbHandle);
PlayerInfo[playerid][pTimeDay] = cache_get_row_int(0, 132, dbHandle);
PlayerInfo[playerid][pKickCount] = cache_get_row_int(0, 133, dbHandle);
PlayerInfo[playerid][pBanCount] = cache_get_row_int(0, 134, dbHandle);
PlayerInfo[playerid][pWarnCount] = cache_get_row_int(0, 135, dbHandle);
PlayerInfo[playerid][pJailCount] = cache_get_row_int(0, 136, dbHandle);
PlayerInfo[playerid][pAnsCount] = cache_get_row_int(0, 137, dbHandle);
cache_get_row(0, 138, PlayerInfo[playerid][pLastVisit], dbHandle, 64);
SendFamily[playerid] = cache_get_row_int(0, 139, dbHandle);
SendAdmin[playerid] = cache_get_row_int(0, 140, dbHandle);
ShowGreenZone[playerid] = cache_get_row_int(0, 141, dbHandle);
ShowLogo[playerid] = cache_get_row_int(0, 142, dbHandle);
ShowVk[playerid] = cache_get_row_int(0, 143, dbHandle);
ShowDate[playerid] = cache_get_row_int(0, 144, dbHandle);
ShowKeys[playerid] = cache_get_row_int(0, 145, dbHandle);
ShowSpeed[playerid] = cache_get_row_int(0, 146, dbHandle);
ShowOgran[playerid] = cache_get_row_int(0, 147, dbHandle);
sscanf(PlayerInfo[playerid][cVehcom1], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms1]);
sscanf(PlayerInfo[playerid][cVehcom2], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms2]);
sscanf(PlayerInfo[playerid][cVehcom3], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms3]);
PlayerLogged[playerid] = true;
TimeLogged[playerid] = -1;
if(ShowVk[playerid] == 1) for(new i; i < 4; i++) TextDrawShowForPlayer(playerid, logotip_vk[i]);
if(ShowLogo[playerid] == 1) for(new i; i < 4; i++) TextDrawShowForPlayer(playerid, logotip[i]);
if(ShowDate[playerid] == 1) for(new i; i < 2; i++) TextDrawShowForPlayer(playerid, logotip_data[i]);
sscanf(PlayerInfo[playerid][pTexts], "p<,>a<i>[3]", PlayerInfo[playerid][pText]);
sscanf(PlayerInfo[playerid][pPhones], "p<,>a<i>[3]", PlayerInfo[playerid][pPhone]);
sscanf(PlayerInfo[playerid][pLics], "p<,>a<i>[5]",PlayerInfo[playerid][pLic]);
sscanf(PlayerInfo[playerid][pWorkBook], "p<,>a<i>[6]",PlayerInfo[playerid][pWB]);
new a;
while(a++ < 100) SendClientMessage(playerid, COLOR_LIGHTRED, "");
SendClientMessage(playerid, COLOR_WHITE,"Добро пожаловать на {399AFA}« Old RolePlay »");
if(PlayerInfo[playerid][pAdmin] > 0) AdmLogged[playerid] = true, SendClientMessage(playerid, COLOR_RED, !"Вы являетесь администратором на сервере. Для авторизации в АП используйте команду /alog");
if(PlayerInfo[playerid][pLeader] > 0) SendMes(playerid, COLOR_WHITE, "[Ф] %s приветствует вас как {FF9900}руководителя",FracInfo[PlayerInfo[playerid][pLeader]][fName]);
if(PlayerInfo[playerid][pMember] > 0 && strcmp(PlayerInfo[playerid][pSendername],FracInfo[PlayerInfo[playerid][pMember]][fAssistant],true) == 0) SendMes(playerid, COLOR_YELLOW, "Вы вошли как заместитель: {FF9900}%s",FracInfo[PlayerInfo[playerid][pMember]][fName]);
/* if(gettime() >= PlayerInfo[playerid][pVIPDate])
{
PlayerInfo[playerid][pVIP] = 0;
PlayerInfo[playerid][pVIPDate] = 0;
SendClientMessage(playerid, COLOR_LIGHTRED, "Действие вашего VIP аккаунта закончилось.");
}
else SendClientMessage(playerid, COLOR_GREEN, "{3697E1}— {FFFFFF}Возможности VIP аккаунта активированы, приятной игры!");
PlayerPlaySound(playerid, 30800, 0.0, 0.0, 0.0);*/
/*if(PlayerInfo[playerid][ProverkaIP] != 0)
{
ShowPlayerDialog(playerid, D_CHECKPASS, DIALOG_STYLE_INPUT, "{FA5269}Пароль безопасности","\
{FFFFFF}На Вашем аккаунте была установлена дополнительный пароль при авторизации..\n\
Если Вы забыли пароль, то напишите об этом основателю, предоставив док-ва того,\n\
что именно Вы являетесь владельцем аккаунта. Введите пароль в строчку ниже:", "Далее", "Выход");
return true;
}*/
if (PlayerInfo[playerid][pText][0] == 1)
{
SendClientMessage(playerid, -1, "{F20B36}—{FFFFFF} Вы забыли оплатить за кварплату, ваш дом продали!");
SendClientMessage(playerid, -1, "{F20B36}—{FFFFFF} На ваш банковский счет возвращена стоимость дома по гос-ву");
PlayerInfo[playerid][pText][0] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "", "");
}
if(PlayerInfo[playerid][pText][1] == 1)
{
SendClientMessage(playerid, -1,"{F20B36}—{FFFFFF} Ваш бизнес закрыли в связи с нехваткой ресурсов");
SendClientMessage(playerid, -1,"{F20B36}—{FFFFFF} Бюджет бизнеса зачислен на ваш банковский счет");
PlayerInfo[playerid][pText][1] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "", "");
}
if(PlayerInfo[playerid][pText][2] == 1)
{
new p = PlayerInfo[playerid][pRefMoney] / 100000;
for(new i = 1; i <= p; i++)
{
GiveMoney(playerid, 100000);
PlayerInfo[playerid][pRefMoney] -= 100000;
}
PlayerInfo[playerid][pText][2] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s', refmoney WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pRefMoney], PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "", "");
}
if(GetPlayerHouse(playerid))
{
new h = GetPVarInt(playerid, "PlayerHouse");
if(HouseInfo[h][hOplata] < 250) SendClientMessage(playerid, COLOR_RED, "На балансе Вашего дома осталось менее 250 рублей"), SendClientMessage(playerid, COLOR_RED, "Внесите оплату за дом, либо в противном случае, Ваш дом будет продан");
}
new visit_str[128];
format(visit_str, sizeof visit_str, "Old RolePlay: {FFFFFF}Последний вход в аккаунт был выполнен: {DCF58A}< %s >", PlayerInfo[playerid][pLastVisit]);
SendClientMessage(playerid, 0x5BA0D4AA, visit_str);
mysql_format(dbHandle, query, 128, "SELECT * FROM `gdonate_payments` WHERE account = '%s' AND status = '1'", PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "CheckDonatePlayer", "i", playerid);
if(PlayerInfo[playerid][pFightStyle] != 0) SetPlayerFightingStyle(playerid,PlayerInfo[playerid][pFightStyle]);
else SetPlayerFightingStyle(playerid,0);
SetMoney(playerid, PlayerInfo[playerid][pCash]);
ResetWeapon(playerid);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
if(PlayerInfo[playerid][pWanted] > 0) SetPlayerWantedLevel(playerid, PlayerInfo[playerid][pWanted]);
if(PlayerInfo[playerid][pGunSkill][6] >= NORM_SKILLS_PLAYER) VehRe[playerid] = true;
SetSpawnInfo(playerid, 255, PlayerInfo[playerid][pModel], 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
SpawnPlayer(playerid);
new str123[12];
GetPlayerIp(playerid,str123,12);
format(string, 64, "%s зашел в аккаунт с ip: %s",PlayerInfo[playerid][pSendername],str123);
Log("LogInfo",string);
DeletePVar(playerid,"Acc");
SetPlayerInt(PlayerInfo[playerid][pSendername], "online", 1);
LoadMyCar(playerid);
SetPlayerTeamColor(playerid);
return true;
}
сток тюнинга
stock SaveVehicleTuning(playerid)
{
new i1 = PlayerInfo[playerid][cCarId][0];
new i2 = PlayerInfo[playerid][cCarId][1];
new i3 = PlayerInfo[playerid][cCarId][2];
PlayerInfo[playerid][cVehcoms1][0]=GetVehicleComponentInSlot(i1, CARMODTYPE_SPOILER);
PlayerInfo[playerid][cVehcoms1][1]=GetVehicleComponentInSlot(i1, CARMODTYPE_HOOD);
PlayerInfo[playerid][cVehcoms1][2]=GetVehicleComponentInSlot(i1, CARMODTYPE_ROOF);
PlayerInfo[playerid][cVehcoms1][3]=GetVehicleComponentInSlot(i1, CARMODTYPE_SIDESKIRT);
PlayerInfo[playerid][cVehcoms1][4]=GetVehicleComponentInSlot(i1, CARMODTYPE_LAMPS);
PlayerInfo[playerid][cVehcoms1][5]=GetVehicleComponentInSlot(i1, CARMODTYPE_NITRO);
PlayerInfo[playerid][cVehcoms1][6]=GetVehicleComponentInSlot(i1, CARMODTYPE_EXHAUST);
PlayerInfo[playerid][cVehcoms1][7]=GetVehicleComponentInSlot(i1, CARMODTYPE_WHEELS);
PlayerInfo[playerid][cVehcoms1][8]=GetVehicleComponentInSlot(i1, CARMODTYPE_STEREO);
PlayerInfo[playerid][cVehcoms1][9]=GetVehicleComponentInSlot(i1, CARMODTYPE_HYDRAULICS);
PlayerInfo[playerid][cVehcoms1][10]=GetVehicleComponentInSlot(i1, CARMODTYPE_FRONT_BUMPER);
PlayerInfo[playerid][cVehcoms1][11]=GetVehicleComponentInSlot(i1, CARMODTYPE_REAR_BUMPER);
PlayerInfo[playerid][cVehcoms1][12]=GetVehicleComponentInSlot(i1, CARMODTYPE_VENT_RIGHT);
PlayerInfo[playerid][cVehcoms1][13]=GetVehicleComponentInSlot(i1, CARMODTYPE_VENT_LEFT);
format(PlayerInfo[playerid][cVehcom1], 64, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][cVehcoms1][0],PlayerInfo[playerid][cVehcoms1][1],PlayerInfo[playerid][cVehcoms1][2],
PlayerInfo[playerid][cVehcoms1][3],PlayerInfo[playerid][cVehcoms1][4],PlayerInfo[playerid][cVehcoms1][5],
PlayerInfo[playerid][cVehcoms1][6],PlayerInfo[playerid][cVehcoms1][7],PlayerInfo[playerid][cVehcoms1][8],
PlayerInfo[playerid][cVehcoms1][9],PlayerInfo[playerid][cVehcoms1][10],PlayerInfo[playerid][cVehcoms1][11],
PlayerInfo[playerid][cVehcoms1][12],PlayerInfo[playerid][cVehcoms1][13]);
PlayerInfo[playerid][cVehcoms2][0]=GetVehicleComponentInSlot(i2, CARMODTYPE_SPOILER);
PlayerInfo[playerid][cVehcoms2][1]=GetVehicleComponentInSlot(i2, CARMODTYPE_HOOD);
PlayerInfo[playerid][cVehcoms2][2]=GetVehicleComponentInSlot(i2, CARMODTYPE_ROOF);
PlayerInfo[playerid][cVehcoms2][3]=GetVehicleComponentInSlot(i2, CARMODTYPE_SIDESKIRT);
PlayerInfo[playerid][cVehcoms2][4]=GetVehicleComponentInSlot(i2, CARMODTYPE_LAMPS);
PlayerInfo[playerid][cVehcoms2][5]=GetVehicleComponentInSlot(i2, CARMODTYPE_NITRO);
PlayerInfo[playerid][cVehcoms2][6]=GetVehicleComponentInSlot(i2, CARMODTYPE_EXHAUST);
PlayerInfo[playerid][cVehcoms2][7]=GetVehicleComponentInSlot(i2, CARMODTYPE_WHEELS);
PlayerInfo[playerid][cVehcoms2][8]=GetVehicleComponentInSlot(i2, CARMODTYPE_STEREO);
PlayerInfo[playerid][cVehcoms2][9]=GetVehicleComponentInSlot(i2, CARMODTYPE_HYDRAULICS);
PlayerInfo[playerid][cVehcoms2][10]=GetVehicleComponentInSlot(i2, CARMODTYPE_FRONT_BUMPER);
PlayerInfo[playerid][cVehcoms2][11]=GetVehicleComponentInSlot(i2, CARMODTYPE_REAR_BUMPER);
PlayerInfo[playerid][cVehcoms2][12]=GetVehicleComponentInSlot(i2, CARMODTYPE_VENT_RIGHT);
PlayerInfo[playerid][cVehcoms2][13]=GetVehicleComponentInSlot(i2, CARMODTYPE_VENT_LEFT);
format(PlayerInfo[playerid][cVehcom2], 64, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][cVehcoms2][0],PlayerInfo[playerid][cVehcoms2][1],PlayerInfo[playerid][cVehcoms2][2],
PlayerInfo[playerid][cVehcoms2][3],PlayerInfo[playerid][cVehcoms2][4],PlayerInfo[playerid][cVehcoms2][5],
PlayerInfo[playerid][cVehcoms2][6],PlayerInfo[playerid][cVehcoms2][7],PlayerInfo[playerid][cVehcoms2][8],
PlayerInfo[playerid][cVehcoms2][9],PlayerInfo[playerid][cVehcoms2][10],PlayerInfo[playerid][cVehcoms2][11],
PlayerInfo[playerid][cVehcoms2][12],PlayerInfo[playerid][cVehcoms2][13]);
PlayerInfo[playerid][cVehcoms3][0]=GetVehicleComponentInSlot(i3, CARMODTYPE_SPOILER);
PlayerInfo[playerid][cVehcoms3][1]=GetVehicleComponentInSlot(i3, CARMODTYPE_HOOD);
PlayerInfo[playerid][cVehcoms3][2]=GetVehicleComponentInSlot(i3, CARMODTYPE_ROOF);
PlayerInfo[playerid][cVehcoms3][3]=GetVehicleComponentInSlot(i3, CARMODTYPE_SIDESKIRT);
PlayerInfo[playerid][cVehcoms3][4]=GetVehicleComponentInSlot(i3, CARMODTYPE_LAMPS);
PlayerInfo[playerid][cVehcoms3][5]=GetVehicleComponentInSlot(i3, CARMODTYPE_NITRO);
PlayerInfo[playerid][cVehcoms3][6]=GetVehicleComponentInSlot(i3, CARMODTYPE_EXHAUST);
PlayerInfo[playerid][cVehcoms3][7]=GetVehicleComponentInSlot(i3, CARMODTYPE_WHEELS);
PlayerInfo[playerid][cVehcoms3][8]=GetVehicleComponentInSlot(i3, CARMODTYPE_STEREO);
PlayerInfo[playerid][cVehcoms3][9]=GetVehicleComponentInSlot(i3, CARMODTYPE_HYDRAULICS);
PlayerInfo[playerid][cVehcoms3][10]=GetVehicleComponentInSlot(i3, CARMODTYPE_FRONT_BUMPER);
PlayerInfo[playerid][cVehcoms3][11]=GetVehicleComponentInSlot(i3, CARMODTYPE_REAR_BUMPER);
PlayerInfo[playerid][cVehcoms3][12]=GetVehicleComponentInSlot(i3, CARMODTYPE_VENT_RIGHT);
PlayerInfo[playerid][cVehcoms3][13]=GetVehicleComponentInSlot(i3, CARMODTYPE_VENT_LEFT);
format(PlayerInfo[playerid][cVehcom3], 64, "%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][cVehcoms3][0],PlayerInfo[playerid][cVehcoms3][1],PlayerInfo[playerid][cVehcoms3][2],
PlayerInfo[playerid][cVehcoms3][3],PlayerInfo[playerid][cVehcoms3][4],PlayerInfo[playerid][cVehcoms3][5],
PlayerInfo[playerid][cVehcoms3][6],PlayerInfo[playerid][cVehcoms3][7],PlayerInfo[playerid][cVehcoms3][8],
PlayerInfo[playerid][cVehcoms3][9],PlayerInfo[playerid][cVehcoms3][10],PlayerInfo[playerid][cVehcoms3][11],
PlayerInfo[playerid][cVehcoms3][12],PlayerInfo[playerid][cVehcoms3][13]);
}
сток сохранения аккаунта
stock SaveAccount(playerid)
{
if(PlayerLogged[playerid] == 0) return true;
new src[512];
/////////////////////////////////
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
format(src,sizeof(src),"ip='%s',", PlayerInfo[playerid][pPlIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"level=%d,",PlayerInfo[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"adminn=%d,",PlayerInfo[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sex=%d,",PlayerInfo[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ippassword='%s',",PlayerInfo[playerid][pIpPassword]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model=%d,",PlayerInfo[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"loach=%d,",PlayerInfo[playerid][pChar]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cash=%d,",GetMoney(playerid));
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bank=%d,",PlayerInfo[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mute=%d,",PlayerInfo[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warn=%d,",PlayerInfo[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"leader=%d,",PlayerInfo[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"member=%d,",PlayerInfo[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rank=%d,",PlayerInfo[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pick=%d,",PlayerInfo[playerid][pPick]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"exp=%d,",PlayerInfo[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"news=%d,",PlayerInfo[playerid][pNews]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"morgan='%i',",PlayerInfo[playerid][pMorgan]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"morgantime='%i',",PlayerInfo[playerid][pMorganTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"crimes=%d,",PlayerInfo[playerid][pCrimes]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wanted=%d,",PlayerInfo[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedtime=%d,",PlayerInfo[playerid][pWantedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedwho='%s',",PlayerInfo[playerid][pWantedWho]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedreason='%s',",PlayerInfo[playerid][pWantedReason]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"job=%d,",PlayerInfo[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checktime=%d,",PlayerInfo[playerid][pCheckTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"drugs=%d,",PlayerInfo[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mats=%d,",PlayerInfo[playerid][pMats]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"heal='%f',",PlayerInfo[playerid][pHeal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"married=%d,",PlayerInfo[playerid][pMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"whomarried='%s',",PlayerInfo[playerid][pWhoMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"paycheck='%i',",PlayerInfo[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fishing='%i',",PlayerInfo[playerid][pFish]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"lottery='%i',",PlayerInfo[playerid][pLottery]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vip='%i',",PlayerInfo[playerid][pVIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"time='%i',",PlayerInfo[playerid][pTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fstyle='%i',",PlayerInfo[playerid][pFightStyle]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"credits='%i',",PlayerInfo[playerid][pCreditss]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"totalcredits='%i',",PlayerInfo[playerid][pTotalCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin1='%i',",PlayerInfo[playerid][pSkin1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin2='%i',",PlayerInfo[playerid][pSkin2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin3='%i',",PlayerInfo[playerid][pSkin3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawnchange='%i',",PlayerInfo[playerid][pSpawnChange]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sdpistol='%i',",PlayerInfo[playerid][pGunSkill][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"deserteagle='%i',",PlayerInfo[playerid][pGunSkill][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"shotgun='%i',",PlayerInfo[playerid][pGunSkill][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mp5='%i',",PlayerInfo[playerid][pGunSkill][3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ak47='%i',",PlayerInfo[playerid][pGunSkill][4]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"m4='%i',",PlayerInfo[playerid][pGunSkill][5]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rpr='%i',",PlayerInfo[playerid][pRPR]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"glasses='%i',",PlayerInfo[playerid][pGlasses]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"satiety='%i',",PlayerInfo[playerid][pSatiety]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rprgive='%i',",PlayerInfo[playerid][pRPRGive]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"healths='%f',",PlayerInfo[playerid][pHealthS]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sportexp='%i',",PlayerInfo[playerid][pSportEXP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"online='%i',",PlayerInfo[playerid][pOnline]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"zakon='%i',",PlayerInfo[playerid][pZakon]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bolezn='%i',",PlayerInfo[playerid][pBolezn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ipcheck='%i',",PlayerInfo[playerid][ProverkaIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"hospital='%i',",PlayerInfo[playerid][pHospital]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"watch='%i',",PlayerInfo[playerid][pWatch]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ciggare='%i',",PlayerInfo[playerid][pCiggare]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sprunk='%i',",PlayerInfo[playerid][pSprunk]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mask='%i',",PlayerInfo[playerid][pMask]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phonebalance='%i',",PlayerInfo[playerid][pPhoneBalance]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"truckskill='%i',",PlayerInfo[playerid][pTruckSkill]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cModel='%i',",PlayerInfo[playerid][cModel][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cX='%f',",PlayerInfo[playerid][cX][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cY='%f',",PlayerInfo[playerid][cY][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cZ='%f',",PlayerInfo[playerid][cZ][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFa='%f',",PlayerInfo[playerid][cFa][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel='%i',",PlayerInfo[playerid][cFuel][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cNumber='%s',",PlayerInfo[playerid][cNumber1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCarAr='%i',",PlayerInfo[playerid][cCarAr][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass='%i',",PlayerInfo[playerid][cClass][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor1='%i',",PlayerInfo[playerid][cColor1][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2='%i',",PlayerInfo[playerid][cColor1][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock='%i',",PlayerInfo[playerid][cLock][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost='%i',",PlayerInfo[playerid][cCost][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom1='%d',",PlayerInfo[playerid][cVehcom1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaintjob='%i',",PlayerInfo[playerid][cPaintjob][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawn='%i',",PlayerInfo[playerid][pSpawn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vb='%i',",PlayerInfo[playerid][pVb]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model2='%i',",PlayerInfo[playerid][cModel][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cX2='%f',",PlayerInfo[playerid][cX][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cY2='%f',",PlayerInfo[playerid][cY][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cZ2='%f',",PlayerInfo[playerid][cZ][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFa2='%f',",PlayerInfo[playerid][cFa][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel2='%i',",PlayerInfo[playerid][cFuel][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cNumber2='%s',",PlayerInfo[playerid][cNumber2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCarAr2='%i',",PlayerInfo[playerid][cCarAr][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass2='%i',",PlayerInfo[playerid][cClass][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2_1='%i',",PlayerInfo[playerid][cColor2][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2_2='%i',",PlayerInfo[playerid][cColor2][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock2='%i',",PlayerInfo[playerid][cLock][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost2='%i',",PlayerInfo[playerid][cCost][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom2='%d',",PlayerInfo[playerid][cVehcom2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaint2='%i',",PlayerInfo[playerid][cPaintjob][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model3='%i',",PlayerInfo[playerid][cModel][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cX3='%f',",PlayerInfo[playerid][cX][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cY3='%f',",PlayerInfo[playerid][cY][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cZ3='%f',",PlayerInfo[playerid][cZ][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFa3='%f',",PlayerInfo[playerid][cFa][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel3='%i',",PlayerInfo[playerid][cFuel][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cNumber3='%s',",PlayerInfo[playerid][cNumber3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCarAr3='%i',",PlayerInfo[playerid][cCarAr][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass3='%i',",PlayerInfo[playerid][cClass][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor3_1='%i',",PlayerInfo[playerid][cColor3][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor3_2='%i',",PlayerInfo[playerid][cColor3][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock3='%i',",PlayerInfo[playerid][cLock][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost3='%i',",PlayerInfo[playerid][cCost][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom3='%d',",PlayerInfo[playerid][cVehcom3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaint3='%i',",PlayerInfo[playerid][cPaintjob][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pCars='%i',",PlayerInfo[playerid][pCars]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"admpass='%i',",PlayerInfo[playerid][pAdmPass]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sendfamily='%i',", SendFamily[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sendadmin='%i',", SendAdmin[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showgzone='%i',", ShowGreenZone[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showlogo='%i',", ShowLogo[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showvk='%i',", ShowVk[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showdate='%i',", ShowDate[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showkeys='%i',", ShowKeys[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showspeed='%i',", ShowSpeed[playerid]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"showogran='%i',", ShowOgran[playerid]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pPhones],16,"%i, %i, %i",
PlayerInfo[playerid][pPhone][0],PlayerInfo[playerid][pPhone][1], PlayerInfo[playerid][pPhone][2]);
format(src,sizeof(src),"phone='%s',",PlayerInfo[playerid][pPhones]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pLics],40,"%i, %i, %i, %i, %i",
PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2]
,PlayerInfo[playerid][pLic][3],PlayerInfo[playerid][pLic][4]);
format(src,sizeof(src),"lic='%s',",PlayerInfo[playerid][pLics]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pWorkBook], 40, "%i, %i, %i, %i, %i, %i",
PlayerInfo[playerid][pWB][0], PlayerInfo[playerid][pWB][1],PlayerInfo[playerid][pWB][2]
,PlayerInfo[playerid][pWB][3],PlayerInfo[playerid][pWB][4], PlayerInfo[playerid][pWB][5]);
format(src,sizeof(src),"workbook='%s',",PlayerInfo[playerid][pWorkBook]);
strcat(query,src,sizeof(query));
if(GetPVarInt(playerid, "GunCheat") == 0)
{
for(new i = 0; i < 13; i++)
{
GetPlayerWeaponData(playerid, i, PlayerInfo[playerid][pGun][i], PlayerInfo[playerid][pAmmo][i]);
}
format(PlayerInfo[playerid][pGuns],40,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pGun][0],PlayerInfo[playerid][pGun][1],PlayerInfo[playerid][pGun][2],
PlayerInfo[playerid][pGun][3],PlayerInfo[playerid][pGun][4],PlayerInfo[playerid][pGun][5],
PlayerInfo[playerid][pGun][6],PlayerInfo[playerid][pGun][7],PlayerInfo[playerid][pGun][8],
PlayerInfo[playerid][pGun][9],PlayerInfo[playerid][pGun][10],PlayerInfo[playerid][pGun][11],PlayerInfo[playerid][pGun][12]);
format(src,sizeof(src),"guns='%s',",PlayerInfo[playerid][pGuns]);
strcat(query,src,sizeof(query));
format(PlayerInfo[playerid][pAmmos],160,"%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d,%d",
PlayerInfo[playerid][pAmmo][0],PlayerInfo[playerid][pAmmo][1],PlayerInfo[playerid][pAmmo][2],
PlayerInfo[playerid][pAmmo][3],PlayerInfo[playerid][pAmmo][4],PlayerInfo[playerid][pAmmo][5],
PlayerInfo[playerid][pAmmo][6],PlayerInfo[playerid][pAmmo][7],PlayerInfo[playerid][pAmmo][8],
PlayerInfo[playerid][pAmmo][9],PlayerInfo[playerid][pAmmo][10],PlayerInfo[playerid][pAmmo][11],PlayerInfo[playerid][pAmmo][12]);
format(src,sizeof(src),"ammos='%s',",PlayerInfo[playerid][pAmmos]);
}
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skills='%d'",PlayerInfo[playerid][pGunSkill][6]);
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE name='%s'",PlayerInfo[playerid][pSendername]);
strcat(query,src,sizeof(query));
mysql_tquery(dbHandle, query, "", "");
return true;
}
сток загрузки аккаунта
forward LoadAccount(playerid, tmp[]);
public LoadAccount(playerid, tmp[])
{
new string[128];
/*new string[64];
new playername[32];
GetPlayerName(playerid,playername,32);*/
new rows, fields;
cache_get_data(rows, fields);
if(!rows)
{
new logtires = 3 - PlayerLogTries[playerid];
PlayerLogTries[playerid]++;
if(PlayerLogTries[playerid] == 4) { SendClientMessage(playerid, COLOR_RED, "Вы были кикнуты по подозрению в взломе {ffffff}/q(uit)"); Kick(playerid); }
new login_str[512];
format(totalstring, 128, "{FFFFFF}Рады снова видеть Вас на сервере {27BBFA}Old RolePlay\n\n"); strcat(login_str, totalstring);
format(totalstring, 128, "{FFFFFF}Ваш аккаунт под ником {FA1E26}%s {FFFFFF}зарегистрирован на сервере\n",PlayerInfo[playerid][pSendername]); strcat(login_str, totalstring);
format(totalstring, 128, "Для игры на сервере, Вам необходимо ввести в окошко ниже свой пароль\n"); strcat(login_str, totalstring);
format(totalstring, 128, "Если Вы забыли свой пароль, то обратитесь к основателям сервера\n"); strcat(login_str, totalstring);
format(totalstring, 128, "Он будет запрашиваться каждый раз при входе на сервер\n\n"); strcat(login_str, totalstring);
format(totalstring, 128, "Введите пароль в поле, данное ниже:"); strcat(login_str, totalstring);
ShowPlayerDialog(playerid, D_ERRORPAS, 3, "{27FAAD}Авторизация", login_str, "Далее","Отмена");
format(string,128,"Вы ввели неправельный пароль от аккаунта. Осталось попыток для ввода: %d",logtires);
SendClientMessage(playerid, COLOR_WARNING, string);
return 1;
}
PlayerInfo[playerid][pID] = cache_get_row_int(0, 0, dbHandle);
cache_get_row(0, 1, PlayerInfo[playerid][pSendername], dbHandle, 32);
cache_get_row(0, 2, PlayerInfo[playerid][pPassword], dbHandle, 32);
cache_get_row(0, 3, PlayerInfo[playerid][pIP], dbHandle, 16);
PlayerInfo[playerid][pAdmin] = cache_get_row_int(0, 4, dbHandle);
cache_get_row(0, 5, PlayerInfo[playerid][pIpPassword], dbHandle, 32);
cache_get_row(0, 6, PlayerInfo[playerid][pMail], dbHandle, 64);
PlayerInfo[playerid][pLevel] = cache_get_row_int(0, 7, dbHandle);
PlayerInfo[playerid][pCash] = cache_get_row_int(0, 8, dbHandle);
PlayerInfo[playerid][pBank] = cache_get_row_int(0, 9, dbHandle);
PlayerInfo[playerid][pExp] = cache_get_row_int(0, 10, dbHandle);
cache_get_row(0, 11, PlayerInfo[playerid][pRegData], dbHandle, 16);
PlayerInfo[playerid][pLeader] = cache_get_row_int(0, 12, dbHandle);
PlayerInfo[playerid][pMember] = cache_get_row_int(0, 13, dbHandle);
PlayerInfo[playerid][pRank] = cache_get_row_int(0, 14, dbHandle);
PlayerInfo[playerid][pWarn] = cache_get_row_int(0, 15, dbHandle);
PlayerInfo[playerid][pSex] = cache_get_row_int(0, 16, dbHandle);
PlayerInfo[playerid][pModel] = cache_get_row_int(0, 17, dbHandle);
PlayerInfo[playerid][pChar] = cache_get_row_int(0, 18, dbHandle);
cache_get_row(0, 19, PlayerInfo[playerid][pLics], dbHandle, 16);
cache_get_row(0, 20, PlayerInfo[playerid][pGuns], dbHandle, 40);
cache_get_row(0, 21, PlayerInfo[playerid][pAmmos], dbHandle, 80);
PlayerInfo[playerid][pGunSkill][6] = cache_get_row_int(0, 22, dbHandle);
PlayerInfo[playerid][pMuted] = cache_get_row_int(0, 23, dbHandle);
PlayerInfo[playerid][pPick] = cache_get_row_int(0, 24, dbHandle);
PlayerInfo[playerid][pCheckTime] = cache_get_row_int(0, 25, dbHandle);
PlayerInfo[playerid][pNews] = cache_get_row_int(0, 26, dbHandle);
cache_get_row(0, 27, PlayerInfo[playerid][pPhones], dbHandle, 16);
cache_get_row(0, 28, PlayerInfo[playerid][pTexts], dbHandle, 20);
PlayerInfo[playerid][pMorgan] = cache_get_row_int(0, 29, dbHandle);
PlayerInfo[playerid][pMorganTime] = cache_get_row_int(0, 30, dbHandle);
PlayerInfo[playerid][pWanted] = cache_get_row_int(0, 31, dbHandle);
PlayerInfo[playerid][pWantedTime] = cache_get_row_int(0, 32, dbHandle);
cache_get_row(0, 33, PlayerInfo[playerid][pWantedWho], dbHandle, 32);
cache_get_row(0, 34, PlayerInfo[playerid][pWantedReason], dbHandle, 32);
PlayerInfo[playerid][pHeal] = cache_get_row_float(0, 35, dbHandle);
PlayerInfo[playerid][pDrugs] = cache_get_row_int(0, 36, dbHandle);
PlayerInfo[playerid][pMats] = cache_get_row_int(0, 37, dbHandle);
PlayerInfo[playerid][pCrimes] = cache_get_row_int(0, 38, dbHandle);
PlayerInfo[playerid][pJob] = cache_get_row_int(0, 39, dbHandle);
PlayerInfo[playerid][pMarried] = cache_get_row_int(0, 40, dbHandle);
cache_get_row(0, 41, PlayerInfo[playerid][pWhoMarried], dbHandle, 32);
cache_get_row(0, 42, PlayerInfo[playerid][pReferal], dbHandle, 32);
PlayerInfo[playerid][pRefMoney] = cache_get_row_int(0, 43, dbHandle);
PlayerInfo[playerid][pPayCheck] = cache_get_row_int(0, 44, dbHandle);
PlayerInfo[playerid][pFish] = cache_get_row_int(0, 45, dbHandle);
PlayerInfo[playerid][pLottery] = cache_get_row_int(0, 46, dbHandle);
PlayerInfo[playerid][pVIP] = cache_get_row_int(0, 47, dbHandle);
PlayerInfo[playerid][pTime] = cache_get_row_int(0, 48, dbHandle);
PlayerInfo[playerid][pFightStyle] = cache_get_row_int(0, 49, dbHandle);
PlayerInfo[playerid][pCreditss] = cache_get_row_int(0, 50, dbHandle);
PlayerInfo[playerid][pTotalCredits] = cache_get_row_int(0, 51, dbHandle);
PlayerInfo[playerid][pSkin1] = cache_get_row_int(0, 52, dbHandle);
PlayerInfo[playerid][pSkin2] = cache_get_row_int(0, 53, dbHandle);
PlayerInfo[playerid][pSkin3] = cache_get_row_int(0, 54, dbHandle);
PlayerInfo[playerid][pSpawnChange] = cache_get_row_int(0, 55, dbHandle);
PlayerInfo[playerid][pGunSkill][0] = cache_get_row_int(0, 56, dbHandle);
PlayerInfo[playerid][pGunSkill][1] = cache_get_row_int(0, 57, dbHandle);
PlayerInfo[playerid][pGunSkill][2] = cache_get_row_int(0, 58, dbHandle);
PlayerInfo[playerid][pGunSkill][3] = cache_get_row_int(0, 59, dbHandle);
PlayerInfo[playerid][pGunSkill][4] = cache_get_row_int(0, 60, dbHandle);
PlayerInfo[playerid][pGunSkill][5] = cache_get_row_int(0, 61, dbHandle);
PlayerInfo[playerid][pRPR] = cache_get_row_int(0, 62, dbHandle);
PlayerInfo[playerid][pGlasses] = cache_get_row_int(0, 63, dbHandle);
PlayerInfo[playerid][pSatiety] = cache_get_row_int(0, 64, dbHandle);
PlayerInfo[playerid][pRPRGive] = cache_get_row_int(0, 65, dbHandle);
PlayerInfo[playerid][pHealthS] = cache_get_row_float(0, 66, dbHandle);
PlayerInfo[playerid][pSportEXP] = cache_get_row_int(0, 67, dbHandle);
PlayerInfo[playerid][pOnline] = cache_get_row_int(0, 68, dbHandle);
PlayerInfo[playerid][pZakon] = cache_get_row_int(0, 69, dbHandle);
PlayerInfo[playerid][pBolezn] = cache_get_row_int(0, 70, dbHandle);
PlayerInfo[playerid][ProverkaIP] = cache_get_row_int(0, 71, dbHandle);
PlayerInfo[playerid][pHospital] = cache_get_row_int(0, 72, dbHandle);
PlayerInfo[playerid][pWatch] = cache_get_row_int(0, 73, dbHandle);
PlayerInfo[playerid][pCiggare] = cache_get_row_int(0, 74, dbHandle);
PlayerInfo[playerid][pSprunk] = cache_get_row_int(0, 75, dbHandle);
PlayerInfo[playerid][pMask] = cache_get_row_int(0, 76, dbHandle);
PlayerInfo[playerid][pPhoneBalance] = cache_get_row_int(0, 77, dbHandle);
PlayerInfo[playerid][pTruckSkill] = cache_get_row_int(0, 78, dbHandle);
PlayerInfo[playerid][cModel][0] = cache_get_row_int(0, 79, dbHandle);
PlayerInfo[playerid][cX][0] = cache_get_row_float(0, 80, dbHandle);
PlayerInfo[playerid][cY][0] = cache_get_row_float(0, 81, dbHandle);
PlayerInfo[playerid][cZ][0] = cache_get_row_float(0, 82, dbHandle);
PlayerInfo[playerid][cFa][0] = cache_get_row_float(0, 83, dbHandle);
PlayerInfo[playerid][cFuel][0] = cache_get_row_int(0, 84, dbHandle);
cache_get_row(0, 85, PlayerInfo[playerid][cNumber1], dbHandle, 64);
PlayerInfo[playerid][cCarAr][0] = cache_get_row_int(0, 86, dbHandle);
PlayerInfo[playerid][cClass][0] = cache_get_row_int(0, 87, dbHandle);
PlayerInfo[playerid][cColor1][0] = cache_get_row_int(0, 88, dbHandle);
PlayerInfo[playerid][cColor1][1] = cache_get_row_int(0, 89, dbHandle);
PlayerInfo[playerid][cLock][0] = cache_get_row_int(0, 90, dbHandle);
PlayerInfo[playerid][cCost][0] = cache_get_row_int(0, 91, dbHandle);
cache_get_row(0, 92, PlayerInfo[playerid][cVehcom1], dbHandle, 64);
PlayerInfo[playerid][cPaintjob][0] = cache_get_row_int(0, 93, dbHandle);
PlayerInfo[playerid][pSpawn] = cache_get_row_int(0, 94, dbHandle);
PlayerInfo[playerid][pVb] = cache_get_row_int(0, 95, dbHandle);
cache_get_row(0, 96, PlayerInfo[playerid][pWorkBook], dbHandle, 16);
PlayerInfo[playerid][pVIPDate] = cache_get_row_int(0, 97, dbHandle);
PlayerInfo[playerid][cModel][1] = cache_get_row_int(0, 98, dbHandle);
PlayerInfo[playerid][cX][1] = cache_get_row_float(0, 99, dbHandle);
PlayerInfo[playerid][cY][1] = cache_get_row_float(0, 100, dbHandle);
PlayerInfo[playerid][cZ][1] = cache_get_row_float(0, 101, dbHandle);
PlayerInfo[playerid][cFa][1] = cache_get_row_float(0, 102, dbHandle);
PlayerInfo[playerid][cFuel][1] = cache_get_row_int(0, 103, dbHandle);
cache_get_row(0, 104, PlayerInfo[playerid][cNumber2], dbHandle, 64);
PlayerInfo[playerid][cCarAr][1] = cache_get_row_int(0, 105, dbHandle);
PlayerInfo[playerid][cClass][1] = cache_get_row_int(0, 106, dbHandle);
PlayerInfo[playerid][cColor2][0] = cache_get_row_int(0, 107, dbHandle);
PlayerInfo[playerid][cColor2][1] = cache_get_row_int(0, 108, dbHandle);
PlayerInfo[playerid][cLock][1] = cache_get_row_int(0, 109, dbHandle);
PlayerInfo[playerid][cCost][1] = cache_get_row_int(0, 110, dbHandle);
cache_get_row(0, 111, PlayerInfo[playerid][cVehcom2], dbHandle, 64);
PlayerInfo[playerid][cPaintjob][1] = cache_get_row_int(0, 112, dbHandle);
PlayerInfo[playerid][cModel][2] = cache_get_row_int(0, 113, dbHandle);
PlayerInfo[playerid][cX][2] = cache_get_row_float(0, 114, dbHandle);
PlayerInfo[playerid][cY][2] = cache_get_row_float(0, 115, dbHandle);
PlayerInfo[playerid][cZ][2] = cache_get_row_float(0, 116, dbHandle);
PlayerInfo[playerid][cFa][2] = cache_get_row_float(0, 117, dbHandle);
PlayerInfo[playerid][cFuel][2] = cache_get_row_int(0, 118, dbHandle);
cache_get_row(0, 119, PlayerInfo[playerid][cNumber3], dbHandle, 64);
PlayerInfo[playerid][cCarAr][2] = cache_get_row_int(0, 120, dbHandle);
PlayerInfo[playerid][cClass][2] = cache_get_row_int(0, 121, dbHandle);
PlayerInfo[playerid][cColor3][0] = cache_get_row_int(0, 122, dbHandle);
PlayerInfo[playerid][cColor3][1] = cache_get_row_int(0, 123, dbHandle);
PlayerInfo[playerid][cLock][2] = cache_get_row_int(0, 124, dbHandle);
PlayerInfo[playerid][cCost][2] = cache_get_row_int(0, 125, dbHandle);
cache_get_row(0, 126, PlayerInfo[playerid][cVehcom3], dbHandle, 64);
PlayerInfo[playerid][cPaintjob][2] = cache_get_row_int(0, 127, dbHandle);
PlayerInfo[playerid][pCars] = cache_get_row_int(0, 128, dbHandle);
PlayerInfo[playerid][pAdmPass] = cache_get_row_int(0, 129, dbHandle);
PlayerInfo[playerid][pTimeSpec] = cache_get_row_int(0, 130, dbHandle);
PlayerInfo[playerid][pTimeRestart] = cache_get_row_int(0, 131, dbHandle);
PlayerInfo[playerid][pTimeDay] = cache_get_row_int(0, 132, dbHandle);
PlayerInfo[playerid][pKickCount] = cache_get_row_int(0, 133, dbHandle);
PlayerInfo[playerid][pBanCount] = cache_get_row_int(0, 134, dbHandle);
PlayerInfo[playerid][pWarnCount] = cache_get_row_int(0, 135, dbHandle);
PlayerInfo[playerid][pJailCount] = cache_get_row_int(0, 136, dbHandle);
PlayerInfo[playerid][pAnsCount] = cache_get_row_int(0, 137, dbHandle);
cache_get_row(0, 138, PlayerInfo[playerid][pLastVisit], dbHandle, 64);
SendFamily[playerid] = cache_get_row_int(0, 139, dbHandle);
SendAdmin[playerid] = cache_get_row_int(0, 140, dbHandle);
ShowGreenZone[playerid] = cache_get_row_int(0, 141, dbHandle);
ShowLogo[playerid] = cache_get_row_int(0, 142, dbHandle);
ShowVk[playerid] = cache_get_row_int(0, 143, dbHandle);
ShowDate[playerid] = cache_get_row_int(0, 144, dbHandle);
ShowKeys[playerid] = cache_get_row_int(0, 145, dbHandle);
ShowSpeed[playerid] = cache_get_row_int(0, 146, dbHandle);
ShowOgran[playerid] = cache_get_row_int(0, 147, dbHandle);
sscanf(PlayerInfo[playerid][cVehcom1], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms1]);
sscanf(PlayerInfo[playerid][cVehcom2], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms2]);
sscanf(PlayerInfo[playerid][cVehcom3], "p<,>a<i>[14]",PlayerInfo[playerid][cVehcoms3]);
PlayerLogged[playerid] = true;
TimeLogged[playerid] = -1;
if(ShowVk[playerid] == 1) for(new i; i < 4; i++) TextDrawShowForPlayer(playerid, logotip_vk[i]);
if(ShowLogo[playerid] == 1) for(new i; i < 4; i++) TextDrawShowForPlayer(playerid, logotip[i]);
if(ShowDate[playerid] == 1) for(new i; i < 2; i++) TextDrawShowForPlayer(playerid, logotip_data[i]);
sscanf(PlayerInfo[playerid][pTexts], "p<,>a<i>[3]", PlayerInfo[playerid][pText]);
sscanf(PlayerInfo[playerid][pPhones], "p<,>a<i>[3]", PlayerInfo[playerid][pPhone]);
sscanf(PlayerInfo[playerid][pLics], "p<,>a<i>[5]",PlayerInfo[playerid][pLic]);
sscanf(PlayerInfo[playerid][pWorkBook], "p<,>a<i>[6]",PlayerInfo[playerid][pWB]);
new a;
while(a++ < 100) SendClientMessage(playerid, COLOR_LIGHTRED, "");
SendClientMessage(playerid, COLOR_WHITE,"Добро пожаловать на {399AFA}« Old RolePlay »");
if(PlayerInfo[playerid][pAdmin] > 0) AdmLogged[playerid] = true, SendClientMessage(playerid, COLOR_RED, !"Вы являетесь администратором на сервере. Для авторизации в АП используйте команду /alog");
if(PlayerInfo[playerid][pLeader] > 0) SendMes(playerid, COLOR_WHITE, "[Ф] %s приветствует вас как {FF9900}руководителя",FracInfo[PlayerInfo[playerid][pLeader]][fName]);
if(PlayerInfo[playerid][pMember] > 0 && strcmp(PlayerInfo[playerid][pSendername],FracInfo[PlayerInfo[playerid][pMember]][fAssistant],true) == 0) SendMes(playerid, COLOR_YELLOW, "Вы вошли как заместитель: {FF9900}%s",FracInfo[PlayerInfo[playerid][pMember]][fName]);
/* if(gettime() >= PlayerInfo[playerid][pVIPDate])
{
PlayerInfo[playerid][pVIP] = 0;
PlayerInfo[playerid][pVIPDate] = 0;
SendClientMessage(playerid, COLOR_LIGHTRED, "Действие вашего VIP аккаунта закончилось.");
}
else SendClientMessage(playerid, COLOR_GREEN, "{3697E1}— {FFFFFF}Возможности VIP аккаунта активированы, приятной игры!");
PlayerPlaySound(playerid, 30800, 0.0, 0.0, 0.0);*/
/*if(PlayerInfo[playerid][ProverkaIP] != 0)
{
ShowPlayerDialog(playerid, D_CHECKPASS, DIALOG_STYLE_INPUT, "{FA5269}Пароль безопасности","\
{FFFFFF}На Вашем аккаунте была установлена дополнительный пароль при авторизации..\n\
Если Вы забыли пароль, то напишите об этом основателю, предоставив док-ва того,\n\
что именно Вы являетесь владельцем аккаунта. Введите пароль в строчку ниже:", "Далее", "Выход");
return true;
}*/
if (PlayerInfo[playerid][pText][0] == 1)
{
SendClientMessage(playerid, -1, "{F20B36}—{FFFFFF} Вы забыли оплатить за кварплату, ваш дом продали!");
SendClientMessage(playerid, -1, "{F20B36}—{FFFFFF} На ваш банковский счет возвращена стоимость дома по гос-ву");
PlayerInfo[playerid][pText][0] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "", "");
}
if(PlayerInfo[playerid][pText][1] == 1)
{
SendClientMessage(playerid, -1,"{F20B36}—{FFFFFF} Ваш бизнес закрыли в связи с нехваткой ресурсов");
SendClientMessage(playerid, -1,"{F20B36}—{FFFFFF} Бюджет бизнеса зачислен на ваш банковский счет");
PlayerInfo[playerid][pText][1] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s' WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "", "");
}
if(PlayerInfo[playerid][pText][2] == 1)
{
new p = PlayerInfo[playerid][pRefMoney] / 100000;
for(new i = 1; i <= p; i++)
{
GiveMoney(playerid, 100000);
PlayerInfo[playerid][pRefMoney] -= 100000;
}
PlayerInfo[playerid][pText][2] = 0;
format(PlayerInfo[playerid][pTexts], 20, "%i, %i, %i", PlayerInfo[playerid][pText][0], PlayerInfo[playerid][pText][1], PlayerInfo[playerid][pText][2]);
format(query, 256, "UPDATE "TABLE_ACCOUNT" SET text = '%s', refmoney WHERE name = '%s'", PlayerInfo[playerid][pTexts], PlayerInfo[playerid][pRefMoney], PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "", "");
}
if(GetPlayerHouse(playerid))
{
new h = GetPVarInt(playerid, "PlayerHouse");
if(HouseInfo[h][hOplata] < 250) SendClientMessage(playerid, COLOR_RED, "На балансе Вашего дома осталось менее 250 рублей"), SendClientMessage(playerid, COLOR_RED, "Внесите оплату за дом, либо в противном случае, Ваш дом будет продан");
}
new visit_str[128];
format(visit_str, sizeof visit_str, "Old RolePlay: {FFFFFF}Последний вход в аккаунт был выполнен: {DCF58A}< %s >", PlayerInfo[playerid][pLastVisit]);
SendClientMessage(playerid, 0x5BA0D4AA, visit_str);
mysql_format(dbHandle, query, 128, "SELECT * FROM `gdonate_payments` WHERE account = '%s' AND status = '1'", PlayerInfo[playerid][pSendername]);
mysql_tquery(dbHandle, query, "CheckDonatePlayer", "i", playerid);
if(PlayerInfo[playerid][pFightStyle] != 0) SetPlayerFightingStyle(playerid,PlayerInfo[playerid][pFightStyle]);
else SetPlayerFightingStyle(playerid,0);
SetMoney(playerid, PlayerInfo[playerid][pCash]);
ResetWeapon(playerid);
SetPlayerScore(playerid, PlayerInfo[playerid][pLevel]);
if(PlayerInfo[playerid][pWanted] > 0) SetPlayerWantedLevel(playerid, PlayerInfo[playerid][pWanted]);
if(PlayerInfo[playerid][pGunSkill][6] >= NORM_SKILLS_PLAYER) VehRe[playerid] = true;
SetSpawnInfo(playerid, 255, PlayerInfo[playerid][pModel], 0, 0, 0, 1.0, -1, -1, -1, -1, -1, -1);
SpawnPlayer(playerid);
new str123[12];
GetPlayerIp(playerid,str123,12);
format(string, 64, "%s зашел в аккаунт с ip: %s",PlayerInfo[playerid][pSendername],str123);
Log("LogInfo",string);
DeletePVar(playerid,"Acc");
SetPlayerInt(PlayerInfo[playerid][pSendername], "online", 1);
LoadMyCar(playerid);
SetPlayerTeamColor(playerid);
return true;
}