Сохранение аккаунтов.

[kala4iks]

Добрый день дорогие форумчане при создании сохранения столкнулся с таким вопросом как лучше сохронять аккаунт 1 способом или 2.

  Открыть/закрыть

stock SaveAccount(playerid) 
{ 
    if(PlayerLogged[playerid] == false || IsPlayerConnected(playerid) == 0)return 1; 
    { 
        new str[120]; 
        mysql_format(dbHandle,str,sizeof(str),"UPDATE `accounts` SET "); 
        mysql_format(dbHandle,str,sizeof(str),"%s `ip` = '%s',",str,PI[playerid][pIP]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `level` = %d,",str,PI[playerid][pLevel]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `admin` = %d,",str,PI[playerid][pAdmin]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `sex` = %d,",str,PI[playerid][pSex]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `securitycode` = '%i',",str,PI[playerid][pSecurityCode]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `model` = %d,",str,PI[playerid][pModel]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `memberskin` = %d,",str,PI[playerid][pMemberSkin]); 
        if(PI[playerid][pCash] > 100000000 || PI[playerid][pCash] < 0) PI[playerid][pCash] = 0; 
        mysql_format(dbHandle,str,sizeof(str),"%s `cash` = %d,",str,PI[playerid][pCash]); 
        if(PI[playerid][pBank] > 100000000 || PI[playerid][pBank] < 0) PI[playerid][pBank] = 0; 
        mysql_format(dbHandle,str,sizeof(str),"%s `bank` = %d,",str,PI[playerid][pBank]); 
        mysql_format(dbHandle,str,sizeof(str),"%s `mute` = %d,",str,PI[playerid][pMuted]); 
        mysql_format(dbHandle,str,sizeof(str),"%s warn=%d,",str,PI[playerid][pWarn]); 
        mysql_format(dbHandle,str,sizeof(str),"%s leader=%d,",str,PI[playerid][pLeader]); 
        mysql_format(dbHandle,str,sizeof(str),"%s templeader=%d,",str,PI[playerid][pTempLeader]); 
        mysql_format(dbHandle,str,sizeof(str),"%s member=%d,",str,PI[playerid][pMember]); 
        mysql_format(dbHandle,str,sizeof(str),"%s rank=%d,",str,PI[playerid][pRank]); 
        mysql_format(dbHandle,str,sizeof(str),"%s pick=%d,",str,PI[playerid][pPick]); 
        mysql_format(dbHandle,str,sizeof(str),"%s exp=%d,",str,PI[playerid][pExp]); 
        mysql_format(dbHandle,str,sizeof(str),"%s news=%d,",str,PI[playerid][pNews]); 
        mysql_format(dbHandle,str,sizeof(str),"%s crimes=%d,",str,PI[playerid][pCrimes]); 
        mysql_format(dbHandle,str,sizeof(str),"%s wanted=%d,",str,PI[playerid][pWanted]); 
        mysql_format(dbHandle,str,sizeof(str),"%s wantedtime=%d,",str,PI[playerid][pWantedTime]); 
        mysql_format(dbHandle,str,sizeof(str),"%s wantedwho='%s',",str,PI[playerid][pWantedWho]); 
        mysql_format(dbHandle,str,sizeof(str),"%s wantedreason='%s',",str,PI[playerid][pWantedReason]); 
        mysql_format(dbHandle,str,sizeof(str),"%s jail=%d,",str,PI[playerid][pJail]); 
        mysql_format(dbHandle,str,sizeof(str),"%s job=%d,",str,PI[playerid][pJob]); 
        mysql_format(dbHandle,str,sizeof(str),"%s jailtime=%d,",str,PI[playerid][pJailTime]); 
        mysql_format(dbHandle,str,sizeof(str),"%s checktime=%d,",str,PI[playerid][pCheckTime]); 
        mysql_format(dbHandle,str,sizeof(str),"%s drugs=%d,",str,PI[playerid][pDrugs]); 
        mysql_format(dbHandle,str,sizeof(str),"%s patron=%d,",str,PI[playerid][pPatron]); 
        mysql_format(dbHandle,str,sizeof(str),"%s gunamount=%d,",str,PI[playerid][pGunAmount]); 
        mysql_format(dbHandle,str,sizeof(str),"%s heal='%f',",str,PI[playerid][pHeal]); 
        mysql_format(dbHandle,str,sizeof(str),"%s married=%d,",str,PI[playerid][pMarried]); 
        mysql_format(dbHandle,str,sizeof(str),"%s whomarried='%s',",str,PI[playerid][pWhoMarried]); 
        mysql_format(dbHandle,str,sizeof(str),"%s paycheck='%i',",str,PI[playerid][pPayCheck]); 
        mysql_format(dbHandle,str,sizeof(str),"%s charity='%i',",str,PI[playerid][pCharity]); 
        mysql_format(dbHandle,str,sizeof(str),"%s vip='%i',",str,PI[playerid][pVip]); 
        mysql_format(dbHandle,str,sizeof(str),"%s viptime='%i',",str,PI[playerid][pVipTime]); 
        mysql_format(dbHandle,str,sizeof(str),"%s time='%i',",str,PI[playerid][pTime]); 
        mysql_format(dbHandle,str,sizeof(str),"%s fstyle='%i',",str,PI[playerid][pFightStyle]); 
        mysql_format(dbHandle,str,sizeof(str),"%s credits='%i',",str,PI[playerid][pCredits]); 
        mysql_format(dbHandle,str,sizeof(str),"%s totalcredits='%i',",str,PI[playerid][pTotalCredits]); 
        mysql_format(dbHandle,str,sizeof(str),"%s skin1='%i',",str,PI[playerid][pSkin][0]); 
        mysql_format(dbHandle,str,sizeof(str),"%s skin2='%i',",str,PI[playerid][pSkin][1]); 
        mysql_format(dbHandle,str,sizeof(str),"%s skin3='%i',",str,PI[playerid][pSkin][2]); 
        mysql_format(dbHandle,str,sizeof(str),"%s spawnchange='%i',",str,PI[playerid][pSpawnChange]); 
        mysql_format(dbHandle,str,sizeof(str),"%s sdpistol='%i',",str,PI[playerid][pGunSkill][0]); 
        mysql_format(dbHandle,str,sizeof(str),"%s deserteagle='%i',",str,PI[playerid][pGunSkill][1]); 
        mysql_format(dbHandle,str,sizeof(str),"%s shotgun='%i',",str,PI[playerid][pGunSkill][2]); 
        mysql_format(dbHandle,str,sizeof(str),"%s mp5='%i',",str,PI[playerid][pGunSkill][3]); 
        mysql_format(dbHandle,str,sizeof(str),"%s ak47='%i',",str,PI[playerid][pGunSkill][4]); 
        mysql_format(dbHandle,str,sizeof(str),"%s m4='%i',",str,PI[playerid][pGunSkill][5]); 
        mysql_format(dbHandle,str,sizeof(str),"%s pistol='%i',",str,PI[playerid][pGunSkill][6]); 
        mysql_format(dbHandle,str,sizeof(str),"%s microuzi='%i',",str,PI[playerid][pGunSkill][7]); 
        mysql_format(dbHandle,str,sizeof(str),"%s hunger='%i',",str,PI[playerid][pHunger]); 
        mysql_format(dbHandle,str,sizeof(str),"%s healths='%f',",str,PI[playerid][pHealthS]); 
        mysql_format(dbHandle,str,sizeof(str),"%s sportexp='%i',",str,PI[playerid][pSportExp]); 
        mysql_format(dbHandle,str,sizeof(str),"%s online='%i',",str,PI[playerid][pOnline]); 
        mysql_format(dbHandle,str,sizeof(str),"%s zakon='%i',",str,PI[playerid][pZakon]); 
        mysql_format(dbHandle,str,sizeof(str),"%s checkcode='%i',",str,PI[playerid][pCheckCode]); 
        mysql_format(dbHandle,str,sizeof(str),"%s city='%i',",str,PI[playerid][pCity]); 
        mysql_format(dbHandle,str,sizeof(str),"%s bed='%i',",str,PI[playerid][pBed]); 
        mysql_format(dbHandle,str,sizeof(str),"%s watch='%i',",str,PI[playerid][pWatch]); 
        mysql_format(dbHandle,str,sizeof(str),"%s ciggare='%i',",str,PI[playerid][pCiggare]); 
        mysql_format(dbHandle,str,sizeof(str),"%s sprunk='%i',",str,PI[playerid][pSprunk]); 
        mysql_format(dbHandle,str,sizeof(str),"%s mask='%i',",str,PI[playerid][pMask]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phonebalance='%i',",str,PI[playerid][pPhoneBalance]); 
        mysql_format(dbHandle,str,sizeof(str),"%s truckskill='%i',",str,PI[playerid][pTruckSkill]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cModel='%i',",str,PI[playerid][cModel]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cFuel='%i',",str,PI[playerid][cFuel]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cClass='%i',",str,PI[playerid][cClass]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cColor1='%i',",str,PI[playerid][cColor][0]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cColor2='%i',",str,PI[playerid][cColor][1]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cLock='%i',",str,PI[playerid][cLock]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cCost='%i',",str,PI[playerid][cCost]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cVehcom='%s',",str,PI[playerid][cVehcom]); 
        mysql_format(dbHandle,str,sizeof(str),"%s cPaintjob='%i',",str,PI[playerid][cPaintjob]); 
        mysql_format(dbHandle,str,sizeof(str),"%s aptechka='%i',",str,PI[playerid][pAptechka]); 
        mysql_format(dbHandle,str,sizeof(str),"%s Voennik='%i',",str,PI[playerid][pVoennik]); 
        mysql_format(dbHandle,str,sizeof(str),"%s music='%i',",str,PI[playerid][pMusic]); 
        mysql_format(dbHandle,str,sizeof(str),"%s datavhod='%s',",str,date("%dd.%mm.%yyyy",gettime())); 
         format(PI[playerid][pRepcars],16,"%i, %i",PI[playerid][pRepcar][0],PI[playerid][pRepcar][1]); 
        mysql_format(dbHandle,str,sizeof(str),"%s repcar='%s',",str,PI[playerid][pRepcars]); 
        format(PI[playerid][pImproves],32,"%i, %i, %i",PI[playerid][pImprove][0],PI[playerid][pImprove][1],PI[playerid][pImprove][2]); 
        mysql_format(dbHandle,str,sizeof(str),"%s improves='%s',",str,PI[playerid][pImproves]); 
        mysql_format(dbHandle,str,sizeof(str),"%s veh_reg='%i',",str,PI[playerid][pRegVehicle]); 
        mysql_format(dbHandle,str,sizeof(str),"%s fishki='%i',",str,PI[playerid][pFishki]); 
        mysql_format(dbHandle,str,sizeof(str),"%s bSpawnMesto = '%i',",str,PI[playerid][pSpawnMesto]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phonenumber='%i',",str,PI[playerid][pPhoneNumber]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber1='%i',",str,PhoneNumbers[playerid][0]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber2='%i',",str,PhoneNumbers[playerid][1]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber3='%i',",str,PhoneNumbers[playerid][2]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber4='%i',",str,PhoneNumbers[playerid][3]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber5='%i',",str,PhoneNumbers[playerid][4]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber6='%i',",str,PhoneNumbers[playerid][5]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber7='%i',",str,PhoneNumbers[playerid][6]); 
        mysql_format(dbHandle,str,sizeof(str),"%s phnumber8='%i',",str,PhoneNumbers[playerid][7]); 
        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]); 
        mysql_format(dbHandle,str,sizeof(str),"%s lic='%s' WHERE name = '%s' LIMIT 1",str,PI[playerid][pLics],GetName(playerid)); 
         mysql_tquery(dbHandle,str,"",""); 
     } 
    return 1; 
}  

  Открыть/закрыть

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),"charity='%i',",PI[playerid][pCharity]); 
    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",PI[playerid][pImprove][0],PI[playerid][pImprove][1],PI[playerid][pImprove][2]); 
    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)," WHERE name='%s' LIMIT 1",GetName(playerid)); 
    strcat(query,src,sizeof(query)); 
     mysql_tquery(dbHandle, query, "", ""); 
    return 1; 
}  

[wAx]

http://pro-pawn.ru/showthread.php?13...�-mysql_format

mysql_format логичнее использовать для проверки на SQL иньекции