advanced code snippet search

Posted By

tobewan on 10/27/09


Tagged

sql server commands dv Dedicated-Virtual


Versions (?)

Grab Plesk FTP account passwords

 / Published in: SQL
 
Expand | Embed | Plain Text 
  1. SELECT REPLACE(sys_users.home,'/home/httpd/vhosts/','') AS domain,
  2. sys_users.login,accounts.password FROM sys_users
  3. LEFT JOIN accounts ON sys_users.account_id=accounts.id
  4. ORDER BY sys_users.home ASC;

Report this snippet  

You need to login to post a comment.