FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
 http://www.countyfairgrounds.net NEEDS MUCHO help View next topic
View previous topic
Post new topicReply to topic
Author Message
ksr1



Joined: 09 Aug 2007
Posts: 13
Location: Bailey, Colorado

PostPosted: Sat Dec 08, 2007 6:01 pm Reply with quoteBack to top

Hi, I am trying to help people by putting 51 rss feeds on my new mobile website. we are the largest and oldest county an state fair site online. I have been using FeedForAll for the podcast feed and for the most part have been happy with it. I have a Msql database on my Yahoo server that someone has done for me. Now I know that this script will hook up to it if I can figure it out and produce 51 state feeds for all of us and the nation but I cannot figure it out. The 51st feed would be a comphrehensive feed that I would like to pull from the database on a weekly basis and would be chronological I read the instructions twice and the man who did the database read the instructions and then got very mad at me - he said I understood rss and he wasn't going to learn well I have been getting just sick over this script. I have tried and tried. I know it must work or why would you have it posted? I did the config file which I have at this address: http://www.countyfairgrounds.net/feedforall/sql2rss_install.php (WELL ANYWAY - here is the info -
<?php
$config["DBuser"]= "fairsdb";
$config["DBpassword"] = "george";
$config["DBmachine"] = "localhost";
$config["DBdatabase"] = "FairsDB";
$config["DBtype"] = "mysql";
?>)
THAT seemed simple enough and then the next link is http://www.countyfairgrounds.net/feedforall/sql2rss.php?buildConfig
<?PHP

//
// Enable the caching for the resulting XML file. Since it may take time to
$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 = 3600;

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

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

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

//
// 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");
}

?>

NOW, I am not at all sure what exactly show be under DB Config file NOR do I nor the guy who did the MSQL database know or can figure out what the next thingy is that the file calls for and thats the QUERY???? SO, we left it there. Needless to say this doesn't work. Can someone please walk us through this mess?
View user's profileSend e-mailVisit poster's websiteYahoo Messenger
MacSupport



Joined: 24 Feb 2005
Posts: 2805

PostPosted: Sun Dec 09, 2007 6:40 am Reply with quoteBack to top

[quote="ksr1"]Hi, I am trying to help people by putting 51 rss feeds on my new mobile website. we are the largest and oldest county an state fair site online. I have been using FeedForAll for the podcast feed and for the most part have been happy with it. I have a Msql database on my Yahoo server that someone has done for me. Now I know that this script will hook up to it if I can figure it out and produce 51 state feeds for all of us and the nation but I cannot figure it out. The 51st feed would be a comphrehensive feed that I would like to pull from the database on a weekly basis and would be chronological I read the instructions twice and the man who did the database read the instructions and then got very mad at me - he said I understood rss and he wasn't going to learn well I have been getting just sick over this script. I have tried and tried. I know it must work or why would you have it posted? I did the config file which I have at this address: http://www.countyfairgrounds.net/feedforall/sql2rss_install.php (WELL ANYWAY - here is the info -
<?php
$config["DBuser"]= "fairsdb";
$config["DBpassword"] = "george";
$config["DBmachine"] = "localhost";
$config["DBdatabase"] = "FairsDB";
$config["DBtype"] = "mysql";
?>)
THAT seemed simple enough and then the next link is http://www.countyfairgrounds.net/feedforall/sql2rss.php?buildConfig
<?PHP

//
// Enable the caching for the resulting XML file. Since it may take time to
$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 = 3600;

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

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

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

//
// 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");
}

?>

NOW, I am not at all sure what exactly show be under DB Config file NOR do I nor the guy who did the MSQL database know or can figure out what the next thingy is that the file calls for and thats the QUERY???? SO, we left it there. Needless to say this doesn't work. Can someone please walk us through this mess?[/quote

The key to all of this is your QUERY statement. You will need to make 51 config files, each with a unique QUERY statement to select from the proper state.

Jim

_________________
Be sure to check out the FeedForAll Mac tutorials at: http://www.FeedForAll.com/tutorials/

FeedForAll Mac and rss2html.php
support@FeedForAll.com
View user's profileVisit poster's website
Display posts from previous:      
Post new topicReply to topic


 Jump to:   



View next topic
View previous topic


Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme