Exporting all blog URL links

webnise said:

write the following code in any php file (say links.php) and put it wp-content folder so that you can access it via http://www.yoursite.com/wp-content/links.php and it will show you all the links of your blog.

Access this file via browser and save the file as TXT and import into Excel using Import from TXT, it will be '|' delimited.

Code:

 [FONT=&quot]<?php[/FONT]
  
  [FONT=&quot]require_once('../wp-blog-header.php');[/FONT]
  [FONT=&quot]query_posts('&showposts=-1&order=ASC');[/FONT]
  
  [FONT=&quot]while (have_posts()) : the_post(); ?>[/FONT]
  
  [FONT=&quot]<?php the_permalink(); ?>|<?php the_title(); ?>|<?php the_tags(); ?>[/FONT]
  [FONT=&quot]<br />[/FONT]
  
  [FONT=&quot]<?php endwhile; ?>[/FONT]

Click to expand...

<Title> Link Sript</Title> 

<?php
  
  require_once('../wp-blog-header.php');
  query_posts('&showposts=-1&order=ASC');
  
  while (have_posts()) : the_post(); ?>
  
  <?php the_permalink(); ?>
  <br />
  
  <?php endwhile; ?>

Comic said:

That worked great. I did make a change to the script so it just produces the URL and nothing else. I will work on this some more and try to perfect it some. Right now the result with the script below only returns the URL's ready to be copied. Thanks a ton for posting the script.

Code:

<Title> Link Sript</Title> 

<?php
  
  require_once('../wp-blog-header.php');
  query_posts('&showposts=-1&order=ASC');
  
  while (have_posts()) : the_post(); ?>
  
  <?php the_permalink(); ?>
  <br />
  
  <?php endwhile; ?>

Click to expand...