mambax7 / gwiki

admin/attachments.php

<?php

use Xmf\Request;

/**
 * admin/attachments.php - file attachment review tool
 *
 * @copyright  Copyright © 2013 geekwright, LLC. All rights reserved.
 * @license    gwiki/docs/license.txt  GNU General Public License (GPL)
 * @since      1.0
 * @author     Richard Griffith <richard@geekwright.com>
 * @package    gwiki
 */
include __DIR__ . '/header.php';
//include_once dirname(__DIR__) . '/include/functions.php';

$moduleAdmin->displayNavigation(basename(__FILE__));

function showAttachments()
{
    global $xoopsDB, $wikiPage;
    $dir = basename(dirname(__DIR__));
    /*
    gwiki_page_files
      file_id int(10) NOT NULL AUTO_INCREMENT,
      keyword varchar(128) NOT NULL DEFAULT '',
      file_name varchar(128) NOT NULL DEFAULT '',
      file_path varchar(255) NOT NULL DEFAULT '',
      file_type varchar(128) NOT NULL DEFAULT '',
      file_icon varchar(64) NOT NULL DEFAULT '',
      file_size int(10) NOT NULL DEFAULT '0',
      file_upload_date int(10) NOT NULL DEFAULT '0',
      file_description text,
      file_uid int(10) NOT NULL DEFAULT '0',
    */
    $kw = Request::getString('kw', '', 'get');
    $fn = Request::getString('fn', '', 'get');;
    $ty = Request::getString('ty', '', 'get');;
    $ds = Request::getString('ds', '', 'get');;

    $q_kw = '%' . $wikiPage->escapeForDB($kw) . '%';
    $q_fn = '%' . $wikiPage->escapeForDB($fn) . '%';
    $q_ty = '%' . $wikiPage->escapeForDB($ty) . '%';
    $q_ds = '%' . $wikiPage->escapeForDB($ds) . '%';

    $likeclause = '';
    if (!empty($kw)) {
        $likeclause .= (empty($likeclause) ? '' : ' and ') . " keyword like '{$q_kw}' ";
    }
    if (!empty($fn)) {
        $likeclause .= (empty($likeclause) ? '' : ' and ') . " file_name like '{$q_fn}' ";
    }
    if (!empty($ty)) {
        $likeclause .= (empty($likeclause) ? '' : ' and ') . " file_type like '{$q_ty}' ";
    }
    if (!empty($ds)) {
        $likeclause .= (empty($likeclause) ? '' : ' and ') . " file_description like '{$q_ds}' ";
    }
    //$whereclause=(empty($likeclause)?'':' where '.$likeclause);
    $whereclause = (empty($likeclause) ? '' : " where {$likeclause}");

    echo <<<EOT
<style>
div.pagination.default {display:inline;}
form {display:inline;}
</style>
EOT;
    $total = 0;
    $limit = 10;
    $start = 0;
    if (!empty($_GET['start'])) {
        $start = (int)$_GET['start'];
    }

    $sql    = 'SELECT count(*) FROM ' . $xoopsDB->prefix('gwiki_page_files') . $whereclause;
    $result = $xoopsDB->query($sql);
    if ($result) {
        $myrow = $xoopsDB->fetchRow($result);
        $total = $myrow[0];
    }

    adminTableStart(_AD_GWIKI_FILES_LIST, 9);
    echo '<tr><form method="get">' . '<td><input type="text" name="kw" size="10" value="' . $kw . '"></td>' . '<td><input type="text" name="fn" size="10" value="' . $fn . '"></td>' . '<td>&nbsp;</td>'
         . '<td><input type="text" name="ty" size="10" value="' . $ty . '"></td>' . '<td>&nbsp;</td>' . '<td>&nbsp;</td>' . '<td>&nbsp;</td>' . '<td><input type="text" name="ds" size="10" value="'
         . $ds . '"></td>' . '<td><input type="submit" value="' . _AD_GWIKI_FILES_FILTER . '"></td>' . '</form></tr>';
    echo '<tr class="head">' . '<th>' . _AD_GWIKI_FILES_KEYWORD . '</th>' . '<th>' . _AD_GWIKI_FILES_NAME . '</th>' . '<th>' . _AD_GWIKI_FILES_PATH . '</th>' . '<th>' . _AD_GWIKI_FILES_TYPE . '</th>'
         . '<th>' . _AD_GWIKI_FILES_ICON . '</th>' . '<th>' . _AD_GWIKI_FILES_SIZE . '</th>' . '<th>' . _AD_GWIKI_FILES_DATE . '</th>' . '<th>' . _AD_GWIKI_FILES_DESC . '</th>' . '<th>'
         . _AD_GWIKI_FILES_UID . '</th>' . '</tr>';

    $sql = 'SELECT * FROM ' . $xoopsDB->prefix('gwiki_page_files');
    $sql .= $whereclause;
    $sql .= ' ORDER BY file_upload_date DESC ';

    $result = $xoopsDB->query($sql, $limit, $start);

    for ($i = 0, $iMax = $xoopsDB->getRowsNum($result); $i < $iMax; ++$i) {
        $row = $xoopsDB->fetchArray($result);
        /*
        gwiki_page_files
          file_id int(10) NOT NULL AUTO_INCREMENT,
          keyword varchar(128) NOT NULL DEFAULT '',
          file_name varchar(128) NOT NULL DEFAULT '',
          file_path varchar(255) NOT NULL DEFAULT '',
          file_type varchar(128) NOT NULL DEFAULT '',
          file_icon varchar(64) NOT NULL DEFAULT '',
          file_size int(10) NOT NULL DEFAULT '0',
          file_upload_date int(10) NOT NULL DEFAULT '0',
          file_description text,
          file_uid int(10) NOT NULL DEFAULT '0',
        */
        echo '<tr class="' . (($i % 2) ? 'even' : 'odd') . '"><td><a href="../edit.php?page=' . $row['keyword'] . '">' . htmlspecialchars($row['keyword'], ENT_QUOTES) . '</a></td>' . '<td>'
             . htmlspecialchars($row['file_name'], ENT_QUOTES) . '</td>' . '<td><a href="' . XOOPS_URL . '/uploads/' . $dir . '/' . $row['file_path'] . '">' . htmlspecialchars($row['file_path'],
                                                                                                                                                                                ENT_QUOTES)
             . '</a></td>' . '<td>' . htmlspecialchars($row['file_type'], ENT_QUOTES) . '</td>' . '<td><img src="' . XOOPS_URL . '/modules/' . $dir . '/assets/icons/16px/' . $row['file_icon']
             . '.png" alt="' . $row['file_icon'] . '" title="' . $row['file_icon'] . '" /></td>' . '<td>' . htmlspecialchars($row['file_size'], ENT_QUOTES) . '</td>' . '<td>' . date('Y-m-d',
                                                                                                                                                                                      $row['file_upload_date'])
             . '</td>' . '<td>' . htmlspecialchars($row['file_description'], ENT_QUOTES) . '</td>' . '<td>' . $wikiPage->getUserName($row['file_uid']) . '</td>' . '</tr>';
    }
    if ($i === 0) {
        echo '<tr class="odd"><td colspan="9">' . _AD_GWIKI_FILES_EMPTY . '</td></tr>';
    }

    // set up pagenav
    $endarray = array();
    $pager    = '';
    if ($total > $limit) {
        include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        $likenav = '';
        if (!empty($kw)) {
            $likenav .= (empty($likenav) ? '' : '&') . "kw={$kw}";
        }
        if (!empty($fn)) {
            $likenav .= (empty($likenav) ? '' : '&') . "fn={$fn}";
        }
        if (!empty($ty)) {
            $likenav .= (empty($likenav) ? '' : '&') . "ty={$ty}";
        }
        if (!empty($ds)) {
            $likenav .= (empty($likenav) ? '' : '&') . "ds={$ds}";
        }
        $nav = new xoopsPageNav($total, $limit, $start, 'start', $likenav);
        if ((int)($total / $limit) < 5) {

This code seems to be duplicated across your project.

            $pager = $nav->renderNav();
        } else {
            $pager = _AD_GWIKI_PAGENAV . $nav->renderSelect(false);
        }
    }
    if (!empty($pager)) {
        $endarray['!PREFORMATTED!'] = $pager;
    }

    adminTableEnd($endarray);
}

showAttachments();

include __DIR__ . '/footer.php';