zaaba

BTW, the code is as follows just in case the page link above goes dead:

<?php
require('./wp-blog-header.php');

$start = '100';
$end = '101';

for ($i=$start; $i<=$end; $i++){
$result = $wpdb->query("INSERT wp_post2cat VALUES (NULL, $i, 1)");
if($result == 1) {
$count++;
}
}
echo "$count rows affected.";
?>

I’ve managed to copy all of my old posts AND managed to change the authors to the right people. The problem is now that the old posts have no categories assigned.

Instead of manually clicking EDIT on the wp-admin screen for each and every one of these entries (OVER 200++!!!), is there a mysql command I can run so that I assign all posts with post_ID > 50 to the default category?

That would be SOO useful. Thanks!

Sweet! Will try it out when I get the chance Kitten. Thanks! Finally… a PLUGIN!

Anonymous & Justin: From what I know, and correct me if I’m wrong, the reason why links result in blank pages is because:
1. The loop has not been reset to ONE. If that is the case, loops will break because the loop threshold has been met. Remember to put the revised WP loop end (see above post). I see you have already done this Justin so ignore this point 🙂
2. Another reason is the !$single rule has been invoked. You might want to try toggling this on/off by deleting/adding the ! symbol. Remember that the ! results in the NOT logical operator. If you have the the !$single rule in your filter, the loop will NOT SHOW if you are in “single-post” mode (e.g. what happens when you click on a permalink). If you want the loop to show regardless of whether you are in full index mode or single post (permalink) mode then just delete the && !$single rule. Ommitting the ! altogether results in the loop ONLY SHOWING if in single-post mode.
For example, my site at http://www.truedeath.com has 2 loops: the central blog loop and the photoblog loop. The central blog loop calls all posts BUT from the photoblog category. The photoblog loop at the side calls posts from ONLY the photoblog category and ONLY if NOT in single-post mode ie: only if we’re on the main index page else it will be hidden.
Ah, but this posed a problem: what if the visitor clicks on a permalink of a photo? The index file would not display it because the category filter would filter it out. My solution then was to create another page – photoblog.php which is the exact clone of index.php but with the photoblog category filter reversed so that it would ONLY show posts from the photoblog category. This was the fastest workaround I could come to without uber hacking the index file any further than I had already done above.
The operating logic above is really quite simple. I guess if you want to have more complex rules you’ll have to tinker alot more with the if statements. If its only 1 index file that you want to worry about then perhaps it would be best to come up with many loops (as in MANY loops) with each having its own set of rules. You can set some to only appearing in single-post mode and some in all modes but excluding certain categories. This is probably very cumbersome but I’m sure with much PHP engineering and dilligence you could combine many of those rules and if statements into one single block.
Might I suggest writing out on a sheet of paper what exactly you want visible at any time and then cater those rules to fit around those permutations. Remember to take note of the ! NOT operator! Good luck!

Its for 1.2 but somehow even I can’t get it to work! I’m not too sure why though. Still fixing it…