View Single Post
  #5  
Old 18th July 2007, 16:52
mthalmei mthalmei is offline
Junior Member
 
Join Date: Jul 2007
Posts: 1
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks for this great hook.

But unfortunately as already written above this does not seem to be working with recent versions of horde and ispconfig.

I have investigated a little bit and found that by using the table isp_isp_web instead of isp_isp_domain this seems to work.

The code schould look like this:
PHP Code:
$query  'SELECT user_email,web_domain FROM (isp_isp_user INNER JOIN isp_dep ON (isp_isp_user.doc_id=child_doc_id AND isp_isp_user.doctype_id=child_doctype_id))';
$query .= ' INNER JOIN isp_isp_web ON (parent_doc_id=isp_isp_web.doc_id AND parent_doctype_id=isp_isp_web.doctype_id) WHERE user_username=' $db->quote($user);

...

$return $row['user_email'] . "@" $row['web_domain']; 
Reply With Quote