Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?PHP
- include("./require.php");
- $pagename = "News";
- $pageid = "news";
- $sqle = $bdd->prepare("SELECT * FROM bl_news WHERE id = ?");
- $sqle->execute(array($_GET['id']));
- $n = $sqle->fetch(PDO::FETCH_ASSOC);
- if(isset($_POST['go'])){
- if(!empty($_POST['contenu'])){
- $contenu = Secu($_POST['contenu']);
- $pseudo = $user['username'];
- $avatar = $user['look'];
- $rank = $user['rank'];
- $time = time();
- if(isset($contenu) ) {
- $errored = false;
- if(strlen($contenu) < 1) {
- $message = "Merci de rentrer un commmentaire";
- $errored = true;
- }
- elseif (strlen($contenu) > 100 )
- {
- $message = "100 caractère maximum";
- $errored = true;
- }
- if($errored == false) {
- $insertusera = $bdd->prepare("INSERT INTO bl_news_comments (username,article,contenu,avatar,time,rank) VALUES (:username, :article, :contenu, :avatar, :time, :rank)");
- $insertusera->bindValue(':username', $pseudo);
- $insertusera->bindValue(':article', $n['id']);
- $insertusera->bindValue(':contenu', $contenu);
- $insertusera->bindValue(':avatar', $avatar);
- $insertusera->bindValue(':time', $time);
- $insertusera->bindValue(':rank', $rank);
- $insertusera->execute();
- $success = "La demande à bien été envoyée";
- }
- }
- }
- }
- if(isset($_GET['del']) AND !empty($_GET['del'])){
- $reqdel = $bdd->prepare('SELECT * FROM bl_news_comments WHERE username= ? && id= ? && article= ?');
- $reqdel->execute(array($user['username'], $_GET['del'], $_GET['id']));
- $del = $reqdel->fetch(PDO::FETCH_ASSOC);
- if($del['username'] == $user['username'] OR $user['rank'] >= 5){
- $del = $bdd->prepare("DELETE FROM bl_news_comments WHERE id = ?");
- $del->execute(array($_GET['del']));
- $message = "<div class='successmsg'>Votre message à bien été supprimé!</div>";
- }else{
- $message = "<div class='errormsg'>Une erreur est survenue</div>";
- }
- }elseif(isset($_GET['del']) AND empty($_GET['del'])){
- header("location: index.php");
- exit();
- }
- ?>
- <html>
- <head>
- <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
- <title><?PHP echo $sitename; ?> » <?PHP echo $pagename; ?></title>
- <link rel="stylesheet" type="text/css" href="css/style.css">
- <link rel="stylesheet" type="text/css" href="css/news.css">
- </head>
- <body>
- <?PHP include("theme/head_new.php"); ?>
- <div id="column_left" class="column">
- <div id="box-blanche">
- <div id="partage2"></div>
- <?PHP
- if($n['id'] >= 1) {
- $sql = $bdd->prepare("SELECT * FROM bl_news WHERE id = ?");
- $sql->execute(array($_GET['id']))
- $row = $sql->rowCount();
- $n = $sql->fetch(PDO::FETCH_ASSOC);
- if(empty($id)) {?>
- <div class="titre"><?php echo $nintrou ?></div>
- <?PHP } elseif($row < 1) {
- ?>
- <div class="titre"><?php echo $nintrou ?></div>
- <?PHP } else {?>
- <div id="titre_news2"><?PHP echo $n['title'];?></div>
- <?PHP echo $n['longstory'];?>
- <br><br>
- <div class="endnew">
- <div class="author"><?PHP echo $n['author'];?></div>
- <div class="datef">Le <?php echo date_fr("d M. Y H:i:s", $n['datecrea']); ?></div>
- </div>
- <?PHP } } ?>
- <div id="titre_news"></div>
- </div>
- <div id="space"></div>
- <div id ="box-blanche">
- <div id="text-archive"><?php echo $lescom ?></div>
- <?php
- $reponse2 = $bdd->prepare('SELECT * FROM bl_news_comments WHERE article = ? ORDER BY id');
- $reponse2->execute(array($_GET['id']));
- while($donnees = $reponse2->fetch()){
- ?>
- <div class='bloc'>
- <div class='topBar'>
- <div class='avatar'><img src='https://avatar-retro.com/habbo-imaging/avatarimage?figure=<?= $donnees['avatar']; ?>' style='<?php if($user['gender'] == "M"){?>-webkit-filter: drop-shadow(3px 0 0 #39add1) drop-shadow(-3px 0 0 #39add1) drop-shadow(0 -3px 0 #39add1);<?php } else { ?>-webkit-filter: drop-shadow(3px 0 0 pink) drop-shadow(-3px 0 0 pink) drop-shadow(0 -3px 0 pink);<?php } ?>'></div>
- <span class="namecom"><?php echo $par ?> <?php echo $donnees['username']; ?></span>
- <span class="datecom"><?php echo $le ?> <?php echo date_fr("d M. Y H:i:s", $donnees['time']); ?></span>
- <?PHP
- if($donnees['rank'] >= 4){
- echo '<div class="marque-s"><img src="./images/ADM.gif"></div>';
- }
- ?>
- <?PHP
- if($donnees['username'] == "{$user['username']}" OR $user['rank'] >= 4){
- echo '<a href="'.$url.'/news.php?id='.Secu($_GET['id']).'&del='.$donnees['id'].'"><button class="supprimer">X</button></a>';
- }
- ?>
- </div>
- <div class='content'><?php echo Secu($donnees['contenu']); ?><br/>
- </div>
- </div>
- <?PHP } ?>
- </div>
- <div id="box-blanche">
- <div id="text-archive"><?php echo $puncom ?></div>
- <?php
- if(!isset($_SESSION['username']))
- { ?>
- <p style="text-align:center;"><?php echo $pascocom ?></p>
- <?php } else { ?>
- <form name="message" method="post" id="left" style="text-align: center;">
- <p><textarea name="contenu" id="editor1" rows="6" cols="110"></textarea></p>
- <button type="submit" name="go" class="btn"><?php echo $sendcom ?></button>
- </form>
- <?php } ?>
- </div>
- </div>
- <div id="column_right" class="column">
- <div id="box-blanche">
- <div id="text-archive"><?php echo $archive ?></div>
- <?PHP
- $sql = $bdd->query("SELECT * FROM `bl_news` ORDER BY id DESC LIMIT 15");
- while($news = $sql->fetch()) {?>
- <a href="./news.php?id=<?php echo $news['id'];?>"><div id="lien_archive" style="background: url(<?php echo $news['image'];?>) 542px 129px;"><?php echo $news['title'];?></div></a>
- <?php } ?>
- </div>
- </div>
- <br><br><br><br>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement