Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Velocio

Pioneers
  • Posts

    13
  • Joined

  • Last visited

Posts posted by Velocio

  1. I installed oscommerce, and after many attempts at customizing it to my liking I wasn't satisfied with the results. I didn't have any traffic and the site didn't work well. So I used the oscommerce forums to find answers to my problems, and here I met (George Multimixer) who helped me out with expert advice. A collaboration was born, which in time has developed to a friendship. George's professionalism, competence, timely support and affordable pricing are second to none. Today I am extremely satisfied of my website performance, especially seeing how my sales volume has increased after implementing George's suggestions.

  2. Hi Jack, i have some problem at configuration (or wrong installation) :sweating: , today have purchassed your product at your site :thumbsup: , at this point you prefered uninstall and yours install for me or is prefered see this installation? :'(

     

    Thank you

    Francesco

  3. Excuse me for this problem, this is set caratter in the php file

    <?php

    /*

    $Id: italian.php,v 1.106 2003/06/20 00:18:31 hpdl Exp $

     

    osCommerce, Open Source E-Commerce Solutions

    http://www.oscommerce.com

     

    Copyright © 2002 osCommerce

     

    Released under the GNU General Public License

    */

     

    // look in your $PATH_LOCALE/locale directory for available locales..

    // on RedHat6.0 I used 'en_US'

    // on FreeBSD 4.0 I use 'en_US.ISO_8859-1'

    // this may not work under win32 environments..

    setlocale(LC_TIME, 'it_IT.ISO8859-1');

    define('DATE_FORMAT_SHORT', '%d/%m/%Y'); // this is used for strftime()

    define('DATE_FORMAT_LONG', '%a %d %B, %Y'); // this is used for strftime()

    define('DATE_FORMAT', 'd/m/Y'); // this is used for date()

    define('PHP_DATE_TIME_FORMAT', 'd/m/Y H:i:s'); // this is used for date()

    define('DATE_TIME_FORMAT', DATE_FORMAT_SHORT . ' %H:%M:%S');

    define('JQUERY_DATEPICKER_I18N_CODE', ''); // leave empty for en_US; see http://jqueryui.com/demos/datepicker/#localization

    define('JQUERY_DATEPICKER_FORMAT', 'mm/dd/yy'); // see http://docs.jquery.com/UI/Datepicker/formatDate

     

    ////

    // Return date in raw format

    // $date should be in format mm/dd/yyyy

    // raw date is in format YYYYMMDD, or DDMMYYYY

    function tep_date_raw($date, $reverse = false) {

    if ($reverse) {

    return substr($date, 0, 2) . substr($date, 3, 2) . substr($date, 6, 4);

    } else {

    return substr($date, 6, 4) . substr($date, 3, 2) . substr($date, 0, 2);

    }

    }

     

    // Global entries for the <html> tag

    define('HTML_PARAMS','dir="ltr" lang="it"');

     

    // charset for web pages and emails

    define('CHARSET', 'utf-16');

     

    // page title

    define('TITLE', 'osCommerce');

     

    // header text in includes/header.php

    define('HEADER_TITLE_TOP', 'Amministrazione');

    define('HEADER_TITLE_SUPPORT_SITE', 'Sito di supporto');

    define('HEADER_TITLE_ONLINE_CATALOG', 'Catalogo On-line');

    define('HEADER_TITLE_ADMINISTRATION', 'Amministrazione');

     

    // text for gender

    define('MALE', 'Uomo');

    define('FEMALE', 'Donna');

     

    // text for date of birth example

    define('DOB_FORMAT_STRING', 'dd/mm/yyyy');

     

    // configuration box text in includes/boxes/configuration.php

    define('BOX_HEADING_CONFIGURATION', 'Configurazione');

    define('BOX_CONFIGURATION_MYSTORE', 'Il mio negozio');

    define('BOX_CONFIGURATION_LOGGING', 'Logging');

    define('BOX_CONFIGURATION_CACHE', 'Cache');

    define('BOX_CONFIGURATION_ADMINISTRATORS', 'Amministratori');

    define('BOX_CONFIGURATION_STORE_LOGO', 'Logo Negozio');

     

    // modules box text in includes/boxes/modules.php

    define('BOX_HEADING_MODULES', 'Moduli');

    define('BOX_MODULES_PAYMENT', 'Pagamenti');

    define('BOX_MODULES_SHIPPING', 'Spedizioni');

    define('BOX_MODULES_ORDER_TOTAL', 'Totale Ordine');

     

    // categories box text in includes/boxes/catalog.php

    define('BOX_HEADING_CATALOG', 'Catalogo');

    define('BOX_CATALOG_CATEGORIES_PRODUCTS', 'Categorie/Prodotti');

    define('BOX_CATALOG_CATEGORIES_PRODUCTS_ATTRIBUTES', 'Attributi Prodotti');

    define('BOX_CATALOG_MANUFACTURERS', 'Produttori');

    define('BOX_CATALOG_REVIEWS', 'Recensioni');

    define('BOX_CATALOG_SPECIALS', 'Offerte');

    define('BOX_CATALOG_PRODUCTS_EXPECTED', 'Prodotti in arrivo');

     

    // customers box text in includes/boxes/customers.php

    define('BOX_HEADING_CUSTOMERS', 'Clienti');

    define('BOX_CUSTOMERS_CUSTOMERS', 'Clienti');

    define('BOX_CUSTOMERS_ORDERS', 'Ordini');

     

    // taxes box text in includes/boxes/taxes.php

    define('BOX_HEADING_LOCATION_AND_TAXES', 'Zone/Tasse');

    define('BOX_TAXES_COUNTRIES', 'Nazioni');

    define('BOX_TAXES_ZONES', 'Stati/Province');

    define('BOX_TAXES_GEO_ZONES', 'Tasse stat./prov.');

    define('BOX_TAXES_TAX_CLASSES', 'Tipi di Tasse');

    define('BOX_TAXES_TAX_RATES', 'Aliquota Tasse');

     

    // reports box text in includes/boxes/reports.php

    define('BOX_HEADING_REPORTS', 'Statistiche');

    define('BOX_REPORTS_PRODUCTS_VIEWED', 'Prodotti visti');

    define('BOX_REPORTS_PRODUCTS_PURCHASED', 'Prodotti acquistati');

    define('BOX_REPORTS_ORDERS_TOTAL', 'Totale Ordini Clienti');

     

    // tools text in includes/boxes/tools.php

    define('BOX_HEADING_TOOLS', 'Strumenti utili');

    define('BOX_TOOLS_BACKUP', 'Salva Database');

    define('BOX_TOOLS_ACTION_RECORDER', 'Registra Azioni');

    define('BOX_TOOLS_BANNER_MANAGER', 'Gestione Banner');

    define('BOX_TOOLS_CACHE', 'Controllo Cache');

    define('BOX_TOOLS_DEFINE_LANGUAGE', 'Definizione lingua');

    define('BOX_TOOLS_FILE_MANAGER', 'Gestione File');

    define('BOX_TOOLS_MAIL', 'Invio Email');

    define('BOX_TOOLS_NEWSLETTER_MANAGER', 'Gestione Newsletter');

    define('BOX_TOOLS_SEC_DIR_PERMISSIONS', 'Cartella dei Permessi di Sicurezza');

    define('BOX_TOOLS_SERVER_INFO', 'Informazioni Server');

    define('BOX_TOOLS_WHOS_ONLINE', 'Chi c\'è online');

    define('BOX_TOOLS_VERSION_CHECK', 'Update per OSC');

     

    // localizaion box text in includes/boxes/localization.php

    define('BOX_HEADING_LOCALIZATION', 'Localizzazione');

    define('BOX_LOCALIZATION_CURRENCIES', 'Valute/Monete');

    define('BOX_LOCALIZATION_LANGUAGES', 'Lingue');

    define('BOX_LOCALIZATION_ORDERS_STATUS', 'Stato Ordini');

     

    // javascript messages

    define('JS_ERROR', 'Si sono verificati degli errori nel procedimento di compilazione del tuo modulo!!\nEseguire le seguenti correzioni:\n\n');

     

    define('JS_OPTIONS_VALUE_PRICE', '* Definire per il nuovo attributo del Prodotto un prezzo\n');

    define('JS_OPTIONS_VALUE_PRICE_PREFIX', '* Definire per il nuovo attributo del Prodotto un prefisso di prezzo\n');

     

    define('JS_PRODUCTS_NAME', '* Definire per il nuovo Prodotto un nome\n');

    define('JS_PRODUCTS_DESCRIPTION', '* Definire per il nuovo Prodotto una descrizione\n');

    define('JS_PRODUCTS_PRICE', '* Definire per il nuovo Prodotto necessita di un prezzo\n');

    define('JS_PRODUCTS_WEIGHT', '* Definire per il nuovo Prodotto un peso\n');

    define('JS_PRODUCTS_QUANTITY', '* Definire per il nuovo Prodotto una quantità\n');

    define('JS_PRODUCTS_MODEL', '* Definire per il nuovo Prodotto un modello\n');

    define('JS_PRODUCTS_IMAGE', '* Definire per il nuovo Prodotto un\'immagine\'\n');

     

    define('JS_SPECIALS_PRODUCTS_PRICE', '* Definire un nuovo prezzo per questo prodotto.\n');

     

    define('JS_GENDER', '* La scelta del Sesso è obbligatoria.\n');

    define('JS_FIRST_NAME', '* Il Nome deve contenere almeno ' . ENTRY_FIRST_NAME_MIN_LENGTH . ' caratteri.\n');

    define('JS_LAST_NAME', '* Il Cognome deve contenere almeno ' . ENTRY_LAST_NAME_MIN_LENGTH . ' caratteri.\n');

    define('JS_DOB', '* La Data di Nascita deve avere il formato: xx/xx/xxxx (mese/giorno/anno).\n');

    define('JS_EMAIL_ADDRESS', '* L\'indirizzo di E-mail deve contenere almeno\' ' . ENTRY_EMAIL_ADDRESS_MIN_LENGTH . ' caratteri.\n');

    define('JS_ADDRESS', '* L\'indirizzo deve contenere almeno\' ' . ENTRY_STREET_ADDRESS_MIN_LENGTH . ' caratteri.\n');

    define('JS_POST_CODE', '* Il CAP deve contenere almeno ' . ENTRY_POSTCODE_MIN_LENGTH . ' caratteri.\n');

    define('JS_CITY', '* Il nome della Città deve contenere almeno ' . ENTRY_CITY_MIN_LENGTH . ' caratteri.\n');

    define('JS_STATE', '* Lo Stato/Provincia deve essere selezionato.\n');

    define('JS_STATE_SELECT', '-- Seleziona Sotto --');

    define('JS_ZONE', '* Lo Stato/Provincia deve essere scelto dalla lista.');

    define('JS_COUNTRY', '* Lo Stato/Provincia deve essere scelto.\n');

    define('JS_TELEPHONE', '* Il Numero di Telefono deve contenere almeno ' . ENTRY_TELEPHONE_MIN_LENGTH . ' caratteri.\n');

    define('JS_PASSWORD', '* La Password e la Conferma devono contenere almeno ' . ENTRY_PASSWORD_MIN_LENGTH . ' caratteri.\n');

     

    define('JS_ORDER_DOES_NOT_EXIST', 'Il Numero dell\'Ordine\' %s non esiste!');

     

    define('CATEGORY_PERSONAL', 'Personale');

    define('CATEGORY_ADDRESS', 'Indirizzo');

    define('CATEGORY_CONTACT', 'Contatti');

    define('CATEGORY_COMPANY', 'Azienda');

    define('CATEGORY_OPTIONS', 'Opzioni');

     

    define('ENTRY_GENDER', 'Sesso:');

    define('ENTRY_GENDER_ERROR', ' <span class="errorText">campo richiesto</span>');

    define('ENTRY_FIRST_NAME', 'Nome:');

    define('ENTRY_FIRST_NAME_ERROR', ' <span class="errorText">minimo ' . ENTRY_FIRST_NAME_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_LAST_NAME', 'Cognome:');

    define('ENTRY_LAST_NAME_ERROR', ' <span class="errorText">minimo ' . ENTRY_LAST_NAME_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_DATE_OF_BIRTH', 'Data di Nascita:');

    define('ENTRY_DATE_OF_BIRTH_ERROR', ' <span class="errorText">(eg. 21/05/1970)</span>');

    define('ENTRY_EMAIL_ADDRESS', 'Indirizzo E-Mail:');

    define('ENTRY_EMAIL_ADDRESS_ERROR', ' <span class="errorText">minimo ' . ENTRY_EMAIL_ADDRESS_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_EMAIL_ADDRESS_CHECK_ERROR', ' <span class="errorText">L\'inidirizzo email non sembra essere valido!</span>');

    define('ENTRY_EMAIL_ADDRESS_ERROR_EXISTS', ' <span class="errorText">Questo indirizzo email esiste già!</span>');

    define('ENTRY_COMPANY', 'Nome Azienda:');

    define('ENTRY_COMPANY_ERROR', '');

    define('ENTRY_STREET_ADDRESS', 'Indirizzo:');

    define('ENTRY_STREET_ADDRESS_ERROR', ' <span class="errorText">minimo ' . ENTRY_STREET_ADDRESS_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_SUBURB', 'Frazione:');

    define('ENTRY_SUBURB_ERROR', '');

    define('ENTRY_POST_CODE', 'CAP:');

    define('ENTRY_POST_CODE_ERROR', ' <span class="errorText">minimo ' . ENTRY_POSTCODE_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_CITY', 'Città:');

    define('ENTRY_CITY_ERROR', ' <span class="errorText">minimo ' . ENTRY_CITY_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_STATE', 'Stato/Provincia:');

    define('ENTRY_STATE_ERROR', ' <span class="errorText">richiesto</span>');

    define('ENTRY_COUNTRY', 'Nazione:');

    define('ENTRY_COUNTRY_ERROR', '');

    define('ENTRY_TELEPHONE_NUMBER', 'Numero di telefono:');

    define('ENTRY_TELEPHONE_NUMBER_ERROR', ' <span class="errorText">minimo ' . ENTRY_TELEPHONE_MIN_LENGTH . ' caratteri</span>');

    define('ENTRY_FAX_NUMBER', 'Numero di Fax:');

    define('ENTRY_FAX_NUMBER_ERROR', '');

    define('ENTRY_NEWSLETTER', 'Newsletter:');

    define('ENTRY_NEWSLETTER_YES', 'Mi iscrivo');

    define('ENTRY_NEWSLETTER_NO', 'Non mi iscrivo');

    define('ENTRY_NEWSLETTER_ERROR', '');

     

    //PIVACF start

    define('ENTRY_PIVA', 'Partita Iva:');

    define('ENTRY_CF', 'Codice Fiscale:');

    define('JS_PIVA', 'Parita Iva richiesta');

    define('JS_CF', 'Codice Fiscale richiesto');

    //PIVACF end

     

    // images

    define('IMAGE_ANI_SEND_EMAIL', 'Spedisci E-Mail');

    define('IMAGE_BACK', 'Indietro');

    define('IMAGE_BACKUP', 'Salva');

    define('IMAGE_CANCEL', 'Cancella');

    define('IMAGE_CONFIRM', 'Conferma');

    define('IMAGE_COPY', 'Copia');

    define('IMAGE_COPY_TO', 'Copia In');

    define('IMAGE_DETAILS', 'Dettagli');

    define('IMAGE_DELETE', 'Cancella');

    define('IMAGE_EDIT', 'Modifica');

    define('IMAGE_EMAIL', 'Email');

    define('IMAGE_EXPORT', 'Esporta');

    define('IMAGE_FILE_MANAGER', 'File Manager');

    define('IMAGE_ICON_STATUS_GREEN', 'Attiva');

    define('IMAGE_ICON_STATUS_GREEN_LIGHT', 'Imposta come Attivo');

    define('IMAGE_ICON_STATUS_RED', 'Inattiva');

    define('IMAGE_ICON_STATUS_RED_LIGHT', 'Imposta come Inattivo');

    define('IMAGE_ICON_INFO', 'Informazioni');

    define('IMAGE_INSERT', 'Inserisci');

    define('IMAGE_LOCK', 'Blocca');

    define('IMAGE_MODULE_INSTALL', 'Installa Modulo');

    define('IMAGE_MODULE_REMOVE', 'Rimuovi Modulo');

    define('IMAGE_MOVE', 'Sposta');

    define('IMAGE_NEW_BANNER', 'Nuovo Banner');

    define('IMAGE_NEW_CATEGORY', 'Nuova Categoria');

    define('IMAGE_NEW_COUNTRY', 'Nuova Nazione');

    define('IMAGE_NEW_CURRENCY', 'Nuova Valuta');

    define('IMAGE_NEW_FILE', 'Nuovo File');

    define('IMAGE_NEW_FOLDER', 'Nuova Cartella');

    define('IMAGE_NEW_LANGUAGE', 'Nuova Lingua');

    define('IMAGE_NEW_NEWSLETTER', 'Nuova Newsletter');

    define('IMAGE_NEW_PRODUCT', 'Nuovo Prodotto');

    define('IMAGE_NEW_TAX_CLASS', 'Nuovo Tipo di Tassa');

    define('IMAGE_NEW_TAX_RATE', 'Nuova Aliquota Tassa');

    define('IMAGE_NEW_TAX_ZONE', 'Nuova Tassa Stat./Prov.');

    define('IMAGE_NEW_ZONE', 'Nuovo Stato/Provincia');

    define('IMAGE_ORDERS', 'Ordini');

    define('IMAGE_ORDERS_INVOICE', 'Fattura');

    define('IMAGE_ORDERS_PACKINGSLIP', 'Ordini evasi');

    define('IMAGE_PREVIEW', 'Anteprima');

    define('IMAGE_RESTORE', 'Ripristina');

    define('IMAGE_RESET', 'Resetta');

    define('IMAGE_SAVE', 'Salva');

    define('IMAGE_SEARCH', 'Cerca');

    define('IMAGE_SELECT', 'Seleziona');

    define('IMAGE_SEND', 'Spedisci');

    define('IMAGE_SEND_EMAIL', 'Invia Email');

    define('IMAGE_UNLOCK', 'Sblocca');

    define('IMAGE_UPDATE', 'Aggiorna');

    define('IMAGE_UPDATE_CURRENCIES', 'Aggiorna Tasso di Cambio');

    define('IMAGE_UPLOAD', 'Upload??');

     

    define('ICON_CROSS', 'Falso');

    define('ICON_CURRENT_FOLDER', 'Cartella Corrente');

    define('ICON_DELETE', 'Cancella');

    define('ICON_ERROR', 'Errore');

    define('ICON_FILE', 'File');

    define('ICON_FILE_DOWNLOAD', 'Download');

    define('ICON_FOLDER', 'Cartella');

    define('ICON_LOCKED', 'Bloccato');

    define('ICON_PREVIOUS_LEVEL', 'Livello Precedente');

    define('ICON_PREVIEW', 'Anteprima');

    define('ICON_STATISTICS', 'Statistiche');

    define('ICON_SUCCESS', 'Riuscito');

    define('ICON_TICK', 'Vero');

    define('ICON_UNLOCKED', 'Sbloccato');

    define('ICON_WARNING', 'Attenzione');

     

    // constants for use in tep_prev_next_display function

    define('TEXT_RESULT_PAGE', 'Pagina %s di %d');

    define('TEXT_DISPLAY_NUMBER_OF_BANNERS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> banners)');

    define('TEXT_DISPLAY_NUMBER_OF_COUNTRIES', 'Visualizzate <b>%d</b> su <b>%d</b> (di <b>%d</b> nazioni)');

    define('TEXT_DISPLAY_NUMBER_OF_CUSTOMERS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> clienti)');

    define('TEXT_DISPLAY_NUMBER_OF_CURRENCIES', 'Visualizzate <b>%d</b> su <b>%d</b> (di <b>%d</b> valute)');

    define('TEXT_DISPLAY_NUMBER_OF_ENTRIES', 'Visualizzati <strong>%d</strong> di <strong>%d</strong> (of <strong>%d</strong> entries)');

    define('TEXT_DISPLAY_NUMBER_OF_LANGUAGES', 'Visualizzate <b>%d</b> su <b>%d</b> (di <b>%d</b> lingue)');

    define('TEXT_DISPLAY_NUMBER_OF_MANUFACTURERS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> produttori)');

    define('TEXT_DISPLAY_NUMBER_OF_NEWSLETTERS', 'Visualizzate <b>%d</b> su <b>%d</b> (di <b>%d</b> newsletters)');

    define('TEXT_DISPLAY_NUMBER_OF_ORDERS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> ordini)');

    define('TEXT_DISPLAY_NUMBER_OF_ORDERS_STATUS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> stato ordini)');

    define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> prodotti)');

    define('TEXT_DISPLAY_NUMBER_OF_PRODUCTS_EXPECTED', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> prodotti in attesa)');

    define('TEXT_DISPLAY_NUMBER_OF_REVIEWS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> recensioni prodotto)');

    define('TEXT_DISPLAY_NUMBER_OF_SPECIALS', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> prodotti in offerta)');

    define('TEXT_DISPLAY_NUMBER_OF_TAX_CLASSES', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> tipi di tassa)');

    define('TEXT_DISPLAY_NUMBER_OF_TAX_ZONES', 'Visualizzate <b>%d</b> su <b>%d</b> (di <b>%d</b> tasse stat./prov)');

    define('TEXT_DISPLAY_NUMBER_OF_TAX_RATES', 'Visualizzate <b>%d</b> su <b>%d</b> (di <b>%d</b> aliquote di tassa)');

    define('TEXT_DISPLAY_NUMBER_OF_ZONES', 'Visualizzati <b>%d</b> su <b>%d</b> (di <b>%d</b> stati/Province)');

     

    define('PREVNEXT_BUTTON_PREV', '<<');

    define('PREVNEXT_BUTTON_NEXT', '>>');

     

    define('TEXT_DEFAULT', 'default');

    define('TEXT_SET_DEFAULT', 'Setta come Default');

    define('TEXT_FIELD_REQUIRED', ' <span class="fieldRequired">* Richiesto</span>');

     

    define('ERROR_NO_DEFAULT_CURRENCY_DEFINED', 'Errore: Non cè un valore di Default settato. Settane uno da: Tool Amministrazione->Localizzazione->Valute');

     

    define('TEXT_CACHE_CATEGORIES', 'Box Categorie');

    define('TEXT_CACHE_MANUFACTURERS', 'Box Produttori');

    define('TEXT_CACHE_ALSO_PURCHASED', 'Also Purchased Module');

     

    define('TEXT_NONE', '--none--');

    define('TEXT_TOP', 'Top');

     

    define('ERROR_DESTINATION_DOES_NOT_EXIST', 'Errore: Destinazione non esistente.');

    define('ERROR_DESTINATION_NOT_WRITEABLE', 'Errore: Destinazione non scrivibile.');

    define('ERROR_FILE_NOT_SAVED', 'Errore: File upload non salvato.');

    define('ERROR_FILETYPE_NOT_ALLOWED', 'Errore: Tipo di file upload non consentito.');

    define('SUCCESS_FILE_SAVED_SUCCESSFULLY', 'Successo: File upload saved successfully.');

    define('WARNING_NO_FILE_UPLOADED', 'Warning: Nessuno file uplodato.');

    define('WARNING_FILE_UPLOADS_DISABLED', 'Warning: Il meccanismo di file uploads è disabilitato nel file di configurazione php.ini.');

     

    //TotalB2B start

    define('BOX_CUSTOMERS_GROUPS', 'Grouppi');

    define('BOX_MANUDISCOUNT', 'Discount Produttori');

    define('BOX_CATEMANUDISCOUNT', 'Discount Categorie Produttori');

    define('BOX_CATEDISCOUNT', 'Discount Categorie');

    //TotalB2B end

     

    //customersextrafileds start

    define('BOX_TOOLS_EXTRA_FIELDS_MANAGER','Extra fields manager');

    define('ENTRY_EXTRA_FIELDS_ERROR','Field %s must contain a minimum of %d characters');

    define('TEXT_DISPLAY_NUMBER_OF_FIELDS', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> Fields)');

    //customersextrafileds end

     

    //extrapages start

    define('BOX_TOOLS_PAGE_MANAGER', 'Extra info Pages Manager');

    define('TEXT_DISPLAY_NUMBER_OF_PAGES', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> Pages)');

    //extrapages end

     

    // START: Product Extra Fields

    define('BOX_CATALOG_PRODUCTS_EXTRA_FIELDS', 'Product Extra Fields');

    // END: Product Extra Fields

     

    //FAQDesk 2.1

    define('BOX_TOOLS_FAQ', 'FAQ Manager');

    //FAQDesk 2.1

     

    //Stats Low Stock

    define('BOX_REPORTS_STOCK_LEVEL', 'Low Stock Report');

    //Stats Low Stock

     

    //++++ QT Pro: Begin Changed code

    define('BOX_REPORTS_STATS_LOW_STOCK_ATTRIB', 'Stock Report');

    //++++ QT Pro: End Changed Code

     

    define('BOX_TOOLS_SLIDESHOW', 'Slideshow');

    define('BOX_CATALOG_SLIDESHOW', 'Slideshow');

    define('TEXT_DISPLAY_NUMBER_OF_SLIDES', 'Displaying <b>%d</b> to <b>%d</b> (of <b>%d</b> slides)');

     

    //Feeder Systems

    define('BOX_FEEDERS_GOOGLE', 'Google Base');

    define('TEXT_FEEDERS_BING', 'Create and Upload a Bing datafeed');

    define('TEXT_FEEDERS_BING_NOFTP', 'Create and <b>do not</b> upload a Bing datafeed');

    define('TEXT_FEEDERS_GOOGLE', 'Create and Upload a GoogleBase datafeed');

    define('TEXT_FEEDERS_GOOGLE_NOFTP', 'Create and <b>do not</b> upload a GoogleBase datafeed');

    define('BOX_MODULES_LIVEHELPNOW', 'LiveHelpNow');

    ?>

  4. This is not really VTS related more an email problem.

     

    Have you made a test purchase and if so what language are the emails in.

     

    What languages should the site work in?

     

    What character sets are defined in each language file?

     

    HTH

     

    G

    Yes i have test purchasse and the email is:

    潭湧瑥楴楢敫ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭഭ上牯楤瑴牵㩡栠瑴㩰潭湧瑥楴楢敫⽴獯潣浭牥散愯捣畯瑮桟獩潴祲楟普㽰牯敤彲摩㜽䐊瑡⁡牯楤㘱映扥牢楡〲㈱਍਍牐摯瑯楴਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍䅒义䕌升䜠䅉䱌䅔䱇䅉䴠⠠業⤮⠠慒敪䴭〬䔰剕਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍潔慴敬瀠牡楺污㩥〰啅䘊牯慦瑩⥔›〱〬䔰剕潔慴敬〬䔰剕਍਍湉楤楲空潣獮来慮਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍湡散捳潍湧瑥楴⁡楆敲ല倊慡空汯畳汬伧汧潩㌰ശ䈊敲捳慩瑉污൹ഊ䤊摮物穩潺映瑡畴慲楺湯൥ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ䘊慲据獥潣䴠杯敮瑴൩嘊慩䘠物湥敺慐穡潺潬猠汵杏楬㈠〵獥楣䤠慴祬਍਍敍潴潤搠慰慧敭瑮൯ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭഭ倊条浡湥潴愠汬潣獮来慮਍਍਍਍

    潭湧瑥楴楢敫ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭഭ上牯楤瑴牵㩡栠瑴㩰潭湧瑥楴楢敫⽴獯潣浭牥散愯捣畯瑮桟獩潴祲楟普㽰牯敤彲摩㜽䐊瑡⁡牯楤㘱映扥牢楡〲㈱਍਍牐摯瑯楴਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍䅒义䕌升䜠䅉䱌䅔䱇䅉䴠⠠業⤮⠠慒敪䴭〬䔰剕਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍潔慴敬瀠牡楺污㩥〰啅䘊牯慦瑩⥔›〱〬䔰剕潔慴敬〬䔰剕਍਍湉楤楲空潣獮来慮਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍湡散捳潍湧瑥楴⁡楆敲ല倊慡空汯畳汬伧汧潩㌰ശ䈊敲捳慩瑉污൹ഊ䤊摮物穩潺映瑡畴慲楺湯൥ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ䘊慲据獥潣䴠杯敮瑴൩嘊慩䘠物湥敺慐穡潺潬猠汵杏楬㈠〵獥楣䤠慴祬਍਍敍潴潤搠慰慧敭瑮൯ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭഭ倊条浡湥潴愠汬潣獮来慮਍਍਍਍

     

     

    The language in the site is Italian and English,

  5. Dear Sir,

    Today my client has purchased an item from my site, the order confirmation email is written in strange characters, the remainder of the site works well. http://www.mognettibike.it/oscommerce/index.php

     

    This copy of email:

    潭湧瑥楴楢敫ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭഭ上牯楤瑴牵㩡栠瑴㩰潭湧瑥楴楢敫⽴獯潣浭牥散愯捣畯瑮桟獩潴祲楟普㽰牯敤彲摩㜽䐊瑡⁡牯楤㘱映扥牢楡〲㈱਍਍牐摯瑯楴਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍慖摵潢獲⁡慤洠湡扵楲‵楌牴潒摡ㄠ删獯慳⠠潒摡爱摥〬䔰剕਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍潔慴敬瀠牡楺污㩥㘠〰啅䘊牯慦瑩⥔›〱〬䔰剕潔慴敬〬䔰剕਍਍湉楤楲空潣獮来慮਍ⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ਍湡散捳潍湧瑥楴⁡楆敲ല倊慡空汯畳汬伧汧潩㌰ശ䈊敲捳慩瑉污൹ഊ䤊摮物穩潺映瑡畴慲楺湯൥ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭ䘊慲据獥潣䴠杯敮瑴൩嘊慩䘠物湥敺慐穡潺潬猠汵杏楬㈠〵獥楣䤠慴祬਍਍敍潴潤搠慰慧敭瑮൯ⴊⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭⴭഭ倊条浡湥潴愠汬潣獮来慮਍਍਍਍

     

    Thank for help

  6. Hi,

    I have a problem with google images, the file is loaded, but the link does not work for images, this is my configuration for google, have the GoogleBase V 2.9.

     

    <?php

    // Title: Google Base Data Feeder

    // Last Update: 12/25/09 by Jack_mcs at oscommerce-solution.com

    // google feed requirements - http://www.google.com/support/merchants/bin/answer.py?hl=en&answer=188494

     

    chdir('../');

    include_once 'includes/application_top.php';

     

    /*************** BEGIN MASTER SETTINGS ******************/

     

    define('SEO_ENABLED','false'); //Change to 'false' to disable if Ultimate SEO URLs is not installed

    define('FEEDNAME', 'Feed_data_mog.txt'); //from your googlebase account

    define('DOMAIN_NAME', '+++++'); //your correct domain name (don't include www unless it is used)

    define('FTP_USERNAME', '++++'); //created from within your googlebase account

    define('FTP_PASSWORD', '++++++'); //created from within your googlebase account

    define('FTP_ENABLED', (isset($_GET['noftp']) ? '0' : '1')); //set to 0 to disable

    define('CONVERT_CURRENCY', '0'); //set to 0 to disable - only needed if a feed in a difference currecny is required

    define('CURRENCY_TYPE', 'EUR'); //(eg. USD, EUR, GBP)

    define('DEFAULT_LANGUAGE_ID', 5); //Change this to the id of your language. BY default 1 is english

    define('QUOTES_CATEGORY_NAME',''); //if the Quotes contribution is installed, enter the name of the quotes category here

     

    /*************** OPTIONS - IF ENABLED, ALSO SET THE SIMILAR OPTION FARTHER DOWN ******************/

    define('OPTIONS_ENABLED', 1);

    define('OPTIONS_ENABLED_AGE_RANGE', 0);

    define('OPTIONS_ENABLED_ATTRIBUTES', 1);

    define('OPTIONS_ENABLED_BRAND', 1); //if set, see options for this setting below

    define('OPTIONS_ENABLED_CONDITION', 1);

    define('OPTIONS_ENABLED_CURRENCY', 0);

    define('OPTIONS_ENABLED_EXPIRATION', 0);

    define('OPTIONS_ENABLED_FEED_LANGUAGE', 0);

    define('OPTIONS_ENABLED_GTIN', 0); //if set, a database field named products_gtin must exist

    define('OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY', 1); //http://www.google.com/support/merchants/bin/answer.py?answer=160081

    define('OPTIONS_ENABLED_GOOGLE_UTM', 0);

    define('OPTIONS_ENABLED_ISBN', 0); //if set, a database field named products_isbn must exist

    define('OPTIONS_ENABLED_MADE_IN', 0);

    define('OPTIONS_ENABLED_MPN', 1); //if set, see options for this setting below

    define('OPTIONS_ENABLED_PRODUCT_MODEL', 0); //displays the product model

    define('OPTIONS_ENABLED_PRODUCT_TYPE', 1);

    define('OPTIONS_ENABLED_SHIPPING', 0);

    define('OPTIONS_ENABLED_INCLUDE_TAX', 0); //0 = no tax, 1 = uses google method, 2 = UK Vat

    define('OPTIONS_ENABLED_UPC', 0); //if set, a database field named products_upc must exist

    define('OPTIONS_ENABLED_WEIGHT', 0);

     

    //some of the following only work if the matching option is enabled above.

    define('OPTIONS_AGE_RANGE', '20-90 years');

     

    define('OPTIONS_AVAILABILITY', 'quantity'); //in stock - Include this value if you are certain that it will ship (or be in-transit to the customer) in 3 business days or less.

    //available for order - Include this value if it will take 4 or more business days to ship it to the customer.

    //out of stock - You’re currently not accepting orders for this product.

    //preorder - You are taking orders for this product, but it’s not yet been released.

    //if empty (no entry), the data will be loaded from the database. A field in the products description table named products_availability is required

    //if "quantity," the field will be popuplated via the quantity: 0 or less = out of stock, greater than 0 = in stock

    //if "status," the field will be popuplated via the status field. in or out of stock

     

    define('OPTIONS_BRAND', 'name'); //leave blank to load from the database field named products_brand, set to "name" to substitute the products name, manu to substitute the manufactueres name or model to substitute the products model

    define('OPTIONS_CONDITION', 'new'); //possible entries are New, Refurbished, Used or blank, which loads from the database field named products_condition

    define('OPTIONS_CURRENCY', 'USD');

    define('OPTIONS_CURRENCY_THOUSANDS_POINT', ','); //this is the thousands point as in $1,000.

    define('OPTIONS_DATE_FORMAT', 'y-m-d'); //change how the date is formatted

    define('OPTIONS_FEED_LANGUAGE', 'en');

    define('OPTIONS_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_GOOGLE_PRODUCT_CATEGORY', 'articoli sportivi'); //enter db to load from a database field named google_product_category enter or enter a specific google category - see taxomy - http://www.google.com/support/merchants/bin/answer.py?answer=160081

    define('OPTIONS_GTIN', '');

    define('OPTIONS_ISBN', '');

    define('OPTIONS_MADE_IN', 'US');

    define('OPTIONS_MPN', 'model'); //leave blank to load from the database field named products_mpn, set to "name" to substitute the products name, manu to substitute the manufactueres name or model to substitute the products model

    define('OPTIONS_PRODUCT_TYPE', 'full'); //full means the full category path (i.e., hardware,printers), anything else, or blank, means just the products category (i.e., printers)

     

    //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', 'US:FL:Ground:7.00'); //says charge shipping to US for residents of Florida at 5% and don't apply tax to shipping

     

    define('OPTIONS_TAX_RATE' , '20.0'); //default = 0 (e.g. for 20.0% tax use "$taxRate = 20.0;") //only used in the next line

    define('OPTIONS_TAX_CALC', (OPTIONS_ENABLED_INCLUDE_TAX == 2 ? (OPTIONS_TAX_RATE/100) + 1 : '1')); //UK. US tax rate - US is ignorded since it is 1

    //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', 'US:FL:5.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', 'lb'); //Valid units include lb, pound, oz, ounce, g, gram, kg, kilogram.

     

    //the following allow skipping certain items

    define('OPTIONS_IGNORE_PRODUCT_PRICE', 0); //0 = include products with price of 0 in output, 1 = ignore products with price of 0

    define('OPTIONS_IGNORE_PRODUCT_ZERO', 0); //0 = include products with qty of 0 in output, 1 = ignore products with qty of 0

     

    /*************** END MASTER SETTINGS ******************/

     

     

    /*************** NO EDITS NEEDED BELOW THIS LINE *****************/

     

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

    // Start TIMER

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

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

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

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

     

     

    $OutFile = "feeds/" . FEEDNAME;

    $destination_file = FEEDNAME;

    $source_file = $OutFile;

    $imageURL = 'http://' . DOMAIN_NAME . '/images/';

    if(SEO_ENABLED=='true'){

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

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

    }else{

    $productURL = 'http://' . DOMAIN_NAME . '/product_info.php?products_id=';

    }

     

    $already_sent = array();

     

    if(CONVERT_CURRENCY)

    {

    if(SEO_ENABLED=='true'){

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

    }else{

    $productURL = "http://" . DOMAIN_NAME . "/product_info.php?currency=" . CURRENCY_TYPE . "&products_id="; //where CURRENCY_TYPE is your currency type (eg. USD, EUR, GBP)

    }

    }

     

    $feed_exp_date = @date(OPTIONS_DATE_FORMAT, 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_AVAILABILITY == '') {

    $extraFields .= ' products_description.products_availability as availability, ';

    }

    if (OPTIONS_ENABLED_BRAND == 1) {

    if (strlen(OPTIONS_BRAND) == 0) {

    $extraFields .= ' products.products_brand as brand, ';

    } else {

    switch (OPTIONS_BRAND) {

    case 'name': $extraFields .= ' products_description.products_name as brand, '; break;

    case 'manu': $extraFields .= ' manufacturers.manufacturers_name as brand, '; break;

    case 'model': $extraFields .= ' products.products_model as brand, '; break;

    default: $extraFields .= ' products_description.products_name as brand, ';

    }

    }

    }

    if (OPTIONS_ENABLED_CONDITION == 1 && strlen(OPTIONS_CONDITION) == 0) {

    $extraFields .= ' products.products_condition as pcondition, ';

    }

    if (OPTIONS_ENABLED_GTIN == 1 && strlen(OPTIONS_GTIN) == 0) {

    $extraFields .= ' products.products_gtin as gtin, ';

    }

    if (OPTIONS_ENABLED_ISBN == 1 && strlen(OPTIONS_ISBN) == 0) {

    $extraFields .= ' products.products_isbn as isbn, ';

    }

    if (OPTIONS_ENABLED_MPN == 1) {

    if (strlen(OPTIONS_MPN) == 0) {

    $extraFields .= ' products.products_mpn as mpn, ';

    } else {

    switch (OPTIONS_MPN) {

    case 'name': $extraFields .= ' products_description.products_name as mpn, '; break;

    case 'manu': $extraFields .= ' manufacturers.manufacturers_name as mpn, '; break;

    case 'model': $extraFields .= ' products.products_model as mpn, '; break;

    default: $extraFields .= ' products_description.products_name as mpn, ';

    }

    }

    }

    if (OPTIONS_ENABLED_UPC == 1 && strlen(OPTIONS_UPC) == 0) {

    $extraFields .= ' products.products_upc as upc, ';

    }

     

    if (OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY == 1 && OPTIONS_GOOGLE_PRODUCT_CATEGORY == 'db') {

    $extraFields .= ' products_description.google_product_category as google_category, ';

    }

     

     

    $sql = "

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

    products_model AS prodModel,

    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.products_price) * " . OPTIONS_TAX_CALC . ",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 = " . DEFAULT_LANGUAGE_ID . "

    AND products_description.language_id = " . DEFAULT_LANGUAGE_ID . "

    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 = " . DEFAULT_LANGUAGE_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 = "link\ttitle\tdescription\tprice\timage_link\tid\tavailability";

    $attributesColumns = array();

     

    //create optional section

    if(OPTIONS_ENABLED == 1) {

    if(OPTIONS_ENABLED_AGE_RANGE == 1) $output .= "\tage_range";

    if(OPTIONS_ENABLED_BRAND == 1) $output .= "\tbrand";

    if(OPTIONS_ENABLED_CONDITION == 1) $output .= "\tcondition";

    if(OPTIONS_ENABLED_CURRENCY == 1) $output .= "\tcurrency";

    if(OPTIONS_ENABLED_EXPIRATION == 1) $output .= "\texpiration_date";

    if(OPTIONS_ENABLED_FEED_LANGUAGE == 1) $output .= "\tlanguage";

    if(OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY == 1) $output .= "\tgoogle product_category";

    if(OPTIONS_ENABLED_GTIN == 1) $output .= "\tgtin";

    if(OPTIONS_ENABLED_ISBN == 1) $output .= "\tisbn";

    if(OPTIONS_ENABLED_MADE_IN == 1) $output .= "\tmade_in";

    if(OPTIONS_ENABLED_MPN == 1) $output .= "\tmpn";

    if(OPTIONS_ENABLED_PRODUCT_MODEL == 1) $output .= "\tmodel";

    if(OPTIONS_ENABLED_PRODUCT_TYPE == 1) $output .= "\tproduct_type";

    if(OPTIONS_ENABLED_SHIPPING == 1) $output .= "\tshipping";

    if(OPTIONS_ENABLED_INCLUDE_TAX == 1) $output .= "\ttax";

    if(OPTIONS_ENABLED_UPC == 1) $output .= "\tupc";

    if(OPTIONS_ENABLED_WEIGHT == 1) $output .= "\tweight";

     

    if (OPTIONS_ENABLED_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 .= "\tc:" . $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 .= "\tc:" . strtolower("Color");

    $output .= "\tc:" . 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 curUSD

    FROM

    currencies

    WHERE currencies.code = '" . CURRENCY_TYPE . "'";

     

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

    $row3 = mysql_fetch_object( $result3 );

    }

     

    $loop_counter = 0;

    $statsArray = array();

     

    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 (OPTIONS_IGNORE_PRODUCT_PRICE > 0 && $row->price <= 0) continue; //skip products with 0 price

    if (OPTIONS_IGNORE_PRODUCT_ZERO > 0 && $row->quantity < 1) continue; //skip products with 0 qty

    if (OPTIONS_IGNORE_PRODUCT_PRICE < 1 && $row->price <= 0) $statsArray['price']++; //record for warning

    if (OPTIONS_IGNORE_PRODUCT_ZERO < 1 && $row->quantity < 1) $statsArray['qty']++; //record for warning

     

    $statsArray['total']++;

     

    if ( $row->prodStatus == 1 ) {

    if (CONVERT_CURRENCY) {

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

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

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

    }

     

    $availability = '';

    switch (OPTIONS_AVAILABILITY) {

    case 'quantity': $availability = ($row->quantity > 0 ? 'in stock' : 'out of stock'); break;

    case 'status': $availability = ($row->prodStatus == 1 ? 'in stock' : 'out of stock'); break;

    case '': $availability = $row->availability; break;

    default: $availability = OPTIONS_AVAILABILITY;

    }

     

    $google_utm = (OPTIONS_ENABLED_GOOGLE_UTM ? OPTIONS_GOOGLE_UTM : '');

     

    if(SEO_ENABLED=='true'){

    $output .= tep_href_link($productURL,$productParam . $row->id, 'NONSSL', false) . $google_utm . "\t";

    } else {

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

    }

     

    $output .=

    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 . "\t" .

    $availability;

     

    //optional values section

    if(OPTIONS_ENABLED == 1) {

    if(OPTIONS_ENABLED_AGE_RANGE == 1)

    $output .= "\t" . OPTIONS_AGE_RANGE;

    if(OPTIONS_ENABLED_BRAND == 1)

    $output .= "\t" . (isset($row->brand) ? $row->brand : (strlen(OPTIONS_BRAND) ? $row->name : "Not Supported"));

    if(OPTIONS_ENABLED_CONDITION == 1)

    $output .= "\t" . (isset($row->pcondition) ? $row->pcondition : OPTIONS_CONDITION);

    if(OPTIONS_ENABLED_CURRENCY == 1)

    $output .= "\t" . OPTIONS_CURRENCY;

    if(OPTIONS_ENABLED_EXPIRATION == 1)

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

    if(OPTIONS_ENABLED_FEED_LANGUAGE == 1)

    $output .= "\t" . OPTIONS_FEED_LANGUAGE;

    if(OPTIONS_ENABLED_GOOGLE_PRODUCT_CATEGORY == 1)

    $output .= "\t" . (OPTIONS_GOOGLE_PRODUCT_CATEGORY == 'db' ? $row->google_category : OPTIONS_GOOGLE_PRODUCT_CATEGORY);

    if(OPTIONS_ENABLED_GTIN == 1)

    $output .= "\t" . (isset($row->gtin) ? $row->gtin : (strlen(OPTIONS_GTIN) ? OPTIONS_GTIN : "Not Supported"));

    if(OPTIONS_ENABLED_ISBN == 1)

    $output .= "\t" . (isset($row->isbn) ? $row->isbn : (strlen(OPTIONS_ISBN) ? OPTIONS_ISBN : "Not Supported"));

    if(OPTIONS_ENABLED_MADE_IN == 1)

    $output .= "\t" . OPTIONS_MADE_IN;

    if(OPTIONS_ENABLED_MPN == 1)

    $output .= "\t" . (isset($row->mpn) ? $row->mpn : (strlen(OPTIONS_MPN) ? OPTIONS_MPN : "Not Supported"));

    if(OPTIONS_ENABLED_PRODUCT_MODEL == 1)

    $output .= "\t" . (! empty($row->prodModel) ? $row->prodModel : $row->catName);

    if(OPTIONS_ENABLED_PRODUCT_TYPE == 1)

    $output .= "\t" . ((OPTIONS_PRODUCT_TYPE == strtolower('full')) ? $catIndex[$row->prodCatID] : $row->catName);

    if(OPTIONS_ENABLED_SHIPPING == 1)

    $output .= "\t" . OPTIONS_SHIPPING_STRING;

    if(OPTIONS_ENABLED_INCLUDE_TAX == 1)

    $output .= "\t" . OPTIONS_TAX_STRING;

    if(OPTIONS_ENABLED_UPC == 1)

    $output .= "\t" . (isset($row->upc) ? $row->upc : (strlen(OPTIONS_UPC) ? OPTIONS_UPC : "Not Supported"));

    if(OPTIONS_ENABLED_WEIGHT == 1)

    $output .= "\t" . $row->prodWeight . ' ' .OPTIONS_WEIGHT_ACCEPTED_METHODS;

     

    /******************* BEGIN HANDLING THE ATTRIBUTES ********************/

    if (OPTIONS_ENABLED_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 = "\t";

    else

    {

    if (empty($trackTabs))

    $trackTabs = str_repeat("\t", $a);

    $trackTabs .= "\t";

    }

     

    $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 '<p style="margin:auto; text-align:left">';

    printf( "Feed contains %d products.", $statsArray['total'] );

    echo '</p>';

     

    $warning = false;

    if (count($statsArray['price']) > 0) {

    $warning = true;

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

    printf( " ***Warning:*** There are %d products with a price of $0.", $statsArray['price'] );

    echo '</p>';

    }

     

    if (count($statsArray['qty']) > 0) {

    $warning = true;

    echo '<p style="margin:auto; text-align:left; padding-bottom:10px; ">';

    printf( " ***Warning:*** There are %d products with a quantity of 0.", $statsArray['qty'] );

    echo '</p>';

    }

     

    $completed = 'File Completed' . ($warning ? ' (with warnings): ' : ':' );

     

    echo "$completed <a href=\"../" . $OutFile . "\" target=\"_blank\">" . $destination_file . "</a><br>\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 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;

    }

     

    if (FTP_ENABLED)

    ftp_file( "uploads.google.com", FTP_USERNAME, FTP_PASSWORD, $source_file, "", $destination_file);

     

    //End FTP

     

     

    // 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>';

     

     

     

     

    // ---------

     

    ?>

×
×
  • Create New...