Greenguy's Board

Greenguy's Board (http://www.greenguysboard.com/board/index.php)
-   Programming & Scripting (http://www.greenguysboard.com/board/forumdisplay.php?f=15)
-   -   RSS Feed generating: php & MySQL problems (http://www.greenguysboard.com/board/showthread.php?t=21934)

ynuahayt 2005-07-13 07:59 AM

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:

/*****************************************************

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 :)

ynuahayt 2005-07-14 09:03 AM

Issue has been resolved - move along nothing to see here!

wankmaster 2005-07-16 06:11 PM

awww ;-( I was getting all excited about being able to spot the bug


All times are GMT -4. The time now is 11:27 AM.

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