/**
* Interfaces eZDB::arrayQuery
* @param string $sql
* @return array|boolean
*/
public static function arrayQuery($sql)
{
if (!is_null(self::$db))
{
XMLImportMonitor::log($sql, 'sql');
return self::$db->arrayQuery($sql);
}
return false;
}
/**
* @param eZMySQLiDB $db
* @return array
*/
function getRelations( $db )
{
$paths = array();
$query = "SELECT
pf.id AS pfid, pf.path AS path, al.cluster_identifier AS cluster
FROM
mm_application_has_publisher_folder AS ahpf
LEFT JOIN
mm_publisher_folder AS pf ON ahpf.publisher_folder_id = pf.id,
mm_application_localized AS al
WHERE
ahpf.application_localized_id
IN
(SELECT id FROM mm_application_localized WHERE cluster_identifier IN ('" . implode( '\', \'', ClusterTool::globCluster() ) . "'))
AND
ahpf.application_localized_id = al.id
ORDER BY
cluster, pf.id";
foreach ( $db->arrayQuery( sprintf( $query ) ) as $row )
$paths[$row['cluster']][$row['pfid']] = $row['path'];
return $paths;
}
