1. Creating New User ( PPP->Secret + MySQL ).
2. Searching User ( this is only from MySQL ).
3. Show a list of all users ( PPP -> Secret ).
4. Delete User ( PPP->Secret + MySQL ).
5. Enable User ( PPP->Secret ).
6. Disable User ( PPP-> Secret ).
7. Change User Password ( PPP->Secret + MySQL), while changing old password is required.
8. Live Monitor Online Users ( PPP->Active Connections ).
9. Show User Stats ( Show Online Users Stats from Queue->Simple ).
10. Monitor Specific Users Stats.

mysql#create database mtpanel;
mysql#grant all on mtpanel.* to 'mtpanel'@'localhost' identified by 'mtpanel';
mysql#flush privileges;
mysql#use mtpanle;

mysql#\. /var/www/mtpanel/mtpanel.sql;

mysql -u root -p123 --database mtpanel < mtpanel.sql

expected closing brace (line 2 column 1)
syntax error (line 1 column 31)

expected closing brace (line 2 column 1)
syntax error (line 1 column 31)
syntax error (line 1 column 27)

interrupted

function user_stats()
        {
$ssh_command = ':global user
:global fname
:global lname
:global traffic
:global up
:global down
:foreach i in=[/queue simple find] do={
:set user [/queue simple get $i name]
:for m from=([:len $user]) to=0 do={:if ([:pick $user $m] = "-") do={:set fname ([:pick $user ($m+1) [:len $user]])}}
:for n from=([:len $fname]) to=0 do={:if ([:pick $fname $n] = ">") do={:set lname ([:pick $fname 0 $n])}}
:set traffic [/queue simple get $user bytes]
:for x from=([:len $traffic] - 1) to=0 do={:if ([:pick $traffic $x] = "/") do={:set up {[:pick $traffic 0 $x] / 1048576 }}}
:for y from=([:len $traffic]) to=0 do={:if ([:pick $traffic $y] = "/") do={:set down {[:pick $traffic ($y+1) [:len $traffic ]] / 1048576 }}}
:put "$lname\_\_\_\t\t ($down MB  -  $up MB)"}';
echo "<pre>";
echo "User ID                Download  -  Upload";
echo "<br><br>";
ssh_run($ssh_command);
echo "</pre>";
}

mysql -u 'SUPERUSER' -p --database 'DATABASE NAME' < profile.sql

:global list "";:foreach i in [/ppp active find ] do={:if ([:find [/ppp active get $i name] "999"]=0) do={:set list ($list . "," . $i)}};:foreach i in={$list} do={/interface monitor-traffic $list}

interrupted