dwmusicstore Posted August 13, 2011 Posted August 13, 2011 Hi, i have made a script for google merchants. The script works great but instead of using the products_price column in the table PRODUCTS i want it to use the customers_group_price in the table PRODUCTS_GROUPS So i altered this line: FORMAT( IFNULL(specials.specials_new_products_price, products.products_price) * " . $taxCalc . ",2) AS price, into FORMAT( IFNULL(specials.specials_new_products_price, products_groups.customers_group_price) * " . $taxCalc . ",2) AS price, But all i am getting is this error: : SQL error Unknown column 'products_groups.customers_group_price' in 'field list'| I've checked the database_tables.php file and there is a line for the PRODUCTS_GROUPS table and the tables and columns are all there...it is impossible to work, or am i missing something ?
web-project Posted August 13, 2011 Posted August 13, 2011 customers_group_price the above field is missing products_groups table, you probably skipped one of installation steps. Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you.
dwmusicstore Posted August 13, 2011 Author Posted August 13, 2011 i am not very good with SQL, can you please tell me how i can solve this ?
web-project Posted August 13, 2011 Posted August 13, 2011 you need to find code similar to: ALTER TABLE products_groups ADD customers_group_price varchar(50); or you can run above code in phpmyadmin utility. Info about adding field to table: http://forums.mysql.com/read.php?132,201915,201915 Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here! 8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself. Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues. Any issues with oscommerce, I am here to help you.
dwmusicstore Posted August 13, 2011 Author Posted August 13, 2011 But customers_group_price IS already in the table products_groups and it has values, and those values i needed, but somehow it is not being found when i run the php script phpmyadmin utility returned this error Fout SQL-query: ALTER TABLE products_groups ADD customers_group_price varchar( 50 ) MySQL retourneerde: Documentatie #1060 - Duplicate column name 'customers_group_price'
Jan Zonjee Posted August 14, 2011 Posted August 14, 2011 Anyone has a idea ? You turn this into a guessing game. Why don't you give us the complete query you use.
dwmusicstore Posted August 15, 2011 Author Posted August 15, 2011 Hi, here is the php script i use <?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>'; ?>
Recommended Posts
Archived
This topic is now archived and is closed to further replies.