X-Git-Url: https://jasonwoof.com/gitweb/?p=wfpl-cms.git;a=blobdiff_plain;f=admin_images.php;h=c2f4943fba53ec34f7a87362882d80ba4b0fff0e;hp=73d16c64c0d21e5af5d8dcb1fa96e13fe993daa0;hb=HEAD;hpb=e7424acd48ed670f1b8bd8d7c1ff69b37ce6334b

diff --git a/admin_images.php b/admin_images.php
index 73d16c6..c2f4943 100644
--- a/admin_images.php
+++ b/admin_images.php
@@ -2,169 +2,157 @@
 
 # This form requires wfpl. See: http://sametwice.com/wfpl
 
-define('ADMIN_IMAGES_DB_FIELDS', 'image,name,caption,sizes');
+define('ADMIN_IMAGES_DB_FIELDS', 'image,name,caption');
 
-require_once(DOCROOT . 'inc/wfpl/format.php');
-require_once(DOCROOT . 'inc/wfpl/upload.php');
+require_once(__DIR__.'/'.'inc/wfpl/format.php');
+require_once(__DIR__.'/'.'inc/wfpl/upload.php');
 
 # example: 200x300
 function format_width_height($str) {
-	$fields = explode('x', $str);
-	if(count($fields) != 2) {
-		return '';
-	}
+    $fields = explode('x', $str);
+    if(count($fields) != 2) {
+        return '';
+    }
 
-	list($width, $height) = $fields;
-	$width = format_int_0($width);
-	$height = format_int_0($height);
+    list($width, $height) = $fields;
+    $width = format_int_0($width);
+    $height = format_int_0($height);
 
-	return "${width}x$height";
+    return "${width}x$height";
 }
 
 function admin_images_get_fields() {
-	$data = array();
-
-	$data['name'] = format_oneline(_REQUEST_cut('name'));
-	$data['caption'] = format_oneline(_REQUEST_cut('caption'));
-
-	if($_FILES['image'] && $_FILES['image']['error'] == 0 && file_exists($_FILES['image']['tmp_name'])) {
-		$image_fn_ext = path_or_mime_to_ext($_FILES['image']['name'], $_FILES['image']['type']);
-		$image_fn_ext = ext_to_web_image_ext($image_fn_ext);
-		$image_fn_base = sha1_file($_FILES['image']['tmp_name']);
-		if (strlen($image_fn_base) == 40) {
-			$image_fn_base = substr($image_fn_base, 0, 16);
-			$image_filename = 'cms_images/' . $image_fn_base . '.' . $image_fn_ext;
-			$data['image'] = convert_uploaded_image('image', $image_filename);
-		}
-	} else {
-		if(_REQUEST_cut('delete_image') == 'Yes') {
-			$data['image'] = '';
-		} else {
-			$data['image'] = format_image_w_h(_REQUEST_cut('old_image'));
-		}
-	}
-	unset($_FILES['image']);
-
-	return $data;
+    $data = array();
+
+    $data['name'] = format_oneline(_REQUEST_cut('name'));
+    $data['caption'] = format_oneline(_REQUEST_cut('caption'));
+
+    if($_FILES['image'] && $_FILES['image']['error'] == 0 && file_exists($_FILES['image']['tmp_name'])) {
+        $image_fn_ext = path_or_mime_to_ext($_FILES['image']['name'], $_FILES['image']['type']);
+        $image_fn_ext = ext_to_web_image_ext($image_fn_ext);
+        $image_fn_base = sha1_file($_FILES['image']['tmp_name']);
+        if (strlen($image_fn_base) == 40) {
+            $image_fn_base = substr($image_fn_base, 0, 16);
+            $image_filename = 'cms_images/' . $image_fn_base . '.' . $image_fn_ext;
+            $data['image'] = convert_uploaded_image('image', $image_filename);
+        }
+    } else {
+        if(_REQUEST_cut('delete_image') == 'Yes') {
+            $data['image'] = '';
+        }
+    }
+    unset($_FILES['image']);
+
+    return $data;
 }
 
 
 function admin_images_main() {
-	session_auth_must('admin_images');
+    session_auth_must('admin_images');
 
-	$id = _REQUEST_cut('edit_id');
-	if($id) {
-		return admin_images_main_form($id);
-	}
+    $id = _REQUEST_cut('edit_id');
+    if($id) {
+        return admin_images_main_form($id);
+    }
 
-	$id = _REQUEST_cut('admin_images_delete_id');
-	if($id) {
-		return admin_images_main_delete($id);
-	}
+    $id = _REQUEST_cut('admin_images_delete_id');
+    if($id) {
+        return admin_images_main_delete($id);
+    }
 
-	if(_REQUEST_cut('new')) {
-		return admin_images_main_form();
-	}
+    if(_REQUEST_cut('new')) {
+        return admin_images_main_form();
+    }
 
-	if(_REQUEST_cut('list')) {
-		return admin_images_main_listing();
-	}
+    if(_REQUEST_cut('list')) {
+        return admin_images_main_listing();
+    }
 
-	$id = _REQUEST_cut('id');
-	if($id) {
-		return admin_images_main_display($id);
-	}
+    if(isset($_POST['name'])) {
+        return admin_images_main_form();
+    }
 
-	if(isset($_POST['name'])) {
-		return admin_images_main_form();
-	}
-
-	# default action:
-	return admin_images_main_listing();
-}
-
-function admin_images_main_display($id) {
-	$data = db_get_assoc('cms_images', 'id,'.ADMIN_IMAGES_DB_FIELDS, 'where id=%i', $id);
-	if(!$data) {
-		message("Error: Broken Link (Image #$id not found)");
-		return './admin_images';
-	}
-
-	# Find pages that have this image on it
-	if($data['image']) {
-		$references = db_get_assocs('cms_pages', 'title,filename', 'where content like "%%%s%%" order by concat(nav_title,title)', substr(enc_image_src($data['image']), 0, -4));
-		if($references) {
-			$data['references'] = array(
-				'data' => $references,
-				'count' => count($references));
-		}
-	}
-
-	tem_set('display', $data);
+    # default action:
+    return admin_images_main_listing();
 }
 
 function admin_images_main_delete($id) {
-	$data = db_get_assoc('cms_images', 'image,sizes', 'where id=%i', $id);
-	if ($data) {
-		$src = enc_image_src($data['image']);
-		if ($src) {
-			$filenames = array($src);
-			foreach ($GLOBALS['wfpl_image_widths'] as $w) {
-				$filenames [] = substr($src, 0, -4) . 'w' . $w . substr($src, -4);
-			}
-			foreach ($filenames as $filename) {
-				if (file_exists($filename)) {
-					unlink($filename);
-				}
-			}
-		}
-		db_delete('cms_images', 'where id=%i', $id);
-		message('Image deleted.');
-	} else {
-		message("Couldn't find image to delete. Maybe it's already been deleted?");
-	}
-	return './admin_images';
+    $data = db_get_assoc('cms_images', 'image', 'where id=%i', $id);
+    if ($data) {
+        $src = enc_image_src($data['image']);
+        if ($src) {
+            $filenames = array($src);
+            foreach ($GLOBALS['wfpl_image_widths'] as $w) {
+                $filenames [] = substr($src, 0, -4) . 'w' . $w . substr($src, -4);
+            }
+            foreach ($filenames as $filename) {
+                if (file_exists($filename)) {
+                    unlink($filename);
+                }
+            }
+        }
+        db_delete('cms_images', 'where id=%i', $id);
+        message('Image deleted.');
+    } else {
+        message("Couldn't find image to delete. Maybe it's already been deleted?");
+    }
+    return './admin_images';
 }
 
 function admin_images_main_listing() {
-	$listing_rows = db_get_assocs('cms_images', 'id,image,name,caption', 'order by name, caption');
-	tem_set('listings', $listing_rows);
+    $sort_by = 'name';
+    $sorts = array(
+        'age' => 'created_at desc',
+        'name' => "coalesce(nullif(name, ''), caption), created_at",
+        'caption' => "coalesce(nullif(caption, ''), name), created_at"
+    );
+    if (isset($_REQUEST['sort'])) {
+        foreach ($sorts as $s => $sql) {
+            if ($_REQUEST['sort'] == $s) {
+                $sort_by = $s;
+                break;
+            }
+        }
+    }
+    tem_set("sort_by_$sort_by");
+    $listing_rows = db_get_assocs('cms_images', 'id,image,name,caption', 'order by ' . $sorts[$sort_by]);
+    tem_set('listings', $listing_rows);
 }
 
 function admin_images_main_form($id = false) {
-	if($id) {
-		tem_set('id', $id);
-	}
-
-	if(isset($_POST['name'])) {
-		$data = admin_images_get_fields();
-
-		# save anything
-		# Note: If you change this to re-display the form in some cases, be sure to handle image uploads well (don't make them upload it again.)
-
-		# save to database
-		if($id) {
-			db_update_assoc('cms_images', $data, 'where id=%i', $id);
-			message('Image updated.');
-			$saved_id = $id;
-		} else {
-			db_insert_assoc('cms_images', $data);
-			message('Image saved. Next time you open a page editor, this image will be availble in the "Insert Image" dialog.');
-			$saved_id = db_auto_id();
-		}
-
-		# return user to display page where they can see instructions, etc
-		return "./admin_images";
-
-	} elseif($id) {
-		# we've recieved an edit id, but no data. So we grab the values to be edited from the database
-		$data = db_get_assoc('cms_images', ADMIN_IMAGES_DB_FIELDS, 'where id=%i', $id);
-	} else {
-		# form not submitted, set default values:
-		$data = array('sizes' => '275x500');
-	}
-
-	tem_set('upload_max_filesize', upload_max_filesize());
-
-	tem_set('form', $data);
+    if($id) {
+        tem_set('id', $id);
+    }
+
+    if(isset($_POST['name'])) {
+        $data = admin_images_get_fields();
+
+        # save anything
+        # Note: If you change this to re-display the form in some cases, be sure to handle image uploads well (don't make them upload it again.)
+
+        # save to database
+        if($id) {
+            db_update_assoc('cms_images', $data, 'where id=%i', $id);
+            message('Image updated.');
+            $saved_id = $id;
+            return "./admin_images";
+        } else {
+            $data['created_at'] = time();
+            db_insert_assoc('cms_images', $data);
+            message('Image saved. Next time you open a page editor, this image will be availble in the "Insert Image" dialog.');
+            $saved_id = db_auto_id();
+            return "./admin_images?sort=age";
+        }
+
+    } elseif($id) {
+        # we've recieved an edit id, but no data. So we grab the values to be edited from the database
+        $data = db_get_assoc('cms_images', ADMIN_IMAGES_DB_FIELDS, 'where id=%i', $id);
+    } else {
+        # form not submitted, set default values:
+        $data = array();
+    }
+
+    tem_set('upload_max_filesize', upload_max_filesize());
+
+    tem_set('form', $data);
 }