/*
Plugin Name: Kategorinin yazıları
Plugin URI: http://www.yakupgovler.com
Description: Belirttiğiniz kategorinin son yazılarını gösterir. WP 2.3 Uyumlu Versiyon.
Author: Erhan Yakut Düzenleyen: Yakup Gövler
Version: 1.0
Author URI: http://www.yakupgovler.com/
*/
function yhaberler( $kategori="---", $tane="10" )
{
global $wpdb;
$sayi=1;
if ($kategori!="---")
$kat= $wpdb->get_var(“SELECT term_id FROM “. $wpdb->terms .” WHERE name=’”.$kategori.”‘”);
else
$kat=1;
$yazisorgusu=”SELECT object_id, term_taxonomy_id from “. $wpdb->term_relationships .” where term_taxonomy_id=’”.$kat.”‘ ORDER BY object_id desc”;
$yazinolar = $wpdb->get_results($yazisorgusu);
if ($yazinolar) {
foreach($yazinolar as $yazino)
$dizi[]=$yazino->object_id;
}
foreach($dizi as $tekyazi)
{
$sorgu=”SELECT ID, post_title, post_status FROM “. $wpdb->posts .” WHERE ID=’”.$tekyazi.”‘ AND post_status=’publish’”;
$post = $wpdb->get_row($sorgu);
if ($post) {
if ($sayi<=$tane)
{
$icerik.="
ID).”\” title=\”".$post->post_title.”\”>”.substr($post->post_title,0,30).”…
\n”;
$sayi++;
}
}
}
echo $icerik;
}
?>











