Huseyn
Компетентный
Все привет! ребята у меня проблема с saveacc не сохраняются деньги...
вот код:
вот код:
PHP:
PI[playerid][pID] = cache_get_row_int(0, 0, dbHandle); // id
//cache_get_row(0, 2, PI[playerid][pPassword], dbHandle, 32); // password
cache_get_row(0, 3, PI[playerid][pLastIP], dbHandle, 16); // ip
cache_get_row(0, 4, PI[playerid][pNumberVehicle], dbHandle, 20); // veh_number
PI[playerid][pRegVehicle] = cache_get_row_int(0, 5, dbHandle); // veh_reg
PI[playerid][pAdmin] = cache_get_row_int(0, 6, dbHandle); // admin
PI[playerid][pSecurityCode] = cache_get_row_int(0, 7, dbHandle); // securitycode
PI[playerid][pCheckCode] = cache_get_row_int(0, 8, dbHandle); // checkcode
cache_get_row(0, 9, PI[playerid][pMail], dbHandle, 64); // mail
PI[playerid][pLevel] = cache_get_row_int(0, 10, dbHandle); // level
PI[playerid][pCash] = cache_get_row_int(0, 11, dbHandle); // cash
PI[playerid][pBank] = cache_get_row_int(0, 12, dbHandle); // bank
PI[playerid][pExp] = cache_get_row_int(0, 13, dbHandle); // exp
cache_get_row(0, 14, PI[playerid][pRegIP], dbHandle, 16); // regip
cache_get_row(0, 15, PI[playerid][pRegData], dbHandle, 15); // datareg
PI[playerid][pLeader] = cache_get_row_int(0, 16, dbHandle); // leader
PI[playerid][pTempLeader] = cache_get_row_int(0, 17, dbHandle); // templeader
PI[playerid][pMember] = cache_get_row_int(0, 18, dbHandle); // member
PI[playerid][pRank] = cache_get_row_int(0, 19, dbHandle); // rank
PI[playerid][pWarn] = cache_get_row_int(0, 20, dbHandle); // warn
PI[playerid][pSex] = cache_get_row_int(0, 21, dbHandle); // sex
PI[playerid][pAge] = cache_get_row_int(0, 22, dbHandle); // age
PI[playerid][pModel] = cache_get_row_int(0, 23, dbHandle); // model
PI[playerid][pMemberSkin] = cache_get_row_int(0, 24, dbHandle); // memberskin
cache_get_row(0, 25, PI[playerid][pLics], dbHandle, 16); // lic
PI[playerid][pMuted] = cache_get_row_int(0, 28, dbHandle); // mute
PI[playerid][pPick] = cache_get_row_int(0, 29, dbHandle); // pick
PI[playerid][pCheckTime] = cache_get_row_int(0, 30, dbHandle); //checktime
PI[playerid][pNews] = cache_get_row_int(0, 31, dbHandle); // news
//PI[playerid][pPhone] = cache_get_row_int(0, 32, dbHandle); // phone
PI[playerid][pPhoneNumber] = cache_get_row_int(0, 33, dbHandle); // phonenumber
cache_get_row(0, 34, PI[playerid][pTexts], dbHandle, 20); // text
PI[playerid][pJail] = cache_get_row_int(0, 35, dbHandle); // jail
PI[playerid][pJailTime] = cache_get_row_int(0, 36, dbHandle); // jailtime
PI[playerid][pWanted] = cache_get_row_int(0, 37, dbHandle); // wanted
PI[playerid][pWantedTime] = cache_get_row_int(0, 38, dbHandle); // wantedtime
cache_get_row(0, 39, PI[playerid][pWantedWho], dbHandle, MAX_PLAYER_NAME); // wantedwho
cache_get_row(0, 40, PI[playerid][pWantedReason], dbHandle, 32); // wantedreason
PI[playerid][pHeal] = cache_get_row_float(0, 41, dbHandle); // heal
PI[playerid][pDrugs] = cache_get_row_int(0, 42, dbHandle); // drugs
PI[playerid][pPatron] = cache_get_row_int(0, 43, dbHandle); // patron
PI[playerid][pGunAmount] = cache_get_row_int(0, 44, dbHandle); // gunamount
PI[playerid][pCrimes] = cache_get_row_int(0, 45, dbHandle); // crimes
PI[playerid][pJob] = cache_get_row_int(0, 46, dbHandle); // job
PI[playerid][pMarried] = cache_get_row_int(0, 47, dbHandle); // married
cache_get_row(0, 48, PI[playerid][pWhoMarried], dbHandle, MAX_PLAYER_NAME); // whomarried
cache_get_row(0, 49, PI[playerid][pReferal], dbHandle, MAX_PLAYER_NAME); // referal
PI[playerid][pRefMoney] = cache_get_row_int(0, 50, dbHandle); // refmoney
PI[playerid][pPayCheck] = cache_get_row_int(0, 51, dbHandle); // paycheck
PI[playerid][pCharity] = cache_get_row_int(0, 52, dbHandle); // charity
PI[playerid][pVip] = cache_get_row_int(0, 53, dbHandle); // vip
PI[playerid][pVipTime] = cache_get_row_int(0, 54, dbHandle); // viptime
PI[playerid][pTime] = cache_get_row_int(0, 55, dbHandle); // time
//PI[playerid][pAdminTime] = cache_get_row_int(0, 56, dbHandle); // admintime
PI[playerid][pFightStyle] = cache_get_row_int(0, 57, dbHandle); // fstyle
PI[playerid][pCredits] = cache_get_row_int(0, 58, dbHandle); // credits
PI[playerid][pTotalCredits] = cache_get_row_int(0, 59, dbHandle); // totalcredits
PI[playerid][pSkin][0] = cache_get_row_int(0, 60, dbHandle); // skin1
PI[playerid][pSkin][1] = cache_get_row_int(0, 61, dbHandle); // skin2
PI[playerid][pSkin][2] = cache_get_row_int(0, 62, dbHandle); // skin3
PI[playerid][pSpawnChange] = cache_get_row_int(0, 63, dbHandle); // spawnchange
PI[playerid][pGunSkill][0] = cache_get_row_int(0, 64, dbHandle); // sdpistol
PI[playerid][pGunSkill][1] = cache_get_row_int(0, 65, dbHandle); // deserteagle
PI[playerid][pGunSkill][2] = cache_get_row_int(0, 66, dbHandle); // shotgun
PI[playerid][pGunSkill][3] = cache_get_row_int(0, 67, dbHandle); // mp5
PI[playerid][pGunSkill][4] = cache_get_row_int(0, 68, dbHandle); // ak47
PI[playerid][pGunSkill][5] = cache_get_row_int(0, 69, dbHandle); // m4
PI[playerid][pGunSkill][6] = cache_get_row_int(0, 70, dbHandle); // pistol
PI[playerid][pGunSkill][7] = cache_get_row_int(0, 71, dbHandle); // microuzi
PI[playerid][pHunger] = cache_get_row_int(0, 72, dbHandle); // hunger
PI[playerid][pHealthS] = cache_get_row_int(0, 73, dbHandle); // healths
PI[playerid][pSportExp] = cache_get_row_int(0, 74, dbHandle); // sportexp
PI[playerid][pOnline] = cache_get_row_int(0, 75, dbHandle); // online
PI[playerid][pZakon] = cache_get_row_int(0, 76, dbHandle); // zakon
PI[playerid][pCity] = cache_get_row_int(0, 77, dbHandle); // city
cache_get_row(0, 78, PI[playerid][pRepcars], dbHandle, 16); // repcar
PI[playerid][pBed] = cache_get_row_int(0, 79, dbHandle); // bed
PI[playerid][pWatch] = cache_get_row_int(0, 80, dbHandle); // watch
PI[playerid][pCiggare] = cache_get_row_int(0, 81, dbHandle); // ciggare
PI[playerid][pSprunk] = cache_get_row_int(0, 82, dbHandle); // sprunk
PI[playerid][pMask] = cache_get_row_int(0, 83, dbHandle); // mask
PI[playerid][pPhoneBalance] = cache_get_row_int(0, 84, dbHandle); // phonebalance
PI[playerid][pTruckSkill] = cache_get_row_int(0, 85, dbHandle); // truckskill
PI[playerid][cModel] = cache_get_row_int(0, 86, dbHandle); // cModel
PI[playerid][cClass] = cache_get_row_int(0, 87, dbHandle); // cClass
PI[playerid][cFuel] = cache_get_row_int(0, 88, dbHandle); // cFuel
PI[playerid][cColor][0] = cache_get_row_int(0, 89, dbHandle); // cColor1
PI[playerid][cColor][1] = cache_get_row_int(0, 90, dbHandle); // cColor2
PI[playerid][cLock] = cache_get_row_int(0, 91, dbHandle); // cLock
PI[playerid][cCost] = cache_get_row_int(0, 92, dbHandle); // cCost
cache_get_row(0, 93, PI[playerid][cVehcom], dbHandle, 64); // cVehcom
PI[playerid][cPaintjob] = cache_get_row_int(0, 94, dbHandle); // cPaintjob
PI[playerid][pAptechka] = cache_get_row_int(0, 95, dbHandle); // aptechka
PI[playerid][pVoennik] = cache_get_row_int(0, 96, dbHandle); // Voennik
PI[playerid][pMusic] = cache_get_row_int(0, 97, dbHandle); // music
cache_get_row(0, 98, PI[playerid][pImproves], dbHandle, 32); // improves
PI[playerid][pSettings] = cache_get_row_int(0, 100, dbHandle); // settings
PhoneNumbers[playerid][0] = cache_get_row_int(0, 101, dbHandle); // phnumber1
PhoneNumbers[playerid][1] = cache_get_row_int(0, 102, dbHandle); // phnumber2
PhoneNumbers[playerid][2] = cache_get_row_int(0, 103, dbHandle); // phnumber3
PhoneNumbers[playerid][3] = cache_get_row_int(0, 104, dbHandle); // phnumber4
PhoneNumbers[playerid][4] = cache_get_row_int(0, 105, dbHandle); // phnumber5
PhoneNumbers[playerid][5] = cache_get_row_int(0, 106, dbHandle); // phnumber6
PhoneNumbers[playerid][6] = cache_get_row_int(0, 107, dbHandle); // phnumber7
PhoneNumbers[playerid][7] = cache_get_row_int(0, 108, dbHandle); // phnumber8
//PI[playerid][pVehicleKey] = cache_get_row_int(0, 109, dbHandle); // vehiclekey
PI[playerid][pMailConfirmed] = cache_get_row_int(0, 110, dbHandle); // mailconf
PI[playerid][pFishki] = cache_get_row_int(0, 111, dbHandle); // fishki pMoney,
PI[playerid][pFWarns] = cache_get_row_int(0, 112, dbHandle); //FWarns / БАЗА ДАННЫХ ТУТ2!![/HTML]
[HTML]stock SaveAccount(playerid)
{
if(PlayerLogged[playerid] == false || IsPlayerConnected(playerid) == 0) return 1;
new src[90];
format(query,sizeof(query),"UPDATE "T_ACCOUNTS" SET ");
format(src,sizeof(src),"ip='%s',",PI[playerid][pIP]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"level=%d,",PI[playerid][pLevel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"admin=%d,",PI[playerid][pAdmin]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sex=%d,",PI[playerid][pSex]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"age=%d,",PI[playerid][pAge]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"securitycode='%i',",PI[playerid][pSecurityCode]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"model=%d,",PI[playerid][pModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"memberskin=%d,",PI[playerid][pMemberSkin]);
strcat(query,src,sizeof(query));
if(PI[playerid][pCash] > 100000000 || PI[playerid][pCash] < 0) PI[playerid][pCash] = 0;
format(src,sizeof(src),"cash=%d,",PI[playerid][pCash]);
strcat(query,src,sizeof(query));
if(PI[playerid][pBank] > 100000000 || PI[playerid][pBank] < 0) PI[playerid][pBank] = 0;
format(src,sizeof(src),"bank=%d,",PI[playerid][pBank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mute=%d,",PI[playerid][pMuted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"warn=%d,",PI[playerid][pWarn]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"leader=%d,",PI[playerid][pLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"templeader=%d,",PI[playerid][pTempLeader]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"member=%d,",PI[playerid][pMember]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"rank=%d,",PI[playerid][pRank]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pick=%d,",PI[playerid][pPick]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"exp=%d,",PI[playerid][pExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"news=%d,",PI[playerid][pNews]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"crimes=%d,",PI[playerid][pCrimes]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wanted=%d,",PI[playerid][pWanted]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedtime=%d,",PI[playerid][pWantedTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedwho='%s',",PI[playerid][pWantedWho]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"wantedreason='%s',",PI[playerid][pWantedReason]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"jail=%d,",PI[playerid][pJail]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"job=%d,",PI[playerid][pJob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"jailtime=%d,",PI[playerid][pJailTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checktime=%d,",PI[playerid][pCheckTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"drugs=%d,",PI[playerid][pDrugs]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"patron=%d,",PI[playerid][pPatron]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"gunamount=%d,",PI[playerid][pGunAmount]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"heal='%f',",PI[playerid][pHeal]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"married=%d,",PI[playerid][pMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"whomarried='%s',",PI[playerid][pWhoMarried]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"paycheck='%i',",PI[playerid][pPayCheck]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"vip='%i',",PI[playerid][pVip]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"viptime='%i',",PI[playerid][pVipTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"time='%i',",PI[playerid][pTime]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fstyle='%i',",PI[playerid][pFightStyle]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"credits='%i',",PI[playerid][pCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"totalcredits='%i',",PI[playerid][pTotalCredits]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin1='%i',",PI[playerid][pSkin][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin2='%i',",PI[playerid][pSkin][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"skin3='%i',",PI[playerid][pSkin][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"spawnchange='%i',",PI[playerid][pSpawnChange]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sdpistol='%i',",PI[playerid][pGunSkill][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"deserteagle='%i',",PI[playerid][pGunSkill][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"shotgun='%i',",PI[playerid][pGunSkill][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mp5='%i',",PI[playerid][pGunSkill][3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ak47='%i',",PI[playerid][pGunSkill][4]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"m4='%i',",PI[playerid][pGunSkill][5]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"pistol='%i',",PI[playerid][pGunSkill][6]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"microuzi='%i',",PI[playerid][pGunSkill][7]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"hunger='%i',",PI[playerid][pHunger]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"healths='%f',",PI[playerid][pHealthS]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sportexp='%i',",PI[playerid][pSportExp]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"online='%i',",PI[playerid][pOnline]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"zakon='%i',",PI[playerid][pZakon]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"checkcode='%i',",PI[playerid][pCheckCode]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"city='%i',",PI[playerid][pCity]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"bed='%i',",PI[playerid][pBed]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"watch='%i',",PI[playerid][pWatch]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"ciggare='%i',",PI[playerid][pCiggare]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"sprunk='%i',",PI[playerid][pSprunk]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"mask='%i',",PI[playerid][pMask]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phonebalance='%i',",PI[playerid][pPhoneBalance]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"truckskill='%i',",PI[playerid][pTruckSkill]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cModel='%i',",PI[playerid][cModel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cFuel='%i',",PI[playerid][cFuel]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cClass='%i',",PI[playerid][cClass]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor1='%i',",PI[playerid][cColor][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cColor2='%i',",PI[playerid][cColor][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cLock='%i',",PI[playerid][cLock]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cCost='%i',",PI[playerid][cCost]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cVehcom='%s',",PI[playerid][cVehcom]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"cPaintjob='%i',",PI[playerid][cPaintjob]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"aptechka='%i',",PI[playerid][pAptechka]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"Voennik='%i',",PI[playerid][pVoennik]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"music='%i',",PI[playerid][pMusic]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"datavhod='%s',",date("%dd.%mm.%yyyy",gettime()));
strcat(query,src,sizeof(query));
format(PI[playerid][pRepcars],16,"%i, %i",PI[playerid][pRepcar][0],PI[playerid][pRepcar][1]);
format(src,sizeof(src),"repcar='%s',",PI[playerid][pRepcars]);
strcat(query,src,sizeof(query));
format(PI[playerid][pImproves],32,"%i, %i, %i, %i",PI[playerid][pImprove][0],PI[playerid][pImprove][1],PI[playerid][pImprove][2],PI[playerid][pImprove][3]);
format(src,sizeof(src),"improves='%s',",PI[playerid][pImproves]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"veh_reg='%i',",PI[playerid][pRegVehicle]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"fishki='%i',",PI[playerid][pFishki]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phonenumber='%i',",PI[playerid][pPhoneNumber]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber1='%i',",PhoneNumbers[playerid][0]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber2='%i',",PhoneNumbers[playerid][1]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber3='%i',",PhoneNumbers[playerid][2]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber4='%i',",PhoneNumbers[playerid][3]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber5='%i',",PhoneNumbers[playerid][4]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber6='%i',",PhoneNumbers[playerid][5]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber7='%i',",PhoneNumbers[playerid][6]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"phnumber8='%i',",PhoneNumbers[playerid][7]);
strcat(query,src,sizeof(query));
format(PI[playerid][pLics],16,"%i, %i, %i, %i",PI[playerid][pLic][0],PI[playerid][pLic][1],PI[playerid][pLic][2],PI[playerid][pLic][3]);
format(src,sizeof(src),"lic='%s'",PI[playerid][pLics]);
strcat(query,src,sizeof(query));
format(src,sizeof(src),"FWarns='%i',",PI[playerid][pFWarns]); // БАЗА ДАННЫХ ТУТ!
strcat(query,src,sizeof(query));
format(src,sizeof(src)," WHERE name='%s' LIMIT 1",GetName(playerid));
strcat(query,src,sizeof(query));
mysql_tquery(dbHandle, query, "", "");
return 1;
}
Последнее редактирование модератором: