XoopsModules25x / efqdirectory

        $uploader = new XoopsMediaUploader(XOOPS_ROOT_PATH . "/modules/$moddir/init_uploads", array('image/gif', 'image/jpeg', 'image/pjpeg', 'image/x-png', 'image/png', 'image/jpg'), 30000, 250, 250);

        if ($uploader->fetchMedia($_POST['xoops_upload_file'][0])) {

            $filename = $uploader->getMediaName();

        } else {

            $sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat') . " SET title = '$p_title', active='$p_active', pid='$p_pid', allowlist='$p_allowlist', showpopular='$p_showpopular' WHERE cid = $p_catid";

            $xoopsDB->query($sql) or $eh->show('0013');

            if ($p_descr) {

                if ($descr_exists === true) {

                    $sql2 = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat_txt') . " SET text='$p_descr' WHERE cid = $p_catid";

                } else {

                    $newid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat_txt') . '_txtid_seq');

                    $sql2  = sprintf("INSERT INTO %s (txtid, cid, TEXT, active, created) VALUES (%u, %u, '%s', %u, '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat_txt'), $newid, $p_catid, $p_descr, '1', time());

                }

                $xoopsDB->query($sql2) or $eh->show('0013');

            }

            redirect_header("categories.php?op=edit&catid=$p_catid", 2, _MD_CAT_UPDATED);

            exit();

        }

        $uploader->setPrefix('efqdir');

        if ($uploader->upload()) {

            $savedfilename = $uploader->getSavedFileName();

            }

            redirect_header("categories.php?op=edit&catid=$p_catid", 2, _MD_CAT_UPDATED);

            exit();

        } else {

            echo $uploader->getErrors();

            $sql = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat') . " SET title = '$p_title', active='$p_active', pid='$p_pid', allowlist='$p_allowlist', showpopular='$p_showpopular' WHERE cid = $p_catid";

            $xoopsDB->query($sql) or $eh->show('0013');

            if ($p_descr) {

                if ($descr_exists === true) {

                    $sql2 = 'UPDATE ' . $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat_txt') . " SET text='$p_descr' WHERE cid = $p_catid";

                } else {

                    $newid = $xoopsDB->genId($xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat_txt') . '_txtid_seq');

                    $sql2  = sprintf("INSERT INTO %s (txtid, cid, TEXT, active, created) VALUES (%u, %u, '%s', %u, '%s')", $xoopsDB->prefix($xoopsModule->getVar('dirname', 'n') . '_cat_txt'), $newid, $p_catid, $p_descr, '1', time());

                }

                $xoopsDB->query($sql2) or $eh->show('0013');

            }

            redirect_header("categories.php?op=edit&catid=$p_catid", 2, _MD_CAT_UPDATED);

            exit();

        }

    }

    redirect_header("categories.php?op=edit&catid=$p_catid", 2, _MD_CAT_NOT_UPDATED);

    exit();