2 /* vim: set expandtab sw=4 ts=4 sts=4: */
4 * Functionality for the navigation tree
6 * @package PhpMyAdmin-Navigation
8 if (! defined('PHPMYADMIN')) {
13 * Represents a procedure node in the navigation tree
15 * @package PhpMyAdmin-Navigation
17 class Node_Procedure
extends Node
20 * Initialises the class
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
27 * @return Node_Procedure
29 public function __construct($name, $type = Node
::OBJECT, $is_group = false)
31 parent
::__construct($name, $type, $is_group);
32 $this->icon
= PMA_Util
::getImage('b_routines.png');
34 'text' => 'db_routines.php?server=' . $GLOBALS['server']
35 . '&db=%2$s&item_name=%1$s&item_type=PROCEDURE'
36 . '&edit_item=1&token=' . $GLOBALS['token'],
37 'icon' => 'db_routines.php?server=' . $GLOBALS['server']
38 . '&db=%2$s&item_name=%1$s&item_type=PROCEDURE'
39 . '&export_item=1&token=' . $GLOBALS['token']
41 $this->classes
= 'procedure';
45 * Returns the comment associated with node
46 * This method should be overridden by specific type of nodes
50 public function getComment()
52 $db = PMA_Util
::sqlAddSlashes(
53 $this->realParent()->real_name
55 $routine = PMA_Util
::sqlAddSlashes(
58 $query = "SELECT `ROUTINE_COMMENT` ";
59 $query .= "FROM `INFORMATION_SCHEMA`.`ROUTINES` ";
60 $query .= "WHERE `ROUTINE_SCHEMA`='$db' ";
61 $query .= "AND `ROUTINE_NAME`='$routine' ";
62 $query .= "AND `ROUTINE_TYPE`='PROCEDURE' ";
63 return PMA_DBI_fetch_value($query);