Thread: [SQL] Error
View Single Post
Author Message
Had3s99
Member
Join Date: Sep 2015
Location: France
Old 08-18-2019 , 16:38   [SQL] Error
Reply With Quote #1

Hello,

I've my code :

Code:
public void T_SelectPlayerTime(Database db, DBResultSet results, const char[] error, any data) {
	int client = 0;

	if ((client = GetClientOfUserId(data)) == 0) {
		return;
	}
	
	if (results == null) {
		LogError("T_SelectPlayerTime failed! %s", error);
	}
	else if(results.RowCount == 0) {
		char l_sQuery[256];
	
		char l_sPseudo[64];
		char l_sSteamId[64];
		
		GetClientName(client, STRING(l_sPseudo));
		GetClientAuthId(client, AuthId_Steam2, STRING(l_sSteamId));
		
		Time[client] = 0;

		FormatEx(l_sQuery, sizeof(l_sQuery), "INSERT INTO `Time_Players` (Pseudo, SteamId) VALUES ('%s', '%s')", l_sPseudo, l_sSteamId);
		Dbase.Query(T_InsertPlayerTime, l_sQuery, _, DBPrio_Low);
	}
}

public void T_InsertPlayerTime(Database db, DBResultSet results, const char[] error, any data) {
	if (results == null) {
		LogError("T_InsertPlayerTime failed! %s", error);
	}
}
And i've this error :

Code:
L 08/18/2019 - 21:55:10: [csgo_timer.smx] T_InsertPlayerTime failed! You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ballz', 'STEAM_1:1:86693297')' at line 1
What is my error ?

Thanks,

Had3s99.
__________________

Last edited by Had3s99; 08-18-2019 at 16:41.
Had3s99 is offline