Dev

dev@lists.roundcube.net

1 participants
4293 discussions

virtuser_query for identities
by Robin Elfrink 27 Mar '06

27 Mar '06

Here's a small patch that allows roundcube to run a query to fill a new user's identities. In config/main.inc.php I use the following line for my setup: $rcmail_config['virtuser_query'] = 'SELECT address FROM mail.virtual WHERE alias REGEXP \'(^|,)%u(,|$)\' AND NOT (address LIKE \'@%\')'; This ensures that new users get at least one valid email address in their identities, since on my system not everybody has an address $username@$config['mail_domain']. Maybe it would be even nicer if the query was used not only with a new user, but every time on login. Somehow. Robin diff -uNr --exclude CVS --exclude main.inc.php roundcubemail.orig/config/main.inc.php.dist roundcubemail/config/main.inc.php.dist --- roundcubemail.orig/config/main.inc.php.dist Sun Feb 5 18:54:25 2006 +++ roundcubemail/config/main.inc.php.dist Thu Feb 9 10:04:05 2006 @@ -47,6 +47,10 @@ // Path to a virtuser table file to resolve user names and e-mail addresses $rcmail_config['virtuser_file'] = ''; +// Query to resolve user names and e-mail addresses from the database +// %u will be replaced with the current username for login +$rcmail_config['virtuser_query'] = ''; + // use this host for sending mails. // to use SSL connection, set ssl://smtp.host.com // if left blank, the PHP mail() function is used diff -uNr --exclude CVS --exclude main.inc.php roundcubemail.orig/program/include/main.inc roundcubemail/program/include/main.inc --- roundcubemail.orig/program/include/main.inc Sun Feb 5 17:34:48 2006 +++ roundcubemail/program/include/main.inc Thu Feb 9 10:32:25 2006 @@ -448,13 +448,29 @@ $user_name = $user!=$user_email ? $user : ''; - // also create a new identity record - $DB->query("INSERT INTO ".get_table_name('identities')." - (user_id, del, standard, name, email) - VALUES (?, 0, 1, ?, ?)", - $user_id, - $user_name, - $user_email); + // also create new identity records + if (empty($CONFIG['virtuser_query'])) + { + $DB->query("INSERT INTO ".get_table_name('identities')." + (user_id, del, standard, name, email) + VALUES (?, 0, 1, ?, ?)", + $user_id, + $user_name, + $user_email); + } + else + { + $sql_result = $DB->query(preg_replace('/%u/', $user, $CONFIG['virtuser_query'])); + while ($sql_arr = $DB->fetch_assoc($sql_result)) + { + $DB->query("INSERT INTO ".get_table_name('identities')." + (user_id, del, standard, name, email) + VALUES (?, 0, 1, ?, ?)", + $user_id, + $user_name, + $sql_arr['address']); + } + } // get existing mailboxes $a_mailboxes = $IMAP->list_mailboxes();

2 3

order by date screwed up
by sofar 27 Mar '06

27 Mar '06

Hi, right now the current cvs trunk orders by date in a very strange way. I suspect it has something to do with me using an ISO-ish date format string (Y-m-d H:S) to display dates in the date column. In any case the last couple of day entries end up between older (above) and really old (below) mails. Sorting done after translating to user's timeformat instead of before? Auke

6 11

Fwd: Re: Hey guys Pls Help me.
by phil 27 Mar '06

27 Mar '06

Didn't reply to the list too: -------- Original Message -------- Subject: Re: Hey guys Pls Help me. Date: Mon, 27 Mar 2006 11:27:36 -0600 From: phil <phil(a)cryer.us> To: Vivek Sharma <vivek_ynr(a)yahoo.com> My suggestion would be this: 1) download EasyPHP http://www.easyphp.org/ for Windows 2) install it (it will install Apache/mySQL/PHP) 3) start EasyPHP, run the configurator to setup your database and other paths 4) ensure that Apache is working 5) install roundcube to C:\EasyPHP\www 6) follow the steps to configure roundcube, if you'd like start with Step 3) here: http://fak3r.com/articles/2005/11/15/howto-install-roundcube-webmail-from-c… Then let us know what point you get stuck on. Thanks P On Mon, 27 Mar 2006 02:36:58 -0800 (PST), Vivek Sharma <vivek_ynr(a)yahoo.com> wrote: > Here is my problem. > I have been rying to install the roundcube mail on an > integreted php dev with built in support for php, mysql(on windows) as > well since the last four days. I am frustrated as I dont know much about > the PHP thing. I was asked by my client to integrate the product wiht one > of the applications. > I stated with getting the error 500 which I removed and > then got as error regarding the PATHSEPERATOR . Then I included the line : > if (!defined('PATH_SEPARATOR')) define('PATH_SEPARATOR', ';'); > at top of my index.php file as suggested by one of the > gentlemen.Thereafter I did not get as error but the screen I get is blank. > In the server Log it says : > [24-Apr-2006 15:31:25] PHP Fatal error: Call to undefined function: > query() in c:\phpdev\www\roundcubemail\program\include\rcube_db.inc on > line 213 > I tried to change the function and looked out for it but I found that > the function does not expect any arguments but the line which calls it > does send it two arguments. I am pasting below the codesnippet of the > Function query() and the call to that function also: > Path : > phpdev\www\roundcubemail\program\inlcude\ rcube_db: > The Definition of the Function: > > /** > * Execute a SQL query > * > * @param string SQL query to execute > * @param mixed Values to be inserted in query > * @return number Query handle identifier > * @access public > */ > function query() > { > $params = func_get_args(); > $query = array_shift($params); > return $this->_query($query, 0, 0, $params); > } > > And rthis is the line no which generated the error :213: > the call: > if ($numrows || $offset) > $result = > $this->db_handle->limitQuery($query,$offset,$numrows,$params); > else > $result = $this->db_handle->query($params, $query); > > > Pls help me guys any kind of help would be accepted with loads of > gratitude. You cannot imagine what predicament I am in. I am very new to > all this pls let me know that is it possible even at the first place to > install it on windows + Apache+ PHP + MySql combination and testing on the > windows locally. Would it open up???? Though I've already tried to install > on the linux server at the domain www.designworxz.com but of no avail. > (I've already tried PaulSchamuaoutu notes for the installation and > wonder how people say it is a ten minutes job to install the product and > has a clean installation procedure). > I am Stuck guys pls help. > > > Humbly, > > Vivek. > > > > > ------------------------------- -- http://fak3r.com - you dont have to kick it -- http://fak3r.com - you dont have to kick it

1 0

Hey guys Pls Help me.
by Vivek Sharma 27 Mar '06

27 Mar '06

Here is my problem. I have been rying to install the roundcube mail on an integreted php dev with built in support for php, mysql(on windows) as well since the last four days. I am frustrated as I dont know much about the PHP thing. I was asked by my client to integrate the product wiht one of the applications. I stated with getting the error 500 which I removed and then got as error regarding the PATHSEPERATOR . Then I included the line : if (!defined('PATH_SEPARATOR')) define('PATH_SEPARATOR', ';'); at top of my index.php file as suggested by one of the gentlemen.Thereafter I did not get as error but the screen I get is blank. In the server Log it says : [24-Apr-2006 15:31:25] PHP Fatal error: Call to undefined function: query() in c:\phpdev\www\roundcubemail\program\include\rcube_db.inc on line 213 I tried to change the function and looked out for it but I found that the function does not expect any arguments but the line which calls it does send it two arguments. I am pasting below the codesnippet of the Function query() and the call to that function also: Path : phpdev\www\roundcubemail\program\inlcude\ rcube_db: The Definition of the Function: /** * Execute a SQL query * * @param string SQL query to execute * @param mixed Values to be inserted in query * @return number Query handle identifier * @access public */ function query() { $params = func_get_args(); $query = array_shift($params); return $this->_query($query, 0, 0, $params); } And rthis is the line no which generated the error :213: the call: if ($numrows || $offset) $result = $this->db_handle->limitQuery($query,$offset,$numrows,$params); else $result = $this->db_handle->query($params, $query); Pls help me guys any kind of help would be accepted with loads of gratitude. You cannot imagine what predicament I am in. I am very new to all this pls let me know that is it possible even at the first place to install it on windows + Apache+ PHP + MySql combination and testing on the windows locally. Would it open up???? Though I've already tried to install on the linux server at the domain www.designworxz.com but of no avail. (I've already tried PaulSchamuaoutu notes for the installation and wonder how people say it is a ten minutes job to install the product and has a clean installation procedure). I am Stuck guys pls help. Humbly, Vivek. --------------------------------- New Yahoo! Messenger with Voice. Call regular phones from your PC and save big.

2 1

multipart bug
by Martin Marques 27 Mar '06

27 Mar '06

In have a person who is sending me mail with a multipart/mixed mail with this header: --===============1505479739== Content-Type: text/plain; charset=unknown-8bit Content-Disposition: inline Content-Transfer-Encoding: 8bit The problem is that RC doesn't show the contents of this part. Yes I know, it has a badly set charset, which I have already claimed to him about this configuration problem in his email client, but I guess there has to be some kind of failure-comeback to at least see something. I haven't checked the code, but it sure looks like an encoding problem. -- --------------------------------------------------------- Lic. Martín Marqués | SELECT 'mmarques' || Centro de Telemática | '@' || 'unl.edu.ar'; Universidad Nacional | DBA, Programador, del Litoral | Administrador ---------------------------------------------------------

1 0

Ghost e-mails
by Richard Green 27 Mar '06

27 Mar '06

Hi, Now I'm sure this is a 'feature', but I'm trying to understand the rationale behind it. If I view my e-mails in RCW, then move some of those messages into another folder using a *different application*, the messages still appear in the old place in RCW, but greyed out. Clicking on them allows me to view the correct e-mail no matter where it has been moved. My question is, is there anyway to turn that off? Things get very messy if you move things back and forth, you can get multiple ghosts of the same e-mail!! Thanks, Richard

7 7

Re: Search!
by David Collantes 25 Mar '06

25 Mar '06

> Great to see a 'Search' box in there today - is this functional at all, or > is it something we can 'turn' on in the prefs? If not, let us know when/how > we can test it, I have some big maildirs to have it sift through! > > After search and spellcheck I can convert my remaining users from SM. What search box? Where? -- David Collantes, Senior Systems Administrator College of Business Administration, UCF 4000 Central Florida Boulevard, Building 94 Room 203E Orlando, FL 32816-1400 - Phone (407) 823-3418

7 7

cvs dumps 'cannot modify headers'
by sofar 24 Mar '06

24 Mar '06

Hi, this mornings CVS dumps the following message after I hit "send": [23-Mar-2006 17:45:09] PHP Warning: Cannot modify header information - headers already sent in /var/roundcubemail-cvs/program/include/rcube_shared.inc on line 121 Auke

5 6

Daylight savings time
by Jon Daley 24 Mar '06

24 Mar '06

What is this feature supposed to do? From what I see, it appears that you manually turn it on and off as the seasons change? -- Jon Daley http://jon.limedaley.com/

2 1

sorting patch
by Jon Daley 24 Mar '06

24 Mar '06

This patch doesn't work for me. My new incoming mail generally ends up somewhere in the middle of the list, rather than at the top. Double-clicking on each message works, but then the next and previous message buttons, don't go in order, but jump around. Undoing this patch makes everything work fine. while (list($key, $val)=each($a)){ - $data=$a[$key]->$field; - if (is_string($data)) $data=strtoupper(str_replace($stripArr, "", $data)); + + if ($field=="timestamp"){ + $data = @strtotime($value->date); + if ($data != false) + $data = $timestamp; + } + else { + $data=$a[$key]->$field; + if (is_string($data)) + $data=strtoupper(str_replace($stripArr, "", $data)); + } + $index[$key]=$data; } -- Jon Daley http://jon.limedaley.com/

1 0

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev