error 001: expected token: - Printable Version
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: error 001: expected token: (/showthread.php?tid=614086)
+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: error 001: expected token: (/showthread.php?tid=614086)
error 001: expected token: - Sirop - 04.08.2016
Hello and sorry for my english
Код HTML:
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(489 -- 617) : error 001: expected token: ",", but found ";"
Код HTML:
format(query, sizeof(query), "INSERT INTO `compte` (`Enregistrer` = '%d', `Vie` = '%d', `Gillet` = '%d', `Masque` = '%d', `MasqueID` = '%d', `Faction` = '%d', `Grade` = '%d', `Situation` = '%d'",
format(query, sizeof(query), "%s, `Mort` = '%d', `TempsJail` = '%d', `Warn` = '%d', `Banned` = '%d'",
query,
/*pInfo[playerid][Mort],
pInfo[playerid][JailTime],
pInfo[playerid][Warn],
pInfo[playerid][Baned]*/
//);
format(query, sizeof(query), "%s, `Maison` = '%d', `Commerce` = '%d', `FactionProprietaire` = '%d', `Vehicule1` = '%d', `Vehicule2` = '%d', `Vehicule3` = '%d'",
query,
/*pInfo[playerid][HouseOwner],
pInfo[playerid][BizOwner],
pInfo[playerid][FacOwner],
pInfo[playerid][VehicleOwner],
pInfo[playerid][VehicleOwner2],
pInfo[playerid][VehicleOwner3]*/
//);
format(query, sizeof(query), "%s `Level` = '%d', `Experience` = '%d', `MaxExperience` = '%d', `Skin` = '%d', `Sexe` = '%d', `Cash` = '%d', `CashBanque` = '%d'",
query,
/*pInfo[playerid][Level],
pInfo[playerid][Exp],
pInfo[playerid][MaxExp],
pInfo[playerid][Skin],
pInfo[playerid][Gender],
pInfo[playerid][HandMoney],
pInfo[playerid][BankMoney]*/
//);
format(query, sizeof(query), "%s, `NumeroTel` = '%d', `Cheque` = '%d', `Temps` = '%d', `Amende` = '%d', `Facture` = '%d', `Emprunt` = '%d', `Lotto` = '%d', `Permis` = '%d', `PermisPoint` = '%d', `PortArme` = '%d'",
query,
/*pInfo[playerid][PhoneNumber],
pInfo[playerid][PayeCheck],
pInfo[playerid][PayeTime],
pInfo[playerid][Amende],
pInfo[playerid][Facture],
pInfo[playerid][Emprunt],
pInfo[playerid][Lotto],
pInfo[playerid][Permis],
pInfo[playerid][PermisPoint],
pInfo[playerid][PortArme]*/
//);
format(query, sizeof(query), "%s `Montre` = '%d', `GPS` = '%d', `Canne` = '%s', `Telephone` = '%s', `Credits` = '%d', `Identite` = '%d', `GramDrogue1` = '%d', `GramDrogue2` = '%d'",
query,
/*pInfo[playerid][Montre],
pInfo[playerid][Gps],
pInfo[playerid][Canne],
pInfo[playerid][Phone],
pInfo[playerid][Credits],
pInfo[playerid][CarteIden],
pInfo[playerid][DrogueFab1],
pInfo[playerid][DrogueFab2]*/
//);
/*
for (new i = 0; i < 13; i ++) {
format(query, sizeof(query), "%s, `Gun%d` = '%d', `Ammo%d` = '%d'", query, i + 1, pInfo[playerid][pGuns][i], i + 1, pInfo[playerid][pAmmo][i]);
}
*/
format(query, sizeof(query), "%s, `GramDrogue3` = '%d', `Cocaine` = '%d', `Heroine` = '%d', `Ecstacy` = '%d', `Arme1` = '%d', `Minition1` = '%d', `Arme2` = '%d', `Minition2` = '%d', `Arme3` = '%d', `Minition3` = '%d', `Arme4` = '%d', `Minition4` = '%d', `Arme5` = '%d', `Minition5` = '%d', `Arme6` = '%d', `Minition6` = '%d', `Arme7` = '%d', `Minition7` = '%d')",
query,
format(query, sizeof(query), "%s, VALUES('%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', '%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')",
query,
pInfo[playerid][Registered],
pInfo[playerid][Health],
pInfo[playerid][Armour],
pInfo[playerid][Mask],
pInfo[playerid][MaskID],
pInfo[playerid][SecteID],
pInfo[playerid][Grade],
pInfo[playerid][LastPos],
pInfo[playerid][Mort],
pInfo[playerid][JailTime],
pInfo[playerid][Warn],
pInfo[playerid][Baned],
pInfo[playerid][HouseOwner],
pInfo[playerid][BizOwner],
pInfo[playerid][FacOwner],
pInfo[playerid][VehicleOwner],
pInfo[playerid][VehicleOwner2],
pInfo[playerid][VehicleOwner3],
pInfo[playerid][Level],
pInfo[playerid][Exp],
pInfo[playerid][MaxExp],
pInfo[playerid][Skin],
pInfo[playerid][Gender],
pInfo[playerid][HandMoney],
pInfo[playerid][BankMoney],
pInfo[playerid][PhoneNumber],
pInfo[playerid][PayeCheck],
pInfo[playerid][PayeTime],
pInfo[playerid][Amende],
pInfo[playerid][Facture],
pInfo[playerid][Emprunt],
pInfo[playerid][Lotto],
pInfo[playerid][Permis],
pInfo[playerid][PermisPoint],
pInfo[playerid][PortArme],
pInfo[playerid][Montre],
pInfo[playerid][Gps],
pInfo[playerid][Canne],
pInfo[playerid][Phone],
pInfo[playerid][Credits],
pInfo[playerid][CarteIden],
pInfo[playerid][DrogueFab1],
pInfo[playerid][DrogueFab2],
pInfo[playerid][DrogueFab3],
pInfo[playerid][Cocaine],
pInfo[playerid][Heroine],
pInfo[playerid][Ecstacy],
pInfo[playerid][Weapon1],
pInfo[playerid][Wep1Ammo],
pInfo[playerid][Weapon2],
pInfo[playerid][Wep2Ammo],
pInfo[playerid][Weapon3],
pInfo[playerid][Wep3Ammo],
pInfo[playerid][Weapon4],
pInfo[playerid][Wep4Ammo],
pInfo[playerid][Weapon5],
pInfo[playerid][Wep5Ammo],
pInfo[playerid][Weapon6],
pInfo[playerid][Wep6Ammo],
pInfo[playerid][Weapon7],
pInfo[playerid][Wep7Ammo]
);
mysql_tquery(g_iHandle, query, "Enregistrement", "dd", playerid, CREATION);
mysql_tquery(g_iHandle, query);
Re: error 001: expected token: - Fantje - 04.08.2016
Somewhere you have used ";" but you need to use "," can't find where for now bc I'm in a hurry.
Re: error 001: expected token: - Shinja - 04.08.2016
I think you meant to use strcat, there are many errors here
Re: error 001: expected token: - SyS - 04.08.2016
You are commenting the closing bracket and semicolon (");") in your code thats why you getting this error.
Re: error 001: expected token: - Sirop - 04.08.2016
Quote:
|
Originally Posted by Shinja
 I think you meant to use strcat, there are many errors here
|
Re: error 001: expected token: - Konstantinos - 04.08.2016
First of all the syntax is incorrect. If you want to have them as "column = value", then you have to use SET after the table's name otherwise use the standard way "INSERT INTO table (fields..) VALUES (values..)" or if you set every single column, you can ignore the name of the fields; however, they must be in order.
The table's design is bad, read more here: https://sampforum.blast.hk/showthread.php?tid=505081
Have default values when needed. I doubt all those variables hold a different value than the original set.
Re: error 001: expected token: - Sirop - 04.08.2016
I have changed
Код HTML:
SQL_CreationCompte(playerid)
{
if (!pInfo[playerid][pLogged])
return 0;
static
query[128];
mysql_format(query, sizeof(query), "INSERT INTO `compte` (`Enregistrer` = %d, \
`Vie` = %d, \
`Gillet` = %d, \
`Masque` = %d, \
`MasqueID` = %d, \
`Faction` = '%e', \
`Grade` = %d, \
`Situation` = %d, \
`Mort` = %d, \
`TempsJail` = %d, \
`Warn` = %d, \
`Banned` = %d, \
`Maison` = %d, \
`Commerce` = %d, \
`FactionProprietaire` = %d, \
`Vehicule1` = %d, \
`Vehicule2` = %d, \
`Vehicule3` = %d, \
`Level` = %d, \
`Experience` = %d, \
`MaxExperience` = %d, \
`Skin` = %d, \
`Sexe` = %d, \
`Cash` = %d, \
`CashBanque` = %d, \
`NumeroTel` = %d, \
`Cheque` = %d, \
`Temps` = %d, \
`Amende` = %d, \
`Facture` = %d, \
`Emprunt` = %d, \
`Lotto` = %d, \
`Permis` = %d, \
`PermisPoint` = %d, \
`PortArme` = %d, \
`Montre` = %d, \
`GPS` = %d, \
`Canne` = %d, \
`Telephone` = %d, \
`Credits` = %d, \
`Identite` = %d, \
`GramDrogue1` = %d, \
`GramDrogue2` = %d, \
`GramDrogue3` = %d, \
`Cocaine` = %d, \
`Heroine` = %d, \
`Ecstacy` = %d, \
`Arme1` = %d, \
`Minition1` = %d, \
`Arme2` = %d, \
`Minition2` = %d, \
`Arme3` = %d, \
`Minition3` = %d, \
`Arme4` = %d, \
`Minition4` = %d, \
`Arme5` = %d, \
`Minition5` = %d, \
`Arme6` = %d, \
`Minition6` = %d, \
`Arme7` = %d, \
`Minition7` = %d \
WHERE `ID` = %d \
VALUES('%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', '%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'",
pInfo[playerid][Registered],
pInfo[playerid][Health],
pInfo[playerid][Armour],
pInfo[playerid][Mask],
pInfo[playerid][MaskID],
pInfo[playerid][SecteID],
pInfo[playerid][Grade],
pInfo[playerid][LastPos],
pInfo[playerid][Mort],
pInfo[playerid][JailTime],
pInfo[playerid][Warn],
pInfo[playerid][Baned],
pInfo[playerid][HouseOwner],
pInfo[playerid][BizOwner],
pInfo[playerid][FacOwner],
pInfo[playerid][VehicleOwner],
pInfo[playerid][VehicleOwner2],
pInfo[playerid][VehicleOwner3],
pInfo[playerid][Level],
pInfo[playerid][Exp],
pInfo[playerid][MaxExp],
pInfo[playerid][Skin],
pInfo[playerid][Gender],
pInfo[playerid][HandMoney],
pInfo[playerid][BankMoney],
pInfo[playerid][PhoneNumber],
pInfo[playerid][PayeCheck],
pInfo[playerid][PayeTime],
pInfo[playerid][Amende],
pInfo[playerid][Facture],
pInfo[playerid][Emprunt],
pInfo[playerid][Lotto],
pInfo[playerid][Permis],
pInfo[playerid][PermisPoint],
pInfo[playerid][PortArme],
pInfo[playerid][Montre],
pInfo[playerid][Gps],
pInfo[playerid][Canne],
pInfo[playerid][Phone],
pInfo[playerid][Credits],
pInfo[playerid][CarteIden],
pInfo[playerid][DrogueFab1],
pInfo[playerid][DrogueFab2],
pInfo[playerid][DrogueFab3],
pInfo[playerid][Cocaine],
pInfo[playerid][Heroine],
pInfo[playerid][Ecstacy],
pInfo[playerid][Weapon1],
pInfo[playerid][Wep1Ammo],
pInfo[playerid][Weapon2],
pInfo[playerid][Wep2Ammo],
pInfo[playerid][Weapon3],
pInfo[playerid][Wep3Ammo],
pInfo[playerid][Weapon4],
pInfo[playerid][Wep4Ammo],
pInfo[playerid][Weapon5],
pInfo[playerid][Wep5Ammo],
pInfo[playerid][Weapon6],
pInfo[playerid][Wep6Ammo],
pInfo[playerid][Weapon7],
pInfo[playerid][Wep7Ammo],
pInfo[playerid][pID]
);
mysql_tquery(g_iHandle, query, "Apres", "dd", playerid, Creation);
mysql_tquery(g_iHandle, query);
return 1;
}
PHP код:
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(509) : error 075: input line too long (after substitutions)
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : error 037: invalid string (possibly non-terminated string)
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : error 017: undefined symbol "INSERT"
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : error 017: undefined symbol "INTO"
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : fatal error 107: too many error messages on one line
Compilation aborted.Pawn compiler 3.2.3664 Copyright (c) 1997-2006, ITB CompuPhase
5 Errors.
PHP код:
`CashBanque` = %d, \
`NumeroTel` = %d, \
Re: error 001: expected token: - Sirop - 04.08.2016
UP pleases
Re: error 001: expected token: - Shinja - 04.08.2016
Error says this line
Quote:
|
VALUES('%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', '%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'", |
Re: error 001: expected token: - AndySedeyn - 04.08.2016
That query looks like a query of someone else's topic yesterday. It's equally bad. Wrapping specifiers in a pair of single quotes is only done when that specifier is replaced by a string (%s, %e,...).
An insert query looks like this:
PHP код:
INSERT INTO table_name (column1, column2, column3) VALUES (value1, value2, value3);