Command ban by IP

[MORTE 55]

Does anyone know how I can make a new table over a command to ban an IP address can not access to play with IP banned? I just need the function block IP in IP table type places there and can not login with it because I can do command, if anyone can help me I appreciate.

[Denis 1322]

Open input_auth.cpp and find those strings:

	if (false == FN_IS_VALID_LOGIN_STRING(login))
	{
		sys_log(0, "InputAuth::Login : IS_NOT_VALID_LOGIN_STRING(%s) desc %p",
				login, get_pointer(d));
		LoginFailure(d, "NOID");
		return;
	}

under that add this:

	char query[1024];
	snprintf(query, sizeof(query),"SELECT ip FROM player.ban_ip WHERE ip = '%s'", inet_ntoa(d->GetAddr().sin_addr));
	std::auto_ptr<SQLMsg> execquery(DBManager::instance().DirectQuery(query));
	
	if (execquery->Get()->uiNumRows >= 1)
	{
		LoginFailure(d, "BAN_IP");
		return;		
	}

I didn't test it but it should work

 

You just need to create a table in player called ban_ip and add one field called ip with text type

 

Edit: Open intrologin.py and find this:

self.loginFailureMsgDict={

and add this:

			"BAN_IP"	: "You have an ip ban",

[MORTE 55]

 

Open input_auth.cpp and find those strings:

	if (false == FN_IS_VALID_LOGIN_STRING(login))
	{
		sys_log(0, "InputAuth::Login : IS_NOT_VALID_LOGIN_STRING(%s) desc %p",
				login, get_pointer(d));
		LoginFailure(d, "NOID");
		return;
	}

under that add this:

	char query[1024];
	snprintf(query, sizeof(query),"SELECT ip FROM player.ban_ip WHERE ip = '%s'", d->GetAddr().sin_addr);
	std::auto_ptr<SQLMsg> execquery(DBManager::instance().DirectQuery(query));
	
	if (execquery->Get()->uiNumRows >= 1)
	{
		LoginFailure(d, "BAN_IP");
		return;		
	}

I didn't test it but it should work

 

You just need to create a table in player called ban_ip and add one field called ip with text type

 

Edit: Open intrologin.py and find this:

self.loginFailureMsgDict={

and add this:

			"BAN_IP"	: "You have an ip ban",

 

thanks

only takes me a question that I have to create player.ban_ip ?? because i did not muitom this function.;

[Denis 1322]

you need to create a table called ban_ip

[MORTE 55]

yes but what settings it should have?

[Denis 1322]

add a field ip with text type

[designer132 6]

 

Open input_auth.cpp and find those strings:

	if (false == FN_IS_VALID_LOGIN_STRING(login))
	{
		sys_log(0, "InputAuth::Login : IS_NOT_VALID_LOGIN_STRING(%s) desc %p",
				login, get_pointer(d));
		LoginFailure(d, "NOID");
		return;
	}

under that add this:

	char query[1024];
	snprintf(query, sizeof(query),"SELECT ip FROM player.ban_ip WHERE ip = '%s'", d->GetAddr().sin_addr);
	std::auto_ptr<SQLMsg> execquery(DBManager::instance().DirectQuery(query));
	
	if (execquery->Get()->uiNumRows >= 1)
	{
		LoginFailure(d, "BAN_IP");
		return;		
	}

I didn't test it but it should work

 

You just need to create a table in player called ban_ip and add one field called ip with text type

 

Edit: Open intrologin.py and find this:

self.loginFailureMsgDict={

and add this:

			"BAN_IP"	: "You have an ip ban",

 

You have little mistake in the code, should be:

	char query[1024];
	snprintf(query, sizeof(query),"SELECT ip FROM player.ban_ip WHERE ip = '%s'", inet_ntoa(d->GetAddr().sin_addr));
	std::auto_ptr<SQLMsg> execquery(DBManager::instance().DirectQuery(query));
	
	if (execquery->Get()->uiNumRows >= 1)
	{
		LoginFailure(d, "BAN_IP");
		return;		
	}

PS. It's work

[Denis 1322]

I forgot to add inet_ntoa ^^ thanks