mambax7/wflinks

<?php
/**
 * Module: WF-Links
 * Version: v1.0.3
 * Release Date: 21 June 2005
 * Developer: John N
 * Team: WF-Projects
 * Licence: GNU
 */

use Xmf\Request;
use XoopsModules\Wflinks;

require_once __DIR__ . '/admin_header.php';

/** @var Wflinks\Helper $helper */
$helper = Wflinks\Helper::getInstance();

$op  = \Xmf\Request::getString('op', '');
$rid = \Xmf\Request::getInt('rid', 0);
$lid = \Xmf\Request::getInt('lid', 0);

switch (mb_strtolower($op)) {
    case 'delvote':
        $sql    = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_votedata') . ' WHERE ratingid=' . $rid;
        $result = $xoopsDB->queryF($sql);
        Wflinks\Utility::updateRating($lid);
        redirect_header('votedata.php', 1, _AM_WFL_VOTEDELETED);
        break;
    case 'main':
    default:
        $start = \Xmf\Request::getInt('start', 0);
        xoops_cp_header();

        $_vote_data = Wflinks\Utility::getVoteDetails($lid);

        $text_info = "
        <table width='100%'>
         <tr>
          <td width='50%' valign='top'>
           <div><b>" . _AM_WFL_VOTE_TOTALRATE . ': </b>' . Request::getInt('rate', 0, 'vote_data') . '</div>
           <div><b>' . _AM_WFL_VOTE_USERAVG . ': </b>' . (int)round($_vote_data['avg_rate'], 2) . '</div>
           <div><b>' . _AM_WFL_VOTE_MAXRATE . ': </b>' . Request::getInt('min_rate', 0, 'vote_data') . '</div>
           <div><b>' . _AM_WFL_VOTE_MINRATE . ': </b>' . Request::getInt('max_rate', 0, 'vote_data') . '</div>
          </td>
          <td>
           <div><b>' . _AM_WFL_VOTE_MOSTVOTEDTITLE . ': </b>' . Request::getInt('max_title', 0, 'vote_data') . '</div>
           <div><b>' . _AM_WFL_VOTE_LEASTVOTEDTITLE . ': </b>' . Request::getInt('min_title', 0, 'vote_data') . '</div>
           <div><b>' . _AM_WFL_VOTE_REGISTERED . ': </b>' . $_vote_data['rate'] - $_vote_data['null_ratinguser'] . '</div>
           <div><b>' . _AM_WFL_VOTE_NONREGISTERED . ': </b>' . Request::getInt('null_ratinguser', 0, 'vote_data') . '</div>
          </td>
         </tr>
        </table>';

        echo "
        <fieldset><legend style='font-weight: bold; color: #0A3760;'>" . _AM_WFL_VOTE_DISPLAYVOTES . "</legend>\n
        <div style='padding: 8px;'>$text_info</div>\n
        <div style='padding: 8px;'><li>" . $imageArray['deleteimg'] . ' ' . _AM_WFL_VOTE_DELETEDSC . "</li></div>\n
        </fieldset>\n
        <br>\n

        <table width='100%' cellspacing='1' cellpadding='2' class='outer'>\n
        <tr>\n
        <th class='txtcenter;'>" . _AM_WFL_VOTE_ID . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_VOTE_USER . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_VOTE_IP . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_VOTE_FILETITLE . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_VOTE_RATING . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_VOTE_DATE . "</th>\n
        <th class='txtcenter;'>" . _AM_WFL_MINDEX_ACTION . "</th></tr>\n";

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

        $results = $xoopsDB->query($sql, $helper->getConfig('admin_perpage'), $start);
        $votes   = $xoopsDB->getRowsNum($xoopsDB->query($sql));

        if (0 == $votes) {
            echo "<tr><td class='txtcenter;' colspan='7' class='head'>" . _AM_WFL_VOTE_NOVOTES . '</td></tr>';
        } else {
            while (list($ratingid, $lid, $ratinguser, $rating, $ratinghostname, $ratingtimestamp, $title) = $xoopsDB->fetchRow($results)) {
                $formatted_date = formatTimestamp($ratingtimestamp, $helper->getConfig('dateformatadmin'));
                $ratinguname    = \XoopsUser:: getUnameFromId($ratinguser);
                echo "
                    <tr class='txtcenter;'>\n
                    <td class='head'>$ratingid</td>\n
                    <td class='even'>$ratinguname</td>\n
                    <td class='even'>$ratinghostname</td>\n
                    <td class='even'>$title</td>\n
                    <td class='even'>$rating</td>\n
                    <td class='even'>$formatted_date</td>\n
                    <td class='even'><a href='votedata.php?op=delvote&amp;lid=" . $lid . '&amp;rid=' . $ratingid . "'>" . $imageArray['deleteimg'] . "</a></td>\n
                    </tr>\n";
            }
        }
        echo '</table>';
        // Include page navigation
        require_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        $page    = ($votes > $helper->getConfig('admin_perpage')) ? _AM_WFL_MINDEX_PAGE : '';
        $pagenav = new \XoopsPageNav($page, $helper->getConfig('admin_perpage'), $start, 'start');
        echo '<div align="right" style="padding: 8px;">' . $pagenav->renderNav() . '</div>';
        break;
}
require_once __DIR__ . '/admin_footer.php';