Email domain administrator account details?

[sitepoint]

Hi. I'd like to send an email containing all neccessary information to the assigned domain administrator. The problem is that it seems that there is some difference between accounts created on 7.5.4 and those created after the upgrade to 8.0

For instance, the following query returns all accounts created before 8.0:

select d.name,s.login,a.password from domains d, hosting h, sys_users s, accounts a where h.dom_id = d.id and h.sys_user_id = s.id and a.id = s.account_id;

This gives me all the domain administrators and the relevant info.

Now, this does not give me the accounts that were added after the upgrade. So, what's the difference? How do I get all the accounts?


Regards,
Chris / Sitepoint.se

 

[sitepoint]

never mind
this query was wrong and i created one that works instead