Archive for November 2010


Using Webmatrix IDE for WordPress

November 24th, 2010 — 5:49am

When I first heard about webmatrix I thought it is a useless IDE.
Because we already have visual studio express editions.

When I install and test webmatrix I see that this is more simple IDE with php support. And visual studios has no obvious way to develop php.

Webmatrix also is not the best enviroment for php. For me it is a very good start.
People who are on .net side are more comfortable with Microsoft’s interface. Webmatrix is an M$ interface for my wordpress development.

Webmatrix is still beta but I developed two wordpress sites with it.
It has locked sometimes but I can give it a 7 out of 10.

I would be more happy with webmatrix if I could create and backup my mysql databses with one click buttons!

Previously I was using virtual machine enviroments or online admin panel to develop wordpress sites.
I did not want to install wamp server or other things to my local machine. You know less installation is better performance!

I now develop wordpress on my local more comfortable…

Thank you webmatrix :P

1 comment » | Tools - Programs

WordPress İçin Çok Tatlı MySql Sorgular

November 11th, 2010 — 4:20pm

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;

2 comments » | Wordpress


Back to top