Re: vacation not working with qmail, autorespond, vpopmail
Rick Romero <[email protected]>
| Newsgroups | gmane.comp.horde.sork |
|---|---|
| Message-ID | <[email protected]> |
On Jun 23, 2007, at 10:17 AM, Claus Szypura wrote: > Claus Szypura <claus <at> centralmail.de> writes: > >> I didn't find the attached diff (perhaps I don't have an > appropriate list >> reader?) - if you don't mind just send it directly to my address >> and I will try >> >> Ah sorry - did find it right within the wiki. Will try and report >> back!! >> > > No, I seem to have missed the attachment indeed, didn' I? Or am I > completely > confused now? > LMAO. Sorry - I didn't attach it ;) http://www.havokmon.com/stuff/horde/vacation/vpopmailsql.1.diff And attached: > > > -- > Sork mailing list - Join the hunt: http://horde.org/bounties/#sork > Frequently Asked Questions: http://horde.org/faq/ > To unsubscribe, mail: [email protected] -- Sork mailing list - Join the hunt: http://horde.org/bounties/#sork Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]
vpopmailsql.1.diff
(application/octet-stream, 1.2 KB)
--- vpopmailsql.php.bak Fri Jun 22 21:25:13 2007
+++ vpopmailsql.php Fri Jun 22 21:32:41 2007
@@ -134,11 +134,23 @@
}
// Get user's path from vpopmail SQL
- $query = 'SELECT ' . $this->_params[$realm]['path_col'] .
- ' FROM ' . $this->_params[$realm]['table'] .
+ if ($this->_params[$realm]['enablemultidomains']){
+ list($cur_email,$cur_domain) = split('@',$my_email,2);
+ $query = 'SELECT ' . $this->_params[$realm]['path_col'] .
+ ' FROM ' . $this->_params[$realm]['vpopmaildb'] . '.' . $cur_domain .
' WHERE concat(' . $this->_params[$realm]['user_col'] .
',\'@\',' . $this->_params[$realm]['domain_col'] . ') LIKE \'' . $my_email . '\' ';
- //' AND ' . $this->_params[$realm]['pass_col'] . ' = ?';
+
+ }
+ else{
+ $query = 'SELECT ' . $this->_params[$realm]['path_col'] .
+ ' FROM ' . $this->_params[$realm]['vpopmaildb'] . '.' . $this->_params[$realm]['table'] .
+ ' WHERE concat(' . $this->_params[$realm]['user_col'] .
+ ',\'@\',' . $this->_params[$realm]['domain_col'] . ') LIKE \'' . $my_email . '\' ';
+
+
+ }
+
/* Execute the query. */
$getdata = mysql_query($query);
$result = mysql_result($getdata, 0, 0);