[DJRambo]

Код:

	format(bQuery, 600, "SELECT * FROM `bans` WHERE `username` = '%q'", GetName(playerid));
	jResult = db_query(Database, bQuery);

	if(db_num_rows(jResult))
	{
	    db_get_field_assoc(jResult, "banby", admin, 128);
	    db_get_field_assoc(jResult, "banreason", reason, 128);
	    db_get_field_assoc(jResult, "banwhen", when, 128);

		format(string, sizeof(string), "%s has connected to the server, Got kicked for being banned.", GetName(playerid));
		Log("finn.txt", string);

		AddBan(User[playerid][accountIP], 1);

		ShowBan(playerid, admin, reason, when);
		
		KickDelay(playerid);
	    return 1;
	}

that's sqlite query. do i need to add this to the ban command

its listed as unban already

Код:

format(Query, 129, "SELECT FROM `bans` WHERE `username` = '%q'", Account);
		Result = db_query(Database, Query);

		if(db_num_rows(Result))
		{
        	db_get_field_assoc(Result, "ip", fIP, 30);
			if(CheckBan(fIP))
			{
				RemoveBan(fIP);
			}
	        format(Query, 129, "DELETE FROM `bans` WHERE `username` = '%q'", Account);
		    Result = db_query(Database, Query);
	        db_free_result(Result);