Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ocs1409

Members
  • Posts

    39
  • Joined

  • Last visited

Profile Information

  • Real Name
    eric
  • Gender
    Male

Recent Profile Visitors

12,326 profile views

ocs1409's Achievements

  1. hello yes we are one the same page. but the frontpage gives several errors on the images being not correctly sized that is why it gives a lower pagespeed in google as i said it is a dev and not a final release of V4 if i look at the term and conditions page and let this page be analysed by google pagespeed there is no problem ( only text ) 👍
  2. hallo thanks for the explain as it is a dev ( always errors 😎 ) and with only text ( term-conditions ) it gets the mobile 94 and desktop 97 the rest of pages depends on the speed of the images i will wait for the beta/stable version to get my hands on. hoping on sooner than later thanks eric
  3. hallo i have ran a google PageSpeed Insights with https://www.trueloaded.co.uk/. this is the precessor of oscommerce v4 as i read in the forum. the result is mobile 87 and desktop 99. my question is : will oscommerce v4 get a boost to get mobile ranking on a higher level ? because all SEO experts say that after SEO products etc speed is one way to get a better ranking my development of oscommerce 2.4.2 currently has a score of mobile 97 and desktop 99 thanks eric
  4. hi frank do you know where the undescores are created ( which php ) or is it harcoded in php ? thanks greetings eric
  5. hello i have installed the addon works great only i have noticed that in the url the last hyphen for a subcategory is the underscore ( _ ) and not the minus sign (-) for example : mydomain.com//latex-muurverf-muurverf-voor-binnen-c-22_28.html is this correct ? greetings eric
  6. hello like the contrib and i have already integrated in my shop i am trying to port this addon to a contrib for edit order with bootstrap in order to add products to the order i trying to add products via a modal popup with this input : <div class="form-group"> <label for="search" class="col-xs-3"> <b>- Of geef zoekopdracht in om matches te zien -</b> </label> <div class="col-xs-9"> <input class="form-control" data-provide="typeahead" autocomplete="off" type="text" name="search" id="search" placeholder="" /> </div> </div> the script for typeahead : <script type="text/javascript"> $("#search").typeahead({ source: function( query, process ) { $.ajax({ url: '<?php echo DIR_FS_ADMIN ; ?>search.php', type: 'post', data: 'query='+ query, datatype: 'JSON', async: true, success: function(data) { process(data) ; } } ) } }); </script> the search.php : <?php require('includes/application_top.php'); $like_statement = $HTTP_POST_VARS[ "query" ] ; // also tried $_POST and $_REQUEST $results= array() ; $autoComplete = tep_db_query("SELECT distinct(p.products_id), pd.products_name, p.products_price, p.products_tax_class_id FROM products_description pd, products p WHERE pd.products_name like '%".$term ."%' AND pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_status limit 6"); $list = tep_db_num_rows($autoComplete); if($list > 0) { while($value = tep_db_fetch_array($autoComplete)){ $row_array['mmsi'] = $row['products_id']; $row_array['name'] = $row['products_name']; array_push($results,$row_array); } } echo json_encode($results, JSON_FORCE_OBJECT); ?> i have typeahead 0.11.1 js and css include in template_top.php do you have a idea what is wrong ?? greet eric
  7. hello i am programming my modified site with among seo url and header tags 3.0 to work with multiple sites contrib 1730. everything work ok but if seo url is turned on i get "The page isn't redirecting properly" a problem with cookies if i turn off seo everything works correct the contrib add stores_id to products, categories, manufacturer etc which is saved in the configuration table can anyone help ? greet eric
  8. hello suddenly everyone is moving from Msql_query to Msqli_query in order to work with Msqli_query can all msql_**** commands and functions be replaced with the corresponding Msqli_**** commands and funtion for example from admin/includes/modules/database_optimizer_common.php /*********************** REMOVE FROM CUSTOMER TABLES *****************************/ if (! empty($config['customers']) && $config['customers'] < $daysLastRan) { $dateCustomers = date("Ymd", time() - ($config['customers'] * 86400)); $wasUpdated = true; $message .= "\r\n" . 'Customers tables were trimmed.'; mysql_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE (`products_id`, `customers_id`) in (select `products_id`, `customers_id` from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "')"); mysql_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "'"); //clear the customers basket table of entries greater than one month old mysql_query("update database_optimizer set customers_last_update = now()"); } change to /*********************** REMOVE FROM CUSTOMER TABLES *****************************/ if (! empty($config['customers']) && $config['customers'] < $daysLastRan) { $dateCustomers = date("Ymd", time() - ($config['customers'] * 86400)); $wasUpdated = true; $message .= "\r\n" . 'Customers tables were trimmed.'; mysqli_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " WHERE (`products_id`, `customers_id`) in (select `products_id`, `customers_id` from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "')"); mysqli_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_basket_date_added < '" . $dateCustomers . "'"); //clear the customers basket table of entries greater than one month old mysqli_query("update database_optimizer set customers_last_update = now()"); } greetings eric
  9. a question if i order a product which is not on stock or stock is not sufficient for the delivery i get a parse error and the complete page with info goes complete screwed is there a solution ??? greetings eric
  10. hello first of all many thanks for this great contribution i have installed it together with sppc. the problem is that i would like to update the gross and net price of all price breaks prices similar to the solution which was mentioned on page 38 ( http://www.oscommerce.com/forums/topic/220794-quantity-price-breaks/page__st__740 ) but i can get it working. can someone give met the right code for this problem ? many thanks eric
  11. Hello my name is Ron, i need put the link in the header menu, you know put? my email is [email protected]

  12. hi i have installed track and trace contribution 3736 in this contribution the problem is if i use the non-ajax version it works well in the ajax version it is working except for the part where i want to save the data for the table order_history the filled in $track_num and $track_pcode are not stored the code i use in admin/edit_orders_ajax.php is : //SADESA ORDER TRACKING // tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values // ('" . tep_db_input($_GET['oID']) . "', // '" . tep_db_input($_GET['status']) . "', // now(), " . // tep_db_input($customer_notified) . ", '" . // oe_iconv($_GET['comments']) . "')"); tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, track_num, track_pcode, comments) values ('" . tep_db_input($_GET['oID']) . "', '" . tep_db_input($_GET['status']) . "', now(), " . tep_db_input($customer_notified) . ", '" . tep_db_input($_GET['track_num'])) . "', '" . tep_db_input($_GET['track_pcode']) . "', '" . oe_iconv($_GET['comments']) . "')"); //SADESA ORDER TRACKING the code used in admin/edit_orders.php is //SADESA ORDER TRACKING // tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, comments) values ('" . tep_db_input($_GET['oID']) . "', '" . tep_db_input($_POST['status']) . "', // now(), " . tep_db_input($customer_notified) . ", '" . tep_db_input(tep_db_prepare_input($_POST['comments'])) . "')"); tep_db_query("INSERT into " . TABLE_ORDERS_STATUS_HISTORY . " (orders_id, orders_status_id, date_added, customer_notified, track_num, track_pcode, comments) values ('" . tep_db_input($_GET['oID']) . "', '" . tep_db_input($_POST['status']) . "', now(), " . tep_db_input($customer_notified) . ", '" . tep_db_input(tep_db_prepare_input($_POST['track_num'])) . "', '" . tep_db_input(tep_db_prepare_input($_POST['track_pcode'])) . "', '" . tep_db_input(tep_db_prepare_input($_POST['comments'])) . "')"); //SADESA ORDER TRACKING in the file edit_orders_ajax.php i already changed $_get with $http_get_vars etc but no luck greetings eric
  13. Feel free to support this contribution or to develope more funtions
  14. Hi ocs1409, The sql update of PDF Invoice keeps giving problems. I managed several typo's, but was never succesfull to import. Can you please review the package and upload a working sql file??

    Thanks

  15. hello if you get a message that the zip file is not found on the server replace http://de3 with http://www. and presto you can download the add on greetings eric
×
×
  • Create New...