Community discussions

MikroTik App
  4. RouterOS
  5. Scripting

hotspot management from PHP API

Post Reply
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

hotspot management from PHP API

Sun Sep 30, 2012 6:06 pm

The code:
Code: Select all
require('routeros_api.class.php');

function recorro($matriz)
{
            foreach($matriz as $key=>$value)
            {
               if (is_array($value))
				{
				        //echo $value["name"].'<br>';
					//si es un array busco dentro
					if ($value["name"] == $mac) 
					{
						//si coincide con el valor deseado, lo devuelvo para usarlo
					  return $value['.id'];
					  break;
					}
					recorro($value);
					}else{  
					   //si es un elemento continuo
					  continue;
					}
				}
	} 

	if ($API->connect('IP', 'USER', 'PASSWORD')) 
	{      
		
		echo '<br><br>';
		echo 'Conecatado Ok';
		echo '<br><br>';
		
		$API->write('/ip/hotspot/user/print',true);
		$READ = $API->read(true);

		$id = recorro($READ);
		$API->write('/ip/hotspot/user/disable',false);
		$API->write('=.id=' . $id);		
		
		echo 'Buscado: '.$id;
		echo '<br><br>';
		//print_r($READ);
		echo '<br><br>';
			
		$API->write('/ip/hotspot/active/print',true);
		$READ2 = $API->read(true);	
		
		foreach ($READ2 as $value2) {
		
		//echo $value2['mac-address'].'<br>';

			if ($value2['mac-address'] == $mac) 
			{
			  $API->write('/ip/hotspot/active/remove',false);
			  $API->write('=.id=' . $value2['.id']);
			  $KILL = $API->read();
			  
			  echo 'Encontrado ';
			  echo $value2['.id'];
			}
		}
		//print_r($READ2);
		$API->disconnect();
}
The problem:

if i send the $mac value from other web, or form, ($_GET) the api seems dont get this value,
if i use $value["name"] == "MAC ADDRESS", the api works fine.

any idea why the api dont read the value of the var?

thanks
Top
 
User avatar
boen_robot
Forum Guru
Forum Guru
Posts: 2400
Joined: Thu Aug 31, 2006 4:43 pm
Location: europe://Bulgaria/Plovdiv

Re: hotspot management from PHP API

Sun Sep 30, 2012 6:29 pm

In PHP, there's just the global scope, and the function's scope. The function scope does NOT inherit the global scope.

If you want to import a global variable, you must either pass it at call time, e.g.
Code: Select all
<?php

function recorro($matriz, $mac) {
//...
}

$id = recorro($READ, $mac);
 
or use the "global" keyword at the start of the function declaration, e.g.
Code: Select all
<?php

function recorro($matriz) {
global $mac;
//...
}

$id = recorro($READ);
 

P.S. That's one unnecessarily complicated code.
Top
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

Re: hotspot management from PHP API

Sun Sep 30, 2012 7:06 pm

Lol, i fell stupid :/


thx man i dont see this noob problem :S

all works fine now :)
Top
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

Re: hotspot management from PHP API

Sat Oct 06, 2012 3:02 am

New problem, becouse the long arrays coming from mk, we need use 2 calls to api, but now, nothing wokrs...
Code: Select all
<?php
require('routeros_api.class.php');

include('../../incluits/config.php');
include('../../incluits/functions.php');

if(!isset($_SESSION["admin"]) )

{
redirigir_a("../index.php?stat=nouser");
}else{

$mac = $_GET["mac"];
echo '<b>Todas las memorias estan expresadas en Bytes </b><br><br><br>';
echo 'Memoria antes de nada ' . memory_get_usage();
echo '<br>';


$API = new routeros_api();
$API->debug = true;


	function recorro($matriz)
	{
		global $mac;
		foreach($matriz as $key=>$value)
		{
	 
			if (is_array($value))
				{
					   //si es un array busco dentro
					if ($value['name'] == $mac) 
					{
						//si coincide con el valor deseado, lo devuelvo para usarlo
					  return $value['.id'];
					  break;
					}
					recorro($value);
					}else{  
					   //si es un elemento continuo
					  continue;
					}
				}
	} 

echo 'Memoria antes de conectar ' . memory_get_usage();
echo '<br>';

	if ($API->connect(xxx)) 
	{      
	
		$API->write('/ip/hotspot/user/print',true);
		$READ = $API->read(true);

		$id = recorro($READ);
		$API->write('/ip/hotspot/user/disable',false);
		$API->write('=.id=' . $id);		
		
		echo '<br>';
		echo 'Encontrado user: ' .$id;
		//print_r($READ);
		echo '<br><br>'; 
		echo "El Array tiene " . sizeof($READ) . " elementos";
		echo '<br><br>';
		
		$API->disconnect();
	
	}
	
echo 'Memoria al terminar el user print / disable ' . memory_get_usage();
echo '<br>';			
unset($READ); //Vacio la array y la memoria que use.
echo 'Memoria al vaciar el user print / disable ' . memory_get_usage();
echo '<br>';	

		unset($READ); //Vacio la array y la memoria que use.
	
	echo '<br><br><br><br><br><br>';
	
	$API2 = new routeros_api();
	$API2->debug = true;
	
	if ($API2->connect(xxx)) 
	{ 
	
		$API2->write('/ip/hotspot/host/print',true);
		$READ2 = $API2->read(true);	
		
		foreach ($READ2 as $value2) {

			if ($value2['mac-address'] == $mac) 
			{
			  $API2->write('/ip/hotspot/host/remove',false);
			  $API2->write('=.id=' . $value2['.id']);
			  
			  echo 'Encontrado user: ' . $value2['.id'];
			}
		
		}
		
		echo '<br><br>';
		echo "El Array tiene " . sizeof($READ2) . " elementos";
		echo '<br><br>';
		//print_r($READ2);
		
echo 'Memoria al terminar el host print / remove ' . memory_get_usage();
echo '<br>';
	
unset($READ2);  //Vacio la array y la memoria que use.

echo 'Memoria al vaciar el user print / disable ' . memory_get_usage();
echo '<br>';	

		$API2->disconnect();
	}
	
echo '<br> Pico de Memoria ' . memory_get_peak_usage();
	
}
?>
The id's are found ok, but the write with the command fails.

Any idea ?
Thanks.
Top
 
User avatar
boen_robot
Forum Guru
Forum Guru
Posts: 2400
Joined: Thu Aug 31, 2006 4:43 pm
Location: europe://Bulgaria/Plovdiv

Re: hotspot management from PHP API

Sat Oct 06, 2012 8:08 pm

Do another read() after the remove, and that will fix it.


But seriously, you're having some unecesarily complicated code.

Using the client from my signature, you can simplify that down to:
Code: Select all
<?php
namespace PEAR2\Net\RouterOS;

include('PEAR2_Net_RouterOS-1.0.0b3.phar');
include('../../incluits/config.php');
include('../../incluits/functions.php');

if(!isset($_SESSION["admin"])) {
    redirigir_a("../index.php?stat=nouser");
} else {
    $client = new Client(...);

    $id = $client->sendSync(
        new Request('/ip hotspot user print .proplist=.id', Query::where('name', $_GET['mac']))
    )->getArgument('.id');

    $removeRequest = new Request('/ip hotspot user remove');
    $removeRequest->setArgument('numbers', $id);
    $client->sendSync($removeRequest);

    $id = $client->sendSync(
        new Request('/ip hotspot host print .proplist=.id', Query::where('mac-address', $_GET['mac']))
    )->getArgument('.id');

    $removeRequest = new Request('/ip hotspot host remove');
    $removeRequest->setArgument('numbers', $id);
    $client->sendSync($removeRequest);
} 
And that's the verbose version. You can take it a step further, and compress that to:
Code: Select all
<?php
namespace PEAR2\Net\RouterOS;

include('PEAR2_Net_RouterOS-1.0.0b3.phar');
include('../../incluits/config.php');
include('../../incluits/functions.php');

if(!isset($_SESSION["admin"])) {
    redirigir_a("../index.php?stat=nouser");
} else {
    $client = new Client(...);

    $removeRequest = new Request('/ip hotspot user remove');
    $client->sendSync($removeRequest
        ->setArgument(
            'numbers',
            $client->sendSync(
                new Request('/ip hotspot user print .proplist=.id', Query::where('name', $_GET['mac']))
            )->getArgument('.id')
        )
    );

    
    $client->sendSync($removeRequest
        ->setCommand('/ip hotspot host remove')
        ->setArgument(
            'numbers',
            $client->sendSync(
                new Request('/ip hotspot host print .proplist=.id', Query::where('mac-address', $_GET['mac']))
            )->getArgument('.id')
        )
    );
} 
(I realize that's actually a few more lines... but it's a few statements less)
Top
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

Re: hotspot management from PHP API

Sat Oct 06, 2012 9:02 pm

i tried with a read() after each remove, and only works the disable part. the remove one fails.

Anyway i will study ur api for the next projects, but for now i dont understand fully this api so.. i go slowly :P

Thanks for the tips
Top
 
User avatar
boen_robot
Forum Guru
Forum Guru
Posts: 2400
Joined: Thu Aug 31, 2006 4:43 pm
Location: europe://Bulgaria/Plovdiv

Re: hotspot management from PHP API

Sat Oct 06, 2012 9:34 pm

Are you sure that your usernames are the mac addresses? Perhaps you need to instead target the mac-address property in the user section too. It would be normal for the remove to fail if there's no ID from the print being matched, which would happen if that's the case.

BTW, I'm not even sure the removal in the "host" is necesary. It should be deleted automatically as a consequence of the user deletion.
Anyway i will study ur api for the next projects, but for now i dont understand fully this api so.. i go slowly
Going slowly by starting with the more cumbersome and unintuitive API, towards the cleaner and easier one... fair enough... I think.
Top
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

Re: hotspot management from PHP API

Sat Oct 06, 2012 9:54 pm

BTW, I'm not even sure the removal in the "host" is necesary. It should be deleted automatically as a consequence of the user deletion.
Should... but not...
Code: Select all

     $API2->write('/ip/hotspot/host/print',true);
      $READ2 = $API2->read(true);   
      
      foreach ($READ2 as $value2) {

         if ($value2['mac-address'] == $mac) 
         {
           $API2->write('/ip/hotspot/host/remove',false);
           $API2->write('=.id=' . $value2['.id']);
           
           echo 'Encontrado user: ' . $value2['.id'];
         }
The Echo shows the id, so the user with this mac address was found, but just don kick him from host list...
Top
 
User avatar
boen_robot
Forum Guru
Forum Guru
Posts: 2400
Joined: Thu Aug 31, 2006 4:43 pm
Location: europe://Bulgaria/Plovdiv

Re: hotspot management from PHP API

Sat Oct 06, 2012 10:03 pm

I don't see a read() there. Make that:
Code: Select all
           $API2->write('/ip/hotspot/host/remove',false);
           $API2->write('=.id=' . $value2['.id']);
           $API2->read(); 
Top
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

Re: hotspot management from PHP API

Sat Oct 06, 2012 10:25 pm

i dont edit the first code with the read() :P

i revised all code again, and now works fine.

Lot of thanks for ur help and ur tips.
Top
 
gkwyc
just joined
Posts: 2
Joined: Sun Nov 04, 2012 1:42 am

Re: hotspot management from PHP API

Mon Nov 05, 2012 11:34 pm

Does not have any available stencil ·
Difficult to use！
Top
 
User avatar
boen_robot
Forum Guru
Forum Guru
Posts: 2400
Joined: Thu Aug 31, 2006 4:43 pm
Location: europe://Bulgaria/Plovdiv

Re: hotspot management from PHP API

Tue Nov 06, 2012 4:28 pm

Does not have any available stencil ·
Difficult to use！
I agree.

Try the other PHP client - the one from my signature. See how you like it. I'd love to hear your feedback on it.
Top
 
tiran
Frequent Visitor
Frequent Visitor
Posts: 50
Joined: Fri Aug 07, 2015 2:53 pm

Re: hotspot management from PHP API

Sat Aug 06, 2016 5:52 pm

how to run this code from api

/tool user-manager user> remove [/tool user-manager user find username=101]
Top
 
User avatar
boen_robot
Forum Guru
Forum Guru
Posts: 2400
Joined: Thu Aug 31, 2006 4:43 pm
Location: europe://Bulgaria/Plovdiv

Re: hotspot management from PHP API

Sat Aug 06, 2016 6:50 pm

With my API client:
Code: Select all
<?php
use PEAR2\Net\RouterOS;

require_once 'PEAR2_Net_RouterOS-1.0.0b5.phar';

$util = new RouterOS\Util($client = new RouterOS\Client('192.168.88.1', 'admin', 'password'));


$util->setMenu('/tool user-manager user')->remove(RouterOS\Query::where('username', '101')); 
Top
 
Turamarth
newbie
Topic Author
Posts: 32
Joined: Wed May 09, 2012 3:25 am

Re: hotspot management from PHP API

Thu Feb 13, 2020 10:36 pm

Hi again, my script was working fine till now (some years working perfect), something more that i saw change with any of last routerOS updates, and now i have a problem with the remove part from hotpost, the enable/disable part works fine, looks like the problem is in the read return from the router, apears to come back empty.

Any ideas?
Top
Post Reply

Who is online

Users browsing this forum: No registered users and 54 guests
  4. RouterOS
  5. Scripting