1 ) redirectError(); logItem( $peId, TYPE_CONSULTATION_PERSONNE, $from ); $peId = null;$typePers = null;$nom = null;$prenom = null;$datenaiss = null;$datedeces = null;$age = null;$nation = null;$medId = null;$urlFan = null;$desc = null;$sexe = null;$nb_film = null;$moy_NoteFilm = null;$moy_Boxoffice = null; $peId = $recordsInfosForArtiste[0]["peId"]; $typePers = $recordsInfosForArtiste[0]["peType"]; $nom = $recordsInfosForArtiste[0]["peNom"]; $prenom = $recordsInfosForArtiste[0]["pePrenom"]; $datenaiss = $recordsInfosForArtiste[0]["peDatenaiss"]; $datedeces = $recordsInfosForArtiste[0]["peDatedeces"]; $age = $recordsInfosForArtiste[0]["age"]; $nation = $recordsInfosForArtiste[0]["peNationalite"]; $medId = $recordsInfosForArtiste[0]["mpMedId"]; $urlFan = $recordsInfosForArtiste[0]["peURL"]; $desc = $recordsInfosForArtiste[0]["peDesc"]; $sexe = $recordsInfosForArtiste[0]["peSexe"]; $nb_film = $recordsInfosForArtiste[0]["peNb_film"]; $moy_NoteFilm = $recordsInfosForArtiste[0]["peMoy_NoteFilm"]; $moy_Boxoffice = $recordsInfosForArtiste[0]["peMoy_Boxoffice"]; $nb_avis = $recordsInfosForArtiste[0]["peNbAvis"]; $recordsInfosForArtiste = null; $label = $prenom." ".strtoupper( $nom ); $bActeur = isActeur( $typePers ); $bReal = isReal( $typePers ); // Nb de consultation de la ladite fiche $query = " SELECT nbNow, progression, pourcentage FROM _synthese_consultation WHERE id = $peId AND type = ".TYPE_CONSULTATION_PERSONNE; $rs = $dbh -> do_query( $query ); list( $nb_consult, $progression, $pourcentage ) = $dbh -> fetch_array( $rs ); $dbh -> finish_sth( $rs ); $recordsFilmsForActeur = getRecordsFilmsForActeur( $peId ); $recordsFilmsForReal = getRecordsFilmsForReal( $peId ); $nbFilmActeur = sizeof( $recordsFilmsForActeur ); $nbFilmReal = sizeof( $recordsFilmsForReal ); $querySalaire = " SELECT rewriterules, titre, annee, saValeur, saDevise FROM salaire INNER JOIN film ON saFiId = id WHERE saPeId = $peId "; $queryHappyBirthday = " SELECT p2.peId, p2.peNom, p2.pePrenom, CASE WHEN p2.peDatedeces IS NOT NULL THEN NULL ELSE DATE_FORMAT( FROM_DAYS( TO_DAYS( NOW() ) - TO_DAYS( p2.peDatenaiss ) ), '%y' ) END AS age FROM personne p1 INNER JOIN personne p2 ON ( MONTH ( p1.peDatenaiss ) = MONTH ( p2.peDatenaiss ) AND DAYOFMONTH( p1.peDatenaiss ) = DAYOFMONTH( p2.peDatenaiss ) ) WHERE p1.peId = $peId AND p2.peId <> $peId AND MONTH ( p1.peDatenaiss ) > 0 ORDER BY p2.peNom, p2.pePrenom "; $queryOftenWorkWith = " SELECT fp2.fpIdpers, COALESCE(CONCAT(pePrenom, ' ', UPPER(peNom)), UPPER(peNom)), COUNT(fp2.fpIdpers) AS nb FROM _film_personne fp1 INNER JOIN _film_personne fp2 ON fp1.fpIdfilm = fp2.fpIdfilm INNER JOIN personne ON fp2.fpIdpers = peId WHERE fp1.fpIdpers = ".$peId." AND fp2.fpIdpers <> ".$peId." GROUP BY fp2.fpIdpers, peNom ORDER BY nb DESC, peNom ASC LIMIT 0, 11 "; $queryConnectedPersonne = " ( SELECT peId, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ), peNom, pePrenom, pcDesc FROM personne_connexion INNER JOIN personne ON peId = pcPe1Id WHERE pcPe2Id = $peId ) UNION ( SELECT peId, COALESCE( CONCAT( pePrenom, ' ', UPPER( peNom ) ), UPPER( peNom ) ), peNom, pePrenom, pcDesc FROM personne_connexion INNER JOIN personne ON peId = pcPe2Id WHERE pcPe1Id = $peId ) ORDER BY peNom ASC, pePrenom ASC "; PutHtmlHeader( $label ); ?>
"; PutMAJPersonne(); echo "
"; PutTopFilm(); echo "
"; PutDossierALaLoupe(); ?>

Fiche consultée fois