/[eiffelstudio]/trunk/Documentation/tools/web/trunk/drupal/sites/all/modules/isedoc/isedoc.lib.inc
ViewVC logotype

Diff of /trunk/Documentation/tools/web/trunk/drupal/sites/all/modules/isedoc/isedoc.lib.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 74849 by jfiat, Fri Sep 26 11:47:11 2008 UTC revision 74850 by jfiat, Fri Sep 26 17:38:58 2008 UTC
# Line 170  function isedoc_node_ids_by_uuid($uuid) Line 170  function isedoc_node_ids_by_uuid($uuid)
170    
171  function isedoc_pages_referencing_image($a_title) {  function isedoc_pages_referencing_image($a_title) {
172          $l_body_filter = 'REGEXP \'[[.[.]][[.[.]]Image:[:blank:]*'.strtolower($a_title).'[:blank:]*([[.|.]]|[[.].]][[.].]])\'';          $l_body_filter = 'REGEXP \'[[.[.]][[.[.]]Image:[:blank:]*'.strtolower($a_title).'[:blank:]*([[.|.]]|[[.].]][[.].]])\'';
173          $sql = "SELECT n.nid, n.title, n.vid FROM {node} n INNER JOIN {node_revisions} r ON n.nid = r.nid AND n.vid = r.vid WHERE LOWER(r.body) $l_body_filter ";          $sql = "SELECT n.nid, n.title, n.vid FROM {node} n INNER JOIN {node_revisions} r ON n.nid = r.nid AND n.vid = r.vid WHERE n.type = 'doc' AND LOWER(r.body) $l_body_filter ";
174          $sql .= " ORDER BY n.nid, n.vid ";          $sql .= " ORDER BY n.nid, n.vid ";
175          $res = db_query($sql);          $res = db_query($sql);
176          $result = array();          $result = array();

Legend:
Removed from v.74849  
changed lines
  Added in v.74850

  ViewVC Help
Powered by ViewVC 1.1.23