-
Posts
308 -
Joined
-
Last visited
-
Days Won
1
Posts posted by bhbilbao
-
-
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.
-
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'); }
-
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)
-
You do this change in product_info.php
You should have a piece of javastript pertaining to prettyphoto in product_info.php
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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.
-
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
-
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?????
-
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.
-
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.
-
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);
-
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)???
-
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???
-
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???
-
Sorry with the link:
www*yourhost*com/admin/categories.php?pID=xxx&action=new_product
-
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.
-
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>
-
Registered an account just to post my little bit.
I managed to get SEO URL's and Buy Now working together by editing one of the files included in seo urls.
Open includes/classes/seo.class.php
Look for the two return $link;
Comment out or replace both with
// AJAX Addto shopping_cart - Begin $link_ajax = ''; if( tep_not_null($parameters) && preg_match("/buy_now/i", $parameters) && $page != 'ajax_shopping_cart.php'){ $link_ajax = '" onclick="doBuyNowGet(\'' . tep_href_link( 'ajax_shopping_cart.php', $parameters, $connection, $add_session_id, $search_engine_safe) . '\'); return false;'; } return $link . $link_ajax; // AJAX Addto shopping_cart - End
Mine looks like the following
switch($this->attributes['SEO_URLS_USE_W3C_VALID']){ case ('true'): if (!isset($_SESSION['customer_id']) && defined('ENABLE_PAGE_CACHE') && ENABLE_PAGE_CACHE == 'true' && class_exists('page_cache')){ //return $link; // AJAX Addto shopping_cart - Begin $link_ajax = ''; if( tep_not_null($parameters) && preg_match("/buy_now/i", $parameters) && $page != 'ajax_shopping_cart.php'){ $link_ajax = '" onclick="doBuyNowGet(\'' . tep_href_link( 'ajax_shopping_cart.php', $parameters, $connection, $add_session_id, $search_engine_safe) . '\'); return false;'; } return $link . $link_ajax; // AJAX Addto shopping_cart - End } else { return htmlspecialchars(utf8_encode($link)); } break; case ('false'): //return $link; // AJAX Addto shopping_cart - Begin $link_ajax = ''; if( tep_not_null($parameters) && preg_match("/buy_now/i", $parameters) && $page != 'ajax_shopping_cart.php'){ $link_ajax = '" onclick="doBuyNowGet(\'' . tep_href_link( 'ajax_shopping_cart.php', $parameters, $connection, $add_session_id, $search_engine_safe) . '\'); return false;'; } return $link . $link_ajax; // AJAX Addto shopping_cart - End break; } } # end function
It's probably not optimal or even neccessary to replace both but I have no idea what I'm doing so I thought it best.
Also, adding buy now to the product_listing.php page, I assume I only need once instance of the form to cover the entire table? I know little php but I've done enough programming to mash something together.
echo '<td align="center" valign=bottom width=33%><table align="center" border=0 width=100%><tr><td align="center" valign=top>'.$lc_text.'</td></tr><tr><td align="center" valign="bottom"><br>'.$prod_name.'<br>Price : ' . $lc_text_price.'<br>' . tep_draw_form('cart_quantity', tep_href_link(FILENAME_PRODUCT_INFO, tep_get_all_get_params(array('action')) . 'action=add_product')) .tep_draw_hidden_field('products_id', $listing['products_id']) . tep_image_submit('button_buy_now.gif', IMAGE_BUTTON_BUY_NOW).'</form><br><br></td></tr></table></td>';
Is what I have currently, obviously I'm drawing a new form for each buy now part, to me it looks like I can remove the form and only have one covering the table?
Website is here Crystal Planet for an example.
Hope this helps some of you!
-
Congratulations.
But 3 minor problems:
1)With contribution "Next - Previous whith detailed".
PHP Error Message on product_info.php
Warning: implode() [function.implode]: Invalid arguments passed in /********/public_html/includes/functions/general.php on line 273
This error happens because de "Custom" category doesn´t exist. How can I jump this error??. It could be right to create a dummy category or something????
2) After order nothing appear in "Pending Builds" in admin menu. Don´t know what is the build.
3) How can I delete builds from catalog. ( If I know the .....product_info.php?products_id=xxx).
Thanks in advance.
-
Finally I give away with the Enable-Disable Categories.
I have 2 minor probles.
When I select a product and click on Info Button it goes to de index.php page and not load de information page of the product (builder_component_info.php).
Im looking for change the code:
//----------------- Show Description --------------- function show_desc(row){ row++; if (recid[row]) window.open ("<?php echo FILENAME_BUILDER_COMPONENT_INFO; ?>?products_id="+recid[row]+"&osCsid=<?php echo $osCsid;?>",'','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=yes,re sizable=yes,copyhistory=no,width=600,height=600,screenX=150,screenY=150,top=150,l eft=150');return(false); } </script>
or this one??
document.write ('<?php echo tep_image(DIR_WS_IMAGES . "scroll.gif", '', 20, 18, 'align=absmiddle');?>'); document.write ("</th>"); document.write ("<th onClick=\"oFrame.style.display='none'\" valign=center><input type=\"button\" value=\"info\" style=\"border: #C4B0AB 1px solid; background-color: #F1F1F1; color: #5C5C5C; font-weight: bold\" onclick='show_desc("+indx+")'></th>"
The other problem are the dependences, they work OK, but looking very weird. I tried with IE but the same thing.
Other day the dependences looked Ok in IE with the red/green colors. But nothing now. why??
Can anyone help me????
[contribution] Send_order_html_email
in General Add-Ons Support
Posted
Corrected in admin/includes/languages/xxx/order.php and edit_order.php: (the simbol %s)
Replaced
for
Corrected in admin/order.php and edit_order.php: (appears as EMAIL_TEXT_COMMENTS_UPDATE)
Replaced
for
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):
P.d: also looked to have installed the database tables eorder_text
Remains the EMAIL_TEXT_INVOICE_URL bug.
Can anyone help me?