[rakshith122]

I use > jBan include for bans on my server
Everything works perfect. But, I just want to know something. I would like to show a dialog for player who connects(if he is banned). It should check his ban_time, ban_reason, ban_time, time remaining, and the one who banned the player and show a dialog containing all these information to the user who is connecting(if banned).

I just want to know how to get those details from my MySQL database.

Some one help me! D:

[yvoms]

here is the code for getting information from the database,

Код:

	if(strlen(account) > 24) return SendClientMessage(playerid, COLOR_RED, "Player name cannot exceed 24 characters.");
	{
	format(Query, sizeof(Query), "SELECT Username, Reason, Admin, IP FROM `Bans` WHERE `Username` = '%s' AND `Banned` = 1 LIMIT 1", account);
	mysql_query(Query);
	mysql_store_result();
	if(mysql_num_rows() == 0)

[rakshith122]

you didn't understand the rest of the question.
I would like to show a dialog containing all these information to the player who is connected(only if he is banned)