Changeset 871

Show
Ignore:
Timestamp:
02/13/04 13:30:31 (5 years ago)
Author:
saxmatt
Message:

Show RSS URIs in OPML file.

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • trunk/wp-links-opml.php

    r817 r871  
    3131    </head> 
    3232    <body> 
    33 <?php $sql = "SELECT $tablelinks.link_url, $tablelinks.link_name, $tablelinks.link_category, $tablelinkcategories.cat_name \n" 
    34         . " FROM $tablelinks \n" 
    35         . " LEFT JOIN $tablelinkcategories on $tablelinks.link_category = $tablelinkcategories.cat_id \n" 
    36         . " WHERE $tablelinks.link_url IS NOT NULL AND $tablelinks.link_url <> '' \n" 
    37         . " $sql_cat \n" 
    38         . " ORDER BY $tablelinkcategories.cat_name, $tablelinks.link_name \n"; 
     33<?php $sql = "SELECT $tablelinks.link_url, link_rss, $tablelinks.link_name, $tablelinks.link_category, $tablelinkcategories.cat_name  
     34FROM $tablelinks  
     35 LEFT JOIN $tablelinkcategories on $tablelinks.link_category = $tablelinkcategories.cat_id 
     36 $sql_cat 
     37 ORDER BY $tablelinkcategories.cat_name, $tablelinks.link_name \n"; 
    3938 //echo("<!-- $sql -->"); 
    4039 $prev_cat_id = 0; 
    …… 
    5453        } // end if new category 
    5554?> 
    56             <outline type="link" text="<?php echo(htmlspecialchars(stripslashes($result->link_name))) ?>" url="<?php echo($result->link_url) ?>"/> 
     55            <outline type="link" text="<?php echo(htmlspecialchars(stripslashes($result->link_name))) ?>" xmlUrl="<?php echo $result->link_rss; ?>" link="<?php echo($result->link_url) ?>"/> 
    5756<?php 
    5857        } // end foreach