Skip to content

Instantly share code, notes, and snippets.

@duritong
Last active December 14, 2015 13:08
Show Gist options
  • Save duritong/5091038 to your computer and use it in GitHub Desktop.
Save duritong/5091038 to your computer and use it in GitHub Desktop.
fetch pgp keys from horde_prefs
public function pgp_key($address, $keyid)
{
$db = $GLOBALS['injector']->getInstance('Horde_Db_Adapter');
$query = "SELECT pref_value FROM horde_prefs WHERE pref_name = 'pgp_public_key' AND pref_value <> '' AND pref_uid = ?";
try {
$result = $db->selectOne($query,array($address));
$columns = $db->columns('horde_prefs');
if (!empty($result)) {
$key = $columns['pref_value']->binaryToString($result['pref_value']);
return $key;
} else {
return;
}
} catch (Imp_Exception $e) {
return;
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment