hasFuse(HK_USER_ID, 'fuse_housekeeping_catalog')) { exit; } if (!isset($_GET['sq'])) { $_GET['sq'] = ""; } if (!isset($_POST['search-query']) && isset($_GET['sq'])) { $_POST['search-query'] = $_GET['sq']; } if ($_GET['sq'] == '' || !isset($_GET['sq']) && isset($_POST['search-query']) && strlen($_POST['search-query']) > 0) { $_GET['sq'] = $_POST['search-query']; } if (isset($_GET['new'])) { dbquery("INSERT INTO furniture (public_name,item_name,type,length,width,stack_height,can_stack,sprite_id,interaction_type) VALUES ('','newitem', 's', '1', '1', '1', '1', '1', 'switch')"); fMessage('ok', 'New item def stub added'); $newId = mysql_result(dbquery("SELECT id FROM furniture ORDER BY id DESC LIMIT 1"), 0); header("Location: ./index.php?_cmd=ot-def&edit=" . $newId); exit; } if (isset($_GET['del'])) { fMessage('error', 'Are you SURE you want to delete that item def? This CAN NOT be reversed.
YES, DELETE IT - or - CANCEL'); } if (isset($_GET['realdel'])) { fMessage('ok', 'Item def deleted!'); dbquery("DELETE FROM furniture WHERE id = '" . intval($_GET['realdel']) . "' LIMIT 1"); header("Location: ./index.php?_cmd=ot-def&sq=" . $_GET['sq']); exit; } $data = null; $lockedVars = array('id','gonew','search-query'); if (isset($_GET['edit'])) { $i = intval($_GET['edit']); $get = dbquery("SELECT * FROM furniture 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['public_name'])) { $i = 0; $qB = ''; foreach ($_POST as $key => $value) { if (in_array($key, $lockedVars)) { continue; } $i++; if ($i > 1) { $qB .= ','; } $qB .= $key . " = '" . filter($value) . "'"; } dbquery("UPDATE furniture 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-def&new"); } else { header("Location: ./index.php?_cmd=ot-def&edit=" . $data['id'] . "&sq=" . $_GET['sq']); } exit; } } } require_once "top.php"; echo '

Manage item defenitions

'; ?> 0) { echo '
'; echo '

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

'; echo '

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

'; echo 'Editing item'; echo '

' . $data['public_name'] . '


'; echo '
'; echo ''; echo '
'; echo 'Insert magic block here:

'; 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'])) { $_POST['search-query'] = filter($_POST['search-query']); $getPages = dbquery("SELECT * FROM furniture WHERE item_name LIKE '%" . $_POST['search-query'] . "%' OR public_name LIKE '%" . $_POST['search-query'] . "%' OR id = '" . $_POST['search-query'] . "'"); echo 'Generate new item def stub

'; echo ''; while ($page = mysql_fetch_assoc($getPages)) { $res = 'NO'; if (mysql_num_rows(dbquery("SELECT null FROM catalog_items WHERE item_ids = '" . $page['id'] . "' LIMIT 1")) >= 1) { $res = 'YES'; } if ($res == 'YES' && strlen($_POST['search-query']) < 1 && strlen($_GET['sq']) < 1) { continue; } echo ''; } echo '
ID Public Name Internal Name Type Interaction Type Options Has cata entry
' . $page['id'] . ' ' . $page['public_name'] . ' ' . $page['item_name'] . ' ' . $page['type'] . ' ' . $page['interaction_type'] . ' [View detail/edit] [Remove] ' . $res . '

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

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