Google Feed Script for sunshop

				
//**************************************
// Name: Google Feed Script for sunshop
// Description:Mod for Sunshop 3.5 to feed data to Google base
// By: Maheshkarekar
//
// Inputs:http://www.yourdomain.com/sunshop/index.php?action=googlefeed
Live Example at http://www.mayoo.com
//
// Returns:Creates a data feed and ftps to uploads.google.com
//
// Assumes:Following files need modification index.php,global.php
//
//This code is copyrighted and has// limited warranties.Please see http://www.Planet-Source-Code.com/vb/scripts/ShowCode.asp?txtCodeId=2362&lngWId=8//for details.//**************************************

//Author Mahesh Kaekar
//Note: This is a Mod to Sunshop 3.5 
You need to modify a few files from sunshop folder
The way this works is we add a new action googlefeed to our index.php script
http://www.yourdomain.com/sunshop/index.php?action=googlefeed
1. Modify /sunshop/index.php - Add the following code after "elseif ($action == "item") {...}"
elseif ($action == "googlefeed") {
 	$show_categories = showcategories ();
		$navigation = "Google Feed";
		$feed = google_feed();
		eval("\$googlefeed_message = \"".$feed."\";");
		$main_content = stripslashes($googlefeed_message);
		start();
}
2. Modify /sunshop/global.php add Method googlerfeed()
Note ftp code I borrowed from som osccommerce website patch
// ###################### Google feed #######################
function google_feed(){
 global $DB_site, $dbprefix;
 $temp=$DB_site->query("Select title As Title,title As Description, substr(title,1,locate(' ',title)) as Brand,	'Used' As Condition,''	As ISBN,concat(concat('http://www.mayoo.com/sunshop/index.php?action=item&id=',itemid), '&prevaction=pricelist') As Link,'' Mpn,format(if(sprice=0,price,sprice),2) As Price,'Computers' Product_type,concat('US:Ground:',format(fship,2)) as Shipping,'' UPC,'Paypal' Payment_Accepted,if (length(thumb) >0,concat('http://www.mayoo.com/sunshop/images/products/',thumb),'') As Image_link FROM ".$dbprefix."items");	
	//Open file to write
	$filename = "mayoostoredb.txt";
	$tab = "\t";
	$cr = "\n";
	$data = "Title".$tab."Description".$tab."Brand".$tab."Condition".$tab."ISBN".$tab."Link".$tab."Mpn".$tab."Price".$tab."Product_type".$tab."Shipping".$tab."UPC".$tab."Payment_Accepted".$tab."image_link".$cr;
	$fp = fopen($filename,"w"); // $fp is now the file pointer to file $filename 
	if($fp){
	
	//Write headings 
	fwrite($fp,$data); 
	while ($row=$DB_site->fetch_array($temp)) {
		$title = $row[Title];
		$description = $row[Description];
		$brand=$row[Brand];
		$condition=$row[Condition];
		$isbn = $row[ISBN];
		$link = $row[Link];
		$mpn = $row[Mpn];
		$price = $row[Price];
		$product_type = $row[Product_type];
		$shipping = $row[Shipping];
		$upc = $row[UPC];
		$payment_accepted = $row[Payment_Accepted];
		$image_link=$row[Image_link];
		//Prepare data
		$data = $title.$tab.$description.$tab.$brand.$tab.$condition.$tab.$isbn.$tab.$link.$tab.$mpn.$tab.$price.$tab.$product_type.$tab.$shipping.$tab.$upc.$tab.$payment_accepted.$tab.$image_link.$cr;
		
		//write data 
		fwrite($fp,$data); 
		} //while
		//Close File
		fclose($fp);
	} //if
	//ftp file
	$ftp_ip= "uploads.google.com";
	$ftp_username = "yourftpid";
	$ftp_password = "yourpassword";
	$ftp_directory = "/";
	chmod($filename, 0777);
	// set up basic connection
	$conn_id = ftp_connect($ftp_ip);
	if ( $conn_id == false )
	{
	$out = "FTP open connection failed to $ftp_ip <BR>\n" ;
	return $out;
	}
	// login with username and password
	$login_result = ftp_login($conn_id, $ftp_username, $ftp_password);
	// check connection
	if ((!$conn_id) || (!$login_result)) {
	$out = "FTP connection has failed!<BR>\nAttempted to connect to " . $ftp_ip . " for user " . $ftp_username . "<BR>\n";
	return $out;
	} else {
	$out = "Connected to " . $ftp_ip . ", for user " . $ftp_username . "<BR>\n";
	}
	if ( strlen( $ftpdirectory ) > 0 )
	{
	if (ftp_chdir($conn_id, $ftp_directory )) {
	$out = $out . "Current directory is now: " . ftp_pwd($conn_id) . "<BR>\n";
	} else {
	$out = $out . "Couldn't change directory on" . $ftp_ip . "<BR>\n";
	return $out;
	}
	}
	ftp_pasv ( $conn_id, true ) ;
	// upload the file
	$upload = ftp_put( $conn_id, $filename, $filename, FTP_ASCII );
	// check upload status
	if (!$upload) {
	$out = $out . "$ftp_ip: FTP upload has failed!<BR>\n";
	return false;
	} else {
	$out = $out . "Uploaded " . $filename . " to " . $ftp_ip . " as " . $filename . "<BR>\n";
	chmod($filename, 0755);
	}
	
	
	return $out;
}
3. Now type the sunshop index url with actin=googlefeed in your browser
http://wwww.yourdomain.com/sunshop/index.php?action=googlefeed
Thanks
Mahesh Karekar 
MaheshKarekar@yahoo.com