cacti/scripts/ss_mikrotik_qusers.php

<?php
/*
 +-------------------------------------------------------------------------+
 | Copyright (C) 2004-2026 The Cacti Group                                 |
 |                                                                         |
 | This program is free software; you can redistribute it and/or           |
 | modify it under the terms of the GNU General Public License             |
 | as published by the Free Software Foundation; either version 2          |
 | of the License, or (at your option) any later version.                  |
 |                                                                         |
 | This program is distributed in the hope that it will be useful,         |
 | but WITHOUT ANY WARRANTY; without even the implied warranty of          |
 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the           |
 | GNU General Public License for more details.                            |
 +-------------------------------------------------------------------------+
 | Cacti: The Complete RRDTool-based Graphing Solution                     |
 +-------------------------------------------------------------------------+
 | This code is designed, written, and maintained by the Cacti Group. See  |
 | about.php and/or the AUTHORS file for specific developer information.   |
 +-------------------------------------------------------------------------+
 | http://www.cacti.net/                                                   |
 +-------------------------------------------------------------------------+
*/

// display no errors
error_reporting(0);

if (!isset($called_by_script_server)) {
	include(__DIR__ . '/../include/cli_check.php');
	array_shift($_SERVER['argv']);
	print call_user_func_array('ss_mikrotik_qusers', $_SERVER['argv']);
}

function ss_mikrotik_qusers(int $host_id, string $cmd = 'index', string $arg1 = '', string $arg2 = '') : mixed {
	if ($cmd == 'index') {
		$return_arr = ss_mikrotik_qusers_getnames($host_id);

		for ($i = 0; ($i < cacti_sizeof($return_arr)); $i++) {
			print $return_arr[$i] . "\n";
		}
	} elseif ($cmd == 'query') {
		$arr_index = ss_mikrotik_qusers_getnames($host_id);
		$arr       = ss_mikrotik_qusers_getinfo($host_id, $arg1);

		for ($i = 0; ($i < cacti_sizeof($arr_index)); $i++) {
			if (isset($arr[$arr_index[$i]])) {
				print $arr_index[$i] . '!' . $arr[$arr_index[$i]] . "\n";
			}
		}
	} elseif ($cmd == 'get') {
		$arg   = $arg1;
		$index = $arg2;

		return ss_mikrotik_qusers_getvalue($host_id, $index, $arg);
	}

	return null;
}

function ss_mikrotik_qusers_getvalue(int $host_id, string $index, string $column) : string {
	switch ($column) {
		case 'curBytesIn':
		case 'curBytesOut':
		case 'curPacketsIn':
		case 'curPacketsOut':
		case 'connectTime':
			$value = db_fetch_cell_prepared("SELECT
			$column AS value
			FROM plugin_mikrotik_users
			WHERE name = ?
			AND host_id = ?",
				[$index, $host_id]);

			break;
		case 'avgBytesIn':
		case 'avgBytesOut':
		case 'avgPacketsIn':
		case 'avgPacketsOut':
			$column = str_replace('avgB', 'b', $column);
			$column = str_replace('avgP', 'p', $column);
			$value  = db_fetch_cell_prepared("SELECT
			IF(connectTime>0,($column/connectTime),0) AS value
			FROM plugin_mikrotik_users
			WHERE name = ?
			AND host_id = ?",
				[$index, $host_id]);

			break;
		case 'bytesIn':
		case 'bytesOut':
		case 'packetsIn':
		case 'packetsOut':
			$value = db_fetch_cell_prepared("SELECT
			$column AS value
			FROM plugin_mikrotik_users
			WHERE name = ?
			AND host_id = ?",
				[$index, $host_id]);

			break;
	}

	if (!empty($value)) {
		return $value;
	} else {
		return '0';
	}
}

function ss_mikrotik_qusers_getnames(int $host_id) : array {
	$return_arr = [];

	$arr = db_fetch_assoc_prepared("SELECT DISTINCT name
		FROM plugin_mikrotik_users
		WHERE host_id = ?
		AND name!=''
		ORDER BY name",
		[$host_id]);

	for ($i = 0; ($i < cacti_sizeof($arr)); $i++) {
		$return_arr[$i] = $arr[$i]['name'];
	}

	return $return_arr;
}

function ss_mikrotik_qusers_getinfo(int $host_id, string $info_requested) : array {
	$return_arr = [];
	$arr        = [];

	if ($info_requested == 'name') {
		$arr = db_fetch_assoc_prepared("SELECT name AS qry_index,
			name AS qry_value
			FROM plugin_mikrotik_users
			WHERE host_id = ?
			AND name!=''
			ORDER BY name",
			[$host_id]);
	} elseif ($info_requested == 'domain') {
		$arr = db_fetch_assoc_prepared("SELECT name AS qry_index,
			domain AS qry_value
			FROM plugin_mikrotik_users
			WHERE host_id = ?
			AND name!=''
			ORDER BY name",
			[$host_id]);
	} elseif ($info_requested == 'ip') {
		$arr = db_fetch_assoc_prepared("SELECT name AS qry_index,
			ip AS qry_value
			FROM plugin_mikrotik_users
			WHERE host_id = ?
			AND name!=''
			ORDER BY name",
			[$host_id]);
	} elseif ($info_requested == 'mac') {
		$arr = db_fetch_assoc_prepared("SELECT name AS qry_index,
			mac AS qry_value
			FROM plugin_mikrotik_users
			WHERE host_id = ?
			AND name!=''
			ORDER BY name",
			[$host_id]);
	}

	for ($i = 0; ($i < cacti_sizeof($arr)); $i++) {
		$return_arr[$arr[$i]['qry_index']] = $arr[$i]['qry_value'];
	}

	return $return_arr;
}