Pelzini

source of /viewer/controllers/table.php

Displays information about the usage of a specific database table

<?php
/*
Copyright 2008 Josh Heidenreich
 
This file is part of Pelzini.
 
Pelzini 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 3 of the License, or
(at your option) any later version.
 
Pelzini is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
GNU General Public License for more details.
 
You should have received a copy of the GNU General Public License
along with Pelzini.  If not, see <http://www.gnu.org/licenses/>.
*/
 
/**
 * Displays information about the usage of a specific database table
 *
 * @package Viewer
 * @author Josh Heidenreich
 * @since 0.2
 * @see viewer/tables_list.php
 * @tag i18n-done
 **/
 
require_once 'functions.php';
 
$_GET['name'] = trim($_GET['name']);
if ($_GET['name'] == '') {
    require_once 'head.php';
    echo "Invalid table specified";
    require_once 'foot.php';
}
 
$name_sql = db_quote ($_GET['name']);
 
$skin['page_name'] = str(STR_TABLE_PAGE_TITLE, 'name', $_GET['name']);
require_once 'head.php';
 
echo '<h2>', str(STR_TABLE_TITLE, 'name', $_GET['name']), '</h2>';
 
 
// Show files
$q = "SELECT files.id, files.name, item_tables.action, item_tables.description
  FROM files
  INNER JOIN item_tables ON item_tables.linktype = " . LINK_TYPE_FILE . " AND item_tables.linkid = files.id
  WHERE item_tables.name = {$name_sql}
  ORDER BY files.name";
$res = db_query ($q);
if (db_num_rows($res) > 0) {
    echo '<h3>', str(STR_FILES), '</h3>';
 
    $alt = false;
    echo '<div class="list">';
    while ($row = db_fetch_assoc ($res)) {
        $class = 'item';
        if ($alt) $class .= '-alt';
 
        // output
        echo "<div class=\"{$class}\">";
        echo "<p><i>{$row['action']}</i> <strong>", get_file_link($row['name']), "</strong></p>";
        echo delink_inline($row['description']);
        echo '</div>';
 
        $file_ids[] = $row['id'];
        $alt = ! $alt;
    }
    echo '</div>';
}
 
 
// Show classes
$q = "SELECT classes.id, classes.name, item_tables.action, item_tables.description
  FROM classes
  INNER JOIN item_tables ON item_tables.linktype = " . LINK_TYPE_CLASS . " AND item_tables.linkid = classes.id
  WHERE item_tables.name = {$name_sql}
  ORDER BY classes.name";
$res = db_query($q);
if (db_num_rows($res) > 0) {
    echo '<a name="classes"></a>';
    echo '<h3>', str(STR_CLASSES), '</h3>';
 
    $alt = false;
    echo '<div class="list">';
    while ($row = db_fetch_assoc ($res)) {
        $class = 'item';
        if ($alt) $class .= '-alt';
 
        echo "<div class=\"{$class}\">";
        echo "<p><i>{$row['action']}</i> <strong>", get_class_link($row['name']), "</strong></p>";
        echo delink_inline($row['description']);
        echo '</div>';
 
        $alt = ! $alt;
    }
    echo '</div>';
}
 
 
// Show functions
$q = "SELECT functions.id, functions.name, item_tables.action, item_tables.description
  FROM functions
  INNER JOIN item_tables ON item_tables.linktype = " . LINK_TYPE_FUNCTION . " AND item_tables.linkid = functions.id
  WHERE item_tables.name = {$name_sql}
  ORDER BY functions.name";
$res = db_query($q);
if (db_num_rows($res) > 0) {
    echo '<a name="functions"></a>';
    echo '<h3>', str(STR_FUNCTIONS), '</h3>';
 
    $alt = false;
    echo '<div class="list">';
    while ($row = db_fetch_assoc ($res)) {
        $class = 'item';
        if ($alt) $class .= '-alt';
 
        // display the function
        echo "<div class=\"{$class}\">";
        echo "<p><i>{$row['action']}</i> <strong>", get_function_link(null, $row['name']), "</strong> </p>";
        echo delink_inline($row['description']);
        echo "</div>";
 
        $alt = ! $alt;
    }
    echo '</div>';
}
 
 
require_once 'foot.php';
?>