server_plugins.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  *
   5  * @package PhpMyAdmin
   6  */
   7
   8 /**
   9  * requirements
  10  */
  11 require_once 'libraries/common.inc.php';
  12
  13 /**
  14  * JS includes
  15  */
  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');
  21
  22 /**
  23  * Does the common work
  24  */
  25 require 'libraries/server_common.inc.php';
  26 require 'libraries/server_plugins.lib.php';
  27
  28 /**
  29  * Prepare plugin list
  30  */
  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);
  37 $plugins = array();
  38 $modules = array();
  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;
  43 }
  44 $GLOBALS['dbi']->freeResult($res);
  45
  46 // sort plugin list (modules are already sorted)
  47 ksort($plugins);
  48
  49 /**
  50  * Displays the page
  51  */
  52 $response->addHTML(PMA_getSubPageHeader('plugins'));
  53 $response->addHTML(PMA_getPluginAndModuleInfo($plugins, $modules));
  54
  55 exit;
  56
  57 ?>