Latest News: (loading..)

mcmannehan

Members
  • Content count

    199
  • Joined

  • Last visited

  • Days Won

    1

mcmannehan last won the day on February 23

mcmannehan had the most liked content!

4 Followers

About mcmannehan

  • Rank
    That's Me
  • Birthday 12/07/1960

Profile Information

  • Real Name
    Manfred Wedel
  • Gender
    Male
  • Location
    Thailand

Recent Profile Visitors

3,461 profile views
  1. PHP 5.6 support is finish on 31.12.2018. So it's highly recommanded to Upgrade. The next problems will come without any Upgrade.
  2. @beerbee Thank for the answer. No i don't have installed SecurityPro. The special letters don't get kick aut. I see them in the $_GET['search']. and it's only in the Shop search. At the admin the search is working with the special letters. It's not only ä ü ö ß it's all special letters also á à or é è and so on and so on. In the Shop search the search have a loop for every letter, in the admin don't have. Shop Search: if (isset($search_keywords) && (sizeof($search_keywords) > 0)) { $where_str .= " and ("; for ($i=0, $n=sizeof($search_keywords); $i<$n; $i++ ) { switch ($search_keywords[$i]) { case '(': case ')': case 'and': case 'or': $where_str .= " " . $search_keywords[$i] . " "; break; default: $keyword = tep_db_prepare_input($search_keywords[$i]); $where_str .= "("; if ( (defined('MODULE_HEADER_TAGS_PRODUCT_META_KEYWORDS_STATUS')) && (MODULE_HEADER_TAGS_PRODUCT_META_KEYWORDS_STATUS != 'Meta') ) { $where_str .= "pd.products_seo_keywords LIKE '%" . tep_db_input($keyword) . "%' OR "; } $where_str .= "pd.products_name like '%" . tep_db_input($keyword) . "%' or p.products_model like '%" . tep_db_input($keyword) . "%' or m.manufacturers_name like '%" . tep_db_input($keyword) . "%'"; if (isset($_GET['search_in_description']) && ($_GET['search_in_description'] == '1')) $where_str .= " or pd.products_description like '%" . tep_db_input($keyword) . "%'"; $where_str .= ')'; break; } } $where_str .= " )"; } Admin Search if (isset($_GET['search'])) { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and pd.products_name like '%" . tep_db_input($search) . "%' order by pd.products_name"); } else { $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' and p.products_id = p2c.products_id and p2c.categories_id = '" . (int)$current_category_id . "' order by pd.products_name"); } I think i will complett reprogramming the Shop search, because this don't work with some server.
  3. There is a problem with the special letters like ä ö ü and more in the serach of osC 2.3.4. If some product name have special letter, than the search result did'n find the product. The mystery thing is, if you serach in the admin, products with special letters the search is working. The database is UTF8. Anyone know some resolution for that, because i did try a lot filter stuff but it's not working.
  4. sorry i don't trust the Info on Github. See here: http://php.net/manual/en/function.each.php and here: http://php.net/manual/en/function.autoload.php And BTW the foreach loop is more faster, than the list, each.
  5. It's will be removed in PHP8.0 and marked in PHP7.2 as deprecated, which is fact.
  6. in specials.php i did'n change like that, coz this is totally wrong. while (list($key, $value) = each($define_list)) { by foreach($define_list as $key => $value) { list(, $this->result) = each($this->cache_data); by $this->result = current($this->cache_data); It's not a class file, so the code $this->result and $this->cache_data will not work. in special.php i change to: // "each()" is depracated in php 7.2, removed in PHP 8.0 //while (list($key, $value) = each($define_list)) { foreach($define_list as $key => $value) { if ($value > 0) $column_list[] = $key; } Today i did change all files (more than 100 files) with the each() function and everything is working.
  7. https://wiki.php.net/rfc/deprecations_php_7_2 PHP function each and autoload
  8. @frankl at this moment i can't say that, because i still check the admin area and change the function tep_image_button, to the tep_draw_button function in some files. And clear the mess with the table colspan. Also there are some problems with different languages. If i am finish with all fixes and with the translation for German languages, i will give you Information. But need a litte bit time. BTW i did hidden from the admin the "Configuration -> RMA Returns". I think it's not nessecary to configure that, your returns_configuration.php do all the stuff.
  9. @LeeFoster you are faster ;-) !!! but i did change like that in admin/includes/boxes/returns.php change if (RMA_RETURN_SYSTEM == '1') { $cl_box_groups[] = array( 'heading' => BOX_RETURNS_HEADING, to if (RMA_RETURN_SYSTEM == 'true') { $cl_box_groups[] = array( 'heading' => BOX_RETURNS_HEADING, In admin/returns_configuration.php change $rma_value_query = tep_db_query("select * from configuration where configuration_key = 'RMA_RETURN_SYSTEM'"); if (!tep_db_num_rows($rma_value_query)) { tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ( 'Use the RMA returns system?', 'RMA_RETURN_SYSTEM', '1', 'Turn the RMA System on or off', '" . $insert_id . "', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); } to if (!tep_db_num_rows($rma_value_query)) { tep_db_query("insert into configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ( 'Use the RMA returns system?', 'RMA_RETURN_SYSTEM', 'true', 'Turn the RMA System on or off', '" . $insert_id . "', '1','tep_cfg_select_option(array(\'true\', \'false\'), ', now())"); }
  10. Admin click configuration -> RMA Returns Change Use the RMA returns system? to true, than i think you will know what i mean. Your value in the database table is 1. After you change this the value is 'true', than the link in the admin "customer returns" show start all the links after the install are gone. I am working on it to fix this, but until now did not find the code for that. Also i did find a lot table colspan issues. I will fix it too. If i finish i will send u a complett new add-on also with German languages, because your add-on is very good to use for revocation in the EU/DE.
  11. Info: date values in the create datebase should not be like 0000-00-00 00:00:00. In MySQL 5.7 with strict SQL Mode an error will occurse. I recommand change the value to 1970-01-01 00:00:00
  12. And now, i did check a bug in the configuration table. if you change Use the RMA returns system? to true, than the installing is gone. Your value before change this, is 1.
  13. and in refund_methods.php you did comment out the break, delete is working, but the case is not closed. case 'delete': $oID = tep_db_prepare_input($_GET['oID']); /* $status_query = tep_db_query("select count(*) as count from refund_method where orders_status = '" . tep_db_input($oID) . "'"); $status = tep_db_fetch_array($status_query); */ $remove_status = true; /* if ($oID == DEFAULT_ORDERS_STATUS_ID) { $remove_status = false; $messageStack->add(ERROR_REMOVE_DEFAULT_ORDER_STATUS, 'error'); } elseif ($status['count'] > 0) { $remove_status = false; $messageStack->add(ERROR_STATUS_USED_IN_ORDERS, 'error'); } else { $history_query = tep_db_query("select count(*) as count from " . TABLE_REFUND_METHOD_HISTORY . " where '" . tep_db_input($oID) . "' in (new_value, old_value)"); $history = tep_db_fetch_array($history_query); if ($history['count'] > 0) { $remove_status = false; $messageStack->add(ERROR_STATUS_USED_IN_HISTORY, 'error'); } } break; */
  14. But i did find one thing. In the admin you still use the function tep_image_button, that should be the tep_draw_button function. in the file: returns_reasons.php and refund_methods.php