Una rutina que convierte los links o enlaces de WordPress en Bookmarks de delicious poniendo los nombres de categoría y los comentarios.
[PHP]
function export2delicious(){
global $wpdb;
$tp = $wpdb->prefix;
// Cabecera
$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.= «
if ($row2->link_description <> «»){
$log.= «
}
}
}
}
}
$log.= «
\n»;
$log.= ««;
return $log;
}
[/PHP]