$resource, 'usage_location' => '', 'usage_medium' => '', 'description' => '', 'usage_date' => date('Y-m-d') ); # Fetch usage data if ($ref > 0) { $usage_data = ps_query("SELECT * FROM resource_usage WHERE ref = ?", array("i",$ref)); if(count($usage_data) == 0) { exit('Usage not found.'); } $new_record = false; $usage_data = $usage_data[0]; $resource = $usage_data['resource']; } if(getval('submitted', '') != '' && enforcePostRequest(false)) { $usage_location = getval('usage_location', ''); $usage_medium = implode(', ', getval('usage_medium', [], false, 'is_array')); $description = getval('description', ''); # Construct usage date $usage_date = getval('usage_date_year', '') . '-' . getval('usage_date_month', '') . '-' . getval('usage_date_day', '-'); $resource_data = get_resource_data($resource); if($new_record && $resource_data !== false && resource_download_allowed($resource, "", $resource_data["resource_type"])) { # New record $parameters=array("i",$resource, "s",$usage_location, "s",$usage_medium, "s",$description, "s",$usage_date); ps_query("INSERT INTO resource_usage (resource, usage_location, usage_medium, description, usage_date) VALUES (?, ?, ?, ?, ?)", $parameters); $ref = sql_insert_id(); resource_log($resource, '', '', $lang['new_usage'] . ' ' . $ref); } elseif(!$new_record && get_edit_access($resource)) { # Existing record $parameters=array("s",$usage_location, "s",$usage_medium, "s",$description, "s",$usage_date, "i",$ref, "i",$resource); ps_query("UPDATE resource_usage SET usage_location = ?, usage_medium = ?, description = ?, usage_date = ? WHERE ref = ? AND resource = ?", $parameters); resource_log($resource, '', '', $lang['edit_usage'] . ' ' . $ref); } redirect('pages/view.php?ref=' . $resource); } include "../../../include/header.php"; ?>

< 

checked>