Greenguy's Board


Go Back   Greenguy's Board > Programming & Scripting
Register FAQ Calendar Today's Posts

Reply
 
Thread Tools Search this Thread Rate Thread Display Modes
Old 2005-07-13, 07:59 AM   #1
ynuahayt
My wife is not a doobie to be passed around! On our wedding day I promised to bogart her for life!
 
ynuahayt's Avatar
 
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

?>
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
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com
ynuahayt is offline   Reply With Quote
Old 2005-07-14, 09:03 AM   #2
ynuahayt
My wife is not a doobie to be passed around! On our wedding day I promised to bogart her for life!
 
ynuahayt's Avatar
 
Join Date: Jan 2005
Posts: 274
Issue has been resolved - move along nothing to see here!
__________________
Free Blog/Free Site Traffic @ yLovesPorn.com
ynuahayt is offline   Reply With Quote
Old 2005-07-16, 06:11 PM   #3
wankmaster
Just because I don't care doesn't mean I don't understand!
 
wankmaster's Avatar
 
Join Date: May 2005
Posts: 96
awww ;-( I was getting all excited about being able to spot the bug
wankmaster is offline   Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 11:33 PM.


Mark Read
Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
© Greenguy Marketing Inc