tid; $first = false; } $duplicate_tids[] = $duplicate->tid; print "duplicate tid: ".$duplicate->tid."
"; } print "
"; // 2) retrieve all node ids that are tagged with these duplicates $result = db_query('SELECT * FROM term_node tn WHERE tn.tid IN (%s) GROUP BY tn.nid', implode(', ', $duplicate_tids)); // 3) delete all entries in term_node for duplicates db_query('DELETE FROM term_node WHERE tid IN (%s)', implode(', ', $duplicate_tids)); // 4) delete all duplicates from term_data, except original db_query('DELETE FROM term_data WHERE tid IN (%s) AND tid != %d', implode(', ', $duplicate_tids), $original_tid); // 5) insert only one term_node entry per node to original tid while ($n = db_fetch_object($result)) { db_query('INSERT INTO term_node(tid, nid) VALUES (%d, %d)', $original_tid, $n->nid); print "updated node: ".$n->nid."
"; } ?>