[Lumineux]

Okay, i tried, and got this:

Код:

[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Password, Name, Level, Admin, Helper, Premium, UpgradePoints)SET ('%s', '%s', %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Password, Name, Level, Admin, Helper, Premium, ", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (ConnectedTime, Registered, Sex, Age, Origin, Muted, Respect)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (ConnectedTime, Registered, Sex, Age, Origin, Mu", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Cash, Bank, Crimes, Kills, Deaths, Arrested, WantedDeaths)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Cash, Bank, Crimes, Kills, Deaths, Arrested, Wa", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Phonebook, LottoNr, Fishes, BiggestFish, Job, Paycheck, HeadValue)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %..."
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Phonebook, LottoNr, Fishes, BiggestFish, Job, P", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Materials, Drugs, Lider, Membru, Rank, Skin, DetSkill)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Materials, Drugs, Lider, Membru, Rank, Skin, De", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (SexSkill, BoxSkill, JackSkill, CarSkill, NewsSkill, DrugsSkill, CookSkill)SET (%d, %d, %d, %d, %d, %d, %d) WHER..."
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Password, Name, Level, Admin, Helper, Premium, UpgradePoints)SET ('abcdef', '',' ŕ la ligne 1
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (SexSkill, BoxSkill, JackSkill, CarSkill, NewsSk", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (FishSkill, pHealth, Interior, Local, WantedLevel, Jailed, JailTime)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = ..."
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
ts (FishSkill, pHealth, Interior, Local, WantedLeve", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Telefon, FirstCar, SecondCar, Helicopter, Boat, Plane, Fwarn)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Telefon, FirstCar, SecondCar, Helicopter, Boat,", callback: "(null)", format: "(null)"
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(ConnectedTime, Registered, Sex, Age, Origin, Muted, Respect)SET (0, 1, 0, 16, 0' ŕ la ligne 1
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (House, Business, CarLic, FlyLic, BoatLic, FishLic, GunLic)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (House, Business, CarLic, FlyLic, BoatLic, FishL", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
(Gun1, Gun2, Gun3, Gun4, Ammo1, Ammo2, Ammo3)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Gun1, Gun2, Gun3, Gun4, Ammo1, Ammo2, Ammo3)SET", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Cash, Bank, Crimes, Kills, Deaths, Arrested, WantedDeaths)SET (50000, 50000, 0,' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Phonebook, LottoNr, Fishes, BiggestFish, Job, Paycheck, HeadValue)SET (1, 0, 0,' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Materials, Drugs, Lider, Membru, Rank, Skin, DetSkill)SET (0, 0, 0, 0, 0, 250, ' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(SexSkill, BoxSkill, JackSkill, CarSkill, NewsSkill, DrugsSkill, CookSkill)SET (' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Ammo4, CarTime, PayDay, PayDayHad, CDPlayer, Wins, Loses)SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d"
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Ammo4, CarTime, PayDay, PayDayHad, CDPlayer, Wi", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (AlcoholPerk, DrugPerk, MiserPerk, PainPerk, TraderPerk, Tutorial, Warnings)SET (%d, %d, %d, %d, %d, %d, %d) WHE..."
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (AlcoholPerk, DrugPerk, MiserPerk, PainPerk, Tra", callback: "(null)", format: "(null)"
[17:43:53] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Adjustable, Married, AcceptPoints, MarriedTo, JobCD, WalkieTalkie, GasCan, Coins)SET (%d, %d, %d, '%s', %d, %d,..."
[17:43:53] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Adjustable, Married, AcceptPoints, MarriedTo, J", callback: "(null)", format: "(null)"
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(FishSkill, pHealth, Interior, Local, WantedLevel, Jailed, JailTime)SET (0, 1112' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Telefon, FirstCar, SecondCar, Helicopter, Boat, Plane, Fwarn)SET (40564, -1, -1' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(House, Business, CarLic, FlyLic, BoatLic, FishLic, GunLic)SET (255, 255, 0, 0, ' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Gun1, Gun2, Gun3, Gun4, Ammo1, Ammo2, Ammo3)SET (0, 0, 0, 0, 0, 0, 0) WHERE ID ' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Ammo4, CarTime, PayDay, PayDayHad, CDPlayer, Wins, Loses)SET (0, 0, 0, 0, 0, 0,' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(AlcoholPerk, DrugPerk, MiserPerk, PainPerk, TraderPerk, Tutorial, Warnings)SET ' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[17:43:53] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Adjustable, Married, AcceptPoints, MarriedTo, JobCD, WalkieTalkie, GasCan, Coin' ŕ la ligne 1
[17:43:53] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..
[17:43:53] [DEBUG] Calling callback "OnQueryError"..

With this code:

PHP код:

mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Password, Name, Level, Admin, Helper, Premium, UpgradePoints)\
SET ('%s', '%s', %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pKey], PlayerInfo[playerid][Name],
PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper],
PlayerInfo[playerid][pDonateRank],PlayerInfo[playerid][pUpgrade],PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (ConnectedTime, Registered, Sex, Age, Origin, Muted, Respect)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg],
PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pMuted],
PlayerInfo[playerid][pExp], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Cash, Bank, Crimes, Kills, Deaths, Arrested, WantedDeaths)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBank],
PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills], PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested],
PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Phonebook, LottoNr, Fishes, BiggestFish, Job, Paycheck, HeadValue)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Materials, Drugs, Lider, Membru, Rank, Skin, DetSkill)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pMats], PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLider], PlayerInfo[playerid][pMembru], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (SexSkill, BoxSkill, JackSkill, CarSkill, NewsSkill, DrugsSkill, CookSkill)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pBoxSkill],
PlayerInfo[playerid][pJackSkill], PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pNewsSkill],
PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pCookSkill], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (FishSkill, pHealth, Interior, Local, WantedLevel, Jailed, JailTime)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pHealth],
PlayerInfo[playerid][pInt], PlayerInfo[playerid][pLocal], WantedLevel[playerid], PlayerInfo[playerid][pJailed],
PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Telefon, FirstCar, SecondCar, Helicopter, Boat, Plane, Fwarn)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pPtelefon], PlayerInfo[playerid][pCarKey1],
PlayerInfo[playerid][pCarKey2], PlayerInfo[playerid][pHeliKey], PlayerInfo[playerid][pBoatKey],
PlayerInfo[playerid][pPlaneKey], PlayerInfo[playerid][pFwarn], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (House, Business, CarLic, FlyLic, BoatLic, FishLic, GunLic)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pHouseKey], PlayerInfo[playerid][pBizzKey],
PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Gun1, Gun2, Gun3, Gun4, Ammo1, Ammo2, Ammo3)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2],
PlayerInfo[playerid][pGun3], PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pAmmo2],
PlayerInfo[playerid][pAmmo3], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Ammo4, CarTime, PayDay, PayDayHad, CDPlayer, Wins, Loses)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pCarTime],
PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad], PlayerInfo[playerid][pCDPlayer],
PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (AlcoholPerk, DrugPerk, MiserPerk, PainPerk, TraderPerk, Tutorial, Warnings)\
SET (%d, %d, %d, %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pAlcoholPerk], PlayerInfo[playerid][pDrugPerk],
PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut], PlayerInfo[playerid][pWarns], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");
mysql_format(mysql, query, sizeof(query), "UPDATE accounts (Adjustable, Married, AcceptPoints, MarriedTo, JobCD, WalkieTalkie, GasCan, Coins)\
SET (%d, %d, %d, '%s', %d, %d, %d, %d) WHERE ID = %d", PlayerInfo[playerid][pAdjustable], PlayerInfo[playerid][pMarried],
PlayerInfo[playerid][pAcceptPoints], PlayerInfo[playerid][pMarriedTo], PlayerInfo[playerid][pJobCD],
PlayerInfo[playerid][pWalkTalkie], PlayerInfo[playerid][pGasCan], PlayerInfo[playerid][pCoins], PlayerInfo[playerid][ID]);
mysql_tquery(mysql, query, "", "");