- Dev - Roundcube mailing lists

Unable to delete Messages
by Rainer Hungershausen 15 Oct '05

15 Oct '05

Hi there, I just tried out Roundcube version 0.1-20051007. Looks awesome! But somehow I can't manage to delete messages. If I click on move message to trash, the message disappears, but is not really moved or deleted. It will always reappear if you reload the Inbox or view the Mailbox with another client. I was using Firefox 1.5 Beta2. If there's anything I can help you with to debug this, just let me know. Best regards, Rainer

1 0

mdb2 integrated (resend with zip attachement
by Lukas Kahwe Smith 15 Oct '05

15 Oct '05

Hi, I just made the backend selectable and integrated the MDB2 backend .. For this I moved the inclusion of the rcube_db.inc frm the index.php file into main.inc. I also added a new config option 'db_backend' to db.inc.php. regards, Lukas

1 0

archive
by Derek Anderson 15 Oct '05

15 Oct '05

hey all, is there a list archive posted somewhere? thanks, -- derek

2 1

mdb2 integrated
by Lukas Kahwe Smith 15 Oct '05

15 Oct '05

Hi, I just made the backend selectable and integrated the MDB2 backend .. For this I moved the inclusion of the rcube_db.inc frm the index.php file into main.inc. I also added a new config option 'db_backend' to db.inc.php. regards, Lukas <?php /* +-----------------------------------------------------------------------+ | program/include/rcube_db.inc | | | | This file is part of the RoundCube Webmail client | | Copyright (C) 2005, RoundCube Dev. - Switzerland | | Licensed under the GNU GPL | | | | PURPOSE: | | PEAR:DB wrapper class that implements PEAR DB functions | | See http://pear.php.net/package/DB | | | +-----------------------------------------------------------------------+ | Author: David Saez Padros <david(a)ols.es> | +-----------------------------------------------------------------------+ $Id: rcube_db.inc,v 1.6 2005/10/07 14:17:08 roundcube Exp $ */ require_once('MDB2.php'); class rcube_db { var $db_dsnw; // DSN for write operations var $db_dsnr; // DSN for read operations var $db_connected=false; // Already connected ? var $db_mode=''; // Connection mode var $db_handle=0; // Connection handle var $a_query_results = array('dummy'); var $last_res_id = 0; // PHP 5 constructor function __construct($db_dsnw,$db_dsnr='') { if ($db_dsnr=='') $db_dsnr=$db_dsnw; $this->db_dsnw = $db_dsnw; $this->db_dsnr = $db_dsnr; $dsn_array = MDB2::parseDSN($db_dsnw); $this->db_provider = $dsn_array['phptype']; } // PHP 4 compatibility function rcube_db($db_dsnw,$db_dsnr='') { $this->__construct($db_dsnw,$db_dsnr); } // Connect to specific database function dsn_connect($dsn) { // Use persistent connections if available $dbh = MDB2::factory($dsn, array('persistent' => $true)); if (PEAR::isError($dbh)) raise_error(array('code' => 500, 'type' => 'db', 'line' => __LINE__, 'file' => __FILE__, 'message' => $dbh->getMessage()), TRUE, FALSE); else if ($this->db_provider=='sqlite') { $dsn_array = MDB2::parseDSN($dsn); if (!filesize($dsn_array['database']) && !empty($this->sqlite_initials)) $this->_sqlite_create_database($dbh, $this->sqlite_initials); } return $dbh; } // Connect to appropiate databse function db_connect ($mode) { $this->db_mode = $mode; // Already connected if ($this->db_connected) { // no replication, current connection is ok if ($this->db_dsnw==$this->db_dsnr) return; // connected to master, current connection is ok if ($this->db_mode=='w') return; // Same mode, current connection is ok if ($this->db_mode==$mode) return; } if ($mode=='r') $dsn=$this->db_dsnr; else $dsn=$this->db_dsnw; $this->db_handle = $this->dsn_connect($dsn); $this->db_connected = true; } // Query database (read operations) function query($query) { // Read or write ? if (strtolower(trim(substr($query,0,6)))=='select') $mode='r'; else $mode='w'; $this->db_connect($mode); if ($this->db_provider == 'sqlite') $query = $this->_sqlite_prepare_query($query); $result = $this->db_handle->query($query); if (PEAR::isError($result)) raise_error(array('code' => 500, 'type' => 'db', 'line' => __LINE__, 'file' => __FILE__, 'message' => $result->getMessage()), TRUE, FALSE); return $this->_add_result($result, $query); } function db_execute ($query) { $this->db_connect('w'); if ($this->db_provider == 'sqlite') $query = $this->_sqlite_prepare_query($query); $result = $this->db_handle->query($query); } function num_rows($res_id=NULL) { if (!$this->db_handle) return FALSE; $result = $this->_get_result($res_id); if ($result) return $result->numRows(); else return FALSE; } function affected_rows($res_id=NULL) { if (!$this->db_handle) return FALSE; return $this->db_handle->affectedRows(); } function insert_id($sequence = '') { if (!$this->db_handle || $this->db_mode=='r') return FALSE; return $this->db_handle->lastInsertID(); } function fetch_assoc($res_id=NULL) { $result = $this->_get_result($res_id); if (PEAR::isError($result)) { raise_error( array('code' => 500, 'type' => 'db', 'line' => __LINE__, 'file' => __FILE__, 'message' => $this->db_link->getMessage()), TRUE, FALSE); return FALSE; } return $result->fetchRow(MDB2_FETCHMODE_ASSOC); } function _add_result($res, $query) { // sql error occured if (PEAR::isError($res)) { raise_error(array('code' => 500, 'type' => 'db', 'line' => __LINE__, 'file' => __FILE__, 'message' => $res->getMessage() . " Query: " . substr(preg_replace('/[\r\n]+\s*/', ' ', $query), 0, 1024)), TRUE, FALSE); return FALSE; } else { $res_id = sizeof($this->a_query_results); $this->a_query_results[$res_id] = $res; $this->last_res_id = $res_id; return $res_id; } } function _get_result($res_id) { if ($res_id==NULL) $res_id = $this->last_res_id; if ($res_id && isset($this->a_query_results[$res_id])) return $this->a_query_results[$res_id]; else return FALSE; } // create a sqlite database from a file function _sqlite_create_database($dbh, $fileName) { if (empty($fileName) || !is_string($fileName)) return ; $data = ''; if ($fd = fopen($fileName, 'r')) { $data = fread($fd, filesize($fileName)); fclose($fd); } if (strlen($data)) sqlite_exec($dbh->connection, $data); } // transform a query so that it is sqlite2 compliant function _sqlite_prepare_query($query) { if (!is_string($query)) return ($query); $search = array('/NOW/', '/`/'); $replace = array("datetime('now')", '"'); $query = preg_replace($search, $replace, $query); return ($query); } } ?> <?php /* +-----------------------------------------------------------------------+ | program/include/main.inc | | | | This file is part of the RoundCube Webmail client | | Copyright (C) 2005, RoundCube Dev, - Switzerland | | Licensed under the GNU GPL | | | | PURPOSE: | | Provide basic functions for the webmail package | | | +-----------------------------------------------------------------------+ | Author: Thomas Bruederli <roundcube(a)gmail.com> | +-----------------------------------------------------------------------+ $Id: main.inc,v 1.7 2005/10/07 14:17:08 roundcube Exp $ */ require_once('lib/des.inc'); // register session and connect to server function rcmail_startup($task='mail') { global $sess_id, $sess_auth, $sess_user_lang; global $CONFIG, $INSTALL_PATH, $BROWSER, $OUTPUT, $_SESSION, $IMAP, $DB, $JS_OBJECT_NAME; // check client $BROWSER = rcube_browser(); // load config file include_once('config/main.inc.php'); $CONFIG = is_array($rcmail_config) ? $rcmail_config : array(); $CONFIG['skin_path'] = $CONFIG['skin_path'] ? preg_replace('/\/$/', '', $CONFIG['skin_path']) : 'skins/default'; // load db conf include_once('config/db.inc.php'); $CONFIG = array_merge($CONFIG, $rcmail_config); // set PHP error logging according to config if ($CONFIG['debug_level'] & 1) { ini_set('log_errors', 1); ini_set('error_log', $INSTALL_PATH.'logs/errors'); } if ($CONFIG['debug_level'] & 4) ini_set('display_errors', 1); else ini_set('display_errors', 0); // prepare DB connection require_once('include/rcube_'.$CONFIG['db_backend'].'.inc'); $DB = new rcube_db($CONFIG['db_dsnw'], $CONFIG['db_dsnr']); $DB->sqlite_initials = $INSTALL_PATH.'SQL/sqlite.initial.sql'; // we can use the database for storing session data if (is_object($DB) && $DB->db_provider!='sqlite') include_once('include/session.inc'); // init session session_start(); $sess_id = session_id(); // create session and set session vars if (!$_SESSION['client_id']) { $_SESSION['client_id'] = $sess_id; $_SESSION['user_lang'] = 'en'; $_SESSION['auth_time'] = mktime(); $_SESSION['auth'] = rcmail_auth_hash($sess_id, $_SESSION['auth_time']); unset($GLOBALS['_auth']); } // set session vars global $sess_auth = $_SESSION['auth']; $sess_user_lang = $_SESSION['user_lang']; // overwrite config with user preferences if (is_array($_SESSION['user_prefs'])) $CONFIG = array_merge($CONFIG, $_SESSION['user_prefs']); // reset some session parameters when changing task if ($_SESSION['task'] != $task) unset($_SESSION['page']); // set current task to session $_SESSION['task'] = $task; // create IMAP object if ($task=='mail') rcmail_imap_init(); // set localization if ($CONFIG['locale_string']) setlocale(LC_ALL, $CONFIG['locale_string']); else if ($sess_user_lang) setlocale(LC_ALL, $sess_user_lang); register_shutdown_function('rcmail_shutdown'); } // create authorization hash function rcmail_auth_hash($sess_id, $ts) { global $CONFIG; $auth_string = sprintf('rcmail*sess%sR%s*Chk:%s;%s', $sess_id, $ts, $CONFIG['ip_check'] ? $_SERVER['REMOTE_ADDR'] : '***.***.***.***', $_SERVER['HTTP_USER_AGENT']); if (function_exists('sha1')) return sha1($auth_string); else return md5($auth_string); } // create IMAP object and connect to server function rcmail_imap_init($connect=FALSE) { global $CONFIG, $IMAP; $IMAP = new rcube_imap(); // enable caching of imap data if ($CONFIG['enable_caching']===TRUE) $IMAP->set_caching(TRUE); // set root dir from config if (strlen($CONFIG['imap_root'])) $IMAP->set_rootdir($CONFIG['imap_root']); if (is_array($CONFIG['default_imap_folders'])) $IMAP->set_default_mailboxes($CONFIG['default_imap_folders']); if (strlen($_SESSION['mbox'])) $IMAP->set_mailbox($_SESSION['mbox']); if (isset($_SESSION['page'])) $IMAP->set_page($_SESSION['page']); // set pagesize from config if (isset($CONFIG['pagesize'])) $IMAP->set_pagesize($CONFIG['pagesize']); // connect with stored session data if ($connect) { if (!($conn = $IMAP->connect($_SESSION['imap_host'], $_SESSION['username'], decrypt_passwd($_SESSION['password'])))) show_message('imaperror', 'error'); } } // do these things on script shutdown function rcmail_shutdown() { global $IMAP; if (is_object($IMAP)) { $IMAP->close(); $IMAP->write_cache(); } } // destroy session data and remove cookie function rcmail_kill_session() { /* $sess_name = session_name(); if (isset($_COOKIE[$sess_name])) setcookie($sess_name, '', time()-42000, '/'); */ $_SESSION = array(); session_destroy(); } // return correct name for a specific database table function get_table_name($table) { global $CONFIG; // return table name if configured $config_key = 'db_table_'.$table; if (strlen($CONFIG[$config_key])) return $CONFIG[$config_key]; return $table; } // init output object for GUI and add common scripts function load_gui() { global $CONFIG, $OUTPUT, $COMM_PATH, $IMAP, $JS_OBJECT_NAME; // init output page $OUTPUT = new rcube_html_page(); // add common javascripts $javascript = "var $JS_OBJECT_NAME = new rcube_webmail();\n"; $javascript .= "$JS_OBJECT_NAME.set_env('comm_path', '$COMM_PATH');\n"; if (!empty($GLOBALS['_framed'])) $javascript .= "$JS_OBJECT_NAME.set_env('framed', true);\n"; $OUTPUT->add_script($javascript); $OUTPUT->include_script('program/js/common.js'); $OUTPUT->include_script('program/js/app.js'); } // perfom login to the IMAP server and to the webmail service function rcmail_login($user, $pass, $host=NULL) { global $CONFIG, $IMAP, $DB, $sess_user_lang; $user_id = NULL; if (!$host) $host = $CONFIG['default_host']; // query if user already registered $sql_result = $DB->query(sprintf("SELECT user_id, username, language, preferences FROM %s WHERE mail_host='%s' AND (username='%s' OR alias='%s')", get_table_name('users'), addslashes($host), addslashes($user), addslashes($user))); // user already registered -> overwrite username if ($sql_arr = $DB->fetch_assoc($sql_result)) { $user_id = $sql_arr['user_id']; $user = $sql_arr['username']; } // parse $host URL $a_host = parse_url($host); if ($a_host['host']) { $host = $a_host['host']; $imap_ssl = (isset($a_host['scheme']) && in_array($a_host['scheme'], array('ssl','imaps','tls'))) ? TRUE : FALSE; $imap_port = isset($a_host['post']) ? $a_host['post'] : ($imap_ssl ? 993 : $CONFIG['default_port']); } // exit if IMAP login failed if (!($imap_login = $IMAP->connect($host, $user, $pass, $imap_port, $imap_ssl))) return FALSE; // user already registered if ($user_id && !empty($sql_arr)) { // get user prefs if (strlen($sql_arr['preferences'])) { $user_prefs = unserialize($sql_arr['preferences']); $_SESSION['user_prefs'] = $user_prefs; array_merge($CONFIG, $user_prefs); } // set user specific language if (strlen($sql_arr['language'])) $sess_user_lang = $_SESSION['user_lang'] = $sql_arr['language']; // update user's record $DB->query(sprintf("UPDATE %s SET last_login=NOW() WHERE user_id=%d", get_table_name('users'), $user_id)); } // create new system user else if ($CONFIG['auto_create_user']) { $user_id = rcmail_create_user($user, $host); } if ($user_id) { $_SESSION['user_id'] = $user_id; $_SESSION['imap_host'] = $host; $_SESSION['username'] = $user; $_SESSION['password'] = encrypt_passwd($pass); // force reloading complete list of subscribed mailboxes $IMAP->clear_cache('mailboxes'); return TRUE; } return FALSE; } // create new entry in users and identities table function rcmail_create_user($user, $host) { global $DB, $CONFIG, $IMAP; $DB->query(sprintf("INSERT INTO %s (created, last_login, username, mail_host) VALUES (NOW(), NOW(), '%s', '%s')", get_table_name('users'), addslashes($user), addslashes($host))); if ($user_id = $DB->insert_id()) { $user_email = strstr($user, '@') ? $user : sprintf('%s@%s', $user, $host); $user_name = $user!=$user_email ? $user : ''; // also create a new identity record $DB->query(sprintf("INSERT INTO %s (user_id, `default`, name, email) VALUES (%d, '1', '%s', '%s')", get_table_name('identities'), $user_id, addslashes($user_name), addslashes($user_email))); // get existing mailboxes $a_mailboxes = $IMAP->list_mailboxes(); // check if the configured mailbox for sent messages exists if ($CONFIG['sent_mbox'] && !in_array_nocase($CONFIG['sent_mbox'], $a_mailboxes)) $IMAP->create_mailbox($CONFIG['sent_mbox'], TRUE); // check if the configured mailbox for sent messages exists if ($CONFIG['trash_mbox'] && !in_array_nocase($CONFIG['trash_mbox'], $a_mailboxes)) $IMAP->create_mailbox($CONFIG['trash_mbox'], TRUE); } else { raise_error(array('code' => 500, 'type' => 'php', 'line' => __LINE__, 'file' => __FILE__, 'message' => "Failed to create new user"), TRUE, FALSE); } return $user_id; } function show_message($message, $type='notice') { global $OUTPUT, $JS_OBJECT_NAME, $REMOTE_REQUEST; $framed = $GLOBALS['_framed']; $command = sprintf("display_message('%s', '%s');", addslashes(rep_specialchars_output(rcube_label($message))), $type); if ($REMOTE_REQUEST) return 'this.'.$command; else $OUTPUT->add_script(sprintf("%s%s.%s", $framed ? sprintf('if(parent.%s)parent.', $JS_OBJECT_NAME) : '', $JS_OBJECT_NAME, $command)); // console(rcube_label($message)); } function console($msg, $type=1) { print $msg; print "\n<hr>\n"; } function encrypt_passwd($pass) { $cypher = des('rcmail?24BitPwDkeyF**ECB', $pass, 1, 0, NULL); return base64_encode($cypher); } function decrypt_passwd($cypher) { $pass = des('rcmail?24BitPwDkeyF**ECB', base64_decode($cypher), 0, 0, NULL); return trim($pass); } // send correct response on a remote request function rcube_remote_response($js_code) { send_nocacheing_headers(); //header('Content-Type: text/javascript'); header('Content-Type: application/x-javascript'); print '/** remote response ['.date('d/M/Y h:i:s O')."] **/\n"; print $js_code; exit; } // ************** template parsing and gui functions ************** // return boolean if a specific template exists function template_exists($name) { global $CONFIG, $OUTPUT; $skin_path = $CONFIG['skin_path']; // check template file return is_file("$skin_path/templates/$name.html"); } // get page template an replace variable // similar function as used in nexImage function parse_template($name='main', $exit=TRUE) { global $CONFIG, $OUTPUT; $skin_path = $CONFIG['skin_path']; // read template file $templ = ''; $path = "$skin_path/templates/$name.html"; if($fp = @fopen($path, 'r')) { $templ = fread($fp, filesize($path)); fclose($fp); } else { raise_error(array('code' => 500, 'type' => 'php', 'line' => __LINE__, 'file' => __FILE__, 'message' => "Error loading template for '$name'"), TRUE, TRUE); return FALSE; } // parse for specialtags $output = parse_rcube_xml($templ); $OUTPUT->write(trim(parse_with_globals($output)), $skin_path); if ($exit) exit; } // replace all strings ($varname) with the content of the according global variable function parse_with_globals($input) { $output = preg_replace('/\$(__[a-z0-9_\-]+)/e', '$GLOBALS["\\1"]', $input); return $output; } function parse_rcube_xml($input) { $output = preg_replace('/<roundcube:([-_a-z]+)\s+([^>]+)>/Uie', "rcube_xml_command('\\1', '\\2')", $input); return $output; } function rcube_xml_command($command, $str_attrib, $a_attrib=NULL) { global $IMAP, $CONFIG; $attrib = array(); $command = strtolower($command); preg_match_all('/\s*([-_a-z]+)=["]([^"]+)["]?/i', stripslashes($str_attrib), $regs, PREG_SET_ORDER); // convert attributes to an associative array (name => value) if ($regs) foreach ($regs as $attr) $attrib[strtolower($attr[1])] = $attr[2]; else if ($a_attrib) $attrib = $a_attrib; // execute command switch ($command) { // return a button case 'button': if ($attrib['command']) return rcube_button($attrib); break; // show a label case 'label': if ($attrib['name'] || $attrib['command']) return rcube_label($attrib); break; // create a menu item case 'menu': if ($attrib['command'] && $attrib['group']) rcube_menu($attrib); break; // include a file case 'include': $path = realpath($CONFIG['skin_path'].$attrib['file']); if($fp = @fopen($path, 'r')) { $incl = fread($fp, filesize($path)); fclose($fp); return parse_rcube_xml($incl); } break; // return code for a specific application object case 'object': $object = strtolower($attrib['name']); if ($object=='loginform') return rcmail_login_form($attrib); else if ($object=='message') return rcmail_message_container($attrib); // MAIL else if ($object=='mailboxlist' && function_exists('rcmail_mailbox_list')) return rcmail_mailbox_list($attrib); else if ($object=='messages' && function_exists('rcmail_message_list')) return rcmail_message_list($attrib); else if ($object=='messagecountdisplay' && function_exists('rcmail_messagecount_display')) return rcmail_messagecount_display($attrib); else if ($object=='messageheaders' && function_exists('rcmail_message_headers')) return rcmail_message_headers($attrib); else if ($object=='messageattachments' && function_exists('rcmail_message_attachments')) return rcmail_message_attachments($attrib); else if ($object=='messagebody' && function_exists('rcmail_message_body')) return rcmail_message_body($attrib); else if ($object=='blockedobjects' && function_exists('rcmail_remote_objects_msg')) return rcmail_remote_objects_msg($attrib); else if ($object=='messagecontentframe' && function_exists('rcmail_messagecontent_frame')) return rcmail_messagecontent_frame($attrib); else if ($object=='messagepartframe' && function_exists('rcmail_message_part_frame')) return rcmail_message_part_frame($attrib); else if ($object=='messagepartcontrols' && function_exists('rcmail_message_part_controls')) return rcmail_message_part_controls($attrib); else if ($object=='composeheaders' && function_exists('rcmail_compose_headers')) return rcmail_compose_headers($attrib); else if ($object=='composesubject' && function_exists('rcmail_compose_subject')) return rcmail_compose_subject($attrib); else if ($object=='composebody' && function_exists('rcmail_compose_body')) return rcmail_compose_body($attrib); else if ($object=='composeattachmentlist' && function_exists('rcmail_compose_attachment_list')) return rcmail_compose_attachment_list($attrib); else if ($object=='composeattachmentform' && function_exists('rcmail_compose_attachment_form')) return rcmail_compose_attachment_form($attrib); else if ($object=='composeattachment' && function_exists('rcmail_compose_attachment_field')) return rcmail_compose_attachment_field($attrib); else if ($object=='priorityselector' && function_exists('rcmail_priority_selector')) return rcmail_priority_selector($attrib); else if ($object=='priorityselector' && function_exists('rcmail_priority_selector')) return rcmail_priority_selector($attrib); // ADDRESS BOOK else if ($object=='addresslist' && function_exists('rcmail_contacts_list')) return rcmail_contacts_list($attrib); else if ($object=='addressframe' && function_exists('rcmail_contact_frame')) return rcmail_contact_frame($attrib); else if ($object=='recordscountdisplay' && function_exists('rcmail_rowcount_display')) return rcmail_rowcount_display($attrib); else if ($object=='contactdetails' && function_exists('rcmail_contact_details')) return rcmail_contact_details($attrib); else if ($object=='contacteditform' && function_exists('rcmail_contact_editform')) return rcmail_contact_editform($attrib); // USER SETTINGS else if ($object=='userprefs' && function_exists('rcmail_user_prefs_form')) return rcmail_user_prefs_form($attrib); else if ($object=='itentitieslist' && function_exists('rcmail_identities_list')) return rcmail_identities_list($attrib); else if ($object=='identityframe' && function_exists('rcmail_identity_frame')) return rcmail_identity_frame($attrib); else if ($object=='identityform' && function_exists('rcube_identity_form')) return rcube_identity_form($attrib); else if ($object=='foldersubscription' && function_exists('rcube_subscription_form')) return rcube_subscription_form($attrib); else if ($object=='createfolder' && function_exists('rcube_create_folder_form')) return rcube_create_folder_form($attrib); else if ($object=='pagetitle') { $task = $GLOBALS['_task']; if ($task=='mail' && isset($GLOBALS['MESSAGE']['subject'])) return rep_specialchars_output("RoundCube|Mail :: ".$GLOBALS['MESSAGE']['subject']); else if (isset($GLOBALS['PAGE_TITLE'])) return rep_specialchars_output("RoundCube|Mail :: ".$GLOBALS['PAGE_TITLE']); else if ($task=='mail' && ($mbox_name = $IMAP->get_mailbox_name())) return "RoundCube|Mail :: $mbox_name"; else return "RoundCube|Mail :: $task"; } else if ($object=='about') return ''; break; } return ''; } // create and register a button function rcube_button($attrib) { global $CONFIG, $OUTPUT, $JS_OBJECT_NAME; static $sa_buttons = array(); static $s_button_count = 100; $skin_path = $CONFIG['skin_path']; if (!($attrib['command'] || $attrib['name'])) return ''; // try to find out the button type if ($attrib['type']) $attrib['type'] = strtolower($attrib['type']); else $attrib['type'] = ($attrib['image'] || $attrib['imagepas'] || $arg['imagect']) ? 'image' : 'link'; $command = $attrib['command']; // take the button from the stack if($attrib['name'] && $sa_buttons[$attrib['name']]) $attrib = $sa_buttons[$attrib['name']]; // add button to button stack else if($attrib['image'] || $arg['imagect'] || $attrib['imagepas'] || $attrib['class']) { if(!$attrib['name']) $attrib['name'] = $command; if (!$attrib['image']) $attrib['image'] = $attrib['imagepas'] ? $attrib['imagepas'] : $attrib['imageact']; $sa_buttons[$attrib['name']] = $attrib; } // get saved button for this command/name else if ($command && $sa_buttons[$command]) $attrib = $sa_buttons[$command]; //else // return ''; // set border to 0 because of the link arround the button if ($attrib['type']=='image' && !isset($attrib['border'])) $attrib['border'] = 0; if (!$attrib['id']) $attrib['id'] = sprintf('rcmbtn%d', $s_button_count++); // get localized text for labels and titles if ($attrib['title']) $attrib['title'] = rep_specialchars_output(rcube_label($attrib['title'])); if ($attrib['label']) $attrib['label'] = rep_specialchars_output(rcube_label($attrib['label'])); if ($attrib['alt']) $attrib['alt'] = rep_specialchars_output(rcube_label($attrib['alt'])); // add empty alt attribute for XHTML compatibility if (!isset($attrib['alt'])) $attrib['alt'] = ''; // register button in the system if ($attrib['command']) $OUTPUT->add_script(sprintf("%s.register_button('%s', '%s', '%s', '%s', '%s', '%s');", $JS_OBJECT_NAME, $command, $attrib['id'], $attrib['type'], $attrib['imageact'] ? $skin_path.$attrib['imageact'] : $attrib['classact'], $attirb['imagesel'] ? $skin_path.$attirb['imagesel'] : $attrib['classsel'], $attrib['imageover'] ? $skin_path.$attrib['imageover'] : '')); // overwrite attributes if (!$attrib['href']) $attrib['href'] = '#'; if ($command) $attrib['onclick'] = sprintf("return %s.command('%s','%s',this)", $JS_OBJECT_NAME, $command, $attrib['prop']); if ($command && $attrib['imageover']) { $attrib['onmouseover'] = sprintf("return %s.button_over('%s','%s')", $JS_OBJECT_NAME, $command, $attrib['id']); $attrib['onmouseout'] = sprintf("return %s.button_out('%s','%s')", $JS_OBJECT_NAME, $command, $attrib['id']); } $out = ''; // generate image tag if ($attrib['type']=='image') { $attrib_str = create_attrib_string($attrib, array('style', 'class', 'id', 'width', 'height', 'border', 'hspace', 'vspace', 'alt')); $img_tag = sprintf('<img src="%%s"%s />', $attrib_str); $btn_content = sprintf($img_tag, $skin_path.$attrib['image']); if ($attrib['label']) $btn_content .= ' '.$attrib['label']; $link_attrib = array('href', 'onclick', 'onmouseover', 'onmouseout', 'title'); } else if ($attrib['type']=='link') { $btn_content = $attrib['label'] ? $attrib['label'] : $attrib['command']; $link_attrib = array('href', 'onclick', 'title', 'id', 'class', 'style'); } else if ($attrib['type']=='input') { $attrib['type'] = 'button'; if ($attrib['label']) $attrib['value'] = $attrib['label']; $attrib_str = create_attrib_string($attrib, array('type', 'value', 'onclick', 'id', 'class', 'style')); $out = sprintf('<input%s disabled />', $attrib_str); } // generate html code for button if ($btn_content) { $attrib_str = create_attrib_string($attrib, $link_attrib); $out = sprintf('<a%s>%s</a>', $attrib_str, $btn_content); } return $out; } function rcube_menu($attrib) { return ''; } function rcube_table_output($attrib, $sql_result, $a_show_cols, $id_col) { global $DB; // allow the following attributes to be added to the <table> tag $attrib_str = create_attrib_string($attrib, array('style', 'class', 'id', 'cellpadding', 'cellspacing', 'border', 'summary')); $table = '<table' . $attrib_str . ">\n"; // add table title $table .= "<thead><tr>\n"; foreach ($a_show_cols as $col) $table .= '<td class="'.$col.'">' . rcube_label($col) . "</td>\n"; $table .= "</tr></thead>\n<tbody>\n"; $c = 0; while ($sql_result && ($sql_arr = $DB->fetch_assoc($sql_result))) { $zebra_class = $c%2 ? 'even' : 'odd'; $table .= sprintf('<tr id="rcmrow%d" class="contact '.$zebra_class.'">'."\n", $sql_arr[$id_col]); // format each col foreach ($a_show_cols as $col) { $cont = rep_specialchars_output($sql_arr[$col]); $table .= '<td class="'.$col.'">' . $cont . "</td>\n"; } $table .= "</tr>\n"; $c++; } // complete message table $table .= "</tbody></table>\n"; return $table; } function rcmail_get_edit_field($col, $value, $attrib, $type='text') { $fname = '_'.$col; $attrib['name'] = $fname; if ($type=='checkbox') { $attrib['value'] = '1'; $input = new checkbox($attrib); } else if ($type=='textarea') { $attrib['cols'] = $attrib['size']; $input = new textarea($attrib); } else $input = new textfield($attrib); // use value from post if (!empty($_POST[$fname])) $value = $_POST[$fname]; $out = $input->show($value); return $out; } function create_attrib_string($attrib, $allowed_attribs=array('id', 'class', 'style')) { // allow the following attributes to be added to the <iframe> tag $attrib_str = ''; foreach ($allowed_attribs as $a) if (isset($attrib[$a])) $attrib_str .= sprintf(' %s="%s"', $a, $attrib[$a]); return $attrib_str; } function format_date($date, $format=NULL) { global $CONFIG, $sess_user_lang; if (is_numeric($date)) $ts = $date; else $ts = strtotime($date); // convert time to user's timezone $timestamp = $ts - date('Z', $ts) + ($CONFIG['timezone'] * 3600); // get current timestamp in user's timezone $now = time(); // local time $now -= (int)date('Z'); // make GMT time $now += ($CONFIG['timezone'] * 3600); // user's time $day_secs = 60*((int)date('H', $now)*60 + (int)date('i', $now)); $week_secs = 60 * 60 * 24 * 7; $diff = $now - $timestamp; // define date format depending on current time if ($CONFIG['prettydate'] && !$format && $diff < $day_secs) return sprintf('%s %s', rcube_label('today'), date('H:i', $timestamp)); else if ($CONFIG['prettydate'] && !$format && $diff < $week_secs) $format = $CONFIG['date_short'] ? $CONFIG['date_short'] : 'D H:i'; else if (!$format) $format = $CONFIG['date_long'] ? $CONFIG['date_long'] : 'd.m.Y H:i'; // parse format string manually in order to provide localized weekday and month names // an alternative would be to convert the date() format string to fit with strftime() $out = ''; for($i=0; $i<strlen($format); $i++) { if ($format{$i}=='\\') // skip escape chars continue; // write char "as-is" if ($format{$i}==' ' || $format{$i-1}=='\\') $out .= $format{$i}; // weekday (short) else if ($format{$i}=='D') $out .= rcube_label(strtolower(date('D', $timestamp))); // weekday long else if ($format{$i}=='l') $out .= rcube_label(strtolower(date('l', $timestamp))); // month name (short) else if ($format{$i}=='M') $out .= rcube_label(strtolower(date('M', $timestamp))); // month name (long) else if ($format{$i}=='F') $out .= rcube_label(strtolower(date('F', $timestamp))); else $out .= date($format{$i}, $timestamp); } return $out; } // ************** functions delivering gui objects ************** function rcmail_message_container($attrib) { global $OUTPUT, $JS_OBJECT_NAME; if (!$attrib['id']) $attrib['id'] = 'rcmMessageContainer'; // allow the following attributes to be added to the <table> tag $attrib_str = create_attrib_string($attrib, array('style', 'class', 'id')); $out = '<div' . $attrib_str . "></div>"; $OUTPUT->add_script("$JS_OBJECT_NAME.gui_object('message', '$attrib[id]');"); return $out; } // return code for the webmail login form function rcmail_login_form($attrib) { global $CONFIG, $OUTPUT, $JS_OBJECT_NAME, $SESS_HIDDEN_FIELD; $labels = array(); $labels['user'] = rcube_label('username'); $labels['pass'] = rcube_label('password'); $labels['host'] = rcube_label('server'); $input_user = new textfield(array('name' => '_user', 'size' => 30)); $input_pass = new passwordfield(array('name' => '_pass', 'size' => 30)); $input_action = new hiddenfield(array('name' => '_action', 'value' => 'login')); $fields = array(); $fields['user'] = $input_user->show($_POST['_user']); $fields['pass'] = $input_pass->show(); $fields['action'] = $input_action->show(); if (is_array($CONFIG['default_host'])) { $select_host = new select(array('name' => '_host')); foreach ($CONFIG['default_host'] as $key => $value) $select_host->add($value, (is_numeric($key) ? $value : $key)); $fields['host'] = $select_host->show($_POST['_host']); } else if (!strlen($CONFIG['default_host'])) { $input_host = new textfield(array('name' => '_host', 'size' => 30)); $fields['host'] = $input_host->show($_POST['_host']); } $form_name = strlen($attrib['form']) ? $attrib['form'] : 'form'; $form_start = !strlen($attrib['form']) ? '<form name="form" action="./" method="post">' : ''; $form_end = !strlen($attrib['form']) ? '</form>' : ''; if ($fields['host']) $form_host = <<<EOF </tr><tr> <td class="title">$labels[host]</td> <td>$fields[host]</td> EOF; $OUTPUT->add_script("$JS_OBJECT_NAME.gui_object('loginform', '$form_name');"); $out = <<<EOF $form_start $SESS_HIDDEN_FIELD $fields[action] <table><tr> <td class="title">$labels[user]</td> <td>$fields[user]</td> </tr><tr> <td class="title">$labels[pass]</td> <td>$fields[pass]</td> $form_host </tr></table> $form_end EOF; return $out; } ?>

1 0

Have you considered MDB2?
by Lukas Kahwe Smith 15 Oct '05

15 Oct '05

Hi, I noticed you guys are using PEAR::DB. Looking at rcube_db.inc there is already a bit of conditional code for databases (although I am not sure if you really need the special connect treatment for sqlite). However your lastinsertid handling is for example integrated in MDB2 via the lastInsertID() method (and yes it will work on pgsql as you expect). Furthermore MDB2 can also handle table creation and altering. Through MDB2_Schema it can even do so in a single xml schema file that can automatically determine what create, drop and alter statements are needed which it can then execute or you can extract into an SQL file. As for your handling of NOW(). Currently MDB2 handles this through MDB2_Date. However there have always been plans to add a module that will generate the necessary SQL to make SQL functions portable. Another cool thing I have done for my framework when serializing strings into the database is to add a new abstract datatype to MDB2 which means that MDB2 automatically handles serializing and unserializing for me. Overall you will notice that MDB2 has much more detailed support for datatypes. If you are interested about the current state of things in MDB2 you may want to check out my blog: http://pooteeweet.org/ regards, Lukas

1 0

little bug in the users table definition
by Lukas Kahwe Smith 15 Oct '05

15 Oct '05

Hi, in your SQL create statement for mysql you set the preference column to be NOT NULL, yet in rcmail_create_user() you do not set a value and therefore the query fails. regards, Lukas

1 0

Correction.... Outlook Colors...Read this One...
by Blob 15 Oct '05

15 Oct '05

It seems that the other set is not going to work so don't use it... Just simply open up your common.css sheet and find these lines body { margin: 8px; background-color: #F2F2F2; /* #EBEBEB; */ color: #000000; } Then Replace these with the color of outlook blue which is like #3768BC for Outlook Blue Or #9AAC70 for Outlook Olive Green which I used in all of the # Fields and it worked... That section should be at the very top of common.css then you need to go to the footer section and put the same #s into there which should be a little down from the body. Looks just like this.. Go on change the f2f2f2 to your color :) #footer { position: fixed !important; left: 0px; right: 0px; bottom: 0px !important; height: 40px; background-color: #f2f2f2; Cheers & Enjoy! Blob

1 0

Outlook Colors..... Attached!
by Blob 15 Oct '05

15 Oct '05

Hey Here's a quick fix for the RoundCube Mail package, simply drop / overwrite these common.css sheets into the default skin pack. I'll be working on the theme layout more as well the templates after All we want it to have more flexiablity in the Panes and all that like Outlook & Thunderbird :-) Cheers! & Enjoy! Blob

1 0

Allow login without domain
by dianoga7＠3dgo.net 15 Oct '05

15 Oct '05

For many people who have shared hosting, they are required to login with their full email addresses. Personally, I find this irritating. Thus...a very small bit of code to allow people to login both with or without their full address. File: include/main.inc Function: rcmail_login Line #: 237 Code: if (strpos($user, '@') == false){ $user = $user . '@' . $CONFIG['domain']; } File: config/main.inc.php Line #: 35 (doesn't actually matter though) Code: // Default Domain // Mainly for shared hosting servers. People that use cpanel, etc... // This will allow users to login without typing their full email address // As long as it actually exists on the default domain // The script will check to see if you have a domain in your username. // If not, this will be added to the end. // Set this to whatever comes after the @ in the email address $rcmail_config['domain'] = 'mydomain.com';

8 12

Preview Window
by Praneet Kandula 15 Oct '05

15 Oct '05

grr.. keep forgetting to "Reply All". We really need to set the "Reply-To" header to the dev lists automatically. My reply is below: I believe it's doable right now by making a new skin, but i'm not sure how exactly. Perhaps one of the developers can weigh in on this? Thomas? -- Praneet Kandula On 10/14/05, Brian Steere <dianoga7(a)3dgo.net> wrote: > Anybody working on and/or interested in a preview pane like outlook and > thunderbird? I don't have the skills to code it at the moment (although > I may be learning more to help with this project) but it is definitely > something I would like to see. > > ~Dianoga > > > >

8 15

DB Error: unknown error
by Spook 15 Oct '05

15 Oct '05

Hi, I've just installed Roundcube and am getting the following error: -- DB Error in <snip>program/include/rcube_db.inc (124): DB Error: unknown error DB Error in <snip>program/include/rcube_db.inc (210): DB Error: unknown error Query: SELECT vars, ip, UNIX_TIMESTAMP(changed) AS changed FROM session WHERE sess_id='9f87e941e2f301270beaf0a0c09d2d6f' Fatal error: Call to a member function on a non-object in <snip>program/include/rcube_db.inc on line 202 -- FYI, the query works (returns an empty set) from the MySQL console. MySQL 4.1.13-standard PHP 4.3.2 Anyone have any ideas about this? A php/mysql bunfight, some odd MySQL coalition setting? TIA.

1 0

Patch to allow the user to pick the SMTP authentication type and to allow them to use the same username for IMAP and SMTP
by Myles Eftos 14 Oct '05

14 Oct '05

Hi! I like what you have done so far - look slike a really cool project! I have just installed the latest build. Not sure how you are handling bug reports, but I have found that using the php mail function results in a bad email formation (Probably because I run qmail) - I'll investigate futher and produce a better bug report of patch. I have a patch got a small for SMTP. This patch allow you to set a variable in the config file so that the SMTP server users the same username and password as IMAP and also allows you to supply a smtp_auth type to the PEAR class (For some reason my server was not authenticating when it tried to guess the auth type) > $smtp_auth_type = $CONFIG['smtp_auth_type'] != '' ? $CONFIG['smtp_auth_type'] : NULL; 80c81 < if (PEAR::isError($SMTP_CONN->auth($CONFIG['smtp_user'], $CONFIG['smtp_pass']))) --- > if (PEAR::isError($SMTP_CONN->auth($CONFIG['smtp_user'], $CONFIG['smtp_pass'], $smtp_auth_type))) 85a87,96 > } > > if($CONFIG['smtp_login_same'] && $CONFIG['smtp_login_same'] == true) > { > if (PEAR::isError($SMTP_CONN->auth($_SESSION['username'], decrypt_passwd($_SESSION['password']), $smtp_auth_type))) > { > smtp_reset(); > $SMTP_ERROR .= "authentication failure\n"; > return FALSE; > } you will need to add two variables to the main.inc.php file // If true, uses the same password as the current logged in user $rcmail_config['smtp_login_same'] = true; $rcmail_config['smtp_auth_type'] = ''; Let me know if you need more info or things supplied differently Thanks! - Myles

3 3

Mailing list administrative information and a status update
by B. Johannessen 14 Oct '05

14 Oct '05

RoundCube developers and users, just thought I'd post a bit of mailing list administrative information and short status update on Trac/Wiki/Archive/Subversion matters. * When posting to the RoundCube Dev list, please make sure you do so from the address with which you are subscribed. All messages from non subscribers are held for moderation, so when you post from another address it increases the moderators workload (Thomas and me) and it delays your message. If you do post from another address by accident, please don't repost from the correct address. This will most likely lead to your message being posted to the list twice. Sometimes in the next few two weeks I'll probably ask one or two of you to help with the moderation (I'll do so in a private e-mail). The moderation is in place only to keep the list from redistributing any spam that will inevitably be sent to it's submission address. *All* non-spam messages should be approved by the moderators. * Some of you have over eager anti-spam filters in place on the addresses subscribed to the list and you are rejecting legitimate list traffic. If it's at all possible, please make sure you white list e-mail from 195.159.29.202/maildialog.com. In cases where I see excessive rejects for a particularly stupid reason, I'll just unsubscribe the offending address to keep my workload at an acceptable level. * Some of you have asked that we include a Reply-To: header in messages distributed to the list. I could go on at length about why this is not a good idea, but luckily Chip Rosenthal has already done so. Anyone interested should read his excellent essay: "Reply-To" Munging Considered Harmful http://www.unicom.com/pw/reply-to-harmful.html * A few words om mailing list etiquette: When replying to the list, please make sure to remove any irrelevant quoted text before sending. In the last few days I've seen some horrible examples of messages with just a few words of original content, followed by several kb of quoted text. Please show some consideration and spend the 2 seconds needed to trim your quotes. Another matter of mailing list etiquette is top-post reply vs. in-line reply. This is a matter of some debate, and not something that should be discussed here. I'll just ask that you all take a look at the excellent Wikipedia article on the subject and form your own opinion on the matter: http://en.wikipedia.org/wiki/Top-posting I'll also note that quite a few people (myself included) subscribe to more mailing lists then they have time to read. For such people, one factor in deciding to read or skip your reply may be if it's top-posted or in-line (again, myself included). * Redistribution delays: The mail server hosting the mailing list got a bit of a surprise after the Slashdot "incident", and have been experiencing some redistribution delays. I've seen delays as high as 30 minutes, but it looks like more then 97% of all traffic is delivered within 5 minutes. This has to do with the Exim install not being optimized for mailing list deliveries. I'll keep an eye on this over the next few day. * I've had reports of mailing list subscribers experiencing probeing looking for RoundCube installs after posting to the list. Please keep an eye out for this. RoundCube is not production ready, and it's entirely possible there may be some exploitable security holes in it (see below). The report I got saw probes from 70.177.39.72, so if you could all check your logs for this IP. If you find something, please e-mail *me*, not the list, and I'll coordinate the investigation. Even if you don't have any probes from that address, please keep en eye out for unusual activity, especially if you've posted identifying details to the mailing list. * Security in RoundCube: There's been talk about letting users select the IMAP server to connect to (via select boxes, input boxes, from the domain in the URL and others). If this is combined with a RoundCube configured to relay outgoing e-mail via a hardcoded local SMTP relay you have an exploitable setup, and will probably have problems sooner or later. Please keep this in mind! * Status of Trac/Wiki/Archive/Subversion: All the software for the new web site (Trac with wiki, MHonArc mailing list archive and Subversion) has been set up. What remains is a bit of work on the layout, and some porting of information from the old site. I'm currently working with Thomas on the former, but could use some help on the later. So if you feel like helping out with porting some information into the wiki, send me a private e-mail and I'll get back to you. I also think it's about time someone started working on a FAQ, so if you have a few hours to spare, good English communication skills, a rough understanding of how RoundCube works, and the most common problems experienced by it's users, drop me en e-mail and I'll get you advanced access to the new wiki so you can get started. Bob (list-mom)

1 0

Re: DB error
by chrisl＠xp.etowns.net 14 Oct '05

14 Oct '05

Fedora Core 4 box php-5.0.4-10.4 sendmail-8.13.4-2 mysql-4.1.14-1.FC4.1 dovecot-0.99.14-4.fc4 PEAR Items Package Version State Archive_Tar 1.3.1 stable Console_Getopt 1.2 stable DB 1.7.6 stable HTML_Template_IT 1.1.1 stable HTTP 1.3.6 stable Mail 1.1.9 stable Net_SMTP 1.2.7 stable Net_Socket 1.0.6 stable Net_UserAgent_Detect 2.1.0 stable PEAR 1.4.2 stable PEAR_Frontend_Gtk 0.4.0 beta PEAR_Frontend_Web 0.4 beta XML_Parser 1.2.7 stable XML_RPC 1.4.3 stable macross wrote: >It's not liking the DB_Error::query() function. Seems to be a Pear issue as >that's what he is using to access DB's > >What PHP PEAR DB MailServer combo are you using? > >-----Original Message----- >From: chrisl(a)xp.etowns.net [mailto:chrisl@xp.etowns.net] >Sent: Friday, October 14, 2005 4:30 PM >To: macross >Cc: dev(a)lists.roundcube.net >Subject: Re: DB error > >I upgraded all the PEAR modules and installed PEAR_Frontend_Gtk and >PEAR_Frontend_Web as they were suggested for the PEAR upgrade. > >I see the same error... > >macross wrote: > > > >>Check your PEAR installation >> >>-----Original Message----- >>From: chrisl(a)xp.etowns.net [mailto:chrisl@xp.etowns.net] >>Sent: Friday, October 14, 2005 4:01 PM >>To: dev(a)lists.roundcube.net >>Subject: DB error >> >>*I received this error when I first accessed my roundcube site >> >>DB Error in /var/www/html/roundcubemail/program/include/rcube_db.inc >>(63):* DB Error: extension not found >> >>*Fatal error*: Call to undefined method DB_Error::query() in >>*/var/www/html/roundcubemail/program/include/rcube_db.inc* on line *119* >> >> >> >> >> >> >> >> >> >> > > > > >

4 4

Re: DB error
by chrisl＠xp.etowns.net 14 Oct '05

14 Oct '05

I adjusted it to be include_path = ".:/php/includes:/usr/share/pear/" still no luck... Does /php/includes correspond to an actual path on a BSD box? macross wrote: >Check your include statement within php.ini ensure it's pointing to your >pear directory. You have an rpm install and have updated it from source or >it appears that way. > >i.e. on FreeBSD > >include_path = ".:/php/includes:/usr/local/share/pear/" > > > >-----Original Message----- >From: chrisl(a)xp.etowns.net [mailto:chrisl@xp.etowns.net] >Sent: Friday, October 14, 2005 4:42 PM >To: macross >Cc: dev(a)lists.roundcube.net >Subject: Re: DB error > >Fedora Core 4 box > >php-5.0.4-10.4 >sendmail-8.13.4-2 >mysql-4.1.14-1.FC4.1 >dovecot-0.99.14-4.fc4 > >PEAR Items >Package Version State >Archive_Tar 1.3.1 stable >Console_Getopt 1.2 stable >DB 1.7.6 stable >HTML_Template_IT 1.1.1 stable >HTTP 1.3.6 stable >Mail 1.1.9 stable >Net_SMTP 1.2.7 stable >Net_Socket 1.0.6 stable >Net_UserAgent_Detect 2.1.0 stable >PEAR 1.4.2 stable >PEAR_Frontend_Gtk 0.4.0 beta >PEAR_Frontend_Web 0.4 beta >XML_Parser 1.2.7 stable >XML_RPC 1.4.3 stable > >macross wrote: > > > >>It's not liking the DB_Error::query() function. Seems to be a Pear issue >> >> >as > > >>that's what he is using to access DB's >> >>What PHP PEAR DB MailServer combo are you using? >> >>-----Original Message----- >>From: chrisl(a)xp.etowns.net [mailto:chrisl@xp.etowns.net] >>Sent: Friday, October 14, 2005 4:30 PM >>To: macross >>Cc: dev(a)lists.roundcube.net >>Subject: Re: DB error >> >>I upgraded all the PEAR modules and installed PEAR_Frontend_Gtk and >>PEAR_Frontend_Web as they were suggested for the PEAR upgrade. >> >>I see the same error... >> >>macross wrote: >> >> >> >> >> >>>Check your PEAR installation >>> >>>-----Original Message----- >>>From: chrisl(a)xp.etowns.net [mailto:chrisl@xp.etowns.net] >>>Sent: Friday, October 14, 2005 4:01 PM >>>To: dev(a)lists.roundcube.net >>>Subject: DB error >>> >>>*I received this error when I first accessed my roundcube site >>> >>>DB Error in /var/www/html/roundcubemail/program/include/rcube_db.inc >>>(63):* DB Error: extension not found >>> >>>*Fatal error*: Call to undefined method DB_Error::query() in >>>*/var/www/html/roundcubemail/program/include/rcube_db.inc* on line *119* >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >>> >> >> >> >> >> > > > > >

1 0

low priority multiple select changes
by Joshua Layne 14 Oct '05

14 Oct '05

Hi all, this is a nit in comparisson to much of the work that needs to be done, but 2 things: 1) it is currently possible to select multiple items using the <shift> key, it has always been my understanding that this is a function more commonly accessed with the <ctrl> key - is there a technical limitation on this, or am I just windows-centric? (..begins to smash head against wall..) 2) is it possible to select an entire range of messages using <ctrl>+<shift> - this would be useful for sorting messages that all go in the same folder (e.g. the 40+ messages a day from this listserv) finally, if nobody is opposed to this (this doesn't seem like a plugin to me), I can tackle it with my oh-so-rusty hack javascript skilz. also, thinking about it - this might be skinnable behavior, once the structure was in place. thoughts? j.

2 1

More detailed installation instructions?
by Hello Spammers 14 Oct '05

14 Oct '05

I'm new to both roundcube and SQL. I'm trying to get roundcube to work with a sqlite database, but when I try to login I get the following errors: DB Error in /home/www/html/roundcubemail/program/include/rcube_db.inc (63): DB Error: no database selected Fatal error: Call to undefined function: query() in /home/www/html/roundcubemail/program/include/rcube_db.inc on line 119 My guess is that I've configured db.inc.php incorrectly. Do more detailed installation instructions (with examples, preferably) exist somewhere? I have been unable to find any helpful documentation for newbies. The installation instructions are a nice general outline, but more details would be really helpful. Thanks. H.S.

1 0

RE: IMAP-UW - Problems with plaintext login
by Tim Simmons 14 Oct '05

14 Oct '05

Maildir has been running fine on my system for over a year, so I don't thing we were having the same issue. I can log in via IMAP fine using other clients, have no problems there. I don't think we're having the same issue. Thank you. Tim Simmons IT Technician Champion Realty, Inc. TimSimmons(a)ChampionRealty.Com Direct:410-975-3028 Fax: 410-647-1187 -----Original Message----- From: garaged [mailto:garaged@gmail.com] Sent: Friday, October 14, 2005 4:59 PM To: Tim Simmons Subject: Re: IMAP-UW - Problems with plaintext login On 10/14/05, Tim Simmons <TimSimmons(a)championrealty.com> wrote: > Could you be a little more specific about how you fixed this issue? Thank > you :) Pretty much, i created ~/Maildir, sent myself a mail, this populated the directory, and changed, mmm, I think I didnt change anythig on config, I just checked. Maildir is configurable, check your mail daemon config if doesnt work. Max -- -----BEGIN GEEK CODE BLOCK----- Version: 3.12 GS/S d- s: a-29 C++(+++) ULAHI+++ P+ L++>+++ E--- W++ N* o-- K- w++++ O- M-- V-- PS+ PE Y-- PGP++ t- 5- X+ R tv++ b+ DI+++ D- G++ e++ h+ r+ z** ------END GEEK CODE BLOCK------

1 0

Re: RE: Theme Ideas.....
by Joshua Layne 14 Oct '05

14 Oct '05

I like the idea of user-skinnable themes, except when the webmail is embedded in another website (I am currently using roundcube in an iframe) - what about an alternate input to the skin (override) via a URL parameter? That way, users could have saved skins for when they are accessing webmail natively, but if they were in _MY_ world, it would look like my site :P thoughts? j. On Fri, 14 Oct 2005 16:22:05 -0400, "macross" <macross(a)msyte.com> wrote: > I'll rewrite the css styles over the weekend adding outlook web access and > basic squirrel for nostalgia, however you will have to make the changes I > previously posted for them to become active. > > So basically I'll handle css change functions and you all can modify the > css > files how you want (but I'll put in some default samples) then we can > package it together. > > Modify the mail.css and common.css I'll make sure they get called upon by > roundcube. > > -----Original Message----- > From: Praneet Kandula [mailto:pkmlist@gmail.com] > Sent: Friday, October 14, 2005 3:58 PM > To: Blob > Cc: dev(a)lists.roundcube.net > Subject: Re: Theme Ideas..... > > How aobut something with the colors of Microsoft Outlook 2003? Perhaps > something that resembles outlook web access? I think this will be a > pretty popular one if you manage to pull off the color scheme.. > > Screenshots of Outlook Web Access 2003. > > http://www.nycenet.edu/NR/rdonlyres/79F4D5EE-019D-4D7E-BBA4-AED55A78CAE6/128 > 4/owa2003screenshots.pdf > > I think the icons are the same ones from Outlook 2003 desktop too. Let > me know if you need any more info. Can't wait to see what you come up > with! > > -- > Praneet Kandula > > On 10/14/05, Blob <blob(a)xdashcentral.us> wrote: >> >> Hey All, >> I'm going to give it a shot in makin' a couple diffrent themes for > this > webmail system using the default theme. I just wanted to know if there > were > anyone that was wanting a certain theme made so I could do it for them. > The > theme I'm making for my self is more likely going to be a Matrix Theme or > Xbox theme which I'm sure isn't the taste of everyone else so give me a > theme to make that everyone would like such as Olive Green just like in > Thunderbird or Outlook etc... Then I will try and give it a shot :) >> >> Cheers! >> blob >> >> >> >> >> >>

2 1

Re: DB error
by chrisl＠xp.etowns.net 14 Oct '05

14 Oct '05

I upgraded all the PEAR modules and installed PEAR_Frontend_Gtk and PEAR_Frontend_Web as they were suggested for the PEAR upgrade. I see the same error... macross wrote: >Check your PEAR installation > >-----Original Message----- >From: chrisl(a)xp.etowns.net [mailto:chrisl@xp.etowns.net] >Sent: Friday, October 14, 2005 4:01 PM >To: dev(a)lists.roundcube.net >Subject: DB error > >*I received this error when I first accessed my roundcube site > >DB Error in /var/www/html/roundcubemail/program/include/rcube_db.inc >(63):* DB Error: extension not found > >*Fatal error*: Call to undefined method DB_Error::query() in >*/var/www/html/roundcubemail/program/include/rcube_db.inc* on line *119* > > > > > > > >

2 1

RE: RE: CSS Style Change
by macross 14 Oct '05

14 Oct '05

Yes it's possible just remember you need to modify both common.css and mail.css. common.css handles the background where we can choose a picture instead of a bg color. Wish I had time or I would write it now. They don't actually have to be separate files. I'll send a sample. -----Original Message----- From: Blob [mailto:blob@xdashcentral.us] Sent: Friday, October 14, 2005 4:21 PM To: macross Subject: Re: RE: CSS Style Change MMM so it would not be possible to make a Maxtrix theme??? Just a solid color?? Since it's all controlled by .css right?? I guess I'll go with Olive Green only and no Matrix theme :( Unless there is a already set # for the Matrix Background you know what I'm saying :) Cheers! Jason On Fri, 14 Oct 2005 16:07:35 -0400, "macross" <macross(a)msyte.com> wrote: > Backgrounds and background color are held within the common.css > %s/mail.css/common.css/ if you are looking to modify the background and > tables etc... > > This will change text and list box behaviours. I can write in modifying > both I suppose with a single css. > > -----Original Message----- > From: Blob [mailto:blob@xdashcentral.us] > Sent: Friday, October 14, 2005 4:01 PM > To: macross > Subject: Re: CSS Style Change > > > Cool This is gonna help me out alot :-) I'm gonna be working on a Matrix > Theme for this webmail package. Might use Yellow or Orange Font on the > text > for the GUI with Matrix. which are either #FF5500 or #FFFF00 Now are all > of these #s in this .CSS related to Text only?? or are there a few for the > backgrounds etc.. which i plan on changing via http code if possible like > with the templates and images etc... > > Cheers! > Jason > > On Fri, 14 Oct 2005 15:54:03 -0400, "macross" <macross(a)msyte.com> wrote: >> Anyone interested in updating their css styles on the fly. I've put > this >> together. It could/should be put in the preferences page I suppose. > But >> I >> am just mucking around here. Send me change if any are made. >> >> Enter this into roundcubemail/skins/default/mail.css >> >> #stylechange >> { >> position: absolute; >> top: 535px; >> left: 20px; >> width: 160px; >> border: 1px solid #CCCCCC; >> color: #333333; >> font-size: 11px; >> font-weight: bold; >> } >> >> Enter this into roundcubemail/program/js/common.js >> >> var expDays = 9999; >> var standardStyle = '2'; >> var nameOfCookie = 'switchstyle'; >> var urlToCSSDirectory = 'roundcubemail/skins/default/'; >> var ScreenCSS_1 = 'mail.css'; >> var ScreenCSS_2 = 'mail_2.css'; >> var ScreenCSS_3 = 'mail_3.css'; >> var ScreenCSS_4 = 'mail_4.css'; >> var ScreenCSS_5 = 'mail_5.css'; >> >> //Let's you change print option CSS // >> >> var PrintCSS_1 = 'mail_1.css'; >> var PrintCSS_2 = 'mail_2.css'; >> var PrintCSS_3 = 'mail_3.css'; >> var PrintCSS_4 = 'mail_4.css'; >> var PrintCSS_5 = 'mail_5.css'; >> >> function switchStyleOfUser(){ >> var fontSize = GetCookie(nameOfCookie); >> if (fontSize == null) { >> fontSize = standardStyle; >> } >> >> if (fontSize == "1") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + ' ' + ScreenCSS_1 + '" >> media="screen">'); } >> if (fontSize == "2") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + ScreenCSS_2 + '" >> media="screen">'); } >> if (fontSize == "3") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + ScreenCSS_3 + '" >> media="screen">'); } >> if (fontSize == "4") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + ScreenCSS_4 + '" >> media="screen">'); } >> if (fontSize == "5") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + ScreenCSS_5 + '" >> media="screen">'); } >> >> if (fontSize == "1") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + PrintCSS_1 + '" >> media="print">'); } >> if (fontSize == "2") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + PrintCSS_2 + '" >> media="print">'); } >> if (fontSize == "3") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + PrintCSS_3 + '" >> media="print">'); } >> if (fontSize == "4") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + PrintCSS_4 + '" >> media="print">'); } >> if (fontSize == "5") { document.write('<link rel="stylesheet" >> type"text/css" href="' + urlToCSSDirectory + PrintCSS_5 + '" >> media="print">'); } >> >> var fontSize = ""; >> return fontSize; >> } >> >> var exp = new Date(); >> exp.setTime(exp.getTime() + (expDays*24*60*60*1000)); >> function getCookieVal (offset) { >> var endstr = document.cookie.indexOf (";", offset); >> if (endstr == -1) >> endstr = document.cookie.length; >> return unescape(document.cookie.substring(offset, endstr)); >> } >> function GetCookie (name) { >> var arg = name + "="; >> var alen = arg.length; >> var clen = document.cookie.length; >> var i = 0; >> while (i < clen) { >> var j = i + alen; >> if (document.cookie.substring(i, j) == arg) >> return getCookieVal (j); >> i = document.cookie.indexOf(" ", i) + 1; >> if (i == 0) break; >> } >> return null; >> } >> function SetCookie (name, value) { >> var argv = SetCookie.arguments; >> var argc = SetCookie.arguments.length; >> var expires = (argc > 2) ? argv[2] : null; >> var path = (argc > 3) ? argv[3] : null; >> var domain = (argc > 4) ? argv[4] : null; >> var secure = (argc > 5) ? argv[5] : false; >> document.cookie = name + "=" + escape (value) + >> ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + >> ((path == null) ? "" : ("; path=" + path)) + >> ((domain == null) ? "" : ("; domain=" + domain)) + >> ((secure == true) ? "; secure" : ""); >> } >> function DeleteCookie (name) { >> var exp = new Date(); >> exp.setTime (exp.getTime() - 1); >> var cval = GetCookie (name); >> document.cookie = name + "=" + cval + "; expires=" + >> exp.toGMTString(); >> } >> function doRefresh(){ >> location.reload(); >> } >> document.write(switchStyleOfUser()); >> >> Enter this into roundcubemail/skins/default/templates/mail.html >> At the bottom just before it includes the taskbar.html >> >> <div id="stylechange"> >> <input type="radio" name="rcstyl" value="1" >> onclick="SetCookie(nameOfCookie, >> this.value, exp); doRefresh();"> style 1<br> >> <input type="radio" name="rcstyl" value="2" >> onclick="SetCookie(nameOfCookie, >> this.value, exp); doRefresh();"> style 2<br> >> <input type="radio" name="rcstyl" value="3" >> onclick="SetCookie(nameOfCookie, >> this.value, exp); doRefresh();"> style 3<br> >> <input type="radio" name="rcstyl" value="4" >> onclick="SetCookie(nameOfCookie, >> this.value, exp); doRefresh();"> style 4<br> >> <input type="radio" name="rcstyl" value="5" >> onclick="SetCookie(nameOfCookie, >> this.value, exp); doRefresh();"> style 5<br> >> </div> >> >> >> Copy the mail.css file and modify it to your own liking naming > mail_2.css >> mail_3.css etc etc >> >> Done! >> >>

1 0

Theme Ideas.....
by Blob 14 Oct '05

14 Oct '05

Hey All, I'm going to give it a shot in makin' a couple diffrent themes for this webmail system using the default theme. I just wanted to know if there were anyone that was wanting a certain theme made so I could do it for them. The theme I'm making for my self is more likely going to be a Matrix Theme or Xbox theme which I'm sure isn't the taste of everyone else so give me a theme to make that everyone would like such as Olive Green just like in Thunderbird or Outlook etc... Then I will try and give it a shot :) Cheers! blob

5 4

DB error
by chrisl＠xp.etowns.net 14 Oct '05

14 Oct '05

*I received this error when I first accessed my roundcube site DB Error in /var/www/html/roundcubemail/program/include/rcube_db.inc (63):* DB Error: extension not found *Fatal error*: Call to undefined method DB_Error::query() in */var/www/html/roundcubemail/program/include/rcube_db.inc* on line *119*

2 1

RE: CSS Style Change
by macross 14 Oct '05

14 Oct '05

Backgrounds and background color are held within the common.css %s/mail.css/common.css/ if you are looking to modify the background and tables etc... This will change text and list box behaviours. I can write in modifying both I suppose with a single css. -----Original Message----- From: Blob [mailto:blob@xdashcentral.us] Sent: Friday, October 14, 2005 4:01 PM To: macross Subject: Re: CSS Style Change Cool This is gonna help me out alot :-) I'm gonna be working on a Matrix Theme for this webmail package. Might use Yellow or Orange Font on the text for the GUI with Matrix. which are either #FF5500 or #FFFF00 Now are all of these #s in this .CSS related to Text only?? or are there a few for the backgrounds etc.. which i plan on changing via http code if possible like with the templates and images etc... Cheers! Jason On Fri, 14 Oct 2005 15:54:03 -0400, "macross" <macross(a)msyte.com> wrote: > Anyone interested in updating their css styles on the fly. I've put this > together. It could/should be put in the preferences page I suppose. But > I > am just mucking around here. Send me change if any are made. > > Enter this into roundcubemail/skins/default/mail.css > > #stylechange > { > position: absolute; > top: 535px; > left: 20px; > width: 160px; > border: 1px solid #CCCCCC; > color: #333333; > font-size: 11px; > font-weight: bold; > } > > Enter this into roundcubemail/program/js/common.js > > var expDays = 9999; > var standardStyle = '2'; > var nameOfCookie = 'switchstyle'; > var urlToCSSDirectory = 'roundcubemail/skins/default/'; > var ScreenCSS_1 = 'mail.css'; > var ScreenCSS_2 = 'mail_2.css'; > var ScreenCSS_3 = 'mail_3.css'; > var ScreenCSS_4 = 'mail_4.css'; > var ScreenCSS_5 = 'mail_5.css'; > > //Let's you change print option CSS // > > var PrintCSS_1 = 'mail_1.css'; > var PrintCSS_2 = 'mail_2.css'; > var PrintCSS_3 = 'mail_3.css'; > var PrintCSS_4 = 'mail_4.css'; > var PrintCSS_5 = 'mail_5.css'; > > function switchStyleOfUser(){ > var fontSize = GetCookie(nameOfCookie); > if (fontSize == null) { > fontSize = standardStyle; > } > > if (fontSize == "1") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + ' ' + ScreenCSS_1 + '" > media="screen">'); } > if (fontSize == "2") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + ScreenCSS_2 + '" > media="screen">'); } > if (fontSize == "3") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + ScreenCSS_3 + '" > media="screen">'); } > if (fontSize == "4") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + ScreenCSS_4 + '" > media="screen">'); } > if (fontSize == "5") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + ScreenCSS_5 + '" > media="screen">'); } > > if (fontSize == "1") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + PrintCSS_1 + '" > media="print">'); } > if (fontSize == "2") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + PrintCSS_2 + '" > media="print">'); } > if (fontSize == "3") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + PrintCSS_3 + '" > media="print">'); } > if (fontSize == "4") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + PrintCSS_4 + '" > media="print">'); } > if (fontSize == "5") { document.write('<link rel="stylesheet" > type"text/css" href="' + urlToCSSDirectory + PrintCSS_5 + '" > media="print">'); } > > var fontSize = ""; > return fontSize; > } > > var exp = new Date(); > exp.setTime(exp.getTime() + (expDays*24*60*60*1000)); > function getCookieVal (offset) { > var endstr = document.cookie.indexOf (";", offset); > if (endstr == -1) > endstr = document.cookie.length; > return unescape(document.cookie.substring(offset, endstr)); > } > function GetCookie (name) { > var arg = name + "="; > var alen = arg.length; > var clen = document.cookie.length; > var i = 0; > while (i < clen) { > var j = i + alen; > if (document.cookie.substring(i, j) == arg) > return getCookieVal (j); > i = document.cookie.indexOf(" ", i) + 1; > if (i == 0) break; > } > return null; > } > function SetCookie (name, value) { > var argv = SetCookie.arguments; > var argc = SetCookie.arguments.length; > var expires = (argc > 2) ? argv[2] : null; > var path = (argc > 3) ? argv[3] : null; > var domain = (argc > 4) ? argv[4] : null; > var secure = (argc > 5) ? argv[5] : false; > document.cookie = name + "=" + escape (value) + > ((expires == null) ? "" : ("; expires=" + expires.toGMTString())) + > ((path == null) ? "" : ("; path=" + path)) + > ((domain == null) ? "" : ("; domain=" + domain)) + > ((secure == true) ? "; secure" : ""); > } > function DeleteCookie (name) { > var exp = new Date(); > exp.setTime (exp.getTime() - 1); > var cval = GetCookie (name); > document.cookie = name + "=" + cval + "; expires=" + > exp.toGMTString(); > } > function doRefresh(){ > location.reload(); > } > document.write(switchStyleOfUser()); > > Enter this into roundcubemail/skins/default/templates/mail.html > At the bottom just before it includes the taskbar.html > > <div id="stylechange"> > <input type="radio" name="rcstyl" value="1" > onclick="SetCookie(nameOfCookie, > this.value, exp); doRefresh();"> style 1<br> > <input type="radio" name="rcstyl" value="2" > onclick="SetCookie(nameOfCookie, > this.value, exp); doRefresh();"> style 2<br> > <input type="radio" name="rcstyl" value="3" > onclick="SetCookie(nameOfCookie, > this.value, exp); doRefresh();"> style 3<br> > <input type="radio" name="rcstyl" value="4" > onclick="SetCookie(nameOfCookie, > this.value, exp); doRefresh();"> style 4<br> > <input type="radio" name="rcstyl" value="5" > onclick="SetCookie(nameOfCookie, > this.value, exp); doRefresh();"> style 5<br> > </div> > > > Copy the mail.css file and modify it to your own liking naming mail_2.css > mail_3.css etc etc > > Done! > >

1 0

Plug-ins / themes / Filters - Development??
by Blob 14 Oct '05

14 Oct '05

I just now installed the Webmail system... I like it! Now I wonder where I can get addons for it such as a filter or more themes and plug-ins etc... for it. Cheers! Jason

5 4

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

Dev