Hi, i am editing a google_feeder script, normally, this script takes a column from a SQL database table but what i want is to take another column from another database table in the same SQL database.This is the script i am currently running
Code: Select all
<?php
define('SEO_URLS_GEBRUIKEN','true');
define('BESTANDSNAAM', 'googleshopping_feed.txt');
define('WEBSITE_LINK', ''.$_SERVER['SERVER_NAME'].'/');
define('FTP_USERNAME', 'naam');
define('FTP_PASSWORD', 'password');
define('FTP_ENABLED', (isset($_GET['noftp']) ? '0' : '0'));
define('CONVERT_CURRENCY', '0');
define('VALUTA', 'EUR');
define('TAAL_ID_LANGUAGE', 5);
define('QUOTES_CATEGORY_NAME','');
define('OPTIONS_TONEN', 1);
define('OPTIONS_TONEN_AGE_RANGE', 0);
define('OPTIONS_TONEN_ATTRIBUTES', 1);
define('OPTIONS_TONEN_BRAND', 1);
define('OPTIONS_TONEN_CONDITION', 1);
define('OPTIONS_TONEN_CURRENCY', 0);
define('OPTIONS_TONEN_EXPIRATION', 1);
define('OPTIONS_TONEN_FEED_LANGUAGE', 0);
define('OPTIONS_TONEN_FEED_QUANTITY', 1);
define('OPTIONS_TONEN_GTIN', 0);
define('OPTIONS_TONEN_GOOGLE_UTM', 0);
define('OPTIONS_TONEN_ISBN', 0);
define('OPTIONS_TONEN_MADE_IN', 0);
define('OPTIONS_TONEN_MANUFACTURERS_ID', 0);
define('OPTIONS_TONEN_PAYMENT_ACCEPTED', 0);
define('OPTIONS_TONEN_PRODUCT_MODEL', 1);
define('OPTIONS_TONEN_PRODUCT_TYPE', 1);
define('OPTIONS_TONEN_SHIPPING', 1);
define('OPTIONS_TONEN_INCLUDE_TAX', 0);
define('OPTIONS_TONEN_UPC', 0);
define('OPTIONS_TONEN_WEIGHT', 1);
define('OPTIONS_AGE_RANGE', '10-50 years');
define('OPTIONS_BRAND', 'Gadgets');
define('OPTIONS_CONDITION', 'Nieuw'); //possible entries are New, Refurbished, Used
define('OPTIONS_DEFAULT_CURRENCY', 'EUR');
define('OPTIONS_DEFAULT_FEED_LANGUAGE', 'NL');
define('OPTIONS_DEFAULT_GOOGLE_UTM', '?utm_source=GoogleBase1&utm_medium=BaseFeed1&utm_campaign=products'); //see http://www.google.com/support/googleanalytics/bin/answer.py?hl=en&answer=55578
define('OPTIONS_GTIN', '');
define('OPTIONS_ISBN', '');
define('OPTIONS_MADE_IN', 'US');
define('OPTIONS_MANUFACTURERS_NAME', '1');
define('OPTIONS_PAYMENT_ACCEPTED_METHODS', '');
define('OPTIONS_PRODUCT_TYPE', 'full');
//define('OPTIONS_TAX_STRING', '');
//the following is for the shipping override option - enter multiple values separated by a comma
//Format entries follow. A colon must be present for each field, whether it is entered or not.
// COUNTRY - OPTIONAL - If country isn't included, we'll assume the shipping price applies to the target country of the item. If region isn't included, the shipping price will apply across the entire country.
// REGION - OPTIONAL - blank for entire country, otherwise, us two-letter State (CA), full zip code (90210) or wildcard zip code (902*)
// SERVICE - OPTIONAL - The service class or delivery speed, i.e. ground
// PRICE - REQUIRED - Fixed shipping price (assumes the same currency as the price attribute)
//define('OPTIONS_SHIPPING_STRING', 'nl::Ground:19.00'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping
//the following is for the tax override option - enter multiple values separated by a comma
//Format entries follow. A colon must be present for each field, whether it is entered or not.
// COUNTRY - OPTIONAL - country the tax applies to - only US for now
// REGION - OPTIONAL - blank for entire country, otherwise, us two-letter State (CA), full zip code (90210) or wildcard zip code (902*)
// TAX - REQUIRED - default = 0 (e.g. for 5.76% tax use 5.76)
// SHIPPING - OPTIONAL - do you charge tax on shipping - choices are y or n
//define('OPTIONS_TAX_STRING', 'NL::19.00:n'); //says charge tax to US for residents of Florida at 5% and don't apply tax to shipping
define('OPTIONS_UPC', '');
define('OPTIONS_WEIGHT_ACCEPTED_METHODS', 'g');
//the following allow skipping certain items
define('OPTIONS_IGNORE_PRODUCT_ZERO', 0);
$taxRate = 19; // (Prijs tonen inclusief XX BTW. Prijzen worden EX BTW uit de dabase gehaald.)
/***********************************************************************************************/
// Configuratie instellingen ophalen
require_once('../includes/configure.php');
if (! function_exists("tep_not_null")) {
function tep_not_null($value) {
if (is_array($value)) {
return ((sizeof($value) > 0) ? true : false);
} else {
return ((($value != '') && (strtolower($value) != 'null') && (strlen(trim($value)) > 0)) ? true : false);
}
}
}
if(SEO_URLS_GEBRUIKEN=='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/filenames.php');
require_once('../includes/database_tables.php');
include_once('../' .DIR_WS_CLASSES . 'seo.class.php');
$seo_urls = new SEO_URL(TAAL_ID_LANGUAGE);
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);
}
}
// -----------
$stimer = explode( ' ', microtime() );
$stimer = $stimer[1] + $stimer[0];
// -----------
$OutFile = "../feeds/" . BESTANDSNAAM;
$destination_file = BESTANDSNAAM;
$source_file = $OutFile;
$imageURL = 'http://' . WEBSITE_LINK . 'images/products_large/';
if(SEO_URLS_GEBRUIKEN=='true'){
$productURL = 'product_info.php'; // ***** Revised for SEO
$productParam = "products_id="; // ***** Added for SEO
}else{
$productURL = 'http://' . WEBSITE_LINK . '/product_info.php?products_id=';
}
$already_sent = array();
if(CONVERT_CURRENCY)
{
if(SEO_URLS_GEBRUIKEN=='true'){
$productParam="currency=" . VALUTA . "&products_id=";
}else{
$productURL = "http://" . WEBSITE_LINK . "/product_info.php?currency=" . VALUTA . "&products_id="; //where VALUTA is your currency type (eg. USD, EUR, GBP)
}
}
$taxCalc = ($taxRate/100) + 1;
$feed_exp_date = date('Y-m-d', time() + 2419200 );
if (!($link=mysql_connect(DB_SERVER,DB_SERVER_USERNAME,DB_SERVER_PASSWORD))) {
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( DB_DATABASE , $link )) {
echo "Error the data base does not exist";
exit();
}
$quotes = '';
if (QUOTES_CATEGORY_NAME !== '') {
$quotes = " and products.customers_email_address = '' and products.quotes_email_address = ''";
}
$extraFields = '';
if (OPTIONS_TONEN_BRAND == 1 && strlen(OPTIONS_BRAND) == 0) { //brand is enabled but not set so load from database
$extraFields .= ' products.products_brand as brand, ';
}
if (OPTIONS_TONEN_GTIN == 1 && strlen(OPTIONS_GTIN) == 0) {
$extraFields .= ' products.products_gtin as gtin, ';
}
if (OPTIONS_TONEN_ISBN == 1 && strlen(OPTIONS_ISBN) == 0) {
$extraFields .= ' products.products_isbn as isbn, ';
}
if (OPTIONS_TONEN_UPC == 1 && strlen(OPTIONS_UPC) == 0) {
$extraFields .= ' products.products_upc as upc, ';
}
$sql = "
SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,
products_model AS prodModel,
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,
products.products_weight AS prodWeight, " . $extraFields . "
FORMAT( IFNULL(specials.specials_new_products_price, products_groups.customers_group_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 is NULL) 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 " . $quotes . "
AND categories_description.language_id = " . TAAL_ID_LANGUAGE . "
AND products_description.language_id = " . TAAL_ID_LANGUAGE . "
ORDER BY
products.products_id ASC
";
$quotes = '';
if (QUOTES_CATEGORY_NAME !== '') {
$quotes = " and categories_description.categories_name NOT LIKE '" . QUOTES_CATEGORY_NAME . "' ";
}
$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 " . $quotes . "
AND categories_description.language_id = " . TAAL_ID_LANGUAGE . "";
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(
"![~ ]+$|^[~ ]+!m", // remove leading/trailing space chars
'%[\r\n]+%m'); // remove CRs and newlines
$_strip_replace = array(
'',
' ');
$_cleaner_array = array(">" => "> ", "®" => "", "®" => "", "™" => "", "™" => "", "~" => "", " " => "", """ => "\"");
if ( file_exists( $OutFile ) ) {
unlink( $OutFile );
}
$output = "link~titel~beschrijving~prijs~afbeeldingslink~id";
$attributesColumns = array();
//create optional section
if(OPTIONS_TONEN == 1) {
if(OPTIONS_TONEN_AGE_RANGE == 1) $output .= "~age_range";
if(OPTIONS_TONEN_BRAND == 1) $output .= "~merk";
if(OPTIONS_TONEN_CONDITION == 1) $output .= "~staat";
if(OPTIONS_TONEN_CURRENCY == 1) $output .= "~currency";
if(OPTIONS_TONEN_EXPIRATION == 1) $output .= "~vervaldatum";
if(OPTIONS_TONEN_FEED_LANGUAGE == 1) $output .= "~language";
if(OPTIONS_TONEN_FEED_QUANTITY == 1) $output .= "~hoeveelheid";
if(OPTIONS_TONEN_GTIN == 1) $output .= "~gtin";
if(OPTIONS_TONEN_ISBN == 1) $output .= "~isbn";
if(OPTIONS_TONEN_MADE_IN == 1) $output .= "~made_in";
if(OPTIONS_TONEN_MANUFACTURERS_ID == 1) $output .= "~manufacturer";
if(OPTIONS_TONEN_PAYMENT_ACCEPTED == 1) $output .= "~payment_accepted";
if(OPTIONS_TONEN_PRODUCT_MODEL == 1) $output .= "~mpn";
if(OPTIONS_TONEN_PRODUCT_TYPE == 1) $output .= "~producttype";
if(OPTIONS_TONEN_SHIPPING == 1) $output .= "~Google productcategorie ";
if(OPTIONS_TONEN_INCLUDE_TAX == 1) $output .= "~tax";
if(OPTIONS_TONEN_UPC == 1) $output .= "~upc";
if(OPTIONS_TONEN_WEIGHT == 1) $output .= "~verzendgewicht";
if (OPTIONS_TONEN_ATTRIBUTES == 1) {
$products_options_name_query = mysql_query("select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where popt.language_id = '" . (int)1 . "' order by popt.products_options_name") or die(mysql_error());
while ($products_options_name = mysql_fetch_object($products_options_name_query)) {
$attributesColumns[] = $products_options_name->products_options_name;
$name = strtolower($products_options_name->products_options_name);
$name = str_replace(" ","_", $name);
$output .= "~c:" . $name;
}
/*
//If you want to only show particular attributes, comment out the above and uncomment this section.
//Then enter two lines for each one you want to show. For example, if the atttributes you want to
//show are named Color and Fabric, the entries would appear as follows:
$attributesColumns[] = "Color";
$attributesColumns[] = "Fabric";
$output .= "~c:" . strtolower("Color");
$output .= "~c:" . strtolower("Fabric");
*/
}
}
$output .= "\n";
$result=mysql_query( $sql )or die( $FunctionName . ": SQL error " . mysql_error() . "| sql = " . htmlentities($sql) );
//Currency Information
if(CONVERT_CURRENCY) {
$sql3 = "
SELECT
currencies.value AS curEUR
FROM
currencies
WHERE currencies.code = '" . VALUTA . "'";
$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 (OPTIONS_IGNORE_PRODUCT_ZERO > 0 && $row->quantity < 1) continue; //skip products with 0 qty
if (isset($already_sent[$row->id])) continue; // if we've sent this one, skip the rest of the while loop
if ( $row->prodStatus == 1 ) {
if (CONVERT_CURRENCY) {
$row->price = preg_replace("/[^.0-9]/", "", $row->price);
$row->price = $row->price * $row3->curEUR;
$row->price = number_format($row->price, 2, '.', ',');
}
$google_utm = (OPTIONS_TONEN_GOOGLE_UTM ? OPTIONS_DEFAULT_GOOGLE_UTM : '');
if(SEO_URLS_GEBRUIKEN=='true'){
$output .= tep_href_link($productURL,$productParam . $row->id) . $google_utm . "~" .
strip_tags($row->name) . "~" .
preg_replace("/\s+[^a-zA-Z0-9]/", "", $row->description) . "~" .
$row->price . "~" .
$row->image_url . "~" .
// $catIndex[$row->prodCatID] . "~" .
$row->id;
} else {
$output .= $row->product_url . $google_utm . "~" .
strip_tags($row->name) . "~" .
preg_replace("/\s+[^a-zA-Z0-9]/", "", $row->description) . "~" .
$row->price . "~" .
$row->image_url . "~" .
// $catIndex[$row->prodCatID] . "~" .
$row->id;
}
//optional values section
if(OPTIONS_TONEN == 1) {
if(OPTIONS_TONEN_AGE_RANGE == 1)
$output .= "~" . OPTIONS_AGE_RANGE;
if(OPTIONS_TONEN_BRAND == 1)
// $output .= "~" . (isset($row->brand) ? $row->brand : (strlen(OPTIONS_BRAND) ? OPTIONS_BRAND : "Not Supported"));
// $output .= "~" . (isset($row->mfgName) ? $row->mfgName : (strlen(OPTIONS_BRAND) ? OPTIONS_BRAND : "Not Supported"));
$output .= "~" . (in_array($row->mfgName,explode(",",OPTIONS_MANUFACTURERS_NAME)) ? '' : $row->mfgName);
// $output .= "~" . (in_array($row->mfgName,explode(",",OPTIONS_MANUFACTURERS_NAME)) ? '' : $row->mfgName);
if(OPTIONS_TONEN_CONDITION == 1)
$output .= "~" . OPTIONS_CONDITION;
if(OPTIONS_TONEN_CURRENCY == 1)
$output .= "~" . OPTIONS_DEFAULT_CURRENCY;
if(OPTIONS_TONEN_EXPIRATION == 1)
$output .= "~" . $feed_exp_date;
if(OPTIONS_TONEN_FEED_LANGUAGE == 1)
$output .= "~" . OPTIONS_DEFAULT_FEED_LANGUAGE;
if(OPTIONS_TONEN_FEED_QUANTITY == 1)
$output .= "~" . $row->quantity;
if(OPTIONS_TONEN_GTIN == 1)
$output .= "~" . (isset($row->gtin) ? $row->gtin : (strlen(OPTIONS_GTIN) ? OPTIONS_GTIN : "Not Supported"));
if(OPTIONS_TONEN_ISBN == 1)
$output .= "~" . (isset($row->isbn) ? $row->isbn : (strlen(OPTIONS_ISBN) ? OPTIONS_ISBN : "Not Supported"));
if(OPTIONS_TONEN_MADE_IN == 1)
$output .= "~" . OPTIONS_MADE_IN;
if(OPTIONS_TONEN_MANUFACTURERS_ID == 1)
//$output .= "~" . (in_array($row->mfgName,explode(",",OPTIONS_MANUFACTURERS_NAME)) ? '' : $row->mfgName);
$output .= "~" . nl2br($row->prodModel);
if(OPTIONS_TONEN_PAYMENT_ACCEPTED == 1)
$output .= "~" . OPTIONS_PAYMENT_ACCEPTED_METHODS;
if(OPTIONS_TONEN_PRODUCT_MODEL == 1)
$output .= "~" . $row->prodModel;
if(OPTIONS_TONEN_PRODUCT_TYPE == 1)
$output .= "~" . ((OPTIONS_PRODUCT_TYPE == strtolower('full')) ? $catIndex[$row->prodCatID] : $row->catName);
if(OPTIONS_TONEN_SHIPPING == 1)
$output .= "~" . ((OPTIONS_PRODUCT_TYPE == strtolower('full')) ? $catIndex[$row->prodCatID] : $row->catName);
if(OPTIONS_TONEN_INCLUDE_TAX == 1)
$output .= "~" . OPTIONS_TAX_STRING;
if(OPTIONS_TONEN_UPC == 1)
$output .= "~" . (isset($row->upc) ? $row->upc : (strlen(OPTIONS_UPC) ? OPTIONS_UPC : "Not Supported"));
if(OPTIONS_TONEN_WEIGHT == 1)
$output .= "~" . $row->prodWeight . ' ' .OPTIONS_WEIGHT_ACCEPTED_METHODS;
/******************* BEGIN HANDLING THE ATTRIBUTES ********************/
if (OPTIONS_TONEN_ATTRIBUTES == 1)
{
$products_attributes_query = mysql_query("select count(*) as total from products_options popt, products_attributes patrib where patrib.products_id='" . $row->id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)1 . "'");
$products_attributes = mysql_fetch_object($products_attributes_query);
if ($products_attributes->total > 0) {
$products_options_name_query = mysql_query("select distinct popt.products_options_id, popt.products_options_name from products_options popt, products_attributes patrib where patrib.products_id='" . (int)$row->id . "' and patrib.options_id = popt.products_options_id and popt.language_id = '" . (int)1 . "' order by popt.products_options_name") or die(mysql_error());
$trackTabs = '';
while ($products_options_name = mysql_fetch_object($products_options_name_query)) {
$products_options_array = array();
$products_options_query = mysql_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from products_attributes pa, products_options_values pov where pa.products_id = '" . (int)$row->id . "' and pa.options_id = '" . $products_options_name->products_options_id . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)1 . "'");
while ($products_options = mysql_fetch_object($products_options_query)) {
$products_options_array[] = array('id' => $products_options->products_options_values_id, 'text' => $products_options->products_options_values_name);
}
for ($a = 0; $a < count($attributesColumns); ++$a)
{
if ($products_options_name->products_options_name == $attributesColumns[$a])
{
if ($a == 0)
$trackTabs = "~";
else
{
if (empty($trackTabs))
$trackTabs = str_repeat("~", $a);
$trackTabs .= "~";
}
$output .= $trackTabs;
foreach ($products_options_array as $arr)
$output .= $arr['text'] . ',';
$output = substr($output, 0, -1);
}
}
}
}
}
/******************* END HANDLING THE ATTRIBUTES ********************/
}
$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 "<table><tr><td><img src=\"images/google-shopping.jpg\" alt=\"Google Shopping\" align=\"left\"></td><td style=\"font-family: verdana; font-size:11px;\"><b>Google shopping feed is geupdate!</b><br><br>Bestand: <a href=\"" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a></td></tr></table>\n";
chmod($OutFile, 0777);
//Start FTP
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 is mislukt!<BR>\n";
return false;
} else {
echo "Uploaded " . $ftpsourcefile . " naar " . $ftpservername . " als " . $ftpdestinationfile . "<BR>\n";
}
// close the FTP stream
ftp_close($conn_id);
return true;
}
if (FTP_ENABLED)
ftp_file( "uploads.google.com", FTP_USERNAME, FTP_PASSWORD, $source_file, "", $destination_file);
//End FTP
// ---------
$etimer = explode( ' ', microtime() );
$etimer = $etimer[1] + $etimer[0];
echo '<p style="font-family: verdana; font-size:11px; margin:auto; text-align:center">';
printf( "Feed is gemaakt in: <b>%f</b> seconden.", ($etimer-$stimer) );
echo '</p>';
// ---------
/*
?>Code: Select all
FORMAT( IFNULL(specials.specials_new_products_price, products_groups.customers_group_price) * " . $taxCalc . ",2) AS price,Let me explain
The table PRODUCTS_GROUPS has 3 columns, "product_id", "customers_group_price" and "customers_group_id", that last column is what i want, but there is also the customers_group_id, that has 3 different values, and all i want is to take only the prices from "customers_group_price" that have a ID 0 in the "customers_group_id"
From another script on my site i have this code
Code: Select all
<?php
} else {
// $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
// $product_info = tep_db_fetch_array($product_info_query);
$product_info_query = tep_db_query("select p.products_new, p.algam_products_number, p.products_id, pd.products_youtube, p.products_levertijd_aanvraag, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, p.products_availability_id, p.products_subimage1, p.products_subimage2, p.products_subimage3, p.products_subimage4, p.products_subimage5, p.products_subimage6, pd.products_sound, pd.products_video, p.products_quantity from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
$product_info = tep_db_fetch_array($product_info_query);
tep_db_query("update " . TABLE_PRODUCTS_DESCRIPTION . " set products_viewed = products_viewed+1 where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and language_id = '" . (int)$languages_id . "'");
// BOF Separate Price per Customer
$scustomer_group_price_query = tep_db_query("select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id']. "' and customers_group_id = '" . $customer_group_id . "'");
if ($scustomer_group_price = tep_db_fetch_array($scustomer_group_price_query)) {
if ($customer_group_id == 2) {
$sql = "select * from customers_dealer_manufacturers where customers_id=".(int)$customer_id." and manufacturers_id=".(int)$product_info['manufacturers_id'];
$q = tep_db_query($sql);
if ($r = tep_db_fetch_array($q)) {
$product_info['products_price']= $scustomer_group_price['customers_group_price'];
}
} else {
$product_info['products_price']= $scustomer_group_price['customers_group_price'];
}
}[/quote]