Ok I'm using this
RSS Feed Generator to make a feed that can tell people when there's a new site in for example an Amateur Porn category. It's running through php and MySQL and I suck at both
Here's the feed so you can see the error message:
http://ylovesporn.com/rss/rss20.php
Here's what I have (Database information is edited out!):
Code:
<?php
/*****************************************************
RSS20.php - RSS generator by Ovi Crisan @ www.2RSS.com
All rights reserved - V1.0 - Also, available for ASP
This script is distributed as freeware. You can change
it upon your needs but have to keep its copyright info
More scripts [PHP & ASP] and RSS directory on our site
******************************************************/
$rss_server="xxx"; // MySQL server
$rss_db="xxx"; // MySQL database
$rss_user="xxx"; // MySQL user
$rss_pass="xxx"; // MySQL password
// prefix for links, concatenated with their id
$item_link="http://ylovesporn.com/page.php?id=";
$channel_copyright="ylovesporn.com";
$channel_editor="ynuahayt@ylovesporn.com"; //Format: email_address OR email_address (name)
$channel_webmaster="ynuahayt@ylovesporn.com"; //Format: email_address OR email_address (name)
$image_title=""; // channel image or site logo
$image_url=""; // image URL [jpg, gif]
$image_link="";
$image_width=88;
$image_height=31;
$encoding="iso-8859-1";
include_once("rss20inc.php");
/**************************************************
Purpose: add all channels available with RSS script
Format for add_channel():
add_channel( Channel_Title, Channel_Link, Channel_Description, SQL_Command, RSS_ID )
Parameters:
- Channel_Title
- Channel_Link - URL of the site
- Channel_Description
- SQL_Command - SQL command used to get info
SQL SELECT fields: Title,Link,Description,Date,Author
- RSS_ID - unique ID of the RSS feed - leave empty for a single feed
***************************************************/
add_channel(
"ynuhayt Loves Free Porn",
"http://ylovesporn.com/",
"Last added links at http://ylovesporn.com/",
"SELECT items.name AS Title,
items.url AS Link,
items.descr AS Description,
FROM_UNIXTIME(items.ndate) AS Date,
FROM items INNER JOIN items ON
WHERE items.ref_id_categories='2'
ORDER BY items.ndate DESC LIMIT 10",
"");
header ("Content-type: text/xml");
rss(); // create RSS content
?>
I hope someone is able to come up with a solution! If you need more info please do tell me and thank you very much
