Jump to content


  • Content count

  • Joined

  • Last visited

  • Days Won


ce7 last won the day on June 5 2015

ce7 had the most liked content!

Profile Information

  • Real Name

Recent Profile Visitors

15,189 profile views
  1. ce7

    Google reCAPTCHA v3

    hi ruden, @ruden thank you for the addon. I have installed it on CE1.0.5.0 and found that after install it, the admin/modules/hooks list will disappear, includes/hooks/shop/create_account/Recaptcha3.php includes/hooks/shop/contact_us/Recaptcha3.php What may I done wrong to cause this issue? How to fix it? Many thanks! Lyn
  2. hi burt, @burt thank you for the reply. i dont have budget to contact developer, i self-learning from forum or google these years 😞 I google "php sort filename" and found some tips, my way to sort define_language is as below for others who maybe also want to know find: $result = array_merge($result, tep_opendir($path . $filename)); add below: // sort the filename lowest to highest // ref: https://www.php.net/manual/en/function.sort.php // or can use asort($result); sort ($result); this gave me the result i want, the only thing, i can not figure out is there are few files not sorted at the bottom, and i dont understand why? check the file type, file size, file permission, file modified date and time, what else did i miss? and the hook language files did come out on the list. Lyn
  3. Hi all, @raiwa @ecartz @burt tried search long time about text editor, wasted lots of time, finally found out define languages...😓 in my list, it doens't come with sorting order, is there a way to asc desc, and how to change the code? in CE version, I have this addon JcM Background Video Hook V1.0 and it has admin/includes/languages/english/hooks/shop/siteWide/BackgroundVideo.php how to list this hooks language file? many thanks! Lyn
  4. hi Zahid, @JcMagpie Thank you for this JcM Header Videos addon's CE addon. It is great! There is one issue need your support, when the webpage load the video script, it will not load properly, need to change the screen size, but if the screen size is too big, then the video links will go blank, please find the image attached so you can understand what I mean, also if i change the video video in right size, when not go blank, only the left scroll bar (go back) appear, the right scroll bar (go next) will not show up, how can i fix this issue? Many thanks! Lyn
  5. Hi Zahid, @JcMagpie Thank you for this addon JcM Index Banner carousel Animated V1.0. Can you please explain what these for and how I can apply them? Banner to show MODULE_CONTENT_HEADER_JCM_CAROUSELBANNER_ID1 Block on screen size MODULE_CONTENT_HEADER_JCM_CAROUSELBANNER_VISABLE_CLASS Banner text size MODULE_CONTENT_HEADER_JCM_CAROUSELBANNER_TEXTSIZE (is this for MODULE_CONTENT_HEADER_JCM_CAROUSELBANNER_TITLEB1 or for MODULE_CONTENT_HEADER_JCM_CAROUSELBANNER_TEXTB1?) Many thanks! Lyn
  6. ce7

    order number prefix

    found the solution! includes/languages/english/orders.php define('TEXT_ORDERS_NUMBER_PREFIX', ORDERS_NUMBER_PREFIX); ---> by echo TEXT_ORDERS_NUMBER_PREFIX, can retrieve the content of configuration_key: ORDERS_NUMBER_PREFIX admin/orders.php original instruction: Replace: <td class="pageHeading"><?php echo HEADING_TITLE; ?></td> by: <td class="pageHeading"><?php echo HEADING_TITLE . ' ' . $prefix . $HTTP_GET_VARS['oID']; ?></td> replace with my solution: <td class="pageHeading"><?php echo HEADING_TITLE . ' ' . TEXT_ORDERS_NUMBER_PREFIX; ?></td>
  7. ce7

    order number prefix

    hi, Installed this addon Order_Number_Prefixe and found that the configuration value will not write or update into the sql, can someone help to guide me how to connect the relation between the configuration key, configuration value with variable $prefix by using tep_db_query in admin/order.php ? the instruction sql to install: ALTER TABLE `orders` ADD `orders_prefix` VARCHAR( 32 ) DEFAULT NULL AFTER `orders_id`; INSERT INTO configuration VALUES ('', 'Order Number Prefix', 'ORDERS_NUMBER_PREFIX', 'y/m/', 'Enter the prefix of the orders numbers; ei: "y/m/" If the order date is october, 20th 2003, the order number will be: 03/10/orderID; Leave it blank if you do not want prefix.', 1, 23, '', '', NULL, NULL) the configuration will be write, and can be update if go to admin/configuration/my store/ edit, and I can update the y/m/ to 20/05/ however, how can I make the new 20/05/ to be update into table ORDER `orders_prefix` column? code from install instruction for admin/order.php does not update the 20/05/ to $prefix value.... $prefix_query = tep_db_query("select orders_prefix from orders where orders_id = '" . $GLOBALS['oID'] . "'"); $prefix_value = tep_db_fetch_array($prefix_query); $prefix = $prefix_value['orders_prefix']; right now the prefix only show up If I use phpmyadmin manually write 20/05/ into TABLE `orders` COLUMN `orders_prefix`, UPDATE `orders` SET `orders_prefix` = '2020/05/' WHERE `orders`.`orders_id` = 2; #1 after update the mystore y/m/ to 20/05/ (can update into configuration table, no problem) #2 has problem to show order number as 20/05/#2 (only show #2) so the goal is after update #1, the admin/order.php will show 20/05/#2 instead of just #2 Can anyone please help? Many thanks!
  8. ce7

    Header Tags SEO

    Hi Jack, Yes somehow the file I modified for template_top.php not upload to the server properly. After upload it with the header tags code, the issue fixed. Thank you very much for your help as usual! 👍
  9. ce7

    Header Tags SEO

    hi Jack, @Jack_mcs Thanks for the addon, installed it on CE1.0.5.0, the links are floating and when click on any of the link, the pop up window is blank, is it something that I did wrong to cause the issues? Many thanks! Lyn
  10. ce7

    Information Pages SEO addon

    @raiwa Thank you.....change the cpanel php version to PHP7+ and reinstall all the addons again... @Jack_mcs is there a way when the footer and infobox have the links or pages, that the hook will not show the links/pages again? (goal: not to show #1 and #2 links) Thanks! Lyn
  11. ce7

    customer create account error

    Found out my problem that causing the issue. I had installed newsletter subscription, and the code i modified was incorrect as tep_db_perform(newsletter_subscription, $sql_subscribe_newsletter); the correct code should be tep_db_perform('newsletter_subscription', $sql_subscribe_newsletter); then the error gone! Lyn
  12. hi, have CE1.0.5.0, testing to register new customer account, it will write into database, but it keep showing error message Fatal error: Uncaught mysqli_sql_exception: Duplicate entry '3' for key 'PRIMARY' in /mywebsite.com/includes/functions/database.php:52 Stack trace: #0 /mywebsite.com/includes/functions/database.php(52): mysqli_query(Object(mysqli), 'insert into cus...') #1 /mywebsite.com/create_account.php(325): tep_db_query('insert into cus...') #2 {main} thrown in /mywebsite.com/includes/functions/database.php on line 52 The create_account.php(325) code is: tep_db_query("insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . (int)$customer_id . "', '0', now())"); and this is the database table CUSTOMERS structure how can I resolve the error issue? Many thanks! Lyn
  13. hi, @burt Have CE1.0.5.0 version, want to modify the product_info page the old price, check the file: cm_pi_price.php see these codes: $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id'])); $specials_price = null; if ($new_price = tep_get_products_special_price($product_info['products_id'])) { $specials_price = $currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id'])); } where is the <del>old price </del> is from? which files should I check? Can someone please help? Many thanks! Lyn
  14. ce7

    Product Margins

    hi, Admin cost price with margin or markup (this addon will show margin in %, but the margin result will not write into table PRODUCTS I like to show (product sale - product cost price = product margin), the real $product margin---> p.products_price - p.products_price_cost = p.products_margins $product_query = tep_db_query("select pd.*, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_price_cost, p.products_margins, p.products_weight, p.products_date_added, p.products_last_modified, date_format(p.products_date_available, '%Y-%m-%d') as products_date_available, p.products_status, p.products_tax_class_id, p.manufacturers_id, p.products_gtin from products p, products_description pd where p.products_id = '" . (int)$_GET['pID'] . "' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "'"); And found Product Cost/Margins Mod 1.0 and modified it, instead of showing %, function updateMargin2() { var grossValue2 = document.forms["new_product"].products_price.value; var costValue2 = document.forms["new_product"].products_price_cost.value; marginValue2 = (grossValue2 - costValue2); document.getElementById('products_margins').innerHTML = marginValue; } function updateMargin2() I modified above not correct I think as it is still not show the margin, and how to update the margin into SQL table? Can someone please help to resolve this issue? Many thanks! Lyn