error 001: expected token:
#1

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);
Reply
#2

Somewhere you have used ";" but you need to use "," can't find where for now bc I'm in a hurry.
Reply
#3

I think you meant to use strcat, there are many errors here
Reply
#4

You are commenting the closing bracket and semicolon (");") in your code thats why you getting this error.
Reply
#5

Quote:
Originally Posted by Shinja
Посмотреть сообщение
I think you meant to use strcat, there are many errors here
Yes i meant To use strcat how To use Correctly strcat ?
Reply
#6

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.
Reply
#7

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 075input line too long (after substitutions)
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : error 037invalid string (possibly non-terminated string)
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : error 017undefined symbol "INSERT"
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : error 017undefined symbol "INTO"
C:\Users\Yamaha\Desktop\Serveur Secondair RP\gamemodes\sql.pwn(510) : fatal error 107too many error messages on one line
Compilation aborted
.Pawn compiler 3.2.3664              Copyright (c1997-2006ITB CompuPhase
5 Errors

And error

PHP код:
`CashBanque` = %d, \
    `
NumeroTel` = %d, \ 
Reply
#8

UP pleases
Reply
#9

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'",

is too long, use strcat for it
Reply
#10

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 (column1column2column3VALUES (value1value2value3); 
Read Konstantinos' reply again.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)