hello

sorry for my english :)
and thanks a lot for your module!!!
i am learning your module and i enjoy very much it, though i have much to learn still.
i have been looking in internet for two days but, maybe because my english, i dont find a solution.

i have a type of content that is a magazine and i have a nodereference to all articles to that magazine.
i want to be able to make publish all the articles at once with vbo.
i have created the view following the tutorials but when i publish the articles, what gets changed it is the magazine and not the articles.
the articles get listed but doesnt matter which i choose, it is the parent magazine who gets changed.

is it possible to do this?
any tips are wellcomed :)

Comments

candelas’s picture

candelas commented

after hours (since i am learning php and sql) i found a way and i write it here for people, in case they need it.
i created an "execute custom php" rule and wrote this:


$articulos = $node->field_articulos_secciones; // this is the name of my referenced node

foreach ($articulos as $valor) {

// i updated the status to published
db_query("UPDATE {node} SET `status`=1 WHERE `nid` =" . $valor[nid]); 
// i change the workflow state
db_query("UPDATE {workflow_node} SET `sid`=14 WHERE `nid` =" . $valor[nid]); 

}
unset($valor);
infojunkie’s picture

infojunkie
Location Vancouver
commented
Status: Active » Fixed

Thanks for documenting your solution. You can also use the action "Execute arbitrary PHP script" with something like:

foreach ($object->field_articulos_secciones as $item) {
  $article = node_load($item['nid']);
  $article->status = 1;
  $article->sid = 14; // not sure what the workflow state id is called, check using dsm($article);
  node_save($article);
}
candelas’s picture

candelas commented

@infojunkie: thanks for giving so much of your time to answerd too many of us :)

i read about node_load() before and because other thing, i am using it now.
before changing the code as you tell to me (thanks thanks thanks) one doubt :

what is it faster: to load and save a node or to update the table on the database?
i ask because i do a loop with 10 nodes.

respect to use this in vbo, other doubt:
if i used as a 'Execute arbitrary PHP script', then i have to write the script every time i run it.
so it is better to make a rule set and in vbo assing it to the view, isnt it?

2 more websites and i'll be flighing with vbo :)

infojunkie’s picture

infojunkie
Location Vancouver
commented

Re: concern #1, for sure manipulating the DB is faster but then you lose all the associated functionality that 3rd party modules might be doing, e.g. rules firing on node publishing.

Re: concern #2, you can create an advanced action (admin/settings/actions/manage > Make a new advanced action available > Execute arbitrary PHP script) and save the script in this new action. You then go back to VBO style settings, select this new action and it will appear in the drop down.

Hope this helps!

candelas’s picture

candelas commented

:)
thanks again!

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.