1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Русский/Russian

Threaded Mode
Ошибка. MySQL R6
Urukhay
Gangsta
****
Posts: 639
Threads: 41
Joined: Sep 2013
Reputation: 0
#21

01.03.2014, 02:10
У Вас в коде должен быть такой запрос: (Ваш лог даёт на него ошибку)
HTML Code:
SELECT * FROM banlist WHERE `Name` = 'Richard_Resolve' `Guns` = '', `Ammos` = '', `Lics` = '1,1,1,1', `Notice` = '0,50,0', `Togs` = '137,294,79', `Jails` = '0,0,0', `Skills` = '100,100,100,100,100,100' WHERE `Name` = 'Richard_Resolve'
Исправьте на:
HTML Code:
SELECT * FROM banlist WHERE Name = 'Richard_Resolve' AND Guns = '' AND Ammos = '' AND Lics = '1,1,1,1' AND Notice = '0,50,0' AND Togs = '137,294,79' AND Jails = '0,0,0' AND Skills = '100,100,100,100,100,100'
Find
Reply
Size
Big Clucker
***
Posts: 113
Threads: 27
Joined: Feb 2013
Reputation: 0
#22

01.03.2014, 06:35
Quote:
Originally Posted by Urukhay
View Post
У Вас в коде должен быть такой запрос: (Ваш лог даёт на него ошибку)
HTML Code:
SELECT * FROM banlist WHERE `Name` = 'Richard_Resolve' `Guns` = '', `Ammos` = '', `Lics` = '1,1,1,1', `Notice` = '0,50,0', `Togs` = '137,294,79', `Jails` = '0,0,0', `Skills` = '100,100,100,100,100,100' WHERE `Name` = 'Richard_Resolve'
Исправьте на:
HTML Code:
SELECT * FROM banlist WHERE Name = 'Richard_Resolve' AND Guns = '' AND Ammos = '' AND Lics = '1,1,1,1' AND Notice = '0,50,0' AND Togs = '137,294,79' AND Jails = '0,0,0' AND Skills = '100,100,100,100,100,100'
Вот именно что нет такого запроса
Find
Reply
Size
Big Clucker
***
Posts: 113
Threads: 27
Joined: Feb 2013
Reputation: 0
#23

01.03.2014, 06:51
Ставлю вот этот код вместо оптимизированного (старый код).
Вывод: ошибок в MYSQL нету с этим кодом..
PHP Code:
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
    format(src,sizeof(src)," `Brunt` = '%i',",PlayerInfo[playerid][pBrunt]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `EnterHour` = '%i',",PlayerInfo[playerid][pEnterHour]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `CrimeWho` = '%s',",PlayerInfo[playerid][pCrimeWho]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Crime` = '%s',",PlayerInfo[playerid][pCrime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `NewlyWeds` = '%i',",PlayerInfo[playerid][pNewlyWeds]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `NewlyWedsTo` = '%s',",PlayerInfo[playerid][pNewlyWedsTo]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Jerrycan` = '%i',",PlayerInfo[playerid][pJerrycan]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Tools` = '%i',",PlayerInfo[playerid][pTools]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `JailTime` = '%i',",PlayerInfo[playerid][pJailTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `WantedLevel` = '%i',",PlayerInfo[playerid][pWantedLevel]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Mats` = '%i',",PlayerInfo[playerid][pMats]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Drugs` = '%i',",PlayerInfo[playerid][pDrugs]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `WarnTime` = '%i',",PlayerInfo[playerid][pWarnTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Warn` = '%i',",PlayerInfo[playerid][pWarn]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Mute` = '%i',",PlayerInfo[playerid][pMute]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `MuteReport` = '%i',",PlayerInfo[playerid][pMuteReport]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `MobileCash` = '%i',",PlayerInfo[playerid][pMobilecash]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Number` = '%i',",PlayerInfo[playerid][pNumberPhone]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Bank` = '%i',",PlayerInfo[playerid][pBank]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Money` = '%i',",PlayerInfo[playerid][pCash]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `FracSkin` = '%i',",PlayerInfo[playerid][pSkin]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Rang` = '%i',",PlayerInfo[playerid][pRang]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Leader` = '%i',",PlayerInfo[playerid][pLeader]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Member` = '%i',",PlayerInfo[playerid][pMember]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `AdminPass` = '%s',",PlayerInfo[playerid][pAdminPassword]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Admin` = '%i',",PlayerInfo[playerid][pAdmin]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Job` = '%i',",PlayerInfo[playerid][pJob]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Sex` = '%i',",PlayerInfo[playerid][pSex]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Health` = '%f',",PlayerInfo[playerid][pHealth]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Level` = '%i',",PlayerInfo[playerid][pLevel]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Exp` = '%i',",PlayerInfo[playerid][pExp]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Char` = '%i',",PlayerInfo[playerid][pChar]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Check` = '%i',",PlayerInfo[playerid][pCheck]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Donate` = '%i',",PlayerInfo[playerid][pScrDonate]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `ExpTime` = '%i',",PlayerInfo[playerid][pExpTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `HourFraction` = '%i',",PlayerInfo[playerid][pHourFractions]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Reputation` = '%i',",PlayerInfo[playerid][pReputation]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Dependence` = '%i',",PlayerInfo[playerid][pDepen]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Dolg` = '%i',",PlayerInfo[playerid][pDolg]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `UseKrisha` = '%i',",PlayerInfo[playerid][pUseKrisha]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Krisha` = '%i',",PlayerInfo[playerid][pKrisha]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Eat` = '%i',",PlayerInfo[playerid][pEat]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Vip` = '%i',",PlayerInfo[playerid][pStatusVip]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Escape` = '%i',",PlayerInfo[playerid][pEscape]);
    strcat(query,src,sizeof(query)); 
Find
Reply
Size
Big Clucker
***
Posts: 113
Threads: 27
Joined: Feb 2013
Reputation: 0
#24

01.03.2014, 10:51
Кто нибудь поможет?
Find
Reply
Jon_De
High-roller
*****
Posts: 1,246
Threads: 12
Joined: Mar 2011
Reputation: 0
#25

01.03.2014, 11:33
Чем?
Quote:

Вывод: ошибок в MYSQL нету с этим кодом..
Find
Reply
Size
Big Clucker
***
Posts: 113
Threads: 27
Joined: Feb 2013
Reputation: 0
#26

01.03.2014, 12:44
Quote:
Originally Posted by Jon_De
View Post
Чем?
С кодом что я выше дал
Find
Reply
Ferjkee
Little Clucker
**
Posts: 26
Threads: 6
Joined: Jan 2014
Reputation: 0
#27

03.03.2014, 13:39
%i в запросах совсем не обязательно ставить между запятыми сверху, они нужны для string или float переменных.
Find
Reply
Stepashka
Godfather
*****
Posts: 5,763
Threads: 19
Joined: Jul 2008
Reputation: 0
#28

03.03.2014, 13:46
Quote:
Originally Posted by Ferjkee
View Post
%i в запросах совсем не обязательно ставить между запятыми сверху, они нужны для string или float переменных.
Для float не нужны.

ЗЫ пожалуйста прекратите писать ваши бесполезные посты во всех темах, такой способ набить постов тут не приветствуется.
Find
Reply
Ferjkee
Little Clucker
**
Posts: 26
Threads: 6
Joined: Jan 2014
Reputation: 0
#29

03.03.2014, 13:49
Quote:
Originally Posted by Size
View Post
Ставлю вот этот код вместо оптимизированного (старый код).
Вывод: ошибок в MYSQL нету с этим кодом..
PHP Code:
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
    format(src,sizeof(src)," `Brunt` = '%i',",PlayerInfo[playerid][pBrunt]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `EnterHour` = '%i',",PlayerInfo[playerid][pEnterHour]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `CrimeWho` = '%s',",PlayerInfo[playerid][pCrimeWho]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Crime` = '%s',",PlayerInfo[playerid][pCrime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `NewlyWeds` = '%i',",PlayerInfo[playerid][pNewlyWeds]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `NewlyWedsTo` = '%s',",PlayerInfo[playerid][pNewlyWedsTo]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Jerrycan` = '%i',",PlayerInfo[playerid][pJerrycan]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Tools` = '%i',",PlayerInfo[playerid][pTools]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `JailTime` = '%i',",PlayerInfo[playerid][pJailTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `WantedLevel` = '%i',",PlayerInfo[playerid][pWantedLevel]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Mats` = '%i',",PlayerInfo[playerid][pMats]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Drugs` = '%i',",PlayerInfo[playerid][pDrugs]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `WarnTime` = '%i',",PlayerInfo[playerid][pWarnTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Warn` = '%i',",PlayerInfo[playerid][pWarn]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Mute` = '%i',",PlayerInfo[playerid][pMute]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `MuteReport` = '%i',",PlayerInfo[playerid][pMuteReport]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `MobileCash` = '%i',",PlayerInfo[playerid][pMobilecash]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Number` = '%i',",PlayerInfo[playerid][pNumberPhone]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Bank` = '%i',",PlayerInfo[playerid][pBank]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Money` = '%i',",PlayerInfo[playerid][pCash]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `FracSkin` = '%i',",PlayerInfo[playerid][pSkin]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Rang` = '%i',",PlayerInfo[playerid][pRang]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Leader` = '%i',",PlayerInfo[playerid][pLeader]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Member` = '%i',",PlayerInfo[playerid][pMember]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `AdminPass` = '%s',",PlayerInfo[playerid][pAdminPassword]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Admin` = '%i',",PlayerInfo[playerid][pAdmin]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Job` = '%i',",PlayerInfo[playerid][pJob]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Sex` = '%i',",PlayerInfo[playerid][pSex]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Health` = '%f',",PlayerInfo[playerid][pHealth]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Level` = '%i',",PlayerInfo[playerid][pLevel]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Exp` = '%i',",PlayerInfo[playerid][pExp]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Char` = '%i',",PlayerInfo[playerid][pChar]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Check` = '%i',",PlayerInfo[playerid][pCheck]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Donate` = '%i',",PlayerInfo[playerid][pScrDonate]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `ExpTime` = '%i',",PlayerInfo[playerid][pExpTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `HourFraction` = '%i',",PlayerInfo[playerid][pHourFractions]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Reputation` = '%i',",PlayerInfo[playerid][pReputation]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Dependence` = '%i',",PlayerInfo[playerid][pDepen]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Dolg` = '%i',",PlayerInfo[playerid][pDolg]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `UseKrisha` = '%i',",PlayerInfo[playerid][pUseKrisha]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Krisha` = '%i',",PlayerInfo[playerid][pKrisha]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Eat` = '%i',",PlayerInfo[playerid][pEat]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Vip` = '%i',",PlayerInfo[playerid][pStatusVip]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Escape` = '%i',",PlayerInfo[playerid][pEscape]);
    strcat(query,src,sizeof(query)); 
Опять же, где конец запроса?
Find
Reply
Ferjkee
Little Clucker
**
Posts: 26
Threads: 6
Joined: Jan 2014
Reputation: 0
#30

03.03.2014, 13:52
Quote:
Originally Posted by Stepashka
View Post
Для float не нужны.

ЗЫ пожалуйста прекратите писать ваши бесполезные посты во всех темах, такой способ набить постов тут не приветствуется.
Мне плевать на посты.
Find
Reply
Size
Big Clucker
***
Posts: 113
Threads: 27
Joined: Feb 2013
Reputation: 0
#31

03.03.2014, 13:52
Полностью stock
PHP Code:
SaveAccount(playerid)
{
    if(gPlayerLogged[playerid] == false) return 1;
    new src[1024], name[MAX_PLAYER_NAME]; GetPlayerName(playerid, name, sizeof(name));
    format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
    format(src,sizeof(src)," `Brunt` = '%i',",PlayerInfo[playerid][pBrunt]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `EnterHour` = '%i',",PlayerInfo[playerid][pEnterHour]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `CrimeWho` = '%s',",PlayerInfo[playerid][pCrimeWho]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Crime` = '%s',",PlayerInfo[playerid][pCrime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `NewlyWeds` = '%i',",PlayerInfo[playerid][pNewlyWeds]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `NewlyWedsTo` = '%s',",PlayerInfo[playerid][pNewlyWedsTo]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Jerrycan` = '%i',",PlayerInfo[playerid][pJerrycan]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Tools` = '%i',",PlayerInfo[playerid][pTools]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `JailTime` = '%i',",PlayerInfo[playerid][pJailTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `WantedLevel` = '%i',",PlayerInfo[playerid][pWantedLevel]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Mats` = '%i',",PlayerInfo[playerid][pMats]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Drugs` = '%i',",PlayerInfo[playerid][pDrugs]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `WarnTime` = '%i',",PlayerInfo[playerid][pWarnTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Warn` = '%i',",PlayerInfo[playerid][pWarn]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Mute` = '%i',",PlayerInfo[playerid][pMute]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `MuteReport` = '%i',",PlayerInfo[playerid][pMuteReport]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `MobileCash` = '%i',",PlayerInfo[playerid][pMobilecash]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Number` = '%i',",PlayerInfo[playerid][pNumberPhone]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Bank` = '%i',",PlayerInfo[playerid][pBank]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Money` = '%i',",PlayerInfo[playerid][pCash]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `FracSkin` = '%i',",PlayerInfo[playerid][pSkin]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Rang` = '%i',",PlayerInfo[playerid][pRang]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Leader` = '%i',",PlayerInfo[playerid][pLeader]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Member` = '%i',",PlayerInfo[playerid][pMember]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `AdminPass` = '%s',",PlayerInfo[playerid][pAdminPassword]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Admin` = '%i',",PlayerInfo[playerid][pAdmin]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Job` = '%i',",PlayerInfo[playerid][pJob]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Sex` = '%i',",PlayerInfo[playerid][pSex]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Health` = '%f',",PlayerInfo[playerid][pHealth]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Level` = '%i',",PlayerInfo[playerid][pLevel]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Exp` = '%i',",PlayerInfo[playerid][pExp]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Char` = '%i',",PlayerInfo[playerid][pChar]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Check` = '%i',",PlayerInfo[playerid][pCheck]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Donate` = '%i',",PlayerInfo[playerid][pScrDonate]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `ExpTime` = '%i',",PlayerInfo[playerid][pExpTime]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `HourFraction` = '%i',",PlayerInfo[playerid][pHourFractions]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Reputation` = '%i',",PlayerInfo[playerid][pReputation]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Dependence` = '%i',",PlayerInfo[playerid][pDepen]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Dolg` = '%i',",PlayerInfo[playerid][pDolg]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `UseKrisha` = '%i',",PlayerInfo[playerid][pUseKrisha]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Krisha` = '%i',",PlayerInfo[playerid][pKrisha]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Eat` = '%i',",PlayerInfo[playerid][pEat]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Vip` = '%i',",PlayerInfo[playerid][pStatusVip]);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Escape` = '%i',",PlayerInfo[playerid][pEscape]);
    strcat(query,src,sizeof(query));
    new gunids[56],ammos[56],cnt;
    for(new i; i < 13; i++)
    {
        new weapid,ammo;
        GetPlayerWeaponData(playerid,i,weapid,ammo);
        if(weapid && ammo && PlayerInfo[playerid][pGun][i] == weapid && PlayerInfo[playerid][pGunAmmo][i] <= ammo)
        {
            if(!cnt)
            {
                format(gunids,sizeof(gunids),"%d",PlayerInfo[playerid][pGun][i]);
                format(ammos,sizeof(ammos),"%d",PlayerInfo[playerid][pGunAmmo][i]);
            }
            else
            {
                format(gunids,sizeof(gunids),"%s,%d",gunids,PlayerInfo[playerid][pGun][i]);
                format(ammos,sizeof(ammos),"%s,%d",ammos,PlayerInfo[playerid][pGunAmmo][i]);
            }
            cnt++;
            if(cnt >= 6) break;
        }
    }
    format(src,sizeof(src)," `Guns` = '%s',",gunids);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," `Ammos` = '%s',",ammos);
    strcat(query,src,sizeof(query));
    format(PlayerInfo[playerid][pLics],40,"%d,%d,%d,%d",PlayerInfo[playerid][pLic][0],PlayerInfo[playerid][pLic][1],PlayerInfo[playerid][pLic][2],PlayerInfo[playerid][pLic][3]);
    format(src,sizeof(src)," `Lics` = '%s',",PlayerInfo[playerid][pLics]);
    strcat(query,src,sizeof(query));
    new notice[8];
    format(notice,sizeof(notice),"%d,%d,%d",PlayerInfo[playerid][pNotice][0],PlayerInfo[playerid][pNotice][1],PlayerInfo[playerid][pNotice][2]);
    format(src,sizeof(src)," `Notice` = '%s',",notice);
    strcat(query,src,sizeof(query));
    format(PlayerInfo[playerid][pTogs],40,"%d,%d,%d",PlayerInfo[playerid][pTog][0],PlayerInfo[playerid][pTog][1],PlayerInfo[playerid][pTog][2]);
    format(src,sizeof(src)," `Togs` = '%s',",PlayerInfo[playerid][pTogs]);
    strcat(query,src,sizeof(query));
    format(PlayerInfo[playerid][pJails],40,"%d,%d,%d",PlayerInfo[playerid][pJail][0],PlayerInfo[playerid][pJail][1],PlayerInfo[playerid][pJail][2]);
    format(src,sizeof(src)," `Jails` = '%s',",PlayerInfo[playerid][pJails]);
    strcat(query,src,sizeof(query));
    new gunskill[30];
    format(gunskill,sizeof(gunskill),"%d,%d,%d,%d,%d,%d",PlayerInfo[playerid][pGunSkill][0],PlayerInfo[playerid][pGunSkill][1],PlayerInfo[playerid][pGunSkill][2],
    PlayerInfo[playerid][pGunSkill][3],PlayerInfo[playerid][pGunSkill][4],PlayerInfo[playerid][pGunSkill][5]);
    format(src,sizeof(src)," `Skills` = '%s'",gunskill);
    strcat(query,src,sizeof(query));
    format(src,sizeof(src)," WHERE `Name` = '%s'",name);
    strcat(query,src,sizeof(query));
    mysql_query(query);
    new guns[56], ammo[56];
    format(guns,56,"%i, %i, %i, %i, %i", CarInfo[playerid][cGun][0],CarInfo[playerid][cGun][1],CarInfo[playerid][cGun][2],CarInfo[playerid][cGun][3],CarInfo[playerid][cGun][4]);
    format(ammo,56,"%i, %i, %i, %i, %i", CarInfo[playerid][cGunAmmo][0],CarInfo[playerid][cGunAmmo][1],CarInfo[playerid][cGunAmmo][2],CarInfo[playerid][cGunAmmo][3],CarInfo[playerid][cGunAmmo][4]);
    format(CarInfo[playerid][cColors],16,"%d,%d", CarInfo[playerid][cColor][0], CarInfo[playerid][cColor][1]);
    format(query,sizeof(query),"UPDATE "TABLE_CARS" SET `Colors` = '%s', `Model` = '%i', `Cost` = '%i', `Guns` = '%s', `Ammo` = '%s', `Drugs` = '%i', `Wheel` = '%i', `Nitro` = '%i', `FBumber` = '%i', `RBumber` = '%i', `Spoiler` = '%i', `Hydra` = '%i' WHERE `Owner` = '%s'",
    CarInfo[playerid][cColors],CarInfo[playerid][cModel],CarInfo[playerid][cCost],guns,ammo,CarInfo[playerid][cDrugs],CarInfo[playerid][cWheel],CarInfo[playerid][cNitro],CarInfo[playerid][cFBumber],CarInfo[playerid][cRBumber],CarInfo[playerid][cSpoiler],CarInfo[playerid][cHydra],name);
    mysql_query(query);
    return 1;
} 
Find
Reply
Eims
Huge Clucker
****
Posts: 475
Threads: 1
Joined: May 2013
Reputation: 0
#32

06.03.2014, 03:30
Не проще ли сразу форматировать всё в одну строку, не используя 2 массива?
PHP Code:
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
format(query,sizeof(query),"%s `Brunt` = '%i',",query,PlayerInfo[playerid][pBrunt]); 
UPD: И вы уверены, что в массиве хватает ячеек для хранения запроса?
Перед
PHP Code:
mysql_query(query); 
поставьте
PHP Code:
printf("%s",query); 
И покажите структуру таблицы вашей
Find
Reply
Size
Big Clucker
***
Posts: 113
Threads: 27
Joined: Feb 2013
Reputation: 0
#33

06.03.2014, 23:24
Quote:
Originally Posted by Eims
View Post
Не проще ли сразу форматировать всё в одну строку, не используя 2 массива?
PHP Code:
format(query,sizeof(query),"UPDATE "TABLE_ACCOUNT" SET ");
format(query,sizeof(query),"%s `Brunt` = '%i',",query,PlayerInfo[playerid][pBrunt]); 
UPD: И вы уверены, что в массиве хватает ячеек для хранения запроса?
Перед
PHP Code:
mysql_query(query); 
поставьте
PHP Code:
printf("%s",query); 
И покажите структуру таблицы вашей
Вы тему вообще читали нет?
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. Non-English
  3. Languages
  4. Русский/Russian