]> http://www.campaignmoney.org/popular Comments for "Popular Content" en http://www.campaignmoney.org/popular <div class="popular-lists-holder"> <?php $limit = 10; //list length $todays = views_build_view('items', views_get_view('recent-popular'), NULL, FALSE, $limit); foreach ($todays['items'] as $node) { $todays_items[] = l($node->node_title, 'node/'. $node->nid); } print '<h2 class="popular-lists-title">Recent Popular Content</h2>'; print theme_item_list($todays_items); $alltime = views_build_view('items', views_get_view('popular'), NULL, FALSE, $limit); foreach ($alltime['items'] as $node) { $alltime_items[] = l($node->node_title, 'node/'. $node->nid); } print '<a name="alltime"> </a><h2 class="popular-lists-title">All Time Popular Content</h2>'; print theme_item_list($alltime_items); $query='SELECT n.nid, n.title, count(*) FROM {forward_log} s LEFT JOIN {node} n ON s.nid = n.nid WHERE s.type="sent" GROUP BY n.nid DESC'; $result = db_query_range($query, 0, $limit); while ($node = db_fetch_object($result)) { $emailed_items[] = l($node->title, 'node/'. $node->nid); } print '<a name="emailed"> </a><h2 class="popular-lists-title">Most Emailed Content</h2>'; print theme_item_list($emailed_items); ?> </div> Wed, 26 Jul 2006 15:08:43 -0500