aboutsummaryrefslogtreecommitdiff
path: root/mostviewedimages.php
diff options
context:
space:
mode:
authorGreg Froese <greg.froese@gmail.com>2009-05-13 13:26:12 +0000
committerGreg Froese <greg.froese@gmail.com>2009-05-13 13:26:12 +0000
commitbc21cbc465d9cd4d86265246826ba02515541152 (patch)
tree6f8fc7b6d54ed9d3c5494ced2a44d671b2481871 /mostviewedimages.php
parentb32a22535f4b41187475618769d0a4d07aba6684 (diff)
downloadelgg-bc21cbc465d9cd4d86265246826ba02515541152.tar.gz
elgg-bc21cbc465d9cd4d86265246826ba02515541152.tar.bz2
fixed sorting for most viewed and watermarking files to show proper owner when watermarking images in a group album
Diffstat (limited to 'mostviewedimages.php')
-rw-r--r--mostviewedimages.php2
1 files changed, 1 insertions, 1 deletions
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);