From bc21cbc465d9cd4d86265246826ba02515541152 Mon Sep 17 00:00:00 2001 From: Greg Froese Date: Wed, 13 May 2009 13:26:12 +0000 Subject: fixed sorting for most viewed and watermarking files to show proper owner when watermarking images in a group album --- mostviewedimages.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'mostviewedimages.php') diff --git a/mostviewedimages.php b/mostviewedimages.php index caf755193..8831dc33e 100644 --- a/mostviewedimages.php +++ b/mostviewedimages.php @@ -17,7 +17,7 @@ $sql = "select md.entity_guid, md.owner_guid, md.enabled, ms.string as views from " . $prefix . "metadata md inner join " . $prefix . "metastrings ms on md.value_id = ms.id inner join " . $prefix . "metastrings ms2 on md.name_id = ms2.id and ms2.string = 'tp_views' - order by views desc LIMIT $max"; + order by (views+0) desc LIMIT $max"; $result = get_data($sql); -- cgit v1.2.3