Blocking a Specific Protocol for a Specific Admin in Marzban Panel

[ppouria]

In the Marzban panel, it's typically not possible to restrict an admin to a specific protocol or block a specific protocol for a particular admin. However, I’ll provide you with a method to block a specific protocol for a specific admin, so they cannot use it. You can also use different queries to limit a specific inbound (I encountered issues when I tried this).

To do this, you need to migrate your Marzban database from SQLite to MySQL and enable phpMyAdmin. Refer to the Marzban documentation for this migration process.

After migrating to MySQL:

1. Open your browser and navigate to phpMyAdmin. For example:

http://192.168.0.1:8010

2. Once in phpMyAdmin, go to the SQL tab to execute queries.

Enter the following command in the MySQL console:

CREATE DEFINER=`root`@`%` EVENT `NAME` ON SCHEDULE EVERY 1 SECOND STARTS '2024-07-26 13:23:01' ON COMPLETION NOT PRESERVE ENABLE DO DELETE FROM proxies
WHERE type = 'VMess' AND proxies.id IN (
    SELECT proxies_id
    FROM (
        SELECT proxies.id AS proxies_id
        FROM proxies
        INNER JOIN users ON proxies.user_id = users.id
        INNER JOIN admins ON users.admin_id = admins.id
        WHERE admins.username = 'ADMIN'
    ) AS subquery
)

• Replace NAME with the event name.
• Replace VMess with your desired protocol (ensure the first letter is capitalized, e.g., "Vless").
• Replace ADMIN with the admin's username.

This command creates an event that runs a query every second, effectively blocking a protocol for a specific admin, preventing them from using it. You can create multiple events to restrict multiple admins. To change the interval from seconds to minutes, replace SECOND with MINUTE.

If you don’t have access to the SQL console, you can manually create this through MySQL.

1. Go to the marzban database and open the Events tab.
2. Click on Create new Event.
3. Enter your desired name in the 'Event name' field.
4. Set the 'Status' field to enable.
5. Set the 'Event type' field to RECURRING.
6. Enter your desired interval value (e.g., 1, 15, or 30) in the 'Execute every' field.
7. Set the 'Execute every' field to Second (or Minute if you prefer).

Now the query will run every second:

DELETE FROM proxies
WHERE type = 'VMess' AND proxies.id IN (
    SELECT proxies_id
    FROM (
        SELECT proxies.id AS proxies_id
        FROM proxies
        INNER JOIN users ON proxies.user_id = users.id
        INNER JOIN admins ON users.admin_id = admins.id
        WHERE admins.username = 'ADMIN'
    ) AS subquery
)

• Replace VMess with your desired protocol.
• Replace ADMIN with the admin's username.
• Set the Definer field to root@%.

Finally, click Go.

And that’s it!

[ppouria]

Also, don't forget to take a backup before making any changes.