id_news) {
$listedito="$LG_NEWSNOEDITO";
$listedito .="$LG_NEWSCREAEDIT
";
$idedito="none";
} else {
$edito->titreNews = stripslashes($edito->titreNews);
$edito->texteNews = stripslashes($edito->texteNews);
$idedito="$edito->id_news";
$listedito="
$LG_NEWSMODSUPEDITO
";
$listedito .="
";
}
}
//----------------------------------------
$page=$_GET['page'];
$limit=$_GET['limit'];
$entetepage .= "$LG_RESULTPAGE \n";
$entetepage .= "5 | \n";
$entetepage .= "10 | \n";
$entetepage .= "20 | \n";
$entetepage .= "50 \n";
//----------------------------------------
//---------------------------------------------------------------------------------
//pagination le limit défini le nombre d'enregistrement par page
//---------------------------------------------------------------
if (!($limit)) {
$limit = 20;
}
if (!($page)) {
$page = 0;
}
// comptage des enregistrements
$requete2="select id_news from ".$extension."news where newsEdito=0 and (id_autnews=".$cuid." or ".$cuid."=1 )";
$results=mysql_query($requete2, $link);
$rows=mysql_num_rows($results);
if ($rows == 0){
$listenews .="
$LG_NORESULT\n";
}
$pages = intval($rows/$limit);
if ($rows%$limit) { $pages++;}
$current = ($page/$limit) + 1;
if (($pages < 1) || ($pages == 0)) { $total = 1;}
else { $total = $pages;}
$first = $page + 1;
if (!((($page + $limit) / $limit) >= $pages) && $pages != 1) {
$last = $page + $limit;}
else{ $last = $rows; }
//---------------------------------------------------------------------------
mysql_free_result($results);
//---------------------------------------------------------------------------
//------------------
//affichage des news
//------------------
$style[0]="bgcolor=\"#FFFFFF\"";
$style[1]="bgcolor=\"#E8E8FF\"";
$i=1;
/* requete avec limit */
$page = intval($page);
$limit = intval($limit);
// modified by iao
$cuid=$_SESSION['SESSION_ID'];
$requete="select id_news, dateNews, titreNews from ".$extension."news ";
$requete.="where newsEdito=0 and (id_autnews=".$cuid." or ".$cuid."=1 ) order by ordreNews desc LIMIT $page, $limit";
// $requete="select id_news, dateNews, titreNews from ".$extension."news where newsEdito=0 order by ordreNews desc LIMIT $page, $limit";
$result=mysql_query($requete, $link);
$listenews="
";
//-----------------------------------------------------------------------
// Deuxieme partie du code de pagination
// (à modifier si vous avez d'autres données à faire circuler dans l'URL)
//-----------------------------------------------------------------------
$pagination .= " $LG_GOPAGE ";
if ($page != 0) {
$back_page = $page - $limit;
$pagination .= "<<\n";
}
for ($i=1; $i <= $pages; $i++) {
$ppage = $limit*($i - 1);
if ($ppage == $page){
//------
if ($total == 1) {
$pagination .= "";
} else {
$pagination .= "$i \n";
}
//-----
} else {
$pagination .= "$i \n";
}
}
if (!((($page+$limit) / $limit) >= $pages) && $pages != 1) {
$next_page = $page + $limit;
$pagination .= ">>\n";
}
//-----------------------------
//affichage des news en attente
//-----------------------------
//added by iao
if ($_SESSION['SESSION_STATUT']=="artadmin") {
$style[0]="bgcolor=\"#FFFFFF\"";
$style[1]="bgcolor=\"#E8E8FF\"";
$i=1;
$requete="select * from ".$extension."newstemp, ".$extension."utilisateurs where id_autnews=id_utilisateur order by ordreNews desc";
$result=mysql_query($requete, $link);
$listenews2 .="";
$listenews2 .="| $LG_NEWSATTENTE | |
";
while ($news2=mysql_fetch_object($result)) {
$news2->titreNews = stripslashes($news2->titreNews);
$news2->texteNews = stripslashes($news2->texteNews);
$listenews2 .= "
\n";
$listenews2 .= "$news2->dateNews
$news2->titreNews
$LG_INDEXAUTOR : $news2->loginUtilisateur | \n";
$listenews2 .= " id_news\">![\"".$LG_PUBLIER."/".$LG_MODIF."\"](\"imgadmin/bblook.gif\") | \n";
$listenews2 .= " id_news\" onClick=\"return confirm('$LG_SUPPRESCONF');\">![\"$LG_SUPPRES\"](\"imgadmin/bbsupp.gif\") | \n";
$listenews2 .= "
\n";
}
$listenews2 .="
";
}
//---------------------------
//Passage d'une news en edito
//---------------------------
if ($_SESSION['SESSION_STATUT']=="artadmin") { //added by iao
if ($_GET['newedito']) {
$newedito=$_GET['newedito'];
$requete="update ".$extension."news SET newsEdito='0' where newsEdito=1";
$result=mysql_query($requete, $link);
$requete="update ".$extension."news SET newsEdito='1' where id_news='$newedito'";
$result2=mysql_query($requete, $link);
//mise a jour des menus auto
include("aartibreves.php");
header ("Location:newsindex.php");
}
}
//----------------------
//suppression de données
//----------------------
if ($_GET['suppid']) {
$suppid=$_GET['suppid'];
$requete="delete from ".$extension."news where id_news='$suppid'";
$result=mysql_query($requete, $link);
// suppression des commentaires
$requete="delete from ".$extension."commentnews where id_news='$suppid'";
$result=mysql_query($requete, $link);
//-----------------------------
//mise a jour des menus auto
include("aartibreves.php");
header ("Location:newsindex.php");
}
if ($_GET['supptemp']) {
$supptemp=$_GET['supptemp'];
$requete="delete from ".$extension."newstemp where id_news='$supptemp'";
$result=mysql_query($requete, $link);
header ("Location:newsindex.php");
}
// champ option commentaire
//-------------------------
if ($_SESSION['SESSION_STATUT']=="artadmin") { //added by iao
$requete="select modoption from ".$extension."module where nomModule='News'";
$result=mysql_query($requete, $link);
$champoption=mysql_fetch_object($result);
if ($champoption->modoption) {
$selected="selected";
$lieuselect2[$champoption->modoption]=$selected;
} else {
$lieuselect2["0"]=$selected;
}
}
// changement option commentaire
//------------------------------
if ($_SESSION['SESSION_STATUT']=="artadmin") { //added by iao
if ($_POST['comm']) {
$comm=$_POST['comm'];
$optioncommentaire=$_POST['optioncommentaire'];
$requete="update ".$extension."module set modoption='$optioncommentaire' where nomModule='News'";
$result=mysql_query($requete, $link);
header ("Location:newsindex.php");
}
}
//-------------------------
mysql_free_result($result);
//-------------------------
//mise en page
//------------
include("header.php");
include("menumod.php");
//modified by iao
if ($_SESSION['SESSION_STATUT']=="artadmin" || $_SESSION['SESSION_STATUT']=="auteurqal") {
// if ($_SESSION['SESSION_STATUT']=="artadmin") {
?>
|
|
modoption=="1" or $champoption->modoption=="2") {?>
| - |
![\"$LG_MODIF\"](\"imgadmin/bbmodif.gif\")
id_news&selection=1\">