Latest News: (loading..)

ocs1409

Members
  • Content count

    29
  • Joined

  • Last visited

About ocs1409

Profile Information

  • Real Name
    eric
  • Gender
    Male
  1. hi frank do you know where the undescores are created ( which php ) or is it harcoded in php ? thanks greetings eric
  2. hi manfred like the idea and additional addons :thumbsup: but in your demo i get in product_info.php : 1054 - Unknown column 'pd.products_tab_1' in 'field list'
  3. 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
  4. hello can not wait to see the beta version for download just one question : where can i read about apps / hooks and how they change the way to extend the core code in comparison with the current modules for content, payment etc. thanks eric
  5. hello looking at the start for a responsive admin from gl walker. i liked the looks and feel of this responsive design for my webshop i also needed a multi store admin. the result is multi store responsive shop and admin with more than 120 addons along with gl walkers design i also mixed in some elements from TSIMI and Gergely bs admin Addons are to name a few : - seperate prices per customer groups ( plus all addons ) SPPC - html emails for new customer, orders etc - multi store but can be used as single shop of cource - content modules for index, product info, contact us etc - option type for products - SEO urls - Headertags - JAVA ans CSS can loaded from own site or from a CDJNS - add new order - Supertracker etc i am now at a point that i am a little developer blind. so a fresh pair of eyes should be helpful All code is from 2.3.4 and 2.3.4. gold. All addons are based on 2.3.4 the files can be found at https://github.com/nieuw1409/admin_responsive thanks to everybody who made the original addons without them i never could put this together greeting 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. sounds great i have sppc already integrated but with normal code in the front and backend of several shops will the future version of sppc have the same functionality as the last version of sppc is is possible to extends this with the addons for sppc like qtpro for sppc or admin specials by categories for sppc see images greet eric category customer groups products customer group customergroups customers customer edit
  8. hello i like the idea i have downloaded the latest 234 BS i could locate the email preview in tools but when i tried one of the options i get Hops! Data not found yet. i searched modules but could not find a option to install the email pages where can i activate the different email ? greeting eric
  9. hi gergely like the idea for bs admin side i already made a start with the idea placing the column_left in de header to obtain more space in the content area where did you place the files you have changed ? do you have a picture of the changes ? greet eric
  10. i like the setup and the new looks of the admin side are the latest files already on github ? keep up the hard work
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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