PHP sed_check_xg Examples

Example #1

File: eyoop.page.edit.php Project: riptide2k/seditio-eyoop

                $rpagealias = sed_sql_numrows($sql) > 0 ? "alias" . rand(1000, 9999) : $rpagealias;
            }
            $sql = sed_sql_query("UPDATE {$db_pages} SET\n\t\t\t\tpage_cat = '" . sed_sql_prep($rpagecat) . "',\n\t\t\t\tpage_type = '" . sed_sql_prep($rpagetype) . "',\n\t\t\t\tpage_key = '" . sed_sql_prep($rpagekey) . "',\n\t\t\t\tpage_extra1 = '" . sed_sql_prep($rpageextra1) . "',\n\t\t\t\tpage_extra2 = '" . sed_sql_prep($rpageextra2) . "',\n\t\t\t\tpage_extra3 = '" . sed_sql_prep($rpageextra3) . "',\n\t\t\t\tpage_extra4 = '" . sed_sql_prep($rpageextra4) . "',\n\t\t\t\tpage_extra5 = '" . sed_sql_prep($rpageextra5) . "',\n\t\t\t\tpage_title = '" . sed_sql_prep($rpagetitle) . "',\n\t\t\t\tpage_desc = '" . sed_sql_prep($rpagedesc) . "',\n\t\t\t\tpage_text='" . sed_sql_prep($rpagetext) . "',\n\t\t\t\tpage_author = '" . sed_sql_prep($rpageauthor) . "',\n\t\t\t\tpage_ownerid = '{$rpageownerid}',\n\t\t\t\tpage_date = '{$rpagedate}',\n\t\t\t\tpage_begin = '{$rpagebegin}',\n\t\t\t\tpage_expire = '{$rpageexpire}',\n\t\t\t\tpage_file = '" . sed_sql_prep($rpagefile) . "',\n\t\t\t\tpage_url = '" . sed_sql_prep($rpageurl) . "',\n\t\t\t\tpage_size = '" . sed_sql_prep($rpagesize) . "',\n\t\t\t\tpage_count = '{$rpagecount}',\n\t\t\t\tpage_filecount = '{$rpagefilecount}',\n\t\t\t\tpage_alias = '" . sed_sql_prep($rpagealias) . "'\n\t\t\t\tWHERE page_id='{$id}'");
            sed_log("Edited page #" . $id, 'adm');
        }
        if ($r == 'adm') {
            header("Location: admin.php?m=page&s=queue");
            exit;
        } else {
            header("Location: list.php?c={$rpagecat}");
            exit;
        }
    }
}
if ($a == 'unvalidate') {
    sed_check_xg();
    $sql = sed_sql_query("SELECT page_ownerid, page_cat FROM {$db_pages} WHERE page_id='{$id}' LIMIT 1");
    if ($row = sed_sql_fetcharray($sql)) {
        $usr['isadmin'] = sed_auth('page', $row['page_cat'], 'A');
        $usr['isadmin'] = $row['page_ownerid'] == $usr['id'] ? TRUE : $usr['isadmin'];
        sed_block($usr['isadmin']);
        $sql = sed_sql_query("UPDATE {$db_pages} SET page_state=1 WHERE page_id='{$id}'");
        sed_cache_clear('latestpages');
        header("Location: list.php?c=" . $row['page_cat']);
        exit;
    } else {
        sed_die();
    }
}
$sql = sed_sql_query("SELECT * FROM {$db_pages} WHERE page_id='{$id}' LIMIT 1");
sed_die(sed_sql_numrows($sql) == 0);

Example #2

File: hidefuturepages.tool.inc.php Project: rs-dlapin/cotonti_genoa_plugin_hidefuturepages

function hfp_tool_action_set_to_display($id)
{
    global $db_pages, $cfg, $sys, $usr, $db_structure;
    sed_check_xg();
    $id = (int) $id;
    $state = sed_import('state', 'G', 'INT', 1);
    if ($id > 0) {
        $sql = sed_sql_query("SELECT page_cat FROM {$db_pages} WHERE page_id='" . $id . "'");
        if ($result = sed_sql_fetchassoc($sql)) {
            $pageexpire = hfp_tool_get_yearstillexpire();
            sed_sql_query("UPDATE {$db_pages} SET page_begin='" . (int) $sys['now_offset'] . "', page_expire='" . $pageexpire . "', page_state='0' WHERE page_id='{$id}'");
            sed_sql_query("UPDATE {$db_structure} SET structure_pagecount=structure_pagecount+1 WHERE structure_code='" . sed_sql_prep($result['page_cat']) . "'");
        }
    }
    sed_redirect(sed_url('admin', 'm=tools&p=hidefuturepages&state=' . $state, NULL, TRUE));
}