forked from WordPress/WordPress
-
Notifications
You must be signed in to change notification settings - Fork 0
/
wp-links-opml.php
59 lines (58 loc) · 2.14 KB
/
wp-links-opml.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
<?php
$blog = 1; // Your blog's ID
$doing_rss = 1;
header('Content-type: text/xml', true);
require('wp-blog-header.php');
$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
FROM $wpdb->links
LEFT 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(htmlspecialchars(stripslashes($result->cat_name))) ?>">
<?php
$prev_cat_id = $result->link_category;
} // end if new category
?>
<outline title="<?php echo(htmlspecialchars(stripslashes($result->link_name))) ?>" type="link" xmlUrl="<?php echo $result->link_rss; ?>" htmlUrl="<?php echo($result->link_url) ?>"/>
<?php
} // end foreach
} // end if
?>
</outline>
</body>
</opml>