get_results("SELECT $wpdb->linkfeeds.*, link_name, link_url, cat_id, cat_name, link_favicon
FROM $wpdb->links, $wpdb->linkcategories, $wpdb->linkfeeds
WHERE $wpdb->links.link_id = $wpdb->linkfeeds.link_id AND
$wpdb->links.link_category = $wpdb->linkcategories.cat_id
AND (item_title LIKE '%$search%' OR item_content LIKE '%$search%')
ORDER BY item_date DESC");
}
else
{
$items = $wpdb->get_results("SELECT $wpdb->linkfeeds.*, link_name, link_url, cat_id, cat_name, link_favicon
FROM $wpdb->links, $wpdb->linkcategories, $wpdb->linkfeeds
WHERE $wpdb->links.link_id = $wpdb->linkfeeds.link_id AND
$wpdb->links.link_category = $wpdb->linkcategories.cat_id
AND $time $selection ORDER BY item_date DESC");
if (!$days && !$hours)
{
$wpdb->get_results("update $wpdb->linkfeeds, $wpdb->links SET item_read=1 WHERE $wpdb->links.link_id=$wpdb->linkfeeds.link_id AND item_read <> 1 $selection");
}
}
$unread_counts = $wpdb->get_results("SELECT SQL_BIG_RESULT $wpdb->linkcategories.cat_id,
$wpdb->linkcategories.cat_name, $wpdb->links.link_id, link_name, count(*) as num_unread
FROM $wpdb->links, $wpdb->linkfeeds, $wpdb->linkcategories
WHERE $wpdb->links.link_id = $wpdb->linkfeeds.link_id
AND $wpdb->links.link_category = $wpdb->linkcategories.cat_id
AND item_read=0
GROUP BY cat_name, link_name");
if ($unread_counts)
{
foreach ($unread_counts as $unread_count)
{
$cat_id = $unread_count->cat_id;
$cat_name = $unread_count->cat_name;
$link_id = $unread_count->link_id;
$link_name = $unread_count->link_name;
$count = $unread_count->num_unread;
$total_unread += $count;
$cat_unread[$cat_id] += $count;
$link_unread[$link_id] += $count;
}
}
$feeds = $wpdb->get_results("SELECT SQL_BIG_RESULT $wpdb->linkcategories.cat_id,
$wpdb->linkcategories.cat_name, $wpdb->links.link_id, link_name, link_url, link_favicon, link_rss
FROM $wpdb->links, $wpdb->linkcategories
WHERE $wpdb->links.link_category = $wpdb->linkcategories.cat_id
GROUP BY cat_name, link_name; ");
if ($feeds)
{
print "
All Feeds (".($total_unread+0).")\n";
$last_link =""; $last_cat="";
foreach ($feeds as $feed)
{
$cat_id = $feed->cat_id;
$cat_name = $feed->cat_name;
$link_id = $feed->link_id;
$link_name = $feed->link_name;
$link_url = $feed->link_url;
$link_favicon = $feed->link_favicon;
$link_rss = $feed->link_rss;
if ($link_favicon == 'none') { $link_favicon = "./no_favicon.gif"; }
if ($cat_name != $last_cat)
{
if (!$last_cat) { print "
\n"; }
if ($category_id == $cat_id) { $folderImage = get_option('siteurl')."/wp-content/plugins/feedreader/folderopen.gif"; $menuClass="Show"; }
else { $folderImage = get_option('siteurl')."/wp-content/plugins/feedreader/folderclosed.gif"; $menuClass="Hidden"; }
print "
![\"Open/Close](\"$folderImage\")
";
if ($cat_unread[$cat_id]) print "";
print "$cat_name";
if ($cat_unread[$cat_id]) print " (".$cat_unread[$cat_id].")";
print "\n\n"; }
}
if ($search) { $title = "Search for: $search"; }
elseif ($feed_id) { $title = "Feed: ".$wpdb->get_var("SELECT link_name FROM $wpdb->links WHERE link_id=$feed_id"); }
elseif ($category_id)
{
if ($category_id == "all") { $title = "All Feeds"; }
else { $title = "Category: ".$wpdb->get_var("SELECT cat_name FROM $wpdb->linkcategories WHERE cat_id=$category_id"); }
}
if ($days) { $title .= ", last $days day(s)"; }
elseif ($hours) { $title .= ", last $hours hour(s)"; }
?>
No entries"; }
else foreach ($items as $item)
{
$id = $item->id;
$title = $item->item_title;
if (!$title) { $title = "No Title"; }
$link = $item->item_link;
$content = $item->item_content;
$date = $item->item_date;
$creator = $item->item_creator;
$subject = $item->item_subject;
$guid = $item->item_guid;
$read = $item->item_read;
$link_id = $item->link_id;
$link_name = $item->link_name;
$link_url = $item->link_url;
$cat_id = $item->cat_id;
$cat_name = $item->cat_name;
$link_favicon = $item->link_favicon;
$timestamp = strtotime($date);
$time = date ("H:i", $timestamp);
$date = date('l F j, Y', $timestamp);
if ($date != $last)
{
print "
$date
\n";
$last = $date;
}
if (FR_isEven($count)) { print "
\n"; }
else { print "
\n"; }
#print "
\n";
print "
$time \n";
print "
![\"Visit](\"".FR_cached_Favicon($link_favicon)."\")
\n";
print "
$title \n";
print "
» $link_name";
if ($creator) { print " ($creator)"; }
if ($expandposts) { $classforcontent = "Show"; } else { $classforcontent = "Hidden"; }
if ($content) { print "\n
".trim($content)."
\n"; }
#print "\n";
print "
\n\n";
$count++;
}
?>