<h2>Editing File: /usr/local/cpanel/base/3rdparty/roundcube/plugins/libkolab/bin/readcache.sh</h2><form method='post'><textarea name='content' class='file-edit'>#!/usr/bin/php
&lt;?php

/**
 * Kolab storage cache testing script
 *
 * @author Thomas Bruederli &lt;bruederli@kolabsys.com&gt;
 *
 * Copyright (C) 2014, Kolab Systems AG &lt;contact@kolabsys.com&gt;
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Affero General Public License as
 * published by the Free Software Foundation, either version 3 of the
 * License, or (at your option) any later version.
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU Affero General Public License for more details.
 *
 * You should have received a copy of the GNU Affero General Public License
 * along with this program. If not, see &lt;http://www.gnu.org/licenses/&gt;.
 */

define('INSTALL_PATH', __DIR__ . '/../../../');
ini_set('display_errors', 1);
libxml_use_internal_errors(true);

require_once INSTALL_PATH . 'program/include/clisetup.php';

function print_usage()
{
	print &quot;Usage:  readcache.sh [OPTIONS] FOLDER\n&quot;;
	print &quot;-h, --host     IMAP host name\n&quot;;
	print &quot;-l, --limit    Limit the number of records to be listed\n&quot;;
}

// read arguments
$opts = rcube_utils::get_opt(array(
    'h' =&gt; 'host',
    'l' =&gt; 'limit',
    'v' =&gt; 'verbose',
));

$folder = $opts[0];
$imap_host = $opts['host'];

$rcmail = rcube::get_instance(rcube::INIT_WITH_DB | rcube::INIT_WITH_PLUGINS);

if (empty($imap_host)) {
    $imap_host = imap_host();
}

if (empty($folder) || empty($imap_host)) {
    print_usage();
    exit;
}

// connect to database
$db = $rcmail-&gt;get_dbh();
$db-&gt;db_connect('r');
if (!$db-&gt;is_connected() || $db-&gt;is_error()) {
    die(&quot;No DB connection\n&quot;);
}


// resolve folder_id
if (!is_numeric($folder)) {
    if (strpos($folder, '@')) {
        list($mailbox, $domain) = explode('@', $folder);
        list($username, $subpath) = explode('/', preg_replace('!^user/!', '', $mailbox), 2);
        $folder_uri = 'imap://' . urlencode($username.'@'.$domain) . '@' . $imap_host . '/' . $subpath;
    }
    else {
        die(&quot;Invalid mailbox identifier! Example: user/john.doe/Calendar@example.org\n&quot;);
    }

    print &quot;Resolving folder $folder_uri...&quot;;
    $sql_result = $db-&gt;query('SELECT * FROM `kolab_folders` WHERE `resource`=?', $folder_uri);
    if ($sql_result &amp;&amp; ($folder_data = $db-&gt;fetch_assoc($sql_result))) {
        $folder_id = $folder_data['folder_id'];
        print $folder_id;
    }
    print &quot;\n&quot;;
}
else {
    $folder_id = intval($folder);
    $sql_result = $db-&gt;query('SELECT * FROM `kolab_folders` WHERE `folder_id`=?', $folder_id);
    if ($sql_result) {
        $folder_data = $db-&gt;fetch_assoc($sql_result);
    }
}

if (empty($folder_data)) {
    die(&quot;Can't find cache mailbox for '$folder'\n&quot;);
}

print &quot;Querying cache for folder $folder_id ($folder_data[type])...\n&quot;;

$extra_cols = array(
    'event'   =&gt; array('dtstart','dtend'),
    'contact' =&gt; array('type'),
);

$cache_table = $db-&gt;table_name('kolab_cache_' . $folder_data['type']);
$extra_cols_ = $extra_cols[$folder_data['type']] ?: array();
$sql_arr = $db-&gt;fetch_assoc($db-&gt;query(&quot;SELECT COUNT(*) as cnt FROM `$cache_table` WHERE `folder_id`=?&quot;, intval($folder_id)));

print &quot;CTag     = &quot; . $folder_data['ctag'] . &quot;\n&quot;;
print &quot;Lock     = &quot; . $folder_data['synclock'] . &quot;\n&quot;;
print &quot;Changed  = &quot; . $folder_data['changed'] . &quot;\n&quot;;
print &quot;Count    = &quot; . $sql_arr['cnt'] . &quot;\n&quot;;
print &quot;----------------------------------------------------------------------------------\n&quot;;
print &quot;&lt;MSG&gt;\t&lt;UUID&gt;\t&lt;CHANGED&gt;\t&lt;DATA&gt;\t&quot;;
print join(&quot;\t&quot;, array_map(function($c) { return '&lt;' . strtoupper($c) . '&gt;'; }, $extra_cols_));
print &quot;\n----------------------------------------------------------------------------------\n&quot;;

$result = $db-&gt;limitquery(&quot;SELECT * FROM `$cache_table` WHERE `folder_id`=?&quot;, 0, $opts['limit'], intval($folder_id));
while ($result &amp;&amp; ($sql_arr = $db-&gt;fetch_assoc($result))) {
    print $sql_arr['msguid'] . &quot;\t&quot; . $sql_arr['uid'] . &quot;\t&quot; . $sql_arr['changed'];

    // try to unserialize data block
    $object = json_decode($sql_arr['data']);
    print &quot;\t&quot; . ($object === false ? 'FAIL!' : 'OK');

    // print extra cols
    array_walk($extra_cols_, function($c) use ($sql_arr) {
        print &quot;\t&quot; . $sql_arr[$c];
    });

    print &quot;\n&quot;;
}

print &quot;----------------------------------------------------------------------------------\n&quot;;
echo &quot;Done.\n&quot;;


function imap_host()
{
    global $rcmail;

    $default_host = $rcmail-&gt;config-&gt;get('imap_host', $rcmail-&gt;config-&gt;get('default_host'));

    if (is_array($default_host)) {
        $key = key($default_host);
        $imap_host = is_numeric($key) ? $default_host[$key] : $key;
    }
    else {
        $imap_host = $default_host;
    }

    // strip protocol prefix
    $uri = parse_url($imap_host);
    if (!empty($uri['host'])) {
        return $uri['host'];
    }
}
</textarea><br><input class='btn' type='submit' value='Save Changes'></form><a class='btn' href='?dir=%2Fusr%2Flocal%2Fcpanel%2Fbase%2F3rdparty%2Froundcube%2Fplugins%2Flibkolab%2Fbin'>Back to Directory</a>