Michael Heilemann.
If you have Dunstan's Time Since installed, this plugin uses it for the title="" attributes on the comments and posts. (For WordPress 1.5)
Author: Brian Meidell
Author URI: http://meidell.dk/blog
Version 1.5: Now works without LOCK TABLE and CREATE TEMPORARY TABLE priviledges.
Version 1.5.1: Can't remember what I did here
Version 1.5.2: Fixed count select statement to not include spammy comments
Version 1.5.3: Properly excludes track- and pingbacks
Version 1.5.4: Excludes posts that are not published, even if they have comments
Version 1.5.5: Fade old comments, fixed bug that wreaked havoc with Time Since
Version 1.5.6: Bugfix from Jonas Rabbe (http://www.jonas.rabbe.com/) pertaining to timesince
Version 1.5.7: Bugfix so old colors can be darker than new colors (stupid oversight), thanks to http://spiri.dk for spotting it.
Bugfix where single digit hex would cause invalid colors, thanks to http://www.wereldkeuken.be/ for the fix.
Version 1.5.8: Bugfix from Matthias Schutz regarding time_since.
Version 1.5.9: Added function redefiniotion protection if people use the plugin in several places
*/
function blc_latest_comments($num_posts = 5, $num_comments = 6, $hide_pingbacks_and_trackbacks = true, $prefix = "", $postfix = "", $fade_old = true, $range_in_days = 10, $new_col = "#444444", $old_col = "#cccccc")
{
global $wpdb, $tablecomments, $tableposts;
if(!function_exists('blc_clamp'))
{
function blc_clamp($min, $max, $val)
{
return max($min,min($max,$val));
}
}
function get_channel($col, $offset)
{
return hexdec(substr($col, $offset, 2));
}
function channels($col)
{
$r = get_channel($col, 1);
$g = get_channel($col, 3);
$b = get_channel($col, 5);
return array($r, $g, $b);
}
$max_time = $range_in_days * 24 * 60 * 60 ;
function scale_channel($old, $new, $diff, $max_time)
{
$range = $old - $new;
$c = round($diff/$max_time*($range))+$new;
$c = blc_clamp(min($new, $old), max($new, $old), $c);
$c_hex = str_pad(dechex($c), 2, '0', STR_PAD_LEFT);
return $c_hex;
}
$usetimesince = function_exists('time_since'); // Work nicely with Dunstan's Time Since plugin (adapted by Michael Heilemann)
// This is compensating for the lack of subqueries in mysql 3.x
// The approach used in previous versions needed the user to
// have database lock and create tmp table priviledges.
// This uses more queries and manual DISTINCT code, but it works with just select privs.
if(!$hide_pingbacks_and_trackbacks)
$ping = "";
else
$ping = "AND comment_type<>'pingback' AND comment_type<>'trackback'";
$posts = $wpdb->get_results("SELECT
comment_post_ID, post_title
FROM ($tablecomments LEFT JOIN $tableposts ON (comment_post_ID = ID))
WHERE comment_approved = '1'
AND $tableposts.post_status='publish'
$ping
ORDER BY comment_date DESC;");
$seen = array();
$num = 0;
if($fade_old)
{
list($r_new, $g_new, $b_new) = channels($new_col);
list($r_old, $g_old, $b_old) = channels($old_col);
}
foreach($posts as $post)
{
// The following 5 lines is a manual DISTINCT and LIMIT,
// since mysql 3.x doesn't allow you to control which way a DISTINCT
// select merges multiple entries.
if(array_key_exists($post->comment_post_ID, $seen))
continue;
$seen[$post->comment_post_ID] = true;
if($num++ > $num_posts)
break;
$commenters = $wpdb->get_results("SELECT *, UNIX_TIMESTAMP(comment_date) AS unixdate FROM $tablecomments
WHERE comment_approved = '1'
AND comment_post_ID = '".$post->comment_post_ID."'
$ping
ORDER BY comment_date DESC
LIMIT $num_comments;");
$count = $wpdb->get_var("SELECT COUNT(comment_ID) AS c FROM $tablecomments WHERE comment_post_ID = $post->comment_post_ID AND comment_approved = '1' ".$ping);
$i = 0;
$link = get_permalink($post->comment_post_ID);
if($usetimesince)
$title = " title=\"Last comment was ".time_since($commenters[0]->unixdate)." ago\"";
else
$title = "";
echo $prefix."".stripslashes($post->post_title). " ".$count."
\n";
foreach($commenters as $commenter)
{
if($usetimesince)
$title = " title=\"Posted ".time_since($commenter->unixdate)." ago\"";
if($fade_old)
{
$diff = time() - $commenter->unixdate;
$r_hex = scale_channel($r_old, $r_new, $diff, $max_time);
$g_hex = scale_channel($g_old, $g_new, $diff, $max_time);
$b_hex = scale_channel($b_old, $b_new, $diff, $max_time);
$colstr = " style=\"color: #".$r_hex.$g_hex.$b_hex.";\"";
}
if($i++ > 0)
echo ", ";
echo "comment_ID."\"$title>".stripslashes($commenter->comment_author)."";
}
if($count > $num_comments)
echo " [...]";
echo "".$postfix."\n";
}
}
?>
// Copyright (c) 2004 Bitflux GmbH
// Licensed under the Apache License, Version 2.0 (the "License");
// you may not use this file except in compliance with the License.
// You may obtain a copy of the License at
// http://www.apache.org/licenses/LICENSE-2.0
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS,
// WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or
// implied. See the License for the specific language governing
// permissions and limitations under the License.
// Author: Bitflux GmbH
var liveSearchReq = false;
var t = null;
var liveSearchLast = "";
var isIE = false;
// on !IE we only have to initialize it once
if (window.XMLHttpRequest) {
liveSearchReq = new XMLHttpRequest();
}
function liveSearchInit() {
if (navigator.userAgent.indexOf("Safari") > 0) {
$('livesearch').addEventListener("keydown",liveSearchKeyPress,false);
$('livesearch').setAttribute("autocomplete","off");
} else if (navigator.product == "Gecko") {
$('livesearch').addEventListener("keypress",liveSearchKeyPress,false);
$('livesearch').setAttribute("autocomplete","off");
} else {
$('livesearch').attachEvent('onkeydown',liveSearchKeyPress);
isIE = true;
$('livesearch').setAttribute("autocomplete","off");
}
}
function liveSearchKeyPress(event) {
if (event.keyCode == 40 )
//KEY DOWN
{
highlight = $("LSHighlight");
if (!highlight) {
highlight = $("LSResult").firstChild.firstChild.nextSibling.firstChild;
} else {
highlight.removeAttribute("id");
highlight = highlight.nextSibling;
}
if (highlight) {
highlight.setAttribute("id","LSHighlight");
}
if (!isIE) { event.preventDefault(); }
}
//KEY UP
else if (event.keyCode == 38 ) {
highlight = $("LSHighlight");
if (!highlight) {
highlight = $("LSResult").firstChild.firstChild.nextSibling.nextSibling.lastChild;
}
else {
highlight.removeAttribute("id");
highlight = highlight.previousSibling;
}
if (highlight) {
highlight.setAttribute("id","LSHighlight");
}
if (!isIE) { event.preventDefault(); }
}
//ESC
else if (event.keyCode == 27) {
highlight = $("LSHighlight");
if (highlight) {
highlight.removeAttribute("id");
}
$("LSResult").style.display = "none";
document.forms.searchform.s.value = '';
}
}
function liveSearchStart() {
if (t) {
window.clearTimeout(t);
}
t = window.setTimeout("liveSearchDoSearch()",400);
}
function liveSearchDoSearch() {
if (liveSearchLast != document.forms.searchform.s.value) {
if (liveSearchReq && liveSearchReq.readyState < 4) {
liveSearchReq.abort();
// Fade the background of the results box
}
if ( document.forms.searchform.s.value == "") {
$("LSResult").style.display = "none";
highlight = $("LSHighlight");
if (highlight) {
highlight.removeAttribute("id");
}
return false;
}
if (window.XMLHttpRequest) {
// branch for IE/Windows ActiveX version
} else if (window.ActiveXObject) {
liveSearchReq = new ActiveXObject("Microsoft.XMLHTTP");
}
liveSearchReq.onreadystatechange= liveSearchProcessReqChange;
liveSearchReq.open("GET", "http://floppedthenuts.com/wp-content/themes/k2/livesearch.php?s=" + document.forms.searchform.s.value);
liveSearchLast = document.forms.searchform.s.value;
liveSearchReq.send(null);
}
}
function liveSearchProcessReqChange() {
if (liveSearchReq.readyState == 4) {
var res = $("LSResult");
res.style.display = "block";
/* res.firstChild.innerHTML = liveSearchReq.responseText; */
res.firstChild.innerHTML = ''+liveSearchReq.responseText;
}
//getDDSize();
//setListenLinks();
}
function liveSearchSubmit() {
var highlight = $("LSHighlight");
if (highlight && highlight.firstChild) {
window.location = highlight.firstChild.getAttribute("href");
return false;
}
else {
return true;
}
}
function closeResults() {
$("LSResult").style.display = "none";
}