|
|
|
|
|
|
|
|
|
#1 |
|
My wife is not a doobie to be passed around! On our wedding day I promised to bogart her for life!
Join Date: Jan 2005
Posts: 274
|
RSS Feed generating: php & MySQL problems
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
?>
![]()
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com |
|
|
|
|
|
#2 |
|
My wife is not a doobie to be passed around! On our wedding day I promised to bogart her for life!
Join Date: Jan 2005
Posts: 274
|
Issue has been resolved - move along nothing to see here!
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com |
|
|
|
|
|
#3 |
|
Just because I don't care doesn't mean I don't understand!
Join Date: May 2005
Posts: 96
|
awww ;-( I was getting all excited about being able to spot the bug
|
|
|
|
![]() |
|
|