April, 2009

Remove duplicate nodes (dedupe) based on title.

Tue, 04/28/2009 - 16:34 — Robert Douglass

Here is a function that will remove all duplicate nodes (based on title) for a certain content type. It keeps the most recent one.

<?php
function dedupe($type) {
  $previous = array();
  $result = db_query("SELECT nid, title FROM {node} 
    WHERE title IN 
      (SELECT title FROM {node} 
        WHERE type = '%s' 
        GROUP BY title HAVING count(*) > 1) 
    ORDER BY title, created DESC", $type);
  while ($row = db_fetch_array($result)) {
    if ($row['title'] == $previous['title']) {
      node_delete($previous['nid']);
    }
    $previous = $row;
  }
}
?>

7 comments

Danjulo Ishizaka and Markus Schirmer, Debussy

Sat, 04/25/2009 - 21:44 — Robert Douglass

Add new comment

Commit 202532 by robertDouglass

Commit #202532 by robertDouglass at 11:02
Advanced Help Injection and Export: /modules/helpinject/helpinject.admin.inc 1.1Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.23
#428630 (first pass) let admin exclude form ids from help inject.

Commit 202528 by robertDouglass

Commit #202528 by robertDouglass at 10:19
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.22
Adding 'weight' to the list of excluded form elements.

Commit 202522 by robertDouglass

Commit #202522 by robertDouglass at 09:39
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.21
#444568 more strictly limit the set of form elements on which inject icons appear.

Commit 202520 by robertDouglass

Commit #202520 by robertDouglass at 09:32
Advanced Help Injection and Export: /modules/helpinject/helpinject.css 1.2

Danjulo Ishizaka and Markus Schirmer, Germany Tour

Sat, 04/25/2009 - 01:16 — Robert Douglass

Danjulo has been taking yoga lessons and is pleased with the positive affects on his playing. Sports and music DO mix.

Commit 202338 by robertDouglass

Commit #202338 by robertDouglass at 22:07
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.19
#433994 by tirsales - pass by reference is deprecated. pass by reference is deprecated. pass by references is .... you'd think I'd learn this :P

April 21st, 2009 - Cotton aloha shirt, origin unknown

About my shirt
Brand:

Unknown - label removed

Material:

Cotton, flat weave

Pattern, description, colors:

Red/pink and orange/yellow hbiscus blossoms, variegated leaves and fronds in green/brown/white/mustard on a pale yellow background

Commit 198650 by robertDouglass

Commit #198650 by robertDouglass at 15:09
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.18
HelpInject now supports translated help. If you use the content translation module to translate your book pages into multiple languages, you can export an Advanced Help compatible module and help texts that include all of the translation.

Commit 198600 by robertDouglass

Commit #198600 by robertDouglass at 11:08
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.17
Performance tune the generated module by not including code for forms if no forms have help, and the same with hook_help.

Commit 198588 by robertDouglass

Commit #198588 by robertDouglass at 09:16
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.16
Eliminate warning on export if no files

April 15th, 2009 - Tori Richard silk aloha shirt

Spring hath sprung.
I have broken the seals on my shirt collection ... I wonder if I can wear them all this year before it gets cold again ... you never know with German weather. A couple trips to Italy and Spain should increase the number of usefully warm days available to me.
Project description: Go through all shirts in my possession. Wear one each day that is warm enough, no repeats until all have been worn. Scan, present ... what about the ones I can't wear? We'll cross that bridge when we come to it, I guess.

Danjulo Ishizaka and Martin Helmchen - Debut CD on Sony | RobsHouse.net

Danjulo should acquaint himself with this sound and insist all ... Playbill Arts: Playbill Listing Detail: Danjulo Ishizaka and José Gallardo. Danjulo Ishizaka ...

Commit 194130 by robertDouglass

Commit #194130 by robertDouglass at 21:32
Advanced Help Injection and Export: /modules/helpinject/helpinject.module 1.15
#416068 by CrashTest_: Link to node/add from the inject page, complete with destination and lightbox2 integration, so that you can add new books to the book structure within the workflow of injecting.

Understanding the ApacheSolr CCK API

Tue, 04/07/2009 - 19:52 — Robert Douglass

In this article I will show you how you can write a tiny bit of code that will reveal new fields and facets for searching with the ApacheSolr module and Acquia Search. Using Acquia Drupal we’ll write an example module that takes the file type from CCK file and image fields and makes them into their own search fields. This results in us being able to filter our search results based on file type. This code fulfils the situation where you want, for example, to find a specific post that has a JPEG image, or all of the posts with PDFs that match a particular keyword.

RobsHouse.net