http://galore.co.za/blog/feed/rdf/ http://galore.co.za/blog/feed/rss/ http://galore.co.za/blog/feed/ http://galore.co.za/blog/feed/atom/ http://galore.co.za/blog/comments/feed/

wordpress

Finding Your Feed URL

There are times when you want to tell someone your site’s feed address or URL, or you need it to submit it to search engines and directories, many of which now accept feed URL submissions. There are four possible URLs for each of your feeds. Any of these will work.

  • http://example.com/?feed=rss
  • http://example.com/?feed=rss2
  • http://example.com/?feed=rdf
  • http://example.com/?feed=atom

If you are using custom permalinks, you should be able to reach them through this usage:

  • http://example.com/feed/
  • http://example.com/feed/rss/
  • http://example.com/feed/rss2/
  • http://example.com/feed/rdf/
  • http://example.com/feed/atom/

Courtesy:wordpress.org

How to create RSS feed for your blog

In this tutorial you’ll learn how to create and RSS feed for your blog. RSS feeds allow your visitors to keep track of your website news and updates without visiting your website each time. You can view RSS feeds from various websites using the Feed Reader application or web service.

There are several feed formats, you can learn more about setting up feeds from WordPress Codex. In this tutorial we’ll cover only the most important things.

You can create the RSS feed for your posts to display your blog updates. The other option is to display the comments RSS to let your customers subscribe for the comments tree.

  • URL for RDF/RSS 1.0 feed
    <?php bloginfo(‘rdf_url’); ?>
  • URL for RSS 0.92 feed
    <?php bloginfo(‘rss_url’); ?>
  • URL for RSS 2.0 feed
    <?php bloginfo(‘rss2_url’); ?>
  • URL for Atom feed
    <?php bloginfo(‘atom_url’); ?>
  • URL for comments RSS 2.0 feed
    <?php bloginfo(‘comments_rss2_url’); ?>

Put the code for the RSS you want to display into the WordPress theme file to display the link. Using the CSS styles you can add the background image and colors.

For example to display the feed in the header edit wp-content/themes/theme###/header.php file.

You can also use some third party plugins to create RSS feeds for your WordPress blog but we recommend using default WordPress functions.

Courtesy:TemplateMonster.com

Usefull wordpress mysql queries

Change Siteurl & Homeurl – Used when moving your site to a new domain or moving your site from localhost to live.

UPDATE wp_options SET option_value = replace(option_value, ‘http://www.oldsiteurl.com’, ‘http://www.newsiteurl.com’) WHERE option_name = ‘home’ OR option_name = ‘siteurl’;

Change GUID – Used to fix the urls after moving your site to a new domain or moving your site from localhost to live.

UPDATE wp_posts SET guid = REPLACE (guid, ‘http://www.oldsiteurl.com’, ‘http://www.newsiteurl.com’);

Change URL in Content – Used when moving your site to a new domain or moving your site from localhost to live.

UPDATE wp_posts SET post_content = REPLACE (post_content, ‘http://www.oldsiteurl.com’, ‘http://www.newsiteurl.com’);

Change Default “Admin” Username

UPDATE wp_users SET user_login = ‘Your New Username’ WHERE user_login = ‘Admin’;

Reset Password

UPDATE wp_users SET user_pass = MD5( ‘new_password’ ) WHERE user_login = ‘your-username’;

Assign all articles by Author B to Author A

UPDATE wp_posts SET post_author = ‘new-author-id’ WHERE post_author = ‘old-author-id’;

Export all Comment Emails with no Duplicate

SELECT DISTINCT comment_author_email FROM wp_comments;

Delete all Pingback

DELETE FROM wp_comments WHERE comment_type = ‘pingback’;

Delete all Spam Comments

DELETE FROM wp_comments WHERE comment_approved = ‘spam’;

  • 0 = Comment Awaiting Moderation
  • 1 = Approved Comment
  • spam = Comment marked as Spam