Jump to content

bhbilbao

Members
  • Content count

    308
  • Joined

  • Last visited

  • Days Won

    1

Everything posted by bhbilbao

  1. bhbilbao

    NEW! Complete Order Editing Tool!

    I have other problem using without AJAX. In editor screen apeared 2 checkboxes: X Shipping same as billing address X Billing same as customer address I checked them and update. And now they are always minimized and dont kown how to came back them.
  2. bhbilbao

    NEW! Complete Order Editing Tool!

    The last version support it , but you must install Send HTML email V2- Otherwhise remove the buttom. You must also to update database: DROP TABLE IF EXISTS `eorder_text`; CREATE TABLE `eorder_text` ( `eorder_text_id` tinyint(3) unsigned NOT NULL default '0', `language_id` tinyint(3) unsigned NOT NULL default '1', `eorder_text_one` text, PRIMARY KEY (`eorder_text_id, language_id`) ) ; etc,etc,etc I have other problem usin AJAX, the email forms return on blank. Example: Dear JOSE GARCIA We would like to notify you that the status of your order has been update. Order Number: Date Ordered:: Wednesday 23 December, 2009 Detailed Invoice: EMAIL_TEXT_COMMENTS_UPDATE_HTML Thank you so much for your order with us! The status of your order has been updated. New status: ....... Could anyone help me???
  3. bhbilbao

    [contribution] Send_order_html_email

    The above solutions are DISABLING USE HTML AJAX in configuration (using edit_orders.php). If I ENABLE USE HTML AJAX (edit_orders_ajax.php) this doesn´t work. The email is send but the queries are blank. ¿? Example: Dear JOSE GARCIA We would like to notify you that the status of your order has been update. Order Number: Date Ordered:: Wednesday 23 December, 2009 Detailed Invoice: EMAIL_TEXT_COMMENTS_UPDATE_HTML Thank you so much for your order with us! The status of your order has been updated. New status: .......
  4. bhbilbao

    [contribution] Send_order_html_email

    Corrected in admin/includes/languages/xxx/order.php and edit_order.php: (the simbol %s) Replaced define('EMAIL_TEXT_COMMENTS_UPDATE', 'The comments for your order are' . "\n\n%s\n\n"); for define('EMAIL_TEXT_COMMENTS_UPDATE', 'The comments for your order are' . "\n\n"); Corrected in admin/order.php and edit_order.php: (appears as EMAIL_TEXT_COMMENTS_UPDATE) Replaced $Varbody = EMAIL_TEXT_COMMENTS_UPDATE . ' ' . $comments . "\n\n" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); for $Varbody = EMAIL_TEXT_COMMENTS_UPDATE_HTML . ' ' . $comments . "\n\n" . sprintf(EMAIL_TEXT_STATUS_UPDATE, $orders_status_array[$status]); Corrected not to receive the followin rare text: VARTABLE1 VARLOGO VARTABLE2 EMAILGREET_MS EMAILWELCOMEEMAILTEXTEMAILCONTACTEMAILWARNING EMAIL_TEXT_FOOTER Copied the following text in admin/includes/languages/xxx/order.php and edit_order.php(before the ?> tag): define('EMAIL_SEPARATOR', '------------------------------------------------------'); define('EMAIL_TEXT_SUBJECT', 'Su pedido ha cambiado de estado.'); define('EMAIL_TEXT_ORDER_NUMBER', 'Pedido Nº:'); define('EMAIL_TEXT_INVOICE_URL', 'Pedido Detallado:'); define('EMAIL_TEXT_DATE_ORDERED', 'Fecha del Pedido'); define('EMAIL_TEXT_STATUS_UPDATE', 'Su pedido ha sido actualizado al siguiente estado.' . "\n\n" . '<font color="#ff6600"><b>Nuevo estado: %s</b></font>' . "\n\n" . 'Por favor responda a este email si tiene alguna pregunta que hacer.' . "\n"); define('EMAIL_TEXT_COMMENTS_UPDATE', '<b>Comentarios del Sr.José Manuel:</b>' . "\n\n%s\n\n"); //BEGIN SEND HTML MAIL// // Email style define('STORE_LOGO', 'BLACKHOLE_BILBAO.jpg'); // Your shop logo (location: /catalog/images). define('BG_TOP_EMAIL', 'pixel_trans.gif'); //Header background image. define('COLOR_TOP_EMAIL', '#ffffff'); //Background color of the email header (only visible if no background image) define('BG_TABLE', 'carta.gif'); //background image of the email body define('COLOR_TABLE', '#f9f9f9'); //background color of the email body (only visible if no background image) //First section of text define('EMAIL_TEXT_DEAR', '<br><br>Notificación para'); define('EMAIL_MESSAGE_GREETING', 'Queremos notificarle que su pedido ha cambiado de estado.'); //Email Footer define('EMAIL_TEXT_FOOTER', 'Este email nos lo proporciono uno de nuestros clientes. Si cree que ha recibido este email por error, por favor mande un email a '); define('EMAIL_TEXT_COPYRIGHT', 'Blackhole Bilbao © 2009 '); //Define Variables define('VARSTYLE', '<link rel="stylesheet" type="text/css" href="stylesheetmail.css">'); //location of email css file. define('VARHTTP', '<base href="' . HTTP_SERVER . DIR_WS_CATALOG . '">'); //Do not change define('VARMAILFOOTER', '' . EMAIL_TEXT_FOOTER . '<a href="mailto:' . STORE_OWNER_EMAIL_ADDRESS . '">' . STORE_OWNER_EMAIL_ADDRESS . '</a><br>' . EMAIL_TEXT_COPYRIGHT . '<a align="center" href="' . HTTP_SERVER . DIR_WS_CATALOG . '">'. STORE_NAME .'</a> '); //footer define('VARLOGO', '<a href="' . HTTP_SERVER . DIR_WS_CATALOG . '"><IMG src="'. HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . STORE_LOGO .'" border=0></a> '); //logo define('VARTABLE1', '<table width="100%" border="0" cellpadding="0" cellspacing="0" bgcolor="' . COLOR_TOP_EMAIL . '" background="'. HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . BG_TOP_EMAIL . '"> '); //Header table formatting define('VARTABLE2', '<table width="100%" border="0" cellpadding="3" cellspacing="3" bgcolor="' . COLOR_TABLE . '" background="'. HTTP_SERVER . DIR_WS_CATALOG . DIR_WS_IMAGES . BG_TABLE . '">'); //Body table formatting //END SEND HTML MAIL// P.d: also looked to have installed the database tables eorder_text CREATE TABLE IF NOT EXISTS `eorder_text` ( `eorder_text_id` tinyint(3) unsigned NOT NULL default '0', `language_id` tinyint(3) unsigned NOT NULL default '1', `eorder_text_one` text NOT NULL, PRIMARY KEY (`eorder_text_id`,`language_id`) ) ; INSERT INTO `eorder_text` VALUES (1, 1, '<-STORE_NAME->\r\n------------------------------------------------------\r\nOrder number: <-insert_id->\r\n(Please quote this number in any enquiries)\r\n\r\nInvoice details: \r\n<-INVOICE_URL->\r\n\r\nDate ordered: <-DATE_ORDERED->\r\n\r\nComments: <-Customer_Comments->\r\n\r\nItems\r\n------------------------------------------------------\r\n<-Item_List->\r\n\r\n------------------------------------------------------\r\n<-List_Total->\r\n\r\nBilling Address\r\n------------------------------------------------------\r\n<-BILL_Adress->\r\n\r\nDelivery Address\r\n------------------------------------------------------\r\n<-DELIVERY_Adress->\r\n\r\nPayment Method\r\n------------------------------------------------------\r\n<-Payment_Modul_Text->\r\n\r\n<-Payment_Modul_Text_Footer->'); INSERT INTO `eorder_text` VALUES (1, 2, '<-STORE_NAME->\r\n------------------------------------------------------\r\nBestellnummer: <-insert_id->\r\n(Bitte bei Zahlungen und Anfragen stets angeben)\r\n\r\nDetailierte Bestellbersicht: \r\n<-INVOICE_URL->\r\n\r\nBestelldatum: <-DATE_ORDERED->\r\n\r\nKommentar: <-Customer_Comments->\r\n\r\nArtikel\r\n------------------------------------------------------\r\n<-Item_List->\r\n\r\n------------------------------------------------------\r\n<-List_Total->\r\n\r\nRechnungsanschrift\r\n------------------------------------------------------\r\n<-BILL_Adress->\r\n\r\nLieferung\r\n------------------------------------------------------\r\n<-DELIVERY_Adress->\r\n\r\nZahlungsweise\r\n------------------------------------------------------\r\n<-Payment_Modul_Text->\r\n\r\n<-Payment_Modul_Text_Footer->'); INSERT INTO `eorder_text` VALUES (1, 3, '<-STORE_NAME->\r\n------------------------------------------------------\r\nBestellnummer: <-insert_id->\r\n(Bitte bei Zahlungen und Anfragen stets angeben)\r\n\r\nDetailierte Bestellbersicht: \r\n<-INVOICE_URL->\r\n\r\nBestelldatum: <-DATE_ORDERED->\r\n\r\nKommentar: <-Customer_Comments->\r\n\r\nArtikel\r\n------------------------------------------------------\r\n<-Item_List->\r\n\r\n------------------------------------------------------\r\n<-List_Total->\r\n\r\nRechnungsanschrift\r\n------------------------------------------------------\r\n<-BILL_Adress->\r\n\r\nLieferung\r\n------------------------------------------------------\r\n<-DELIVERY_Adress->\r\n\r\nZahlungsweise\r\n------------------------------------------------------\r\n<-Payment_Modul_Text->\r\n\r\n<-Payment_Modul_Text_Footer->'); INSERT INTO `eorder_text` VALUES (2, 1, '<table id="AutoNumber3" cellspacing="0" cellpadding="10" width="100%" border="0" style="border-collapse: collapse"><tbody><tr><td width="100%"><font face="Arial"><strong><-STORE_NAME-><br /><br /><font size="2">Thank you for your custom!</font></strong></font><hr align="left" color="#000000" style="width: 281px; height: 1px" /> <p><font face="Arial"><font size="2">Your order number:</font> <strong><font size="2"><-insert_id-></font><br /></strong><em><font size="1">(Please quote your order number in any enquiry)</font></em></font></p><p><font face="Arial"><font size="2">Order Details: </font><br /><strong><font size="1"><-INVOICE_URL-></font></strong></font></p><p><font face="Arial" size="2">Date Ordered: <strong><-DATE_ORDERED-></strong></font></p><p><strong><font face="Arial" color="#ff0000"><br /><font size="2">Items ordered:</font></font></strong></p><table id="AutoNumber2" cellspacing="0" cellpadding="0" border="0" style="border-collapse: collapse"><tbody><tr><td width="100%" style="border-top-width: 1px; border-left-width: 1px; border-bottom: 1px solid; border-right-width: 1px"><font face="Arial"><-Item_List-></font></td></tr><tr><td width="100%"><b><font face="Arial"><-List_Total-></font></b></td></tr> </tbody></table><p> Comments: <-Customer_Comments-></p></td></tr></tbody> </table> <table id="AutoNumber1" cellspacing="0" cellpadding="10" border="0" style="border-collapse: collapse"> <tbody><tr><td valign="top" width="50%"><font face="Arial" size="2"><b><font color="#ff0000">Billing Address:<br /> </font></b></font><font face="Arial" size="2"><-BILL_Adress-></font></td><td valign="top" width="50%"><font face="Arial" color="#ff0000"><b><font size="2">Delivery Address:<br /></font></b></font><font face="Arial" size="2"><-DELIVERY_Adress-></font></td></tr></tbody> </table> <table id="AutoNumber4" cellspacing="0" cellpadding="10" width="100%" border="0" style="border-collapse: collapse"><tbody><tr><td width="100%"><font face="Arial" size="2"><b><font color="#ff0000">Payment Method:</font></b><br /><-Payment_Modul_Text-></font><p><font face="Arial" size="2"><-Payment_Modul_Text_Footer-></font></p></td></tr></tbody></table><table><tbody><tr><td><b>Terms and conditions</b><br /><font size="1">Your right to cancel:<p>We hope you will be happy with the products you have ordered, but in case you would like to return anything, these are your cancellation rights:</p><p>Under the United Kingdom''s Distance Selling Regulations, you generally have the right to cancel the contract and ask for a refund for items bought online within a period of 7 working days, beginning with the day after the day on which the item is delivered. This does not apply to video, DVD, audio, video games and software products where the item has been unsealed. Downloadable digital items cannot be cancelled or returned once downloading has commenced.</p><p>If you wish to cancel this contract, please pack the relevant item securely and send it back to us so that we receive it within 7 working days after the day of the date that the item was delivered to you. We recommend that you use a recorded-delivery service as if we do not receive them we will be unable to offer you a refund. Please note that you are responsible for the cost of return postage unless we sent you the wrong item or it is faulty.</p><p>We will refund the relevant part of the purchase price for the returned items provided they arrive within the cancellation period and, in the case of music, software and games have not been unsealed or opened.</p></p></font></td></tr><tr><td align="center"><font size="2"><p><-STORE_NAME-><br />Your store Address<br />Store Town<br />Store Postcode<br /><br />Store Tel<br />Store Email <br /> </p></font></td></tr></tbody> </table>'); INSERT INTO `eorder_text` VALUES (2, 3, '<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial><STRONG><-STORE_NAME-><BR><BR><FONT size=2>Vielen Dank fr Ihre Bestellung!</FONT></STRONG></FONT> <HR style="WIDTH: 281px; HEIGHT: 1px" align=left color=#000000> <P><FONT face=Arial size=2></FONT><FONT face=Arial><FONT size=2> Ihre Bestellnummer:</FONT> <STRONG><FONT size=2><-insert_id-></FONT><BR></STRONG><EM><FONT size=1>(Bitte bei Zahlungen und Anfragen stets angeben)</FONT></EM></FONT></P> <P><FONT face=Arial size=2></FONT><FONT face=Arial><FONT size=2> Ihre Detailierte Bestellbersicht: </FONT><BR><STRONG><FONT size=1><-INVOICE_URL-></FONT></STRONG></FONT></P> <P><FONT face=Arial size=2> Ihr Bestelldatum: <STRONG><-DATE_ORDERED-></STRONG></FONT></P> <P><STRONG><FONT face=Arial color=#ff0000><BR><FONT size=2>Ihre bestellten Artikel:</FONT></FONT></STRONG></P> <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; BORDER-BOTTOM: 1px solid; BORDER-RIGHT-WIDTH: 1px" width="100%"><FONT face=Arial><-Item_List-></FONT></TD></TR> <TR> <TD width="100%"><B><FONT face=Arial><-List_Total-></FONT></B></TD></TR></TBODY></TABLE> <P> </P></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 border=0> <TBODY> <TR> <TD vAlign=top width="50%"><FONT face=Arial size=2><B><FONT color=#ff0000>Ihre Rechnungsanschrift:<BR></FONT></B></FONT><FONT face=Arial size=2><B><FONT color=#ff0000><BR><BR></FONT></B><-BILL_Adress-></FONT></TD> <TD vAlign=top width="50%"><FONT face=Arial color=#ff0000><B><FONT size=2>Ihre Lieferanschrift:<BR></FONT></B></FONT><FONT face=Arial color=#ff0000><B><FONT size=2><BR><BR></FONT></B></FONT><FONT face=Arial size=2><-DELIVERY_Adress-></FONT></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial size=2><B><FONT color=#ff0000>Zahlungsweise:<BR><BR></FONT></B><BR><BR><BR><-Payment_Modul_Text-></FONT> <P><FONT face=Arial size=2><-Payment_Modul_Text_Footer-></FONT></P></TD></TR></TBODY></TABLE>'); INSERT INTO `eorder_text` VALUES (2, 2, '<TABLE id=AutoNumber3 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial><STRONG><-STORE_NAME-><BR><BR><FONT size=2>Vielen Dank fr Ihre Bestellung!</FONT></STRONG></FONT> <HR style="WIDTH: 281px; HEIGHT: 1px" align=left color=#000000> <P><FONT face=Arial size=2></FONT><FONT face=Arial><FONT size=2> Ihre Bestellnummer:</FONT> <STRONG><FONT size=2><-insert_id-></FONT><BR></STRONG><EM><FONT size=1>(Bitte bei Zahlungen und Anfragen stets angeben)</FONT></EM></FONT></P> <P><FONT face=Arial size=2></FONT><FONT face=Arial><FONT size=2> Ihre Detailierte Bestellbersicht: </FONT><BR><STRONG><FONT size=1><-INVOICE_URL-></FONT></STRONG></FONT></P> <P><FONT face=Arial size=2> Ihr Bestelldatum: <STRONG><-DATE_ORDERED-></STRONG></FONT></P> <P><FONT face=Arial size=2> Kommentar: <STRONG><-Customer_Comments-></STRONG></FONT></P> <P><STRONG><FONT face=Arial color=#ff0000><BR><FONT size=2>Ihre bestellten Artikel:</FONT></FONT></STRONG></P> <TABLE id=AutoNumber2 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 border=0> <TBODY> <TR> <TD style="BORDER-TOP-WIDTH: 1px; BORDER-LEFT-WIDTH: 1px; BORDER-BOTTOM: 1px solid; BORDER-RIGHT-WIDTH: 1px" width="100%"><FONT face=Arial><-Item_List-></FONT></TD></TR> <TR> <TD width="100%"><B><FONT face=Arial><-List_Total-></FONT></B></TD></TR></TBODY></TABLE> <P> </P></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber1 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 border=0> <TBODY> <TR> <TD vAlign=top width="50%"><FONT face=Arial size=2><B><FONT color=#ff0000>Ihre Rechnungsanschrift:<BR></FONT></B></FONT><FONT face=Arial size=2><B><FONT color=#ff0000><BR><BR></FONT></B><-BILL_Adress-></FONT></TD> <TD vAlign=top width="50%"><FONT face=Arial color=#ff0000><B><FONT size=2>Ihre Lieferanschrift:<BR></FONT></B></FONT><FONT face=Arial color=#ff0000><B><FONT size=2><BR><BR></FONT></B></FONT><FONT face=Arial size=2><-DELIVERY_Adress-></FONT></TD></TR></TBODY></TABLE> <TABLE id=AutoNumber4 style="BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=10 width="100%" border=0> <TBODY> <TR> <TD width="100%"><FONT face=Arial size=2><B><FONT color=#ff0000>Zahlungsweise:<BR><BR></FONT></B><BR><BR><BR><-Payment_Modul_Text-></FONT> <P><FONT face=Arial size=2><-Payment_Modul_Text_Footer-></FONT></P></TD></TR></TBODY></TABLE>'); Remains the EMAIL_TEXT_INVOICE_URL bug. Can anyone help me?
  5. bhbilbao

    [contribution] Send_order_html_email

    Instaled: + Order Editor (orders.php + edit_orders.php) + Manual Order Maker + Send HTML Email V2. little problems when receiving emails text: On email invoive link (EMAIL_TEXT_INVOICE_URL): The link is incorrect. Or the order status update http://www.myweb.com/account_history_info.php?order_id= (without the order number) or the new order-made http://www.myweb.com/admin/FILENAME_ACCOUNT_HISTORY_INFO?order_id=59 (without the define) twice bad. these corresponds to vartex2: $Vartext2 = ' ' . EMAIL_TEXT_ORDER_NUMBER . ' <STRONG> ' . $oID . '</STRONG><br>' . EMAIL_TEXT_DATE_ORDERED . ': <strong>' . strftime(DATE_FORMAT_LONG) . '</strong><br><a href="' . HTTP_SERVER . DIR_WS_CATALOG . 'account_history_info.php?order_id=' . $insert_id .'">' . EMAIL_TEXT_INVOICE_URL . '</a>' ; Also down a extrange simbol %s. Other time the comments dissapear for the text EMAIL_TEXT_COMMENTS_UPDATE Can anyone help me.
  6. bhbilbao

    [CONTRIBUTION] PDF Customer Invoice

    I have problems with the contribution http://addons.oscommerce.com/info/5322 It creates a invoice number when clicking on admin CREATE INVOICE NUMBER and writes data in database table FACTURAS (invoice_id, orders_id, invoice serial, invoice_number, date_invoice) When a customer goes to his acount_history_info and click to download the PDF, it GETS WITHOUT THE INVOICE_ID AND THE DATE_INVOCE (empty on white). I dont knonw how to modify pdfinvoice.php Code from my archive: require(DIR_WS_CLASSES . 'order.php'); $order = new order($HTTP_GET_VARS['order_id']); //contamos los items total de la factura - codigo facilitado por Eusebio $items_total = 0; $count_items_query = tep_db_query("select count(orders_products_id) as total from " . TABLE_ORDERS_PRODUCTS . " where orders_id = '" . (int)$order_id . "'"); $count_items = tep_db_fetch_array($count_items_query); $items_total += $count_items['total']; // set invoice date - today or day ordered. set in config $date = (PDF_INV_DATE_TODAY == 'today') ? strftime(DATE_FORMAT_LONG) : tep_date_long($order->info['date_purchased']); if($order->billing['invoice_serial'] . $order->billing['invoice_number_pad'] != ''){ $pdf->Text(10,70, PRINT_INVOICE_HEADING_2 . ': ' . $order->billing['invoice_serial'] . $order->billing['invoice_number_pad'],0,'L'); }
  7. bhbilbao

    Multi_Vendor_Shipping new thread

    But why the PDF Customer Invoice works fine in acount_history_info???? (Im refering to PDF Customer Invoice v1.3 2009/01/03 that is similar or the same as PDF Admin Invoice)
  8. bhbilbao

    Ultimate Osc Translator

    This is the other code in may product_info.php: // Light Box J Query with ultra Pics 2.08 Add on BOF if ($custom_computer['products_model'] == "Custom"){ $product_info_query = tep_db_query("select p.products_weight, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); }else{ $product_info_query = tep_db_query("select p.products_weight, p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, p.products_image_med, p.products_image_lrg, p.products_image_sm_1, p.products_image_xl_1, p.products_image_sm_2, p.products_image_xl_2, p.products_image_sm_3, p.products_image_xl_3, p.products_image_sm_4, p.products_image_xl_4, p.products_image_sm_5, p.products_image_xl_5, p.products_image_sm_6, p.products_image_xl_6, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'"); } // Light Box J Query with ultra Pics 2.08 Add on EOF ... <!-- Light Box J Query with ultra Pics 2.08 Add on BOF --> <?php $small_image = $product_info['products_image']; $popup_image = $product_info['products_image_med']; if ($popup_image == '') $popup_image = $small_image; echo '<a href="' . tep_href_link(DIR_WS_IMAGES . $popup_image) . '" target="_blank" rel="prettyOverlay[gallery]" title="' . $product_info['products_name'] . '">' . tep_image(DIR_WS_IMAGES . $small_image, $product_info['products_name'], 0, 200, 'hspace="1" vspace="1"') . '<br/>' . tep_image_button('image_enlarge.gif', TEXT_CLICK_TO_ENLARGE) . '</a>'; ?> <!-- Light Box J Query with ultra Pics 2.08 Add on BOF --> .... <?php // Light Box J Query with ultra Pics 2.08 Add on BOF if (ULTIMATE_ADDITIONAL_IMAGES == 'enable') { include(DIR_WS_MODULES . 'additional_images.php'); } // Light Box J Query with ultra Pics 2.08 Add on EOF ?> I also readed the documentation said Burt.(conflicts). But I dont know how to apply those fixes. It say to write them at the end of jquery, but nothing happens. By the way, is there any contribution to take only one product_description(for example the spanish) and with it, the other languages take that description.??? The description sizes are higher to the rest items in the online database. My host only give to me a 100MB dB. I have menus and buttons translated to espanol/english/german and i want to maintain them. But when im editing the product if i give the decription box empty of an expecific language, then in the shop will be empty. I thought to write only one description for all languages and with this mod translate the others.(Less work and less MB of dB). I dont care about the 80% translate rate.
  9. bhbilbao

    Multi_Vendor_Shipping new thread

    I have problems in this contribution with PDF ADMIN INVOICE. Making and order on web with the normal shoping process , when clickig create PDF on admin it works. But if the customers uses MVS options and finalice the order. Then in admin I click on CretePDF and there is not products. All cell in white!!! (extrange) The lines of pdf_invoice.php are these: //Show the products information line by line . . $pdf->MultiCell(18,6,$order->products[$i]['model'],1,'L', '1'); . . $pdf->MultiCell(9,6,$order->products[$i]['qty'],1,'C', '1'); . . $pdf->MultiCell(128,6,substr($order->products[$i]['name'],0,60),1,'L', '1'); . . etc.
  10. bhbilbao

    pdf invoices for admin only

    I have problems in this contribution with the MVS(MultiVendorShiping). Making and order on web with the normal shoping process , when clickig create PDF on admin it works. But if the customers uses MVS options and finalice the order. Then in admin I click on CretePDF and there is not products. All cell in white!!! (extrange) The lines of pdf_invoice.php are these: //Show the products information line by line . . $pdf->MultiCell(18,6,$order->products[$i]['model'],1,'L', '1'); . . $pdf->MultiCell(9,6,$order->products[$i]['qty'],1,'C', '1'); . . $pdf->MultiCell(128,6,substr($order->products[$i]['name'],0,60),1,'L', '1'); . . etc.
  11. bhbilbao

    Ultimate Osc Translator

    I dont knew that translate the 80% of the test. One problem less. These are my scripts before the </head> tag: <script language="javascript"><!-- function popupWindow(url) { window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,resizable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,left=150') } function popupPricematch(url) { window.open(url,'popupPricematch','toolbar=no,status=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,resizable=yes,copyhistory=no,width=500,height400,screenX=10,screenY=150,top=10,left=150') } //--></script> <?php // MVS Shipping Estimator Start ?> <script language="javascript" type="text/javascript"><!-- function estimatorpopupWindow(URL) { window.open(URL,'productsshippingestimator','toolbar=0,scrollbars=1,location=0,statusbar=0,menubar=0,resizable=1,width=800,height=600') } //--></script> <?php // MVS Shipping Estimator End ?> <script type="text/javascript"> function TamFonte(num, id) { document.getElementById(id).className = "ft"+num; } </script> <link rel="stylesheet" href="lightbox.css" type="text/css" media="screen" /> <link rel="stylesheet" type="text/css" href="stylesheet.css"> <script type="text/javascript" src="js/prototype.js"></script> <script type="text/javascript" src="js/scriptaculous.js?load=effects,builder"></script> <script type="text/javascript" src="js/lightbox.js"></script> <!-- Light Box J Query Add on BOF --> <link rel="stylesheet" href="lightbox/prettyPhoto.css" type="text/css" title="prettyPhoto main stylesheet" charset="utf-8" /> <script src="lightbox/jquery-1.2.3.pack.js" type="text/javascript" charset="utf-8"></script> <script src="lightbox/prettyPhoto.js" type="text/javascript" charset="utf-8"></script> <!-- Light Box J Quesry Add on EOF --> I replaced $(document).ready(function(){ to jQuery(document).ready(function(){ on pretyphoto.js The translator works fine. But the popup photo doesn´t work (its open in other tab or window) I think that the problem is the archive prototype1.6.js. Could be a problem having diferent versios of it??? If I remove the line <script type='text/javascript' src="/osc_translater/prototype1.6.js"></script> of your code, popup prety photo works fine but not the translator. I also try to write the scripts before the <head> tag. Also renaming src="/osc_translater/prototype1.6.js to src="js/prototype.js Only works the translator or the popup.
  12. bhbilbao

    Ultimate Osc Translator

    I tried two manners but nothing. I have problems with the products description that has html code like <li> or <div>. This part dosnt translate. In other hand, it translate half the normal text. i dont know why worked for a moments, but nothing now.
  13. bhbilbao

    Ultimate Osc Translator

    Now it works!!!!! Do this contribution translate all words??? I see that some latin words like "magnética" with the acentuation do not traslate. ¿? But now the lightbox popup dosnt work. And Pricematch contribution works extrange.
  14. bhbilbao

    Ultimate Osc Translator

    For people that dosnt work this contribution Im were using other translate box: <td class="main"><script src="http://www.gmodules.com/ig/ifr?url=http://www.google.com/ig/modules/translatemypage.xml&up_source_language=es&w=160&h=60&title=&border=&output=js"></script></td> But this looks better.
  15. bhbilbao

    Ultimate Osc Translator

    Yes , i saw where to put the folder on href="osc_translater/translater.css" But it dont works. In my root I have 2 folders lightbox and js. And inside the lightbox/ folder the archive prettyPhoto.js $(document).ready(function(){ prettyPhoto.init(); }); prettyPhoto = { options : { 'animationSpeed' : 'fast', /* fast/normal/slow */ 'padding' : 0 /* padding for each side of the picture */ }, init : function(){ // Find all the images to overlay prettyPhoto.imagesArray = []; $("a[rel^='prettyOverlay']").each(function(){ prettyPhoto.imagesArray[prettyPhoto.imagesArray.length] = this; $(this).bind('click',function(){ prettyPhoto.open(this); return false; But is diferent to the code you write before. I tried to modify it but it donst work. I have other contribution instaled: "Increase and decrease the size of the text in the description of the products - Font size By APOPULAR.zip" I tried playing with the <divs> and it translate half of the text. P.D: Referente a "Hala Madrid!" "Soy más informático que futbolero" :D
  16. bhbilbao

    Ultimate Osc Translator

    clicking the flag nothings happens. Sorry Ronrrico , but what archive or archives should be modified??? EventDispatcher.js??? prototype1.6.js??? translater.css??? product_info.php??? The "osc_translater" folder must be copied as it in the root or the archives inside it?????
  17. bhbilbao

    Multi_Vendor_Shipping new thread

    Because in the pulldown there is only one option available "REPORT_ALL". I want to report the list of one specific vendor and print preview him. This could be made with orders_by_vendor.php but I want all the optios working. I don´t kwow if this option is available because in the right papel of vendors.php appears "This vendors ordes - (Coming Soon)" Now I have other problem with vendor_email_send.php: Send Vendor Email The body of the email will look like this, this is what your Vendor will see when they open the email: bla, bla, bla. I write on the box and then click on Preview, and finally in the next page "SEND EMAIL". It appears a red line on top that said "Contact" but noting happens. In other hand, this contribution is great and works fine except this minors "bugs" that dosnt work with me.
  18. bhbilbao

    Multi_Vendor_Shipping new thread

    Thanks Jim. I´ll try soon you said me. Now Im fighting with other piece of code in stats_sales_report2.php I modified to this: <?php echo REPORT_VENDOR_FILTER; ?><br> <select name="vendor" size="1"> <option value="0"><?php echo REPORT_ALL; ?></option> <option value="1"><?php echo 1; ?></option> <option value="2"><?php echo 2; ?></option> <option value="3"><?php echo 3; ?></option> <option value="4"><?php echo 4; ?></option> <option value="5"><?php echo 5; ?></option> <option value="6"><?php echo 6; ?></option> <?php foreach ($sr->vendor as $value) { ?> <option value="<?php echo $value["vendors_id"]?>"<?php if ($srVendor == $value["vendors_id"]) echo "selected"; ?>><?php echo $value["vendors_name"] ; ?></option> <?php } Nothing happens when i change the vendor and click send.
  19. bhbilbao

    Multi_Vendor_Shipping new thread

    Sorry, is changing /includes/functions/database.php (not the general.php) I found other solution configuring php.ini to this(without changing the update): register_globals = on [b]output_buffering = on output_buffering = 4096[/b] error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE & ~E_STRICT);
  20. bhbilbao

    Multi_Vendor_Shipping new thread

    I found a solution in general.php by removing osCommerce update 051113 (thanks to Fredrik.r!); From function tep_db_input($string, $link = 'db_link') { global $$link; if (function_exists('mysql_real_escape_string')) { return mysql_real_escape_string($string, $$link); } elseif (function_exists('mysql_escape_string')) { return mysql_escape_string($string); } return addslashes($string); } to function tep_db_input($string) { return addslashes($string); } It works! But, could be this dangerous(removing the update)???
  21. bhbilbao

    Multi_Vendor_Shipping new thread

    Need help! I read all the pages with diferent solutions but it didnt work. I get this error at final of checkout process (checkout_process.php). Warning: mysql_real_escape_string() expects parameter 1 to be string, array given in xxxxxxxxxxx /includes/functions/database.php on line 130 and after a seconds Warning: Cannot modify header information - headers already sent by (output started at xxxxxx/includes/functions/database.php:130) in /xxxxxxxxxxxxxx/includes/functions/general.php on line 64 I look for the email and the order is OK. But at the end of process this ugly error with the blank page. I review for white spaces before and after <php php>? (this is ok) The problem is in checkout_process.php, at line aprox. 130 130 'shipping_module' => $shipping['id'], if i remove that line all works fine. Can anyone help me, please???
  22. I have a problem importing SQL. It gives an error. #1062 - Duplicate entry '1001' for key 1 I tried to to change configuration_id to INT(15), UNSIGNED, AUTO-INCREMENT, etc. I also try REPAIR TABLE configuration QUICK; What is the problem???
  23. bhbilbao

    Custom Computer Creator v9 Support

    Sorry with the link: www*yourhost*com/admin/categories.php?pID=xxx&action=new_product
  24. bhbilbao

    Custom Computer Creator v9 Support

    More problems: Ajax Buy Now doesn´t work with Custom Computer Creator [custom_checkout.php] Nothing happens when hit to add to basket. Has somebody a fix to it??? the #3 is fixed: 1)Go to CCC Config 2)Default estatus for builds=1 3)Then go to the product en edit it.(look the products_id=xxx) 4)Put again the estatus for builds=0 then go to: http://www.xxxxxx.com/admin/categories.php?pID=xxx&action=new_product (change the xxx with product_info code) If change the ref, name or description it will be deleted. But if you edit again it will maintain the description, links or other pictures.
  25. bhbilbao

    Ajax Buy Now

    Ajax Buy Now doesn´t work with Custom Computer Creator [custom_checkout.php] Nothing happens when hit to add to basket. Has somebody a fix to it??? Other problem is product_info.php Ajax buy doesn´t work here, it refreshes all the page, but it works on product_listing.php I have PRICE_EXCL contrib installed. My product_info.php <td width="220" align="right" valign="middle" class="infoBoxContents"> <?php echo tep_draw_hidden_field('products_id', $product_info['products_id']) . tep_image_submit('button_in_cart.gif', IMAGE_BUTTON_IN_CART); ?> </td>
×