aboutsummaryrefslogtreecommitdiff
path: root/mostcommentedimagestoday.php
diff options
context:
space:
mode:
authorGreg Froese <greg.froese@gmail.com>2009-06-05 20:57:31 +0000
committerGreg Froese <greg.froese@gmail.com>2009-06-05 20:57:31 +0000
commit529d3775aba062679fcfcfe848e41a31328e86e8 (patch)
tree7affa91ab2b65d6b1abf78fe436ebc98260117d7 /mostcommentedimagestoday.php
parent21165f5f200b122389ef3feb9a23e647a64fa46b (diff)
downloadelgg-529d3775aba062679fcfcfe848e41a31328e86e8.tar.gz
elgg-529d3775aba062679fcfcfe848e41a31328e86e8.tar.bz2
added a bunch of new pages based on comments and views, none of these are in the default menus, must hit the mostvieweddashboard manually, these are more admin type pages
Diffstat (limited to 'mostcommentedimagestoday.php')
-rw-r--r--mostcommentedimagestoday.php50
1 files changed, 50 insertions, 0 deletions
diff --git a/mostcommentedimagestoday.php b/mostcommentedimagestoday.php
new file mode 100644
index 000000000..ce0ad8aeb
--- /dev/null
+++ b/mostcommentedimagestoday.php
@@ -0,0 +1,50 @@
+<?php
+
+ /**
+ * Tidypics full view of an image
+ * Given a GUID, this page will try and display any entity
+ *
+ */
+
+ // Load Elgg engine
+ include_once(dirname(dirname(dirname(__FILE__))) . "/engine/start.php");
+
+ global $CONFIG;
+ $prefix = $CONFIG->dbprefix;
+ $max = 24;
+
+
+ //find timestamps for today
+ $time_info = new stdClass();
+ $time_info->start = mktime(0,0,0, date("m"), 1, date("Y"));
+ $time_info->end = mktime();
+
+ //this works but is wildly inefficient
+ //$annotations = get_annotations(0, "object", "image", "tp_view", "", "", 5000);
+
+ $sql = "SELECT ent.guid, count( * ) AS views
+ 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
+ INNER JOIN " . $prefix . "metastrings ms ON ms.id = ann1.name_id
+ AND ms.string = 'generic_comment'
+ WHERE ann1.time_created BETWEEN $time_info->start AND $time_info->end
+ GROUP BY ent.guid
+ ORDER BY views DESC
+ LIMIT $max";
+
+ $result = get_data($sql);
+
+ $entities = array();
+ foreach($result as $entity) {
+ $entities[] = get_entity($entity->guid);
+ }
+
+ tidypics_mostviewed_submenus();
+ $title = elgg_echo("tidypics:mostcommentedtoday");
+ $area2 = elgg_view_title($title);
+ $area2 .= elgg_view_entity_list($entities, $max, 0, $max);
+ $body = elgg_view_layout('two_column_left_sidebar', '', $area2);
+ page_draw($title, $body);
+?> \ No newline at end of file