PhpMyNewsLetter 2.0

function UpdateEmailError($cnx , $table_email , $list_id , $email , $status , $type , $categorie ,
                          $short_desc , $long_desc , $campaign_id , $table_email_deleted , $table_send , $hash){
    $rHash = @current($cnx->query("SELECT hash 
                                    FROM ".$table_email." 
                                        WHERE list_id='".($cnx->CleanInput($list_id))."' 
                                            AND email='".($cnx->CleanInput($email))."'
                                            AND hash='".($cnx->CleanInput($hash))."'
                                            ")->fetch());
    if($hash == $rHash){
        if ($cnx->query("INSERT IGNORE INTO ".$table_email_deleted." (id,email,list_id,hash,error,status,type,categorie,short_desc,long_desc,campaign_id)
                            SELECT id,email,list_id,hash,'Y','".($cnx->CleanInput($status))."','".($cnx->CleanInput($type))."',
                                    '".($cnx->CleanInput($categorie))."','".($cnx->CleanInput($short_desc))."',
                                    '".($cnx->CleanInput($long_desc))."','".($cnx->CleanInput($campaign_id))."'
                                FROM ".$table_email."
                                    WHERE email = '" . ($cnx->CleanInput($email)) . "'
                                       AND hash = '" . ($cnx->CleanInput($hash)) . "'")){
            if ($cnx->query("DELETE FROM ".$table_email." 
                                WHERE email='" . ($cnx->CleanInput($email)) . "'
                                   AND hash = '" . ($cnx->CleanInput($hash)) . "'")) {
                if ($cnx->query("UPDATE ".$table_send ."
                                    SET error=error+1 
                                        WHERE id_mail='".($cnx->CleanInput($campaign_id))."'")){
                    return true;
                } else {
                    return false;
                }
            } else {
                return false;
            }
        } else {
            return false;
        }
    }
}