Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ocs1409

Members
  • Content count

    39
  • Joined

  • Last visited

Everything posted by ocs1409

  1. 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
  2. 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 ) 👍
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  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. 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
  11. Feel free to support this contribution or to develope more funtions
  12. 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
  13. install this contribution : http://addons.oscommerce.com/info/3115 greet eric
  14. 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
  15. ocs1409

    [Addon} Modular SEO Header Tags

    hi jim thanks for the great add on 1 with regard to the google metatags i am missing : - revisit after ( days / months ) - author - canonical - language ( nl,en,fr etc. ) - copyright 2 is it possible to include the metatag 'keywords' in a module because several dutch search engines use the tag thanks eric
  16. hello i am using search tag cloud contribution ( http://addons.oscommerce.com/info/5498 ) in the install.txt 2) includes/modules/product_listing.php ***************************************************************************** Search for around Line 150: Find: $list_box_contents[$cur_row][] = array('align' => $lc_align, 'params' => 'class="productListing-data"', 'text' => $lc_text); } } And Add after new lines: //BOF: Search Tag Cloud v2.4 by darkamex if (($_GET['keywords'] != '')) { $search_count = tep_db_query("select search, freq from customers_searches where search = '". $_GET['keywords'] . "' and language_id='". $languages_id . "'"); if (!tep_db_num_rows($search_count)) { tep_db_query("insert into customers_searches (search, freq, language_id) values ('". tep_db_input($_GET['keywords']) ."',1," .$languages_id." )"); } else { $search_val = tep_db_fetch_array($search_count); tep_db_query("update customers_searches set freq = " . ($search_val['freq']+1) . " where search = '". tep_db_input($_GET['keywords']) . "' and language_id='". $languages_id . "'"); } } //EOF: Search Tag Cloud v2.3 by faaliyet i have searched in the product_listing.php module there are more then 1 lines with the code :blink: where should the search tag cloud code be placed to update the search phrases in the database file :D eric
  17. hello i have just installed oscommerce rc2a with the following contributions : seperate pricing per customer 4.2.2 and SPPC pricebreaks v2. after installing option type in admin everything worked ok. i also get produkt_info.php installed and working. but after choosing a tex or textarea atribute the shopping cart stays empty. <_< the problem lies in the fact that the attribute code in several php files are so much different from original ocs rc2a that i can not make anything out of it to replace it with the code from the option type v2contribution. has anyone installed all 3 contributions ?? please give me a solution or the correct code to use all 3 contributions together :D many,many thanks eric
  18. ocs1409

    [Contribution] Option Types v2

    hello i have just installed oscommerce rc2a with the following contributions : seperate pricing per customer 4.2.2 and SPPC pricebreaks v2. after installing option type in admin everything worked ok. i also get produkt_info.php installed and working. but after choosing a tex or textarea atribute the shopping cart stays empty. <_< the problem lies in the fact that the attribute code in several php files are so much different from original ocs rc2a that i can not make anything out of it to replace it with the code from the option type v2contribution. has anyone installed all 3 contributions ?? please give me a solution or the correct code to use all 3 contributions together :rolleyes: many,many thanks eric
  19. ocs1409

    NEW! Complete Order Editing Tool!

    i have the lastest order editor installed 5.0.6.1. and among other contributions fancier invoice and packing slip this contribution also send a invoice when a order is placed in checkout_process.php my question is, is it possible to send the email invoice instead of the text email when the administrator hits the new order email greetings eric
  20. i have updated to 3.5 but but still i get no shopping cart info on the who on line page if have check the both configure.php but they have the same : define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' in the configuration of store in sessions Sessies Sessies-directory tmp Forceer cookiegebruik False Controleer SSL sessie-ID False Controleer browser user False Controleer IP-adres user False Block spiders False Recreat sessie True thanks B)
  21. i have updated to 3.5 but but still i get no shopping cart info on the who on line page if have check the both configure.php but they have the same : define('STORE_SESSIONS', ''); // leave empty '' for default handler or set to 'mysql' in the configuration of store in sessions Sessies Sessies-directory tmp Forceer cookiegebruik False Controleer SSL sessie-ID False Controleer browser user False Controleer IP-adres user False Block spiders False Recreat sessie True thanks B) Sessies-directory Wijzigen Als sessies niet via de database gaan, sla dan de sessie-bestanden op in deze directorie Toegevoegd op: 12.04.2008 Laatst ge
  22. ocs1409

    Orders at-a-glance

    hello i have just installed orders at a glance v4 and i have sexy admin installed the trouble is that if a move to orders id and try to read orders at a glance the info is printed at the top left corner of the screen can anyone help to correct this ? :-" eric
  23. does anyone has a solution to give a customer a discount percentage on different catogories within seperate pricing per customer 4.2.0. thanks
×