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

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

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

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

[Ошибка] UPDATE MySQL

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

Ray_Grand

Умник
В общем такая проблема, переводил регистрацию с mxINI на MySQL R8 R20 и возникла проблема при обновлении данных:

Ошибка из mysql_log
PHP: 
[DEBUG] ProcessQueryThread() - Executing query UPDATE `players` SET `pLevel` = '1', `pAdmin` = '0', `pDonateRank` = '0', `gPupgrade` = '0', `pConnectTime` = '0', `pReg` = '1', `pSex` = '1', `pAge` = '24', `pOrigin` = '1', `pCK` = '0', `pMuted` = '0', `pExp` = '0', `pCash` = '0', `pAccount` = '2500', `pCrimes` = '0', `pKills` = '0', `pDeaths` = ...
[ERROR] ProcessQueryThread() - 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 '' at line 1 (error ID: 1064)
[DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
Ошибка из server_log
PHP: 
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 '' at line 1
Паблик с обновлением:
PHP: 
public OnPlayerUpdate_GF(playerid)
{
	if(IsPlayerConnected(playerid))
	{
	    if(GetPVarInt(playerid,"Logged") > 0)
    	{
        	new string[300],query[300];
    		format(string,sizeof(string),"UPDATE `players` SET "),strcat(query,string);
    		format(string,sizeof(string),"`pLevel` = '%d', ",PlayerInfo[playerid][pLevel]),strcat(query,string);
    		format(string,sizeof(string),"`pAdmin` = '%d', ",PlayerInfo[playerid][pAdmin]),strcat(query,string);
    		format(string,sizeof(string),"`pDonateRank` = '%d', ",PlayerInfo[playerid][pDonateRank]),strcat(query,string);
    		format(string,sizeof(string),"`gPupgrade` = '%d', ",PlayerInfo[playerid][gPupgrade]),strcat(query,string);
    		format(string,sizeof(string),"`pConnectTime` = '%d', ",PlayerInfo[playerid][pConnectTime]),strcat(query,string);
    		format(string,sizeof(string),"`pReg` = '%d', ",PlayerInfo[playerid][pReg]),strcat(query,string);
    		format(string,sizeof(string),"`pSex` = '%d', ",PlayerInfo[playerid][pSex]),strcat(query,string);
    		format(string,sizeof(string),"`pAge` = '%d', ",PlayerInfo[playerid][pAge]),strcat(query,string);
    		format(string,sizeof(string),"`pOrigin` = '%d', ",PlayerInfo[playerid][pOrigin]),strcat(query,string);
    		format(string,sizeof(string),"`pCK` = '%d', ",PlayerInfo[playerid][pCK]),strcat(query,string);
    		format(string,sizeof(string),"`pMuted` = '%d', ",PlayerInfo[playerid][pMuted]),strcat(query,string);
    		format(string,sizeof(string),"`pExp` = '%d', ",PlayerInfo[playerid][pExp]),strcat(query,string);
    		format(string,sizeof(string),"`pCash` = '%d', ",PlayerInfo[playerid][pCash]),strcat(query,string);
    		format(string,sizeof(string),"`pAccount` = '%d', ",PlayerInfo[playerid][pAccount]),strcat(query,string);
    		format(string,sizeof(string),"`pCrimes` = '%d', ",PlayerInfo[playerid][pCrimes]),strcat(query,string);
    		format(string,sizeof(string),"`pKills` = '%d', ",PlayerInfo[playerid][pKills]),strcat(query,string);
    		format(string,sizeof(string),"`pDeaths` = '%d', ",PlayerInfo[playerid][pDeaths]),strcat(query,string);
    		format(string,sizeof(string),"`pArrested` = '%d', ",PlayerInfo[playerid][pArrested]),strcat(query,string);
    		format(string,sizeof(string),"`pWantedDeaths` = '%d', ",PlayerInfo[playerid][pWantedDeaths]),strcat(query,string);
    		format(string,sizeof(string),"`pPhoneBook` = '%d', ",PlayerInfo[playerid][pPhoneBook]),strcat(query,string);
    		format(string,sizeof(string),"`pKpk` = '%d', ",PlayerInfo[playerid][pKpk]),strcat(query,string);
    		format(string,sizeof(string),"`pLottoNr` = '%d', ",PlayerInfo[playerid][pLottoNr]),strcat(query,string);
    		format(string,sizeof(string),"`pFishes` = '%d', ",PlayerInfo[playerid][pFishes]),strcat(query,string);
    		format(string,sizeof(string),"`pBiggestFish` = '%d', ",PlayerInfo[playerid][pBiggestFish]),strcat(query,string);
    		format(string,sizeof(string),"`pJob` = '%d', ",PlayerInfo[playerid][pJob]),strcat(query,string);
    		format(string,sizeof(string),"`pPayCheck` = '%d', ",PlayerInfo[playerid][pPayCheck]),strcat(query,string);
    		format(string,sizeof(string),"`pHeadValue` = '%d', ",PlayerInfo[playerid][pHeadValue]),strcat(query,string);
    		format(string,sizeof(string),"`pJailed` = '%d', ",PlayerInfo[playerid][pJailed]),strcat(query,string);
    		format(string,sizeof(string),"`pJailTime` = '%d', ",PlayerInfo[playerid][pJailTime]),strcat(query,string);
    		format(string,sizeof(string),"`pMats` = '%d', ",PlayerInfo[playerid][pMats]),strcat(query,string);
    		format(string,sizeof(string),"`pDrugs` = '%d', ",PlayerInfo[playerid][pDrugs]),strcat(query,string);
    		format(string,sizeof(string),"`pLeader` = '%d', ",PlayerInfo[playerid][pLeader]),strcat(query,string);
    		format(string,sizeof(string),"`pMember` = '%d', ",PlayerInfo[playerid][pMember]),strcat(query,string);
    		format(string,sizeof(string),"`pFMember` = '%d', ",PlayerInfo[playerid][pFMember]),strcat(query,string);
    		format(string,sizeof(string),"`pRank` = '%d', ",PlayerInfo[playerid][pRank]),strcat(query,string);
    		format(string,sizeof(string),"`pZvan` = '%d', ",PlayerInfo[playerid][pZvan]),strcat(query,string);
    		format(string,sizeof(string),"`pChar` = '%d', ",PlayerInfo[playerid][pChar]),strcat(query,string);
    		format(string,sizeof(string),"`pContractTime` = '%d', ",PlayerInfo[playerid][pContractTime]),strcat(query,string);
    		format(string,sizeof(string),"`pDetSkill` = '%d', ",PlayerInfo[playerid][pDetSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pSexSkill` = '%d', ",PlayerInfo[playerid][pSexSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pBoxSkill` = '%d', ",PlayerInfo[playerid][pBoxSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pLawSkill` = '%d', ",PlayerInfo[playerid][pLawSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pMechSkill` = '%d', ",PlayerInfo[playerid][pMechSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pJackSkill` = '%d', ",PlayerInfo[playerid][pJackSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pVorSkill` = '%d', ",PlayerInfo[playerid][pVorSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pCarSkill` = '%d', ",PlayerInfo[playerid][pCarSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pNewsSkill` = '%d', ",PlayerInfo[playerid][pNewsSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pDrugsSkill` = '%d', ",PlayerInfo[playerid][pDrugsSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pCookSkill` = '%d', ",PlayerInfo[playerid][pCookSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pFishSkill` = '%d', ",PlayerInfo[playerid][pFishSkill]),strcat(query,string);
    		format(string,sizeof(string),"`pHealth` = '%f', ",PlayerInfo[playerid][pHealth]),strcat(query,string);
    		format(string,sizeof(string),"`pSHealth` = '%f', ",PlayerInfo[playerid][pSHealth]),strcat(query,string);
    		format(string,sizeof(string),"`pInt` = '%d', ",PlayerInfo[playerid][pInt]),strcat(query,string);
    		format(string,sizeof(string),"`pLocal` = '%d', ",PlayerInfo[playerid][pLocal]),strcat(query,string);
    		format(string,sizeof(string),"`pTeam` = '%d', ",PlayerInfo[playerid][pTeam]),strcat(query,string);
    		format(string,sizeof(string),"`pModel` = '%d', ",PlayerInfo[playerid][pModel]),strcat(query,string);
    		format(string,sizeof(string),"`pPnumber` = '%d', ",PlayerInfo[playerid][pPnumber]),strcat(query,string);
    		format(string,sizeof(string),"`pPhousekey` = '%d', ",PlayerInfo[playerid][pPhousekey]),strcat(query,string);
    		format(string,sizeof(string),"`pPbiskey` = '%d', ",PlayerInfo[playerid][pPbiskey]),strcat(query,string);
    		format(string,sizeof(string),"`pPos_x` = '%f', ",PlayerInfo[playerid][pPos_x]),strcat(query,string);
    		format(string,sizeof(string),"`pPos_y` = '%f', ",PlayerInfo[playerid][pPos_y]),strcat(query,string);
    		format(string,sizeof(string),"`pPos_z` = '%f', ",PlayerInfo[playerid][pPos_z]),strcat(query,string);
    		format(string,sizeof(string),"`pCarLic` = '%d', ",PlayerInfo[playerid][pCarLic]),strcat(query,string);
    		format(string,sizeof(string),"`pFlyLic` = '%d', ",PlayerInfo[playerid][pFlyLic]),strcat(query,string);
    		format(string,sizeof(string),"`pMotoLic` = '%d', ",PlayerInfo[playerid][pMotoLic]),strcat(query,string);
    		format(string,sizeof(string),"`pBoatLic` = '%d', ",PlayerInfo[playerid][pBoatLic]),strcat(query,string);
    		format(string,sizeof(string),"`pFishLic` = '%d', ",PlayerInfo[playerid][pFishLic]),strcat(query,string);
    		format(string,sizeof(string),"`pGunLic` = '%d', ",PlayerInfo[playerid][pGunLic]),strcat(query,string);
    		format(string,sizeof(string),"`pCarTime` = '%d', ",PlayerInfo[playerid][pCarTime]),strcat(query,string);
    		format(string,sizeof(string),"`pVorTime` = '%d', ",PlayerInfo[playerid][pVorTime]),strcat(query,string);
    		format(string,sizeof(string),"`pPayDay` = '%d', ",PlayerInfo[playerid][pPayDay]),strcat(query,string);
    		format(string,sizeof(string),"`pPayDayHad` = '%d', ",PlayerInfo[playerid][pPayDayHad]),strcat(query,string);
    		format(string,sizeof(string),"`pCDPlayer` = '%d', ",PlayerInfo[playerid][pCDPlayer]),strcat(query,string);
    		format(string,sizeof(string),"`pWins` = '%d', ",PlayerInfo[playerid][pWins]),strcat(query,string);
    		format(string,sizeof(string),"`pLoses` = '%d', ",PlayerInfo[playerid][pLoses]),strcat(query,string);
            format(string,sizeof(string),"`pAlcoholPerk` = '%d', ",PlayerInfo[playerid][pAlcoholPerk]),strcat(query,string);
            format(string,sizeof(string),"`pDrugPerk` = '%d', ",PlayerInfo[playerid][pDrugPerk]),strcat(query,string);
            format(string,sizeof(string),"`pMiserPerk` = '%d', ",PlayerInfo[playerid][pMiserPerk]),strcat(query,string);
            format(string,sizeof(string),"`pPainPerk` = '%d', ",PlayerInfo[playerid][pPainPerk]),strcat(query,string);
            format(string,sizeof(string),"`pTraderPerk` = '%d', ",PlayerInfo[playerid][pTraderPerk]),strcat(query,string);
            format(string,sizeof(string),"`pTut` = '%d', ",PlayerInfo[playerid][pTut]),strcat(query,string);
            format(string,sizeof(string),"`pMissionNr` = '%d', ",PlayerInfo[playerid][pMissionNr]),strcat(query,string);
            format(string,sizeof(string),"`pWarns` = '%d', ",PlayerInfo[playerid][pWarns]),strcat(query,string);
            format(string,sizeof(string),"`pAdjustable` = '%d', ",PlayerInfo[playerid][pAdjustable]),strcat(query,string);
            format(string,sizeof(string),"`pFuel` = '%d', ",PlayerInfo[playerid][pFuel]),strcat(query,string);
            format(string,sizeof(string),"`pMarried` = '%d', ",PlayerInfo[playerid][pMarried]),strcat(query,string);
            format(string,sizeof(string),"`pMarriedTo` = '%s', ",PlayerInfo[playerid][pMarriedTo]),strcat(query,string);
            format(string,sizeof(string),"`pMuteTime` = '%d', ",PlayerInfo[playerid][pMuteTime]),strcat(query,string);
            format(string,sizeof(string),"`pHaveMute` = '%d', ",PlayerInfo[playerid][pHaveMute]),strcat(query,string);
            format(string,sizeof(string),"`pNaga` = '%d', ",PlayerInfo[playerid][pNaga]),strcat(query,string);
            format(string,sizeof(string),"`pEnter` = '%d', ",PlayerInfo[playerid][pEnter]),strcat(query,string);
            format(string,sizeof(string),"`pWeap` = '%d', ",PlayerInfo[playerid][pWeap]),strcat(query,string);
            format(string,sizeof(string),"`pReport` = '%d', ",PlayerInfo[playerid][pReport]),strcat(query,string);
            format(string,sizeof(string),"`pCarKey` = '%d', ",PlayerInfo[playerid][pCarKey]),strcat(query,string);
            format(string,sizeof(string),"`pCarKey2` = '%d', ",PlayerInfo[playerid][pCarKey2]),strcat(query,string);
            format(string,sizeof(string),"`pCarKey3` = '%d', ",PlayerInfo[playerid][pCarKey3]),strcat(query,string);
            format(string,sizeof(string),"`pOrd` = '%d', ",PlayerInfo[playerid][pOrd]),strcat(query,string);
            format(string,sizeof(string),"`pPass` = '%d', ",PlayerInfo[playerid][pPass]),strcat(query,string);
            format(string,sizeof(string),"`pMask` = '%d', ",PlayerInfo[playerid][pMask]),strcat(query,string);
            format(string,sizeof(string),"`pMaskOn` = '%d', ",PlayerInfo[playerid][pMaskOn]),strcat(query,string);
            format(string,sizeof(string),"`pMaskSkill` = '%d', ",PlayerInfo[playerid][pMaskSkill]),strcat(query,string);
            format(string,sizeof(string),"`pSh` = '%d', ",PlayerInfo[playerid][pSh]),strcat(query,string);
            format(string,sizeof(string),"`pNalog` = '%d', ",PlayerInfo[playerid][pNalog]),strcat(query,string);
            format(string,sizeof(string),"`pBalance` = '%d', ",PlayerInfo[playerid][pBalance]),strcat(query,string);
            format(string,sizeof(string),"`pPx` = '%f', ",PlayerInfo[playerid][pPx]),strcat(query,string);
            format(string,sizeof(string),"`pPy` = '%f', ",PlayerInfo[playerid][pPy]),strcat(query,string);
            format(string,sizeof(string),"`pPz` = '%f', ",PlayerInfo[playerid][pPz]),strcat(query,string);
            format(string,sizeof(string),"`pPo` = '%d', ",PlayerInfo[playerid][pPo]),strcat(query,string);
            format(string,sizeof(string),"`pPp` = '%d', ",PlayerInfo[playerid][pPp]),strcat(query,string);
            format(string,sizeof(string),"`pVaip` = '%d', ",PlayerInfo[playerid][pVaip]),strcat(query,string);
            format(string,sizeof(string),"`pDonateTime` = '%d', ",PlayerInfo[playerid][pDonateTime]),strcat(query,string);
    		format(string,sizeof(string),"WHERE `pName` = '%s'",PlayerInfo[playerid][pName]),strcat(query,string);
    		mysql_function_query(dbHandle,query,false,"","");
    	}
	}
	return 1;
}
 
Статус
В этой теме нельзя размещать новые ответы.
Сверху Снизу