addLocale("housekeeping.catalogue"); $page['name'] = $lang->loc['pagename.catalogue']; $page['category'] = "tools"; require_once('./templates/housekeeping_header.php'); if(isset($_GET['do']) && $_GET['do'] == "save"){ $row = $_POST; if(empty($row['data'])){ $error = $lang->loc['error.no.data']."
"; } if(empty($row['price']) || !is_numeric($row['price'])){ $error = $lang->loc['invalid.price']."
"; } if(empty($row['amount']) || !is_numeric($row['amount'])){ $error = $lang->loc['invalid.amount']."
"; } if(empty($row['minrank']) || !is_numeric($row['minrank'])){ $error = $lang->loc['invalid.minrank']."
"; } if($row['categoryid'] == "new"){ if(empty($row['new_category'])){ $error = $lang->loc['invalid.new.category']; }else{ $id = (int) $db->result($db->query("SELECT MAX(id) FROM ".PREFIX."homes_catalogue LIMIT 1")); $row['categoryid'] = $id + 1; $row['category'] = $row['new_category']; } }else{ $category = explode(",",$row['categoryid'],2); $row['categoryid'] = $category[0]; $row['category'] = $category[1]; } if(empty($error)){ if(!empty($row['id'])){ $db->query("UPDATE ".PREFIX."homes_catalogue SET name = '".$input->FilterText($row['name'])."', `desc` = '".$input->FilterText($row['desc'])."', `type` = '".$input->FilterText($row['type'])."', `data` = '".$input->FilterText($row['data'])."', price = '".$input->FilterText($row['price'])."', amount = '".$input->FilterText($row['amount'])."', category = '".$input->FilterText($row['category'])."', categoryid = '".$input->FilterText($row['categoryid'])."', minrank = '".$input->FilterText($row['minrank'])."', `where` = '".$input->FilterText($row['where'])."' WHERE id = '".$input->FilterText($row['id'])."' LIMIT 1"); $message = $lang->loc['message.item.modified']; }else{ $db->query("INSERT INTO ".PREFIX."homes_catalogue (name,`desc`,`type`,`data`,price,amount,category,categoryid,minrank,`where`) VALUES ('".$input->FilterText($row['name'])."','".$input->FilterText($row['desc'])."','".$input->FilterText($row['type'])."','".$input->FilterText($row['data'])."','".$input->FilterText($row['price'])."','".$input->FilterText($row['amount'])."','".$input->FilterText($row['category'])."','".$input->FilterText($row['categoryid'])."','".$input->FilterText($row['minrank'])."','".$input->FilterText($row['where'])."')"); $message = $lang->loc['message.item.created']; } unset($_POST); unset($_GET); }else{ $_GET['do'] = "create"; } }elseif($_GET['do'] == "remove"){ if(isset($_POST['id']) && isset($_POST['remove'])){ $db->query("DELETE FROM ".PREFIX."homes_catalogue WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1"); unset($_POST); unset($_GET); $message = $lang->loc['message.item.removed']; } } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $db->query("SELECT * FROM ".PREFIX."homes_catalogue WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); $typeselected[(int) $row['type']] = ' selected="true"'; $whereselected[(int) $row['where']] = ' selected="true"'; }elseif(empty($row)){ $typeselected[1] = ' selected="true"'; $whereselected[0] = ' selected="true"'; $row['price'] = "2"; $row['amount'] = "1"; $row['minrank'] = "1"; $row['categoryid'] = "new"; } switch($_GET['do']){ case "create": $lang->addLocale("housekeeping.catalogue.create"); $icon = "catalogue_create.png"; $description = $lang->loc['catalogue.create.desc']; if(!empty($row['new_category'])){ $newselected = ' selected="true"'; } $content = ""; if(!empty($error)){ $content .= '
'.$error.'
'; } $content .= '
'; if(!empty($row['id'])){ $content .= ''; } $content .= '















'.$lang->loc['category'].'





'; break; case "remove": $lang->addLocale("housekeeping.catalogue.remove"); $icon = "catalogue_remove.png"; $description = $lang->loc['catalogue.remove.desc']; $content = '
'.$lang->loc['confirm.remove'].' "'.$input->HoloText($row['name']).'"?
'; break; default: $lang->addLocale("housekeeping.catalogue.display"); $icon = "catalogue.png"; $description = $lang->loc['catalogue.display.desc']; $content = ""; if(isset($message) && !empty($message)){ $content .= '
'.$message.'
'; } $content .= '
'; $sql = $db->query("SELECT * FROM ".PREFIX."homes_catalogue WHERE type = '1' OR type = '4' ORDER BY type ASC, categoryid ASC, name ASC, data ASC"); $i = 0; while($row = $db->fetch_assoc($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } if($row['type'] == "1"){ $type = $lang->loc['sticker']; }else{ $type = $lang->loc['background']; } $content .= ' '; } $content .= '
'.$lang->loc['type'].' '.$lang->loc['name'].' '.$lang->loc['data'].' '.$lang->loc['category'].' '.$lang->loc['actions'].'
'.$type.' '.$input->HoloText($row['name']).' '.$input->HoloText($row['data']).' '.$input->HoloText($row['category']).' '.$lang->loc['edit'].''.$lang->loc['remove'].'
'; break; } ?>
loc['pagename.catalogue']; ?> loc['pagename.catalogue']; ?>