$heightart)
$orientation = "Landscape";
else if ($heightart > $widthart)
$orientation = "Portrait";
else if($widthart == $heightart)
$orientation = "Square";
}
$colors=array();
$query4 = "SELECT * FROM `color_match2` WHERE `partno`='". $catalogSK ."' AND `color_count` > 25 ORDER BY `color_count` DESC LIMIT 16";
$result4 = mysql_query($query4) or die("Couldn't add row 1");
while($row_color = mysql_fetch_array($result4))
{
//ECHO "INSIDE";
$colors[] = $row_color['color_code'];
}
$color_list = implode("||",$colors);
$color_list = trim($color_list);
//echo $color_tabs . "
";
$icon = "http://www.overstockart.net/search/images/spacer.gif";
$query2 = "SELECT * FROM `backorders` WHERE `itemCode` = '$catalogSK' LIMIT 1;";
//echo $query2;
$result2 = mysql_query($query2);
//echo $art_id . " number of rows: " . mysql_num_rows($result3) . "
";
if(mysql_num_rows($result2) > 0)
{
$icon = "http://www.overstockart.net/search/images/preorder.jpg";
$instock = "On Pre-Order";
//echo "mark: " . $icon ;
}
else
{
$query2 = "SELECT * FROM `backorderframes` WHERE `itemCode` = '$catalogSK' LIMIT 1;";
//echo $query2;
$result2 = mysql_query($query2);
//echo $art_id . " number of rows: " . mysql_num_rows($result3) . "
";
if(mysql_num_rows($result2) > 0)
{
$icon = "http://www.overstockart.net/search/images/preorder.jpg";
$instock = "Frame on Backorder";
//echo "mark: " . $icon ;
}
else
{
$query1 = "SELECT * FROM `bestsellers` WHERE `itemCode` = '$catalogSK' LIMIT 1;";
//echo $query3;
$result1 = mysql_query($query1);
//echo $art_id . " number of rows: " . mysql_num_rows($result3) . "
";
if(mysql_num_rows($result1) > 0)
{
$icon = "http://www.overstockart.net/search/images/bestseller.jpg";
//echo "mark: " . $icon ;
}
else
{
$query4 = "SELECT * FROM `newarrivals` WHERE `itemCode` = '$catalogSK' LIMIT 1;";
//echo $query4;
$result4 = mysql_query($query4);
if(mysql_num_rows($result4) > 0)
{
$icon = "http://www.overstockart.net/search/images/newarrival.jpg";
}
else
{
$query5 = "SELECT * FROM `closeouts` WHERE `itemCode` = '$catalogSK' LIMIT 1;";
$result5 = mysql_query($query5);
if(mysql_num_rows($result5) > 0)
{
$icon = "http://www.overstockart.net/search/images/closeout.jpg";
}
else
{
$query6 = "SELECT * FROM `hotdeals` WHERE `itemCode` = '$catalogSK' LIMIT 1;";
//echo $query6;
$result6 = mysql_query($query6);
if(mysql_num_rows($result6) > 0)
{
$icon = "http://www.overstockart.net/search/images/hotdeals.jpg";
}
}
}
}
}
}
$line = stripslashes($headline) . " " . $suggested . " " . $fullprice . " " . $catalogSK . " " . $artist . " " . $subject . " " . $style . " " . $salePrice . " " . $artist_link . " " . $framing . " " . $yahooID . " " . $link . " " . stripslashes($caption) . " " . $salePrice . " " . $description . " " . $fileName . " " . $categoryDefault . " " . $artsize . " " . $icon . " " . $color_list . " " . $orientation . " " . $instock . "\n";
//start line for excell output.
//echo "the color list: " . $color_list . "
";
$data .= $line ;
}
//print $header . $data;
$document = $header . $data;
//echo $document;
$document = trim($document);
//creating the file on the server
$fh = fopen("feeds/nextopiafeed.txt", "w");
fwrite($fh, $document);
$file = 'feeds/nextopiafeed.txt';
$remote_file = 'nextopiafeed.txt';
fclose($fh);
/***
// set up basic connection to search on overstockart.com
$ftp_server = 'ftp.overstockart.com';
$ftp_user_name = 'search@overstockart.com';
$ftp_user_pass = 'search1234';
$conn_id = ftp_connect($ftp_server);
// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);
// turn passive mode OFF
//ftp_pasv($conn_id, FALSE);
// upload a file
if (ftp_put($conn_id, $remote_file, $file, FTP_ASCII)) {
echo "successfully uploaded $file\n";
$Body = "successfully uploaded search products " . $file;
// $email = "asasson@overstockart.com";
// $subject = "cron job running... nextopia...";
// cron_mail($email, $subject, $Body);
} else {
echo "There was a problem while uploading $file\n";
$Body = "problem while uploading nextopia " . $file;
$email = "asasson@overstockart.com";
$subject = "problem while uploading nextopia...";
cron_mail($email, $subject, $Body);
}
// close the connection
ftp_close($conn_id);
****/
// set up basic connection search on overstockart.com
/****
$ftp_server = 'ftp.overstockart.com';
$ftp_user_name = 'catalogcity@overstockart.com';
$ftp_user_pass = 'ninanina';
$conn_id = ftp_connect($ftp_server);
// login with username and password
$login_result = ftp_login($conn_id, $ftp_user_name, $ftp_user_pass);
$file_cat = 'feeds/catalogcity.txt';
$remote_file_cat = 'catalogcity.txt';
// turn passive mode OFF
//ftp_pasv($conn_id, FALSE);
// upload a file
if (ftp_put($conn_id, $remote_file_cat, $file_cat, FTP_ASCII)) {
echo "successfully uploaded $file_cat\n";
$Body = "successfully uploaded catalogcity products " . $file_cat;
$email = "asasson@overstockart.com";
$subject = "cron job running... catalogcity feed...";
cron_mail($email, $subject, $Body);
} else {
echo "There was a problem while uploading $file_cat\n";
$Body = "problem while uploading catalogcity feed " . $file_cat;
$email = "asasson@overstockart.com";
$subject = "problem while uploading catalogcity feed...";
cron_mail($email, $subject, $Body);
}
// close the connection
ftp_close($conn_id);
****/
//echo $header . \n;
//echo $data;
?>