prepare("SELECT * FROM `groupe` WHERE nom_groupe=?"); $stmt->bindValue(1,$groupe, PDO::PARAM_STR); $stmt->execute(); if($stmt->RowCount()==1) { $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); extract($rows[0]); } */ $stmt = $db_PDO->prepare("SELECT * FROM `biographies` WHERE id_bio=?"); $stmt->bindValue(1,$id_bio, PDO::PARAM_INT); $stmt->execute(); if($stmt->RowCount()==1) { $rows = $stmt->fetchAll(PDO::FETCH_ASSOC); extract($rows[0]); $groupe=new groupe($id_groupe); } else $id_bio=0; if($groupe->nom_groupe!="" AND $id_bio) define("CURRENT_PAGE",set_current_page_seo("biography",array("groupe"=>clean($groupe->nom_groupe_dir),"id_bio"=>$id_bio),$_GET['l'])); else define("CURRENT_PAGE",set_current_page_seo("",null,$_GET['l'])); echo "$nom_groupe : ".$txt_bio['bio']." - ".SITE_NAME.""; $meta_description['fr']="$nom_groupe : ".$txt_bio['bio']." - ".SITE_NAME.""; $meta_description['en']="$nom_groupe : ".$txt_bio['bio']." - ".SITE_NAME.""; // $meta_keyword['fr']="groupe,$nom_groupe,chroniques,biographie,musique"; // $meta_keyword['en']="band,$nom_groupe,reviews,biography,music"; echo " "; include("styleNEW.htm"); //include("gallery.htm"); ?>
'; // branche("lien\">$nom_groupe",$txt_bio['bio']." $groupe->nom_groupe"); /// validation automatique de la biographie //valid_submission($id_bio,"18a","18b"); } else { MenuVerifAdmin($id_bio,"18a","/soumission/bio_delete.php?id_bio=$id_bio&l=".LANG,"/soumission/submit_bio.php?id_groupe=$id_groupe&l=".LANG); echo '
'; } $groupe->affiche_logo(); echo '

'.$txt_bio['bio']." : ".$groupe->nom_groupe.'

'; if(isset($_SESSION['login'])) { $membre=new membre($_SESSION['login']); $rq2="SELECT pseudo,type FROM `submission_validator` WHERE pseudo='".$_SESSION['login']."' AND (type='18a' || type='18b')"; $res2=mysqli_query($GLOBALS['iconnexion'],$rq2); if(mysqli_num_rows($res2)>0) $allow_deletion=true; else $allow_deletion=false; if($allow_deletion || $membre->cercle==1) { echo ''; } // displayCadreMenu2("lightred",display("P�naliser","Penalize"),display("P�naliser le membre ayant ajout� ces paroles","Penalize the member who added this lyrics"),,"mes%20images/misc/icon_penalize.jpg"); // displayCadreMenu2("lightred",,display("Supprimer completement les paroles de l'album","Remove totaly the lyrics"),","mes%20images/misc/icon_delete.jpg"); } echo '
'; if(is_file("$groupe->dir_groupe/$id_bio-bioutf8.htm")) { $filename="$groupe->dir_groupe/$id_bio-bioutf8.htm"; $handle = fopen ("$filename", "r"); $biographie=fread($handle,filesize ($filename)); } else if(is_file("$groupe->dir_groupe/$id_bio-bio.htm")) { $filename="$groupe->dir_groupe/$id_bio-bio.htm"; if($handle = fopen ("$filename", "r")) { $biographie=fread($handle,filesize ($filename)); if($encoded=="0") { $biographie=encode_biographie($biographie,$lang,$id_groupe); $groupe->ajout_bio($biographie,$lang,true); $rq="UPDATE `biographies` SET encoded='1' WHERE id_bio='$id_bio'"; $res=mysqli_query($GLOBALS['iconnexion'],$rq); } fclose ($handle); if(ENCODING=="UTF-8") { if(!is_file("$groupe->dir_groupe/$id_bio-bioutf8.htm")) { global $conn_id; connect_FTP(); if(!ftp_chdir($conn_id,"les goupes/$groupe->lettre/$groupe->nom_groupe_dir")) { echo "FAILURE : changing band directory
"; exit(); } do { $seed = substr(md5(microtime().getmypid()), 0, 8); $path_to_image = "bio_$seed.htm"; } while (file_exists(DIR_SITE."/temp/$path_to_image")); $dir=getcwd(); chdir(DIR_SITE."/temp"); $biographie=str_replace("�","'",$biographie); $biographie=utf8_encode($biographie); $fp=fopen("$path_to_image","w"); fputs($fp,"$biographie"); fclose($fp); if(!ftp_put($conn_id,$id_bio."-bioutf8.htm","$path_to_image", FTP_ASCII)) echo "failure copy of the bio
"; } $filename="$groupe->dir_groupe/$id_bio-bioutf8.htm"; $handle = fopen ("$filename", "r"); $biographie=fread($handle,filesize ($filename)); } } } if($biographie) { echo $biographie; echo '

'; // include("addthis.php"); } else echo $txt_bio['NoBio']; echo '
'; if(!isset($_GET['VerifAdmin'])) { echo '
'; include("footer.php"); } else { echo "

"; include("soumission/admin2/CheckNew.htm"); } ?>