-?><?php echo '<?xml version="1.0"?'.">\n"; ?>
-<!-- generator="wordpress/<?php echo $wp_version ?>" -->
-<opml version="1.0">
- <head>
- <title>Links for <?php echo get_bloginfo('name').$cat_name ?></title>
- <dateCreated><?php echo gmdate("D, d M Y H:i:s"); ?> GMT</dateCreated>
- </head>
- <body>
-<?php $sql = "SELECT $wpdb->links.link_url, link_rss, $wpdb->links.link_name, $wpdb->links.link_category, $wpdb->linkcategories.cat_name, link_updated
-FROM $wpdb->links
- INNER JOIN $wpdb->linkcategories on $wpdb->links.link_category = $wpdb->linkcategories.cat_id
- AND $wpdb->links.link_visible = 'Y'
- $sql_cat
- ORDER BY $wpdb->linkcategories.cat_name, $wpdb->links.link_name \n";
- //echo("<!-- $sql -->");
- $prev_cat_id = 0;
- $results = $wpdb->get_results($sql);
- if ($results) {
- foreach ($results as $result) {
- if ($result->link_category != $prev_cat_id) { // new category
- if ($prev_cat_id != 0) { // not first time