Integration of SQL Queries into Marzban Next

[iamtheted]

Integration of SQL Queries into Marzban Next

[erfjab]

Hello Marzban
There are so many SQL queries that are quite practical, and since you're planning for the next update of Marzban, I was wondering if you could integrate them into the panel or API. I'll list the queries down below in case you wanna check them out.
Thanks in advance!

• Changing the admin for a specific user (sudo & non-sudo)
• Checking out the GB limits that have been set by admins (sudo & non-sudo)
• Calculation of all GBs that have been set by the admins
• Node usage of each admin (each node specifically）
• Enabling/Disabling all users of an admins
• Checking the traffic usage of admins
• Checking out the users that expire on a specific date or let's say 1 day from now
• Checking out the users that have a certain GB left
• Checking out the users that have a disabled inbound or protocol
• Enabling/Disabling a certain protocol for all users
• Enabling/Disabling an inbound for all users of all admins
• Enabling/Disabling an inbound for a specific admin
• Deleting all the expired users
• Deleting only the users that have been expired for a week/month
• Adding 1 day to all users
• Taking away 1 day from all users

You can access some of the queries in Marzban Nameh as I list the links to the posts down below, also some of the things I listed above as requests may not be in the queries below.

https://t.me/Marzban_Nameh/177
https://t.me/Marzban_Nameh/180
https://t.me/Marzban_Nameh/188
https://t.me/Marzban_Nameh/191
https://t.me/Marzban_Nameh/198
https://t.me/Marzban_Nameh/199

Thank you so much!
TED

Most of them are available in APIs, either directly or indirectly. If possible, we will add better APIs for the convenience of your work.