Moving Objects via PHP & Cron

Friday 11 June 2004 8:59:03 am

Hi Alex,

I have such a framework script. :) It's pretty basic but it should do what you want to do. How can I send it to you?

--
Hans

Hans
http://blog.hansmelis.be

Friday 11 June 2004 9:26:51 am

Hans, that would be extremely helpful, thank you! I can be reached at 'alexj' at 'agrussell.com'.

Thank you so much!

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Friday 11 June 2004 9:42:51 am

That's great Hans. :) I will try it out right after lunch.

Again, thank you for such a speedy response.

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Friday 11 June 2004 11:46:29 am

I've started working with the framework Hans was kind enough to provide, but I am running into a problem. I went through and defined the node IDs as noted in the directions in the file and added a couple of <i>cli</i> calls to monitor via the command line. But the script doesn't appear to be executing properly. Specifically, the foreach loop isn't kicked off. I also commented out the move command as I do not have it all set up as it should be. Below is the script as I currently have it, can anyone point out what is wrong?

include_once( 'kernel/classes/ezcontentobjecttreenode.php' );
include_once( 'kernel/classes/ezcontentobject.php' );
include_once( 'lib/ezutils/classes/ezcli.php' );

$cli =& eZCLI::instance();

$parentNodeID = '186';
$newParentNodeID = '650';
$attribIdentifier = 'price';

// This is an array that contains all fetch parameters (like in templates), except the parent's nodeid.
// Leave empty for default fetch
$params = array();

$childNodes =& eZContentObjectTreeNode::subTree( $params, $parentNodeID );

$inc = 0;
foreach( $childNodes as $child )
{
  $inc++;
  $cli->output( '-- In foreach --');
  $childObj = $child->attribute( 'object' );
  $objData = $childObj->dataMap();

  $value = $objData[$attribIdentifier]->content();
	
  $doMove = false;

  // Insert code to check $value, set $doMove to true if this objects needs to be moved
  if( $doMove === true )
    {
    //$cli->output( '$child->move( ' . $newParentNodeID . ' );');
    }
  $cli->output( $inc );
}

I've double-checked the supplied Node IDs, so I know they are right. I'm sure I am missing something obvious, but I'm willing to kick myself to get through this. ;)

Thanks again,

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Friday 11 June 2004 12:05:19 pm

Thanks for the speedy reply. But that still doesn't kick off the <i>foreach</i> loop. :( Any other ideas perchance?

FYI, I'm trying this on a 3.3-3 install.

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Friday 11 June 2004 12:28:47 pm

They have read access to that folder and the class of items I need to change.

Alex

EDIT: Oh, alright. Thanks :)

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Friday 11 June 2004 12:53:16 pm

Thanks Hans, I appreciate your help. I have set the two Node IDs to integers once more and I cleared the caches, but neither seemed to make a difference. :( This seems like it should be pretty straight-forward, which makes it all the more confusing. Perhaps I should take a break from it and work on something else for a bit.

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Friday 11 June 2004 1:05:43 pm

Well, since you're trying to update ezcontentobject_tree I'm assuming you have the node ID of each node you want to move. In that case, you can do

$node = eZContentObjectTreeNode::fetch( <node_id> );

You also know the node ID of the destination, so you can do

$node->move( <new_node_id> );

That should be enough to move something.

--
Hans

Hans
http://blog.hansmelis.be

Tuesday 15 June 2004 6:53:35 pm

Well I am obviously doing something really wrong as I still can't get this working. Grrrr. Below is my current version of the script. Can anyone see what I may be doing wrong?

<?php

include_once( 'kernel/classes/ezcontentobjecttreenode.php' );
include_once( 'kernel/classes/ezcontentobject.php' );
include_once( 'lib/ezutils/classes/ezcli.php' );
include_once( 'kernel/classes/eznodeassignment.php' );

$parentNodeID = 186;
$newParentNodeID = 650;
// Set up the command line interface.
//
// This allows eZ to set up the PHP session correctly.

$cli =& eZCLI::instance();

$link = mysql_connect('localhost', 'ezpublish', '4es6zH3Ay');
if (!$link) {
   die('Could not connect: ' . mysql_error());
}
mysql_select_db("ez_cuttingedge") or die("Could not select database");
$query = "SELECT * FROM `ezcontentobject_attribute` WHERE `contentclassattribute_id` = 215 AND data_text <> ''";
$result = mysql_query($query) or die("Query failed : " . mysql_error());
echo '[ ' . $query . ' ]' . "\n";
$rollover = '60';
$today = date("Y m d");

while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
  $datestring1 = $line["data_text"];
  $date1 = explode(" ",$datestring1);
  $date2 = explode(" ",$today);
  sprintf($datestring1, "%s%s%s", $date1[0], $date1[1], $date1[2]);
  sprintf($today, "%s%s%s", $date2[0], $date2[2], $date2[2]);
  $dateDiff = mktime(11,0,0,$date2[1],$date2[2],$date2[0]) - mktime(12,0,0,$date1[1],$date1[2],$date1[0]);
  $difference = floor($dateDiff/60/60/24);

  if ($rollover > $difference){
    
  } else {
    $query2 = 'SELECT * FROM ezcontentobject_tree WHERE contentobject_id = ' . $line["contentobject_id"];
    $result2 = mysql_query($query2) or die("Query failed : " . mysql_error());
    while ($line2 = mysql_fetch_array($result2, MYSQL_ASSOC)) {
      $movingNode = $line2["node_id"];
      $node =& eZContentObjectTreeNode::fetch($movingNode);
      $node->move($newParentNodeID);
    }
  }
}

/* Free resultset */
mysql_free_result($result);
mysql_close($link);
?>

I keep getting the error <i>
PHP Fatal error: Call to a member function on a non-object in /x/local/www/cuttingedge.data/ez_upgraded/auto_archive3.php on line 56</i> when I try to run the script. The line in question is <i>$node->move($newParentNodeID);</i>.

Any thoughts?

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>

Wednesday 16 June 2004 7:00:15 am

Hrrrm, I think you are on to something as nothing is output to screen when I echo <i>$node</i> after the line

$node = eZContentObjectTreeNode::fetch($movingNode);

. That line doesn't throw an error though, and the variable <i>$movingNode</i> shows the right value. Note: I changed <i>$node =&</i> to <i>$node =</i> (removing the &) to be consistent with the code in ezcontnentobjecttreenode.php. The fetch query appears to be executing properly. I will add some debugs to the move function shortly, once a content import is finished.

Thanks again!

Alex

Alex
[ bald_technologist on the IRC channel (irc.freenode.net): #eZpublish ]

<i>When in doubt, clear the cache.</i>