diff options
| author | Greg Froese <greg.froese@gmail.com> | 2009-05-18 12:57:59 +0000 |
|---|---|---|
| committer | Greg Froese <greg.froese@gmail.com> | 2009-05-18 12:57:59 +0000 |
| commit | 70ad5de3a1d4fffc8b3d97c301194bb0258b4c68 (patch) | |
| tree | 765e5d8b7081fd3373df0fb89d33a237a0239fce /mostviewedimages.php | |
| parent | dd81b02a85596a913c4a42fba655766b61334eb1 (diff) | |
| download | elgg-70ad5de3a1d4fffc8b3d97c301194bb0258b4c68.tar.gz elgg-70ad5de3a1d4fffc8b3d97c301194bb0258b4c68.tar.bz2 | |
fixed watermarking after code re-org and added most recently viewed option
Diffstat (limited to 'mostviewedimages.php')
| -rw-r--r-- | mostviewedimages.php | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/mostviewedimages.php b/mostviewedimages.php index 5bbbcf5e7..9d2831bf7 100644 --- a/mostviewedimages.php +++ b/mostviewedimages.php @@ -17,7 +17,7 @@ //$annotations = get_annotations(0, "object", "image", "tp_view", "", "", 5000); $sql = "SELECT ent.guid, count( * ) AS views - FROM `my_elggentities` ent + FROM " . $prefix . "entities ent INNER JOIN " . $prefix . "entity_subtypes sub ON ent.subtype = sub.id AND sub.subtype = 'image' INNER JOIN " . $prefix . "annotations ann1 ON ann1.entity_guid = ent.guid |