Froogle data feeder will not feed

[price351]

I have installed the froogle data feeder, but I cannot get froogle.php to feed(populate) the actual froogle_data_file.txt

 

The file is here http://www.ps2repairs.co.uk/feeds/price351_hotmail_com.txt but I cannot populate it.

 

I thought the problem may be with this line

 

http://www.ps2repairs.co.uk/catalog/produc...oducts_id='

 

within froogle.php

 

Should it be like this ?

 

http://www.ps2repairs.co.uk/catalog/produc...&products_id=73

 

I have tried and checked everything I can think of, any ideas would be greatly apperciated.

 

My froogle.php file

 

<?php

// Title: Froogle Data Feeder 1.62

// Author: Calvin K

// Contact: [email protected]

// Organization: Conceptual Networking

// Last Update: 12/21/05

 

//

// This feeder has been revised to work with Ultimate SEO URLs 2.1d (http://www.oscommerce.com/community/contributions,2823)

//

 

// Change to 'false' to disable the use of SEO

define('SEO_ENABLED','false');

 

if(SEO_ENABLED=='true'){

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

// Modification for SEO

// Since the ultimate SEO was only installed on the public side, we will include our files from there.

require_once('../includes/configure.php');

require_once('../includes/filenames.php');

require_once('../includes/database_tables.php');

$languages_id = 1; // CHANGEME - Change this to the id of your language. BY default 1 is english

 

 

include_once('../' .DIR_WS_CLASSES . 'seo.class.php');

$seo_urls = new SEO_URL($languages_id);

 

function tep_href_link($page = '', $parameters = '', $connection = 'NONSSL', $add_session_id = true, $search_engine_safe = true) {

global $seo_urls;

return $seo_urls->href_link($page, $parameters, $connection, $add_session_id);

}

}

 

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

 

// Start TIMER

// -----------

$stimer = explode( ' ', microtime() );

$stimer = $stimer[1] + $stimer[0];

// -----------

 

 

$OutFile = "http://www.ps2repairs.co.uk/feeds/price351_hotmail_com.txt"; //"CHANGEME-full-path-to-file-with-777-dir-and-file-permissions.fr-outfile.txt";

$destination_file = "price351_hotmail_com.txt"; //"CHANGEME-filename-to-upload-to-froogle.txt" ;

$source_file = $OutFile;

$imageURL = 'http://www.ps2repairs.co.uk/catalog/images';

if(SEO_ENABLED=='true'){

$productURL = 'product_info.php'; // ***** Revised for SEO

$productParam = "products_id="; // ***** Added for SEO

}else{

$productURL = 'https://www.ps2repairs.co.uk/catalog/product_info.php?products_id=';

}

 

$already_sent = array();

 

if(SEO_ENABLED=='true'){

$home = DB_SERVER; // ****** revised these because we can....

$user=DB_SERVER_USERNAME;

$pass=DB_SERVER_PASSWORD;

$base=DB_DATABASE;

}else{

$home = "db236.oneandone.co.uk" ;

$user="user";

$pass="password";

$base="db89760055";

}

 

$ftp_server = "hedwig.google.com" ;

$ftp_user_name = "user";

$ftp_user_pass = "password";

$ftp_directory = ""; // leave blank for froogle

 

$taxRate = 17.5; //default = 0 (e.g. for 17.5% tax use "$taxRate = 17.5;")

$taxCalc = ($taxRate/100) + 1; //Do not edit

$convertCur = false; //default = false

$curType = "GBP"; // Converts Currency to any defined currency (eg. USD, EUR, GBP)

if($convertCur)

{

if(SEO_ENABLED=='true'){

$productParam="currency=" . $curType . "&products_id=";

}else{

$productURL = "http://www.ps2repairs.co.uk/catalog/product_info.php?currency=" . $curType . "&products_id="; //where CURTYPE is your currency type (eg. USD, EUR, GBP)

}

}

 

//START Advance Optional Values

 

//(0=False 1=True) (optional_sec must be enabled to use any options)

$optional_sec = 0;

$instock = 0;

$shipping = 0;

$lowestShipping = "4.95"; //this is not binary.

$brand = 0;

$upc = 0; //Not supported by default osC

$manufacturer_id = 0; //Not supported by default osC

$product_type = 0;

$currency = 0;

$default_currency = "USD"; //this is not binary.

$feed_language = 0;

$default_feed_language = "en"; //this is not binary.

$ship_to = 0;

$default_ship_to = "ALL"; //this is not binary, not supported by default osC for individual products.

$ship_from = 0;

$default_ship_from = "USD"; //this is not binary, not supported by default osC for individual products.

 

//END of Advance Optional Values

 

if (!($link=mysql_connect($home,$user,$pass)))

{

echo "Error when connecting itself to the data base";

exit();

}

if (!mysql_select_db( $base , $link ))

{

echo "Error the data base does not exist";

exit();

}

 

$sql = "

SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,

products_model AS prodModel, products_weight,

manufacturers.manufacturers_name AS mfgName,

manufacturers.manufacturers_id,

products.products_id AS id,

products_description.products_name AS name,

products_description.products_description AS description,

products.products_quantity AS quantity,

products.products_status AS prodStatus,

FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price,

CONCAT( '" . $imageURL . "' ,products.products_image) AS image_url,

products_to_categories.categories_id AS prodCatID,

categories.parent_id AS catParentID,

categories_description.categories_name AS catName

FROM categories,

categories_description,

products,

products_description,

products_to_categories

 

left join manufacturers on ( manufacturers.manufacturers_id = products.manufacturers_id )

left join specials on ( specials.products_id = products.products_id AND ( ( (specials.expires_date > CURRENT_DATE) OR (specials.expires_date = 0) ) AND ( specials.status = 1 ) ) )

 

WHERE products.products_id=products_description.products_id

AND products.products_id=products_to_categories.products_id

AND products_to_categories.categories_id=categories.categories_id

AND categories.categories_id=categories_description.categories_id

ORDER BY

products.products_id ASC

";

 

 

$catInfo = "

SELECT

categories.categories_id AS curCatID,

categories.parent_id AS parentCatID,

categories_description.categories_name AS catName

FROM

categories,

categories_description

WHERE categories.categories_id = categories_description.categories_id

";

 

function findCat($curID, $catTempPar, $catTempDes, $catIndex)

{

if( (isset($catTempPar[$curID])) && ($catTempPar[$curID] != 0) )

{

if(isset($catIndex[$catTempPar[$curID]]))

{

$temp=$catIndex[$catTempPar[$curID]];

}

else

{

$catIndex = findCat($catTempPar[$curID], $catTempPar, $catTempDes, $catIndex);

$temp = $catIndex[$catTempPar[$curID]];

}

}

if( (isset($catTempPar[$curID])) && (isset($catTempDes[$curID])) && ($catTempPar[$curID] == 0) )

{

$catIndex[$curID] = $catTempDes[$curID];

}

else

{

$catIndex[$curID] = $temp . " > " . $catTempDes[$curID];

}

return $catIndex;

 

}

 

$catIndex = array();

$catTempDes = array();

$catTempPar = array();

$processCat = mysql_query( $catInfo )or die( $FunctionName . ": SQL error " . mysql_error() . "| catInfo = " . htmlentities($catInfo) );

while ( $catRow = mysql_fetch_object( $processCat ) )

{

$catKey = $catRow->curCatID;

$catName = $catRow->catName;

$catParID = $catRow->parentCatID;

if($catName != "")

{

$catTempDes[$catKey]=$catName;

$catTempPar[$catKey]=$catParID;

}

}

 

foreach($catTempDes as $curID=>$des) //don't need the $des

{

$catIndex = findCat($curID, $catTempPar, $catTempDes, $catIndex);

}

 

$_strip_search = array(

"![\t ]+$|^[\t ]+!m", // remove leading/trailing space chars

'%[\r\n]+%m'); // remove CRs and newlines

$_strip_replace = array(

'',

' ');

$_cleaner_array = array(">" => "> ", "?" => "", "?" => "", "?" => "", "?" => "", "\t" => "", " " => "");

 

if ( file_exists( $OutFile ) )

unlink( $OutFile );

 

$output = "product_url \t name \t description \t price \t image_url \t category \t offer_id";

 

//create optional section

if($optional_sec == 1)

{

if($instock == 1)

$output .= "\t instock ";

if($shipping == 1)

$output .= "\t shipping ";

if($brand == 1)

$output .= "\t brand ";

if($upc == 1)

$output .= "\t upc ";

if($manufacturer_id == 1)

$output .= "\t manufacturer_id ";

if($product_type == 1)

$output .= "\t product_type ";

if($currency == 1)

$output .= "\t currency ";

if($feed_language == 1)

$output .= "\t language ";

if($ship_to == 1)

$output .= "\t ship_to ";

if($ship_from == 1)

$output .= "\t ship_from ";

}

$output .= "\n";

 

 

$result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) );

 

//Currency Information

if($convertCur)

{

$sql3 = "

SELECT

currencies.value AS curUSD

FROM

currencies

WHERE currencies.code = '$curType'

";

 

$result3=mysql_query( $sql3 )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql3 = " . htmlentities($sql3) );

$row3 = mysql_fetch_object( $result3 );

}

 

$loop_counter = 0;

 

while( $row = mysql_fetch_object( $result ) )

{

if (isset($already_sent[$row->id])) continue; // if we've sent this one, skip the rest of the while loop

 

if( $row->prodStatus == 1 || ($optional_sec == 1 && $instock == 1) )

{

 

if($convertCur)

{

$row->price = ereg_replace("[^.0-9]", "", $row->price);

$row->price = $row->price * $row3->curUSD;

$row->price = number_format($row->price, 2, '.', ',');

}

 

if(SEO_ENABLED=='true'){

$output .= tep_href_link($productURL,$productParam . $row->id) . "\t" .

preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" .

preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" .

$row->price . "\t" .

$row->image_url . "\t" .

$catIndex[$row->prodCatID] . "\t" .

$row->id;

}else{

$output .= $row->product_url . "\t" .

preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->name, $_cleaner_array) ) ) . "\t" .

preg_replace($_strip_search, $_strip_replace, strip_tags( strtr($row->description, $_cleaner_array) ) ) . "\t" .

$row->price . "\t" .

$row->image_url . "\t" .

$catIndex[$row->prodCatID] . "\t" .

$row->id;

}

 

//optional values section

if($optional_sec == 1)

{

if($instock == 1)

{

if($row->prodStatus == 1)

{

$prodStatusOut = "Y";

}

else

{

$prodStatusOut = "N";

}

$output .= " \t " . $prodStatusOut;

}

if($shipping == 1)

$output .= " \t " . $lowestShipping;

if($brand == 1)

$output .= " \t " . $row->mfgName;

if($upc == 1)

$output .= " \t " . "Not Supported";

if($manufacturer_id == 1)

$output .= " \t " . "Not Supported";

if($product_type == 1)

{

$catNameTemp = strtolower($catName);

if($catNameTemp == "books")

$productTypeOut = "book";

else if($catNameTemp == "music")

$productTypeOut = "music";

else if($catNameTemp == "videos")

$productTypeOut = "video";

else

$productTypeOut = "other";

 

$output .= " \t " . $productTypeOut;

}

if($currency == 1)

$output .= " \t " . $default_currency;

if($feed_language == 1)

$output .= " \t " . $default_feed_language;

if($ship_to == 1)

$output .= " \t " . $default_ship_to;

if($ship_from == 1)

$output .= " \t " . $default_ship_from;

}

$output .= " \n";

}

$already_sent[$row->id] = 1;

 

 

$loop_counter++;

if ($loop_counter>750) {

$fp = fopen( $OutFile , "a" );

$fout = fwrite( $fp , $output );

fclose( $fp );

$loop_counter = 0;

$output = "";

}

}

 

$fp = fopen( $OutFile , "a" );

$fout = fwrite( $fp , $output );

fclose( $fp );

echo "File completed: <a href=\"" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a><br>\n";

chmod($OutFile, 0777);

 

/*

//Start FTP to Froogle

 

function ftp_file( $ftpservername, $ftpusername, $ftppassword, $ftpsourcefile, $ftpdirectory, $ftpdestinationfile )

{

// set up basic connection

$conn_id = ftp_connect($ftpservername);

if ( $conn_id == false )

{

echo "FTP open connection failed to $ftpservername <BR>\n" ;

return false;

}

 

// login with username and password

$login_result = ftp_login($conn_id, $ftpusername, $ftppassword);

 

// check connection

if ((!$conn_id) || (!$login_result)) {

echo "FTP connection has failed!<BR>\n";

echo "Attempted to connect to " . $ftpservername . " for user " . $ftpusername . "<BR>\n";

return false;

} else {

echo "Connected to " . $ftpservername . ", for user " . $ftpusername . "<BR>\n";

}

 

if ( strlen( $ftpdirectory ) > 0 )

{

if (ftp_chdir($conn_id, $ftpdirectory )) {

echo "Current directory is now: " . ftp_pwd($conn_id) . "<BR>\n";

} else {

echo "Couldn't change directory on $ftpservername<BR>\n";

return false;

}

}

 

ftp_pasv ( $conn_id, true ) ;

// upload the file

$upload = ftp_put( $conn_id, $ftpdestinationfile, $ftpsourcefile, FTP_ASCII );

 

// check upload status

if (!$upload) {

echo "$ftpservername: FTP upload has failed!<BR>\n";

return false;

} else {

echo "Uploaded " . $ftpsourcefile . " to " . $ftpservername . " as " . $ftpdestinationfile . "<BR>\n";

}

 

// close the FTP stream

ftp_close($conn_id);

 

return true;

}

 

ftp_file( $ftp_server, $ftp_user_name, $ftp_user_pass, $source_file, $ftp_directory, $destination_file);

 

//End FTP to Froogle

*/

 

// End TIMER

// ---------

$etimer = explode( ' ', microtime() );

$etimer = $etimer[1] + $etimer[0];

echo '<p style="margin:auto; text-align:center">';

printf( "Script timer: <b>%f</b> seconds.", ($etimer-$stimer) );

echo '</p>';

// ---------

 

?>

http://www.ps2repairs.co.uk/feeds/price351_hotmail_com.txt