root/wp-since-last-visit/trunk/wp-last-visit.php

<?php

// WP Since Last Visit
// version 2.2, 2004-07-05
//
// Copyright (c) 2002-2004 Alex King
// http://www.alexking.org/software/wordpress/
//
// This is an add-on for WordPress
// http://wordpress.org/
//
// **********************************************************************
// This program is distributed in the hope that it will be useful, but
// WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. 
// *****************************************************************

/*
Plugin Name: WP Since Last Visit
Plugin URI: http://www.alexking.org/software/wordpress/
Description: Indicate new posts and comments since your last visit.
Author: Alex King
Author URI: http://www.alexking.org/
*/ 

// Modified by Dougal Campbell <URL:http://dougal.gunters.org/> 20030911
//   replaced mysql_*() calls with ezSQL calls
//   modified cookie code to derive info from $siteurl
//   renamed cookies with 'wp' instead of 'b2'
//
// include this file or paste the functions into your page

// set $path and $domain as appropriate to your server. In most cases,
// you'll want $path to match your WordPress install directory. If your
// site is accessible by multiple subdomain names, like "example.com" 
// and "www.example.com", then set $domain to ".example.com"

// By default, we'll try to derive them from the site url defined
// in the Base Settings options:
$urlinfo = parse_url($siteurl);

$path = $urlinfo['path'];
$domain = $urlinfo['host'];

if (!isset($time_difference)) {
    $time_difference = 0;
}
if (!isset($tableposts)) {
    $tableposts = 'wp_posts';
}
if (!isset($tablecomments)) {
    $tablecomments = 'wp_comments';
}

if (!empty($_GET["type"]) && $_GET["type"] == "js") {
    $wplastvisit_output = "javascript";
}

if (isset($wplastvisit_output)) { // will output stuff for the HTML source
    switch ($wplastvisit_output) {
        case "javascript":
            include("../../wp-blog-header.php");
            header("Content-type: text/javascript");
?>
//    var slvIndicator = 'New';
    var slvIndicator = '<img src="<?php bloginfo('siteurl'); ?>/ak-img/new.gif" alt="New" title="New since your last visit." />';
    
    function slvBanner() {
        var posts = slvGetCookie('wplastvisit_posts');
        var comments = slvGetCookie('wplastvisit_comments');
        if (posts == null || comments == null) {
            return false;
        }
        var banner = '';
        if (posts == 1) {
            banner += posts + ' new post and ';
        }
        else {
            banner += posts + ' new posts and ';
        }
        if (comments == 1) {
            banner += comments + ' new comment since your last visit.';
        }
        else {
            banner += comments + ' new comments since your last visit.';
        }
        document.write(banner);
    }
    
    function slvShowNewIndicator(date) {
        if (parseInt(date) > parseInt(slvGetCookie('wplastvisit'))) {
            document.write(slvIndicator);
        }
    }
    
    function slvGetCookie(name) {

    /**
     * Read the JavaScript cookies tutorial at:
     *   http://www.netspade.com/articles/javascript/cookies.xml
     */

        var dc = document.cookie;
        var prefix = name + "=";
        var begin = dc.indexOf("; " + prefix);
        if (begin == -1)
        {
            begin = dc.indexOf(prefix);
            if (begin != 0) return null;
        }
        else
        {
            begin += 2;
        }
        var end = document.cookie.indexOf(";", begin);
        if (end == -1)
        {
            end = dc.length;
        }
        return unescape(dc.substring(begin + prefix.length, end));
    }    
<?php
        break;
    }
}
else { // standard
    
    function ak_last_visit($use_session = 1, $hours = 1) {
        global $path, $domain, $time_difference;
        global $tableposts, $tablecomments;
        if ($use_session == 1 && 
            isset($_COOKIE["wpthisvisit"]) && 
            isset($_COOKIE["wplastvisit"])) {
            if ($_COOKIE["wpthisvisit"] > 
                (time() + ($time_difference * 3600)) - ($hours * 3600)) {
                setcookie("wpthisvisit"
                         ,time() + ($time_difference * 3600)
                         ,time() + 30000000
                         ,$path
                         ,$domain
                         );
                $ak_last_visit = $_COOKIE["wplastvisit"];
            }
            else {
                setcookie("wpthisvisit"
                         ,time() + ($time_difference * 3600)
                         ,time() + 30000000
                         ,$path
                         ,$domain
                         );
                setcookie("wplastvisit"
                         ,$_COOKIE["wpthisvisit"]
                         ,time() + 30000000
                         ,$path
                         ,$domain
                         );
                $ak_last_visit = $_COOKIE["wpthisvisit"];
            }
        }
        else {
            setcookie("wpthisvisit"
                     ,time() + ($time_difference * 3600)
                     ,time() + 30000000
                     ,$path
                     ,$domain
                     );
            setcookie("wplastvisit"
                     ,time() + ($time_difference * 3600)
                     ,time() + 30000000
                     ,$path
                     ,$domain
                     );
            if (isset($_COOKIE["wplastvisit"])) {
                $ak_last_visit = $_COOKIE["wplastvisit"];
            }
            else {
                $ak_last_visit = time() + ($time_difference * 3600);
            }
        }
        if (isset($ak_last_visit)) {
            $last_visit = date("Y-m-d H:i:s", $ak_last_visit);
            $result = mysql_query("SELECT COUNT(ID) AS count "
                                 ."FROM $tableposts "
                                 ."WHERE post_date > '$last_visit' "
                                 ."AND post_date <= '"
                                 .date("Y-m-d H:i:s"
                                      ,(time() + ($time_difference * 3600))
                                      )
                                 ."' AND post_status = 'publish'"
                                 );
            if ($result) {
                while ($data = mysql_fetch_object($result)) {
                    $posts = $data->count;
                }
            }
            setcookie("wplastvisit_posts"
                     ,$posts
                     ,time() + 30000000
                     ,$path
                     ,$domain
                     );
            $result = mysql_query("SELECT COUNT(comment_ID) AS count "
                                 ."FROM $tablecomments "
                                 ."LEFT JOIN $tableposts "
                                 ."ON $tablecomments.comment_post_ID=$tableposts.ID "
                                 ."WHERE comment_date > '$last_visit' "
                                 ."AND comment_approved = '1' "
                                 ."AND comment_date <= '"
                                 .date("Y-m-d H:i:s"
                                      ,(time() + ($time_difference * 3600))
                                      )
                                 ."' AND $tableposts.post_status = 'publish'"
                                 );
            if ($result) {
                while ($data = mysql_fetch_object($result)) {
                    $comments = $data->count;
                }
            }
            setcookie("wplastvisit_comments"
                     ,$comments
                     ,time() + 30000000
                     ,$path
                     ,$domain
                     );
        }
    }
    
    function mysql2timestamp($m) {
        return mktime(substr($m,11,2),substr($m,14,2),substr($m,17,2),substr($m,5,2),substr($m,8,2),substr($m,0,4));
    }
    
    function ak_comments_popup_link($zero='No Comments', $one='1 Comment', $more='% Comments', $CSSclass='', $none='Comments Off') {
        global $id, $wpcommentspopupfile, $wpcommentsjavascript, $post, $wpdb, $tablecomments, $HTTP_COOKIE_VARS, $cookiehash;
        global $querystring_start, $querystring_equal, $querystring_separator, $siteurl;
        $data = $wpdb->get_row("SELECT COUNT(comment_ID) AS number, MAX(comment_date) AS max_comment_date FROM $tablecomments WHERE comment_post_ID = $id AND comment_approved = '1';");
        $number = $data->number;
        $max_date = $data->max_comment_date;
        if (0 == $number && 'closed' == $post->comment_status && 'closed' == $post->ping_status) {
            echo $none;
            return;
        } else {
            if (!empty($post->post_password)) { // if there's a password
                if ($HTTP_COOKIE_VARS['wp-postpass_'.$cookiehash] != $post->post_password) {  // and it doesn't match the cookie
                    echo("Enter your password to view comments");
                    return;
                }
            }
            echo '<a href="';
            if ($wpcommentsjavascript) {
                echo $siteurl.'/'.$wpcommentspopupfile.$querystring_start.'p'.$querystring_equal.$id.$querystring_separator.'c'.$querystring_equal.'1';
                //echo get_permalink();
                echo '" onclick="wpopen(this.href); return false"';
            } else {
                // if comments_popup_script() is not in the template, display simple comment link
                comments_link();
                echo '"';
            }
            if (!empty($CSSclass)) {
                echo ' class="'.$CSSclass.'"';
            }
            echo '>';
            comments_number($zero, $one, $more, $number);
            echo '</a> ';
            echo '<script type="text/javascript">slvShowNewIndicator('.mysql2timestamp($max_date).');</script>';
        }
    }

    ak_last_visit();

}

?>