Category: Wordpress

WordPress: Quickly Replace Content Across All Blog Entries

I discovered I could change my image paths that were linked against www.techish.net to www.techish.net by using MySQL to REPLACE the string.
After a few minutes of thinking about this, this is a really cool thing — beyond what I just accomplished.
I can use this to update what was once static information (phone number, fax, email, contact information, etc.) quickly!
This is what the syntax looked like:

update blog_posts set post_content = REPLACE(post_content,'https://techish.net/wp-content/uploads/', 'https://techish.net/wp-content/uploads/');

Now using that as a basis, I can use REPLACE(post_content, ”,”) to create quick hacks to change emails on-the-fly that were contained in my posts.

Migrating…

Please stand-by while old blog posts are migrated to the new system.
All content has been migrated.
Notes…
Migrating WordPress to a subdomain caused images to b0rk. This was the fix instead of screwing with .htaccess and since I’m also using WordPress on the main domain:

update blog_posts set post_content = REPLACE(post_content,'https://techish.net/wp-content/uploads/', 'https://techish.net/wp-content/uploads/');

That saved me from modifying 98 posts by hand. *Phew*
And to update the media library path:

UPDATE wp_posts SET guid = REPLACE(guid,'https://techish.net/wp-content/uploads/','https://techish.net/wp-content/uploads/')

GooglePlus RSS Feed Reader in PHP

I’m working on a GooglePlus RSS Feed Reader in PHP for anyone who might be interested in making a WordPress module or something similar to display N latest Public posts to your stream.

I have some code in PHP that I’m tinkering with. The original idea came from http://plusfeed.appspot.com/.

You can view the progress: https://techish.net/pub/googleplus_rss.php

You can use ?id= to supply your own Google+ ID string found when you login and navigate to http://plus.google.com/

The string of interest here is:

https://plus.google.com/_/stream/getactivities/?&sp=[1,2,"XXX",null,null,null,null,"social.google.com",[]]

Where XXX is your Google+ ID.

[update: August 7, 2011 22:45 EST]

The RSS is for the most part complete; I have some code clean-up to work on yet but it is working. Check out the right column and you’ll see my public feed from Google+.

To reference this, simply add: https://techish.net/pub/googleplus_rss.php?id=YOURGOOGLEPLUSIDHERE to the RSS widget source in WordPress – or in your favorite RSS reader. Let me know if you have any problems!

Tip: You can show the latest N by adding ?latest=X to the URI.

[update: August 6, 2011 02:07 EST]

I have completed most of the work. I’ve added two user controllable parameters:

id - Integer:  Google+ ID
latest - Integer:  Latest X number of entries to return.

https://techish.net/pub/googleplus_rss.php?latest=5 will show you my latest 5 entries.

I plan to add date constraints sometime soon and eventually I can maybe pull in comments to the entries(?).

Latest Site News

Well, I’m now on the latest release of WordPress (3.2.1).

Mail service is up and running for techish.net, techish.info and techish.org. Anyone with email @techish.net, @techish.info, or @techish.org can access webmail via http://webmail.techish.net/ as usual.

Squirrelmail is up and running to serve me all my glorious (read: unmissed) mail!

DNS servers are back up and operating full force. I am running authoritative for techish.net, TECHISH.ORG, TECHISH.INFO as well as a local cache.