Доступ к архиву

Переход в группу "Пользователь"

300.00 ₽
Одноразовый платёж
Быстрый переход в группу "Пользователи", без надобности написания постов и ожидания.

Покупка дает возможность:
Быть полноправным участником форума
Нормальное копирование кода
Создавать темы
Скачивать файлы
Доступ к архиву Pawno-Info

Ошибка в mysql syntax

Статус
В этой теме нельзя размещать новые ответы.
Егорчик

Егорчик

Специалист
Добрый вечер.Может кто найдёт ошибку. Версия Mysql r38


new src[60];
new query[2900];
new sendername[MAX_PLAYER_NAME];
GetPlayerName(x, sendername, sizeof(sendername));
new year, month, day;
getdate(year, month, day);
new strstre[100];
format(strstre,sizeof(strstre), "%d/%d/%d",day,month,year);
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
PlayerInfo[x][pCash] = GetSRVMoney(x);
format(src,sizeof(src),"pLevel=%d,",PlayerInfo[x][pLevel]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pAdmin=%d,",PlayerInfo[x][pAdmin]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pHelper=%d,",PlayerInfo[x][pHelper]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pPlaceJail=%d,",PlayerInfo[x][pPlaceJail]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pIp='%s',",PlayerInfo[x][pIp]);strcat(query,src,sizeof(query));//
format(src,sizeof(src),"pvIp='%s',",PlayerInfo[x][pvIp]);strcat(query,src,sizeof(query));//
format(src,sizeof(src),"pIpReg='%s',",PlayerInfo[x][pIpReg]);strcat(query,src,sizeof(query));//
format(src,sizeof(src),"pHousecash=%d,",PlayerInfo[x][pHousecash]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pCheckip=%d,",PlayerInfo[x][pCheckip]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pText=%d,",PlayerInfo[x][pText]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pKeyip=%d,",PlayerInfo[x][pKeyip]);strcat(query,src,sizeof(query));
format(src,sizeof(src),"pHP=%d,",PlayerInfo[x]
PHP: 
);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pSatiety=%d,",PlayerInfo[x][pSatiety]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pDataReg='%s',",PlayerInfo[x][pDataReg]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pCar=%d,",PlayerInfo[x][pCar]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pFuelCar=%f,",PlayerInfo[x][pFuelCar]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pProcents=%d,",PlayerInfo[x][pProcents]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pDonateRank=%d,",PlayerInfo[x][pDonateRank]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pDonateMoney=%d,",PlayerInfo[x][pDonateMoney]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pReg=%d,",PlayerInfo[x][pReg]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pMaterials=%d,",PlayerInfo[x][pMaterials]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pSex=%d,",PlayerInfo[x][pSex]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pArrested=%d,",PlayerInfo[x][pArrested]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pMuted=%d,",PlayerInfo[x][pMuted]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pCrimes=%d,",PlayerInfo[x][pCrimes]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pExp=%d,",PlayerInfo[x][pExp]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pCash=%d,",PlayerInfo[x][pCash]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pKills=%d,",PlayerInfo[x][pKills]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pDeaths=%d,",PlayerInfo[x][pDeaths]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pWantedDeaths=%d,",PlayerInfo[x][pWantedDeaths]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pPayCheck=%d,",PlayerInfo[x][pPayCheck]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pJailed=%d,",PlayerInfo[x][pJailed]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pJailTime=%d,",PlayerInfo[x][pJailTime]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pWins=%d,",PlayerInfo[x][pWins]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pLoses=%d,",PlayerInfo[x][pLoses]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pCDPlayer=%d,",PlayerInfo[x][pCDPlayer]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pDrugs=%d,",PlayerInfo[x][pDrugs]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pLeader=%d,",PlayerInfo[x][pLeader]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pMember=%d,",PlayerInfo[x][pMember]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pRank=%d,",PlayerInfo[x][pRank]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pChar=%d,",PlayerInfo[x][pChar]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pJob=%d,",PlayerInfo[x][pJob]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pInt=%d,",PlayerInfo[x][pInt]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pLocal=%d,",PlayerInfo[x][pLocal]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pModel=%d,",PlayerInfo[x][pModel]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pPnumber=%d,",PlayerInfo[x][pPnumber]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pPhoneBook=%d,",PlayerInfo[x][pPhoneBook]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pDirectory=%d,",PlayerInfo[x][pDirectory]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pVhoddata=%d,",PlayerInfo[x][pVhoddata]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pVhodMes=%d,",PlayerInfo[x][pVhodMes]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pVhodchas=%d,",PlayerInfo[x][pVhodchas]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pVhodminute=%d,",PlayerInfo[x][pVhodminute]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pCarLic=%d,",PlayerInfo[x][pCarLic]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pFlyLic=%d,",PlayerInfo[x][pFlyLic]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pBoatLic=%d,",PlayerInfo[x][pBoatLic]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pFishLic=%d,",PlayerInfo[x][pFishLic]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pGunLic=%d,",PlayerInfo[x][pGunLic]);strcat(query,src,sizeof(query));
	format(src,sizeof(src),"pBisLic=%d,",PlayerInfo[x][pBisLic]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pNkeys=%d,",PlayerInfo[x][pNkeys]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pPHousekey=%d,",PlayerInfo[x][pPHousekey]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pPBiskey=%d,",PlayerInfo[x][pPBiskey]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pAutoMast=%d,",PlayerInfo[x][pAutoMast]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pLabiding=%d,",PlayerInfo[x][pLabiding]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pAddiction=%d,",PlayerInfo[x][pAddiction]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pPayDay=%d,",PlayerInfo[x][pPayDay]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pPayDayHad=%d,",PlayerInfo[x][pPayDayHad]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTut=%d,",PlayerInfo[x][pTut]);strcat(query,src,sizeof(query));//
    format(src,sizeof(src),"pWarns=%d,",PlayerInfo[x][pWarns]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"punWarns=%d,",PlayerInfo[x][punWarns]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"punWarnstime=%d,",PlayerInfo[x][punWarnstime]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pFuel=%d,",PlayerInfo[x][pFuel]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pMarried=%d,",PlayerInfo[x][pMarried]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pMarriedTo='%s',",PlayerInfo[x][pMarriedTo]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pMushrooms=%d,",PlayerInfo[x][pMushrooms]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTicket=%d,",PlayerInfo[x][pTicket]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTicketNr[0]=%d,",PlayerInfo[playerid][pTicketNr][0]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTicketNr[1]=%d,",PlayerInfo[playerid][pTicketNr][1]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTicketNr[2]=%d,",PlayerInfo[playerid][pTicketNr][2]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTicketWin=%d,",PlayerInfo[x][pTicketWin]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pRadio=%d,",PlayerInfo[x][pRadio]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pFishes=%d,",PlayerInfo[x][pFishes]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pFriendMoney=%d,",PlayerInfo[x][pFriendMoney]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pMuteTime=%d,",PlayerInfo[x][pMuteTime]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pBank=%d,",PlayerInfo[x][pBank]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pKazpay=%d,",PlayerInfo[x][pKazpay]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDonateAccount=%d,",PlayerInfo[x][pDonateAccount]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pMobile=%d,",PlayerInfo[x][pMobile]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDostup=%d,",PlayerInfo[x][pDostup]);strcat(query,src,sizeof(query));//
    format(src,sizeof(src),"pLocked=%d,",PlayerInfo[x][pLocked]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDebt=%d,",PlayerInfo[x][pDebt]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pMafiaRoof=%d,",PlayerInfo[x][pMafiaRoof]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pUseMafiaRoof=%d,",PlayerInfo[x][pUseMafiaRoof]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pWantedLevel=%d,",PlayerInfo[x][pWantedLevel]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pAntiCheat=%d,",PlayerInfo[x][pAntiCheat]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[0]=%d,",PlayerInfo[x][pSlot][0]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[1]=%d,",PlayerInfo[x][pSlot][1]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[2]=%d,",PlayerInfo[x][pSlot][2]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[3]=%d,",PlayerInfo[x][pSlot][3]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[4]=%d,",PlayerInfo[x][pSlot][4]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[5]=%d,",PlayerInfo[x][pSlot][5]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[6]=%d,",PlayerInfo[x][pSlot][6]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[7]=%d,",PlayerInfo[x][pSlot][7]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[8]=%d,",PlayerInfo[x][pSlot][8]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[9]=%d,",PlayerInfo[x][pSlot][9]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[10]=%d,",PlayerInfo[x][pSlot][10]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[11]=%d,",PlayerInfo[x][pSlot][11]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlot[12]=%d,",PlayerInfo[x][pSlot][12]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[0]=%d,",PlayerInfo[x][pSlotammo][0]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[1]=%d,",PlayerInfo[x][pSlotammo][1]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[2]=%d,",PlayerInfo[x][pSlotammo][2]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[3]=%d,",PlayerInfo[x][pSlotammo][3]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[4]=%d,",PlayerInfo[x][pSlotammo][4]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[5]=%d,",PlayerInfo[x][pSlotammo][5]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[6]=%d,",PlayerInfo[x][pSlotammo][6]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[7]=%d,",PlayerInfo[x][pSlotammo][7]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[8]=%d,",PlayerInfo[x][pSlotammo][8]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[9]=%d,",PlayerInfo[x][pSlotammo][9]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[10]=%d,",PlayerInfo[x][pSlotammo][10]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[11]=%d,",PlayerInfo[x][pSlotammo][11]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSlotammo[12]=%d,",PlayerInfo[x][pSlotammo][12]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pGunSkill[0]=%d,",PlayerInfo[x][pGunSkill][0]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pGunSkill[1]=%d,",PlayerInfo[x][pGunSkill][1]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pGunSkill[2]=%d,",PlayerInfo[x][pGunSkill][2]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pGunSkill[3]=%d,",PlayerInfo[x][pGunSkill][3]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pGunSkill[4]=%d,",PlayerInfo[x][pGunSkill][4]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pGunSkill[5]=%d,",PlayerInfo[x][pGunSkill][5]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTaxiExp=%d,",PlayerInfo[x][pTaxiExp]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pTaxiLvl=%d,",PlayerInfo[x][pTaxiLvl]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pCarRobbingExp=%d,",PlayerInfo[x][pCarRobbingExp]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pAdvertTime=%d,",PlayerInfo[x][pAdvertTime]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pBoxstyle=%d,",PlayerInfo[x][pBoxstyle]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pKstyle=%d,",PlayerInfo[x][pKstyle]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pKickstyle=%d,",PlayerInfo[x][pKickstyle]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pBoxSkill=%d,",PlayerInfo[x][pBoxSkill]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pKongfuSkill=%d,",PlayerInfo[x][pKongfuSkill]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pKickboxSkill=%d,",PlayerInfo[x][pKickboxSkill]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDLevel=%d,",PlayerInfo[x][pDLevel]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDExp=%d,",PlayerInfo[x][pDExp]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDMgruz=%d,",PlayerInfo[x][pDMgruz]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pDgruz=%d,",PlayerInfo[x][pDgruz]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pFerma=%d,",PlayerInfo[x][pFerma]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pFermazarobotok=%d,",PlayerInfo[x][pFermazarobotok]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pFermajob=%d,",PlayerInfo[x][pFermajob]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pWheels=%d,",PlayerInfo[x][pWheels]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pPaintJob=%d,",PlayerInfo[x][pPaintJob]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pSpoiler=%d,",PlayerInfo[x][pSpoiler]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pBumper1=%d,",PlayerInfo[x][pBumper1]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pBumper2=%d,",PlayerInfo[x][pBumper2]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pColor=%d,",PlayerInfo[x][pColor]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pColor1=%d,",PlayerInfo[x][pColor1]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pNitro=%d,",PlayerInfo[x][pNitro]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"pHydrawlic=%d,",PlayerInfo[x][pHydrawlic]);strcat(query,src,sizeof(query));
    format(src,sizeof(src),"Online='%s'",strstre);strcat(query,src,sizeof(query));
	format(src,sizeof(src)," WHERE Name='%s'",sendername);strcat(query,src,sizeof(query));
	return mysql_function_query(mysql, query, false,"","");[/QUOTE]


[QUOTE][20:17:34] [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]=0,pTicketNr[1]=0,pTicketNr[2]=0,pTicketWin=0,pRadio=0,pFishes=0,pFriendMoney' at line 1
[/QUOTE]
Открыть
 
Последнее редактирование:
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу