index.php

在综合英文版XOOPS 2.09, 2.091, 2.092 的基础上正式发布XOOPS 2.09中文版 XOOPS 2.09x 版主要是PHP5升级、bug修正和安全补正： 1 全面兼容PHP 5.

            $button_tray -> addElement($hidden);

            if (!$arr['lid'])
            {
                $butt_create = new XoopsFormButton('', '', _AM_WFD_BSAVE, 'submit');
                $butt_create -> setExtra('onclick="this.form.elements.op.value=\'edit_review\'"');
                $button_tray -> addElement($butt_create);

                $butt_clear = new XoopsFormButton('', '', _AM_WFD_BRESET, 'reset');
                $button_tray -> addElement($butt_clear);

                $butt_cancel = new XoopsFormButton('', '', _AM_WFD_BCANCEL, 'button');
                $butt_cancel -> setExtra('onclick="history.go(-1)"');
                $button_tray -> addElement($butt_cancel);
            } 
            else
            {
                $butt_create = new XoopsFormButton('', '', _AM_WFD_BSAVE, 'submit');
                $butt_create -> setExtra('onclick="this.form.elements.op.value=\'edit_review\'"');
                $button_tray -> addElement($butt_create);

                $butt_delete = new XoopsFormButton('', '', _AM_WFD_BDELETE, 'submit');
                $butt_delete -> setExtra('onclick="this.form.elements.op.value=\'del_review\'"');
                $button_tray -> addElement($butt_delete);

                $butt_cancel = new XoopsFormButton('', '', _AM_WFD_BCANCEL, 'button');
                $butt_cancel -> setExtra('onclick="history.go(-1)"');
                $button_tray -> addElement($butt_cancel);
            } 
            $sform -> addElement($button_tray);
            $sform -> display();
            xoops_cp_footer();
        } 
        break;

    case "reviews":
        include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        global $xoopsDB, $myts, $xoopsModuleConfig, $imagearray;
        $start = isset($_GET['start']) ? intval($_GET['start']) : 0;
        $sql = "SELECT * FROM " . $xoopsDB -> prefix('wfdownloads_reviews') . " WHERE submit = 0 ORDER BY review_id" ;
        $result = $xoopsDB -> query($sql, $xoopsModuleConfig['admin_perpage'], $start);
        $num = $xoopsDB -> getRowsNum($result);
        $error = "<a href='javascript:history.go(-1)'>" . _AM_WFD_BRETURN . "</a><br /><br />";
        $error .= "Could not retrive review data: <br /><br />";
        $error .= $sql;
        if (!$result)
        {
            trigger_error($error, E_USER_ERROR);
        } 

        xoops_cp_header();
        wfd_adminmenu(_AM_WFD_AREVIEWS);

        echo "
			<fieldset><legend style='font-weight: bold; color: #900;'>" . _AM_WFD_AREVIEWS_INFO . "</legend>\n
			<div style='padding: 8px;'>" . _AM_WFD_AREVIEWS_WAITING . "&nbsp;<b>$num</b><div>\n
			<div style='padding: 8px;'>\n
			<li>" . $imagearray['approve'] . " " . _AM_WFD_AREVIEWS_APPROVE . "\n
			<li>" . $imagearray['editimg'] . " " . _AM_WFD_AREVIEWS_EDIT . "\n
			<li>" . $imagearray['deleteimg'] . " " . _AM_WFD_AREVIEWS_DELETE . "</div>\n
			</div>\n
			</fieldset><br />\n
		
		<table width='100%' cellspacing='1' cellpadding='3' border='0' class='outer'>\n
		<tr>\n
		<td class='bg3' align='center' width = '3%'><b>" . _AM_WFD_REV_ID . "</b></td>\n
		<td class='bg3' width = '30%'><b>" . _AM_WFD_REV_TITLE . "</b></td>\n
		<td class='bg3' align='center' width = '15%'><b>" . _AM_WFD_REV_POSTER . "</b></td>\n
		<td class='bg3' align='center' width = '15%'><b>" . _AM_WFD_REV_SUBMITDATE . "</b></td>\n
		<td class='bg3' align='center' width = '7%'><b>" . _AM_WFD_REV_ACTION . "</b></td>\n
		</tr>\n
		";
        if ($num)
        {
            while ($review_array = $xoopsDB -> fetchArray($result))
            {
                $review_id = intval($review_array['review_id']);
				$sql2 = "SELECT title FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " WHERE lid = " . $review_array['lid'] . "" ;
                list($title) = $xoopsDB -> fetchrow($result2 = $xoopsDB -> query($sql2));
				$title = $myts -> htmlSpecialChars($title);
                $lid = intval($review_array['lid']);
                $submitter = xoops_getLinkedUnameFromId($review_array['uid']);
                $datetime = formatTimestamp($review_array['date'], $xoopsModuleConfig['dateformat']);
                $status = (intval($review_array['submit'])) ? $approved : "<a href='index.php?op=approve_review&review_id=" . $review_id . "'>" . $imagearray['approve'] . "</a>";
                $modify = "<a href='index.php?op=edit_review&review_id=" . $review_id . "'>" . $imagearray['editimg'] . "</a>";
                $delete = "<a href='index.php?op=del_review&review_id=" . $review_id . "'>" . $imagearray['deleteimg'] . "</a>";
                echo "
		<tr>\n
		<td class='head' align='center'>" . $review_id . "</td>\n
		<td class='even' nowrap><a href='index.php?op=Download&amp;lid=" . $lid . "'>" . $title . "</a></td>\n
		<td class='even' align='center' nowrap>$submitter</td>\n
		<td class='even' align='center'>" . $datetime . "</td>\n
		<td class='even' align='center' nowrap>$status $modify $delete</td>\n
		</tr>\n
		";
            } 
        } 
        else
        {
            echo "<tr ><td align = 'center' class='head' colspan = '6'>" . _AM_WFD_REV_NOWAITINGREVIEWS . "</td></tr>";
        } 
        echo "</table>\n";
        $pagenav = new XoopsPageNav($num, $xoopsModuleConfig['admin_perpage'] , $start, 'start');
        echo "<div text-align='right'>" . $pagenav -> renderNav() . '</div>';
        xoops_cp_footer();
        break;

    case 'main':
    default:

        global $xoopsUser, $xoopsDB, $xoopsConfig;
        include_once XOOPS_ROOT_PATH . '/class/pagenav.php';
        $start = isset($_GET['start']) ? intval($_GET['start']) : 0;
        $start1 = isset($_GET['start1']) ? intval($_GET['start1']) : 0;
        $start2 = isset($_GET['start2']) ? intval($_GET['start2']) : 0;
        $start3 = isset($_GET['start3']) ? intval($_GET['start3']) : 0;
        $start4 = isset($_GET['start4']) ? intval($_GET['start4']) : 0;
        $totalcats = wfd_totalcategory();
        $result = $xoopsDB -> query("SELECT COUNT(*) FROM " . $xoopsDB -> prefix("wfdownloads_broken") . "");
        list($totalbrokendownloads) = $xoopsDB -> fetchRow($result);
        $result2 = $xoopsDB -> query("SELECT COUNT(*) FROM " . $xoopsDB -> prefix("wfdownloads_mod") . "");
        list($totalmodrequests) = $xoopsDB -> fetchRow($result2);

        $result3 = $xoopsDB -> query("SELECT COUNT(*) FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " WHERE published = 0");
        list($totalnewdownloads) = $xoopsDB -> fetchRow($result3);
        $result4 = $xoopsDB -> query("SELECT COUNT(*) FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " WHERE published > 0");
        list($totaldownloads) = $xoopsDB -> fetchRow($result4);
        $result5 = $xoopsDB -> query("SELECT COUNT(*) FROM " . $xoopsDB -> prefix("wfdownloads_reviews") . " WHERE submit = 0");
        list($newreviews) = $xoopsDB -> fetchRow($result5);

        xoops_cp_header();
        wfd_adminmenu(_AM_WFD_MDOWNLOADS);

        echo "
		<fieldset><legend style='font-weight: bold; color: #900;'>" . _AM_WFD_MINDEX_DOWNSUMMARY . "</legend>\n
		<div style='padding: 8px;'><small>\n
		<a href='category.php'>" . _AM_WFD_SCATEGORY . "</a><b>" . $totalcats . "</b> | \n
		<a href='index.php'>" . _AM_WFD_SFILES . "</a><b>" . $totaldownloads . "</b> | \n
		<a href='newdownloads.php'>" . _AM_WFD_SNEWFILESVAL . "</a><b>" . $totalnewdownloads . "</b> | \n
		<a href='modifications.php'>" . _AM_WFD_SMODREQUEST . "</a><b>" . $totalmodrequests . "</b> | \n
		<a href='brokendown.php'>" . _AM_WFD_SBROKENSUBMIT . "</a><b>" . $totalbrokendownloads . "</b> | \n
		<a href='index.php?op=reviews'>" . _AM_WFD_SREVIEWS . "</a><b>" . $newreviews . "</b>\n
		</small></div></fieldset><br />\n
		";

        wfd_serverstats();

        if ($totalcats > 0)
        {
            include_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php';
            $mytree = new XoopsTree($xoopsDB -> prefix("wfdownloads_cat"), "cid", "pid");
            $sform = new XoopsThemeForm(_AM_WFD_CCATEGORY_MODIFY, "category", "category.php");
            ob_start();
            $sform -> addElement(new XoopsFormHidden('cid', ''));
            $mytree -> makeMySelBox("title", "title");
            $sform -> addElement(new XoopsFormLabel(_AM_WFD_CCATEGORY_MODIFY_TITLE, ob_get_contents()));
            ob_end_clean();
            $dup_tray = new XoopsFormElementTray('', '');
            $dup_tray -> addElement(new XoopsFormHidden('op', 'modCat'));
            $butt_dup = new XoopsFormButton('', '', _AM_WFD_BMODIFY, 'submit');
            $butt_dup -> setExtra('onclick="this.form.elements.op.value=\'modCat\'"');
            $dup_tray -> addElement($butt_dup);
            $butt_dupct = new XoopsFormButton('', '', _AM_WFD_BDELETE, 'submit');
            $butt_dupct -> setExtra('onclick="this.form.elements.op.value=\'del\'"');
            $dup_tray -> addElement($butt_dupct);
            $sform -> addElement($dup_tray);
            $sform -> display();
        } 

        if ($totaldownloads > 0)
        {
            $sql = "SELECT * FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " 
				WHERE published > 0 AND published <= " . time() . " AND (expired = 0 OR expired > " . time() . ") 
				AND offline = 0 ORDER BY lid DESC" ;
            $published_array = $xoopsDB -> query($sql, $xoopsModuleConfig['admin_perpage'], $start);
            $published_array_count = $xoopsDB -> getRowsNum($xoopsDB -> query($sql));

            wfd_downlistheader(_AM_WFD_MINDEX_PUBLISHEDDOWN);
            if ($published_array_count > 0)
            {
                while ($published = $xoopsDB -> fetchArray($published_array))
                {
                    wfd_downlistbody($published);
                } 
            } 
            else
            {
                wfd_downlistfooter();
            } 
            wfd_downlistpagenav($published_array_count, $start, 'art');
            /**
             * Auto Publish
             */
            $sql = "SELECT * FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " 
				WHERE published > " . time() . " ORDER BY lid DESC" ;
            $auto_publish_array = $xoopsDB -> query($sql, $xoopsModuleConfig['admin_perpage'], $start2);
            $auto_publish_count = $xoopsDB -> getRowsNum($xoopsDB -> query($sql));
            wfd_downlistheader(_AM_WFD_MINDEX_AUTOPUBLISHEDDOWN);
            if ($auto_publish_count > 0)
            {
                while ($auto_publish = $xoopsDB -> fetchArray($auto_publish_array))
                {
                    wfd_downlistbody($auto_publish);
                } 
            } 
            else
            {
                wfd_downlistfooter();
            } 
            wfd_downlistpagenav($auto_publish_count, $start2, 'art2');
            /**
             * Auto expire FAQ
             */
            $sql = "SELECT * FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " 
				WHERE expired > " . time() . " ORDER BY lid DESC" ;
            $auto_expire_array = $xoopsDB -> query($sql, $xoopsModuleConfig['admin_perpage'], $start3);
            $auto_expire_count = $xoopsDB -> getRowsNum($xoopsDB -> query($sql));

            wfd_downlistheader(_AM_WFD_MINDEX_AUTOEXPIRE);
            if ($auto_expire_count > 0)
            {
                while ($auto_expire = $xoopsDB -> fetchArray($auto_expire_array))
                {
                    wfd_downlistbody($auto_expire);
                } 
            } 
            else
            {
                wfd_downlistfooter();
            } 
            wfd_downlistpagenav($auto_expire_count, $start3, 'art3');
            /**
             * Offline FAQ
             */
            $sql = "SELECT * FROM " . $xoopsDB -> prefix("wfdownloads_downloads") . " WHERE 
				offline = 1 ORDER BY lid DESC" ;
            $offline_array = $xoopsDB -> query($sql, $xoopsModuleConfig['admin_perpage'], $start4);
            $offline_count = $xoopsDB -> getRowsNum($xoopsDB -> query($sql));

            wfd_downlistheader(_AM_WFD_MINDEX_OFFLINEDOWN);
            if ($offline_count > 0)
            {
                while ($is_offline = $xoopsDB -> fetchArray($offline_array))
                {
                    wfd_downlistbody($is_offline);
                } 
            } 
            else
            {
                wfd_downlistfooter();
            } 
            wfd_downlistpagenav($offline_count, $start4, 'art4');
        } 
        xoops_cp_footer();
        break;
} 

?>