Alfuv debilnicek

we need remove / delete all articles from database. all old articles in database was only testing purposes

i mean articles as class like article, u can remove any node from tree

include "some_db_layer";

$q = "
SELECT node_id
FROM `ezcontentobject`
LEFT JOIN ezcontentobject_tree ON `ezcontentobject`.id = ezcontentobject_tree.contentobject_id
WHERE `contentclass_id` = 2 AND node_id IS NOT NULL
";
//contentclass_id` = 2 is our id for articles
$res = $db->fetch_all($q);

foreach ( $res as $value) {
$rootNode = eZContentObjectTreeNode::fetch( $value['node_id'] );
//delete, realy delete records from dbase,
$rootNode->removeNodeFromTree(false);
}

This entry was posted on Sunday, March 29th, 2009 at 6:55 pm and is filed under Coding, php. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.