List all active domains:
SELECT name FROM domains WHERE status = '0'
List all suspended domains:
SELECT name FROM domains WHERE status = '16'
List all expired (hosting) domains:
SELECT name FROM domains WHERE status = '256'
List all domains with backup/restore in progress:
SELECT name FROM domains WHERE status = '4'
List all domains suspended by client:
SELECT name FROM domains WHERE status = '64'
So, all suspended domains are:
SELECT name FROM domains WHERE STATUS != ‘0′
thank u, this is exacly what i need:)
Not quite… suspended domains have status code 16… if you do a query for all domains with status != ‘0′ you will see there are many other status codes than listed here
At some stage I’ll get them all in here for easy reference
What is status 2?
And did u now, what about status=4. Is it means, what domain are suspend while backup or its not a rule?
Yes, 4 means the domain is in the process of either being backed up or being restored and is disabled until the process completes.
I’ve never come across status code 2, so can’t give you an answer sorry.