Unpublish node based on field option

Question

Is there a way to unpublish a node if a user selects an option from a select list in field?

I have a field that has a list of cities. What I would like is if the user selects a certain city like London for example, the node is automatically unpublished so it can be moderated.

I have been trying with rules but every time I test my rule nothing happens so I'm sure there is something wrong with my rule or maybe there is an easier approach?

Answer 1

You could also hook on hook_node_presave() and check here the value of the field... No ?

mymodule_node_presave($node) {
if($node->yourfield[.....]['value'] == 'London') {
$node->state = '0';
}
}

Answer 2

Did you test first to see if the "Entity has field" before doing the "Data comparison"?

When comparing fields it is necessary to first check that the entity has the field for Rules to pick them up. When comparing basic node attributes like Content Type you can omit this step.

Here's an example...

Answer 3

That can be done with some code in a custom module...

In the example below I'm assuming your content type is called article, and articles have a field called category, and when the category is Javascript then we unpublish the node.

First we need to modify the node form and add a new submit handler that fire after the one that saves the node (the order here is important):

function YOUR_MODULE_NAME_form_alter(&$form, &$form_state, $form_id) {
    if($form_id=='article_node_form') {
        $form['actions']['submit']['#submit'][] = 'article_node_form_custom_submit';
    }
}

Now we need to define our custom form submit handler:

function article_node_form_custom_submit($form, &$form_state) {
    // check if the category is Javascript
    if($form_state['values']['field_category']['und'][0]['value']=='Javascript') {
        // load the node
        $node = node_load($form_state['values']['nid']);
        // set the status to 0 to unpublish it
        $node->status = 0;
        // save the node
        node_save($node);
        // set a message to say what we've done
        drupal_set_message($node->title.' has been unpublished as the category was set to Javascript.');
    }
}

And that's all there is to it :)