Ticket #2778: sqlite_trunk_query

Replace a complex query that doesn't work with two simpler ones and a
bit of PHP code.

Upstream issue: http://freepbx.org/trac/ticket/2778

--- trunk.orig/modules/core/functions.inc.php
+++ trunk/modules/core/functions.inc.php
@@ -1802,20 +1802,9 @@ function core_trunks_list($assoc = false
        
        if ($amp_conf["AMPDBENGINE"] == "sqlite3")
        {
-               // TODO: sqlite work arround - diego
-               // TODO: WILL NOT WORK, need to remove the usage of SUBSTRING
-               // need to reorder the trunks in PHP code
-               $sqlstr  = "SELECT t.variable, t.value, d.value state FROM `globals` t ";
-               $sqlstr .= "JOIN (SELECT x.variable, x.value FROM globals x WHERE x.variable LIKE 'OUTDISABLE\_%') d ";
-               $sqlstr .= "ON substring(t.variable,5) = substring(d.variable,12) WHERE t.variable LIKE 'OUT\_%' ";
-               $sqlstr .= "UNION ALL ";
-               $sqlstr .= "SELECT v.variable, v.value, concat(substring(v.value,1,0),'off') state  FROM `globals` v ";
-               $sqlstr .= "WHERE v.variable LIKE 'OUT\_%' AND concat('OUTDISABLE_',substring(v.variable,5)) NOT IN ";
-               $sqlstr .= " ( SELECT variable from globals WHERE variable LIKE 'OUTDISABLE\_%' ) ";
-               $sqlstr .= "ORDER BY variable";
-
-               //$unique_trunks = sql("SELECT * FROM globals WHERE variable LIKE 'OUT_%' ORDER BY variable","getAll"); 
-               $unique_trunks = sql($sqlstr,"getAll"); 
+               $possible_trunks = sql("SELECT * FROM globals WHERE variable LIKE 'OUT_%' ORDER BY variable,value","getAll");
+               $disabled_trunks = sql("SELECT * FROM globals WHERE variable LIKE 'OUTDISABLE_%' ORDER BY variable,value","getAll");
+               $unique_trunks = array_diff($possible_trunks, $disabled_trunks);
        }
        else
        {