addLocale("housekeeping.collectables"); $page['name'] = $lang->loc['pagename.collectables']; $page['category'] = "tools"; if(isset($_POST['search'])){ $sql = $data->select6($input->FilterText($_POST['query'])); $search_results = "\n"; $i = 0; while($row = $db->fetch_row($sql)){ if($input->IsEven($i)){ $even = "even"; }else{ $even = "odd"; } $search_results .= "\n"; $i++; } $search_results .= "

".$row[0]."

"; }else{ $search_results = "\n

".$lang->loc['search.desc']."

"; } if(isset($_GET['do']) && $_GET['do'] == "save"){ $row = $_POST; $row['image_small'] = str_replace("%path%",PATH,$row['image_small']); $row['image_large'] = str_replace("%path%",PATH,$row['image_large']); $year = $row['year']; $selected[(int) $row['month']] = ' selected="true"'; $row['date'] = mktime(0,0,0,$row['month'],1,$row['year']); if(empty($row['furni_id'])){ $error = $lang->loc['error.no.furni_id']."
"; } if(empty($row['month'])){ $error = $lang->loc['error.no.month']."
"; } if(empty($row['year'])){ $error = $lang->loc['error.no.year']; } if(empty($error)){ if(!empty($row['id'])){ $db->query("UPDATE ".PREFIX."collectables SET image_small = '".$input->FilterText($row['image_small'])."', image_large = '".$input->FilterText($row['image_large'])."', furni_id = '".$input->FilterText($row['furni_id'])."', date = '".$input->FilterText($row['date'])."' WHERE id = '".$input->FilterText($row['id'])."' LIMIT 1"); $message = $lang->loc['message.collectable.modified']; }else{ $db->query("INSERT INTO ".PREFIX."collectables (image_small,image_large,furni_id,date) VALUES ('".$input->FilterText($row['image_small'])."','".$input->FilterText($row['image_large'])."','".$input->FilterText($row['furni_id'])."','".$input->FilterText($row['date'])."')"); $message = $lang->loc['message.collectable.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."collectables WHERE id = '".$input->FilterText($_POST['id'])."' LIMIT 1"); unset($_POST); unset($_GET); $message = $lang->loc['message.collectable.removed']; } } if((isset($_GET['id']) || isset($_POST['id'])) && empty($row)){ $sql = $db->query("SELECT * FROM ".PREFIX."collectables WHERE id = '".$input->FilterText($_GET['id'])."' LIMIT 1"); $row = $db->fetch_assoc($sql); $year = date('Y',$row['date']); $selected[(int) date('n',$row['date'])] = ' selected="true"'; }elseif(empty($row)){ $row['image_small'] = "%path%/web-gallery/images/furni/small/"; $row['image_large'] = "%path%/web-gallery/images/furni/large/"; $row['furni_id'] = $_GET['furniid']; $year = date('Y'); $selected[(int) date('n')] = ' selected="true"'; } switch($_GET['do']){ case "create": $lang->addLocale("housekeeping.collectables.create"); $icon = "collectables_create.png"; $description = $lang->loc['collectables.create.desc']; $content = ""; if(!empty($error)){ $content .= '

'.$error.'

'; } $content .= '

'; break; case "remove": $lang->addLocale("housekeeping.collectables.remove"); $icon = "collectables_remove.png"; $description = $lang->loc['collectables.remove.desc']; $content = '

'.$lang->loc['confirm.remove'].' "'.date('F Y',$row['date']).'"?

'; break; default: $lang->addLocale("housekeeping.collectables.display"); $icon = "collectables.png"; $description = $lang->loc['collectables.display.desc']; $content = ""; if(isset($message) && !empty($message)){ $content .= '

'.$message.'

'; } $content .= '

'; $sql = $data->select5(); $i = 0; while($row = $db->fetch_row($sql)){ $i++; if($input->IsEven($i)){ $even = ' class="even"'; }else{ $even = ''; } $content .= ' '; } $content .= '

'.$lang->loc['image'].'	'.$lang->loc['name'].'	'.$lang->loc['date'].'	'.$lang->loc['actions'].'
	'.$input->HoloText($row[4]).'	'.date('F Y',$row[3]).'

'; break; } $page['scrollbar'] = true; require_once('./templates/housekeeping_header.php'); ?>

loc['pagename.collectables']; ?> loc['pagename.collectables']; ?>