/** * Retourne un tableau des identifiants des vedettes contenant l'élément * @param int $element_id Identifiant en base de l'élément * @param string $element_type Type de l'élément * * @return array Tableau des identifiants des vedettes */ public static function get_vedettes_built_with_element($element_id, $element_type) { global $dbh; $vedettes_id = array(); $query = "select distinct grammar from vedette"; $result = pmb_mysql_query($query, $dbh); if ($result && pmb_mysql_num_rows($result)) { while ($row = pmb_mysql_fetch_object($result)) { $vedette = new vedette_composee(0, $row->grammar); // On récupère l'identifiant lié au type d'élément foreach ($vedette->get_available_fields() as $key => $field) { if ($field["type"] == $element_type) { $element_type_num = $field["num"]; break; } } // On va chercher en base les vedettes contenant cet élément $query = "select distinct num_vedette from vedette_object inner join vedette on num_vedette = id_vedette where object_id = " . $element_id . " and object_type = " . $element_type_num . " and grammar = " . $row->grammar; $result2 = pmb_mysql_query($query, $dbh); if ($result2 && pmb_mysql_num_rows($result2)) { while ($row2 = pmb_mysql_fetch_object($result2)) { $vedettes_id[] = $row2->num_vedette; } } } } return $vedettes_id; }