Skip to content

Integration of SQL Queries into Marzban Next #988

Closed as not planned
Closed as not planned
@iamtheted

Description

@iamtheted

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

Metadata

Metadata

Assignees

No one assigned

    Labels

    FeatureNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions