XoopsModules25x / soapbox

        echo "<br>\n";

    }

    public static function showSubmissions()

    {

        global $xoopsGTicket;

        global $xoopsModuleConfig, $xoopsModule;

        $pathIcon16 = Xmf\Module\Admin::iconUrl('', 16);

        $myts       = MyTextSanitizer::getInstance();

        require_once XOOPS_ROOT_PATH . '/class/xoopslists.php';

        require_once XOOPS_ROOT_PATH . '/class/pagenav.php';

        require_once XOOPS_ROOT_PATH . '/class/xoopsform/grouppermform.php';

        require_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->dirname() . '/include/cleantags.php';

        $module_id = $xoopsModule->getVar('mid');

        $startsub  = isset($_GET['startsub']) ? (int)$_GET['startsub'] : 0;

        $datesub   = isset($_GET['datesub']) ? (int)$_GET['datesub'] : 0;

        //---GET view sort --

        $sortname = isset($_GET['sortname']) ? strtolower(trim(strip_tags($myts->stripSlashesGPC($_GET['sortname'])))) : 'datesub';

        if (!in_array($sortname, array('datesub', 'weight', 'counter', 'rating', 'headline'))) {

            $sortname = 'datesub';

        }

        $sortorder = isset($_GET['sortorder']) ? strtoupper(trim(strip_tags($myts->stripSlashesGPC($_GET['sortorder'])))) : 'DESC';

        if (!in_array($sortorder, array('ASC', 'DESC'))) {

            $sortorder = 'DESC';

        }

        //---------------

        /* Code to show submitted articles */

        echo "<h3 style='color: #2F5376; margin: 0 0 4px 0;'>" . _AM_SOAPBOX_SHOWSUBMISSIONS . '</h3>';

        echo '<span style="color: #567; margin: 3px 0 12px 0; font-size: small; display: block; ">' . _AM_SOAPBOX_SUBTEXT . '</span>';

        echo "<table width='100%' cellspacing=1 cellpadding=3 border=0 class = outer>";

        echo '<tr>';

        echo "<td width='40' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTID . '</b></td>';

        echo "<td width='20%' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTCOLNAME . '</b></td>';

        echo "<td width='45%' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTHEADLINE . '</b></td>';

        echo "<td width='90' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTCREATED . '</b></td>';

        echo "<td width='60' class='bg3' align='center'><b>" . _AM_SOAPBOX_ACTION . '</b></td>';

        echo '</tr>';

        // Put column names in an array, to avoid a query in the while loop farther ahead

        /* Code to show submitted articles */

        // Articles count

        //    function &getArticlesAllPermcheck(

        //         $limit=0, $start=0,

        //         $checkRight = true, $published = true, $submit = 0, $offline = 0, $block = null ,

        //         $sortname = 'datesub', $sortorder = 'DESC',

        //         $select_sbcolumns = null , $NOTarticleIDs = null ,

        //         $approve_submit = false ,

        //         $id_as_key = false )

        // Articles count

        $entrydataHandler = xoops_getModuleHandler('entrydata', $xoopsModule->dirname());

        //-------------------------------------

        $_entryob_arr = $entrydataHandler->getArticlesAllPermcheck((int)$xoopsModuleConfig['perpage'], $startsub, false, false, 1, null, null, $sortname, $sortorder, null, null, false);

        // Get number of articles in the selected condition ($cond)

        $numrows = $entrydataHandler->total_getArticlesAllPermcheck;

        if ($numrows > 0) { // That is, if there ARE unauthorized articles in the system

            foreach ($_entryob_arr as $_entryob) {

                //get vars

                //-------------------------------------

                $articles = $_entryob->toArray();

                //--------------------

                $colname = !empty($_entryob->_sbcolumns) ? $_entryob->_sbcolumns->getVar('name') : '';

                $created = $myts->htmlSpecialChars(formatTimestamp($datesub, $xoopsModuleConfig['dateformat']));

                $modify  = "<a href='submissions.php?op=mod&articleID=" . $articles['articleID'] . "'><img src='" . $pathIcon16 . "/edit.png' ALT='" . _AM_SOAPBOX_EDITSUBM . "'></a>";

                $delete  = "<a href='submissions.php?op=del&articleID=" . $articles['articleID'] . "'><img src='" . $pathIcon16 . "/delete.png' ALT='" . _AM_SOAPBOX_DELETESUBM . "'></a>";

                echo '<tr>';

                echo "<td class='head' align='center'>" . $articles['articleID'] . '</td>';

                echo "<td class='even' align='left'>" . $colname . '</td>';

                echo "<td class='even' align='left'>" . $articles['headline'] . '</td>';

                echo "<td class='even' align='center'>" . $created . '</td>';

                echo "<td class='even' align='center'>" . $modify . $delete . '</td>';

                echo '</tr>';

            }

        } else { // that is, $numrows = 0, there's no columns yet

            echo '<tr>';

            echo "<td class='head' align='center' colspan= '7'>" . _AM_SOAPBOX_NOSUBMISSYET . '</td>';

            echo '</tr>';

        }

        echo "</table>\n";

        $pagenav = new XoopsPageNav($numrows, $xoopsModuleConfig['perpage'], $startsub, 'startsub', '&sortname=' . $sortname . '&sortorder=' . $sortorder);

        echo '<div style="text-align:right;">' . $pagenav->renderNav() . '</div>';

        echo "<br>\n";

    }

    //HACK bydomifara for add method

    echo "<br>\n";

}

function showSubmissions()

{

    global $xoopsGTicket;

    global $xoopsModuleConfig, $xoopsModule;

    $pathIcon16 = Xmf\Module\Admin::iconUrl('', 16);

    $myts       = MyTextSanitizer::getInstance();

    require_once XOOPS_ROOT_PATH . '/class/xoopslists.php';

    require_once XOOPS_ROOT_PATH . '/class/pagenav.php';

    require_once XOOPS_ROOT_PATH . '/class/xoopsform/grouppermform.php';

    require_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->dirname() . '/include/cleantags.php';

    $module_id = $xoopsModule->getVar('mid');

    $startsub  = isset($_GET['startsub']) ? (int)$_GET['startsub'] : 0;

    $datesub   = isset($_GET['datesub']) ? (int)$_GET['datesub'] : 0;

    //---GET view sort --

    $sortname = isset($_GET['sortname']) ? strtolower(trim(strip_tags($myts->stripSlashesGPC($_GET['sortname'])))) : 'datesub';

    if (!in_array($sortname, array('datesub', 'weight', 'counter', 'rating', 'headline'))) {

        $sortname = 'datesub';

    }

    $sortorder = isset($_GET['sortorder']) ? strtoupper(trim(strip_tags($myts->stripSlashesGPC($_GET['sortorder'])))) : 'DESC';

    if (!in_array($sortorder, array('ASC', 'DESC'))) {

        $sortorder = 'DESC';

    }

    //---------------

    /* Code to show submitted articles */

    echo "<h3 style='color: #2F5376; margin: 0 0 4px 0;'>" . _AM_SOAPBOX_SHOWSUBMISSIONS . '</h3>';

    echo '<span style="color: #567; margin: 3px 0 12px 0; font-size: small; display: block; ">' . _AM_SOAPBOX_SUBTEXT . '</span>';

    echo "<table width='100%' cellspacing=1 cellpadding=3 border=0 class = outer>";

    echo '<tr>';

    echo "<td width='40' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTID . '</b></td>';

    echo "<td width='20%' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTCOLNAME . '</b></td>';

    echo "<td width='45%' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTHEADLINE . '</b></td>';

    echo "<td width='90' class='bg3' align='center'><b>" . _AM_SOAPBOX_ARTCREATED . '</b></td>';

    echo "<td width='60' class='bg3' align='center'><b>" . _AM_SOAPBOX_ACTION . '</b></td>';

    echo '</tr>';

    // Put column names in an array, to avoid a query in the while loop farther ahead

    /* Code to show submitted articles */

    // Articles count

    //    function &getArticlesAllPermcheck(

    //         $limit=0, $start=0,

    //         $checkRight = true, $published = true, $submit = 0, $offline = 0, $block = null ,

    //         $sortname = 'datesub', $sortorder = 'DESC',

    //         $select_sbcolumns = null , $NOTarticleIDs = null ,

    //         $approve_submit = false ,

    //         $id_as_key = false )

    // Articles count

    $entrydataHandler = xoops_getModuleHandler('entrydata', $xoopsModule->dirname());

    //-------------------------------------

    $_entryob_arr = $entrydataHandler->getArticlesAllPermcheck((int)$xoopsModuleConfig['perpage'], $startsub, false, false, 1, null, null, $sortname, $sortorder, null, null, false);

    // Get number of articles in the selected condition ($cond)

    $numrows = $entrydataHandler->total_getArticlesAllPermcheck;

    if ($numrows > 0) { // That is, if there ARE unauthorized articles in the system

        foreach ($_entryob_arr as $_entryob) {

            //get vars

            //-------------------------------------

            $articles = $_entryob->toArray();

            //--------------------

            $colname = !empty($_entryob->_sbcolumns) ? $_entryob->_sbcolumns->getVar('name') : '';

            $created = $myts->htmlSpecialChars(formatTimestamp($datesub, $xoopsModuleConfig['dateformat']));

            $modify  = "<a href='submissions.php?op=mod&articleID=" . $articles['articleID'] . "'><img src='" . $pathIcon16 . "/edit.png' ALT='" . _AM_SOAPBOX_EDITSUBM . "'></a>";

            $delete  = "<a href='submissions.php?op=del&articleID=" . $articles['articleID'] . "'><img src='" . $pathIcon16 . "/delete.png' ALT='" . _AM_SOAPBOX_DELETESUBM . "'></a>";

            echo '<tr>';

            echo "<td class='head' align='center'>" . $articles['articleID'] . '</td>';

            echo "<td class='even' align='left'>" . $colname . '</td>';

            echo "<td class='even' align='left'>" . $articles['headline'] . '</td>';

            echo "<td class='even' align='center'>" . $created . '</td>';

            echo "<td class='even' align='center'>" . $modify . $delete . '</td>';

            echo '</tr>';

        }

    } else { // that is, $numrows = 0, there's no columns yet

        echo '<tr>';

        echo "<td class='head' align='center' colspan= '7'>" . _AM_SOAPBOX_NOSUBMISSYET . '</td>';

        echo '</tr>';

    }

    echo "</table>\n";

    $pagenav = new XoopsPageNav($numrows, $xoopsModuleConfig['perpage'], $startsub, 'startsub', '&sortname=' . $sortname . '&sortorder=' . $sortorder);

    echo '<div style="text-align:right;">' . $pagenav->renderNav() . '</div>';

    echo "<br>\n";

}

//HACK bydomifara for add method

/**