sql2rss_sampleconfig.php

SQL to RSS > Html

<?php
//
// sql2rss.php RSS feed generation from SQL Sample Configuration
//
// Copyright 2006-2007 NotePage, Inc.
// http://www.feedforall.com
//
// NotePage, Inc. grants registerd users of our FeedForAll and/or
// FeedForAll Mac product(s) the right to install and use the
// sql2rss.php script free of charge.  
// Please refer to the EULA included in the download for full license
// terms and conditions.
//
// $Id: sql2rss_SampleConfig.php,v 3.0 2007/04/16 14:23:05 housley Exp $
//

//
// Enable the caching for the resulting XML file.  Since it may take time to 
// process multiple RSS feeds and may be noticed by visitors to your
// website this is highly recommended.  During development and testing set 
// this to 0 so you can see the results of your changes.
$useOutputCaching = 0;

//
// The variable $outputCacheTTL controls how many seconds a cached copy of
// resulting RSS feed can be used before it must be recreated.
// $outputCacheTTL = 60;      //cache files for 1 minute
$outputCacheTTL = 3600;    //cache files for 1 hour
// $outputCacheTTL = 86400;   //cache files for 1 day

//
// $ChannelTemplate is the XML file that contains the outer, <channel>, items
// for the produced feed.  This MUST be a valid RSS 2.0 feed without any
// <item>'s.  It must also specify "UTF-8" encoding, since all the produced
// items will be in UTF-8.
$ChannelTemplate  = "sql2rss_ChannelTemplate.xml";

//
// $ItemTemplate is the ITEM file that contains the the template for <item>.
// This MUST be a valid RSS 2.0 feed <item>.  It must also specify "UTF-8" 
// encoding, since all the produced items will be in UTF-8.
$ItemTemplate  = "sql2rss_ItemTemplate.xml";

//
// $SQLQuery is a valid database query for your database
$SQLQuery = "SELECT * FROM feedItmes WHERE ItemTitle LIKE \"%FeedForAll%\" ORDER BY ItemPubDate_t DESC LIMIT 10";

//
// $configFile is the configuration file with the database username and
// password
$DBconfigFile = "sql2rss_DBconfig.inc.php";

//
// $debugLevel controls the amount of debugging information that is shown, if any.
//   0 = NONE (default)
//   1 = MySQL errors
//   2 =
//   3 = Informaiton for every step
// 
$debugLevel = 0;

//
// Since we are calling sql2rss.php from here, we don't want
// to include a separate config file.
$ConfigFilename = "DO_NOT_INCLUDE_CONFIG";
if (!isset($_REQUEST["buildConfig"])) {
  @include("sql2rss.php");
}

?>