From f7ecfa21088175bc236b1136c1a4b2aa2488f37c Mon Sep 17 00:00:00 2001
From: Christian Weiske <cweiske@cweiske.de>
Date: Fri, 22 Aug 2014 17:17:01 +0200
Subject: show some statistics on the index page

---
 lib/tokenstorage.php | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

(limited to 'lib/tokenstorage.php')

diff --git a/lib/tokenstorage.php b/lib/tokenstorage.php
index 9a173f5..f8f0806 100644
--- a/lib/tokenstorage.php
+++ b/lib/tokenstorage.php
@@ -106,6 +106,30 @@ class TokenStorage
         return $token;
     }
 
+    /**
+     * Load multiple tokens
+     *
+     * @param string $username User name
+     * @param string $type     Token type: temp, access, verify
+     *
+     * @return array Array of Token objects
+     */
+    public function loadForUser($username, $type)
+    {
+        $result = \OC_DB::executeAudited(
+            'SELECT * FROM `*PREFIX*grauphel_oauth_tokens`'
+            . ' WHERE `token_user` = ? AND `token_type` = ?',
+            array($username, $type)
+        );
+
+        $tokens = array();
+        while ($tokenRow = $result->fetchRow()) {
+            $tokens[] = $this->fromDb($tokenRow);
+        }
+
+        return $tokens;
+    }
+
     protected function fromDb($tokenRow)
     {
         $token = new Token();
-- 
cgit v1.2.3