Mysql query don't execute ?! HELP
#1

Ok so i'm having this errors:
MYSQL_LOG:

Код:
[14:19:13] [DEBUG] mysql_format - connection: 1, len: 1500, format: "%s"
[14:19:13] [DEBUG] mysql_query - connection: 1, query: "UPDATE `players` SET  `AdminJailed` = '0', `pVehicle1` = '1', `p", use_cache: false
[14:19:13] [DEBUG] CMySQLQuery::Execute - starting query execution
[14:19:13] [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 '' at line 1
[14:19:13] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE players SET  IsConnected = 0 WHERE id = 1", callback: "(null)", format: "(null)"
[14:19:13] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[14:19:13] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.613 milliseconds
[14:19:13] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
Why the hell is stopping ?

Oh: mysql = mysql_connect(host, user, db, pass, .pool_size = 0);


The script:
pawn Код:
new query[1500];
format(query, sizeof(query), "UPDATE `players` SET ");
format(query, sizeof(query), "%s `AdminJailed` = '%d',", query, PlayerInfo[playerid][AdminJailed]);
format(query, sizeof(query), "%s `pVehicle1` = '%d',", query, PlayerInfo[playerid][pVehicle1]);

format(query, sizeof(query), "%s `pVehicle1Model` = '%d',", query, PlayerInfo[playerid][pVehicle1Model]);

format(query, sizeof(query), "%s `pVehicle1Value` = '%d',", query, PlayerInfo[playerid][pVehicle1Value]);
format(query, sizeof(query), "%s `pVehicle1Lock` = '%d',", query, PlayerInfo[playerid][pVehicle1Lock]);
format(query, sizeof(query), "%s `pVehicle1Color1` = '%d',", query, PlayerInfo[playerid][pVehicle1Lock]);
format(query, sizeof(query), "%s `pVehicle1Color2` = '%d',", query, PlayerInfo[playerid][pVehicle1Lock]);
format(query, sizeof(query), "%s `pVehicle1Plate` = '%d',", query, PlayerInfo[playerid][pVehicle1Plate]);
format(query, sizeof(query), "%s `pVehicle1X` = '%f',", query, PlayerInfo[playerid][pVehicle1X]);
format(query, sizeof(query), "%s `pVehicle1Y` = '%f',", query, PlayerInfo[playerid][pVehicle1Y]);
format(query, sizeof(query), "%s `pVehicle1Z` = '%f',", query, PlayerInfo[playerid][pVehicle1Z]);
format(query, sizeof(query), "%s `pVehicle1C` = '%f',", query, PlayerInfo[playerid][pVehicle1C]);
format(query, sizeof(query), "%s `pVehicle2` = '%d',", query, PlayerInfo[playerid][pVehicle2]);
format(query, sizeof(query), "%s `pVehicle2Model` = '%d',", query, PlayerInfo[playerid][pVehicle2Model]);
format(query, sizeof(query), "%s `pVehicle2Value` = '%d',", query, PlayerInfo[playerid][pVehicle2Value]);
format(query, sizeof(query), "%s `pVehicle2Lock` = '%d',", query, PlayerInfo[playerid][pVehicle2Lock]);
format(query, sizeof(query), "%s `pVehicle2Color1` = '%d',", query, PlayerInfo[playerid][pVehicle2Lock]);
format(query, sizeof(query), "%s `pVehicle2Color2` = '%d',", query, PlayerInfo[playerid][pVehicle2Lock]);
format(query, sizeof(query), "%s `pVehicle2Plate` = '%d',", query, PlayerInfo[playerid][pVehicle2Plate]);
format(query, sizeof(query), "%s `pVehicle2X` = '%f',", query, PlayerInfo[playerid][pVehicle2X]);
format(query, sizeof(query), "%s `pVehicle2Y` = '%f',", query, PlayerInfo[playerid][pVehicle2Y]);
format(query, sizeof(query), "%s `pVehicle2Z` = '%f',", query, PlayerInfo[playerid][pVehicle2Z]);
format(query, sizeof(query), "%s `pVehicle2C` = '%f',", query, PlayerInfo[playerid][pVehicle2C]);
format(query, sizeof(query), "%s `pVehicle3` = '%d',", query, PlayerInfo[playerid][pVehicle3]);
format(query, sizeof(query), "%s `pVehicle3Model` = '%d',", query, PlayerInfo[playerid][pVehicle3Model]);
format(query, sizeof(query), "%s `pVehicle3Value` = '%d',", query, PlayerInfo[playerid][pVehicle3Value]);
format(query, sizeof(query), "%s `pVehicle3Lock` = '%d',", query, PlayerInfo[playerid][pVehicle3Lock]);
format(query, sizeof(query), "%s `pVehicle3Color1` = '%d',", query, PlayerInfo[playerid][pVehicle3Lock]);
format(query, sizeof(query), "%s `pVehicle3Color2` = '%d',", query, PlayerInfo[playerid][pVehicle3Lock]);
format(query, sizeof(query), "%s `pVehicle3Plate` = '%d',", query, PlayerInfo[playerid][pVehicle3Plate]);
format(query, sizeof(query), "%s `pVehicle3X` = '%f',", query, PlayerInfo[playerid][pVehicle3X]);
format(query, sizeof(query), "%s `pVehicle3Y` = '%f',", query, PlayerInfo[playerid][pVehicle3Y]);
format(query, sizeof(query), "%s `pVehicle3Z` = '%f',", query, PlayerInfo[playerid][pVehicle3Z]);
format(query, sizeof(query), "%s `pVehicle3C` = '%f',", query, PlayerInfo[playerid][pVehicle3C]);
format(query, sizeof(query), "%s `PlayerLevel` = '%d',", query, PlayerInfo[playerid][pLevel]);
format(query, sizeof(query), "%s `BanDays` = '%d',", query, PlayerInfo[playerid][BanDays]);
format(query, sizeof(query), "%s `gPoints` = '%d',", query, PlayerInfo[playerid][gPoints]);
format(query, sizeof(query), "%s `DonateWait` = '%d',", query, PlayerInfo[playerid][DonateWait]);
format(query, sizeof(query), "%s `JobBoost` = '%d',", query, PlayerInfo[playerid][JobBoost]);
format(query, sizeof(query), "%s `sWarns` = '%d',", query, PlayerInfo[playerid][sWarns]);
format(query, sizeof(query), "%s `RobSkill` = '%d',", query, PlayerInfo[playerid][RobSkill]);
format(query, sizeof(query), "%s `Inactivitate` = '%d',", query, 0);
format(query, sizeof(query), "%s `Clan` = '%d',", query, PlayerInfo[playerid][pClan]);
format(query, sizeof(query), "%s `Dice` = '%d',", query, PlayerInfo[playerid][pDice]);
format(query, sizeof(query), "%s `SideJob` = '%d',", query, PlayerInfo[playerid][SideJob]);
format(query, sizeof(query), "%s `GiftWait` = '%d',", query, PlayerInfo[playerid][GiftWait]);
format(query, sizeof(query), "%s `fPunish` = '%d',", query, PlayerInfo[playerid][fPunish]);
format(query, sizeof(query), "%s `Skill1` = '%d',", query, PlayerInfo[playerid][pJobSkillL][1]);
format(query, sizeof(query), "%s `SkillA1` = '%d',", query, PlayerInfo[playerid][pJobSkillA][1]);
format(query, sizeof(query), "%s `SkillN1` = '%d',", query, PlayerInfo[playerid][pJobSkillN][1]);
format(query, sizeof(query), "%s `Skill2` = '%d',", query, PlayerInfo[playerid][pJobSkillL][2]);
format(query, sizeof(query), "%s `SkillA2` = '%d',", query, PlayerInfo[playerid][pJobSkillA][2]);
format(query, sizeof(query), "%s `SkillN2` = '%d',", query, PlayerInfo[playerid][pJobSkillN][2]);
format(query, sizeof(query), "%s `Skill3` = '%d',", query, PlayerInfo[playerid][pJobSkillL][3]);
format(query, sizeof(query), "%s `SkillA3` = '%d',", query, PlayerInfo[playerid][pJobSkillA][3]);
format(query, sizeof(query), "%s `SkillN3` = '%d',", query, PlayerInfo[playerid][pJobSkillN][3]);
format(query, sizeof(query), "%s `Skill4` = '%d',", query, PlayerInfo[playerid][pJobSkillL][4]);
format(query, sizeof(query), "%s `SkillA4` = '%d',", query, PlayerInfo[playerid][pJobSkillA][4]);
format(query, sizeof(query), "%s `SkillN4` = '%d',", query, PlayerInfo[playerid][pJobSkillN][4]);
format(query, sizeof(query), "%s `Skill5` = '%d',", query, PlayerInfo[playerid][pJobSkillL][5]);
format(query, sizeof(query), "%s `SkillA5` = '%d',", query, PlayerInfo[playerid][pJobSkillA][5]);
format(query, sizeof(query), "%s `SkillN5` = '%d',", query, PlayerInfo[playerid][pJobSkillN][5]);
format(query, sizeof(query), "%s `Reports` = '%d',", query, PlayerInfo[playerid][Reports]);
format(query, sizeof(query), "%s `Helps` = '%d',", query, PlayerInfo[playerid][Helps]);
format(query, sizeof(query), "%s `Newbies` = '%d',", query, PlayerInfo[playerid][Newbies]);
format(query, sizeof(query), "%s `FactionActivity` = '%d',", query, PlayerInfo[playerid][fActivity]);
format(query, sizeof(query), "%s `FactionDays` = '%d',", query, PlayerInfo[playerid][fHours]);
format(query, sizeof(query), "%s `Age` = '%d',", query, PlayerInfo[playerid][pAge]);
format(query, sizeof(query), "%s `PhoneNr` = '%d',", query, PlayerInfo[playerid][pPnumber]);
format(query, sizeof(query), "%s `HelperLevel` = '%d',", query, PlayerInfo[playerid][pAdmin]);
format(query, sizeof(query), "%s `AdminLevel` = '%d',", query, PlayerInfo[playerid][pHelper]);
format(query, sizeof(query), "%s `DonateRank` = '%d',", query, PlayerInfo[playerid][pDonateRank]);
format(query, sizeof(query), "%s `Head` = '%d',", query, PlayerInfo[playerid][pHead]);
format(query, sizeof(query), "%s `Face` = '%d',", query, PlayerInfo[playerid][pFace]);
format(query, sizeof(query), "%s `Body` = '%d',", query, PlayerInfo[playerid][pBody]);
format(query, sizeof(query), "%s `Wanted` = '%d',", query, PlayerInfo[playerid][pWanted]);
format(query, sizeof(query), "%s `ConnectedTimeOre` = '%d',", query, PlayerInfo[playerid][pConnectTimeOre]);
format(query, sizeof(query), "%s `ConnectedTimeMinute` = '%d',", query, PlayerInfo[playerid][pConnectTimeMinute]);
format(query, sizeof(query), "%s `ConnectedTimeW` = '%d',", query, PlayerInfo[playerid][pConnectTimeW]);
format(query, sizeof(query), "%s `Registered` = '%d',", query, PlayerInfo[playerid][pReg]);
format(query, sizeof(query), "%s `Sex` = '%d',", query, PlayerInfo[playerid][pSex]);
format(query, sizeof(query), "%s `pRob` = '%d',", query, PlayerInfo[playerid][pRob]);
format(query, sizeof(query), "%s `pBan` = '%d',", query, PlayerInfo[playerid][pLocked]);
format(query, sizeof(query), "%s `pPsbiskey` = '%d',", query, PlayerInfo[playerid][pPsbiskey]);
format(query, sizeof(query), "%s `Muted` = '%d',", query, PlayerInfo[playerid][pMuted]);
format(query, sizeof(query), "%s `MuteTime` = '%d',", query, PlayerInfo[playerid][pMuteTime]);
format(query, sizeof(query), "%s `Respect` = '%d',", query, PlayerInfo[playerid][pExp]);
format(query, sizeof(query), "%s `Money` = '%d',", query, PlayerInfo[playerid][pCash]);
format(query, sizeof(query), "%s `Bank` = '%d',", query, PlayerInfo[playerid][pAccount]);
format(query, sizeof(query), "%s `Crimes` = '%d',", query, PlayerInfo[playerid][pCrimes]);
format(query, sizeof(query), "%s `Phonebook` = '%d',", query, PlayerInfo[playerid][pPhoneBook]);
format(query, sizeof(query), "%s `Job` = '%d',", query, PlayerInfo[playerid][pJob]);
format(query, sizeof(query), "%s `HeadValue` = '%d',", query, PlayerInfo[playerid][pHeadValue]);
format(query, sizeof(query), "%s `Jailed` = '%d',", query, PlayerInfo[playerid][pJailed]);
format(query, sizeof(query), "%s `JailTime` = '%d',", query, PlayerInfo[playerid][pJailTime]);
format(query, sizeof(query), "%s `Drugs` = '%d',", query, PlayerInfo[playerid][pDrugs]);
format(query, sizeof(query), "%s `Leader` = '%d',", query, PlayerInfo[playerid][pLeader]);
format(query, sizeof(query), "%s `Member` = '%d',", query, PlayerInfo[playerid][pMember]);
format(query, sizeof(query), "%s `Rank` = '%d',", query, PlayerInfo[playerid][pRank]);
format(query, sizeof(query), "%s `Chara` = '%d',", query, PlayerInfo[playerid][pChar]);
format(query, sizeof(query), "%s `House` = '%d',", query, PlayerInfo[playerid][pPhousekey]);
format(query, sizeof(query), "%s `pWarn` = '%d',", query, PlayerInfo[playerid][pWarn]);
format(query, sizeof(query), "%s `fWarn` = '%d',", query, PlayerInfo[playerid][fWarn]);
format(query, sizeof(query), "%s `Bizz` = '%d',", query, PlayerInfo[playerid][pPbiskey]);
format(query, sizeof(query), "%s `CarLic` = '%d',", query, PlayerInfo[playerid][pCarLic]);
format(query, sizeof(query), "%s `ClanRank` = '%d',", query, PlayerInfo[playerid][ClanRank]);
format(query, sizeof(query), "%s `FlyLic` = '%d',", query, PlayerInfo[playerid][pFlyLic]);
format(query, sizeof(query), "%s `BoatLic` = '%d',", query, PlayerInfo[playerid][pBoatLic]);
format(query, sizeof(query), "%s `GunLic` = '%d',", query, PlayerInfo[playerid][pGunLic]);
format(query, sizeof(query), "%s `Married` = '%d',", query, PlayerInfo[playerid][pMarried]);
format(query, sizeof(query), "%s `MarriedTo` = '%s',", query, PlayerInfo[playerid][pMarriedTo]);
format(query, sizeof(query), "%s `pLockedReason` = '%s',", query, PlayerInfo[playerid][pLockedReason]);
format(query, sizeof(query), "%s `pLockedBy` = '%s',", query, PlayerInfo[playerid][pLockedBy]);
format(query, sizeof(query), "%s `RegisterDate` = '%s',", query, PlayerInfo[playerid][pRegisterDate]);
format(query, sizeof(query), "%s `IP` = '%s',", query, PlayerInfo[playerid][pIP]);
format(query, sizeof(query), "%s `ClanName` = '%s',", query, PlayerInfo[playerid][ClanName]);
format(query, sizeof(query), "%s `pMarkX` = '%f',", query, PlayerInfo[playerid][pMark][0]);
format(query, sizeof(query), "%s `pMarkY` = '%f',", query, PlayerInfo[playerid][pMark][1]);
format(query, sizeof(query), "%s `pMarkZ` = '%f',", query, PlayerInfo[playerid][pMark][2]);
new Year, Month, Day;
getdate(Year, Month, Day);
new Hour, Minute;
gettime(Hour, Minute);
new numeluna[50];
switch(Month)
{
case 1: numeluna = "Ian";
case 2: numeluna = "Feb";
case 3: numeluna = "Mar";
case 4: numeluna = "Apr";
case 5: numeluna = "Mai";
case 6: numeluna = "Iun";
case 7: numeluna = "Iul";
case 8: numeluna = "Aug";
case 9: numeluna = "Sep";
case 10: numeluna = "Oct";
case 11: numeluna = "Nov";
case 12: numeluna = "Dec";
}
format(PlayerInfo[playerid][pLastOnline], 256 , "%02d %s - %d:%d", Day, numeluna, Hour,Minute);

for(new i = 1; i < 20; i++)
{
new stringul1[50];
format(stringul1,50,"pInvType%d",i);
new stringul2[50];
format(stringul2,50,"pInvCant%d",i);
format(query, sizeof(query), "%s `%s` = '%d',", query, stringul1, PlayerInfo[playerid][pInvType][i]);
format(query, sizeof(query), "%s `%s` = '%d',", query, stringul2, PlayerInfo[playerid][pInvCant][i]);
}
format(query, sizeof(query), "%s `LastOnline` = '%s',", query, PlayerInfo[playerid][pLastOnline]);
mysql_format(mysql, query, sizeof(query), "%s", query);
mysql_query(mysql, query, false);
Reply
#2

Use strcat
formating query and using it inside is probably not valid
PHP код:
new fullquery[1256];
format(querysizeof(query), " `LastOnline` = '%s',"PlayerInfo[playerid][pLastOnline]);
strcat(query,fullquery); 
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)