Jump to content

ocs1409

Members
  • Content count

    39
  • Joined

  • Last visited

Profile Information

  • Real Name
    eric
  • Gender
    Male

Recent Profile Visitors

11,195 profile views
  1. ocs1409

    google PageSpeed Insights

    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. ocs1409

    google PageSpeed Insights

    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. ocs1409

    google PageSpeed Insights

    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. hello has anyone tried or tested or implemented the brotli compression method instead of the gzip ? i have seen that this is available in the php 7.3 exteension of my webhoster thanks eric
  5. ocs1409

    ULTIMATE Seo Urls 5 - by FWR Media

    hi frank do you know where the undescores are created ( which php ) or is it harcoded in php ? thanks greetings eric
  6. ocs1409

    ULTIMATE Seo Urls 5 - by FWR Media

    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
  7. ocs1409

    Store Search Bar (BS)

    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
  8. ocs1409

    ULTIMATE Seo Urls 5 - by FWR Media

    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
  9. ocs1409

    Database Optimizer

    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
  10. 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
  11. ocs1409

    Quantity Price Breaks

    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://forums.oscommerce.com/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
  12. Hello my name is Ron, i need put the link in the header menu, you know put? my email is entre2lineas@hotmail.com

  13. ocs1409

    NEW! Complete Order Editing Tool!

    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
  14. ocs1409

    PDF Invoice Help Please...

    install this contribution : http://addons.oscommerce.com/info/3115 greet eric
  15. Feel free to support this contribution or to develope more funtions
×