[MOD] RSS Feed 0.1

[artpics]

before when i used this code in any html template

Code: [Select]

<?php
                    echo date("d.m.Y, H:i");
        ?>
it showed the date time on each page, now since i have added this mod  the time is not shown anymore,when it used to work any ideas

thanks
RT

[mawenzi]

@ V@no ...

the query, you posted here, don't show only the images in RSS-Feed which only guests can see on the website ... it shows further all images ... is there another solution ... ?

mawenzi

[Vincent]

i need help i can't get the thumb to show up - the description on the beginn of the site was to confusing me!
could somebody nice and clear writing down - what to do to have the thumbs added?

is it also possible to have the keywords added?

thanks for support
vincent

[Vincent]

http://www.foto-kocher.com/rss.php

--------------------------
Ok es geht jetzt so wie ich es will mit dem Thumb!
aber ist es noch möglich das Verzeichniss einzufügen und die Keywords des Bildes?
--------------------------
OK it works with a thumb picture
but it is also possible to add the categorie next to the picture and also the Keywords?
--------------------------
Sincerly
gruss
Vincent

[Vincent]

is it possible to do a RSS Feed from just a couple of categories,
or is it possible that the user register and could  define which categorie he would get a feed!

sincerly
vincent

[mawenzi]

... du kannst ja pro Kategorie ein RSS-Feed anlegen (natürlich auch einen für die gesamte Galerie) ... und der geneigte User kann sich dann den ihn entsprechenden Feed aussuchen bzw. von der jeweiligen Kategorieseite laden ... möglich wäre auch den RSS-Feed-Kategorie-Download (Mini-Button) immer jeweils mit der category_bit.html anzuzeigen ...

[Vincent]

i was trying to add a table structure but i could not find out which html file i had to do something!
i mean when i added a table nothing happen and i could not see any change!

any idee where to add this?

sincerly
vincent

[mawenzi]

in rss.php ...

Code: [Select]

...
$content .= " <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\"><tr><td>";
...
$content .= " </td><td></table>";
...

mawenzi

[Vincent]

still hoping getting support for doing a Rss feed from a selected categorie and his Subcategorie!

sincerly
vincent

[mawenzi]

Hallo Vincent,

habe gerade dieses gelesen und ich denke, es ist auch der Lösungsansatz für deine Anfrage.

RSS-Feed für bestimmte / einzelne Kategorien :

1. mach eine Kopie von deiner aktuellen rss.php und benenne sie nach den betreffenden Kategorien um z.B. rss_1-2-3.php
2. Verwende folgende Datenbankabfrage (d.h. ersetzen) in der rss_1-2-3.php:

Code: [Select]

$cat_in = array(1,2,3); // Hier id-Liste der anzuzeigenden Kategorien!

$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, i.image_thumb_file, i.image_media_file, c.cat_name, u.user_name
        FROM ".IMAGES_TABLE." i
        LEFT JOIN ".CATEGORIES_TABLE." c ON (c.cat_id = i.cat_id)
        LEFT JOIN ".USERS_TABLE." u ON (u.user_id = i.user_id)
        WHERE i.image_active = 1 AND i.cat_id NOT IN ($cat_id_sql) AND c.cat_id = i.cat_id AND i.cat_id IN (".implode(", ", $cat_in).")
        ORDER BY i.image_date DESC
        LIMIT $num_new_images";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
3. Nun kannst du in der betreffenden Kategorie den Link ( z.B. auch mit RSS-Feed-Button ) als Kategorie-RSS-Feed anbieten.
4. Du kannst natürlich auch auf deiner RSS-Seite eine Liste / Tabelle mit den jeweiligen RSS-Feeds anbieten, so dass der User hier auswählen kann.

Hinweis :
Subkategorien werden nicht automatisch mitangezeigt, wenn die übergeordnete Kategorie in der Liste steht. D.h. alle gewünschten Kategorien müssen in der id-Liste aufgeführt werden.

Hab es getestet und ich denke es wäre der erste Schritt bezogen auf deine Wunschliste ... 

mawenzi

[lovetamil]

hello...i am gettin this error..please help

End tag 'head' does not match the start tag 'link'. Error processing resource 'http://www.tamilsoulja.com/gallery/rss.php'. Line 8, Position 3
 

</head>
--^

and this is my rss.php

/*************************************************
 * RSS Feed for 4images                          *
 * beta 0.1                                      *
 * Email:
 */

//------------ CONFIG ----------------------------

$num_new_images = 10;
/*
 u can uncomment this, if you want to use config variables from 4images config
 $num_new_images = $config['image_cells'];
*/

//because we have no session here, we have to hardcode this values
define('SCRIPT_URL', 'http://www.tamilsoulja.com/gallery'); //no trailing slash
define('LANGUAGE', 'DE');

define('ROOT_PATH', './');

//----- END CONFIG--------------------------------------------

include(ROOT_PATH.'global.php');
$main_template = 'rss';



$sql = "SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, c.cat_name
        FROM ".IMAGES_TABLE." i,  ".CATEGORIES_TABLE." c
        WHERE i.image_active = 1 AND c.cat_id = i.cat_id
        ORDER BY i.image_date DESC
        LIMIT $num_new_images";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
$format="Y-m-d\TH:i:s+00:00"; //the time format for rss date
while($image_row = $site_db->fetch_array($result)){
  $site_template->register_vars(array(
                  "title" => $image_row["image_name"],             
                  "description" => $image_row["image_description"],
                  "category_domain" => SCRIPT_URL."/categories.php?cat_id=".$image_row["cat_id"],
                  "category" => $image_row["cat_name"],
                  "link" => SCRIPT_URL."/details.php?image_id=".$image_row["image_id"],
                  "date" => format_date($format,$image_row["image_date"]),
                  ));
  $new_images.=$site_template->parse_template("rssitem");
 }

//-----------------------------------------------------
//--- Print Out ---------------------------------------
//-----------------------------------------------------
$site_template->register_vars(
               array(
                "ctitle" => $config['site_name'],
                "clink" => SCRIPT_URL,
                "cdescription" => $config['site_name']." RSS Feed",
                "language" =>LANGUAGE,
                "ititle" =>"",               
                "iurl" => SCRIPT_URL."/".TEMPLATE_PATH."/images/header_logo.gif",
                "ilink" => SCRIPT_URL,
                "items" => $new_images,             
                )
               );
header("Content-type: text/xml");
$site_template->print_template('<?xml version="1.0" encoding="ISO-8859-1"?>'.$site_template->parse_template($main_template));;
?>

[V@no]

probably something wrong with your template or some text that being included in the feed contains < or > characters.

[sigma]

Couldnt find this in teh previous posts. Maybe I didnt search well enough.

Im trying to include my news mod and also updates to certain categories. These category updates would have new images but the dates would be from months ago. Any way of adding either of these to the Feed?

[a4land]

Could you show me the final edition of this MOD ?

I've just downloaded it from the 1st page , and installed it . It works but without showing thumbnails , I tried to use the Feedreader v2.9 to view rss.php but the thumbnails still didn't appear . What should I do now ?

[takgallery]

please help on this error

XML Parsing Error: junk after document element
Location: http://takgallery.com/rss.php
Line Number 1, Column 7:<br /><font color='#FF0000'><b>DB Error</b></font>: <b>Bad SQL Query</b>: SELECT i.image_id, i.cat_id, i.user_id, i.image_name, i.image_description, i.image_keywords, i.image_date, i.image_active, c.cat_name
------^


i tried everything but no way
please help and take a look at this error :
http://takgallery.com/rss.php