<?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.2 2007/07/02 10:43:25 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 shorturl WHERE shortUrl NOT LIKE "%9%" and status="active" ORDER BY expiryDate DESC LIMIT 125';

//
// $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_once('sql2rss.php');
}

?>