Problème ligne "format" MySQL trop longue

[Hakimo_Crays]

Bonsoir,

Aillant voulu passé mon GM en MySQL je me suis retrouvé avec un petit dilemme

Je doit transformé tout sa:

Code: [Sélectionner]

format(var, 64, "Level=%d\n",PlayerInfo[playerid][pLevel]);fwrite(hFile, var);
format(var, 64, "AdminLevel=%d\n",PlayerInfo[playerid][pAdmin]);fwrite(hFile, var);
format(var, 64, "DonateRank=%d\n",PlayerInfo[playerid][pDonateRank]);fwrite(hFile, var);
format(var, 64, "UpgradePoints=%d\n",PlayerInfo[playerid][gPupgrade]);fwrite(hFile, var);
format(var, 64, "ConnectedTime=%d\n",PlayerInfo[playerid][pConnectTime]);fwrite(hFile, var);
format(var, 64, "Registered=%d\n",PlayerInfo[playerid][pReg]);fwrite(hFile, var);
format(var, 64, "Sex=%d\n",PlayerInfo[playerid][pSex]);fwrite(hFile, var);
format(var, 64, "Age=%d\n",PlayerInfo[playerid][pAge]);fwrite(hFile, var);
format(var, 64, "Origin=%d\n",PlayerInfo[playerid][pOrigin]);fwrite(hFile, var);
format(var, 64, "CK=%d\n",PlayerInfo[playerid][pCK]);fwrite(hFile, var);
format(var, 64, "Muted=%d\n",PlayerInfo[playerid][pMuted]);fwrite(hFile, var);
format(var, 64, "MutedOOC=%d\n",PlayerInfo[playerid][pMutedOOC]);fwrite(hFile, var);
format(var, 64, "Respect=%d\n",PlayerInfo[playerid][pExp]);fwrite(hFile, var);
format(var, 64, "Money=%d\n",PlayerInfo[playerid][pCash]);fwrite(hFile, var);
format(var, 64, "Bank=%d\n",PlayerInfo[playerid][pAccount]);fwrite(hFile, var);
format(var, 64, "Crimes=%d\n",PlayerInfo[playerid][pCrimes]);fwrite(hFile, var);

format(var, 64, "Kills=%d\n",PlayerInfo[playerid][pKills]);fwrite(hFile, var);
format(var, 64, "Deaths=%d\n",PlayerInfo[playerid][pDeaths]);fwrite(hFile, var);
format(var, 64, "Arrested=%d\n",PlayerInfo[playerid][pArrested]);fwrite(hFile, var);
format(var, 64, "WantedDeaths=%d\n",PlayerInfo[playerid][pWantedDeaths]);fwrite(hFile, var);
format(var, 64, "Phonebook=%d\n",PlayerInfo[playerid][pPhoneBook]);fwrite(hFile, var);
format(var, 64, "LottoNr=%d\n",PlayerInfo[playerid][pLottoNr]);fwrite(hFile, var);
format(var, 64, "Fishes=%d\n",PlayerInfo[playerid][pFishes]);fwrite(hFile, var);
format(var, 64, "BiggestFish=%d\n",PlayerInfo[playerid][pBiggestFish]);fwrite(hFile, var);
format(var, 64, "Job=%d\n",PlayerInfo[playerid][pJob]);fwrite(hFile, var);
format(var, 64, "Paycheck=%d\n",PlayerInfo[playerid][pPayCheck]);fwrite(hFile, var);
format(var, 64, "HeadValue=%d\n",PlayerInfo[playerid][pHeadValue]);fwrite(hFile, var);
format(var, 64, "Jailed=%d\n",PlayerInfo[playerid][pJailed]);fwrite(hFile, var);
format(var, 64, "JailTime=%d\n",PlayerInfo[playerid][pJailTime]);fwrite(hFile, var);
format(var, 64, "Materials=%d\n",PlayerInfo[playerid][pMats]);fwrite(hFile, var);
format(var, 64, "Materialsf=%d\n",PlayerInfo[playerid][pMatsf]);fwrite(hFile, var);
format(var, 64, "Drugs=%d\n",PlayerInfo[playerid][pDrugs]);fwrite(hFile, var);
format(var, 64, "Leader=%d\n",PlayerInfo[playerid][pLeader]);fwrite(hFile, var);
format(var, 64, "Member=%d\n",PlayerInfo[playerid][pMember]);fwrite(hFile, var);
format(var, 64, "FMember=%d\n",PlayerInfo[playerid][pFMember]);fwrite(hFile, var);
format(var, 64, "Rank=%d\n",PlayerInfo[playerid][pRank]);fwrite(hFile, var);
format(var, 64, "Char=%d\n",PlayerInfo[playerid][pChar]);fwrite(hFile, var);
format(var, 64, "ContractTime=%d\n",PlayerInfo[playerid][pContractTime]);fwrite(hFile, var);
format(var, 64, "DetSkill=%d\n",PlayerInfo[playerid][pDetSkill]);fwrite(hFile, var);
format(var, 64, "SexSkill=%d\n",PlayerInfo[playerid][pSexSkill]);fwrite(hFile, var);
format(var, 64, "BoxSkill=%d\n",PlayerInfo[playerid][pBoxSkill]);fwrite(hFile, var);
format(var, 64, "LawSkill=%d\n",PlayerInfo[playerid][pLawSkill]);fwrite(hFile, var);
format(var, 64, "MechSkill=%d\n",PlayerInfo[playerid][pMechSkill]);fwrite(hFile, var);
format(var, 64, "JackSkill=%d\n",PlayerInfo[playerid][pJackSkill]);fwrite(hFile, var);
format(var, 64, "CarSkill=%d\n",PlayerInfo[playerid][pCarSkill]);fwrite(hFile, var);
format(var, 64, "NewsSkill=%d\n",PlayerInfo[playerid][pNewsSkill]);fwrite(hFile, var);
format(var, 64, "DrugsSkill=%d\n",PlayerInfo[playerid][pDrugsSkill]);fwrite(hFile, var);
format(var, 64, "CookSkill=%d\n",PlayerInfo[playerid][pCookSkill]);fwrite(hFile, var);
format(var, 64, "FishSkill=%d\n",PlayerInfo[playerid][pFishSkill]);fwrite(hFile, var);
format(var, 64, "pSHealth=%.1f\n",PlayerInfo[playerid][pSHealth]);fwrite(hFile, var);
            GetPlayerHealth(playerid,PlayerInfo[playerid][pHealth]);
format(var, 64, "pHealth=%.1f\n",PlayerInfo[playerid][pHealth]);fwrite(hFile, var);
format(var, 64, "Int=%d\n",PlayerInfo[playerid][pInt]);fwrite(hFile, var);
format(var, 64, "Local=%d\n",PlayerInfo[playerid][pLocal]);fwrite(hFile, var);
format(var, 64, "Team=%d\n",PlayerInfo[playerid][pTeam]);fwrite(hFile, var);
format(var, 64, "Model=%d\n",PlayerInfo[playerid][pModel]);fwrite(hFile, var);
format(var, 64, "PhoneNr=%d\n",PlayerInfo[playerid][pPnumber]);fwrite(hFile, var);
format(var, 64, "Car=%d\n",PlayerInfo[playerid][pPvehkey]);fwrite(hFile, var);
format(var, 64, "Car2=%d\n",PlayerInfo[playerid][pPvehkey2]);fwrite(hFile, var);
format(var, 64, "Car3=%d\n",PlayerInfo[playerid][pPvehkey3]);fwrite(hFile, var);
format(var, 64, "Car4=%d\n",PlayerInfo[playerid][pPvehkey4]);fwrite(hFile, var);
format(var, 64, "House=%d\n",PlayerInfo[playerid][pPhousekey]);fwrite(hFile, var);
format(var, 64, "Bizz=%d\n",PlayerInfo[playerid][pPbiskey]);fwrite(hFile, var);
if ((PlayerInfo[playerid][pPos_x]==0.0 && PlayerInfo[playerid][pPos_y]==0.0 && PlayerInfo[playerid][pPos_z]==0.0))
{
    PlayerInfo[playerid][pPos_x] = 1684.9;
PlayerInfo[playerid][pPos_y] = -2244.5;
PlayerInfo[playerid][pPos_z] = 13.5;
}
if(Spectate[playerid] != 255)
{
PlayerInfo[playerid][pPos_x] = Unspec[playerid][sPx];
PlayerInfo[playerid][pPos_y] = Unspec[playerid][sPy];
PlayerInfo[playerid][pPos_z] = Unspec[playerid][sPz];
PlayerInfo[playerid][pInt] = Unspec[playerid][sPint];
PlayerInfo[playerid][pLocal] = Unspec[playerid][sLocal];
}
format(var, 64, "Pos_x=%.1f\n",PlayerInfo[playerid][pPos_x]);fwrite(hFile, var);
format(var, 64, "Pos_y=%.1f\n",PlayerInfo[playerid][pPos_y]);fwrite(hFile, var);
format(var, 64, "Pos_z=%.1f\n",PlayerInfo[playerid][pPos_z]);fwrite(hFile, var);
format(var, 64, "CarLic=%d\n",PlayerInfo[playerid][pCarLic]);fwrite(hFile, var);
                format(var, 64, "FlyLic=%d\n",PlayerInfo[playerid][pFlyLic]);fwrite(hFile, var);
                format(var, 64, "FlyLicf=%d\n",PlayerInfo[playerid][pFlyLicf]);fwrite(hFile, var);
                format(var, 64, "FlyLict=%d\n",PlayerInfo[playerid][pFlyLict]);fwrite(hFile, var);
format(var, 64, "BoatLic=%d\n",PlayerInfo[playerid][pBoatLic]);fwrite(hFile, var);
format(var, 64, "BoatLicf=%d\n",PlayerInfo[playerid][pBoatLicf]);fwrite(hFile, var);
format(var, 64, "BoatLict=%d\n",PlayerInfo[playerid][pBoatLict]);fwrite(hFile, var);
format(var, 64, "FishLic=%d\n",PlayerInfo[playerid][pFishLic]);fwrite(hFile, var);
format(var, 64, "FishLicf=%d\n",PlayerInfo[playerid][pFishLicf]);fwrite(hFile, var);
format(var, 64, "FishLict=%d\n",PlayerInfo[playerid][pFishLict]);fwrite(hFile, var);
format(var, 64, "LourdLic=%d\n",PlayerInfo[playerid][pLourdLic]);fwrite(hFile, var);
format(var, 64, "LourdLicf=%d\n",PlayerInfo[playerid][pLourdLicf]);fwrite(hFile, var);
format(var, 64, "LourdLict=%d\n",PlayerInfo[playerid][pLourdLict]);fwrite(hFile, var);
format(var, 64, "MotoLic=%d\n",PlayerInfo[playerid][pMotoLic]);fwrite(hFile, var);
format(var, 64, "MotoLicf=%d\n",PlayerInfo[playerid][pMotoLicf]);fwrite(hFile, var);
format(var, 64, "MotoLict=%d\n",PlayerInfo[playerid][pMotoLict]);fwrite(hFile, var);
format(var, 64, "GunLic=%d\n",PlayerInfo[playerid][pGunLic]);fwrite(hFile, var);
format(var, 64, "GunLicf=%d\n",PlayerInfo[playerid][pGunLicf]);fwrite(hFile, var);
format(var, 64, "GunLict=%d\n",PlayerInfo[playerid][pGunLict]);fwrite(hFile, var);
format(var, 64, "Gun1=%d\n",PlayerInfo[playerid][pGun1]);fwrite(hFile, var);
format(var, 64, "Gun2=%d\n",PlayerInfo[playerid][pGun2]);fwrite(hFile, var);
format(var, 64, "Gun3=%d\n",PlayerInfo[playerid][pGun3]);fwrite(hFile, var);
format(var, 64, "Gun4=%d\n",PlayerInfo[playerid][pGun4]);fwrite(hFile, var);
format(var, 64, "skinf=%d\n",PlayerInfo[playerid][pskinf]);fwrite(hFile, var);
format(var, 64, "skinfm=%d\n",PlayerInfo[playerid][pskinfm]);fwrite(hFile, var);
format(var, 64, "Ammo1=%d\n",PlayerInfo[playerid][pAmmo1]);fwrite(hFile, var);
format(var, 64, "Ammo2=%d\n",PlayerInfo[playerid][pAmmo2]);fwrite(hFile, var);
format(var, 64, "Ammo3=%d\n",PlayerInfo[playerid][pAmmo3]);fwrite(hFile, var);
format(var, 64, "Ammo4=%d\n",PlayerInfo[playerid][pAmmo4]);fwrite(hFile, var);
format(var, 64, "CarTime=%d\n",PlayerInfo[playerid][pCarTime]);fwrite(hFile, var);
format(var, 64, "PayDay=%d\n",PlayerInfo[playerid][pPayDay]);fwrite(hFile, var);
format(var, 64, "PayDayHad=%d\n",PlayerInfo[playerid][pPayDayHad]);fwrite(hFile, var);
format(var, 64, "Watch=%d\n",PlayerInfo[playerid][pWatch]);fwrite(hFile, var);
format(var, 64, "GPS=%d\n",PlayerInfo[playerid][pGPS]);fwrite(hFile, var);
format(var, 64, "Tante=%d\n",PlayerInfo[playerid][pTante]);fwrite(hFile, var);
format(var, 64, "Decodeur=%d\n",PlayerInfo[playerid][pDecodeur]);fwrite(hFile, var);
format(var, 64, "Crashed=%d\n",PlayerInfo[playerid][pCrashed]);fwrite(hFile, var);
format(var, 64, "Wins=%d\n",PlayerInfo[playerid][pWins]);fwrite(hFile, var);
format(var, 64, "Loses=%d\n",PlayerInfo[playerid][pLoses]);fwrite(hFile, var);
format(var, 64, "AlcoholPerk=%d\n",PlayerInfo[playerid][pAlcoholPerk]);fwrite(hFile, var);
format(var, 64, "DrugPerk=%d\n",PlayerInfo[playerid][pDrugPerk]);fwrite(hFile, var);
format(var, 64, "MiserPerk=%d\n",PlayerInfo[playerid][pMiserPerk]);fwrite(hFile, var);
format(var, 64, "PainPerk=%d\n",PlayerInfo[playerid][pPainPerk]);fwrite(hFile, var);
format(var, 64, "TraderPerk=%d\n",PlayerInfo[playerid][pTraderPerk]);fwrite(hFile, var);
format(var, 64, "Tutorial=%d\n",PlayerInfo[playerid][pTut]);fwrite(hFile, var);
format(var, 64, "Robbank=%d\n",PlayerInfo[playerid][probbank]);fwrite(hFile, var);
//format(var, 64, "Dormir=%d\n",PlayerInfo[playerid][pDormir]);fwrite(hFile, var);
format(var, 64, "Hotel=%d\n",PlayerInfo[playerid][pHotel]);fwrite(hFile, var);
format(var, 64, "fpermis=%d\n",PlayerInfo[playerid][pfpermis]);fwrite(hFile, var);
format(var, 64, "PointPermis=%d\n",PlayerInfo[playerid][pPointPermis]);fwrite(hFile, var);
format(var, 64, "Mission=%d\n",PlayerInfo[playerid][pMissionNr]);fwrite(hFile, var);
format(var, 64, "Warnings=%d\n",PlayerInfo[playerid][pWarnings]);fwrite(hFile, var);
format(var, 64, "VirWorld=%d\n",PlayerInfo[playerid][pVirWorld]);fwrite(hFile, var);
format(var, 64, "Fuel=%d\n",PlayerInfo[playerid][pFuel]);fwrite(hFile, var);
format(var, 64, "Married=%d\n",PlayerInfo[playerid][pMarried]);fwrite(hFile, var);
format(var, 64, "MarriedTo=%s\n",PlayerInfo[playerid][pMarriedTo]);fwrite(hFile, var);
format(var, 64, "FishTool=%d\n",PlayerInfo[playerid][pFishTool]);fwrite(hFile, var);
    format(var, 64, "Note1=%s\n",PlayerInfo[playerid][pNote1]);fwrite(hFile, var);
format(var, 64, "Note1s=%d\n",PlayerInfo[playerid][pNote1s]);fwrite(hFile, var);
format(var, 64, "Note2=%s\n",PlayerInfo[playerid][pNote2]);fwrite(hFile, var);
format(var, 64, "Note2s=%d\n",PlayerInfo[playerid][pNote2s]);fwrite(hFile, var);
format(var, 64, "Note3=%s\n",PlayerInfo[playerid][pNote3]);fwrite(hFile, var);
format(var, 64, "Note3s=%d\n",PlayerInfo[playerid][pNote3s]);fwrite(hFile, var);
format(var, 64, "Note4=%s\n",PlayerInfo[playerid][pNote4]);fwrite(hFile, var);
format(var, 64, "Note4s=%d\n",PlayerInfo[playerid][pNote4s]);fwrite(hFile, var);
format(var, 64, "Note5=%s\n",PlayerInfo[playerid][pNote5]);fwrite(hFile, var);
format(var, 64, "Note5s=%d\n",PlayerInfo[playerid][pNote5s]);fwrite(hFile, var);
format(var, 64, "InvWeapon=%d\n",PlayerInfo[playerid][pInvWeapon]);fwrite(hFile, var);
format(var, 64, "InvAmmo=%d\n",PlayerInfo[playerid][pInvAmmo]);fwrite(hFile, var);
format(var, 64, "Lighter=%d\n",PlayerInfo[playerid][pLighter]);fwrite(hFile, var);
format(var, 64, "Cigarettes=%d\n",PlayerInfo[playerid][pCigarettes]);fwrite(hFile, var);
format(var, 64, "Mask=%d\n",PlayerInfo[playerid][pMask]);fwrite(hFile, var);
format(var, 32, "WT=%d\n",PlayerInfo[playerid][pWT]);fwrite(hFile, var);
format(var, 32, "WTc=%d\n",PlayerInfo[playerid][pWTc]);fwrite(hFile, var);
format(var, 64, "Lang1=%d\n",PlayerInfo[playerid][pLang1]);fwrite(hFile, var);
format(var, 64, "Lang2=%d\n",PlayerInfo[playerid][pLang2]);fwrite(hFile, var);
format(var, 64, "Work=%d\n",PlayerInfo[playerid][pWork]);fwrite(hFile, var);
format(var, 64, "CanRobTime=%d\n",PlayerInfo[playerid][pRobTime]);fwrite(hFile, var);
format(var, 64, "Locked=%d\n",PlayerInfo[playerid][pLocked]);fwrite(hFile, var);En MySQL, j'ai bien sur commencé:

Code: [Sélectionner]

format(query, sizeof(query), "INSERT INTO `comptes`(`Nom`, `Password`, `Level`, `AdminLevel`, `DonateRank`, `UpgradePoints`, `ConnectedTime`, `Registered`, `Sex`, `Age`, `Origin`, `CK`, `Muted`, `MutedOOC`, `Respect`, `Money`, `Bank`, `Crimes`) VALUES ('%s','%s','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d','%d')", playername3, password, PlayerInfo[playerid][pLevel], PlayerInfo[playerid][pAdmin], PlayerInfo[playerid][pDonateRank], PlayerInfo[playerid][gPupgrade], PlayerInfo[playerid][pConnectTime], PlayerInfo[playerid][pReg], PlayerInfo[playerid][pSex], PlayerInfo[playerid][pAge], PlayerInfo[playerid][pOrigin], PlayerInfo[playerid][pCK], PlayerInfo[playerid][pMuted], PlayerInfo[playerid][pMutedOOC], PlayerInfo[playerid][pExp], PlayerInfo[playerid][pCash], PlayerInfo[playerid][pAccount]);
Malheureusement c'est long à faire et la ligne est trop longue  :bangin
Pendant la compilation:
C:\Users\HP\Desktop\oerp v.SQL\gamemodes\OERP.pwn(16657) : error 075: input line too long (after substitutions)
C:\Users\HP\Desktop\oerp v.SQL\gamemodes\OERP.pwn(16660) : error 075: input line too long (after substitutions)

Je me tourne vers vous pour savoir comment contourné ce problème merci.

[spiirou]

Il n'y aurait pas la possibilité de faire un retour a la ligne avec ce signe \ ?

Genre

Code: [Sélectionner]

format(str, sizeof(str), "blabla super long mais j'ai pas envie de trop en ecrire! \
Oulala il etait temps de passer a la ligne suivante parce que ce devenait super long");
Il me semble que ca se fait, teste dans ton cas :)

[Diablo62]

Merci Spiirou Je ne connaissais pas l'astuce du \ .
Personnellement j'allais à la ligne juste après une virgule :

Code: [Sélectionner]

format(string,sizeof(string),
"   Ecrire autant pour M. %s c'est parfois très embêtant mais par moment ça peut-être marrant ",
playername);

[Hakimo_Crays]

Tout d'abord je tenais à vous remercier de vous être penchez sur mon problème, malheuresement aucune de vos 2 méthodes de fonctionne (La 1er ne fonctionne pas du tout et la deuxième est aussi limité

[raven181]

Et si tu refais une ligne "INSERT INTO" a la suite en ajoutant la suite?

Enfin je suis pas très clair peut être dis moi si tu as compris^^

[mathieu371]

Il n'y a à ma connaissance qu'une solution, tu coupe ton insertion en plusieurs parties. Je m'explique:

format(blabla, sizeof(blabla), "blabla tu coupe apres X caractères");
mysql_query(blabla);
format(blabla, sizeof(blabla), "tu met le reste, si trop long tu recoupe etc..");
mysql_query(blabla);

J'espère que mon message t'ait aidé.

[Xartrick]

Strcat - SA-MP Wiki

[S!m]

Salut,

pour être sur: tu dois utiliser la fonction indiqué par Xartrick.

Il te suffit de faire ta requête en plusieurs parties et ensuite tu les colles ensembles dans le bon ordre à l'aide de strcat.

c'est donc plutôt ainsi:

Code: (pawn) [Sélectionner]

new blabla[768];// ajuste selon la longueur de ta requête
new blabla2[256], blabla[256];
format(blabla, sizeof(blabla), "blabla tu coupe apres X caractères");
format(blabla2, sizeof(blabla2), "tu met le reste, si trop long tu recoupe etc..");
format(blabla3, sizeof(blabla3), "la balance de ta requête");
strcat(blabla, blabla2, sizeof(blabla));
strcat(blabla, blabla3, sizeof(blabla));

Bonne chance

++Sim++