hasFuse(HK_USER_ID, 'fuse_housekeeping_catalog'))
{
exit;
}
if (isset($_GET['unsetCat']))
{
unset($_SESSION['OT_PAGE_CAT']);
}
if (!isset($_SESSION['OT_PAGE_CAT']))
{
if (isset($_POST['OT_PAGE_CAT']))
{
$_SESSION['OT_PAGE_CAT'] = $_POST['OT_PAGE_CAT'];
}
else
{
require_once "top.php";
echo 'Select a category to edit:
';
echo '';
require_once "bottom.php";
exit;
}
}
$newOrderId = mysql_result(dbquery("SELECT order_num FROM catalog_pages WHERE parent_id = '" . $_SESSION['OT_PAGE_CAT'] . "' ORDER BY order_num DESC"), 0) + 1;
if (!isset($_GET['sq']))
{
$_GET['sq'] = "";
}
if (isset($_GET['new']))
{
dbquery("INSERT INTO catalog_pages (parent_id,caption,icon_color,icon_image,visible,enabled,order_num,page_layout,page_text_details,page_headline) VALUES ('" . $_SESSION['OT_PAGE_CAT'] . "','', '0', '1', '1', '1', '" . $newOrderId . "', 'default_3x3','Click on an item for more information.','catalog_frontpage_headline2_en')");
fMessage('ok', 'New page stub added');
$newId = mysql_result(dbquery("SELECT id FROM catalog_pages ORDER BY id DESC LIMIT 1"), 0);
header("Location: ./index.php?_cmd=ot-pages&edit=" . $newId);
exit;
}
if (isset($_GET['del']))
{
fMessage('error', 'Are you SURE you want to delete that page? This CAN NOT be reversed.
YES, DELETE IT - or - CANCEL');
}
if (isset($_GET['realdel']))
{
fMessage('ok', 'Page deleted!');
dbquery("DELETE FROM catalog_pages WHERE id = '" . intval($_GET['realdel']) . "' AND parent_id = '" . $_SESSION['OT_PAGE_CAT'] . "' LIMIT 1");
header("Location: ./index.php?_cmd=ot-pages&");
exit;
}
$data = null;
$lockedVars = array('id','parent_id','type','gonew');
if (isset($_GET['edit']))
{
$i = intval($_GET['edit']);
$get = dbquery("SELECT * FROM catalog_pages WHERE id = '" . $i . "' AND parent_id = '" . $_SESSION['OT_PAGE_CAT'] . "' LIMIT 1");
if (mysql_num_rows($get) == 0)
{
fMessage('error', 'Oops! Invalid item.');
}
else
{
$data = mysql_fetch_assoc($get);
if (isset($_POST['caption']))
{
$i = 0;
$qB = '';
foreach ($_POST as $key => $value)
{
$i++;
if (in_array($key, $lockedVars))
{
continue;
}
if ($i > 1)
{
$qB .= ',';
}
$qB .= $key . " = '" . filter($value) . "'";
}
dbquery("UPDATE catalog_pages SET " . $qB . " WHERE id = '" . intval($_GET['edit']) . "' LIMIT 1");
fMessage('ok', 'Updated item successfully');
if (isset($_POST['gonew']) && $_POST['gonew'] == "y")
{
header("Location: ./index.php?_cmd=ot-pages&new");
}
else
{
header("Location: ./index.php?_cmd=ot-pages&edit=" . $data['id']);
}
exit;
}
}
}
if (isset($_POST['update-order']))
{
foreach ($_POST as $key => $value)
{
if ($key == 'update-order')
{
continue;
}
if (substr($key, 0, 4) != 'ord-')
{
die("Invalid: " . $key);
continue;
}
$id = intval(substr($key, 4));
dbquery("UPDATE catalog_pages SET order_num = '" . intval($value) . "' WHERE id = '" . $id . "' AND parent_id = '" . $_SESSION['OT_PAGE_CAT'] . "' LIMIT 1");
}
fMessage('ok', 'Updated page order.');
}
require_once "top.php";
echo 'Manage catalogue pages
';
echo '
Editing category: ' . mysql_result(dbquery("SELECT caption FROM catalog_pages WHERE id = '" . $_SESSION['OT_PAGE_CAT'] . "' LIMIT 1"), 0) . ' (Change)';
echo '
';
if ($data != null)
{
echo '
';
echo 'Editing item';
echo '' . $data['caption'] . '
';
echo '';
echo '
';
}
$getPages = dbquery("SELECT * FROM catalog_pages WHERE parent_id = '" . $_SESSION['OT_PAGE_CAT'] . "' ORDER BY order_num ASC");
echo 'Generate new page stub
';
echo '
| ID |
Caption |
Visible |
Enabled |
Layout |
Order |
Options |
or
';
echo 'Generate new page stub';
echo '
';
require_once "bottom.php";
?>