Log in with username/password: lyceum/lyceum

Changeset 1070

Show
Ignore:
Timestamp:
08/18/07 12:52:40 (1 year ago)
Author:
jjb
Message:

Remove unused category selection (nothing was joining against the category table, and the query is already post-specific)

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • trunk/src/lyceum/wp-admin/execute-pings.php

    r638 r1070  
    44 
    55// Do pingbacks 
    6 while ($ping = $wpdb->get_row(" 
    7    SELECT *  
    8    FROM {$wpdb->posts}, {$wpdb->postmeta} , {$wpdb->categories} 
    9    WHERE  
    10       blog='$blog' AND 
    11       {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id AND 
    12       {$wpdb->postmeta}.meta_key = '_pingme' LIMIT 1"))  
    13 
     6while ($ping = $wpdb->get_row("SELECT * FROM {$wpdb->posts}, {$wpdb->postmeta} WHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id AND {$wpdb->postmeta}.meta_key = '_pingme' LIMIT 1")) { 
    147   $wpdb->query("DELETE FROM {$wpdb->postmeta} WHERE post_id = {$ping->ID} AND meta_key = '_pingme';"); 
    158   pingback($ping->post_content, $ping->ID); 
     
    1710 
    1811// Do Enclosures 
    19 while ($enclosure = $wpdb->get_row(" 
    20    SELECT *  
    21    FROM {$wpdb->posts}, {$wpdb->postmeta} , {$wpdb->categories} 
    22    WHERE  
    23       blog='$blog' AND 
    24       {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id AND  
    25       {$wpdb->postmeta}.meta_key = '_encloseme' LIMIT 1"))  
    26 
     12while ($enclosure = $wpdb->get_row("SELECT * FROM {$wpdb->posts}, {$wpdb->postmeta} WHERE {$wpdb->posts}.ID = {$wpdb->postmeta}.post_id AND {$wpdb->postmeta}.meta_key = '_encloseme' LIMIT 1")) { 
    2713   $wpdb->query("DELETE FROM {$wpdb->postmeta} WHERE post_id = {$enclosure->ID} AND meta_key = '_encloseme';"); 
    2814   do_enclose($enclosure->post_content, $enclosure->ID); 
Log in with username/password: lyceum/lyceum