Beiträge von sternenlicht

/*
 * function get_links_anchor()
 *
 * added by Yannick Lefebvre
 *
 * Output a list of all links, listed by category, using the
 * settings in $wpdb->linkcategories and output it as a nested
 * HTML unordered list. Can also insert anchors for categories
 *
 * Parameters:
 *   order (default 'name')  - Sort link categories by 'name' or 'id'
 *   hide_if_empty (default true)  - Supress listing empty link categories
 *   catanchor (default false) - Adds name anchors to categorie links to be able to link directly to categories
 *   shownotes (default false) - Shows notes in addition to description for links (useful since notes field is larger than description)
 *   categorylist (default null) - Only show links inside of selected categories. Enter category numbers in a string separated by commas
 *   show_image_and_name (default false) - Show both image and name instead of only one or the other
 *   use_html_tags (default false) - Use HTML tags for formatting instead of just displaying them
 *   show_rss (default false) - Display RSS URI if available in link description
 *   beforenote (default <br />) - Code to print out between the description and notes
 */


function get_links_anchor_notes($order = 'name', $hide_if_empty = 'obsolete', $catanchor = false, $shownotes = false, $categorylist = '', $show_image_and_name = false, $use_html_tags = false, $show_rss = false, $beforenote = '<br />') {
	global $wpdb;


	$order = strtolower($order);


	// Handle link category sorting
	if (substr($order,0,1) == '_') {
		$direction = ' DESC';
		$order = substr($order,1);
	}


	// if 'name' wasn't specified, assume 'id':
	$cat_order = ('name' == $order) ? 'cat_name' : 'cat_id';
	
	if ($categorylist != '')
	   $catsearch = ' AND link_category in (' . $categorylist . ') ';
	else
	   $catsearch = '';
	   
	if (!isset($direction)) $direction = '';


	// Fetch the link category data as an array of hashesa


	$sql = "SELECT DISTINCT link_category, cat_name, show_images, 
			show_description, show_rating, show_updated, sort_order, 
			sort_desc, list_limit
		FROM $wpdb->links
		LEFT JOIN `$wpdb->linkcategories` ON (link_category = cat_id)
		WHERE link_visible =  'Y'
			AND list_limit <> 0" .
			$catsearch;
    $sql .= ' ORDER BY ' . $cat_order . $direction;
    $cats = $wpdb->get_results($sql, ARRAY_A);
	
    // Display each category
	if ($cats) {
		echo '<div class="linklist">'."\n";
		foreach ($cats as $cat) {
			// Handle each category.
			// First, fix the sort_order info
			$orderby = $cat['sort_order'];
			$orderby = (bool_from_yn($cat['sort_desc'])?'_':'') . $orderby;


			// Display the category name
			$catfront = '	';
			if ($catanchor)
				$cattext = '<a name="' . $cat['cat_name'] . '"></a>';
			else
			    $cattext = '';
			$catlink = '<h2>' . $cat['cat_name'] . "</h2>\n\t<ul>\n";
			
			echo ($catfront . $cattext . $catlink);
			// Call get_links() with all the appropriate params
			get_links_notes($cat['link_category'],
				'<li>',"</li><br />","\n",
				bool_from_yn($cat['show_images']),
				$orderby,
				bool_from_yn($cat['show_description']),
				bool_from_yn($cat['show_rating']),
				$cat['list_limit'],
				bool_from_yn($cat['show_updated']),
				$shownotes,
				$show_image_and_name,
			    $use_html_tags,
				$show_rss,
				$beforenote);


			// Close the last category
			echo "\t</ul>\n";
		}
		echo "</div>\n";
	}
}

<?
/*
 * function get_links_cats_anchor()
 *
 * added by Yannick Lefebvre
 *
 * Output a list of all links categories, listed by category, using the
 * settings in $wpdb->linkcategories and output it as table
 *
 * Parameters:
 *   order (default 'name')  - Sort link categories by 'name' or 'id'
 *   hide_if_empty (default true)  - Supress listing empty link categories
 *   table_witdh (default 100) - Width of table, percentage
 *   num_columns (default 1) - Number of columns in table
 *   catanchor (default false) - Determines if links to generated anchors should be created
 */


function get_links_cats_anchor($order = 'name', $hide_if_empty = 'obsolete', $table_width = 100, $num_columns = 1, $catanchor = false) {
	global $wpdb;
	$countcat = 0;


	$order = strtolower($order);


	// Handle link category sorting
	if (substr($order,0,1) == '_') {
		$direction = ' DESC';
		$order = substr($order,1);
	}


	// if 'name' wasn't specified, assume 'id':
	$cat_order = ('name' == $order) ? 'cat_name' : 'cat_id';


	if (!isset($direction)) $direction = '';
	// Fetch the link category data as an array of hashesa
	$cats = $wpdb->get_results("
		SELECT DISTINCT link_category, cat_name, show_images, 
			show_description, show_rating, show_updated, sort_order, 
			sort_desc, list_limit
		FROM `$wpdb->links` 
		LEFT JOIN `$wpdb->linkcategories` ON (link_category = cat_id)
		WHERE link_visible =  'Y'
			AND list_limit <> 0
		ORDER BY $cat_order $direction ", ARRAY_A);


	// Display each category
	


	if ($cats) {
		echo '<div class="linktable">';
		echo '<table width="'. $table_width . '%">'."\n";
		foreach ($cats as $cat) {
			// Handle each category.
			// First, fix the sort_order info
			$orderby = $cat['sort_order'];
			$orderby = (bool_from_yn($cat['sort_desc'])?'_':'') . $orderby;


			// Display the category name
			$countcat += 1;
			if (($countcat % $num_columns == 1) or ($countcat == 1) ) echo "<tr>\n";
						
			$catfront = '	<td><a ';
			if ($catanchor)
				$cattext = 'href="#' . $cat['cat_name'] . '" ';
			else
			    $cattext = '';
			$catitem = '>' . $cat['cat_name'] . "</a></td>\n";
			
			echo ($catfront . $cattext . $catitem);


			
			if ($countcat % $num_columns == 0) echo "</tr>\n";			
		}
	}
	if (($countcat % $num_columns = 3) or ($countcat == 1)) echo "</tr>\n";
	echo "</table>\n";
	echo "</div>\n";
}


/** function get_links_notes()
 ** Gets the links associated with category n.
 ** Parameters:
 **   category (default -1)  - The category to use. If no category supplied
 **      uses all
 **   before (default '')  - the html to output before the link
 **   after (default '<br />')  - the html to output after the link
 **   between (default ' ')  - the html to output between the link/image
 **     and it's description. Not used if no image or show_images == true
 **   show_images (default true) - whether to show images (if defined).
 **   orderby (default 'id') - the order to output the links. E.g. 'id', 'name',
 **     'url', 'description', or 'rating'. Or maybe owner. If you start the
 **     name with an underscore the order will be reversed.
 **     You can also specify 'rand' as the order which will return links in a
 **     random order.
 **   show_description (default true) - whether to show the description if
 **    show_images=false/not defined .
 **   show_rating (default false) - show rating stars/chars
 **   limit (default -1) - Limit to X entries. If not specified, all entries
 **     are shown.
 **   show_updated (default 0) - whether to show last updated timestamp
 **   show_notes - determines if notes should be displayed in addition to description
 **   show_image_and_name (default false) - Show both image and name instead of only one or the other
 **   use_html_tags (default false) - Use HTML tags for formatting instead of just displaying them
 **   show_rss (default false) - Display RSS URI if available in link description
 **   beforenote (default <br />) - Code to print out between the description and notes
 */
function get_links_notes($category = -1, $before = '', $after = '<br />',
                   $between = ' ', $show_images = true, $orderby = 'name',
                   $show_description = true, $show_rating = false,
                   $limit = -1, $show_updated = 1, $show_notes = false, $show_image_and_name = false, $use_html_tags = false, 
				   $show_rss = false, $beforenote = '<br />', $echo = true
				   ) {


    global $wpdb;


    $direction = ' ASC';
    $category_query = "";
    if ($category != -1) {
        $category_query = " AND link_category = $category ";
    }
    if (get_settings('links_recently_updated_time')) {
        $recently_updated_test = ", IF (DATE_ADD(link_updated, INTERVAL ".get_settings('links_recently_updated_time')." MINUTE) >= NOW(), 1,0) as recently_updated ";
    } else {
		$recently_updated_test = '';
	}
    if ($show_updated) {
        $get_updated = ", UNIX_TIMESTAMP(link_updated) AS link_updated_f ";
    }


    $orderby=strtolower($orderby);
    if ($orderby == '')
        $orderby = 'id';
    if (substr($orderby,0,1) == '_') {
        $direction = ' DESC';
        $orderby = substr($orderby,1);
    }


    switch($orderby) {
        case 'length':
        $length = ",CHAR_LENGTH(link_name) AS length";
        break;
        case 'rand':
            $orderby = 'rand()';
            break;
        default:
            $orderby = " link_" . $orderby;
    }


    if (!isset($length)) {
		$length = "";
	}


    $sql = "SELECT link_url, link_name, link_image, link_target,
            link_description, link_rating, link_rel, link_notes, link_rss $length $recently_updated_test $get_updated
            FROM $wpdb->links
            WHERE link_visible = 'Y' " .
           $category_query;
    $sql .= ' ORDER BY ' . $orderby;
    $sql .= $direction;
    /* The next 2 lines implement LIMIT TO processing */
    if ($limit != -1)
        $sql .= " LIMIT $limit";
    //echo $sql;
    $results = $wpdb->get_results($sql);
    if (!$results) {
        return;
    }
    foreach ($results as $row) {
		if (!isset($row->recently_updated)) $row->recently_updated = false;
        echo($before);
        if ($show_updated && $row->recently_updated) {
            echo get_settings('links_recently_updated_prepend');
        }
        $the_link = '#';
        if (($row->link_url != null) && ($row->link_url != '')) {
            $the_link = $row->link_url;
        }
        $rel = $row->link_rel;
        if ($rel != '') {
            $rel = " rel='$rel'";
        }
		
		if ($use_html_tags) {
			$descnotes = $row->link_notes;
		}
		else {
			$descnotes = wp_specialchars($row->link_notes, ENT_QUOTES);
		}
		$desc = wp_specialchars($row->link_description, ENT_QUOTES);
        $name = wp_specialchars($row->link_name, ENT_QUOTES);


        $title = $desc;


        if ($show_updated) {
           if (substr($row->link_updated_f,0,2) != '00') {
                $title .= ' (Last updated ' . date(get_settings('links_updated_date_format'), $row->link_updated_f + (get_settings('gmt_offset') * 3600)) .')';
            }
        }


        if ('' != $title) {
            $title = " title='$title'";
        }


        $alt = " alt='$name'";
            
        $target = $row->link_target;
        if ('' != $target) {
            $target = " target='$target'";
        }
        echo("<a href='$the_link'");
        echo($rel . $title . $target);
        echo('>');
        if (($row->link_image != null) && $show_images) {
			if (strstr($row->link_image, 'http'))
				echo "<img src='$row->link_image' $alt $title />";
			else // If it's a relative path
            	echo "<img src='" . get_settings('siteurl') . "$row->link_image' $alt $title />";
			if ($show_image_and_name) {
			    echo($between.$name);
			}
        } else {
            echo($name);
        }
        echo('</a>');
        if ($show_updated && $row->recently_updated) {
            echo get_settings('links_recently_updated_append');
        }


		if ($use_html_tags) {
			$desc = $row->link_description;
		}
		else {
			$desc = wp_specialchars($row->link_description, ENT_QUOTES);
		}
		
        if ($show_description && ($desc != '')) {
            echo($between.$desc);
        }


		if ($show_notes && ($descnotes != '')) {
			echo("$beforenote\n");
		    echo($between.$descnotes);
		}
		if ($show_rss && ($row->link_rss != '')) {
		    echo($between . '<a id="rss" href="'.$row->link_rss.'">RSS</a>');
		}
        echo("$after\n");
    } // end while
}


?>

<?php
/*
Plugin Name: Deep Thoughts
Version: 1.2
Plugin URI: http://spoken-for.org/archives/2005/02/22/810/
Description: Display one Deep Thought with Jack Handy from SNL every day.
Author: Valerie Holifield
Author URI: http://www.spoken-for.org
*/


function deepthoughts() {


	echo "<h2>Today's Deep Tho't</h2><ul><li>";
$day=date("z");
if ($day==0) echo "When I found the wallet in the road, I started wondering about the guy who owned it. Who was he? Was it William Gregory of 2407 Eastwood Lane, like the driver's license said, or was it someone else? And what was he going to spend the $220 on? About a week later, I started wondering again about the wallet guy. What was he like? And where was he going to spend his five dollars?";
if ($day==1) echo "If you ever drop your keys in a river of molten lava, man, let 'em go.";if ($day==365) echo "I'll never forget the time I got caught stealing watermelons from old Mr. Barnslow's watermelon patch. I was with my friend Bobby. We were giggling so hard I thought I'd wet my pants! At first we tried to steal two watermelons each, but they were too heavy and we dropped them, and that made us laugh even harder. Finally, we each picked out a good one, and we were just about to sneak back through the fence when we heard a low, deep voice behind us. 'Just where do you think you're going with those watermelons?' I gulped and turned around. It was old Mr. Barnslow, pointing his shotgun at us. Bobby dropped his watermelon, then pulled out the .38 revolver he kept in his waist, turned, and fired. But the turning must have thrown off his aim, because the shot only hit Mr. Barnslow in the thigh. Mr. Barnslow immediately fired both barrels at Bobby. One blast of buckshot missed entirely, but the other tore into Bobby's shoulder. He tried to fire back, but his shoulder was so torn up he couldn't raise his arm. Just as he was trying to switch to his left hand, Mr. Barnslow ran up and cracked him across the face with the butt of his shotgun. Bobby fell to the ground in a heap. Mr. Barnslow raised the butt of his gun to finish him off, but just then Bobby pulled out his hunting knife and plunged it into the farmer's big white belly. After that, I don't think I stole watermelons for at least a year.";
echo "</ul></li>";
}
?>