File: /home/httpd/html/freecams1.com/public_html/admin/niches.php
<?php
require "db.php";
if ($_POST['list']) {
foreach ($_POST['list'] as $i) {
if (is_numeric($i)) {
dbQuery("DELETE FROM `niches` WHERE `record_num` = '$i'");
dbQuery("DELETE FROM `niches_languages` WHERE `niche` = '$i'");
dbQuery("DELETE FROM `content_niches` WHERE `niche` = '$i'");
}
}
}
if (isset($_POST['formSubmit'])) {
$_POST = array_map_array('trim', $_POST);
$post = mysql_real_escape_array($_POST);
if ($_POST['name'] == '') {
setMessage('"Category Name" is required!', 'error');
} else if (is_array(dbRow("SELECT * FROM `niches` WHERE `name` = '$post[name]'"))) {
setMessage('Such category (name) already exist!', 'error');
}
if (!getMessages(false, 'error')) {
$insert_id = dbInsert('niches', array(
'name' => $_POST['name'],
'description' => $_POST['description'],
'metakw' => $_POST['metakw'],
'metadesc' => $_POST['metadesc'],
'csv_match' => $_POST['csv_match'],
'metatitle' => $_POST['metatitle'],
'metaheader' => $_POST['metaheader'],
'flag_navigation' => (int) $_POST['flag_navigation'],
'paysite' => (int) $_POST['paysite']
));
if (is_numeric($insert_id)) {
if ($_FILES['postroll']['tmp_name']) {
$category_thumb = "cat{$insert_id}.jpg";
move_uploaded_file($_FILES['postroll']['tmp_name'], "$misc_path/$category_thumb");
}
foreach ($_POST['lang'] as $k => $v) {
dbInsert('niches_languages', array(
'niche' => $insert_id,
'language' => $k,
'name' => $v['name'],
'data' => serialize($v),
));
}
}
setMessage("Category has been added!");
header("Location: $_SERVER[REQUEST_URI]");
exit();
} else {
entities_walk($_POST);
}
}
$page = (isset($_GET['page']) && is_numeric($_GET['page'])) ? (int) $_GET['page'] : 1;
$max_results = (isset($_GET['setmax']) && $_GET['setmax'] > 0) ? (int) $_GET['setmax'] : 100;
$from = ($page * $max_results) - $max_results;
?>
<? require "header.php"; ?>
<script>
$().ready(function () {
$('.lang-selection a').on('click', function (e) {
e.preventDefault();
$('.lang-selection').find('a.active').removeClass('active');
$(this).addClass('active');
var activeItems = $(this).attr('href').replace("#", "");
$('#languages').find('.langInput').hide();
$('#languages').find('.' + activeItems).show();
return false;
});
});
</script>
<div class="content-page">
<div class="header-area">
<div class="breadcrumbs">
<a href="index.php">Admin Home</a>
<span><a href="niches.php">Categories</a></span>
</div>
</div>
<div class="content-outer">
<h2>Manage<strong>Categories</strong></h2>
<div class="content-inner">
<? echo getMessages(); ?>
<form method="POST" action="" enctype="multipart/form-data" class="form" novalidate autocomplete="off">
<table class="pagetable" id="languages">
<thead>
<tr>
<th colspan="2">Add Category</th>
</tr>
</thead>
<tbody>
<tr>
<td colspan="2" class="lang-selection">
<ul class="tabs custom">
<li><a href="#baseLang" class="tab active">Default</a></li>
<? foreach ($languages as $l) { ?>
<li><a href="#<? echo $l['iso']; ?>" class="tab"><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i><? echo $l['iso']; ?></a></li>
<? } ?>
</ul>
</td>
</tr>
<tr class="baseLang langInput">
<td>Name</td>
<td><input name="name" type="text" required value="<? echo $_POST['name']; ?>" /></td>
</tr>
<? foreach ($languages as $l) { ?>
<tr class="<? echo $l['iso']; ?> langInput" style="display: none;">
<td><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i>Name (<? echo $l['name']; ?>/<? echo $l['iso']; ?>)</td>
<td><input name="lang[<? echo $l['iso']; ?>][name]" type="text" value="<? echo $_POST['lang'][$l['iso']]['name']; ?>" /></td>
</tr>
<? } ?>
<tr class="baseLang langInput">
<td>Title Tag</td>
<td><input name="metatitle" type="text" value="<? echo $_POST['metatitle']; ?>" /></td>
</tr>
<? foreach ($languages as $l) { ?>
<tr class="<? echo $l['iso']; ?> langInput" style="display: none;">
<td><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i>Title Tag (<? echo $l['name']; ?>/<? echo $l['iso']; ?>)</td>
<td><input name="lang[<? echo $l['iso']; ?>][metatitle]" type="text" value="<? echo $_POST['lang'][$l['iso']]['metatitle']; ?>" /></td>
</tr>
<? } ?>
<tr class="baseLang langInput">
<td>Header Title</td>
<td><input name="metaheader" type="text" value="<? echo $_POST['metaheader']; ?>" /></td>
</tr>
<? foreach ($languages as $l) { ?>
<tr class="<? echo $l['iso']; ?> langInput" style="display: none;">
<td><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i>Header Title (<? echo $l['name']; ?>/<? echo $l['iso']; ?>)</td>
<td><input name="lang[<? echo $l['iso']; ?>][metaheader]" type="text" value="<? echo $_POST['lang'][$l['iso']]['metaheader']; ?>" /></td>
</tr>
<? } ?>
<tr class="baseLang langInput">
<td>Meta KW</td>
<td><input name="metakw" type="text" value="<? echo $_POST['metakw']; ?>" /></td>
</tr>
<? foreach ($languages as $l) { ?>
<tr class="<? echo $l['iso']; ?> langInput" style="display: none;">
<td><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i>Meta KW (<? echo $l['name']; ?>/<? echo $l['iso']; ?>)</td>
<td><input name="lang[<? echo $l['iso']; ?>][metakw]" type="text" value="<? echo $_POST['lang'][$l['iso']]['metakw']; ?>" /></td>
</tr>
<? } ?>
<tr class="baseLang langInput">
<td>Meta Desc</td>
<td><input name="metadesc" type="text" value="<? echo $_POST['metadesc']; ?>" /></td>
</tr>
<? foreach ($languages as $l) { ?>
<tr class="<? echo $l['iso']; ?> langInput" style="display: none;">
<td><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i>Meta Desc (<? echo $l['name']; ?>/<? echo $l['iso']; ?>)</td>
<td><input name="lang[<? echo $l['iso']; ?>][metadesc]" type="text" value="<? echo $_POST['lang'][$l['iso']]['metadesc']; ?>" /></td>
</tr>
<? } ?>
<tr class="baseLang langInput">
<td>Description</td>
<td><textarea name="description" cols="35" rows="4"><? echo $_POST['description']; ?></textarea></td>
</tr>
<? foreach ($languages as $l) { ?>
<tr class="<? echo $l['iso']; ?> langInput" style="display: none;">
<td><i class="flag-icon flag-icon-<? echo strtolower($l['iso']); ?>"></i>Description (<? echo $l['name']; ?>/<? echo $l['iso']; ?>)</td>
<td><textarea name="lang[<? echo $l['iso']; ?>][description]" cols="35" rows="4"><? echo $_POST['lang'][$l['iso']]['description']; ?></textarea></td>
</tr>
<? } ?>
<tr>
<td>Import Match</td>
<td><input name="csv_match" type="text" value="<? echo $_POST['csv_match']; ?>" /></td>
</tr>
<tr>
<td>Image</td>
<td><input type="file" name="postroll" data-extensions="jpg,jpeg"/></td>
</tr>
<tr>
<td>Show in Navigation Toolbar</td>
<td>
<select name="flag_navigation">
<option<? echo ($_POST['flag_navigation'] == '0') ? ' selected' : ''; ?> value="0">No</option>
<option<? echo ($_POST['flag_navigation'] == '1') ? ' selected' : ''; ?> value="1">Yes</option>
</select>
</td>
</tr>
<tr>
<td>Paysite Ad Group</td>
<td>
<select name="paysite">
<option value="0">None</option>
<?php
$rresult = dbQuery("SELECT * FROM paysites ORDER BY name ASC", false);
foreach ($rresult as $rrow) {
?>
<option<?php echo $_POST['paysite'] == $rrow['record_num'] ? ' selected' : ''; ?> value="<?php echo $rrow['record_num']; ?>"><?php echo $rrow['name']; ?></option>
<?php } ?>
</select>
</td>
</tr>
<tr class="item submit">
<td colspan="2">
<input type="hidden" name="formSubmit" value="1" />
<button type="submit" class="btn action-save">Submit</button>
</td>
</tr>
</tbody>
</table>
</form>
<form method="POST" action="" enctype="multipart/form-data" class="form" novalidate autocomplete="off">
<table class="pagetable">
<thead>
<tr>
<th class="thumb">Thumbnail</th>
<th>Name</th>
<th class="options"></th>
<th style="width:50px">
<label for="check-select-all-1" class="checkbox">
<input type="checkbox" name="select_all" value="1" data-items="list[]" id="check-select-all-1">
<i></i>
</label>
</th>
</tr>
</thead>
<tbody>
<?
$result = dbQuery("SELECT *, (SELECT COUNT(*) FROM `content_niches` WHERE `niche` = `niches`.`record_num`) AS `content__amount` FROM `niches` ORDER BY `name` LIMIT $from, $max_results",false);
$total_results = dbValue("SELECT COUNT(*) AS `count` FROM `niches`", 'count');
$total_pages = ceil($total_results / $max_results);
?>
<? if (count($result) == 0) { ?>
<tr><td colspan="4"><div class="notification alert">No niches found</div></td></tr>
<? } else { ?>
<? foreach($result as $row) { ?>
<tr>
<td class="thumb">
<? if (file_exists($misc_path . '/cat' . $row['record_num'] . '.jpg')) { ?>
<img src="<? echo $misc_url; ?>/cat<? echo $row['record_num']; ?>.jpg" alt="<? echo $row['name']; ?>" />
<? } else { ?>
<img src="<? echo $basehttp; ?>/core/images/catdefault.jpg" alt="<? echo $row['name']; ?>">
<? } ?></td>
<td><? echo $row['name']; ?><br />Content Amount: <? echo $row['content__amount']; ?></td>
<td class="options">
<a href="edit_niche.php?id=<? echo $row[record_num]; ?>" class="btn btn-xs btn-orange" title="Edit Niche"><i class="ion ion-edit icon-edit"></i></a>
</td>
<td>
<label class="checkbox">
<input type="checkbox" name="list[]" value="<? echo $row['record_num']; ?>" id="ids-<? echo $row['record_num']; ?>"><i></i>
</label>
</td>
</tr>
<? } ?>
<? } ?>
<tr class="item submit">
<td colspan="4">
<button type="submit" class="btn action-delete">Delete Selected</button>
</td>
</tr>
</tbody>
</table>
</form>
<div id="adminPagination"><? echo showAdminPagination($total_pages); ?></div>
</div>
</div>
</div>
<? require "footer.php"; ?>