DZone Snippets: wordpress code

Perform Comment Recount for WordPress

breakerjump (Josh) — Wed, 14 May 2008 23:11:28 GMT

Run from the command line and uncomment line #2 if your mysql adapter is installed via RubyGems. Fast as hell.



#!/usr/bin/ruby

#require 'rubygems'

require 'mysql'

 

db = Mysql.real_connect("host", "username", "password", "database")

ids = db.query("SELECT `ID` FROM `wp_posts` WHERE 1")

 

ids.each_hash do |post|

  id = post['ID']

  num = 0

  comments = db.query("SELECT COUNT(1) FROM `wp_comments` WHERE `comment_post_ID`='#{id}' AND `comment_approved`='1';")

  comments.each {|x| num = x[0]}

  up = db.query("UPDATE `wp_posts` SET `comment_count`='#{num}' WHERE `ID`='#{id}';")

end

Display recent posts from a category

fabricadecosas (ana m.) — Sun, 11 May 2008 20:25:24 GMT

// No need of a plugin to do this





  global $post;

 $myposts = get_posts('numberposts=5&category=4');

 foreach($myposts as $post) :

 setup_postdata($post);

 ?>

 

 

.

Transfer Wordpress MySQL database to new webhost

SimonDorfman (Simon Dorfman) — Mon, 14 Apr 2008 07:54:58 GMT

// Transfer Wordpress MySQL database to new webhost in 3 steps (assumes: A. files have already been copied over, B. database created on new server, C. database user created on new server, D. wp-config.php updated on new server)
// 1. login to old host via ssh, run this command:



mysqldump -h DB_HOST -u DB_USER -p DB_NAME > dump.sql

// replace DB_HOST, DB_USER, & DB_NAME with info from the local wp-config.php file
// when asked for password, enter DB_PASSWORD from the local wp-config.php file

// 2. copy dump.sql to your new host using sftp

// 3. login go new host via ssh, run this command:



mysql -h DB_HOST -u DB_USER -p DB_NAME < dump.sql

// replace DB_HOST, DB_USER, & DB_NAME with info from the local wp-config.php file
// when asked for password, enter DB_PASSWORD from the local wp-config.php file

// adopted from this page: http://technosailor.com/2007/04/06/wordpress-faq-how-do-i-move-my-blog-to-a-new-host/

firefox not showing vertical scrollbars in blog

jaredh123 (Jared Henderson) — Thu, 21 Feb 2008 20:40:24 GMT

hey everyone,

I'm new here and wondering if someone can help me out. i have a couple wordpress blogs i've built for clients, and i'm occasionally getting a wierd behavior in Firefox Win/Mac: sometimes even though there is plenty of content below the fold, no vertical scrollbar will show at all. it only does this on firefox.

here's an example (must view in firefox):

http://www.lorihedrickphotography.com/blog/

and i've tried adding this:

html {
height:101%;
overflow-y:scroll;
}

i looked at it with firebug, it validates. i'm stumped! any help would be greatly appreciated.

-jared

RSS output of a Prologue post

als (alex) — Wed, 30 Jan 2008 00:25:57 GMT

// This is how Prologue outputs a post





		

		http://localhost/wordpress/?p=3

		http://localhost/wordpress/?p=3#comments

		Tue, 29 Jan 2008 23:54:15 +0000



		admin

		

		



		



		http://localhost/wordpress/?p=3

		

			

                Pretty cool, here’s the Twitta!
]]>

			http://localhost/wordpress/?feed=rss2&p=3

Typo export to Wordpress WXR (script version)

laurelfan (Laurel Fan) — Wed, 18 Jul 2007 23:41:54 GMT

I tried to use this method here: http://snippets.dzone.com/posts/show/3264 however my typo blog was too slow and it kept timing out (which is why we're switching to wordpress anyway...). So I stole the code and hacked it up a bit so it could be run as a script.

Put this in $RAILS_ROOT/script/wp_export.rb, and run it like:



RAILS_ENV=production ./script/wp_export.rb > out.wxr

Import it with the "Import Wordpress" tool in your wordpress blog's admin interface.



#!/usr/bin/env ruby

require File.dirname(__FILE__) + '/../config/boot'

require 'environment'



require 'application'



# we need a controller to generate html output

class FakeController < ApplicationController

  include ActionView::Helpers::TextHelper

  include ActionView::Helpers::TagHelper

end

fake_controller = FakeController.new



articles = Article.find(:all)



xml = Builder::XmlMarkup.new(:target => STDOUT, :indent => 2)



xml.instruct! :xml, :version=>"1.0", :encoding=>"UTF-8"

xml.rss 'version' => "2.0",

        'xmlns:content' => "http://purl.org/rss/1.0/modules/content/",

        'xmlns:wfw' => "http://wellformedweb.org/CommentAPI/",

        'xmlns:dc' => "http://purl.org/dc/elements/1.1/",

        'xmlns:wp' => "http://wordpress.org/export/1.0/" do

  xml.channel do

    xml.title "The Robot Co-op"

    xml.link "http://www.robotcoop.com"

    xml.language "en-us"

    xml.ttl "40"

    xml.description "Robot coop blog"



    articles.each do |a|

        xml.item do

          xml.title a.title

          xml.content(:encoded) { |x| x << a.html(fake_controller, :all) }

          xml.pubDate a.published_at.rfc2822

          xml.guid "urn:uuid:{a.guid}", "isPermaLink" => "false"

          author = a.user.name rescue a.author

          xml.author author

          xml.dc :creator, author

          for category in a.categories

            xml.category category.name

          end

          for tag in a.tags

            xml.category tag.display_name

          end

          xml.wp :post_id, a.id

          xml.wp :post_date, a.published_at.strftime("%Y-%m-%d %H:%M:%S")

          xml.wp :comment_status, 'closed'

          xml.wp :ping_status, 'closed'

          xml.wp :post_name, a.permalink

          xml.wp :status, 'publish'

          xml.wp :post_parent, '0'

          xml.wp :post_type, 'post'

          for comment in a.comments

            xml.wp(:comment) do

              xml.wp :comment_id, comment.id

              xml.wp :comment_author, comment.author

              xml.wp :comment_author_email, comment.email

              xml.wp :comment_author_url, comment.url

              xml.wp :comment_author_IP, comment.ip

              xml.wp :comment_date, comment.published_at.strftime("%Y-%m-%d %H:%M:%S")

              xml.wp(:comment_content) { |x| x << comment.body }

              xml.wp :comment_approved, '1'

              xml.wp :comment_parent, '0'

            end

          end

       end

    end

  end

end

Typo export to WordPress WXR

schacon (Scott Chacon) — Tue, 09 Jan 2007 23:52:47 GMT

If you want to move from Typo to Wordpress, you can use this to export the strange Wordpress RSS file format (comments and all).

Just add this to the XmlController :



  def wp

    @articles = Article.find( :all, :include => [:categories, :tags, :user, :blog])

  end

And then add this file (app/views/xml/wp.rxml):



// insert code here..

xml.instruct! :xml, :version=>"1.0", :encoding=>"UTF-8"



xml.rss 'version' => "2.0", 'xmlns:content' => "http://purl.org/rss/1.0/modules/content/", 'xmlns:wfw' => "http://wellformedweb.org/CommentAPI/", 'xmlns:dc' => "http://purl.org/dc/elements/1.1/", 'xmlns:wp' => "http://wordpress.org/export/1.0/" do

  xml.channel do

    xml.title @feed_title

    xml.link @link

    xml.language "en-us"

    xml.ttl "40"

    xml.description this_blog.blog_subtitle



    @articles.each do |a|

        xml.item do

          xml.title post_title(a)

          xml.content(:encoded) { |x| x << '' }

          xml.pubDate a.published_at.rfc2822

          xml.guid "urn:uuid:#{a.guid}", "isPermaLink" => "false"

          author = a.user.name rescue a.author

          xml.author author

          xml.dc :creator, author

          for category in a.categories

            xml.category category.name

          end

          for tag in a.tags

            xml.category tag.display_name

          end

          xml.wp :post_id, a.id

          xml.wp :post_date, a.published_at.strftime("%Y-%m-%d %H:%M:%S")

          xml.wp :comment_status, 'closed'

          xml.wp :ping_status, 'closed'

          xml.wp :post_name, a.permalink

          xml.wp :status, 'publish'

          xml.wp :post_parent, '0'

          xml.wp :post_type, 'post'

          for comment in a.comments

            xml.wp(:comment) do

              xml.wp :comment_id, comment.id

              xml.wp :comment_author, comment.author

              xml.wp :comment_author_email, comment.email

              xml.wp :comment_author_url, comment.url

              xml.wp :comment_author_IP, comment.ip

              xml.wp :comment_author_date, comment.published_at.strftime("%Y-%m-%d %H:%M:%S")

              xml.wp(:comment_content) { |x| x << comment.full_html }

              xml.wp :comment_approved, '1'

              xml.wp :comment_parent, '0'

            end

          end

        end

    end

end

Then hit your typo blog at http://myblog/xml/wp and save the file to import through the WordPress interface.

Wordpress HTML Outline

ianpurton () — Thu, 02 Nov 2006 15:42:27 GMT

// Basic HTML structure for a wordpress page



	

		

		



		

			

				The Title Of Your Post

				

				

				

				

				

			



			

				Leave Your Comment

Googleit WordPress Plugin

lordrich () — Thu, 13 Apr 2006 16:20:36 GMT

// description of your code here



/*

Plugin Name: Googleit

Plugin URI: http://lordrich.com/archives/2005/04/02/just-google-it/

Description: Link to google for the current title.  Usage: google_it();

Version: 0.1

Author: Richard Kirkcaldy

Author URI: http://lordrich.com

*/



function google_it(){

	$google = 'Google It';

	echo $google;

	}

?>

Feedwordpress mod

lordrich () — Tue, 11 Apr 2006 20:22:45 GMT

A simplified version of update-feeds.php from the Feedwordpress project. This version doesn't bother checking for authentication as there's really no point. It doesn't check whether it's being run at the commandline either, it simply assumes it is being called by wget as a cron job. This is designed to be run with version 0.98





// Help us to pick out errors, if any.

ini_set('error_reporting', E_ALL & ~E_NOTICE);

ini_set('display_errors', true);

define('MAGPIE_DEBUG', true);



// Are we running from a web request or from the command line?

                $update_feeds_display = 'text/plain';

                $update_feeds_invoke = 'post';

                $update_feeds_verbose = false;



require_once ('../wp-blog-header.php');



function update_feeds_mention ($feed) {

        global $update_feeds_display;



        if ($update_feeds_display=='text/html') :

                echo "Updating ".$feed['link/name']." from <                        .$feed['link/uri']."\">".$feed['link/uri']."> ...\n";

        else :

                echo "* Updating ".$feed['link/name']." from <".$feed['link/uri']."> ...\n";

        endif;

        flush();

}



# -- Don't change these unless you know what you're doing...

define ('RPC_MAGIC', 'tag:radgeek.com/projects/feedwordpress/'); // update all



// Query secret word from database

$rpc_secret = get_settings('feedwordpress_rpc_secret');



header("Content-Type: {$update_feeds_display}; charset=utf-8");





        // Henceforward, we can proceed on the assumption that we have an authenticated user

        $uri = (isset($_REQUEST['uri']) ? $_REQUEST['uri'] : RPC_MAGIC.$rpc_secret);



        if ($update_feeds_display=='text/html') :

                echo <<





update-feeds :: FeedWordPress







update-feeds: make FeedWordPress check for new syndicated content



EOHTML;

        endif;



$feedwordpress =& new FeedWordPress;



if ($update_feeds_display=='text/html' or $update_feeds_verbose) :

        add_action('feedwordpress_check_feed', 'update_feeds_mention');

endif;



if ($update_feeds_display=='text/html') : // HTTP GET or HTTP POST: add some web niceties





        echo "\n";

        echo " ";

        echo "\n";

        echo "\n";

endif;



if ($update_feeds_invoke != 'get') : // Only do things with side-effects for HTTP POST or command l

ine

        if ($update_feeds_display == 'text/html') : echo "\n"; endif;

        $delta = @$feedwordpress->update($uri);

        if ($update_feeds_display == 'text/html') : echo "\n"; endif;



        if (is_null($delta)) :

                if ($update_feeds_invoke == 'cmd') :

                        $stderr = fopen('php://stderr', 'w');

                        fputs($stderr, "update-feeds (".date('Y-m-d H:i:s')."): ERROR: I don't synd

icate <$uri>\n");

                elseif ($update_feeds_display == 'text/plain') :

                        echo "update-feeds (".date('Y-m-d H:i:s')."): ERROR: I don't syndicate <$ur

i>\n";

                else :

                        echo "Error: I don't syndicate $uri>\n";

                endif;

        elseif ($update_feeds_display=='text/html' or $update_feeds_verbose) :

                $mesg = array();

                if (isset($delta['new'])) : $mesg[] = ' '.$delta['new'].' new posts were syndicated

'; endif;

                if (isset($delta['updated'])) : $mesg[] = ' '.$delta['updated'].' existing posts we

re updated'; endif;

                if ($update_feeds_display=='text/html') : echo ""; endif;

                echo "Update complete.".implode(' and', $mesg);

                if ($update_feeds_display=='text/html') : echo ""; endif;

                echo "\n"; flush();

        endif;

endif;



if ($update_feeds_display=='text/html') : // HTTP GET or HTTP POST: close off web niceties

        echo <<

← Return to WordPress Dashboard





EOHTML;

endif;

?>