Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/escort46.de/public_html/admin/ |
<?php
$error = "";
$message = "";
include "db_connection.php";
include "sessioncheck.php";
if (!empty($_GET['rowset'])) {
$rowset = $_GET['rowset'];
} else {
$rowset = md5(uniqid(rand(), true));
}
if (!empty($_GET['item_id'])) {
$subset = $_GET['item_id'];
} else {
$subset = md5(uniqid(rand(), true));
}
#Save code start -->
if (!empty($_POST["Process"]) && trim($_POST["Process"]) == "AddNow") {
$data = array();
#Global deskop update
$data["ads_count_list_desktop"] = trim($_POST["ads_count_list_desktop"]);
$data["ads_count_grid_desktop"] = trim($_POST["ads_count_grid_desktop"]);
#update no of rows globally
$pagetbl = "UPDATE `scroll_ads` set
`ads_count_list`='" . addslashes($data['ads_count_list_desktop']) . "',
`ads_count_grid`='" . addslashes($data['ads_count_grid_desktop']) . "'
where `ad_device`='desktop' ";
$pagetbl = mysqli_query($connection, $pagetbl);
#Global mobile update
$data["ads_count_list_mobile"] = trim($_POST["ads_count_list_mobile"]);
$data["ads_count_grid_mobile"] = trim($_POST["ads_count_grid_mobile"]);
#update no of rows globally
$pagetbl = "UPDATE `scroll_ads` set
`ads_count_list`='" . addslashes($data['ads_count_list_mobile']) . "',
`ads_count_grid`='" . addslashes($data['ads_count_grid_mobile']) . "'
where `ad_device`='mobile' ";
$pagetbl = mysqli_query($connection, $pagetbl);
#Global tablet update
$data["ads_count_list_tablet"] = trim($_POST["ads_count_list_tablet"]);
$data["ads_count_grid_tablet"] = trim($_POST["ads_count_grid_tablet"]);
#update no of rows globally
$pagetbl = "UPDATE `scroll_ads` set
`ads_count_list`='" . addslashes($data['ads_count_list_tablet']) . "',
`ads_count_grid`='" . addslashes($data['ads_count_grid_tablet']) . "'
where `ad_device`='tablet' ";
$pagetbl = mysqli_query($connection, $pagetbl);
#Desktop code start -->
$data["ad_device_desktop"] = trim($_POST["ad_device_desktop"]);
$data["link_desktop"] = trim($_POST["link_desktop"]);
$data["img_title_desktop"] = trim($_POST["img_title_desktop"]);
$data["image_name_desktop"] = "";
$data["active_desktop"] = trim($_POST["active_desktop"]);
$data["banner_code_desktop"] = (!empty($_POST["banner_code_desktop"])) ? $_POST["banner_code_desktop"] : 0;
#add the code
if (!empty($_FILES["image_name_desktop"]["name"])) {
#upload image code
$tmp_name = $_FILES['image_name_desktop']['tmp_name'];
$path = "../bg_images/scroll/";
$name = $_FILES['image_name_desktop']['name'];
$size = $_FILES['image_name_desktop']['size'];
$type = $_FILES['image_name_desktop']['type'];
$ext = strtolower(substr($name, strrpos($name, '.') + 1));
$name = time() . "_" . rand(0, 999999) . "." . $ext;
$target_file = $path . $name;
move_uploaded_file($_FILES["image_name_desktop"]["tmp_name"], $target_file);
$data["image_name_desktop"] = $name;
#delete old image
if (!empty($row["image_name"])) {
#delete old image
unlink("../bg_images/scroll/" . $row["image_name"]);
}
} else {
$data["image_name_desktop"] = !empty($_POST['old_image_desktop']) ? $_POST['old_image_desktop'] : "";
}
$query = "SELECT * from scroll_ads WHERE subset='" . $subset . "' and `ad_device`='desktop' ";
$result = mysqli_query($connection, $query);
if (mysqli_num_rows($result)) {
#update query
$pagetbl = "UPDATE `scroll_ads` set
`banner_code`='" . addslashes($data['banner_code_desktop']) . "',
`link`='" . addslashes($data['link_desktop']) . "',
`image_name`='" . addslashes($data['image_name_desktop']) . "',
`img_alt`='" . addslashes($data['img_title_desktop']) . "',
`img_title`='" . addslashes($data['img_title_desktop']) . "',
`active`='" . addslashes($data['active_desktop']) . "'
where `subset`= '" . $subset . "' and `ad_device`='desktop' ";
$pagetbl = mysqli_query($connection, $pagetbl);
$message = "Data updated successfully";
//header("Location:scroll_list");
} else {
#insert query for desktop
$pagetbl = "INSERT INTO `scroll_ads`(`banner_code`, `ads_count_list`, `ads_count_grid`, `link`, `image_name`, `img_alt`, `img_title`, `ad_device`,`active`,`rowset`,`subset`) VALUES ('" . addslashes($data['banner_code_desktop']) . "', '" . addslashes($data['ads_count_list_desktop']) . "', '" . addslashes($data['ads_count_grid_desktop']) . "', '" . addslashes($data['link_desktop']) . "', '" . addslashes($data['image_name_desktop']) . "', '" . addslashes($data['img_title_desktop']) . "', '" . addslashes($data['img_title_desktop']) . "', 'desktop', '" . addslashes($data['active_desktop']) . "', '" . $rowset . "', '" . $subset . "')";
$pagetbl = mysqli_query($connection, $pagetbl);
$message = "Data updated successfully";
//header("Location:scroll_list");
}
#Desktop code ends -->
#Mobile code start -->
$data["ad_device_mobile"] = trim($_POST["ad_device_mobile"]);
$data["link_mobile"] = trim($_POST["link_mobile"]);
$data["img_title_mobile"] = trim($_POST["img_title_mobile"]);
$data["image_name_mobile"] = "";
$data["active_mobile"] = trim($_POST["active_mobile"]);
$data["banner_code_mobile"] = (!empty($_POST["banner_code_mobile"])) ? $_POST["banner_code_mobile"] : "";
$data["image_name_mobile"] = "";
#add the code
if (!empty($_FILES["image_name_mobile"]["name"])) {
#upload image code
$tmp_name = $_FILES['image_name_mobile']['tmp_name'];
$path = "../bg_images/scroll/";
$name = $_FILES['image_name_mobile']['name'];
$size = $_FILES['image_name_mobile']['size'];
$type = $_FILES['image_name_mobile']['type'];
$ext = strtolower(substr($name, strrpos($name, '.') + 1));
$name = time() . "_" . rand(0, 999999) . "." . $ext;
$target_file = $path . $name;
move_uploaded_file($_FILES["image_name_mobile"]["tmp_name"], $target_file);
$data["image_name_mobile"] = $name;
#delete old image
if (!empty($row["image_name"])) {
#delete old image
unlink("../bg_images/scroll/" . $row["image_name"]);
}
} else {
$data["image_name_mobile"] = !empty($_POST['old_image_mobile']) ? $_POST['old_image_mobile'] : "";
}
$query = "SELECT * from scroll_ads WHERE subset='" . $subset . "' and `ad_device`='mobile' ";
$result = mysqli_query($connection, $query);
if (mysqli_num_rows($result)) {
#update query
$pagetbl = "UPDATE `scroll_ads` set
`banner_code`='" . addslashes($data['banner_code_mobile']) . "',
`link`='" . addslashes($data['link_mobile']) . "',
`image_name`='" . addslashes($data['image_name_mobile']) . "',
`img_alt`='" . addslashes($data['img_title_mobile']) . "',
`img_title`='" . addslashes($data['img_title_mobile']) . "',
`active`='" . addslashes($data['active_mobile']) . "'
where `subset`= '" . $subset . "' and `ad_device`='mobile' ";
$pagetbl = mysqli_query($connection, $pagetbl);
$message = "Data updated successfully";
//header("Location:scroll_list");
} else {
#insert query for mobile
$pagetbl = "INSERT INTO `scroll_ads`(`banner_code`, `ads_count_list`, `ads_count_grid`, `link`, `image_name`, `img_alt`, `img_title`, `ad_device`,`active`,`rowset`,`subset`) VALUES ('" . addslashes($data['banner_code_mobile']) . "', '" . addslashes($data['ads_count_list_mobile']) . "', '" . addslashes($data['ads_count_grid_mobile']) . "', '" . addslashes($data['link_mobile']) . "', '" . addslashes($data['image_name_mobile']) . "', '" . addslashes($data['img_title_mobile']) . "', '" . addslashes($data['img_title_mobile']) . "', 'mobile', '" . addslashes($data['active_mobile']) . "', '" . $rowset . "', '" . $subset . "')";
$pagetbl = mysqli_query($connection, $pagetbl);
$message = "Data updated successfully";
//header("Location:scroll_list");
}
#Mobile code ends -->
#Tablet code start -->
$data["ad_device_tablet"] = trim($_POST["ad_device_tablet"]);
$data["link_tablet"] = trim($_POST["link_tablet"]);
$data["img_title_tablet"] = trim($_POST["img_title_tablet"]);
$data["image_name_tablet"] = "";
$data["active_tablet"] = trim($_POST["active_tablet"]);
$data["banner_code_tablet"] = (!empty($_POST["banner_code_tablet"])) ? $_POST["banner_code_tablet"] : "";
#add the code
if (!empty($_FILES["image_name_tablet"]["name"])) {
#upload image code
$tmp_name = $_FILES['image_name_tablet']['tmp_name'];
$path = "../bg_images/scroll/";
$name = $_FILES['image_name_tablet']['name'];
$size = $_FILES['image_name_tablet']['size'];
$type = $_FILES['image_name_tablet']['type'];
$ext = strtolower(substr($name, strrpos($name, '.') + 1));
$name = time() . "_" . rand(0, 999999) . "." . $ext;
$target_file = $path . $name;
move_uploaded_file($_FILES["image_name_tablet"]["tmp_name"], $target_file);
$data["image_name_tablet"] = $name;
#delete old image
if (!empty($row["image_name"])) {
#delete old image
unlink("../bg_images/scroll/" . $row["image_name"]);
}
} else {
$data["image_name_tablet"] = !empty($_POST['old_image_tablet']) ? $_POST['old_image_tablet'] : "";
}
$query = "SELECT * from scroll_ads WHERE subset='" . $subset . "' and `ad_device`='tablet' ";
$result = mysqli_query($connection, $query);
if (mysqli_num_rows($result)) {
#update query
$pagetbl = "UPDATE `scroll_ads` set
`banner_code`='" . addslashes($data['banner_code_tablet']) . "',
`link`='" . addslashes($data['link_tablet']) . "',
`image_name`='" . addslashes($data['image_name_tablet']) . "',
`img_alt`='" . addslashes($data['img_title_tablet']) . "',
`img_title`='" . addslashes($data['img_title_tablet']) . "',
`active`='" . addslashes($data['active_tablet']) . "'
where `subset`= '" . $subset . "' and `ad_device`='tablet' ";
$pagetbl = mysqli_query($connection, $pagetbl);
$message = "Data updated successfully";
//header("Location:scroll_list");
} else {
#insert query for tablet
$pagetbl = "INSERT INTO `scroll_ads`(`banner_code`, `ads_count_list`, `ads_count_grid`, `link`, `image_name`, `img_alt`, `img_title`, `ad_device`,`active`,`rowset`,`subset`) VALUES ('" . addslashes($data['banner_code_tablet']) . "', '" . addslashes($data['ads_count_list_tablet']) . "', '" . addslashes($data['ads_count_grid_tablet']) . "', '" . addslashes($data['link_tablet']) . "', '" . addslashes($data['image_name_tablet']) . "', '" . addslashes($data['img_title_tablet']) . "', '" . addslashes($data['img_title_tablet']) . "', 'tablet', '" . addslashes($data['active_tablet']) . "', '" . $rowset . "', '" . $subset . "')";
$pagetbl = mysqli_query($connection, $pagetbl);
$message = "Data updated successfully";
//header("Location:scroll_list");
}
#Tablet code ends -->
unset($_POST);
}
#Save code ends
if (!empty($_GET['item_id'])) {
#Desktop
$query = "SELECT * from scroll_ads WHERE subset='" . $subset . "' and ad_device='desktop'";
$result = mysqli_query($connection, $query);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$data = array();
$data["banner_code_desktop"] = trim($row["banner_code"]);
$data["ads_count_list_desktop"] = trim($row["ads_count_list"]);
$data["ads_count_grid_desktop"] = trim($row["ads_count_grid"]);
$data["ad_device_desktop"] = 'desktop';
$data["link_desktop"] = trim($row["link"]);
$data["img_title_desktop"] = trim($row["img_title"]);
$data["old_image_desktop"] = trim($row["image_name"]);;
$data["active_desktop"] = trim($row["active"]);
}
#Mobile
$query = "SELECT * from scroll_ads WHERE subset='" . $subset . "' and ad_device='mobile'";
$result = mysqli_query($connection, $query);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$data["banner_code_mobile"] = trim($row["banner_code"]);
$data["ads_count_list_mobile"] = trim($row["ads_count_list"]);
$data["ads_count_grid_mobile"] = trim($row["ads_count_grid"]);
$data["ad_device_mobile"] = 'mobile';
$data["link_mobile"] = trim($row["link"]);
$data["img_title_mobile"] = trim($row["img_title"]);
$data["old_image_mobile"] = trim($row["image_name"]);;
$data["active_mobile"] = trim($row["active"]);
}
#Mobile
$query = "SELECT * from scroll_ads WHERE subset='" . $subset . "' and ad_device='tablet'";
$result = mysqli_query($connection, $query);
if (mysqli_num_rows($result) > 0) {
$row = mysqli_fetch_assoc($result);
$data["banner_code_tablet"] = trim($row["banner_code"]);
$data["ads_count_list_tablet"] = trim($row["ads_count_list"]);
$data["ads_count_grid_tablet"] = trim($row["ads_count_grid"]);
$data["ad_device_tablet"] = 'tablet';
$data["link_tablet"] = trim($row["link"]);
$data["img_title_tablet"] = trim($row["img_title"]);
$data["old_image_tablet"] = trim($row["image_name"]);;
$data["active_tablet"] = trim($row["active"]);
}
}
?>
<!-- Header Start-->
<?php include("header.php"); ?>
<nav class=" navbar navbar-expand navbar-white navbar-light">
<ul class="navbar-nav">
<li class="nav-item">
<a class="nav-link" data-widget="pushmenu" href="#">
<i class="fa fa-bars" style="color:white;"></i>
</a>
</li>
</ul>
<div>
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item ">Scroll</li>
<li class="breadcrumb-item">Manage</li>
</ol>
</div>
</nav>
<!-- Header Ends-->
<!-- Content Start-->
<section class="content">
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card">
<!-- /.card-header -->
<div class="card-body">
<?php include_once 'notification.php'; ?>
<?php
$apnd = "?rowset=" . $rowset;
if (!empty($_GET['item_id'])) {
$apnd .= "&item_id=" . $_GET['item_id'];
}
?>
<form method="post" action="<?php echo MAIN_URL ?>/admin/scroll_add<?= $apnd ?>" enctype="multipart/form-data">
<input type="hidden" id="rowset" name="rowset" value="<?= $rowset ?>" />
<?php if (!empty($_GET["item_id"])) { ?>
<input type="hidden" id="subset" name="subset" value="<?= $_GET["item_id"] ?>" />
<?php } else { ?>
<input type="hidden" id="subset" name="subset" value="<?= $subset ?>" />
<?php } ?>
<!-- Desktop -->
<div class="row">
<div class="form-group form-check-inline">
<input type="text" class="form-control" id="ad_device_desktop" name="ad_device_desktop" value="desktop" readonly="true" style="width:80px;">
</div>
<div class="form-group form-check-inline">
<input type="number" class="form-control" id="ads_count_list_desktop" name="ads_count_list_desktop" placeholder="Show after every No. Ads[List]" title="Show after every No. Ads[List]" value="<?php if (!empty($data["ads_count_list_desktop"])) {
echo $data["ads_count_list_desktop"];
} ?>" required>
</div>
<!--<div class="form-group form-check-inline">
<input type="number" class="form-control" id="ads_count_grid_desktop" placeholder="Show after every No. Ads[Grid]" title="Show after every No. Ads[Grid]" name="ads_count_grid_desktop" value="<?php if (!empty($data["ads_count_grid_desktop"])) {
echo $data["ads_count_grid_desktop"];
} ?>" required >
</div>-->
<div class="form-group form-check-inline">
<textarea title="Link" alt="Link" class="form-control" id="link_desktop" cols="40" name="link_desktop" placeholder="Link"><?php if (!empty($data["link_desktop"])) {
echo $data["link_desktop"];
} ?></textarea>
</div>
<div class="form-group form-check-inline">
<select class="form-control" title="Banner Code" id="banner_code_desktop" name="banner_code_desktop">
<option value="0" <?php if (isset($data["banner_code_desktop"]) && trim($data["banner_code_desktop"]) == "0") { ?> selected="selected" <?php } ?>>Image</option>
<option value="1" <?php if (isset($data["banner_code_desktop"]) && trim($data["banner_code_desktop"]) == "1") { ?> selected="selected" <?php } ?>>Code</option>
</select>
</div>
<div class="form-group form-check-inline">
<input type="text" title="Image Title" alt="Image Title" class="form-control" id="img_title_desktop" name="img_title_desktop" placeholder="Title" value="<?php if (!empty($data["img_title_desktop"])) {
echo $data["img_title_desktop"];
} ?>">
</div>
<div class="form-group form-check-inline">
<input title="Image" alt="Image" name="image_name_desktop" id="image_name_desktop" type="file" placeholder="Upload Image" value="Upload Image">
</div>
<input type="hidden" name="old_image_desktop" id="old_image_desktop" value="<?php if (!empty($data["old_image_desktop"])) {
echo $data['old_image_desktop'];
} else {
echo "";
} ?>" />
<?php if (!empty($data["old_image_desktop"])) { ?>
<div class="form-group form-check-inline">
<img src="<?= MAIN_URL ?>/bg_images/scroll/<?= $data['old_image_desktop'] ?>" width="60px;" />
</div>
<?php } ?>
<div class="form-group form-check-inline">
<select class="form-control" title="Select Link Active" id="active_desktop" name="active_desktop">
<option value="1" <?php if (isset($data["active"]) && trim($data["active"]) == "1") { ?> selected="selected" <?php } ?>>Active</option>
<option value="0" <?php if (isset($data["active"]) && trim($data["active"]) == "0") { ?> selected="selected" <?php } ?>>Inactive</option>
</select>
</div>
</div>
<!-- Desktop -->
<!-- Mobile -->
<div class="row">
<div class="form-group form-check-inline">
<input type="text" class="form-control" id="ad_device_mobile" name="ad_device_mobile" value="mobile" readonly="true" style="width:80px;">
</div>
<div class="form-group form-check-inline">
<input type="number" class="form-control" id="ads_count_list_mobile" name="ads_count_list_mobile" placeholder="Show after every No. Ads[List]" title="Show after every No. Ads[List]" value="<?php if (!empty($data["ads_count_list_mobile"])) {
echo $data["ads_count_list_mobile"];
} ?>" required>
</div>
<!--<div class="form-group form-check-inline">
<input type="number" class="form-control" id="ads_count_grid_mobile" placeholder="Show after every No. Ads[List]" title="Show after every No. Ads[List]" name="ads_count_grid_mobile" value="<?php if (!empty($data["ads_count_grid_mobile"])) {
echo $data["ads_count_grid_mobile"];
} ?>" required >
</div>-->
<div class="form-group form-check-inline">
<textarea title="Link" alt="Link" class="form-control" id="link_mobile" cols="40" name="link_mobile" placeholder="Link"><?php if (!empty($data["link_mobile"])) {
echo $data["link_mobile"];
} ?></textarea>
</div>
<div class="form-group form-check-inline">
<select class="form-control" title="Banner Code" id="banner_code_mobile" name="banner_code_mobile">
<option value="0" <?php if (isset($data["banner_code_mobile"]) && trim($data["banner_code_mobile"]) == "0") { ?> selected="selected" <?php } ?>>Image</option>
<option value="1" <?php if (isset($data["banner_code_mobile"]) && trim($data["banner_code_mobile"]) == "1") { ?> selected="selected" <?php } ?>>Code</option>
</select>
</div>
<div class="form-group form-check-inline">
<input type="text" title="Image Title" alt="Image Title" class="form-control" id="img_title_mobile" name="img_title_mobile" placeholder="Title" value="<?php if (!empty($data["img_title_mobile"])) {
echo $data["img_title_mobile"];
} ?>">
</div>
<div class="form-group form-check-inline">
<input title="Image" alt="Image" name="image_name_mobile" id="image_name_mobile" type="file" placeholder="Upload Image" value="Upload Image">
</div>
<input type="hidden" name="old_image_mobile" id="old_image_mobile" value="<?php if (!empty($data["old_image_mobile"])) {
echo $data['old_image_mobile'];
} else {
echo "";
} ?>" />
<?php if (!empty($data["old_image_mobile"])) { ?>
<div class="form-group form-check-inline">
<img src="<?= MAIN_URL ?>/bg_images/scroll/<?= $data['old_image_mobile'] ?>" width="60px;" />
</div>
<?php } ?>
<div class="form-group form-check-inline">
<select class="form-control" title="Select Link Active" id="active_mobile" name="active_mobile">
<option value="1" <?php if (isset($data["active"]) && trim($data["active"]) == "1") { ?> selected="selected" <?php } ?>>Active</option>
<option value="0" <?php if (isset($data["active"]) && trim($data["active"]) == "0") { ?> selected="selected" <?php } ?>>Inactive</option>
</select>
</div>
</div>
<!-- Mobile -->
<!-- Tablet -->
<div class="row">
<div class="form-group form-check-inline">
<input type="text" class="form-control" id="ad_device_tablet" name="ad_device_tablet" value="tablet" readonly="true" style="width:80px;">
</div>
<div class="form-group form-check-inline">
<input type="number" class="form-control" id="ads_count_list_tablet" name="ads_count_list_tablet" placeholder="Show after every No. Ads[List]" title="Show after every No. Ads[List]" value="<?php if (!empty($data["ads_count_list_tablet"])) {
echo $data["ads_count_list_tablet"];
} ?>" required>
</div>
<!--<div class="form-group form-check-inline">
<input type="number" class="form-control" id="ads_count_grid_tablet" placeholder="Show after every No. Ads[List]" title="Show after every No. Ads[List]" name="ads_count_grid_tablet" value="<?php if (!empty($data["ads_count_grid_tablet"])) {
echo $data["ads_count_grid_tablet"];
} ?>" required >
</div>-->
<div class="form-group form-check-inline">
<textarea title="Link" alt="Link" class="form-control" id="link_tablet" cols="40" name="link_tablet" placeholder="Link"><?php if (!empty($data["link_tablet"])) {
echo $data["link_tablet"];
} ?></textarea>
</div>
<div class="form-group form-check-inline">
<select class="form-control" title="Banner Code" id="banner_code_tablet" name="banner_code_tablet">
<option value="0" <?php if (isset($data["banner_code_tablet"]) && trim($data["banner_code_tablet"]) == "0") { ?> selected="selected" <?php } ?>>Image</option>
<option value="1" <?php if (isset($data["banner_code_tablet"]) && trim($data["banner_code_tablet"]) == "1") { ?> selected="selected" <?php } ?>>Code</option>
</select>
</div>
<div class="form-group form-check-inline">
<input type="text" title="Image Title" alt="Image Title" class="form-control" id="img_title_tablet" name="img_title_tablet" placeholder="Title" value="<?php if (!empty($data["img_title_tablet"])) {
echo $data["img_title_tablet"];
} ?>">
</div>
<div class="form-group form-check-inline">
<input title="Image" alt="Image" name="image_name_tablet" id="image_name_tablet" type="file" placeholder="Upload Image" value="Upload Image">
</div>
<input type="hidden" name="old_image_tablet" id="old_image_tablet" value="<?php if (!empty($data["old_image_tablet"])) {
echo $data['old_image_tablet'];
} else {
echo "";
} ?>" />
<?php if (!empty($data["old_image_tablet"])) { ?>
<div class="form-group form-check-inline">
<img src="<?= MAIN_URL ?>/bg_images/scroll/<?= $data['old_image_tablet'] ?>" width="60px;" />
</div>
<?php } ?>
<div class="form-group form-check-inline">
<select class="form-control" title="Select Link Active" id="active_tablet" name="active_tablet">
<option value="1" <?php if (isset($data["active"]) && trim($data["active"]) == "1") { ?> selected="selected" <?php } ?>>Active</option>
<option value="0" <?php if (isset($data["active"]) && trim($data["active"]) == "0") { ?> selected="selected" <?php } ?>>Inactive</option>
</select>
</div>
</div>
<!-- Tablet -->
<div class="row">
<div class="form-group form-check-inline">
<button type="submit" class="btn btn-primary">Add Banner</button>
<input type="hidden" name="Process" id="Process" value="AddNow" />
</div>
<div class="form-group form-check-inline">
<button type="button" class="btn btn-primary" title="Reset" onClick="change_url()">RESET</button>
</div>
</div>
</form>
<?php $query = "SELECT* from scroll_ads WHERE rowset ='" . $rowset . "' group by subset";
$sql = mysqli_query($connection, $query);
$data = array();
if (mysqli_num_rows($sql) > 0) { ?>
<hr />
<table id="ads_table" class="table table-bordered table-striped text-nowrap" width="100%">
<thead>
<tr>
<!--<th>ID</th>-->
<th>Device</th>
<th>Link</th>
<th>Title</th>
<th>Image</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php while ($record = mysqli_fetch_assoc($sql)) { ?>
<tr>
<!--<td><?= $record["id"] ?></td>-->
<td><?php echo "Multi"; ?></td>
<td>
<?php if ($record["banner_code"] == 1) { ?>
Banner
<?php } else { ?>
<a class="search_link" href=<?= $record['link'] ?> target="_blank" title="<?= $record['link'] ?>" alt="<?= $record['link'] ?>"><?= substr($record['link'], 0, 60) ?>...</a>
<?php } ?>
</td>
<td><?= $record["img_title"] ?></td>
<td>
<?php if (!empty($record['image_name'])) { ?>
<a class="image_popup" href="<?= MAIN_URL ?>/bg_images/scroll/<?= $record['image_name'] ?>" target="_blank" title="<?= $record['img_title'] ?>" alt="<?= $record['img_title'] ?>"><img class="img-fluid" width="80px;" src="<?= MAIN_URL ?>/bg_images/scroll/<?= $record['image_name'] ?>"></a>
<?php } ?>
</td>
<td>
<?php if ($record['active'] == "1") {
echo "Active";
} else {
echo "Inactive";
} ?>
</td>
<td>
<a href='scroll_add.php?rowset=<?= $record['rowset'] ?>&item_id=<?= $record['subset'] ?>' class='edit_user btn menu-icon vd_bg-yellow' title='Edit Banner'><i class='fa fa-edit fa-lg'></i></a>
<button id='delete_user_<?= $record['subset'] ?>' type='button' class='btn menu-icon vd_bg-red delete_user' data-id='<?= $record['subset'] ?>' title='Delete Banner'><i class='fa fa-trash fa-lg'></i></button>
</td>
</tr>
<?php } //while
?>
</table>
<?php } ?>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
</div>
<!-- /.row (main row) -->
</div><!-- /.container-fluid -->
</section>
<!-- Content Ends-->
<script type="text/javascript">
function change_url(val) {
//alert($('.ssh').val());
var rowset = $("#rowset").val();
window.location = "<?php echo MAIN_URL ?>/admin/scroll_add?rowset=" + rowset;
}
$(document.body).on('click', '.delete_user', function(e) {
if (confirm("Are you sure!") == true) {} else {
return false;
}
var crud = 'delete';
var val = $(this).data("id");
//alert(val);return false;
$.ajax({
url: 'service/delete_scroll_item',
type: 'post',
data: {
crud: crud,
value: val
},
success: function(data) {
if (data == '1') {
$(".modal-backdrop").remove();
$('#delete_user_' + val).closest("tr").remove();
//window.location.href = window.location.href;
}
}
});
$('.btn-confirm-delete').unbind();
});
/*$(document.body).on('click', '.delete_user', function(e){
$(".btn-confirm-delete").attr("data-id",$(this).data('id'));
$('.delete_user').unbind();
});*/
</script>
<!-- Footer Start-->
<?php include("footer.php"); ?>
<!-- Footer Ends-->