OSDN Git Service

getOption() bug fix
authorkmorimatsu <kmorimatsu@1ca29b6e-896d-4ea0-84a5-967f57386b96>
Thu, 7 Dec 2006 03:18:54 +0000 (03:18 +0000)
committerkmorimatsu <kmorimatsu@1ca29b6e-896d-4ea0-84a5-967f57386b96>
Thu, 7 Dec 2006 03:18:54 +0000 (03:18 +0000)
git-svn-id: https://svn.sourceforge.jp/svnroot/nucleus-jp/nucleus-jp/trunk@171 1ca29b6e-896d-4ea0-84a5-967f57386b96

euc/nucleus/libs/PLUGIN.php
utf8/nucleus/libs/PLUGIN.php

index 301a21b..c86975b 100755 (executable)
-<?php  /**\r
-         * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)\r
-         * Copyright (C) 2002-2005 The Nucleus Group\r
-         *\r
-         * This program is free software; you can redistribute it and/or\r
-         * modify it under the terms of the GNU General Public License\r
-         * as published by the Free Software Foundation; either version 2\r
-         * of the License, or (at your option) any later version.\r
-         * (see nucleus/documentation/index.html#license for more info)\r
-         *\r
-         * This is an (abstract) class of which all Nucleus Plugins must inherit\r
-         *\r
-         * for more information on plugins and how to write your own, see the\r
-         * plugins.html file that is included with the Nucleus documenation\r
-         *\r
-         * $Id: PLUGIN.php,v 1.3 2005-03-16 08:10:35 kimitake Exp $\r
-         * $NucleusJP: PLUGIN.php,v 1.3 2005/03/12 06:19:05 kimitake Exp $\r
-         */\r
-       class NucleusPlugin {\r
-\r
-               // these functions _have_ to be redefined in your plugin\r
-\r
-               function getName() { return 'Undefined'; }\r
-               function getAuthor()  { return 'Undefined'; }\r
-               function getURL()  { return 'Undefined'; }\r
-               function getVersion() { return '0.0'; }\r
-               function getDescription() { return 'Undefined';}\r
-\r
-               // these function _may_ be redefined in your plugin\r
-\r
-               function getMinNucleusVersion() { return 150; }\r
-               function getMinNucleusPatchLevel() { return 0; }\r
-               function getEventList() { return array(); }\r
-               function getTableList() { return array(); }\r
-               function hasAdminArea() { return 0; }\r
-\r
-               function install() {}\r
-               function unInstall() {}\r
-\r
-               function init() {}\r
-\r
-               function doSkinVar($skinType) {}\r
-               function doTemplateVar(&$item) {\r
-                       $args = func_get_args();\r
-                       array_shift($args);\r
-                       array_unshift($args, 'template');\r
-                       call_user_func_array(array(&$this,'doSkinVar'),$args);\r
-               }\r
-               function doTemplateCommentsVar(&$item, &$comment) {\r
-                       $args = func_get_args();\r
-                       array_shift($args);\r
-                       array_shift($args);\r
-                       array_unshift($args, 'template');\r
-                       call_user_func_array(array(&$this,'doSkinVar'),$args);\r
-               }\r
-               function doAction($type) { return 'No Such Action'; }\r
-\r
-               /**\r
-                * Checks if a plugin supports a certain feature.\r
-                *\r
-                * @returns 1 if the feature is reported, 0 if not\r
-                * @param $feature\r
-                *              Name of the feature. See plugin documentation for more info\r
-                *                      'SqlTablePrefix' -> if the plugin uses the sql_table() method to get table names\r
-                *                      'HelpPage' -> if the plugin provides a helppage\r
-                */\r
-               function supportsFeature($feature) {\r
-                       return 0;\r
-               }\r
-\r
-               /**\r
-                * Report a list of plugin that is required to function\r
-                * \r
-                * @returns an array of names of plugin, an empty array indicates no dependency\r
-                */\r
-               function getPluginDep() { return array(); }\r
-\r
-               // these helper functions should not be redefined in your plugin\r
-\r
-               /**\r
-                 * Creates a new option for this plugin\r
-                 *\r
-                 * @param name\r
-                 *             A string uniquely identifying your option. (max. length is 20 characters)\r
-                 * @param description\r
-                 *             A description that will show up in the nucleus admin area (max. length: 255 characters)\r
-                 * @param type\r
-                 *             Either 'text', 'yesno' or 'password'\r
-                 *             This info is used when showing 'edit plugin options' screens\r
-                 * @param value\r
-                 *             Initial value for the option (max. value length is 128 characters)\r
-                 */\r
-               function createOption($name, $desc, $type, $defValue = '', $typeExtras = '') {\r
-                       return $this->_createOption('global', $name, $desc, $type, $defValue, $typeExtras);\r
-               }\r
-               function createBlogOption($name, $desc, $type, $defValue = '', $typeExtras = '') {\r
-                       return $this->_createOption('blog', $name, $desc, $type, $defValue, $typeExtras);\r
-               }\r
-               function createMemberOption($name, $desc, $type, $defValue = '', $typeExtras = '') {\r
-                       return $this->_createOption('member', $name, $desc, $type, $defValue, $typeExtras);\r
-               }\r
-               function createCategoryOption($name, $desc, $type, $defValue = '', $typeExtras = '') {\r
-                       return $this->_createOption('category', $name, $desc, $type, $defValue, $typeExtras);\r
-               }\r
-        function createItemOption($name, $desc, $type, $defValue = '', $typeExtras = '') {\r
-                       return $this->_createOption('item', $name, $desc, $type, $defValue, $typeExtras);\r
-               }\r
-\r
-               /**\r
-                 * Removes the option from the database\r
-                 *\r
-                 * Note: Options get erased automatically on plugin uninstall\r
-                 */\r
-               function deleteOption($name) {\r
-                       return $this->_deleteOption('global', $name);\r
-               }\r
-               function deleteBlogOption($name) {\r
-                       return $this->_deleteOption('blog', $name);\r
-               }\r
-               function deleteMemberOption($name) {\r
-                       return $this->_deleteOption('member', $name);\r
-               }\r
-               function deleteCategoryOption($name) {\r
-                       return $this->_deleteOption('category', $name);\r
-               }\r
-        function deleteItemOption($name) {\r
-                       return $this->_deleteOption('item', $name);\r
-               }\r
-\r
-               /**\r
-                 * Sets the value of an option to something new\r
-                 */\r
-               function setOption($name, $value) {\r
-                       return $this->_setOption('global', 0, $name, $value);\r
-               }\r
-               function setBlogOption($blogid, $name, $value) {\r
-                       return $this->_setOption('blog', $blogid, $name, $value);\r
-               }\r
-               function setMemberOption($memberid, $name, $value) {\r
-                       return $this->_setOption('member', $memberid, $name, $value);\r
-               }\r
-               function setCategoryOption($catid, $name, $value) {\r
-                       return $this->_setOption('category', $catid, $name, $value);\r
-               }\r
-        function setItemOption($itemid, $name, $value) {\r
-                       return $this->_setOption('item', $itemid, $name, $value);\r
-               }\r
-\r
-               /**\r
-                 * Retrieves the current value for an option\r
-                 */\r
-               function getOption($name)\r
-               {\r
-                       // only request the options the very first time. On subsequent requests\r
-                       // the static collection is used to save SQL queries.\r
-                       if ($this->plugin_options == 0)\r
-                       {\r
-                               $this->plugin_options = array();        \r
-                               $query = mysql_query(\r
-                                        'SELECT d.oname as name, o.ovalue as value '.\r
-                                        'FROM '.\r
-                                        sql_table('plugin_option').' o, '.\r
-                                        sql_table('plugin_option_desc').' d '.\r
-                                        'WHERE d.opid='. intval($this->getID()).' AND d.oid=o.oid'\r
-                               );\r
-                               while ($row = mysql_fetch_object($query))\r
-                                       $this->plugin_options[strtolower($row->name)] = $row->value;\r
-                 }\r
-                 if (isset($this->plugin_options[strtolower($name)]))\r
-                               return $this->plugin_options[strtolower($name)];\r
-                 else\r
-                               return $this->_getOption('global', 0, $name);\r
-               }                 \r
-\r
-               function getBlogOption($blogid, $name) {\r
-                       return $this->_getOption('blog', $blogid, $name);\r
-               }\r
-               function getMemberOption($memberid, $name) {\r
-                       return $this->_getOption('member', $memberid, $name);\r
-               }\r
-               function getCategoryOption($catid, $name) {\r
-                       return $this->_getOption('category', $catid, $name);\r
-               }\r
-        function getItemOption($itemid, $name) {\r
-                       return $this->_getOption('item', $itemid, $name);\r
-               }\r
-\r
-               /**\r
-                * Retrieves an associative array with the option value for each\r
-                * context id\r
-                */\r
-               function getAllBlogOptions($name) {\r
-                       return $this->_getAllOptions('blog', $name);\r
-               }\r
-               function getAllMemberOptions($name) {\r
-                       return $this->_getAllOptions('member', $name);\r
-               }\r
-               function getAllCategoryOptions($name) {\r
-                       return $this->_getAllOptions('category', $name);\r
-               }\r
-        function getAllItemOptions($name) {\r
-                       return $this->_getAllOptions('item', $name);\r
-               }\r
-               \r
-               /**\r
-         * Retrieves an indexed array with the top (or bottom) of an option\r
-                * (delegates to _getOptionTop())\r
-         */\r
-               function getBlogOptionTop($name, $amount = 10, $sort = 'desc') {\r
-                       return $this->_getOptionTop('blog', $name, $amount, $sort);\r
-               }\r
-               function getMemberOptionTop($name, $amount = 10, $sort = 'desc') {\r
-                       return $this->_getOptionTop('member', $name, $amount, $sort);\r
-               }\r
-               function getCategoryOptionTop($name, $amount = 10, $sort = 'desc') {\r
-                       return $this->_getOptionTop('category', $name, $amount, $sort);\r
-               }\r
-               function getItemOptionTop($name, $amount = 10, $sort = 'desc') {\r
-                       return $this->_getOptionTop('item', $name, $amount, $sort);\r
-               }\r
-               \r
-               /**\r
-                * Retrieves an array of the top (or bottom) of an option from a plugin.\r
-                * @author TeRanEX\r
-                * @param  string $context the context for the option: item, blog, member,...\r
-                * @param  string $name    the name of the option\r
-                * @param  int    $amount  how many rows must be returned\r
-                * @param  string $sort    desc or asc\r
-                * @return array           array with both values and contextid's\r
-                * @access private\r
-                */\r
-        function _getOptionTop($context, $name, $amount = 10, $sort = 'desc') {\r
-                       if (($sort != 'desc') && ($sort != 'asc')) {\r
-                               $sort= 'desc';\r
-                       }\r
-\r
-                       $oid = $this->_getOID($context, $name);\r
-\r
-                       // retrieve the data and return\r
-                       $q = 'SELECT otype, oextra FROM '.sql_table('plugin_option_desc').' WHERE oid = '.$oid;\r
-                       $query = mysql_query($q);\r
-\r
-                       $o = mysql_fetch_array($query);\r
-\r
-                       if (($this->optionCanBeNumeric($o['otype'])) && ($o['oextra'] == 'number' )) {\r
-                               $orderby = 'CAST(ovalue AS SIGNED)';\r
-                       } else {\r
-                               $orderby = 'ovalue';\r
-                       }\r
-                       $q = 'SELECT ovalue value, ocontextid id FROM '.sql_table('plugin_option').' WHERE oid = '.$oid.' ORDER BY '.$orderby.' '.$sort.' LIMIT 0,'.$amount;\r
-                       $query = mysql_query($q);\r
-                       \r
-                       // create the array\r
-                       $i = 0;\r
-                       $top = array();\r
-                       while($row = mysql_fetch_array($query)) {\r
-                               $top[$i++] = $row;\r
-                       }\r
-                       \r
-                       // return the array (duh!)\r
-                       return $top;\r
-               }\r
-\r
-               /**\r
-                 * Returns the plugin ID\r
-                 */\r
-               function getID() {\r
-                       return $this->plugid;\r
-               }\r
-\r
-               /**\r
-                 * returns the URL of the admin area for this plugin (in case there's\r
-                 * no such area, the returned information is invalid)\r
-                 */\r
-               function getAdminURL() {\r
-                       global $CONF;\r
-                       return $CONF['PluginURL'] . $this->getShortName() . '/';\r
-               }\r
-\r
-               /**\r
-                 * Returns the directory where the admin directory is located and\r
-                 * where the plugin can maintain his extra files\r
-                 */\r
-               function getDirectory() {\r
-                       global $DIR_PLUGINS;\r
-                       return $DIR_PLUGINS . $this->getShortName() . '/';\r
-               }\r
-\r
-               /**\r
-                 * Derives the short name for the plugin from the classname (all lowercase)\r
-                 */\r
-               function getShortName() {\r
-                       return str_replace('np_','',strtolower(get_class($this)));\r
-               }\r
-\r
-               var $_aOptionValues;    // oid_contextid => value\r
-               var $_aOptionToInfo;    // context_name => array('oid' => ..., 'default' => ...)\r
-               var $plugin_options;    // see getOption()\r
-               var $plugid;                    // plugin id\r
-\r
-\r
-               // constructor. Initializes some internal data\r
-               function NucleusPlugin() {\r
-                       $this->_aOptionValues = array();        // oid_contextid => value\r
-                       $this->_aOptionToInfo = array();        // context_name => array('oid' => ..., 'default' => ...)\r
-                       $this->plugin_options = 0;\r
-               }\r
-\r
-               // private\r
-               function _createOption($context, $name, $desc, $type, $defValue, $typeExtras = '') {\r
-                       // create in plugin_option_desc\r
-                       $query = 'INSERT INTO ' . sql_table('plugin_option_desc')\r
-                              .' (opid, oname, ocontext, odesc, otype, odef, oextra)'\r
-                              .' VALUES ('.intval($this->plugid)\r
-                             .', \''.addslashes($name).'\''\r
-                             .', \''.addslashes($context).'\''\r
-                             .', \''.addslashes($desc).'\''\r
-                             .', \''.addslashes($type).'\''\r
-                             .', \''.addslashes($defValue).'\''\r
-                                        .', \''.addslashes($typeExtras).'\')';\r
-                       sql_query($query);\r
-                       $oid = mysql_insert_id();\r
-\r
-                       $key = $context . '_' . $name;\r
-                       $this->_aOptionToInfo[$key] = array('oid' => $oid, 'default' => $defValue);\r
-                       return 1;\r
-               }\r
-\r
-\r
-               // private\r
-               function _deleteOption($context, $name) {\r
-                       $oid = $this->_getOID($context, $name);\r
-                       if (!$oid) return 0; // no such option\r
-\r
-                       // delete all things from plugin_option\r
-                       sql_query('DELETE FROM ' . sql_table('plugin_option') . ' WHERE oid=' . $oid);\r
-\r
-                       // delete entry from plugin_option_desc\r
-                       sql_query('DELETE FROM ' . sql_table('plugin_option_desc') . ' WHERE oid=' . $oid);\r
-\r
-                       // clear from cache\r
-                       unset($this->_aOptionToInfo[$context . '_' . $name]);\r
-                       $this->_aOptionValues = array();\r
-                       return 1;\r
-               }\r
-\r
-               /**\r
-                * private\r
-                * returns: 1 on success, 0 on failure\r
-                */\r
-               function _setOption($context, $contextid, $name, $value) {\r
-                       global $manager;\r
-\r
-                       $oid = $this->_getOID($context, $name);\r
-                       if (!$oid) return 0;\r
-\r
-                       // check if context id exists\r
-                       switch ($context) {\r
-                               case 'member':\r
-                                       if (!MEMBER::existsID($contextid)) return 0;\r
-                                       break;\r
-                               case 'blog':\r
-                                       if (!$manager->existsBlogID($contextid)) return 0;\r
-                                       break;\r
-                               case 'category':\r
-                                       if (!$manager->existsCategory($contextid)) return 0;\r
-                                       break;\r
-                case 'item':\r
-                    if (!$manager->existsItem($contextid, true, true)) return 0;\r
-                                       break;\r
-                               case 'global':\r
-                                       if ($contextid != 0) return 0;\r
-                                       break;\r
-                       }\r
-\r
-\r
-                       // update plugin_option\r
-                       sql_query('DELETE FROM ' . sql_table('plugin_option') . ' WHERE oid='.intval($oid) . ' and ocontextid='. intval($contextid));\r
-                       sql_query('INSERT INTO ' . sql_table('plugin_option') . ' (ovalue, oid, ocontextid) VALUES (\''.addslashes($value).'\', '. intval($oid) . ', ' . intval($contextid) . ')');\r
-\r
-                       // update cache\r
-                       $this->_aOptionValues[$oid . '_' . $contextid] = $value;\r
-\r
-                       return 1;\r
-               }\r
-\r
-               // private\r
-               function _getOption($context, $contextid, $name) {\r
-                       $oid = $this->_getOID($context, $name);\r
-                       if (!$oid) return '';\r
-\r
-\r
-                       $key = $oid . '_' . $contextid;\r
-\r
-                       if (isset($this->_aOptionValues[$key]))\r
-                               return $this->_aOptionValues[$key];\r
-\r
-                       // get from DB\r
-                       $res = sql_query('SELECT ovalue FROM ' . sql_table('plugin_option') . ' WHERE oid='.intval($oid).' and ocontextid=' . intval($contextid));\r
-\r
-                       if (!$res || (mysql_num_rows($res) == 0)) {\r
-                               $defVal = $this->_getDefVal($context, $name);\r
-                               $this->_aOptionValues[$key] = $defVal;\r
-\r
-                               // fill DB with default value\r
-                               $query = 'INSERT INTO ' . sql_table('plugin_option') . ' (oid,ocontextid,ovalue)'\r
-                                      .' VALUES ('.intval($oid).', '.intval($contextid).', \''.addslashes($defVal).'\')';\r
-                               sql_query($query);\r
-                       }\r
-                       else {\r
-                               $o = mysql_fetch_object($res);\r
-                               $this->_aOptionValues[$key] = $o->ovalue;\r
-                       }\r
-\r
-                       return $this->_aOptionValues[$key];\r
-               }\r
-\r
-               /**\r
-                * Returns assoc array with all values for a given option (one option per\r
-                * possible context id)\r
-                */\r
-               function _getAllOptions($context, $name) {\r
-                       $oid = $this->_getOID($context, $name);\r
-                       if (!$oid) return array();\r
-                       $defVal = $this->_getDefVal($context, $name);\r
-\r
-                       $aOptions = array();\r
-                       switch ($context) {\r
-                               case 'blog':\r
-                                       $r = sql_query('SELECT bnumber as contextid FROM ' . sql_table('blog'));\r
-                                       break;\r
-                               case 'category':\r
-                                       $r = sql_query('SELECT catid as contextid FROM ' . sql_table('category'));\r
-                                       break;\r
-                               case 'member':\r
-                                       $r = sql_query('SELECT mnumber as contextid FROM ' . sql_table('member'));\r
-                                       break;\r
-                       }\r
-                       if ($r) {\r
-                               while ($o = mysql_fetch_object($r))\r
-                                       $aOptions[$o->contextid] = $defVal;\r
-                       }\r
-\r
-                       $res = sql_query('SELECT ocontextid, ovalue FROM ' . sql_table('plugin_option') . ' WHERE oid=' . $oid);\r
-                       while ($o = mysql_fetch_object($res))\r
-                               $aOptions[$o->ocontextid] = $o->ovalue;\r
-\r
-                       return $aOptions;\r
-               }\r
-\r
-               /**\r
-                * Gets the 'option identifier' that corresponds to a given option name.\r
-                * When this method is called for the first time, all the OIDs for the plugin\r
-                * are loaded into memory, to avoid re-doing the same query all over.\r
-                */\r
-               function _getOID($context, $name) {\r
-                       $key = $context . '_' . $name;\r
-                       $info = $this->_aOptionToInfo[$key];\r
-                       if (is_array($info)) return $info['oid'];\r
-\r
-                       // load all OIDs for this plugin from the database\r
-                       $this->_aOptionToInfo = array();\r
-                       $query = 'SELECT oid, oname, ocontext, odef FROM ' . sql_table('plugin_option_desc') . ' WHERE opid=' . intval($this->plugid);\r
-                       $res = sql_query($query);\r
-                       while ($o = mysql_fetch_object($res)) {\r
-                               $k = $o->ocontext . '_' . $o->oname;\r
-                               $this->_aOptionToInfo[$k] = array('oid' => $o->oid, 'default' => $o->odef);\r
-                       }\r
-                       mysql_free_result($res);\r
-\r
-                       return $this->_aOptionToInfo[$key]['oid'];\r
-               }\r
-               function _getDefVal($context, $name) {\r
-                       $key = $context . '_' . $name;\r
-                       $info = $this->_aOptionToInfo[$key];\r
-                       if (is_array($info)) return $info['default'];\r
-               }\r
-\r
-\r
-               /**\r
-                * Deletes all option values for a given context and contextid\r
-                * (used when e.g. a blog, member or category is deleted)\r
-                *\r
-                * (static method)\r
-                */\r
-               function _deleteOptionValues($context, $contextid) {\r
-                       // delete all associated plugin options\r
-                       $aOIDs = array();\r
-                               // find ids\r
-                       $query = 'SELECT oid FROM '.sql_table('plugin_option_desc') . ' WHERE ocontext=\''.addslashes($context).'\'';\r
-                       $res = sql_query($query);\r
-                       while ($o = mysql_fetch_object($res))\r
-                               array_push($aOIDs, $o->oid);\r
-                       mysql_free_result($res);\r
-                               // delete those options. go go go\r
-                       if (count($aOIDs) > 0) {\r
-                               $query = 'DELETE FROM ' . sql_table('plugin_option') . ' WHERE oid in ('.implode(',',$aOIDs).') and ocontextid=' . intval($contextid);\r
-                               sql_query($query);\r
-                       }\r
-               }\r
-\r
-               /**\r
-                * splits the option's typeextra field (at ;'s) to split the meta collection\r
-                * @param string $typeExtra the value of the typeExtra field of an option\r
-                * @return array array of the meta-key/value-pairs\r
-                * @author TeRanEX\r
-                * @static\r
-                */\r
-               function getOptionMeta($typeExtra) {\r
-                       $tmpMeta = explode(';', $typeExtra);\r
-                       $meta = array();\r
-                       for ($i = 0; $i < count($tmpMeta); $i++) {\r
-                               if (($i == 0) && (!strstr($tmpMeta[0], '='))) {\r
-                                       // we have the select-list\r
-                                       $meta['select'] = $tmpMeta[0];\r
-                               } else {\r
-                                       $tmp = explode('=', $tmpMeta[$i]);\r
-                                       $meta[$tmp[0]] = $tmp[1];\r
-                               }\r
-                       }\r
-                       return $meta;\r
-               }\r
-\r
-               /**\r
-                * filters the selectlists out of the meta collection\r
-                * @param string $typeExtra the value of the typeExtra field of an option\r
-                * @return string the selectlist\r
-                * @author TeRanEX\r
-                */\r
-               function getOptionSelectValues($typeExtra) {\r
-                       $meta = NucleusPlugin::getOptionMeta($typeExtra);\r
-                       //the select list must always be the first part\r
-                       return $meta['select'];\r
-               }\r
-               \r
-               /**\r
-                * checks if the eventlist in the database is up-to-date\r
-                * @return bool if it is up-to-date it return true, else false\r
-                * @author TeRanEX\r
-                */\r
-               function subscribtionListIsUptodate() {\r
-                       $res = sql_query('SELECT event FROM '.sql_table('plugin_event').' WHERE pid = '.$this->getID());\r
-                       $ev = array();\r
-                       while($a = mysql_fetch_array($res)) {\r
-                               array_push($ev, $a['event']);\r
-                       }\r
-                       if (count($ev) != count($this->getEventList())) {\r
-                               return false;\r
-                       }\r
-                       $d = array_diff($ev, $this->getEventList());\r
-                       if (count($d) > 0) {\r
-                               // there are differences so the db is not up-to-date\r
-                               return false;\r
-                       }\r
-                       return true;\r
-               }\r
-               \r
-               /**\r
-                * @param $aOptions: array ( 'oid' => array( 'contextid' => 'value'))\r
-                *        (taken from request using requestVar())\r
-                * @param $newContextid: integer (accepts a contextid when it is for a new \r
-                *        contextid there was no id available at the moment of writing the\r
-                *        formcontrols into the page (by ex: itemOptions for new item)\r
-                * @static \r
-                */\r
-               function _applyPluginOptions(&$aOptions, $newContextid = 0) {\r
-                       global $manager;\r
-                       if (!is_array($aOptions)) return;\r
-\r
-                       foreach ($aOptions as $oid => $values) {\r
-\r
-                               // get option type info\r
-                               $query = 'SELECT opid, oname, ocontext, otype, oextra, odef FROM ' . sql_table('plugin_option_desc') . ' WHERE oid=' . intval($oid);\r
-                               $res = sql_query($query);\r
-                               if ($o = mysql_fetch_object($res))\r
-                               {\r
-                                       foreach ($values as $contextid => $value) {\r
-                                               // retreive any metadata\r
-                                               $meta = NucleusPlugin::getOptionMeta($o->oextra);\r
-                                               \r
-                                               // if the option is readonly or hidden it may not be saved\r
-                                               if (($meta['access'] != 'readonly') && ($meta['access'] != 'hidden')) {\r
-                                                       \r
-                                                       $value = undoMagic($value);     // value comes from request\r
-       \r
-                                                       switch($o->otype) {\r
-                                                               case 'yesno':\r
-                                                                       if (($value != 'yes') && ($value != 'no')) $value = 'no';\r
-                                                                       break;\r
-                                                               default:\r
-                                                                       break;\r
-                                                       }\r
-                                                       \r
-                                                       // check the validity of numerical options\r
-                                                       if (($meta['datatype'] == 'numerical') && (!is_numeric($value))) { \r
-                                                               //the option must be numeric, but the it isn't\r
-                                                               //use the default for this option\r
-                                                               $value = $o->odef;\r
-                                                       }\r
-       \r
-                                                       // decide wether we are using the contextid of newContextid\r
-                                                       if ($newContextid != 0) {\r
-                                                               $contextid = $newContextid;\r
-                                                       }\r
-                                                       \r
-                                                       //trigger event PrePluginOptionsUpdate to give the plugin the\r
-                                                       //possibility to change/validate the new value for the option\r
-                                                       $manager->notify('PrePluginOptionsUpdate',array('context' => $o->ocontext, 'plugid' => $o->opid, 'optionname' => $o->oname, 'contextid' => $contextid, 'value' => &$value));\r
-                                                       \r
-                                                       // delete the old value for the option\r
-                                                       sql_query('DELETE FROM '.sql_table('plugin_option').' WHERE oid='.intval($oid).' AND ocontextid='.intval($contextid));\r
-                                                       sql_query('INSERT INTO '.sql_table('plugin_option')." (oid, ocontextid, ovalue) VALUES (".intval($oid).",".intval($contextid).",'" . addslashes($value) . "')");\r
-                                               }\r
-                                       }\r
-                               }\r
-                       }\r
-               }\r
-               \r
-       }\r
-?>\r
+<?php
+       /*
+        * Nucleus: PHP/MySQL Weblog CMS (http://nucleuscms.org/)
+        * Copyright (C) 2002-2006 The Nucleus Group
+        *
+        * This program is free software; you can redistribute it and/or
+        * modify it under the terms of the GNU General Public License
+        * as published by the Free Software Foundation; either version 2
+        * of the License, or (at your option) any later version.
+        * (see nucleus/documentation/index.html#license for more info)
+        */
+       /**
+        * This is an (abstract) class of which all Nucleus Plugins must inherit
+        *
+        * for more information on plugins and how to write your own, see the
+        * plugins.html file that is included with the Nucleus documenation
+        *
+        * @license http://nucleuscms.org/license.txt GNU General Public License
+        * @copyright Copyright (C) 2002-2005 The Nucleus Group
+        * @version $Id: PLUGIN.php,v 1.4 2006-12-07 03:18:54 kmorimatsu Exp $
+        * @version $NucleusJP: PLUGIN.php,v 1.3.2.1 2005/08/23 08:08:38 kimitake Exp $
+        */
+       class NucleusPlugin {
+
+               // these functions _have_ to be redefined in your plugin
+
+               function getName() { return 'Undefined'; }
+               function getAuthor()  { return 'Undefined'; }
+               function getURL()  { return 'Undefined'; }
+               function getVersion() { return '0.0'; }
+               function getDescription() { return 'Undefined';}
+
+               // these function _may_ be redefined in your plugin
+
+               function getMinNucleusVersion() { return 150; }
+               function getMinNucleusPatchLevel() { return 0; }
+               function getEventList() { return array(); }
+               function getTableList() { return array(); }
+               function hasAdminArea() { return 0; }
+
+               function install() {}
+               function unInstall() {}
+
+               function init() {}
+
+               function doSkinVar($skinType) {}
+               function doTemplateVar(&$item) {
+                       $args = func_get_args();
+                       array_shift($args);
+                       array_unshift($args, 'template');
+                       call_user_func_array(array(&$this,'doSkinVar'),$args);
+               }
+               function doTemplateCommentsVar(&$item, &$comment) {
+                       $args = func_get_args();
+                       array_shift($args);
+                       array_shift($args);
+                       array_unshift($args, 'template');
+                       call_user_func_array(array(&$this,'doSkinVar'),$args);
+               }
+               function doAction($type) { return 'No Such Action'; }
+
+               /**
+                * Checks if a plugin supports a certain feature.
+                *
+                * @returns 1 if the feature is reported, 0 if not
+                * @param $feature
+                *              Name of the feature. See plugin documentation for more info
+                *                      'SqlTablePrefix' -> if the plugin uses the sql_table() method to get table names
+                *                      'HelpPage' -> if the plugin provides a helppage
+                */
+               function supportsFeature($feature) {
+                       return 0;
+               }
+
+               /**
+                * Report a list of plugin that is required to function
+                *
+                * @returns an array of names of plugin, an empty array indicates no dependency
+                */
+               function getPluginDep() { return array(); }
+
+               // these helper functions should not be redefined in your plugin
+
+               /**
+                 * Creates a new option for this plugin
+                 *
+                 * @param name
+                 *             A string uniquely identifying your option. (max. length is 20 characters)
+                 * @param description
+                 *             A description that will show up in the nucleus admin area (max. length: 255 characters)
+                 * @param type
+                 *             Either 'text', 'yesno' or 'password'
+                 *             This info is used when showing 'edit plugin options' screens
+                 * @param value
+                 *             Initial value for the option (max. value length is 128 characters)
+                 */
+               function createOption($name, $desc, $type, $defValue = '', $typeExtras = '') {
+                       return $this->_createOption('global', $name, $desc, $type, $defValue, $typeExtras);
+               }
+               function createBlogOption($name, $desc, $type, $defValue = '', $typeExtras = '') {
+                       return $this->_createOption('blog', $name, $desc, $type, $defValue, $typeExtras);
+               }
+               function createMemberOption($name, $desc, $type, $defValue = '', $typeExtras = '') {
+                       return $this->_createOption('member', $name, $desc, $type, $defValue, $typeExtras);
+               }
+               function createCategoryOption($name, $desc, $type, $defValue = '', $typeExtras = '') {
+                       return $this->_createOption('category', $name, $desc, $type, $defValue, $typeExtras);
+               }
+               function createItemOption($name, $desc, $type, $defValue = '', $typeExtras = '') {
+                       return $this->_createOption('item', $name, $desc, $type, $defValue, $typeExtras);
+               }
+
+               /**
+                 * Removes the option from the database
+                 *
+                 * Note: Options get erased automatically on plugin uninstall
+                 */
+               function deleteOption($name) {
+                       return $this->_deleteOption('global', $name);
+               }
+               function deleteBlogOption($name) {
+                       return $this->_deleteOption('blog', $name);
+               }
+               function deleteMemberOption($name) {
+                       return $this->_deleteOption('member', $name);
+               }
+               function deleteCategoryOption($name) {
+                       return $this->_deleteOption('category', $name);
+               }
+               function deleteItemOption($name) {
+                       return $this->_deleteOption('item', $name);
+               }
+
+               /**
+                 * Sets the value of an option to something new
+                 */
+               function setOption($name, $value) {
+                       return $this->_setOption('global', 0, $name, $value);
+               }
+               function setBlogOption($blogid, $name, $value) {
+                       return $this->_setOption('blog', $blogid, $name, $value);
+               }
+               function setMemberOption($memberid, $name, $value) {
+                       return $this->_setOption('member', $memberid, $name, $value);
+               }
+               function setCategoryOption($catid, $name, $value) {
+                       return $this->_setOption('category', $catid, $name, $value);
+               }
+               function setItemOption($itemid, $name, $value) {
+                       return $this->_setOption('item', $itemid, $name, $value);
+               }
+
+               /**
+                 * Retrieves the current value for an option
+                 */
+               function getOption($name) {
+                       return $this->_getOption('global', 0, $name);
+               }
+               function getBlogOption($blogid, $name) {
+                       return $this->_getOption('blog', $blogid, $name);
+               }
+               function getMemberOption($memberid, $name) {
+                       return $this->_getOption('member', $memberid, $name);
+               }
+               function getCategoryOption($catid, $name) {
+                       return $this->_getOption('category', $catid, $name);
+               }
+               function getItemOption($itemid, $name) {
+                       return $this->_getOption('item', $itemid, $name);
+               }
+
+               /**
+                * Retrieves an associative array with the option value for each
+                * context id
+                */
+               function getAllBlogOptions($name) {
+                       return $this->_getAllOptions('blog', $name);
+               }
+               function getAllMemberOptions($name) {
+                       return $this->_getAllOptions('member', $name);
+               }
+               function getAllCategoryOptions($name) {
+                       return $this->_getAllOptions('category', $name);
+               }
+               function getAllItemOptions($name) {
+                       return $this->_getAllOptions('item', $name);
+               }
+
+               /**
+                * Retrieves an indexed array with the top (or bottom) of an option
+                * (delegates to _getOptionTop())
+                */
+               function getBlogOptionTop($name, $amount = 10, $sort = 'desc') {
+                       return $this->_getOptionTop('blog', $name, $amount, $sort);
+               }
+               function getMemberOptionTop($name, $amount = 10, $sort = 'desc') {
+                       return $this->_getOptionTop('member', $name, $amount, $sort);
+               }
+               function getCategoryOptionTop($name, $amount = 10, $sort = 'desc') {
+                       return $this->_getOptionTop('category', $name, $amount, $sort);
+               }
+               function getItemOptionTop($name, $amount = 10, $sort = 'desc') {
+                       return $this->_getOptionTop('item', $name, $amount, $sort);
+               }
+
+               /**
+                * Retrieves an array of the top (or bottom) of an option from a plugin.
+                * @author TeRanEX
+                * @param  string $context the context for the option: item, blog, member,...
+                * @param  string $name    the name of the option
+                * @param  int    $amount  how many rows must be returned
+                * @param  string $sort    desc or asc
+                * @return array           array with both values and contextid's
+                * @access private
+                */
+               function _getOptionTop($context, $name, $amount = 10, $sort = 'desc') {
+                       if (($sort != 'desc') && ($sort != 'asc')) {
+                               $sort= 'desc';
+                       }
+
+                       $oid = $this->_getOID($context, $name);
+
+                       // retrieve the data and return
+                       $q = 'SELECT otype, oextra FROM '.sql_table('plugin_option_desc').' WHERE oid = '.$oid;
+                       $query = mysql_query($q);
+
+                       $o = mysql_fetch_array($query);
+
+                       if (($this->optionCanBeNumeric($o['otype'])) && ($o['oextra'] == 'number' )) {
+                               $orderby = 'CAST(ovalue AS SIGNED)';
+                       } else {
+                               $orderby = 'ovalue';
+                       }
+                       $q = 'SELECT ovalue value, ocontextid id FROM '.sql_table('plugin_option').' WHERE oid = '.$oid.' ORDER BY '.$orderby.' '.$sort.' LIMIT 0,'.$amount;
+                       $query = mysql_query($q);
+
+                       // create the array
+                       $i = 0;
+                       $top = array();
+                       while($row = mysql_fetch_array($query)) {
+                               $top[$i++] = $row;
+                       }
+
+                       // return the array (duh!)
+                       return $top;
+               }
+
+               /**
+                 * Returns the plugin ID
+                 */
+               function getID() {
+                       return $this->plugid;
+               }
+
+               /**
+                 * returns the URL of the admin area for this plugin (in case there's
+                 * no such area, the returned information is invalid)
+                 */
+               function getAdminURL() {
+                       global $CONF;
+                       return $CONF['PluginURL'] . $this->getShortName() . '/';
+               }
+
+               /**
+                 * Returns the directory where the admin directory is located and
+                 * where the plugin can maintain his extra files
+                 */
+               function getDirectory() {
+                       global $DIR_PLUGINS;
+                       return $DIR_PLUGINS . $this->getShortName() . '/';
+               }
+
+               /**
+                 * Derives the short name for the plugin from the classname (all lowercase)
+                 */
+               function getShortName() {
+                       return str_replace('np_','',strtolower(get_class($this)));
+               }
+
+               var $_aOptionValues;    // oid_contextid => value
+               var $_aOptionToInfo;    // context_name => array('oid' => ..., 'default' => ...)
+               var $plugid;                    // plugin id
+
+
+               // constructor. Initializes some internal data
+               function NucleusPlugin() {
+                       $this->_aOptionValues = array();        // oid_contextid => value
+                       $this->_aOptionToInfo = array();        // context_name => array('oid' => ..., 'default' => ...)
+               }
+
+               // private
+               function _createOption($context, $name, $desc, $type, $defValue, $typeExtras = '') {
+                       // create in plugin_option_desc
+                       $query = 'INSERT INTO ' . sql_table('plugin_option_desc')
+                                  .' (opid, oname, ocontext, odesc, otype, odef, oextra)'
+                                  .' VALUES ('.intval($this->plugid)
+                                                        .', \''.addslashes($name).'\''
+                                                        .', \''.addslashes($context).'\''
+                                                        .', \''.addslashes($desc).'\''
+                                                        .', \''.addslashes($type).'\''
+                                                        .', \''.addslashes($defValue).'\''
+                                                        .', \''.addslashes($typeExtras).'\')';
+                       sql_query($query);
+                       $oid = mysql_insert_id();
+
+                       $key = $context . '_' . $name;
+                       $this->_aOptionToInfo[$key] = array('oid' => $oid, 'default' => $defValue);
+                       return 1;
+               }
+
+
+               // private
+               function _deleteOption($context, $name) {
+                       $oid = $this->_getOID($context, $name);
+                       if (!$oid) return 0; // no such option
+
+                       // delete all things from plugin_option
+                       sql_query('DELETE FROM ' . sql_table('plugin_option') . ' WHERE oid=' . $oid);
+
+                       // delete entry from plugin_option_desc
+                       sql_query('DELETE FROM ' . sql_table('plugin_option_desc') . ' WHERE oid=' . $oid);
+
+                       // clear from cache
+                       unset($this->_aOptionToInfo[$context . '_' . $name]);
+                       $this->_aOptionValues = array();
+                       return 1;
+               }
+
+               /**
+                * private
+                * returns: 1 on success, 0 on failure
+                */
+               function _setOption($context, $contextid, $name, $value) {
+                       global $manager;
+
+                       $oid = $this->_getOID($context, $name);
+                       if (!$oid) return 0;
+
+                       // check if context id exists
+                       switch ($context) {
+                               case 'member':
+                                       if (!MEMBER::existsID($contextid)) return 0;
+                                       break;
+                               case 'blog':
+                                       if (!$manager->existsBlogID($contextid)) return 0;
+                                       break;
+                               case 'category':
+                                       if (!$manager->existsCategory($contextid)) return 0;
+                                       break;
+                               case 'item':
+                                       if (!$manager->existsItem($contextid, true, true)) return 0;
+                                       break;
+                               case 'global':
+                                       if ($contextid != 0) return 0;
+                                       break;
+                       }
+
+
+                       // update plugin_option
+                       sql_query('DELETE FROM ' . sql_table('plugin_option') . ' WHERE oid='.intval($oid) . ' and ocontextid='. intval($contextid));
+                       sql_query('INSERT INTO ' . sql_table('plugin_option') . ' (ovalue, oid, ocontextid) VALUES (\''.addslashes($value).'\', '. intval($oid) . ', ' . intval($contextid) . ')');
+
+                       // update cache
+                       $this->_aOptionValues[$oid . '_' . $contextid] = $value;
+
+                       return 1;
+               }
+
+               // private
+               function _getOption($context, $contextid, $name) {
+                       $oid = $this->_getOID($context, $name);
+                       if (!$oid) return '';
+
+
+                       $key = $oid . '_' . $contextid;
+
+                       if (isset($this->_aOptionValues[$key]))
+                               return $this->_aOptionValues[$key];
+
+                       // get from DB
+                       $res = sql_query('SELECT ovalue FROM ' . sql_table('plugin_option') . ' WHERE oid='.intval($oid).' and ocontextid=' . intval($contextid));
+
+                       if (!$res || (mysql_num_rows($res) == 0)) {
+                               $defVal = $this->_getDefVal($context, $name);
+                               $this->_aOptionValues[$key] = $defVal;
+
+                               // fill DB with default value
+                               $query = 'INSERT INTO ' . sql_table('plugin_option') . ' (oid,ocontextid,ovalue)'
+                                          .' VALUES ('.intval($oid).', '.intval($contextid).', \''.addslashes($defVal).'\')';
+                               sql_query($query);
+                       }
+                       else {
+                               $o = mysql_fetch_object($res);
+                               $this->_aOptionValues[$key] = $o->ovalue;
+                       }
+
+                       return $this->_aOptionValues[$key];
+               }
+
+               /**
+                * Returns assoc array with all values for a given option (one option per
+                * possible context id)
+                */
+               function _getAllOptions($context, $name) {
+                       $oid = $this->_getOID($context, $name);
+                       if (!$oid) return array();
+                       $defVal = $this->_getDefVal($context, $name);
+
+                       $aOptions = array();
+                       switch ($context) {
+                               case 'blog':
+                                       $r = sql_query('SELECT bnumber as contextid FROM ' . sql_table('blog'));
+                                       break;
+                               case 'category':
+                                       $r = sql_query('SELECT catid as contextid FROM ' . sql_table('category'));
+                                       break;
+                               case 'member':
+                                       $r = sql_query('SELECT mnumber as contextid FROM ' . sql_table('member'));
+                                       break;
+                       }
+                       if ($r) {
+                               while ($o = mysql_fetch_object($r))
+                                       $aOptions[$o->contextid] = $defVal;
+                       }
+
+                       $res = sql_query('SELECT ocontextid, ovalue FROM ' . sql_table('plugin_option') . ' WHERE oid=' . $oid);
+                       while ($o = mysql_fetch_object($res))
+                               $aOptions[$o->ocontextid] = $o->ovalue;
+
+                       return $aOptions;
+               }
+
+               /**
+                * Gets the 'option identifier' that corresponds to a given option name.
+                * When this method is called for the first time, all the OIDs for the plugin
+                * are loaded into memory, to avoid re-doing the same query all over.
+                */
+               function _getOID($context, $name) {
+                       $key = $context . '_' . $name;
+                       $info = $this->_aOptionToInfo[$key];
+                       if (is_array($info)) return $info['oid'];
+
+                       // load all OIDs for this plugin from the database
+                       $this->_aOptionToInfo = array();
+                       $query = 'SELECT oid, oname, ocontext, odef FROM ' . sql_table('plugin_option_desc') . ' WHERE opid=' . intval($this->plugid);
+                       $res = sql_query($query);
+                       while ($o = mysql_fetch_object($res)) {
+                               $k = $o->ocontext . '_' . $o->oname;
+                               $this->_aOptionToInfo[$k] = array('oid' => $o->oid, 'default' => $o->odef);
+                       }
+                       mysql_free_result($res);
+
+                       return $this->_aOptionToInfo[$key]['oid'];
+               }
+               function _getDefVal($context, $name) {
+                       $key = $context . '_' . $name;
+                       $info = $this->_aOptionToInfo[$key];
+                       if (is_array($info)) return $info['default'];
+               }
+
+
+               /**
+                * Deletes all option values for a given context and contextid
+                * (used when e.g. a blog, member or category is deleted)
+                *
+                * (static method)
+                */
+               function _deleteOptionValues($context, $contextid) {
+                       // delete all associated plugin options
+                       $aOIDs = array();
+                               // find ids
+                       $query = 'SELECT oid FROM '.sql_table('plugin_option_desc') . ' WHERE ocontext=\''.addslashes($context).'\'';
+                       $res = sql_query($query);
+                       while ($o = mysql_fetch_object($res))
+                               array_push($aOIDs, $o->oid);
+                       mysql_free_result($res);
+                               // delete those options. go go go
+                       if (count($aOIDs) > 0) {
+                               $query = 'DELETE FROM ' . sql_table('plugin_option') . ' WHERE oid in ('.implode(',',$aOIDs).') and ocontextid=' . intval($contextid);
+                               sql_query($query);
+                       }
+               }
+
+               /**
+                * splits the option's typeextra field (at ;'s) to split the meta collection
+                * @param string $typeExtra the value of the typeExtra field of an option
+                * @return array array of the meta-key/value-pairs
+                * @author TeRanEX
+                * @static
+                */
+               function getOptionMeta($typeExtra) {
+                       $tmpMeta = explode(';', $typeExtra);
+                       $meta = array();
+                       for ($i = 0; $i < count($tmpMeta); $i++) {
+                               if (($i == 0) && (!strstr($tmpMeta[0], '='))) {
+                                       // we have the select-list
+                                       $meta['select'] = $tmpMeta[0];
+                               } else {
+                                       $tmp = explode('=', $tmpMeta[$i]);
+                                       $meta[$tmp[0]] = $tmp[1];
+                               }
+                       }
+                       return $meta;
+               }
+
+               /**
+                * filters the selectlists out of the meta collection
+                * @param string $typeExtra the value of the typeExtra field of an option
+                * @return string the selectlist
+                * @author TeRanEX
+                */
+               function getOptionSelectValues($typeExtra) {
+                       $meta = NucleusPlugin::getOptionMeta($typeExtra);
+                       //the select list must always be the first part
+                       return $meta['select'];
+               }
+
+               /**
+                * checks if the eventlist in the database is up-to-date
+                * @return bool if it is up-to-date it return true, else false
+                * @author TeRanEX
+                */
+               function subscribtionListIsUptodate() {
+                       $res = sql_query('SELECT event FROM '.sql_table('plugin_event').' WHERE pid = '.$this->getID());
+                       $ev = array();
+                       while($a = mysql_fetch_array($res)) {
+                               array_push($ev, $a['event']);
+                       }
+                       if (count($ev) != count($this->getEventList())) {
+                               return false;
+                       }
+                       $d = array_diff($ev, $this->getEventList());
+                       if (count($d) > 0) {
+                               // there are differences so the db is not up-to-date
+                               return false;
+                       }
+                       return true;
+               }
+
+               /**
+                * @param $aOptions: array ( 'oid' => array( 'contextid' => 'value'))
+                *        (taken from request using requestVar())
+                * @param $newContextid: integer (accepts a contextid when it is for a new
+                *        contextid there was no id available at the moment of writing the
+                *        formcontrols into the page (by ex: itemOptions for new item)
+                * @static
+                */
+               function _applyPluginOptions(&$aOptions, $newContextid = 0) {
+                       global $manager;
+                       if (!is_array($aOptions)) return;
+
+                       foreach ($aOptions as $oid => $values) {
+
+                               // get option type info
+                               $query = 'SELECT opid, oname, ocontext, otype, oextra, odef FROM ' . sql_table('plugin_option_desc') . ' WHERE oid=' . intval($oid);
+                               $res = sql_query($query);
+                               if ($o = mysql_fetch_object($res))
+                               {
+                                       foreach ($values as $contextid => $value) {
+                                               // retreive any metadata
+                                               $meta = NucleusPlugin::getOptionMeta($o->oextra);
+
+                                               // if the option is readonly or hidden it may not be saved
+                                               if (($meta['access'] != 'readonly') && ($meta['access'] != 'hidden')) {
+
+                                                       $value = undoMagic($value);     // value comes from request
+
+                                                       switch($o->otype) {
+                                                               case 'yesno':
+                                                                       if (($value != 'yes') && ($value != 'no')) $value = 'no';
+                                                                       break;
+                                                               default:
+                                                                       break;
+                                                       }
+
+                                                       // check the validity of numerical options
+                                                       if (($meta['datatype'] == 'numerical') && (!is_numeric($value))) {
+                                                               //the option must be numeric, but the it isn't
+                                                               //use the default for this option
+                                                               $value = $o->odef;
+                                                       }
+
+                                                       // decide wether we are using the contextid of newContextid
+                                                       if ($newContextid != 0) {
+                                                               $contextid = $newContextid;
+                                                       }
+
+                                                       //trigger event PrePluginOptionsUpdate to give the plugin the
+                                                       //possibility to change/validate the new value for the option
+                                                       $manager->notify('PrePluginOptionsUpdate',array('context' => $o->ocontext, 'plugid' => $o->opid, 'optionname' => $o->oname, 'contextid' => $contextid, 'value' => &$value));
+
+                                                       // delete the old value for the option
+                                                       sql_query('DELETE FROM '.sql_table('plugin_option').' WHERE oid='.intval($oid).' AND ocontextid='.intval($contextid));
+                                                       sql_query('INSERT INTO '.sql_table('plugin_option')." (oid, ocontextid, ovalue) VALUES (".intval($oid).",".intval($contextid).",'" . addslashes($value) . "')");
+                                               }
+                                       }
+                               }
+                       }
+               }
+
+       }
+?>
index 0511ebf..416048a 100755 (executable)
@@ -17,8 +17,8 @@
         *
         * @license http://nucleuscms.org/license.txt GNU General Public License
         * @copyright Copyright (C) 2002-2006 The Nucleus Group
-        * @version $Id: PLUGIN.php,v 1.5 2006-07-12 07:11:47 kimitake Exp $
-        * $NucleusJP: PLUGIN.php,v 1.4 2005/08/13 07:33:02 kimitake Exp $
+        * @version $Id: PLUGIN.php,v 1.6 2006-12-07 03:18:33 kmorimatsu Exp $
+        * $NucleusJP: PLUGIN.php,v 1.5 2006/07/12 07:11:47 kimitake Exp $
         */
        class NucleusPlugin {
 
                /**
                  * Retrieves the current value for an option
                  */
-               function getOption($name)
-               {
-                       // only request the options the very first time. On subsequent requests
-                       // the static collection is used to save SQL queries.
-                       if ($this->plugin_options == 0)
-                       {
-                               $this->plugin_options = array();
-                               $query = mysql_query(
-                                        'SELECT d.oname as name, o.ovalue as value '.
-                                        'FROM '.
-                                        sql_table('plugin_option').' o, '.
-                                        sql_table('plugin_option_desc').' d '.
-                                        'WHERE d.opid='. intval($this->getID()).' AND d.oid=o.oid'
-                               );
-                               while ($row = mysql_fetch_object($query))
-                                       $this->plugin_options[strtolower($row->name)] = $row->value;
-                 }
-                 if (isset($this->plugin_options[strtolower($name)]))
-                               return $this->plugin_options[strtolower($name)];
-                 else
-                               return $this->_getOption('global', 0, $name);
+               function getOption($name) {
+                       return $this->_getOption('global', 0, $name);
                }
-
                function getBlogOption($blogid, $name) {
                        return $this->_getOption('blog', $blogid, $name);
                }
 
                var $_aOptionValues;    // oid_contextid => value
                var $_aOptionToInfo;    // context_name => array('oid' => ..., 'default' => ...)
-               var $plugin_options;    // see getOption()
                var $plugid;                    // plugin id
 
 
                function NucleusPlugin() {
                        $this->_aOptionValues = array();        // oid_contextid => value
                        $this->_aOptionToInfo = array();        // context_name => array('oid' => ..., 'default' => ...)
-                       $this->plugin_options = 0;
                }
 
                // private