php-blog-cvs

[Tom S. <tom...@us...>]

Update of /cvsroot/php-blog/serendipity/include
In directory sc8-pr-cvs1.sourceforge.net:/tmp/cvs-serv31998/include

Modified Files:
      Tag: branch-smarty
	plugin_api.inc.php 
Log Message:
- Cache requests for plugin ownership, nuking *a lot* of queries


Index: plugin_api.inc.php
===================================================================
RCS file: /cvsroot/php-blog/serendipity/include/Attic/plugin_api.inc.php,v
retrieving revision 1.1.2.2
retrieving revision 1.1.2.3
diff -u -d -r1.1.2.2 -r1.1.2.3
--- plugin_api.inc.php	16 Nov 2004 14:55:18 -0000	1.1.2.2
+++ plugin_api.inc.php	18 Nov 2004 22:28:58 -0000	1.1.2.3
@@ -267,6 +267,27 @@
         return 0;
     }
 
+    function get_plugin_owner($instance_id)
+    {
+        global $serendipity;
+        static $cache;
+
+        if ( isset($cache[$instance_id]) ) {
+            return $cache[$instance_id];
+        }
+
+        $sql = "SELECT name, authorid from {$serendipity['dbPrefix']}plugins";
+        $data = serendipity_db_query($sql);
+
+        $cache = array();
+        foreach ( $data as $rs ) {
+            $cache[$rs['name']] = $rs['authorid'];
+        }
+
+        return $cache[$instance_id];
+    }
+
+
     /* Creates an instance of a named plugin */
     function &load_plugin($instance_id, $authorid = null)
     {
@@ -299,9 +320,7 @@
         if (!is_null($authorid)) {
             $p->serendipity_owner = $authorid;
         } else {
-            $sql = "SELECT authorid from {$serendipity['dbPrefix']}plugins WHERE name = '" . $instance_id . "'";
-            $owner = serendipity_db_query($sql, true);
-            $p->serendipity_owner = $owner[0];
+            $p->serendipity_owner = serendipity_plugin_api::get_plugin_owner($instance_id);
         }
 
         return $p;