Mysql - (error #1064)
#1

Hello all guys, how are you going? and yeah, the problem which I don't really like, but it finally fallen on me

I tried solving this by myself, but without result..


mysql_log :
PHP код:
[19:32:29 02/04/18] [ERRORCMySQLQuery::Execute[] - (error #1064) Erreur de syntaxe prиs de 'Rename = 0 WHERE ID = 0' а la ligne 1 (Query: "UPDATE srv_users SET Niveau = 1, Respect = 5, ServiceMinute = 0, MinExp = 1, AdminLevel = 10012, Banexp = 0, Banm = 0, Bany = 0, Banhour = 0, Banmin = 0, RaisonBanni = '', VIP = 0, Rename = 0 WHERE ID = 0") 
server_log :
PHP код:
[19:31:38UPDATE srv_users SET Niveau 1Respect 1ServiceMinute 0MinExp 0AdminLevel 10012Banexp 0Banm 0Bany 0Banhour 0Banmin 0RaisonBanni ''VIP 0Rename 0 WHERE ID 
Script :
Код:
Users_Save(userid)
{

	static
 		query[5054];

	format(query,sizeof(query), "UPDATE srv_users SET Niveau = %d, Respect = %d, ServiceMinute = %d, MinExp = %d, AdminLevel = %d, Banexp = %d, Banm = %d, Bany = %d, Banhour = %d, Banmin = %d, RaisonBanni = '%s', VIP = %d, Rename = %d WHERE ID = %d",
 	PlayerInfo[userid][pNiveau],
  	PlayerInfo[userid][pRespect],
 	PlayerInfo[userid][pServiceMinute],
   	PlayerInfo[userid][pMinExp],
   	PlayerInfo[userid][pAdminLevel],
    PlayerInfo[userid][pBanexp],
    PlayerInfo[userid][pBanm],
    PlayerInfo[userid][pBany],
    PlayerInfo[userid][pBanhour],
    PlayerInfo[userid][pBanmin],
    PlayerInfo[userid][pRaisonBanni],
    PlayerInfo[userid][pVIP],
    PlayerInfo[userid][pRename],
	PlayerInfo[userid][pID]);
	mysql_tquery(g_iHandle, query, "", "");
}
Can anyone give me a bit of help please
Reply


Messages In This Thread
Mysql - (error #1064) - by Maximun - 04.02.2018, 18:55
Re: Mysql - (error #1064) - by JasonRiggs - 04.02.2018, 19:38
Re: Mysql - (error #1064) - by Maximun - 04.02.2018, 20:30
Re: Mysql - (error #1064) - by Mugala - 04.02.2018, 21:29
Re: Mysql - (error #1064) - by Maximun - 04.02.2018, 22:54
Re: Mysql - (error #1064) - by Misiur - 05.02.2018, 17:02

Forum Jump:


Users browsing this thread: 1 Guest(s)