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