• 11-08-2008, 08:47:46
    #1
    Merhaba arkadaslar Bir bot yaptim ama kategoriye icerigi ekliyor kategoriye tikladigimda iceirk geliyor ama icerik sayisi gostermiyor
    kodlar :
    $icerikekle=
    mysql_query("insert into wp_posts(post_author,post_date,post_date_gmt,post_content,post_title,post_category,post_status,comment_status,ping_status,post_name,post_modified,post_modified_gmt,post_type) 
    values
    ('1',NOW(),NOW(),'$icerikmi','$sarkibaslik','0','publish','open','open','$seobaslik',NOW(),NOW(),'post')");
    if($icerikekle){
    $sanatciidm=mysql_insert_id();
    $kataekle=mysql_query("insert into wp_term_relationships (object_id, term_taxonomy_id, term_order) values ('$sanatciidm', '$kategori', '0')");
  • 11-08-2008, 20:15:11
    #2
    Üyeliği durduruldu
    Zamanım olmadığı için botlarımdan kopyaladım değişkenleri kendine göre düzenlersin kategoriyi otomatik açsın istiyorsan;

    $kategori_kontrol=mysql_num_rows(mysql_query("Select * from wp_terms where slug='$kategori_seo'"));
    if ($kategori_kontrol=='0') {
    mysql_query("Insert Into wp_terms (name,slug,term_group) values ('$kategori_adi','$kategori_seo','0')");
    $k_sql=mysql_fetch_array(mysql_query("Select * from wp_terms where slug='$kategori_seo'"));
    $kid=$k_sql[term_id];
    mysql_query("Insert Into  wp_term_taxonomy (term_id,taxonomy,description) values ('$kid','category','$kategori_adi')");
    $taxonomy_sql=mysql_fetch_array(mysql_query("Select * from wp_term_taxonomy where term_id='$kid'"));
    $taxonomy_id=$taxonomy_sql[term_taxonomy_id];
    }
    else {
    $k_sql=mysql_fetch_array(mysql_query("Select * from wp_terms where slug='$kategori_seo'"));
    $kid=$k_sql[term_id];
    $taxonomy_sql=mysql_fetch_array(mysql_query("Select * from wp_term_taxonomy where term_id='$kid'"));
    $taxonomy_id=$taxonomy_sql[term_taxonomy_id];
    }
    $tarih = date("Y-m-j H:i:s");
    $kontrol=mysql_num_rows(mysql_query("Select * from wp_posts where post_title='$mp3_adi'"));
    if ($kontrol=='1') { echo" $mp3_adi  ======> Var !!..<br>"; } else {
    mysql_query("Insert Into wp_posts (post_author,post_category,post_title,post_name,post_content,post_date,post_date_gmt) values ('1','$kid','$mp3_adi','$adi_seo','$mesaj','$tarih','$tarih')");
    $v=mysql_fetch_array(mysql_query("Select * from wp_posts where post_content='$mesaj'"));
    mysql_query("Insert Into  wp_term_relationships (object_id,term_taxonomy_id) values ('$v[ID]','$taxonomy_id')");
    mysql_query("Insert Into wp_postmeta (meta_id,post_id,meta_key,meta_value) values ('$kid','$v[ID]','_wp_old_slug','$adi_seo')");
    mysql_query("Update wp_term_taxonomy set count=count+1 where term_id='$kid'");
    tag($mp3_adi,$v[ID]);
    echo "$mp3_adi =====> Eklendi<br>"; 
    }
    Benim istediğim kategoriye eklesin diyorsan;

    $taxonomy_sql=mysql_fetch_array(mysql_query("Select * from wp_term_taxonomy where term_id='$kid'"));
    $taxonomy_id=$taxonomy_sql[term_taxonomy_id];
    $kontrol=mysql_num_rows(mysql_query("Select * from wp_posts where post_name='$adi_seo'"));
    if ($kontrol=='1') {
    echo $video_adi."   ====>>> Var<br>"; 
    } else {
    mysql_query("Insert Into wp_posts (post_author,post_category,post_title,post_name,post_content,post_date,post_date_gmt) values ('1','$kid','$video_adi','$adi_seo','$mesaj','$tarih','$tarih')");
    $v=mysql_fetch_array(mysql_query("Select * from wp_posts where post_name='$adi_seo'"));
    mysql_query("Insert Into  wp_term_relationships (object_id,term_taxonomy_id) values ('$v[ID]','$taxonomy_id')");
    mysql_query("Insert Into wp_postmeta (meta_id,post_id,meta_key,meta_value) values ('$kid','$v[ID]','_wp_old_slug','$adi_seo')");
    mysql_query("Update wp_term_taxonomy set count=count+1 where term_id='$kid'");
    echo $video_adi."  =====>>> Eklendi<br>";
    }