WordPress Plugin: Export Blogroll for del.icio.us

9 responses to “WordPress Plugin: Export Blogroll for del.icio.us”

1. 

   Alex 2007/12/10 11:49 pm

   I guess delicious is technically a book mark site. However, it’s more of a place for cool tricks and tips. Simply dumping your blog roll there seems kind of spammy.

2. 

   Perishable 2007/12/10 11:54 pm • Post Author

   Not if you keep it to yourself ;)

3. 

   Harry 2007/12/14 5:20 am

   Thanks for sharing the plugin, i was looking for this since some time.

4. 

   houserocker 2007/12/14 7:04 pm

   thanks so much for this great and easy to use tool!!!

5. 

   Perishable 2007/12/16 11:36 am • Post Author

   My pleasure — thanks for the feedback :)

6. 

   coutie 2008/01/01 3:32 am

   thanks for that plugin!!! Really need it and now got it!!

7. 

   Perishable 2008/01/01 9:27 am • Post Author

   Happy to help — thank you for the comment!

8. 

   Alex 2009/07/21 6:37 am

   One suggestion to import the names of categories as tags, test in 2.7.1

   function export2delicious(){
   	global $wpdb;
   	$tp = $wpdb->prefix;
   	// Cabecera
   	$log = "";
   	$log.= "n";
   	$log.= "n";
   	$log.= "Bookmarksn";
   	$log.= "";
   	$sql = "SELECT DISTINCTROW wp_terms.name, wp_term_taxonomy.term_taxonomy_id
   			FROM (wp_term_taxonomy INNER JOIN wp_terms ON wp_term_taxonomy.term_id = wp_terms.term_id) INNER JOIN wp_term_relationships ON wp_term_taxonomy.term_taxonomy_id = wp_term_relationships.term_taxonomy_id
   			WHERE (((wp_term_taxonomy.taxonomy)='link_category')) 
   			ORDER BY wp_terms.name;";
   	$rst = $wpdb->get_results($sql);
   	if ( is_array($rst) ) {
   		foreach ( $rst as $row ) {
   			$tags = str_replace(" ",",",$row->name);
   			$tags = str_replace("&",",",$tags);
   			//$log  .= "Tax:{$row->term_taxonomy_id} | {$row->name} ";
   			$links = ddmcl_generate_category($row->term_taxonomy_id,$row->name,false);
   			$sql = "SELECT link_url, link_name, link_description, link_image 
   					FROM {$tp}links INNER JOIN {$tp}term_relationships ON {$tp}links.link_id = {$tp}term_relationships.object_id
   					WHERE wp_term_relationships.term_taxonomy_id='{$row->term_taxonomy_id}' AND link_visible = 'Y' ORDER BY link_name";
   			$rst2 = $wpdb->get_results($sql);
   			if ( is_array($rst2) ) {		
   				foreach ( $rst2 as $row2 ) {
   					$log.= "<a>link_url}" TAGS="$tags">{$row2->link_name}</a>n";
   					if ($row2->link_description  ""){
   						$log.= "{$row2->link_description}n";
   					}
   				}
   			}
   		}
   	}
   	$log.= "n";
   	$log.= "";
   	return $log;
   }

9. 

   Jeff Starr 2009/07/21 10:04 am • Post Author

   Awesome, thanks Alex. I will consult with this code during the next update of my plugin. It may also help others who are looking to import the names of categories as tags. Thanks for posting :)

Comments are closed for this post. Something to add? Let me know.