By tejasdarji on
We are having one master site which works like, if node is added in master site it will be added in different sub-sites too. Want to do the same for deleting a node and have an issue that master site node gets deleted before sub-site node.
I am having an issue in deleting a node of the sub-site from the database i.e database1 while node is deleted from the master database i.e database0.
if ((($op=="delete")) && ($node->type=="page")) {
// if(is_array($node->field_checkbox_value)){
foreach($node->field_checkbox_value as $cbs) {
if($cbs['value'] > 0) {
if ($cbs==1) {
$db='co1';
}
if($cbs['value']==2)
{
$db='co2';
}
if($cbs['value']==3)
{
$db='co3';
}
$node->nid;
$tempnid=$node->nid;
//print $tempnid;
$coid = db_fetch_object(db_query("SELECT field_corporate_news_id_value FROM content_type_page where nid=$tempnid"));
$coid = $coid->field_corporate_news_id_value;
print $coid;
$k = db_set_active($db);
if (db_is_active()) {
//db_insert('node');
$cnid = db_fetch_object(db_query("SELECT nid,field_corporate_news_id_value FROM content_type_page where content_type_page.field_corporate_news_id_value=$coid "));
$cnid = $cnid->nid;
print $cnid;
db_query("DELETE FROM node WHERE nid =$cnid ");
db_query("DELETE FROM node_revisions WHERE nid=$cnid");
db_query("DELETE FROM url_alias WHERE src='node/$cnid' ");
db_query("DELETE FROM content_type_page WHERE nid=$cnid ");
$x = db_set_active('default');
}
}
}
//}
}