PHP Q_Clean Examples

Example #1

File: topicadmin.php Project: Jireck-npds/npds_dune

        forumerror('0001');
    }
    $sql = "UPDATE {$upload_table} SET forum_id='{$newforum}' WHERE apli='forum_npds' AND topic_id='{$topic}' AND forum_id='{$forum}'";
    sql_query($sql);
    $sql = "SELECT arbre FROM " . $NPDS_Prefix . "forums WHERE forum_id='{$newforum}'";
    $arbre = sql_fetch_assoc(sql_query($sql));
    if ($arbre['arbre']) {
        $url_ret = "viewtopicH.php";
    } else {
        $url_ret = "viewtopic.php";
    }
    include "header.php";
    opentable();
    echo "<p align=\"center\" class=\"noir\">" . translate("The topic has been moved.") . "</p><br /> - <a href=\"{$url_ret}?topic={$topic}&amp;forum={$newforum}\" class=\"noir\">" . translate("Click here to view the updated topic.") . "</a><br /><br /> - <a href=\"forum.php\" class=\"noir\">" . translate("Click here to return to the forum index.") . "</a>";
    closetable();
    Q_Clean();
    include "footer.php";
} else {
    if ($Mmod or $adminforum == 1) {
        switch ($mode) {
            case 'move':
                include "header.php";
                echo '
      <h2>' . translate("Forum") . '</h2>
      <form action="topicadmin.php" method="post">
         <div class="form-group row">
            <label class="form-control-label col-sm-12" for="newforum">' . translate("Move Topic To: ") . '</label>
            <div class="col-sm-12">
               <select class="c-select form-control" name="newforum">';
                $sql = "SELECT forum_id, forum_name FROM " . $NPDS_Prefix . "forums WHERE forum_id!='{$forum}' ORDER BY cat_id,forum_index,forum_id";
                if ($result = sql_query($sql)) {

Example #2

File: cache.class.php Project: Jireck-npds/npds_dune

function SC_clean()
{
    global $CACHE_CONFIG;
    $dh = opendir($CACHE_CONFIG['data_dir']);
    while (false !== ($filename = readdir($dh))) {
        if ($filename === '.' or $filename === '..' or $filename === 'ultramode.txt' or $filename === 'net2zone.txt' or $filename === 'sql' or $filename === 'index.html') {
            continue;
        }
        if (is_file($CACHE_CONFIG['data_dir'] . $filename)) {
            unlink($CACHE_CONFIG['data_dir'] . $filename);
        }
    }
    closedir($dh);
    Q_Clean();
}

Example #3

File: phpbbforum.php Project: Jireck-npds/npds_dune

function ForumGoDel($forum_id, $ok = 0)
{
    global $hlpfile;
    global $NPDS_Prefix;
    if ($ok == 1) {
        sql_query("DELETE FROM " . $NPDS_Prefix . "forumtopics WHERE forum_id='{$forum_id}'");
        sql_query("DELETE FROM " . $NPDS_Prefix . "forum_read WHERE forum_id='{$forum_id}'");
        control_efface_post("forum_npds", "", "", $forum_id);
        sql_query("DELETE FROM " . $NPDS_Prefix . "forums WHERE forum_id='{$forum_id}'");
        Q_Clean();
        global $aid;
        Ecr_Log("security", "DeleteForum({$forum_id}) by AID : {$aid}", "");
        Header("Location: admin.php?op=ForumAdmin");
    } else {
        include "header.php";
        GraphicAdmin($hlpfile);
        opentable();
        echo "<p align=\"center\" class=\"rouge\"><b>" . adm_translate("ATTENTION :  êtes-vous certain de vouloir effacer ce Forum et tous ses Sujets ?") . "</b><br /><br />";
    }
    echo "[ <a href=\"admin.php?op=ForumGoDel&amp;forum_id={$forum_id}&amp;ok=1\" class=\"rouge\">" . adm_translate("Oui") . "</a> | <a href=\"admin.php?op=ForumAdmin\" class=\"noir\">" . adm_translate("Non") . "</a> ]<br /><br />";
    closetable();
    include "footer.php";
}

Example #4

File: phpbbmaint.php Project: npds/npds_dune

function MergeForumAction($oriforum, $destforum)
{
    global $upload_table;
    global $NPDS_Prefix;
    $sql = "UPDATE " . $NPDS_Prefix . "forumtopics SET forum_id='{$destforum}' WHERE forum_id='{$oriforum}'";
    if (!($r = sql_query($sql))) {
        forumerror('0010');
    }
    $sql = "UPDATE " . $NPDS_Prefix . "posts SET forum_id='{$destforum}' WHERE forum_id='{$oriforum}'";
    if (!($r = sql_query($sql))) {
        forumerror('0010');
    }
    $sql = "UPDATE " . $NPDS_Prefix . "forum_read SET forum_id='{$destforum}' WHERE forum_id='{$oriforum}'";
    if (!($r = sql_query($sql))) {
        forumerror('0001');
    }
    $sql = "UPDATE {$upload_table} SET forum_id='{$destforum}' WHERE apli='forum_npds' and forum_id='{$oriforum}'";
    sql_query($sql);
    sql_free_result;
    Q_Clean();
    header("location: admin.php?op=MaintForumAdmin");
}

Example #5

File: phpbbconfig.php Project: npds/npds_dune

function ForumConfigChange($allow_html, $allow_bbcode, $allow_sig, $posts_per_page, $hot_threshold, $topics_per_page, $allow_upload_forum, $allow_forum_hide, $rank1, $rank2, $rank3, $rank4, $rank5, $anti_flood, $solved)
{
    global $NPDS_Prefix;
    sql_query("UPDATE " . $NPDS_Prefix . "config SET allow_html='{$allow_html}', allow_bbcode='{$allow_bbcode}', allow_sig='{$allow_sig}', posts_per_page='{$posts_per_page}', hot_threshold='{$hot_threshold}', topics_per_page='{$topics_per_page}', allow_upload_forum='{$allow_upload_forum}', allow_forum_hide='{$allow_forum_hide}', rank1='{$rank1}', rank2='{$rank2}', rank3='{$rank3}', rank4='{$rank4}', rank5='{$rank5}', anti_flood='{$anti_flood}', solved='{$solved}'");
    Q_Clean();
    Header("Location: admin.php?op=ForumConfigAdmin");
}