Changeset 9262

Timestamp:

03/17/10 09:56:16 (2 years ago)

Author:

p_lindheimer

Message:

add versions of deprecated core_routing functions to tables.php for migrations from tarball type installs

Files:

• freepbx/trunk/upgrades/2.8.0alpha1/tables.php (modified) (3 diffs)

freepbx/trunk/upgrades/2.8.0alpha1/tables.php

@@ -84 +84 @@
-        out("ok");
-
-
+__
-
-        $routes = array();
@@ -94 +94 @@
-          $accum[] = substr($extdisplay,4);
-  
-
+__
-          $accum[] = $routecid_array['routecid'];
-          $accum[] = $routecid_array['routecid_mode'];
-
-
-
-
-
-
-
-
+__
+__
+__
+__
+
+__
+__
-
-          $routes[$extdisplay] = $accum;
@@ -192 +192 @@
-  }
-}
+
+//----------  DEPRECATED functions added here so installs work from tarball --------------
+
+function __core_routing_getroutenames() 
+{
+  global $amp_conf;
+  
+  if ($amp_conf["AMPDBENGINE"] == "sqlite3") 
+  {
+    $results = sql("SELECT DISTINCT context FROM extensions WHERE context LIKE 'outrt-%' ORDER BY context ","getAll");
+    foreach( array_keys($results) as $idx )
+    {
+       $results[$idx][0] = substr( $results[$idx][0], 6);
+    }
+  }
+  else
+  {
+    $results = sql("SELECT DISTINCT SUBSTRING(context,7) FROM extensions WHERE context LIKE 'outrt-%' ORDER BY context ","getAll");
+  }
+  return $results;
+}
+function __core_routing_getroutecid($route) {
+  global $db;
+
+  $sql = "SELECT DISTINCT args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'ROUTECID%' OR args LIKE 'EXTEN_ROUTE_CID%') ";
+  $results = $db->getOne($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  if (preg_match('/^(.*)=(.*)/', $results, $matches)) {
+    $routecid = $matches[2];
+    $routecid_mode = $matches[1] == 'ROUTECID' ? 'override_extension':'';
+  } else {
+    $routecid = '';
+    $routecid_mode = '';
+  }
+  return array('routecid' => $routecid, 'routecid_mode' => $routecid_mode);
+}
+function __core_routing_getroutepassword($route) {
+  global $db;
+  $sql = "SELECT DISTINCT args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'dialout-trunk,%' OR args LIKE 'dialout-enum,%' OR args LIKE 'dialout-dundi,%') ORDER BY CAST(priority as UNSIGNED) ";
+  $results = $db->getOne($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  if (preg_match('/^.*,.*,.*,(\d+|\/\S+)/', $results, $matches)) {
+    $password = $matches[1];
+  } else {
+    $password = "";
+  }
+  return $password;
+}
+function __core_routing_getrouteemergency($route) {
+  global $db;
+  $sql = "SELECT DISTINCT args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'EMERGENCYROUTE%') ";
+  $results = $db->getOne($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  if (preg_match('/^.*=(.*)/', $results, $matches)) {
+    $emergency = $matches[1];
+  } else {
+    $emergency = "";
+  }
+  return $emergency;
+}
+function __core_routing_getrouteintracompany($route) {
+  global $db;
+  $sql = "SELECT DISTINCT args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'INTRACOMPANYROUTE%') ";
+  $results = $db->getOne($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  if (preg_match('/^.*=(.*)/', $results, $matches)) {
+    $intracompany = $matches[1];
+  } else {
+    $intracompany = "";
+  }
+  return $intracompany;
+}
+function __core_routing_getroutemohsilence($route) {
+  global $db;
+  $sql = "SELECT DISTINCT args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'MOHCLASS%') ";
+  $results = $db->getOne($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  if (preg_match('/^.*=(.*)/', $results, $matches)) {
+    $mohsilence = $matches[1];
+  } else {
+    $mohsilence = "";
+  }
+  return $mohsilence;
+}
+function __core_routing_getroutepatterns($route) {
+  global $db;
+  $sql = "SELECT extension, args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'dialout-trunk%' OR args LIKE 'dialout-enum%' OR args LIKE 'dialout-dundi%') ORDER BY extension ";
+  $results = $db->getAll($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  
+  $patterns = array();
+  foreach ($results as $row) {
+    if ($row[0][0] == "_") {
+      // remove leading _
+      $pattern = substr($row[0],1);
+    } else {
+      $pattern = $row[0];
+    }
+    
+    if (preg_match("/{EXTEN:(\d+)}/", $row[1], $matches)) {
+      // this has a digit offset, we need to insert a |
+      $pattern = substr($pattern,0,$matches[1])."|".substr($pattern,$matches[1]);
+    }
+    
+    $patterns[] = $pattern;
+  }
+  return array_unique($patterns);
+}
+function __core_routing_getroutetrunks($route) {
+  global $db;
+  $sql = "SELECT DISTINCT args FROM extensions WHERE context = 'outrt-".$route."' AND (args LIKE 'dialout-trunk,%' OR args LIKE 'dialout-enum,%' OR args LIKE 'dialout-dundi,%') ORDER BY CAST(priority as UNSIGNED) ";
+  $results = $db->getAll($sql);
+  if(DB::IsError($results)) {
+    die_freepbx($results->getMessage());
+  }
+  $trunks = array();
+  foreach ($results as $row) {
+    if (preg_match('/^dialout-trunk,(\d+)/', $row[0], $matches)) {
+      // check in_array -- even though we did distinct
+      // we still might get ${EXTEN} and ${EXTEN:1} if they used | to split a pattern
+      if (!in_array("OUT_".$matches[1], $trunks)) {
+        $trunks[] = "OUT_".$matches[1];
+      }
+    } else if (preg_match('/^dialout-enum,(\d+)/', $row[0], $matches)) {
+      if (!in_array("OUT_".$matches[1], $trunks)) {
+        $trunks[] = "OUT_".$matches[1];
+      }
+    } else if (preg_match('/^dialout-dundi,(\d+)/', $row[0], $matches)) {
+      if (!in_array("OUT_".$matches[1], $trunks)) {
+        $trunks[] = "OUT_".$matches[1];
+      }
+    }
+  }
+  return $trunks;
+}