[Nikol4u]

I have created a rather very simple sql ban plugin.
Whenever a player connects I run the cmdCheckPlayer() to see if he is banned or not.

Connection to the database is fine, however I get SQL_NumResults(query) to be 0

This is what I log:

L 04/03/2015 - 17:13:58: [sqlbans.amxx] SELECT * FROM `e107_server_bans` WHERE (`sb_steam`='STEAM_0:0xxxxxx' OR `sb_ip` = 'xx.xx.xx.xx') AND (`sb_date` + `sb_time` > '1428081238' OR `sb_time` = '0') L 04/03/2015 - 17:13:59: [sqlbans.amxx] number of rows 0 L 04/03/2015 - 17:13:59: [sqlbans.amxx] user is not banned

And when I run the same query through phpMyAdmin I am getting 1 result.

Have I done something wrong?

public cmdCheckPlayer( plr )
{
	static query[256], authid[36], ip[16], playerId[1];
	playerId[0] = plr;

	get_user_authid( plr, authid, sizeof authid - 1 );
	get_user_ip( plr, ip, sizeof ip - 1, 1 );

	formatex( query, 256, "SELECT `sb_reason` FROM `%s` WHERE (`sb_steam`='%s' OR `sb_ip` = '%s') AND (`sb_date` +  `sb_time` > '%d' OR `sb_time` = '0')", g_SqlTable, authid, ip, get_systime() );
	log_amx(query);
	SQL_ThreadQuery( g_SqlTuple, "fnSqlBanSearch", query, playerId, 1 );
	
	log_amx(query);
}

public fnSqlBanSearch( failstate, Handle:query, error[], errorcode, data[], size, Float:queuetime )
{	
	if( !query_failed( failstate, error, errorcode ) )
	{
		static plr;
		plr = data[0];
		
		static te[256];
		
		formatex(te, 256, "number of rows %i", SQL_NumResults( query ) );
		log_amx(te);
		
		if( SQL_NumResults( query ) )
		{
			static reason[192];
			
			SQL_ReadResult( query, 0, reason, sizeof reason - 1 );
			
			client_print( plr, print_console, "[%s] You are banned from this server",g_ServerName );
			plr += 200;
			set_task( 0.1, "delayed_kick", plr );
		}
		else
		{
			log_amx("user is not banned");
		}
	}
	
	return PLUGIN_HANDLED;
}

public query_failed( failstate, error[], errornum )
{
	if( failstate == TQUERY_CONNECT_FAILED )
	{
		log_amx( "[SQL] Could not connect to database: %s", error );
		return 1;
	}
	else if( failstate == TQUERY_QUERY_FAILED )
	{
		log_amx( "[SQL] Query failed: %s", error );
		return 1;
	}
   
	if( errornum )
	{
		log_amx( "[SQL] Query Error: %s", error );
		return 1;
	}
	
	return 0;
}

[Nikol4u]

bump?

[Bugsy]

When I write queries I do not wrap anything but strings in quotes. The below (to me) is comparing a numerical value against a string of numbers, not a numerical value. I'm not sure if the SQL processor can interpret this properly, but try what I posted below and see if you get a different result:

`sb_date` + `sb_time` > '1428081238'

Mind you, I use MS Access 2010 so I'm not sure if MySQL\SQLite differ in this regard, but worth a try.

See if this works

SELECT * 
FROM e107_server_bans 
WHERE (sb_steam='STEAM_0:0xxxxxx' OR sb_ip='xx.xx.xx.xx') AND 
((sb_date + sb_time) > 1428081238 OR sb_time = 0);