[Parallex]

Hey there everyone,

So this is the offline ban command from my script. There is one problem with the command. Even if the account which we are attempting to ban exists, it gives us the message "* User not found!"* even though it exists. This is the code:

Код:

YCMD:oban(playerid, params[], help) {
	if(help) {
		SendClientMessage(playerid, X11_WHITE, "Bans an offline player");
		return 1;
	}
	new username[(MAX_PLAYER_NAME*2)+1],reason[128];
	if(!sscanf(params,"s[" #MAX_PLAYER_NAME "]s[128]",username,reason)) {
		mysql_real_escape_string(username, username);
		format(query, sizeof(query), "select INET_NTOA(`ip`),a.id FROM connections ca INNER JOIN characters c on c.id = ca.charid inner join accounts a on a.id = c.accountid where (c.username = \"%s\" OR a.username = \"%s\") ORDER BY ca.id DESC LIMIT 0,1",username,username);
		mysql_function_query(g_mysql_handle, query, true, "OnOfflineBanPlayer", "dss",playerid,username,reason);
	} else {
		SendClientMessage(playerid, X11_WHITE, "USAGE: /oban [username] [reason]");
	}
	return 1;
}

public OnOfflineBanPlayer(playerid, name[],reason[]) {
	new ip[16],accid[16];
	new rows, fields;
	cache_get_data(rows, fields);
	if(rows < 1) {
		SendClientMessage(playerid, X11_TOMATO_2, "* User not found");
		return 1;
	}
	cache_get_row(0,0,ip);
	cache_get_row(0,1,accid);
	format(query, sizeof(query),"INSERT INTO `bans` SET `bannerid` = %d,`reason` = \"%s\",`accountid` = %d,`ip` = INET_ATON(\"%s\")",GetPVarInt(playerid, "AccountID"), reason, strval(accid),ip);
	mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");
	format(query, sizeof(query), "[AdmWarn]: %s has OBanned %s: %s",GetPlayerNameEx(playerid, ENameType_AccountName), name, reason);
	ABroadcast(X11_TOMATO_2, query, EAdminFlags_All);
	return 1;
}

Any help would be appreciated as to why it does that.

[Hunud]

Try this.

Код:

public OnOfflineBanPlayer(playerid, name[],reason[]) {
	new ip[16],accid[16];
	new rows, fields;
	cache_get_data(rows, fields);
	if(rows > 0) {
		SendClientMessage(playerid, X11_TOMATO_2, "* User not found");
		return 1;
	}
	cache_get_row(0,0,ip);
	cache_get_row(0,1,accid);
	format(query, sizeof(query),"INSERT INTO `bans` SET `bannerid` = %d,`reason` = \"%s\",`accountid` = %d,`ip` = INET_ATON(\"%s\")",GetPVarInt(playerid, "AccountID"), reason, strval(accid),ip);
	mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");
	format(query, sizeof(query), "[AdmWarn]: %s has OBanned %s: %s",GetPlayerNameEx(playerid, ENameType_AccountName), name, reason);
	ABroadcast(X11_TOMATO_2, query, EAdminFlags_All);
	return 1;
}

[Parallex]

Quote:

Originally Posted by Hunud Try this. Код: public OnOfflineBanPlayer(playerid, name[],reason[]) { new ip[16],accid[16]; new rows, fields; cache_get_data(rows, fields); if(rows > 0) { SendClientMessage(playerid, X11_TOMATO_2, "* User not found"); return 1; } cache_get_row(0,0,ip); cache_get_row(0,1,accid); format(query, sizeof(query),"INSERT INTO `bans` SET `bannerid` = %d,`reason` = \"%s\",`accountid` = %d,`ip` = INET_ATON(\"%s\")",GetPVarInt(playerid, "AccountID"), reason, strval(accid),ip); mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", ""); format(query, sizeof(query), "[AdmWarn]: %s has OBanned %s: %s",GetPlayerNameEx(playerid, ENameType_AccountName), name, reason); ABroadcast(X11_TOMATO_2, query, EAdminFlags_All); return 1; }

As expected, it does not seem to work.

It does say that the user has been offline banned yet the user is still not banned. Moreover, even if the account doesn't exist, it still shows the message that the account has been banned.