diff options
| author | donncha <donncha@7be80a69-a1ef-0310-a953-fb0f7c49ff36> | 2005-07-12 11:27:54 +0000 |
|---|---|---|
| committer | donncha <donncha@7be80a69-a1ef-0310-a953-fb0f7c49ff36> | 2005-07-12 11:27:54 +0000 |
| commit | 4f3bce79bfb5851cef9e7bc655c91bb3093cc401 (patch) | |
| tree | 10a0991fddeb0e075d7fa46e2b40e5dbc64d1e88 /wp-inst/wp-links-opml.php | |
| download | wordpress-mu-4f3bce79bfb5851cef9e7bc655c91bb3093cc401.tar.gz wordpress-mu-4f3bce79bfb5851cef9e7bc655c91bb3093cc401.tar.xz wordpress-mu-4f3bce79bfb5851cef9e7bc655c91bb3093cc401.zip | |
Initial Import
git-svn-id: http://svn.automattic.com/wordpress-mu/trunk@1 7be80a69-a1ef-0310-a953-fb0f7c49ff36
Diffstat (limited to 'wp-inst/wp-links-opml.php')
| -rw-r--r-- | wp-inst/wp-links-opml.php | 58 |
1 files changed, 58 insertions, 0 deletions
diff --git a/wp-inst/wp-links-opml.php b/wp-inst/wp-links-opml.php new file mode 100644 index 0000000..04d4ff0 --- /dev/null +++ b/wp-inst/wp-links-opml.php @@ -0,0 +1,58 @@ +<?php +$doing_rss = 1; + +require('wp-blog-header.php'); +header('Content-type: text/xml; charset=' . get_settings('blog_charset'), true); +$link_cat = $_GET['link_cat']; +if ((empty($link_cat)) || ($link_cat == 'all') || ($link_cat == '0')) { + $sql_cat = ''; +} else { // be safe + $link_cat = ''.urldecode($link_cat).''; + $link_cat = addslashes_gpc($link_cat); + $link_cat = intval($link_cat); + if ($link_cat != 0) { + $sql_cat = "AND $wpdb->links.link_category = $link_cat"; + $cat_name = $wpdb->get_var("SELECT $wpdb->linkcategories.cat_name FROM $wpdb->linkcategories WHERE $wpdb->linkcategories.cat_id = $link_cat"); + if (!empty($cat_name)) { + $cat_name = ": category $cat_name"; + } + } +} +?><?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 + JOIN $wpdb->linkcategories on $wpdb->links.link_category = $wpdb->linkcategories.cat_id + $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 +?> + </outline> +<?php + } // end if not first time +?> + <outline type="category" title="<?php echo wp_specialchars($result->cat_name); ?>"> +<?php + $prev_cat_id = $result->link_category; + } // end if new category +?> + <outline title="<?php echo wp_specialchars($result->link_name); ?>" type="link" xmlUrl="<?php echo wp_specialchars($result->link_rss); ?>" htmlUrl="<?php echo wp_specialchars($result->link_url); ?>" updated="<?php if ('0000-00-00 00:00:00' != $result->link_updated) echo $result->link_updated; ?>" /> +<?php + } // end foreach + } // end if +?> + </outline> + </body> +</opml>
\ No newline at end of file |