-
Posts
13 -
Joined
-
Last visited
Posts posted by Velocio
-
-
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
-
ok solved, aruba changed php, i have change change the utf 8 ok is ok.
thank you
-
If you send an emails from the shop admin do you have the same problem? Yes the same problem
汩琠潵牯楤敮쌠₨獥来極潴
Francesco
-
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
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');
?>
-
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,
-
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
-
Hi, problem solved have insert incorrect domain name www.mognettibike.it the correct is www.mognettibike.it/oscomerrce
Thamk you
Frrancesco
-
Hi, excuse the domani name is www.mognettibike.it
-
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>';
// ---------
?>
Feedback for multimixer and Mini Template System
in Developer Feedback
Posted
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.