hasFuse(HK_USER_ID, 'fuse_housekeeping_catalog')) { exit; } if (!isset($_GET['sq'])) { $_GET['sq'] = ""; } if (isset($_GET['new'])) { dbquery("INSERT INTO catalog_items (page_id,item_ids,catalog_name,cost_credits,cost_pixels,amount) VALUES (137,1,'',10,0,1)"); fMessage('ok', 'New catalog item stub added'); $newId = mysql_result(dbquery("SELECT id FROM catalog_items ORDER BY id DESC LIMIT 1"), 0); header("Location: ./index.php?_cmd=ot-cata-items&edit=" . $newId); exit; } if (isset($_GET['del'])) { fMessage('error', 'Are you SURE you want to delete that catalog item? This CAN NOT be reversed.
YES, DELETE IT - or - CANCEL'); } if (isset($_GET['realdel'])) { fMessage('ok', 'Item def deleted!'); dbquery("DELETE FROM catalog_items WHERE id = '" . intval($_GET['realdel']) . "' LIMIT 1"); header("Location: ./index.php?_cmd=ot-cata-items&sq=" . $_GET['sq']); exit; } $data = null; $lockedVars = array('id','gonew'); if (isset($_GET['edit'])) { $i = intval($_GET['edit']); $get = dbquery("SELECT * FROM catalog_items WHERE id = '" . $i . "' LIMIT 1"); if (mysql_num_rows($get) == 0) { fMessage('error', 'Oops! Invalid item.'); } else { $data = mysql_fetch_assoc($get); if (isset($_POST['page_id'])) { $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_items SET " . $qB . " WHERE id = '" . intval($_GET['edit']) . "' LIMIT 1"); fMessage('ok', 'Updated cata item successfully'); if (isset($_POST['gonew']) && $_POST['gonew'] == "y") { header("Location: ./index.php?_cmd=ot-cata-items&new"); } else { header("Location: ./index.php?_cmd=ot-cata-items&edit=" . $data['id']); } exit; } } } require_once "top.php"; echo '

Manage catalogue items

'; $checkBlankItems = dbquery("SELECT id,page_id FROM catalog_items WHERE item_ids = '1' AND catalog_name = ''"); if (mysql_num_rows($checkBlankItems) > 0) { echo '
'; echo '

'; echo 'Warning! There are blank items in the database:
'; echo '

'; echo '

'; echo '
'; } if ($data != null) { echo '

'; echo 'Editing cata item'; echo '

' . $data['catalog_name'] . '


'; echo '
'; foreach ($data as $key => $value) { $lck = false; if (in_array($key, $lockedVars)) { $lck = true; } echo $key . ':


'; } echo ' Create & go to new stub after saving
'; echo ' '; echo ''; echo '
'; echo '
'; } else { echo '

'; if (!isset($_POST['search-query']) && isset($_GET['sq'])) { $_POST['search-query'] = $_GET['sq']; } if (isset($_POST['search-query'])) { $_POST['search-query'] = filter($_POST['search-query']); $getPages = dbquery("SELECT * FROM catalog_items WHERE catalog_name LIKE '%" . $_POST['search-query'] . "%' OR id = '" . $_POST['search-query'] . "' OR item_ids = '" . $_POST['search-query'] . "' OR page_id = '" . $_POST['search-query'] . "' ORDER BY item_ids ASC"); echo 'Generate new cata item stub

'; echo ''; while ($page = mysql_fetch_assoc($getPages)) { echo ''; } echo '
ID Page ID Defenition Ref Name Cost Amount Options
' . $page['id'] . ' ' . $page['page_id'] . ' ' . $page['item_ids'] . ' ' . $page['catalog_name'] . ' ' . $page['cost_credits'] . ' CR, ' . $page['cost_pixels'] . ' PX ' . $page['amount'] . ' [View detail/edit] [Remove]

'; } else { echo '
Please search for something first.

'; } } echo 'Generate new cata item stub'; echo ' '; require_once "bottom.php"; ?>