XoopsModules25x / xoopstube

admin/votedata.php

<?php
/**
 * Module: XoopsTube
 *
 * You may not change or alter any portion of this comment or credits
 * of supporting developers from this source code or any supporting source code
 * which is considered copyrighted (c) material of the original comment or credit authors.
 *
 * PHP version 5
 *
 * @category        Module
 * @package         Xoopstube
 * @author          XOOPS Development Team
 * @copyright       2001-2013 The XOOPS Project
 * @license         GNU GPL 2 or later (http://www.gnu.org/licenses/gpl-2.0.html)
 * @version         $Id$
 * @link            http://sourceforge.net/projects/xoops/
 * @since           1.0.6
 */

include_once __DIR__ . '/admin_header.php';

$op  = xtubeCleanRequestVars($_REQUEST, 'op', '');
$rid = xtubeCleanRequestVars($_REQUEST, 'rid', 0);
$lid = xtubeCleanRequestVars($_REQUEST, 'lid', 0);
$rid = intval($rid);
$lid = intval($lid);

switch (strtolower($op)) {
    case 'delvote':
        $sql    = 'DELETE FROM ' . $xoopsDB->prefix('xoopstube_votedata') . ' WHERE ratingid=' . $rid;
        $result = $xoopsDB->queryF($sql);
        xtubeUpdateRating($lid);
        redirect_header('votedata.php', 1, _AM_XOOPSTUBE_VOTEDELETED);
        break;

    case 'main':
    default:
        $start = xtubeCleanRequestVars($_REQUEST, 'start', 0);
        xoops_cp_header();
        //xtubeRenderAdminMenu( _AM_XOOPSTUBE_VOTE_RATINGINFOMATION );

43% of this comment could be valid code. Did you maybe forget this after debugging?

        $aboutAdmin = new ModuleAdmin();
        echo $aboutAdmin->addNavigation('votedata.php');
        $_vote_data = xtubeGetVoteDetails($lid);

        $text_info
            = '
        <table width="100%">
         <tr>
          <td width="50%" valign="top">
           <div><b>' . _AM_XOOPSTUBE_VOTE_TOTALRATE . ': </b>' . intval($_vote_data['rate']) . '</div>
           <div><b>' . _AM_XOOPSTUBE_VOTE_USERAVG . ': </b>' . intval(round($_vote_data['avg_rate'], 2)) . '</div>
           <div><b>' . _AM_XOOPSTUBE_VOTE_MAXRATE . ': </b>' . intval($_vote_data['min_rate']) . '</div>
           <div><b>' . _AM_XOOPSTUBE_VOTE_MINRATE . ': </b>' . intval($_vote_data['max_rate']) . '</div>
          </td>
          <td>
           <div><b>' . _AM_XOOPSTUBE_VOTE_MOSTVOTEDTITLE . ': </b>' . intval($_vote_data['max_title']) . '</div>
           <div><b>' . _AM_XOOPSTUBE_VOTE_LEASTVOTEDTITLE . ': </b>' . intval($_vote_data['min_title']) . '</div>
           <div><b>' . _AM_XOOPSTUBE_VOTE_REGISTERED . ': </b>' . (intval(
                $_vote_data['rate'] - $_vote_data['null_ratinguser']
            )) . '</div>
           <div><b>' . _AM_XOOPSTUBE_VOTE_NONREGISTERED . ': </b>' . intval($_vote_data['null_ratinguser']) . '</div>
          </td>
         </tr>
        </table>';

        echo '
         <fieldset style="border: #e8e8e8 1px solid;">
         <legend style="display: inline; font-weight: bold; color: #0A3760;">' . _AM_XOOPSTUBE_VOTE_DISPLAYVOTES . '</legend>
         <div style="padding: 8px;">' . $text_info . '<br />
         <li>' . $xtubeImageArray['deleteimg'] . ' ' . _AM_XOOPSTUBE_VOTE_DELETEDSC . '</li>
         </div>
         </fieldset>

        <table width="100%" cellspacing="1" cellpadding="2" class="outer" style="font-size: smaller;">
        <tr>
        <th style="text-align: center;">' . _AM_XOOPSTUBE_VOTE_ID . '</th>
        <th style="text-align: center;">' . _AM_XOOPSTUBE_VOTE_USER . '</th>
        <th style="text-align: center;">' . _AM_XOOPSTUBE_VOTE_IP . '</th>
        <th style="text-align: left;">&nbsp;' . _AM_XOOPSTUBE_VOTE_FILETITLE . '</th>
        <th style="text-align: center;">' . _AM_XOOPSTUBE_VOTE_RATING . '</th>
        <th style="text-align: center;">' . _AM_XOOPSTUBE_VOTE_DATE . '</th>
        <th style="text-align: center;">' . _AM_XOOPSTUBE_MINDEX_ACTION . '</th></tr>';

        $sql = 'SELECT * FROM ' . $xoopsDB->prefix('xoopstube_votedata');
        if ($lid > 0) {
            $sql .= ' WHERE lid=' . $lid;
        }
        $sql .= ' ORDER BY ratingtimestamp DESC';

        $results = $xoopsDB->query($sql, $xoopsModuleConfig['admin_perpage'], $start);
        $votes   = $xoopsDB->getRowsNum($xoopsDB->query($sql));

        if ($votes == 0) {
            echo '<tr><td style="text-align: center;" colspan="7" class="head">' . _AM_XOOPSTUBE_VOTE_NOVOTES . '</td></tr>';
        } else {
            while (list($ratingid, $lid, $ratinguser, $rating, $ratinghostname, $ratingtimestamp, $title) = $xoopsDB->fetchRow(
                $results
            )) {
                $formatted_date = xtubeGetTimestamp(
                    formatTimestamp($ratingtimestamp, $xoopsModuleConfig['dateformat'])
                );
                $ratinguname    = XoopsUser::getUnameFromId($ratinguser);
                echo '
                    <tr>
                    <td class="head" style="text-align: center;">' . $ratingid . '</td>
                    <td class="even" style="text-align: center;">' . $ratinguname . '</td>
                    <td class="even" style="text-align: center;">' . $ratinghostname . '</td>
                    <td class="even" style="text-align: left;">&nbsp;' . $title . '</td>
                    <td class="even" style="text-align: center;">' . $rating . '</td>
                    <td class="even" style="text-align: center;">' . $formatted_date . '</td>
                    <td class="even" style="text-align: center;"><a href="votedata.php?op=delvote&amp;lid=' . $lid . '&amp;rid=' . $ratingid . '">' . $xtubeImageArray['deleteimg'] . '</a></td>
                    </tr>';
            }
        }
        echo '</table>';
        // Include page navigation
        include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        $page    = ($votes > $xoopsModuleConfig['admin_perpage']) ? _AM_XOOPSTUBE_MINDEX_PAGE : '';
        $pagenav = new XoopsPageNav($page, $xoopsModuleConfig['admin_perpage'], $start, 'start');
        echo '<div align="right" style="padding: 8px;">' . $pagenav->renderNav() . '</div>';
        break;
}
include_once __DIR__ . '/admin_footer.php';