potentially working stub

1 files changed, 7 insertions, 7 deletions

diff --git a/inbox_settings.php b/inbox_settings.php
index c0b2017..3f8b45d 100644
--- a/inbox_settings.php
+++ b/inbox_settings.php
@@ -89,14 +89,14 @@ class inbox_settings extends rcube_plugin {
             $attrib['id'] = 'rcpgpkeyslist';
 
         // info the js needs access to
-        $this->rc->output->add_gui_object('keyslist', $attrib['id']);
-        $this->rc->output->include_script('list.js');
+        $this->rcmail->output->add_gui_object('keyslist', $attrib['id']);
+        $this->rcmail->output->include_script('list.js');
 
-        // $this->rc->output->add_label('inbox_settings.a', 'inbox_settings.b');
+        // $this->rcmail->output->add_label('inbox_settings.a', 'inbox_settings.b');
         
-        $data = [[1, 'DEADBEEF', 'placeholder comment']];
+        $data = run_query('keys', $assoc = true);
 
-        return rcmail_action::table_output($attrib, $data, ['name', 'comment'], 'id');
+        return rcmail_action::table_output($attrib, $data, ['fingerprint', 'comment'], 'id');
     }
 
     function render_settings_ui() {
@@ -192,7 +192,7 @@ class inbox_settings extends rcube_plugin {
         return (new html_inputfield(['type' => 'hidden', 'name' => $name]))->show($value);
     }
 
-    private function run_query($qid, $substitutions = []) {
+    private function run_query($qid, $substitutions = [], $assoc = false) {
         if (!($sql = $this->rcmail->config->get('inbox_settings_' . $qid . '_query'))) {
             $this->rcmail->output->command(
                 'display_message', $this->gettext('no_query'), 'error');
@@ -234,7 +234,7 @@ class inbox_settings extends rcube_plugin {
         }
 
         $ndresult = [];
-        while ($row = $db->fetch_array($result))
+        while ($row = $assoc ? $db->fetch_assoc($result) : $db->fetch_array($result))
             $ndresult[] = $row;
 
         return $ndresult;