Writing Something

Varsayılan Admin Kullanıcısının Adını Değiştirmek İçin;
UPDATE wp_users SET user_login = 'Your New Username' WHERE user_login = 'Admin';

Kullanıcı Şifresini Resetlemek İçin;
UPDATE wp_users SET user_pass = MD5( 'new_password' ) WHERE user_login = 'your-username';

Yazı Revizyonlarını Silmek İçin;
DELETE a,b,c FROM wp_posts a
LEFT JOIN wp_term_relationships b ON (a.ID = b.object_id)
LEFT JOIN wp_postmeta c ON (a.ID = c.post_id)
WHERE a.post_type = 'revision'

Gelen Yorumlardaki Eposta Adreslerini Almak İçin;
SELECT DISTINCT comment_author_email FROM wp_comments;

Kullanılmayan Tagların Listesi İçin;
SELECT * From wp_terms wt
INNER JOIN wp_term_taxonomy wtt ON wt.term_id=wtt.term_id WHERE wtt.taxonomy='post_tag' AND wtt.count=0;

Last week I needed a flickr gallery plugin for wordpress. I searched all the plugins and like flickr mini galery plugin most.

My first criteria to decide this flickr plugin is it must work without flash. This plugin works without flash. :)

Usage is very simple. First you set your flickr user id from the admin panel and after some galery preferences you can add your flickr gallery to any post you like.

And this is how you use Flickr mini galery on posts.
[ miniflickr photoset_id="72157624698916423" ]

One of the good ways to integrate flickr with wordpress is the wp-flickr plugin. In my opinion the best way integration for galleries is flickr mini galery.

But if you want to see all of your images in flickr from wordpress admin panel, the best way is WP-Flickr Plugin.

You will see all you photo sets from an html select.

I use “wp-flickr” and “flickr mini galery” plugins both. And I am very happy :)

you can download it here:
wordpress.org/extend/plugins/wp-flickr

Using an image gallery plugin in wordpress is a need. Not every one likes the default gallery behaviour of wordpress.

I am using Nextgen gallery for most of my sites. But i found out a new image gallery plugin … wp facebox gallery.

Nextgen is also good but wp facebox gallery is simple and beautiful. Simple is better…

Nextgen’s admin panel is confusing for end users. To use wp facebox gallery, all you need is uploading images directly in the post and giving a rel attribute value “facebox”.

[ gallery  rel="facebox" ]

wp facebox gallery also has a “keyboard navigation” functionality!

Most of us use wordpress because we now Google loves it :) If you did not know this, you just learned :P and if you do not trust my words, just install other blog engines or your own design and publish them at same dates. After 15 days check your pages Google positions! Or just look at your visitor count! …

Anyway … there is a very basic Google advice that says use breadcrumbs navigation. When you use breadcrumbs navigation Google easily understands your hierarchy. And gives you more rank… Also your visitor surfs better too.

You can find this information also in Google’s starter guide for seo pdf which you can find at Google webmaster central.

To sum up, I write this article because this navigation is not included in default wordpress. You need to install a plugin for breadcrumbs or edit the “single.php”. On that page just add this code above the post title.

<p id="breadcrumbs"> <a href="http://www.yoursite.com">Home</a> » <a href="<?php get_category_link($cat) ?>“></a> » <b title="<?php the_title(); ?>“><?php the_title(); ?></b></p> <p>

Every plugin is an extra cost on performance issues. So just change your single.php and do not install a plugin!