mambax7 / wflinks

    case 'save':

        // first delete all alternate categories for this topic

        $sql = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_altcat') . ' WHERE lid=' . $lid;

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

        $k = array_keys($_REQUEST);

        foreach ($k as $sid) {

        foreach ($k as $sid) {

            if (preg_match('/cid-([0-9]*)/', $sid, $cid)) {

                $sql = 'INSERT INTO ' . $xoopsDB->prefix('wflinks_altcat') . "(cid, lid) VALUES('" . $cid[1] . "','" . $lid . "')";

                if (!$result = $xoopsDB->query($sql)) {

                    XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

                    return false;

                }

            }

        }

        redirect_header('index.php', 1, _AM_WFL_ALTCAT_CREATED);

        $sql              = 'UPDATE '

                            . $xoopsDB->prefix('wflinks_indexpage')

                            . " set indexheading='$indexheading', indexheader='$indexheader', indexfooter='$indexfooter', indeximage='$indeximage', indexheaderalign='$indexheaderalign ', indexfooteralign='$indexfooteralign', nohtml='$nohtml', nosmiley='$nosmiley', noxcodes='$noxcodes', noimages='$noimages', nobreak='$nobreak', lastlinksyn='$lastlinksyn', lastlinkstotal='$lastlinkstotal'";

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

        redirect_header('index.php', 1, _AM_WFL_IPAGE_UPDATED);

        break;

    default:

        $sql = 'SELECT indeximage, indexheading, indexheader, indexfooter, nohtml, nosmiley, noxcodes, noimages, nobreak, indexheaderalign, indexfooteralign, lastlinksyn, lastlinkstotal FROM ' . $xoopsDB->prefix('wflinks_indexpage');

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

        list($indeximage, $indexheading, $indexheader, $indexfooter, $nohtml, $nosmiley, $noxcodes, $noimages, $nobreak, $indexheaderalign, $indexfooteralign, $lastlinksyn, $lastlinkstotal) = $xoopsDB->fetchRow($result);

        xoops_cp_header();

        global $xoopsModule;

        $sql = 'SELECT cid, title, notifypub FROM ' . $xoopsDB->prefix('wflinks_links') . ' WHERE lid=' . $lid;

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

        list($cid, $title, $notifypub) = $xoopsDB->fetchRow($result);

        // Update the database

        xoops_load('XoopsUserUtility');

        $start = WflinksUtility::cleanRequestVars($_REQUEST, 'start', 0);

        $sql   = 'SELECT * FROM ' . $xoopsDB->prefix('wflinks_links') . ' WHERE published = 0 ORDER BY lid DESC';

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

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

        $new_array_count = $xoopsDB->getRowsNum($xoopsDB->query($sql));

    global $xoopsDB, $wfmyts, $mytree, $imageArray, $xoopsConfig, $xoopsModuleConfig, $xoopsModule, $xoopsUser;

    $sql = 'SELECT * FROM ' . $xoopsDB->prefix('wflinks_links') . ' WHERE lid=' . $lid;

    if (!$result = $xoopsDB->query($sql)) {

        XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

        return false;

    }

    $link_array = $xoopsDB->fetchArray($xoopsDB->query($sql));

    $directory    = $xoopsModuleConfig['screenshots'];

            $sql .= ' WHERE cid=' . $cid;

        }

        $sql .= ' ORDER BY lid DESC';

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

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

        $broken_array_count = $xoopsDB->getRowsNum($result);

            // delete link

            $sql = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_links') . ' WHERE lid=' . $lid;

            if (!$result = $xoopsDB->query($sql)) {

                XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

                return false;

            }

            // delete from altcat

            $sql = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_altcat') . ' WHERE lid=' . $lid;

            // delete from altcat

            $sql = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_altcat') . ' WHERE lid=' . $lid;

            if (!$result = $xoopsDB->query($sql)) {

                XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

                return false;

            }

            // delete vote data

            $sql = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_votedata') . ' WHERE lid=' . $lid;

            // delete vote data

            $sql = 'DELETE FROM ' . $xoopsDB->prefix('wflinks_votedata') . ' WHERE lid=' . $lid;

            if (!$result = $xoopsDB->query($sql)) {

                XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

                return false;

            }

            // delete comments

            xoops_comment_delete($xoopsModule->getVar('mid'), $lid);

                             . $cid;

            $database_mess = _AM_WFL_CCATEGORY_MODIFIED;

        }

        if (!$result = $xoopsDB->query($sql)) {

            XoopsErrorHandler_HandleError(E_USER_WARNING, $sql, __FILE__, __LINE__);

            return false;

        }

        redirect_header('category.php', 1, $database_mess);

        break;