/** * 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; }