Ejemplo n.º 1
0
function defensio_make_to_ham($comment_TYPE, $comment_ID = 0)
{
    global $database;
    $table = $comment_TYPE == 'C' ? "Comments" : "Trackbacks";
    $blogid = getBlogId();
    $sql = "SELECT c.*, d.spaminess, d.signature FROM {$database['prefix']}{$table} c LEFT JOIN  {$database['prefix']}defensio d\n\t\tON c.blogid = d.blog_ID and c.id = d.comment_ID \n\t\tWHERE d.blog_ID = '{$blogid}' and d.comment_TYPE = '{$comment_TYPE}' and c.isFiltered = 0 and d.spaminess > 0";
    if ($comment_ID) {
        $sql .= " and c.id in ({$comment_ID})";
    }
    $r = POD::queryAll($sql);
    if (!$r || !count($r)) {
        return;
    }
    $hams = array();
    $comment_IDs = array();
    foreach ($r as $c) {
        array_push($hams, $c['signature']);
        array_push($comment_IDs, $c['id']);
    }
    // make spam to ham
    if (count($hams) > 0) {
        defensio_submit_ham(implode(',', $hams));
        $string_id = implode(',', $comment_IDs);
        $sql = "UPDATE {$database['prefix']}defensio SET spaminess = 0 WHERE blog_ID = '{$blogid}' and comment_TYPE = '{$comment_TYPE}' and comment_ID in ({$string_id})";
        POD::execute($sql);
        //
        //$sql = "UPDATE {$database['prefix']}{$table} SET isFiltered = 0 WHERE blogid = '$blogid' and id in ($string_id)";
        //POD::execute($sql);
    }
}
Ejemplo n.º 2
0
function defensio_submit_nonspam_comment($defensio_conf)
{
    //Function to report the comment is not spam
    //Loop thru the $_POST['moderate_commnts_boxes'] and keep marking each comment as spam to Defensio
    global $pixelpost_db_prefix;
    if (is_array($_POST['moderate_commnts_boxes'])) {
        $number_of_images = count($_POST['moderate_commnts_boxes']);
        $counter = 0;
        $counter_no_signature = 0;
        $signatures = null;
        foreach ($_POST['moderate_commnts_boxes'] as $cid) {
            $query = "SELECT `signature` FROM {$pixelpost_db_prefix}comments WHERE id = '" . (int) $cid . "'";
            $result = mysql_query($query);
            if (mysql_num_rows($result)) {
                $row = mysql_fetch_assoc($result);
                if ($row['signature'] != null) {
                    $counter = $counter + 1;
                    if ($counter != $number_of_images) {
                        $signatures .= $row['signature'] . ",";
                    } else {
                        $signatures .= $row['signature'];
                    }
                    //Since comment is not spam, let's mark it to publish
                    $query = "UPDATE {$pixelpost_db_prefix}comments SET publish = 'yes' WHERE id = '" . (int) $cid . "'";
                    mysql_query($query);
                } else {
                    // no signature was found
                    $counter_no_signature = $counter_no_signature + 1;
                }
            }
        }
        // construct the error message
        $GLOBALS['defensio_result_message'] = '<div class="jcaption confirm">';
        if ($signatures != null) {
            // we obviously have some signatures so submit them
            $r = defensio_submit_ham($defensio_conf, $signatures);
            $GLOBALS['defensio_result_message'] .= 'Reported ' . $counter . ' comments as HAM to Defensio.';
            if ($counter_no_signature > 0) {
                $GLOBALS['defensio_result_message'] .= 'However, ' . $counter_no_signature . 'comments could not be reported.';
            }
        } else {
            $GLOBALS['defensio_result_message'] .= 'Could not report ' . $counter_no_signature . ' comments as HAM to Defensio.';
        }
        $GLOBALS['defensio_result_message'] .= '</div>';
    } else {
        $GLOBALS['defensio_result_message'] = '<div class="jcaption confirm">You must select at least one comment.</div>';
    }
}