| 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/vracandbio.com/cp-admin/ |
Upload File : |
<?php
include_once('includes/header.php');
$adv_id = $_GET['id'];
if (empty($adv_id)) { $adv_id = $_POST['adv_id']; }
$slide_id = $_GET['slideshow'];
$requete = $bdd->prepare('SELECT * FROM ' . $GLOBALS['db_table']['slideshow_pictures'] . ' WHERE id = :id');
$requete->execute(array('id' => $adv_id));
$list = $requete->fetchAll();
$i=0;
$id = $list[$i]['id'];
$slideshow = $list[$i]['slideshow'];
$position = $list[$i]['position'];
$name = $list[$i]['name'];
$picture = $list[$i]['picture'];
$url = $list[$i]['url'];
$target = $list[$i]['target'];
if (isset($_POST['edit'])) {
$requete = $bdd->prepare('UPDATE ' . $GLOBALS['db_table']['slideshow_pictures'] . ' SET name = :name, url = :url, target = :target WHERE id = :id');
if($_POST['target'] == '_blank')
{
$requete->execute(array(
'name' => $_POST['name'],
'url' => $_POST['urlExt'],
'target' => $_POST['target'],
'id' => $adv_id
));
}
else
{
if(!empty($_POST['varr']))
{
$requete->execute(array(
'name' => $_POST['name'],
'url' => $_POST['varr'],
'target' => $_POST['target'],
'id' => $adv_id
));
} else {
$requete->execute(array(
'name' => $_POST['name'],
'url' => $_POST['urlInt'],
'target' => $_POST['target'],
'id' => $adv_id
));
}
}
/////////////////////////////////////////////////////////////////
if($_POST['dupli'] > 0) {
$requete = $bdd->prepare('INSERT INTO ' . $GLOBALS['db_table']['slideshow_pictures'] . ' (picture, slideshow, name, url, target) VALUES (:picture, :slideshow, :name, :url, :target)');
$requete->execute(array(
'picture' => $picture,
'slideshow' => $_POST['dupli'],
'name' => $name,
'url' => $url,
'target' => $target
));
}
/////////////////////////////////////////////////////////////////
echo '<script>';
echo 'window.location = "./slideshow_content.php?id=' . $slideshow . '"';
echo '</script>';
}
?>
<div class="container">
<div class="row">
<div class="span12">
<div class="page-header">
<h1>Edition Slideshow
<div class="pull-right">
<a href="slideshow_content.php?id=<?php echo $slideshow; ?>" class="btn btn-primary"><i class="icon-arrow-left"></i> Retour</a>
</div>
</h1>
</div>
</div>
</div>
<?php
echo '<div id="form-content" style="">';
echo '<form class="form-horizontal" method="post" action="#" enctype="multipart/form-data">';
echo '<div class="row-fluid">';
echo '<div class="span6">';
echo '<div class="control-group">';
echo '<label class="control-label" for="title">Slideshow :</label>';
echo '<div class="controls">';
echo '<img src="../uploadfiles/slideshows/'.$picture.'" width="500px" heigth="250px">';
echo '</div>';
echo '</div>';
echo '</div>';
echo '<div class="span6">';
echo '<div class="control-group">';
echo '<label class="control-label" for="title">Titre :</label>';
echo '<div class="controls">';
echo '<input style="width:287px" name="name" id="name" value="'.$name.'" required="" type="text">';
echo '</div>';
echo '</div>';
echo '<div class="control-group">';
echo '<label class="control-label" for="title">Destination :</label>';
echo '<div class="controls">';
echo '<select onchange="changeTarget()" name="target" id="target" data-placeholder="Type de lien" class="chosen-select" style="width:300px;">';
echo '<option value=""></option>';
echo '<option value="_blank"'; if($target == '_blank')echo ' selected'; echo '>Externe</option>';
echo '<option value="_top"'; if($target != '_blank')echo ' selected'; echo '>Interne</option>';
echo '</select>';
echo ' <a onMouseOver="infobulle(this, \'Destination INTERNE correspond à _top (le lien arrivera dans la même fenêtre que votre site) et EXTERNE à _blank (le lien arrivera dans une nouvelle fenêtre de votre navigateur).\');"><img src="assets/img/help.png"></a>';
echo '</div>';
echo '</div>';
echo '<div id="int" class="control-group">';
echo '<label class="control-label" for="title">Lien interne :</label>';
echo '<div class="controls">';
echo '<select name="urlInt" style="width:300px;">';
echo '<option value=""></option>';
echo '<option value="blog"'; if($url == "blog")echo ' selected'; echo '>Blog</option>';
$requete = $bdd->query('SELECT * FROM blog where status>0 ORDER BY position');
$list = $requete->fetchAll();
for($i=0; $i<count($list); $i++) {
$name = $list[$i]['title'];
$seo = $list[$i]['seo'];
echo '<option value="blog-' . $seo . '"'; if($url == 'blog-' . $seo)echo ' selected'; echo '>-' . $name . '</option>';
}
echo '<option value="promotions"'; if($url == "promotions")echo ' selected'; echo '>Promotions</option>';
echo '<option value="nouveautes"'; if($url == "nouveautes")echo ' selected'; echo '>Nouveautés</option>';
echo '<option value="top-ventes"'; if($url == "top-ventes")echo ' selected'; echo '>Meilleures ventes</option>';
$requete = $bdd->query('SELECT * FROM cms ORDER BY position');
$list = $requete->fetchAll();
for($i=0; $i<count($list); $i++) {
$title = $list[$i]['title'];
$seo = $list[$i]['seo'];
echo '<option value="page-' . $seo . '"'; if($url == 'page-' . $seo)echo ' selected'; echo '>' . $title . '</option>';
}
$requete = $bdd->query('SELECT * FROM categories ORDER BY position');
$list = $requete->fetchAll();
for($i=0; $i<count($list); $i++) {
$name = $list[$i]['name'];
$seo = $list[$i]['seo'];
echo '<option value="categorie-' . $seo . '"'; if($url == 'categorie-' . $seo)echo ' selected'; echo '>' . $name . '</option>';
}
echo '</select>';
echo '</div>';
echo '</div>';
echo '<div id="varr" class="control-group">';
echo '<label class="control-label" for="title">Choisir un article :</label>';
echo '<div class="controls">';
echo '<select name="varr" style="width:300px;">';
echo '<option value=""></option>';
$requete = $bdd->query('SELECT * FROM products WHERE status = 1 ORDER BY name ASC');
$list = $requete->fetchAll();
for($i=0; $i<count($list); $i++) {
$name = $list[$i]['name'];
$seo = $list[$i]['seo'];
echo '<option value="produit-' . $seo . '"'; if($url == 'produit-' . $seo)echo ' selected'; echo '>' . $name . '</option>';
}
echo '</select>';
echo ' <a onMouseOver="infobulle(this, \'Utiliser cette option pour un article. Sa sélection est prioritaire dans les enregistrements !!\');"><img src="assets/img/help.png"></a>';
echo '</div>';
echo '</div>';
echo '<div id="ext" class="control-group">';
echo '<label class="control-label" for="title">Lien externe :</label>';
echo '<div class="controls">';
echo '<input style="width:287px" name="urlExt" value="'.$url.'" type="text">';
echo ' <a onMouseOver="infobulle(this, \'A FAIRE\');"><img src="assets/img/help.png"></a>';
echo '</div>';
echo '</div>';
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
echo '<div class="control-group">';
echo '<label class="control-label" for="title">Dupliquer vers un autre Slideshow :</label>';
echo '<div class="controls">';
echo '<select name="dupli" style="width:300px;">';
echo '<option value=""></option>';
$requete = $bdd->query('SELECT id,name FROM slideshows WHERE status = 1 AND id!='.$slide_id.' ORDER BY id ASC');
$list = $requete->fetchAll();
for($i=0; $i<count($list); $i++) {
$name = $list[$i]['name'];
$idde = $list[$i]['id'];
$requete5 = $bdd->prepare('SELECT * FROM ' . $GLOBALS['db_table']['slideshow_pictures'] . ' WHERE slideshow = :slideshow AND picture = :picture ORDER BY position');
$requete5->execute(array('slideshow' => $idde, 'picture' => $picture));
$nexi = $requete5->fetchAll();
$existe= $nexi[0]['id'];
if ($existe < 1) {
echo '<option value="' . $idde . '"'; echo '>' . $name. '</option>';
}
}
echo '</select>';
echo ' <a onMouseOver="infobulle(this, \'Utiliser uniquement après avoir rempli et enregistré le titre + le lien et la destination. Cette option dupliquera : Image + Titre + Lien + Destination vers le Slideshow de votre choix.\');"><img src="assets/img/help.png"></a>';
echo '</div>';
echo '</div>';
///////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
echo '</div>';
echo '</div>';
echo '</div>';
echo '<div class="form-actions">';
echo '<div class="btn-group">';
echo '<input type="hidden" name="id" value="'.$id.'" />';
echo '<input type="hidden" name="$adv_id" value="'.$adv_id.'" />';
echo '<button type="submit" name="edit" class="btn btn-success"><i class="icon-ok"></i> Enregistrer</button>';
echo '</div>';
echo '</div>';
echo '</form>';
echo '</div>';
?>
<script type="text/javascript">
function changeTarget() {
if (document.getElementById("target").value == '_blank') {
document.getElementById("int").style.display = "none";
document.getElementById("varr").style.display = "none";
document.getElementById("ext").style.display = "block";
} else if (document.getElementById("target").value == '_top'){
document.getElementById("ext").style.display = "none";
document.getElementById("int").style.display = "block";
document.getElementById("varr").style.display = "block";
} else {
console.log('erreur');
}
console.log('appel du script !');
}
changeTarget();
</script>
</div>
<script type="text/javascript" src="assets/js/chosen.jquery.js" ></script>
<script type="text/javascript">
var config = {
'.chosen-select' : {},
'.chosen-select-deselect' : {allow_single_deselect:true},
'.chosen-select-no-single' : {disable_search_threshold:10},
'.chosen-select-no-results': {no_results_text:'Oops, nothing found!'},
'.chosen-select-width' : {width:"95%"}
}
for (var selector in config) {
$(selector).chosen(config[selector]);
}
</script>
<?
include_once('includes/footer.php');
?>