I'm totally lost in the Plesk 10 database Schema, even with the PDF diagram that someone at Parallels has gone to a lot of trouble to create.
If anyone has previously worked it out, I'd LOVE it if they could post the "magic words" (SQL statement) necessary to obtain a list of email addresses, mailbox-usage and mailbox-quota from the Plesk database.
I'm trying to write a php application that processes these details, so basically I need to generate a list containing every mailbox, how much data it contains and what its maximum quota is.
I know I can do this with a bash script that goes through all the directories in /var/qmail/mailnames, but as the data is already in the Plesk database, it seems silly to do that when the data has already been checked and stored.
If anyone has previously worked it out, I'd LOVE it if they could post the "magic words" (SQL statement) necessary to obtain a list of email addresses, mailbox-usage and mailbox-quota from the Plesk database.
I'm trying to write a php application that processes these details, so basically I need to generate a list containing every mailbox, how much data it contains and what its maximum quota is.
I know I can do this with a bash script that goes through all the directories in /var/qmail/mailnames, but as the data is already in the Plesk database, it seems silly to do that when the data has already been checked and stored.