salut a tous voila jai installer un script de news sur mon site mais il ya un blem
http://mega-dbz.performant-hosting.com/version2/
voila le fichier function_aff
<?php
include(´./tlNews/inc/config.php´);
include(´./tlNews/inc/sql_connect.php´);
function mystripslashes($string) {
if (get_magic_quotes_gpc()==1) {
return ($string);
}
else {
return (stripslashes ($string));
}
}
function myaddslashes($string) {
if (get_magic_quotes_gpc()==1) {
return ($string);
}
else {
return (mysql_real_escape_string ($string));
}
}
function afficher_news($nbr_news) {
if(isset($_GET[´idNouvelle´])){
$idnews = $_GET[´idNouvelle´];
$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news where id = ´$idnews´";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);
$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);
$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);
$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", mystripslashes(nl2br($row[´content´])), $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);
echo $val[´code´];
}
echo "<div style=´text-align: center; font-weight: bold;´><a
href=´?idNouvelle=".$idnews."&comment=ajout´>A
jouter un commentaire.</a></div>";
echo "<div style=´text-align: center;´>";
if($_GET[´comment´] == ´ajout´){
echo "<form action=´?idNouvelle=".$idnews."&comment=send´ method=´post´>";
echo ´Auteur :<br /><input type="text" name="auteur" size="50" maxlength="255" /><br />´;
echo ´Commentaire :<br /><textarea name="msg" cols="50" rows="5"></textarea><br />´;
echo ´<input type="submit" name="submit" value="Ajouter" />´;
echo "</form>";
}
elseif($_GET[´comment´] == ´send´){
$auteur =
myaddslashes(htmlspecialchars($_POST[´auteur´]));
$msg = myaddslashes(htmlspecialchars($_POST[´msg´]));
$date = date("Y-m-d H:i:s");
$idnews = $_GET[´idNouvelle´];
if(empty($auteur) || empty($msg)){
echo "Veuillez remplir tous les champs.\n";
}
else{
$query = "INSERT INTO tlNews_comment(idNouvelle,date,auteur,msg) VALUES(´$idnews´,´$date´,´$auteur´,´$msg´)";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
echo "Votre commentaire a bien été ajouté.\n";
}
}
echo "</div>";
echo "<a id=´comment´></a><div style=´padding: 15px 15px 15px 15px; text-decoration: underline; font-weight: bold; font-size: 16px;´>Commentaires :</div>";
$query3 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_comment where idNouvelle = ´$idnews´ ORDER BY id DESC";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
while ($row3 = mysql_fetch_array($result3)) {
$msg = mystripslashes(nl2br($row3[´msg´]));
echo "<div style=´border-bottom: 1px dotted #000;´>".$row3[´date´]." par
<b>".mystripslashes($row3[´auteur´])."</b></div>";
echo "<div>".$msg."</div><hr />\n";
}
}
else{
$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news ORDER BY id DESC limit 0,$nbr_news";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);
$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);
$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);
$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", "<p><a href=´?idNouvelle=".$row[´id´]."´>Lire la Suite</a></p>", $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);
echo $val[´code´];
}
}
echo "<hr /><div style=´text-align: center;´><a href=´http://www.tommyweb.org´ title=´Annuaire de scripts PHP / MySql´>tlNews par Tommy Leunen.</a></div>";
mysql_close();
}
function afficher_archives() {
if(isset($_GET[´annee´]) AND isset($_GET[´mois´])){
if($_GET[´mois´] <= "9") { $_GET[´mois´] = "0".$_GET[´mois´]; }
else { $_GET[´mois´]; }
$datearch = $_GET[´annee´]."-".$_GET[´mois´];
$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news WHERE date LIKE ´$datearch%´ ORDER BY id DESC";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);
$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);
$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);
$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", "<p><a href=´?idNouvelle=".$row[´id´]."´>Lire la Suite</a></p>", $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);
echo $val[´code´];
}
}
elseif(isset($_GET[´idNouvelle´])){
$idnews = $_GET[´idNouvelle´];
$query1 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_news where id = ´$idnews´";
$result1 = mysql_query($query1) or die(´Erreur SQL : ´.mysql_error());
while ($row = mysql_fetch_array($result1)) {
$template = $row[´template´];
$query = "SELECT * FROM tlNews_template where title = ´$template´";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$val = mysql_fetch_array($result);
$vign = $row[´vign´];
$query2 = "SELECT * FROM tlNews_vign where title = ´$vign´";
$result2 = mysql_query($query2) or die(´Erreur SQL : ´.mysql_error());
$row1 = mysql_fetch_array($result2);
$idnews = $row[´id´];
$query3 = "SELECT * FROM tlNews_comment where idNouvelle = ´$idnews´";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
$nb = mysql_num_rows($result3);
$val[´code´] = str_replace("[titre]", mystripslashes($row[´title´]), $val[´code´]);
$val[´code´] = str_replace("[auteur]", $row[´auteur´], $val[´code´]);
$val[´code´] = str_replace("[vign]", "<img src=´./tlNews/".$row1[´url´]."´ alt=´vign´ />", $val[´code´]);
$val[´code´] = str_replace("[date]", $row[´date´], $val[´code´]);
$val[´code´] = str_replace("[chapeau]", mystripslashes(nl2br($row[´chapeau´])), $val[´code´]);
$val[´code´] = str_replace("[suite]", mystripslashes(nl2br($row[´content´])), $val[´code´]);
$val[´code´] = str_replace("[src]", "<a href=´".$row[´src´]."´>".$row[´src´]."</a>", $val[´code´]);
$val[´code´] = str_replace("[comment]", "<a href=´?idNouvelle=".$idnews."#comment´>".$nb." commentaire(s)</a>", $val[´code´]);
echo $val[´code´];
}
echo "<div style=´text-align: center; font-weight: bold;´><a
href=´?idNouvelle=".$idnews."&comment=ajout´>A
jouter un commentaire.</a></div>";
echo "<div style=´text-align: center;´>";
if($_GET[´comment´] == ´ajout´){
echo "<form action=´?idNouvelle=".$idnews."&comment=send´ method=´post´>";
echo ´Auteur : <br /><input type="text" name="auteur" size="50" maxlength="255" /><br />´;
echo ´Commentaire : <br /><textarea name="msg" cols="50" rows="5"></textarea><br />´;
echo ´<input type="submit" name="submit" value="Ajouter" />´;
echo "</form>";
}
elseif($_GET[´comment´] == ´send´){
$auteur =
myaddslashes(htmlspecialchars($_POST[´auteur´]));
$msg = myaddslashes(htmlspecialchars($_POST[´msg´]));
$date = date("Y-m-d H:i:s");
$idnews = $_GET[´idNouvelle´];
if(empty($auteur) || empty($msg)){
echo "Veuillez remplir tous les champs.\n";
}
else{
$query = "INSERT INTO tlNews_comment(idNouvelle,date,auteur,msg) VALUES(´$idnews´,´$date´,´$auteur´,´$msg´)";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
echo "Votre commentaire a bien été ajouté.\n";
}
}
echo "</div>";
echo "<a id=´comment´></a><div style=´padding: 15px 15px 15px 15px; text-decoration: underline; font-weight: bold; font-size: 16px;´>Commentaires : </div>";
$query3 = "SELECT *, DATE_FORMAT(date,´Le %d-%m-%Y à %T´) as date FROM tlNews_comment where idNouvelle = ´$idnews´ ORDER BY id DESC";
$result3 = mysql_query($query3) or die(´Erreur SQL : ´.mysql_error());
while ($row3 = mysql_fetch_array($result3)) {
$msg = mystripslashes(nl2br($row3[´msg´]));
echo "<div style=´border-bottom: 1px dotted #000;´>".$row3[´date´]." par
<b>".mystripslashes($row3[´auteur´])."</b></div>";
echo "<div>".$msg."</div><hr />\n";
}
}
else{
$query = "SELECT DISTINCT MONTH(date) AS mois, YEAR(date) AS annee FROM tlNews_news ORDER BY annee DESC, mois DESC";
$result = mysql_query($query) or die(´Erreur SQL : ´.mysql_error());
$annee = "grrrr";
echo "<ul>\r";
while ($val = mysql_fetch_array($result)) {
if($val[´mois´] <= "9") {
$mois = str_replace(array("1", "2", "3", "4", "5", "6", "7", "8", "9"), array("Janvier", "Février", "Mars", "Avril", "Mai", "Juin", "Juillet", "Août", "Septembre "), $val[´mois´]);
}
else{
$mois = str_replace(array("10", "11", "12"), array("Octobre", "Novembre", "Décembre"), $val[´mois´]);
}
if ($annee != $val[´annee´]) {
echo "<li style=´list-style-type: none; margin: 5px 0px 5px -35px; font-weight: bold;´>Archives des nouvelles postées en ".$val[´annee´].".</li>\r";
}
else{ }
echo "<li style=´list-style-type: square;´><a
href=´?annee=".$val[´annee´]."&mois=".$val[´mo
is´]."´>".$mois." ".$val[´annee´]."</a></li>\r"; //retirer ./?page=archives pour les autres
$annee = $val[´annee´];
}
echo "</ul>\r";
}
echo "<hr /><div style=´text-align: center;´><a href=´http://www.tommyweb.org´ title=´Annuaire de scripts PHP / MySql´><a href=´http://www.tommyweb.org´>tlNews par Tommy Leunen.</a></div>";
mysql_close();
}
?>
Apparemment, tu appelles deux fois le fichier function_aff.php, d´où le souci.
et comment régler le blem
ben tu l´apel qu´une seule fois
Perso moi mon script de news fé 46 lignes + pour afficher 10 ligne sa doit faire en tout 56 lignes alors quand je vois ton truc .... ^^