Beispiel #1
0
function linkedPages()
{
    foreach ($_REQUEST as $k => $v) {
        ${$k} = $v;
    }
    if (count($ids) <= 0) {
        redirectMsg("pages.php?cat={$cat}&page={$page}", __('Select at least a cetegory to edit', 'qpages'), 1);
        die;
    }
    $db = XoopsDatabaseFactory::getDatabaseConnection();
    $sql = "SELECT * FROM " . $db->prefix("qpages_pages") . " WHERE id_page IN (";
    $sql .= implode(',', $ids) . ')';
    $result = $db->query($sql);
    while ($row = $db->fetchArray($result)) {
        $page = new QPPage();
        $page->assignVars($row);
        $page->setType(!$page->type());
        $page->update();
    }
    redirectMsg("pages.php?cat={$cat}&page={$page}", __('Database updated successfully!', 'qpages'), 0);
}