Jump to content

ocs1409

Members
  • Content count

    36
  • Joined

  • Last visited

Profile Information

  • Real Name
    eric
  • Gender
    Male

Recent Profile Visitors

10,910 profile views
  1. 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
  2. hello i have downloaded and installed the latest CE Phoenix as my webshop. it feels familar and easy to use but i am missing the possibility to have a modular product listing something like the modules for the index page. i have seached the apps section and forum but i could not find anything. it is easy to shuffle the content around and to add content as needed my question is : has anyone has a idea or propasal to program this in CE phoenix ? thanks eric
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. Hello my name is Ron, i need put the link in the header menu, you know put? my email is entre2lineas@hotmail.com

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

    PDF Invoice Help Please...

    install this contribution : http://addons.oscommerce.com/info/3115 greet 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. ocs1409

    [Addon} Modular SEO Header Tags

    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
×