phpmyadmin/libraries/navigation/Nodes/Node_Event.class.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Functionality for the navigation tree
   5  *
   6  * @package PhpMyAdmin-Navigation
   7  */
   8 if (! defined('PHPMYADMIN')) {
   9     exit;
  10 }
  11
  12 /**
  13  * Represents a event node in the navigation tree
  14  *
  15  * @package PhpMyAdmin-Navigation
  16  */
  17 class Node_Event extends Node
  18 {
  19     /**
  20      * Initialises the class
  21      *
  22      * @param string $name     An identifier for the new node
  23      * @param int    $type     Type of node, may be one of CONTAINER or OBJECT
  24      * @param bool   $is_group Whether this object has been created
  25      *                         while grouping nodes
  26      *
  27      * @return Node_Event
  28      */
  29     public function __construct($name, $type = Node::OBJECT, $is_group = false)
  30     {
  31         parent::__construct($name, $type, $is_group);
  32         $this->icon  = PMA_Util::getImage('b_events.png');
  33         $this->links = array(
  34             'text' => 'db_events.php?server=' . $GLOBALS['server']
  35                     . '&amp;db=%2$s&amp;item_name=%1$s&amp;edit_item=1'
  36                     . '&amp;token=' . $GLOBALS['token'],
  37             'icon' => 'db_events.php?server=' . $GLOBALS['server']
  38                     . '&amp;db=%2$s&amp;item_name=%1$s&amp;export_item=1'
  39                     . '&amp;token=' . $GLOBALS['token']
  40         );
  41         $this->classes = 'event';
  42     }
  43
  44     /**
  45      * Returns the comment associated with node
  46      * This method should be overridden by specific type of nodes
  47      *
  48      * @return string
  49      */
  50     public function getComment()
  51     {
  52         $db    = PMA_Util::sqlAddSlashes(
  53             $this->realParent()->real_name
  54         );
  55         $event = PMA_Util::sqlAddSlashes(
  56             $this->real_name
  57         );
  58         $query  = "SELECT `EVENT_COMMENT` ";
  59         $query .= "FROM `INFORMATION_SCHEMA`.`EVENTS` ";
  60         $query .= "WHERE `EVENT_SCHEMA`='$db' ";
  61         $query .= "AND `EVENT_NAME`='$event' ";
  62         return PMA_DBI_fetch_value($query);
  63     }
  64 }
  65
  66 ?>