I read the other articles already for the oodle-external.php file I still can not get it to work for my clients feeds. I am getting "Listing element <listing> not found in feed." from oodle when i test the feed...any suggestions?
Here is the code:
PHP Code:
<?php
require_once('includes/init.php');
/*
* Only change this if you are sure your content encoding is not utf-8
*/
$oodle_content_encoding = "utf-8";
/*
* Only use this require if you want to keep any of the following options
* in some other file (other than init.php, which is already included)
* as per following comments. Change the path to whatever file you are using.
*
* require_once(FILESYSTEM_PATH .'includes/my_site_init.php');
*/
/*
* Custom fields you don't want included on the Oodle feeds.
* Use "processed" format (so "Some Field" becomes "some_field")
* Example:
* $oodle_skip_fields = array(
* 'your_birthday',
* 'some_unwanted_field',
* 'another_unwanted_field'
* );
*
* NOTE - if you want, you can leave this one alone, and use one called
* $init_oodle_skip_fields you define elsewhere (probably in init.php or
* somewhere similar) if you are trying to keep all your mod's init code
* in one place.
*/
global $init_oodle_skip_fields;
$oodle_skip_fields = array(
);
if (is_array($init_oodle_skip_fields))
{
$oodle_skip_fields = array_merge($oodle_skip_fields,$init_oodle_skip_fields);
}
/*
* Custom field names you want to substitute on Oodle feeds. For instance you
* may need to change "Pet Gender" to "Sex".
* Use "processed" format (so "Pet Gender" becomes "pet_gender")
* Example:
* $oodle_field_subs = array(
* 'pet_gender' => 'sex',
* 'another_field' => 'some_other_oodle_field'
* );
*
* NOTE - if you want, you can leave this one alone, and use one called
* $init_oodle_field_subs you define elsewhere (probably in init.php or
* somewhere similar) if you are trying to keep all your mod's init code
* in one place.
*/
global $init_oodle_field_subs;
$oodle_field_subs = array(
);
if (is_array($init_oodle_field_subs))
{
$oodle_field_subs = array_merge($oodle_field_subs,$init_oodle_field_subs);
}
/*
* Category names you want to change when you feed them to Oodle.
* Example:
* $oodle_cat_subs = array(
* 'Shelter Dogs' => 'Dogs',
* 'Shelter Cats' => 'Cats'
* );
*
* NOTE - if you want, you can leave this one alone, and use one called
* $init_oodle_cat_subs you define elsewhere (probably in init.php or
* somewhere similar) if you are trying to keep all your mod's init code
* in one place.
*/
global $init_oodle_cat_subs;
$oodle_cat_subs = array(
);
if (is_array($init_oodle_cat_subs))
{
$oodle_cat_subs = array_merge($oodle_cat_subs,$init_oodle_cat_subs);
}
/*
* NO USER SERVICEABLE PARTS BEYOND THIS POINT!!
*/
// Set up the main product feed query. Joins user, category, custom field
// and image data.
$sSQL= "
SELECT
p.id, p.owner, p.title, p.featured, p.section, p.description, p.shortDescription,
p.price, p.dateadded, p.expiration, p.pBold, p.pHighlighted,
u.state, u.city, u.country, u.username,
c.name AS catname, c.id as catid,
pf.lfValue as fieldvalue,
f.fName as fieldname,
i.image as image
FROM ".PREFIX."listings AS p
LEFT JOIN " . PREFIX . "users AS u ON p.owner = u.id
LEFT JOIN " . PREFIX . "categories AS c ON c.id = p.section
LEFT JOIN " . PREFIX . "listingsfields AS pf ON pf.lfID = p.id
LEFT JOIN " . PREFIX . "fields AS f ON f.fID = pf.lfID
LEFT JOIN " . PREFIX . "prodimages AS i ON i.pid = p.id
WHERE p.expiration > NOW()
AND p.display = 'Y'
";
// see if we have any specific category id(s), which can be a single id or a
// comma separated list
if (isset($_REQUEST['categoryid'])&& $_REQUEST['categoryid']<>"")
{
// if any catid's are specified, grab the complete tree of id's
// for the where clause.
$categoryid = $_REQUEST['categoryid'];
$arr_childs = explode(',',$categoryid);
get_ids($arr_childs);
$sSQL .= " AND p.section IN (". implode(', ', $arr_childs) .")";
}
// Order by date added
$sSQL .= " ORDER BY p.dateadded DESC";
// is there a limit? Default is all items, no limit
if(isset($_GET['limit']) && $_GET['limit']<>"")
{
$sSQL .= " LIMIT ". (int)$_GET['limit'];
}
// build array of listings
$ads = array();
$result = $db->query($sSQL);
while ($rs=$result->fetch())
{
// because we are using left joins on many-to-one tables (like custom fields and images)
// we will have duplicate rows for each id. We only want to grab the basic row
// if we don't already have it.
if (!$ads[$rs['id']])
{
$ads[$rs['id']] = $rs;
}
// if a custom fieldname and value are specified, add them to an array
// for this item
if ($rs['fieldname'] and $rs['fieldvalue'])
{
if (!$ads[$rs['id']]['fields'][$rs['fieldname']])
{
$ads[$rs['id']]['fields'][$rs['fieldname']] = $rs['fieldvalue'];
}
}
// if an image is specified, use the first one we see as the image for this item
// and just ignore any subsequent images for the item
if ($rs['image'])
{
if (!$ads[$rs['id']]['image'])
{
$ads[$rs['id']]['image'] = $rs['image'];
}
}
}
// set XML type and nocache headers
header('Content-Type: text/xml');
header('Expires: ' . gmdate('D, d M Y H:i:s') . ' GMT');
header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
header('Pragma: public');
// print out the page header
echo "<?xml version=\"1.0\" encoding=\"$oodle_content_encoding\"?>\r\n";
echo "<listings>\r\n";
// time to build the actual XML list of items
if (!empty($ads))
{
foreach ($ads AS $listing)
{
// do any cat name substitutions
if ($oodle_cat_subs[$listing['catname']])
{
$listing['catname'] = $oodle_cat_subs[$listing['catname']];
}
// conacatenate the short and long descriptions
if ($listing['shortDescription'])
{
$listing['description'] = $listing['shortDescription'] . "\n\n" . $listing['description'];
}
// sanitize text fields
$listing['title'] = htmlspecialchars($listing['title']);
$listing['catname'] = htmlspecialchars($listing['catname']);
$listing['description'] = htmlspecialchars($listing['description']);
$listing['image_url'] = $listing['image'] ? URL . "/thumbs/small_" . $listing['image'] : "";
// output the basic information common to all entries
echo "\t<listing>\r\n";
echo "\t\t<category>" . $listing['catname'] . "</category>\r\n";
echo "\t\t<id>" . $listing['id'] . "</id>\r\n";
echo "\t\t<title>" . $listing['title'] . "</title>\r\n";
echo "\t\t<description>" . $listing['description'] . "</description>\r\n";
echo "\t\t<price>" . $listing['price'] . "</price>\r\n";
echo "\t\t<currency>USD</currency>\r\n";
echo "\t\t<url>". URL ."/viewlisting.php?view=".$listing['id']."</url>\r\n";
echo "\t\t<image_url>". $listing['image_url'] ."</image_url>\r\n";
// now grab and output any custom fields
if (is_array($listing['fields']))
{
foreach ($listing['fields'] as $fieldname => $fieldvalue)
{
$fieldname = htmlspecialchars(preg_replace('# #','_',strtolower($fieldname)));
// skip it if it's in the ignore list
if (in_array($fieldname,$oodle_skip_fields))
{
continue;
}
// make any custom fieldname substitutions
if (in_array($fieldname,$oodle_field_subs))
{
$fieldname = $oodle_field_subs[$fieldname];
}
$fieldvalue = htmlspecialchars($fieldvalue);
echo "\t\t<$fieldname>$fieldvalue</$fieldname>\r\n";
}
}
echo "\t</listing>\r\n";
}
}
//close the feed
echo "</listings>\r\n";
// Hey, we're done! Cool!!
?>
02-19-2010, 01:20 AM
Oodle for 68classifieds v4
Similar Threads
Linear Mode
