--- ../../../voipdrupal-source/modules/voipscriptui/voipscriptui.module 2012-04-16 15:24:08.000000000 +0000
+++ voipscriptui.module 2012-04-19 17:01:32.000000000 +0000
@@ -11,15 +11,18 @@
 
   //Create the Sql query. This uses various parts of Drupal 7's new DBTNG database abstraction layer.
   //$query = db_select('node', n.title FROM {node} n WHERE n.type = :n.type and n.status = :n.status', array(':n.type' => "voipscriptui", ':n.status' => 1));
-  $query = db_select('node', 'n')
-    ->join('title', 'n', ':n.type = voipscriptui :n.status = 1', array(':n.type' => "voipscriptui", ':n.status' => 1));
+  $query = db_select('node', 'n');
+  $query
+    ->fields('n')
+    ->condition('n.type', 'voipscriptui')
+    ->condition('n.status', '1');
+
   $result = $query->execute();
 
   // @todo Drupal 7 update BWM THIS ISN'T WORKING YET. NEED TO MERGE $query into $result
   foreach ($result as $node) {
     $script_names[] = $node->title;
   }
-
   return $script_names;
 }
 
@@ -193,7 +196,6 @@
       'field' => 'clone',
     );
   }
-
   // get voipscriptui scripts
   $res = db_query("SELECT nid, title FROM {node} WHERE type = :type", array(':type' => 'voipscriptui'));
   foreach ($res as $script_ui) {