2 /* vim: set expandtab sw=4 ts=4 sts=4: */
11 require_once 'libraries/common.inc.php';
16 $response = PMA_Response
::getInstance();
17 $header = $response->getHeader();
18 $scripts = $header->getScripts();
19 $scripts->addFile('jquery/jquery.tablesorter.js');
20 $scripts->addFile('server_plugins.js');
23 * Does the common work
25 require 'libraries/server_common.inc.php';
26 require 'libraries/server_plugins.lib.php';
31 $sql = "SELECT p.plugin_name, p.plugin_type, p.is_active, m.module_name, m.module_library,
32 m.module_version, m.module_author, m.module_description, m.module_license
33 FROM data_dictionary.plugins p
34 JOIN data_dictionary.modules m USING (module_name)
35 ORDER BY m.module_name, p.plugin_type, p.plugin_name";
36 $res = $GLOBALS['dbi']->query($sql);
39 while ($row = $GLOBALS['dbi']->fetchAssoc($res)) {
40 $plugins[$row['plugin_type']][] = $row;
41 $modules[$row['module_name']]['info'] = $row;
42 $modules[$row['module_name']]['plugins'][$row['plugin_type']][] = $row;
44 $GLOBALS['dbi']->freeResult($res);
46 // sort plugin list (modules are already sorted)
52 $response->addHTML(PMA_getSubPageHeader('plugins'));
53 $response->addHTML(PMA_getPluginAndModuleInfo($plugins, $modules));