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

Threaded Mode
error 001: expected token:
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#1

04.08.2016, 12:21
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);
Find
Reply
Fantje
Huge Clucker
****
Posts: 393
Threads: 105
Joined: Dec 2014
Reputation: 0
#2

04.08.2016, 12:37
Somewhere you have used ";" but you need to use "," can't find where for now bc I'm in a hurry.
Find
Reply
Shinja
Gangsta
*****
Posts: 969
Threads: 26
Joined: Jan 2016
Reputation: 0
#3

04.08.2016, 12:40
I think you meant to use strcat, there are many errors here
Find
Reply
SyS
High-roller
*****
Posts: 1,939
Threads: 11
Joined: Oct 2015
Reputation: 0
#4

04.08.2016, 14:47
You are commenting the closing bracket and semicolon (");") in your code thats why you getting this error.
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#5

04.08.2016, 16:16
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 ?
Find
Reply
Konstantinos
Spam Machine
*****
Posts: 11,827
Threads: 33
Joined: Dec 2011
Reputation: 0
#6

04.08.2016, 16:37
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.
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#7

04.08.2016, 17:32
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. 
And error

PHP код:
`CashBanque` = %d, \
    `NumeroTel` = %d, \ 
Find
Reply
Sirop
Big Clucker
***
Posts: 91
Threads: 25
Joined: Oct 2015
Reputation: 0
#8

04.08.2016, 18:47
UP pleases
Find
Reply
Shinja
Gangsta
*****
Posts: 969
Threads: 26
Joined: Jan 2016
Reputation: 0
#9

04.08.2016, 18:55
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
Find
Reply
AndySedeyn
High-roller
*****
Posts: 1,206
Threads: 39
Joined: Feb 2014
Reputation: 0
#10

04.08.2016, 19:22
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); 
Read Konstantinos' reply again.
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