Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Integration of SQL Queries into Marzban Next #988

Open
iamtheted opened this issue May 17, 2024 · 0 comments
Open

Integration of SQL Queries into Marzban Next #988

iamtheted opened this issue May 17, 2024 · 0 comments
Labels
enhancement New feature or request

Comments

@iamtheted
Copy link

iamtheted commented May 17, 2024

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

@iamtheted iamtheted added the enhancement New feature or request label May 17, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

1 participant