コード例 #1
0
 /**
  * Interfaces eZDB::escapeString
  * @param  string         $str string to escape
  * @return string|boolean result
  */
 public static function escapeString($str)
 {
     if (!is_null(self::$db))
     {
         return self::$db->escapeString($str);
     }
     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;
}