
en direct
|
|
$mysqlquery = "SELECT id_site,url_news,title_news,date_news FROM actualites ORDER BY date_news DESC LIMIT 0,15";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
while ($row4=mysql_fetch_row($mysqlresult)) {
$id_site = $row4[0];
$url_news = $row4[1];
$title_news = $row4[2];
$date_news = $row4[3];
list($date_news,$heure_news) = explode(" ",$date_news);
$heure_news=substr($heure_news, 0, -3);
$mysqlquery2 = "SELECT * FROM actualites_sites WHERE id_site='".$id_site."'";
$mysqlresult2 = mysql_query($mysqlquery2,$mysqlconnect);
$row2 = mysql_fetch_row($mysqlresult2);
$id_rub = $row2[1];
$mysqlquery1 = "SELECT * FROM actualites_themes WHERE id_rub='".$id_rub."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1 = mysql_fetch_row($mysqlresult1);
$sujet = $row1[1];
?> · = $title_news; ?>
}} else { echo "Le flux est en cours de mise à jour."; } ?>
|
|
afficher toute l'actualité
|

|
|
$i="1";
$mysqlquery_forum = "SELECT id_topic,titre_topic FROM forum_topics ORDER BY date_dernier_post DESC LIMIT 0,5";
$mysqlresult_forum = mysql_query($mysqlquery_forum,$mysqlconnect) or die ('erreur sql ligne '.__LINE__.' ' . mysql_error());
while ($row=mysql_fetch_row($mysqlresult_forum)) {
$id_topic=$row[0];
$titre_topic=$row[1];
$mysqlquery = "SELECT id_post FROM forum_posts WHERE id_topic='".$id_topic."' ORDER BY date_post DESC LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row4=mysql_fetch_row($mysqlresult);
$id_dernier_post=$row4[0];
$select = "SELECT count(id_post) FROM forum_posts WHERE id_topic='".$id_topic."'";
$result = mysql_query($select,$mysqlconnect) or die ('Erreur : '.mysql_error() );
$row = mysql_fetch_row($result);
$total = $row[0];
$page_dernier_post=ceil($total/10);
?>
· = ucfirst($titre_topic); ?>
$i++; if ($i=="3") { $i="1"; } } ?>
|
|
sommaire | écrire un sujet
|
$mysqlquery1 = "SELECT * FROM sondages_sondages WHERE id_rubrique='0' AND actif='oui' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
if(mysql_num_rows($mysqlresult1) > 0) {
$row=mysql_fetch_row($mysqlresult1);
$id_sondage=$row[0];
$date_ajout=$row[1];
$question=$row[2];
$nb_total_reponses_sondage = "SELECT SUM(nb_votes) AS total FROM sondages_reponses WHERE id_sondage='".$id_sondage."'";
$nb_total_reponses_sondage = mysql_query($nb_total_reponses_sondage,$mysqlconnect);
$data = mysql_fetch_array($nb_total_reponses_sondage);
$nb_total_reponses_sondage = $data['total'];
$vote_permis = "oui";
if ($vote_save==$id_sondage) { $vote_permis = "non"; }
if ($_COOKIE["sondage_".$id_sondage]) { $vote_permis = "non"; }
if ($vote_permis=="oui") { ?>
} else { ?>

|
| = $question; ?> |
$i=1;
$mysqlquery1 = "SELECT * FROM sondages_reponses WHERE id_sondage='".$id_sondage."' ORDER BY id_reponse ASC";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
if(mysql_num_rows($mysqlresult1) > 0) {
while ($row=mysql_fetch_row($mysqlresult1)) {
$id_reponse=$row[0];
$id_sondage=$row[1];
$reponse=$row[2];
$nb_votes=$row[3];
$pourcent_rep = round($nb_votes * 100 / $nb_total_reponses_sondage, 1);
?>
| bgcolor="#F7F1F7" } ?>>= $reponse; ?> |
bgcolor="#F7F1F7" $i=0; } ?>> = $pourcent_rep; ?> % |
$i++; }} ?>
|
|
echo $nb_total_reponses_sondage." vote"; if ($nb_total_reponses_sondage>1) { echo "s"; } ?> | archives | commentaires (= nb_commentaires("sondage-".$id_sondage); ?>)
|
}} else { echo "erreur"; } ?>

|
|
//$mysqlquery = "SELECT t.*, t.somme_notes/t.nb_notes as moyenne FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='F' AND t.statut='1' ORDER BY moyenne DESC LIMIT 0,1";
$mysqlquery = "SELECT t.* FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='F' AND t.statut='1' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
$row=mysql_fetch_row($mysqlresult);
$id_membre=$row[0];
$id_photo=$row[1];
$date_ajout=$row[2];
$somme_notes=$row[3];
$nb_notes=$row[4];
$statut=$row[5];
$moyenne = $somme_notes / $nb_notes;
$moyenne = arrondi($moyenne,1);
$mysqlquery5 = "SELECT * FROM album_photos WHERE id_membre='".$id_membre."' AND id_photo='".$id_photo."'";
$mysqlresult5 = mysql_query($mysqlquery5,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult5);
$photo=$row[2];
$mysqlquery16 = "SELECT * FROM membres WHERE id='$id_membre'";
$mysqlresult16 = mysql_query($mysqlquery16,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult16);
$pseudo_membre=$row[1];
?>

= $moyenne; ?>/10
} ?>
|
//$mysqlquery = "SELECT t.*, t.somme_notes/t.nb_notes as moyenne FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='H' AND t.statut='1' ORDER BY moyenne DESC LIMIT 0,1";
$mysqlquery = "SELECT t.* FROM membres AS m LEFT JOIN pixs_tronches AS t ON t.id_membre = m.id WHERE m.sexe='H' AND t.statut='1' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
if(mysql_num_rows($mysqlresult) > 0) {
$row=mysql_fetch_row($mysqlresult);
$id_membre=$row[0];
$id_photo=$row[1];
$date_ajout=$row[2];
$somme_notes=$row[3];
$nb_notes=$row[4];
$statut=$row[5];
$moyenne = $somme_notes / $nb_notes;
$moyenne = arrondi($moyenne,1);
$mysqlquery5 = "SELECT * FROM album_photos WHERE id_membre='".$id_membre."' AND id_photo='".$id_photo."'";
$mysqlresult5 = mysql_query($mysqlquery5,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult5);
$photo=$row[2];
$mysqlquery16 = "SELECT * FROM membres WHERE id='$id_membre'";
$mysqlresult16 = mysql_query($mysqlquery16,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult16);
$pseudo_membre=$row[1];
?>

= $moyenne; ?>/10
} ?>
|
|
$mysqlquery = "SELECT * FROM pictures WHERE statut='1' AND taille!='1' ORDER BY md5(rand()) LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult);
$id_img=$row[0];
$id_galerie=$row[1];
$copyright_img=$row[2];
$date_img=$row[3];
$id_posteur_img=$row[4];
$url_img=$row[5];
$taille_img=$row[6];
?>
0) { echo "-";
while ($row=mysql_fetch_row($mysqlresult1)) {
$id_tag=$row[0];
$nom_tag=$row[2];
echo urls($nom_tag);
if ($i!=mysql_num_rows($mysqlresult1)) { ?>- } $i++; }} ?>.html">
|
|
galerie d'images | tronches
|
$query_visiteurs = "SELECT * FROM nb_connectes";
$result_visiteurs = mysql_query($query_visiteurs,$mysqlconnect);
$nb_visiteurs = mysql_num_rows($result_visiteurs);
$background='EFEAD6';
$color='CEBF84';
?>
html(xiti); ?>
|
|
html(search); ?>
|
| |
Bienvenue sur Mixs.fr, la première communauté des jeunes internautes !
C'est ta première visite ? Je te laisse naviguer sur les services et outils présentés ci-dessous. Si tu as besoin d'aide n'hésite pas à cliquer sur le bouton d'aide en bas à gauche de chaque page.
Tu vas pouvoir découvrir des univers très variés comme musique, cinéma, télévision, multimédia, livres, santé, partager tes photos et vidéos, discuter sur les forums, créer un blog et te faire un tas d'amis !
|
| |

|
|
|
| |
|
|
| |

|
$mysqlquery1 = "SELECT id,id_rubrique,titre,introduction,format_img FROM mag_articles WHERE statut='1' ORDER BY date DESC LIMIT 0,1";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult1);
$id_article=$row[0];
$id_rubrique_article=$row[1];
$titre_article=$row[2];
$introduction_article=$row[3];
$format_img1=$row[4];
$mysqlquery2 = "SELECT nom FROM mag_rubriques WHERE id='$id_rubrique_article'";
$mysqlresult2 = mysql_query($mysqlquery2,$mysqlconnect);
$row=mysql_fetch_row($mysqlresult2);
$nom_rubrique_article=$row[0];
$mysqlquery = "SELECT * FROM mag_articles WHERE statut='1' AND id!='".$id_article."' ORDER BY date DESC LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult);
$id_article_1=$row1[0];
$titre_article_1=$row1[3];
$format_img_1=$row1[12];
$mysqlquery = "SELECT * FROM mag_articles WHERE statut='1' AND id!='".$id_article."' AND id!='".$id_article_1."' ORDER BY date DESC LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row2=mysql_fetch_row($mysqlresult);
$id_article_2=$row2[0];
$titre_article_2=$row2[3];
$format_img_2=$row2[12];
$mysqlquery = "SELECT * FROM mag_articles WHERE statut='1' AND id!='".$id_article."' AND id!='".$id_article_1."' AND id!='".$id_article_2."' ORDER BY date DESC LIMIT 0,1";
$mysqlresult = mysql_query($mysqlquery,$mysqlconnect);
$row3=mysql_fetch_row($mysqlresult);
$id_article_3=$row3[0];
$titre_article_3=$row3[3];
$format_img_3=$row3[12];
?>
| = ucfirst($nom_rubrique_article); ?> = $titre_article; ?> |
|
|
= $introduction_article; ?> (...)
|
|
|
| |

|
|
|
Top visites 24h |
Dernières notes publiés |
|
|
$i=1;
$mysqlquery3 = "SELECT * FROM blogs_statistiques WHERE date='".date("Y-m-d")."' ORDER BY visites_uniques DESC LIMIT 0,5";
$mysqlresult3 = mysql_query($mysqlquery3,$mysqlconnect);
if(mysql_num_rows($mysqlresult3) >= 5) {
?>
while ($row3=mysql_fetch_row($mysqlresult3)) {
$id_blog=$row3[0];
$mysqlquery1 = "SELECT * FROM blogs WHERE id_blog='".$id_blog."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult1);
$id_membre=$row1[1];
$titre_blog=$row1[2];
$mysqlquery1 = "SELECT * FROM membres WHERE id='".$id_membre."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult1);
$pseudo_membre=$row1[1];
?>
| bgcolor="#F8FAFC" $i=0; } ?>>= encoder($titre_blog); ?> |
$i++; } ?>
} else { ?>
$i=1;
$mysqlquery3 = "SELECT * FROM blogs_statistiques WHERE date='".date('Y-m-d', time()-3600*24)."' ORDER BY visites_uniques DESC LIMIT 0,5";
$mysqlresult3 = mysql_query($mysqlquery3,$mysqlconnect);
?>
while ($row3=mysql_fetch_row($mysqlresult3)) {
$id_blog=$row3[0];
$mysqlquery1 = "SELECT * FROM blogs WHERE id_blog='".$id_blog."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult1);
$id_membre=$row1[1];
$titre_blog=$row1[2];
$mysqlquery1 = "SELECT * FROM membres WHERE id='".$id_membre."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult1);
$pseudo_membre=$row1[1];
?>
| bgcolor="#F8FAFC" $i=0; } ?>>= encoder($titre_blog); ?> |
$i++; } ?>
} ?>
|
$i=1;
$mysqlquery3 = "SELECT * FROM blogs_posts WHERE statut='1' AND date_post<='".date("Y-m-d H:i:s")."' ORDER BY date_post DESC LIMIT 0,5";
$mysqlresult3 = mysql_query($mysqlquery3,$mysqlconnect);
if(mysql_num_rows($mysqlresult3) > 0) {
?>
while ($row3=mysql_fetch_row($mysqlresult3)) {
$id_post=$row3[0];
$id_blog=$row3[1];
$titre_post=$row3[2];
$post=$row3[3];
$rubrique_post=$row3[4];
$date_post=$row3[5];
$statut_post=$row3[6];
$commentaires_post=$row3[7];
$img_post=$row3[8];
$align_img_post=$row3[9];
$mysqlquery1 = "SELECT * FROM blogs WHERE id_blog='".$id_blog."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult1);
$id_membre=$row1[1];
$mysqlquery1 = "SELECT * FROM membres WHERE id='".$id_membre."'";
$mysqlresult1 = mysql_query($mysqlquery1,$mysqlconnect);
$row1=mysql_fetch_row($mysqlresult1);
$pseudo_membre=$row1[1];
?>
| bgcolor="#F8FAFC" $i=0; } ?>>= encoder($titre_post); ?> |
$i++; } ?>
} ?>
|
|
|