1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help

Threaded Mode
MySQL
Lumineux
Huge Clucker
***
Posts: 238
Threads: 6
Joined: Apr 2013
Reputation: 0
#1

24.01.2016, 10:19
What should I do ?
Код:
[22:58:05] [DEBUG] mysql_format - connection: 1, len: 1500, format: "UPDATE accounts (Password, Name, Level, Admin, Helper, Premium, UpgradePoints, ConnectedTime, Registered, Sex, Age, Origin, Mute..."
[22:58:05] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE accounts (Password, Name, Level, Admin, Helper, Premium, ", callback: "(null)", format: "(null)"
[22:58:05] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[22:58:05] [ERROR] CMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prčs de '(Password, Name, Level, Admin, Helper, Premium, UpgradePoints, ConnectedTime, Re' ŕ la ligne 1
[22:58:05] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[22:58:05] [DEBUG] Calling callback "OnQueryError"..
Код:
new query[1500], string[1500], string2[500];
format(string, sizeof(string), "UPDATE accounts (Password, Name, Level, Admin, Helper, Premium, UpgradePoints");
format(string2, sizeof(string2), ", ConnectedTime, Registered, Sex, Age, Origin, Muted, Respect, Cash, Bank, Crimes, Kills, Deaths, Arrested, WantedDeaths");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", Phonebook, LottoNr, Fishes, BiggestFish, Job, Paycheck, HeadValue, Materials, Drugs, Lider, Membru, Rank, Skin, DetSkill");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", SexSkill, BoxSkill, JackSkill, CarSkill, NewsSkill, DrugsSkill, CookSkill, FishSkill, pHealth, Interior, Local, WantedLevel");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", Jailed, JailTime, Telefon, FirstCar, SecondCar, Helicopter, Boat, Plane, Fwarn, House, Business, CarLic, FlyLic, BoatLic, FishLic");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", GunLic, Gun1, Gun2, Gun3, Gun4, Ammo1, Ammo2, Ammo3, Ammo4, CarTime, PayDay, PayDayHad, CDPlayer, Wins, Loses, AlcoholPerk");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", DrugPerk, MiserPerk, PainPerk, TraderPerk, Tutorial, Warnings, Adjustable, Married, AcceptPoints, MarriedTo, JobCD, WalkieTalkie");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", GasCan, Coins) SET ('%s', '%s', %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d, %d");
strcat(string, string2, sizeof(string));
format(string2, sizeof(string2), ", %d, %d, %d, %d, %d, %d, %d, %d, %d, '%s', %d, %d, %d, %d) WHERE ID = %d");
strcat(string, string2, sizeof(string));
mysql_format(mysql, query, sizeof(query), string,
PlayerInfo[playerid][pKey], PlayerInfo[playerid][Name],
PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pDonateRank],
PlayerInfo[playerid][pUpgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex],
PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pExp],
PlayerInfo[playerid][pCash], PlayerInfo[playerid][pBank], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pKills],
PlayerInfo[playerid][pDeaths], PlayerInfo[playerid][pArrested], PlayerInfo[playerid][pWantedDeaths], PlayerInfo[playerid][pPhoneBook],
PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pFishes], PlayerInfo[playerid][pBiggestFish], PlayerInfo[playerid][pJob],
PlayerInfo[playerid][pPayCheck], PlayerInfo[playerid][pHeadValue], PlayerInfo[playerid][pMats], PlayerInfo[playerid][pDrugs],
PlayerInfo[playerid][pLider], PlayerInfo[playerid][pMembru], PlayerInfo[playerid][pRank], PlayerInfo[playerid][pChar],
PlayerInfo[playerid][pDetSkill], PlayerInfo[playerid][pSexSkill], PlayerInfo[playerid][pBoxSkill], PlayerInfo[playerid][pJackSkill],
PlayerInfo[playerid][pMechSkill], PlayerInfo[playerid][pNewsSkill], PlayerInfo[playerid][pDrugsSkill], PlayerInfo[playerid][pCookSkill],
PlayerInfo[playerid][pFishSkill], PlayerInfo[playerid][pHealth], PlayerInfo[playerid][pInt], PlayerInfo[playerid][pLocal],
WantedLevel[playerid], PlayerInfo[playerid][pJailed], PlayerInfo[playerid][pJailTime], PlayerInfo[playerid][pPtelefon],
PlayerInfo[playerid][pCarKey1], PlayerInfo[playerid][pCarKey2], PlayerInfo[playerid][pHeliKey], PlayerInfo[playerid][pBoatKey],
PlayerInfo[playerid][pPlaneKey], PlayerInfo[playerid][pFwarn], PlayerInfo[playerid][pHouseKey], PlayerInfo[playerid][pBizzKey],
PlayerInfo[playerid][pCarLic], PlayerInfo[playerid][pFlyLic], PlayerInfo[playerid][pBoatLic], PlayerInfo[playerid][pFishLic],
PlayerInfo[playerid][pGunLic], PlayerInfo[playerid][pGun1], PlayerInfo[playerid][pGun2], PlayerInfo[playerid][pGun3],
PlayerInfo[playerid][pGun4], PlayerInfo[playerid][pAmmo1], PlayerInfo[playerid][pAmmo2], PlayerInfo[playerid][pAmmo3],
PlayerInfo[playerid][pAmmo4], PlayerInfo[playerid][pCarTime], PlayerInfo[playerid][pPayDay], PlayerInfo[playerid][pPayDayHad],
PlayerInfo[playerid][pCDPlayer], PlayerInfo[playerid][pWins], PlayerInfo[playerid][pLoses], PlayerInfo[playerid][pAlcoholPerk],
PlayerInfo[playerid][pDrugPerk], PlayerInfo[playerid][pMiserPerk], PlayerInfo[playerid][pPainPerk], PlayerInfo[playerid][pTraderPerk],
PlayerInfo[playerid][pTut], PlayerInfo[playerid][pWarns], 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, "", "");
Find
Reply
Lumineux
Huge Clucker
***
Posts: 238
Threads: 6
Joined: Apr 2013
Reputation: 0
#2

24.01.2016, 12:51
Anyone ?
Find
Reply
Amunra
Gangsta
****
Posts: 502
Threads: 57
Joined: Nov 2015
Reputation: 0
#3

24.01.2016, 13:42
See again Your Sql File ...
Wiki SAMP OnQuerryError, Find Your Probs
Find
Reply
jamal1992
Huge Clucker
****
Posts: 470
Threads: 37
Joined: Nov 2010
Reputation: 0
#4

24.01.2016, 14:57
De ce folosesti asa, mi se pare foarte incurcat. Nu stiu cum de le-ai tinut randul dar cred ca ai mai multe buguri aici. Dupa parerea mea ce trebuie sa faci este sa iei in parte fiecare rand e greseala de scriere, mareste numarul de caractere si vezi cum se comporta.
Uite un exemplu de cum am facut eu:
PHP код:
mysql_format(handle, query, sizeof(query), "UPDATE accounts SET Level = '%d', Admin = '%d', Helper = '%d', Money = '%d', AccountBank = '%d', VictimCrime = '%s', AccusedCrime = '%s' WHERE ID = '%d'",
    PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pHelper], PlayerInfo[playerid][pMoney], PlayerInfo[playerid][pAccountBank], PlayerInfo[playerid][pVictimCrime], PlayerInfo[playerid][pAccusedCrime], PlayerInfo[playerid][pID]);
    mysql_tquery(handle,query);
    mysql_format(handle, query, sizeof(query), "UPDATE accounts SET Sex = '%d', Age = '%d', Email = '%s', Crimes = '%d', Phonebook = '%d', Phone = '%d', LottoNr = '%d', Job = '%d' WHERE ID = '%d'",
    PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pEmail], PlayerInfo[playerid][pCrimes], PlayerInfo[playerid][pPhoneBook], PlayerInfo[playerid][pPhone], PlayerInfo[playerid][pLottoNr], PlayerInfo[playerid][pJob], PlayerInfo[playerid][pID]);
    mysql_tquery(handle,query); 
Poate ca nu e cea mai buna idee, dar la mine merge oke. Astea au fost facute in timpul cand invatam limbajul SQL, daca ar fi sa le fac acum as folosi si eu strcat dar nu in modul cum ai facut-o tu.
Find
Reply
Lumineux
Huge Clucker
***
Posts: 238
Threads: 6
Joined: Apr 2013
Reputation: 0
#5

24.01.2016, 15:30
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, "", ""); 
Find
Reply
« Next Oldest | Next Newest »


Forum Jump:


Users browsing this thread: 1 Guest(s)
  1. SA-MP Forums Archive
  2. SA-MP Scripting and Plugins
  3. Scripting Help