15.05.2015, 04:51
Всем привет 
. Ребят, помогите решить проблесу с сохранением аккаунтов.
Ошибка в логе:
. Ребят, помогите решить проблесу с сохранением аккаунтов.PHP код:
stock SaveAcc(playerid)
{
if(gPlayerLogged[playerid] == 1 && IsPlayerConnected(playerid))
{
new str[2048];
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pLevel` = '%d',`pPhousekey` = '%d',`pPbiskey` = '%d',`pPsbiskey` = '%d',`pAdmin` = '%d',`pFuelcar` = '%f',`pCar` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pLevel],
PlayerInfo[playerid][pPhousekey], PlayerInfo[playerid][pPbiskey],
PlayerInfo[playerid][pPsbiskey], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pFuelcar], PlayerInfo[playerid][pCar],
PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pDonateMoney` = '%d', `pDonateAdd` = '%d', `pDonateRank` = '%d',`pReg` = '%d',`pSex` = '%d',`pMuted` = '%d',`pExp` = '%d',`pCash` = '%d',`pJailed` = '%d',`pJailTime` = '%d',`pMats` = '%d',`pDrugs` = '%d',`pLeader` = '%d',`pMember` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pDonateMoney],PlayerInfo[playerid][pDonateAdd],
PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][pReg],PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pMuted],PlayerInfo[playerid][pExp],PlayerInfo[playerid][pCash],
PlayerInfo[playerid][pJailed],PlayerInfo[playerid][pJailTime],
PlayerInfo[playerid][pMats],PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLeader],PlayerInfo[playerid][pMember],
PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pRank` = '%d',`pJob` = '%d',`pVodPrava` = '%d',`pBizLic` = '%d',`pFlyLic` = '%d',`pBoatLic` = '%d',`pFishLic` = '%d',`pGunLic` = '%d', `pTelefon` = '%d', `pNarcoZavisimost` = '%d', `pNarcoLomka` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pRank], PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pVodPrava], PlayerInfo[playerid][pBizLic],
PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic],
PlayerInfo[playerid][pFishLic], PlayerInfo[playerid][pGunLic],
PlayerInfo[playerid][pTelefon], PlayerInfo[playerid][pNarcoZavisimost],
PlayerInfo[playerid][pNarcoLomka], PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pSDPistol` = '%d',`pDesertEagle` = '%d',`pShotGun` = '%d',`pMP5` = '%d',`pAK47` = '%d',`pM4` = '%d',`pChar` = '%d',`pModel` = '%d',`pProz` = '%d',`pOgran` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pSDPistol], PlayerInfo[playerid][pDesertEagle], PlayerInfo[playerid][pShotGun],
PlayerInfo[playerid][pMP5], PlayerInfo[playerid][pAK47],
PlayerInfo[playerid][pM4], PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pModel], PlayerInfo[playerid][pProz],
PlayerInfo[playerid][pOgran], PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pPnumber` = '%d',`pPayDayHad` = '%d',`pWarns` = '%d',`punWarns` = '%d',`punWarnstime` = '%d',`pFuel` = '%d',`pExitTied` = '%d',`pExitTiedNomer` = '%d',`pGrabSkill` = '%d',`pGrabTime` = '%d',`pReportTime` = '%d',`pAutoTime` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pPnumber], PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pWarns], PlayerInfo[playerid][punWarns],
PlayerInfo[playerid][punWarnstime], PlayerInfo[playerid][pFuel],PlayerInfo[playerid][pExitTied],
PlayerInfo[playerid][pExitTiedNomer], PlayerInfo[playerid][pGrabSkill],
PlayerInfo[playerid][pGrabTime], PlayerInfo[playerid][pReportTime], PlayerInfo[playerid][pAutoTime],
PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pAutoSkill` = '%d',`pMarried` = '%d',`pMuteTime` = '%d',`pMobile` = '%d',`pBank` = '%d',`pBoxSkill` = '%d',`pKongfuSkill` = '%d',`pKickboxSkill` = '%d',`pFightSkill` = '%d',`pFightSkil` = '%d',`pFightTime` = '%d',`pDostup` = '%d',`pEat`= '%d',`pZakonp` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pAutoSkill], PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pMuteTime], PlayerInfo[playerid][pMobile], PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pBoxSkill], PlayerInfo[playerid][pKongfuSkill],
PlayerInfo[playerid][pKickboxSkill], PlayerInfo[playerid][pFightSkill],
PlayerInfo[playerid][pFightSkil], PlayerInfo[playerid][pFightTime],
PlayerInfo[playerid][pDostup], PlayerInfo[playerid][pEat], PlayerInfo[playerid][pZakonp],
PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pVipTime` = '%d',`pVipData` = '%d',`pProz` = '%d',`pKolesocar` = '%d',`pPokraska` = '%d',`pSpoiler` = '%d',`pHood` = '%d',`pExhaust` = '%d',`pLamps` = '%d',`pSideskirt` = '%d',`pVozdyx` = '%d',`pVcol1` = '%d',`pVcol2` = '%d',`pBamper1` = '%d',`pBamper2` = '%d' WHERE `Name` = '%s'",
PlayerInfo[playerid][pVipTime], PlayerInfo[playerid][pVipData], PlayerInfo[playerid][pProz],
PlayerInfo[playerid][pKolesocar], PlayerInfo[playerid][pPokraska],
PlayerInfo[playerid][pSpoiler], PlayerInfo[playerid][pHood],
PlayerInfo[playerid][pExhaust], PlayerInfo[playerid][pLamps],
PlayerInfo[playerid][pSideskirt], PlayerInfo[playerid][pVozdyx],
PlayerInfo[playerid][pVcol1], PlayerInfo[playerid][pVcol2],
PlayerInfo[playerid][pBamper1], PlayerInfo[playerid][pBamper2],
PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
mysql_format(dbHandle, str, sizeof(str), "UPDATE `accounts` SET `pIp` = '%s',`pNitro` = '%d',`pGidra` = '%d',`pMestoJail` = '%d',`pWanted` = '%d',`pHousecash` = '%d',`pTut` = '%d',`pNumbercar` = '%s',`pIpReg` = '%s',`pCheckKey` = '%d',`pBans` = '%d',`pReports` = '%d',`pWarnings` = '%d',`pKicks` = '%d' WHERE `Name` = '%s'",str,
PlayerInfo[playerid][pIp], PlayerInfo[playerid][pNitro],PlayerInfo[playerid][pGidra],PlayerInfo[playerid][pMestoJail],
PlayerInfo[playerid][pWanted], PlayerInfo[playerid][pHousecash],
PlayerInfo[playerid][pTut], PlayerInfo[playerid][pNumbercar],
PlayerInfo[playerid][pBans], PlayerInfo[playerid][pReports], PlayerInfo[playerid][pWarnings], PlayerInfo[playerid][pKicks],
PlayerInfo[playerid][pIpReg], PlayerInfo[playerid][pCheckKey], PlayerInfo[playerid][pName]);
mysql_tquery(dbHandle, str);
}
return 1;
}
Ошибка в логе:
PHP код:
[07:53:35] [ERROR] CMySQLQuery::Execute[] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0',`pVipData` = '0',`pProz` = '100',`pKolesocar` = '0',`pPokraska` = '255',`pSpo' at line 1
