';
// branche("".display("Groupe","Band")."",
// "nom_groupe").">$album->nom_groupe",
// "nom_groupe&nom_album=$album->nom_album_ref").">$album->nom_album",
// "".display("Liste des vote","Rates' list")."");
// $album->affiche_min();
filters('');
echo '
';
echo '
'.$album->nom_groupe." : ".$album->nom_album." - ".$txt_ListeVote[0].'
';
// $membre = new membre($_SESSION['login']);
if(isset($_GET['p']))
$page=(int)$_GET['p'];
else
$page=1;
$next_page=$page+1;
$max_result=100;
$start=($page-1)*$max_result;
if(isset($_GET['sort']))
{
$stmt = $db_PDO->prepare("SELECT V.*,M.chroniqueur,M.avatar FROM `vote_album` V INNER JOIN membres M ON V.pseudo=M.pseudo
WHERE id_album=:id_album ORDER BY note ASC LIMIT $start,$max_result");
$stmt->bindValue(':id_album', $album->id_album, PDO::PARAM_INT);
$stmt->execute();
if($stmt->RowCount()==$max_result) ///we assume there is more to load
echo '';
}
else if(isset($_GET['officiel']))
{
$stmt = $db_PDO->prepare("SELECT V.*,M.chroniqueur,M.avatar FROM `vote_album` V INNER JOIN membres M ON V.pseudo=M.pseudo
WHERE id_album=:id_album AND (M.chroniqueur=1 || M.chroniqueur=2) ORDER BY pseudo");
// $stmt->bindValue(':pseudo', "$pseudosearch%", PDO::PARAM_STR);
$stmt->bindValue(':id_album', $album->id_album, PDO::PARAM_INT);
$stmt->execute();
// if($stmt->RowCount()==$max_result) ///we assume there is more to load
// echo '';
}
else if(isset($_GET['friends']))
{
if($_SESSION['login'])
{
$stmt = $db_PDO->prepare("SELECT V.*,M.avatar FROM `vote_album` V INNER JOIN membres M ON V.pseudo=M.pseudo
INNER JOIN membres_amis A ON pseudo1=:MyPseudo and pseudo2=V.pseudo
WHERE id_album=:id_album AND A.type=1 AND M.pseudo!=:MyPseudo2 ORDER BY pseudo");
$stmt->bindValue(':id_album', $album->id_album, PDO::PARAM_INT);
$stmt->bindValue(':MyPseudo', $_SESSION['login'], PDO::PARAM_STR);
$stmt->bindValue(':MyPseudo2', $_SESSION['login'], PDO::PARAM_STR);
$stmt->execute();
}
else
echo '';
}
else if(!empty($_GET['pseudosearch']))
{
$stmt = $db_PDO->prepare("SELECT V.*,M.chroniqueur,M.avatar FROM `vote_album` V INNER JOIN membres M ON V.pseudo=M.pseudo
WHERE id_album=:id_album AND M.pseudo LIKE :pseudo ORDER BY pseudo LIMIT $start,$max_result");
$stmt->bindValue(':pseudo', "$pseudosearch%", PDO::PARAM_STR);
$stmt->bindValue(':id_album', $album->id_album, PDO::PARAM_INT);
$stmt->execute();
if($stmt->RowCount()==$max_result) ///we assume there is more to load
echo '';
}
else
{
$stmt = $db_PDO->prepare("SELECT V.*,M.chroniqueur,M.avatar FROM `vote_album` V INNER JOIN membres M ON V.pseudo=M.pseudo
WHERE id_album=:id_album ORDER BY note DESC LIMIT $start,$max_result");
$stmt->bindValue(':id_album', $album->id_album, PDO::PARAM_INT);
$stmt->execute();
if($stmt->RowCount()==$max_result) ///we assume there is more to load
echo '';
}
$rows = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach($rows as $ligne)
{
extract($ligne);
// $nb_note++;
// $total+=$note;
// if($chroniqueur>0)
// echo "";
// else
echo '';
// if($chroniqueur>0)
// echo "
";
/*
echo "$pseudo : ";
if($_SESSION['login']==$pseudo)
echo " $note ";
else
echo " $note ";
echo "$ratingcomment";
if( ($pseudo==$_SESSION['login']) || $membre->cercle==1)
echo "
![](\"mes%20images/b_drop.png\")
";
else
echo " ";
echo ""; */
}
if($stmt->RowCount()==0)
echo $common['noResult'];
// echo '
';
echo '
';
infinitescrollerstatus();
echo ' ";
/*
echo "$pseudo : ";
if($_SESSION['login']==$pseudo)
echo " $note ";
else
echo " $note ";
echo "$ratingcomment";
if( ($pseudo==$_SESSION['login']) || $membre->cercle==1)
echo "
";
else
echo " ";
echo ""; */
}
if($stmt->RowCount()==0)
echo $common['noResult'];
// echo '| '.$txt_ListeVote[1].' |