/ Published in: SQL
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
echo "SELECT REPLACE(sys_users.home,'/home/httpd/vhosts/','') AS domain, sys_users.login,accounts.password FROM sys_users LEFT JOIN accounts on sys_users.account_id=accounts.id ORDER BY sys_users.home ASC;" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dpsa -t