FeedForAll Forum Index  
 Home  •  FAQ  •   Search   •  Register   •  Profile   •  Log in
Search found 12 matches
Author Message
Topic: Item template sql2rss
Andre

Replies: 4
Views: 2469

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Fri Sep 30, 2016 11:28 am   Subject: Item template sql2rss
I will publish text and picutures, I tought that's its needed to adapt the item template for my website
Topic: Item template sql2rss
Andre

Replies: 4
Views: 2469

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Fri Sep 30, 2016 11:13 am   Subject: Item template sql2rss
to create rss feeds in mysql database, when I have an news item, that the sql2rss automatic update this.
Topic: Item template sql2rss
Andre

Replies: 4
Views: 2469

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Fri Sep 30, 2016 11:07 am   Subject: Item template sql2rss
Hallo,
Is there anybody they can help me to create the right item template? It's didden't work on my website.
Understand the item template thanks!
<item>
<title>~~~Agrarisch Nieuws~~~</title>
<link>http://localhost/agrarischevacaturebank.nl/agarischnieuws.xml=~~~listingsdb_id~~~</link> <description>~~~Altijd actueel nieuws uit de agrarische sector~~~</description>
<pubDate>~~~RSSDATE(ItemPubDate_t)~~~</pubDate>
</item>
Topic: Problem with finishing rss feed
Andre

Replies: 0
Views: 1728

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Tue Sep 20, 2016 7:06 am   Subject: Problem with finishing rss feed
Hallo,
I have problems wiht my item template, I cannot make the rss feed with this. Wat did I wrong? Below is my item template, thanks for your answer.

< item>
<title>~~~item_name~~~</title>
< link>~~~http://www.agrarischevacaturebank.nl/agrarisch-nieuws/sql2rss/sql2rss.php~~~</link>
<description>~~~short_description~~~</description>
<pubDate>~~~RSSDATE(ItemPubDate_t)~~~</pubDate>
< /item>
Topic: Item Template
Andre

Replies: 0
Views: 1652

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Sat Sep 17, 2016 11:14 am   Subject: Item Template
My item template don't work, this is my template what have I to do?

< item>
<title>~~~item_name~~~</title>
< link>~~~http://www.agrarischevacaturebank.nl/agrarisch-nieuws/sql2rss/sql2rss.php~~~</link>
<description>~~~short_description~~~</description>
<pubDate>~~~RSSDATE(ItemPubDate_t)~~~</pubDate>
< /item>
Topic: problem with installing SQL2RSS
Andre

Replies: 10
Views: 3188

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Tue Sep 13, 2016 1:54 am   Subject: sql2rss
It works, thanks!
Topic: problem with installing SQL2RSS
Andre

Replies: 10
Views: 3188

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Thu Sep 08, 2016 2:58 pm   Subject: problem with installing SQL2RSS
Halle,
I am sure, i can see the file in the root server. When I tried to go http://www.agrarischevacaturebank.nl/mynewconfig.php I said this on the page now Warning: Division by zero in C:\domains\agrarischevacaturebank.nl\wwwroot\mynewconfig.php on line 32

Warning: Division by zero in C:\domains\agrarischevacaturebank.nl\wwwroot\mynewconfig.php on line 32
Topic: qustion about installing SQL2RSS
Andre

Replies: 0
Views: 1649

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Wed Sep 07, 2016 4:45 am   Subject: qustion about installing SQL2RSS
Can you help me, What for a file name have I to give at the configurationfile? Can you give me the parameter? I mean this file

<?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 = "sql2rss_ItemTemplate.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");
}

?>
Topic: problem with installing SQL2RSS
Andre

Replies: 10
Views: 3188

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Tue Sep 06, 2016 1:52 pm   Subject: problem with installing SQL2RSS
What for a file name have I to give at the configurationfile? Can you give me the parameter? Thnx
Regards,
André
Topic: problem with installing SQL2RSS
Andre

Replies: 10
Views: 3188

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Tue Sep 06, 2016 11:15 am   Subject: problem with installing SQL2RSS
No, I did Upload the configuration file, and put it into the same folder as your sql2rss.php file
Topic: problem with installing SQL2RSS
Andre

Replies: 10
Views: 3188

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Tue Sep 06, 2016 10:25 am   Subject: problem with installing SQL2RSS
www.agrarischevacaturebank.nl/sql2rss.php
Topic: problem with installing SQL2RSS
Andre

Replies: 10
Views: 3188

PostForum: SQL2RSS (MySQL to RSS Feed Creator)   Posted: Tue Sep 06, 2016 9:50 am   Subject: problem with installing SQL2RSS
Hi,

I used the url: http://wwwexample.com/sql2rss.php?CONFIGFILE=mynewconfig.php I have a white screen, what did I wrong?
Thanx for the answer
 

 Jump to:   


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