W3 osCommerce WIP

ejsolutions · October 6, 2021

Brilliant effort!

One item stands out that really should've been a core inclusion, is an HTML editor for descriptions, IMHumbleO. Something like CKEditor, depending on suitability with jquery, PHP7/8 etc.

Hotclutch · October 8, 2021

I am working on Meta Tags.

w3-1-min.png.3bca6dcdfd741a5fac8d732e32705ff2.png

w3-2-min.png.25833f12d2a8cb557911af641c3cbbdc.png

w3-3-min.png.83997895c199a2034b177c4cc4f353b7.png

w3-4-min.png.c1e428366a69312928fbb3d477e6b5b6.png

Hotclutch · October 8, 2021

w3-1-min.png.39b2c7afdbc450d151c75be7361e1d2c.png

Hotclutch · October 8, 2021

Tomorrow I start looking at the header tag modules catalog side.

w1-min.png.827158abefc90a5a0c6d32356f9c7b32.png

w2-min.png.c522b2acb273d4a8568f9ffad83fba4b.png

w3-min.png.f6be0fa63ec015c5c969d6bc541a8cc9.png

w4-min.png.000fcf4f9351b3f6482949cd0faedd57.png

w5-min.png.418d1d3dc84cca6615ca5e7c6931a34d.png

w6-min.png.99ff357854b64907963f4ca670c03bef.png

w7-min.png.b98bd5dca0043100108427a8df7cb6e7.png

Hotclutch · October 8, 2021

Here is the code for Category SEO. It will add 1 query to every pageload. I will do another one each for manufacturers and products.

    function execute() {
      global $PHP_SELF, $oscTemplate, $current_category_id, $languages_id;

      if ( (basename($PHP_SELF) == 'index.php') && ($current_category_id > 0) ){
            $categories_query = tep_db_query("select categories_name, categories_seo_title, categories_seo_description, categories_seo_keywords from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$current_category_id . "' and language_id = '" . (int)$languages_id . "' limit 1");
            if (tep_db_num_rows($categories_query) > 0) {
              $categories = tep_db_fetch_array($categories_query);
			  if (tep_not_null($categories['categories_seo_title'])) {	
                $oscTemplate->setTitle($categories['categories_seo_title'] . ', ' . STORE_NAME);
			  } else {
				$oscTemplate->setTitle($categories['categories_name'] . ', ' . STORE_NAME);  
			  }

			  if ( tep_not_null($categories['categories_seo_description']) ) {
			    $oscTemplate->addBlock('<meta name="description" content="' . tep_output_string($categories['categories_seo_description']) . '" />', $this->group);			    
			  }
			  if ( tep_not_null($categories['categories_seo_keywords']) ) {
			    $oscTemplate->addBlock('<meta name="keywords" content="' . tep_output_string($categories['categories_seo_keywords']) . '" />', $this->group);
		  }
        }
      }
    }

Hotclutch · October 8, 2021

Manufacturers.

    function execute() {
      global $PHP_SELF, $oscTemplate, $languages_id;

      if (basename($PHP_SELF) == FILENAME_DEFAULT) {
        if (isset($_GET['manufacturers_id']) && is_numeric($_GET['manufacturers_id'])) {

            $manufacturers_query = tep_db_query("select m.manufacturers_name, mi.manufacturers_seo_title, mi.manufacturers_seo_description, mi.manufacturers_seo_keywords from " . TABLE_MANUFACTURERS . " m, " . TABLE_MANUFACTURERS_INFO . " mi where m.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.manufacturers_id = '" . (int)$_GET['manufacturers_id'] . "' and mi.languages_id = '" . (int)$languages_id . "'");

            if (tep_db_num_rows($manufacturers_query)) {
              $manufacturers = tep_db_fetch_array($manufacturers_query);

			  if (tep_not_null($manufacturers['manufacturers_seo_title'])) {	
                $oscTemplate->setTitle($manufacturers['manufacturers_seo_title'] . ', ' . STORE_NAME);
			  } else {
				$oscTemplate->setTitle($manufacturers['manufacturers_name'] . ', ' . STORE_NAME);  
			  }

			  if ( tep_not_null($manufacturers['manufacturers_seo_description']) ) {
			    $oscTemplate->addBlock('<meta name="description" content="' . tep_output_string($manufacturers['manufacturers_seo_description']) . '" />', $this->group);			    
			  }
			  if ( tep_not_null($manufacturers['manufacturers_seo_keywords']) ) {
			    $oscTemplate->addBlock('<meta name="keywords" content="' . tep_output_string($manufacturers['manufacturers_seo_keywords']) . '" />', $this->group);
		      }		  
          }
        }
      }
    }

Hotclutch · October 8, 2021

Products.

    function execute() {
      global $PHP_SELF, $oscTemplate, $languages_id, $product_check;

      if (basename($PHP_SELF) == FILENAME_PRODUCT_INFO) {
        if (isset($_GET['products_id'])) {
          if ($product_check['total'] > 0) {
            $product_info_query = tep_db_query("select pd.products_name, pd.products_seo_title, pd.products_seo_description, pd.products_seo_keywords from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$_GET['products_id'] . "' and pd.products_id = p.products_id and pd.language_id = '" . (int)$languages_id . "'");
            $product_info = tep_db_fetch_array($product_info_query);

			  if (tep_not_null($product_info['products_seo_title'])) {	
                $oscTemplate->setTitle($product_info['products_seo_title'] . ', ' . STORE_NAME);
			  } else {
				$oscTemplate->setTitle($product_info['products_name'] . ', ' . STORE_NAME);  
			  }

			  if ( tep_not_null($product_info['products_seo_description']) ) {
			    $oscTemplate->addBlock('<meta name="description" content="' . tep_output_string($product_info['products_seo_description']) . '" />', $this->group);			    
			  }
			  if ( tep_not_null($product_info['products_seo_keywords']) ) {
			    $oscTemplate->addBlock('<meta name="keywords" content="' . tep_output_string($product_info['products_seo_keywords']) . '" />', $this->group);
			  }
          }
        }
      }
    }

Hotclutch · October 9, 2021

https://www.dropbox.com/s/4kre1hbg36c8ao6/W3-osC Seo Meta Tags.zip?dl=0

-> Category & Manufacturer Descriptions.

-> Category, Manufacturer, Product Titles and Meta.

That completes SEO Meta Tags for W3-osC. Follow the instructions in the package.

Hotclutch · October 9, 2021

Display Product Name instead of Model in breadcrumb trail.

Follow the updated instructions in the package above.

w3-1-min.png.a83d9d50be1e1e0b674d936141ce78e2.png

w3-2-min.png.e464904c04880a41ca7d797c77371c41.png

w3-3-min.png.990db3265f8f2a6cfbd75d2bd301b89d.png

w3-4-min.png.3d3432ee8bfe3d8e7e26dc01ed91caa2.png

Hotclutch · October 10, 2021

w3-1-min.png.ff68829e7da658e7baf143ae12bce0bb.png

Hotclutch · October 11, 2021

I have done some more work on ORP Related Products.

-> Moved the Install/Uninstall SQL from the product module to Configuration.

-> Replaced hardcoded filenames and database definitions.

w3-1-min.png.e3e535010d0375bf28d485a19477afb4.png

w3-2-min.png.603dbe99d2ffa17e74a8af7000da8eec.png

w3-3-min.png.0c40f69d21f9647401426ca924bac452.png

w3-4-min.png.db793fbe2c9ba9b7a3dc38b6458cdf52.png

w3-5-min.png.0401da090f7397ec02107683f11e83cc.png

Hotclutch · October 11, 2021

In the SQL installer, there are 2 php8 errors:

Warning: Undefined array key "install"

  switch ($_GET['install']) {

this is the section of code:

  switch ($_GET['install']) {
    case ('new'):
      install_ORP_to_sql();
      tep_redirect(tep_href_link($filename));
      break;
    case ('remove'):
      $group_id = get_group_id($contrib);
      remove_keys($group_id);
      remove_group_id($contrib);
      remove_table();
      tep_redirect(tep_href_link($filename));
      break;
    case ('upgrade'):
      $group_id = get_group_id($contrib);
      remove_keys($group_id);
      install_ORP_to_sql($group_id);
      tep_redirect(tep_href_link($filename));
      break;
  }

And

Fatal error: Uncaught TypeError: sizeof(): Argument #1 ($value) must be of type Countable|array, bool given in

if (sizeof($group_id_array <= 1)) {

  function get_group_id($config_title) {
    $group_id_array = tep_db_fetch_array(tep_db_query("SELECT configuration_group_id FROM " . TABLE_CONFIGURATION_GROUP . " WHERE configuration_group_title like '". $config_title . "'"));	
    if (sizeof($group_id_array <= 1)) {
      return $group_id_array['configuration_group_id'];
    }
    remove_group_id($contrib);
    return 0;
  }

Demitry · October 11, 2021

if (is_array($group_id_array) && sizeof($group_id_array <= 1)) {

Should really be...

if (is_array($group_id_array) && sizeof($group_id_array) <= 1) {

Edited October 11, 2021 by Demitry

Demitry · October 11, 2021

Try this for the first one.

switch (isset($_GET['install'])) {

or

switch ((isset($_GET['install']) ? $_GET['install'] : null)) {

Hotclutch · October 11, 2021

16 minutes ago, Demitry said:

Try this for the first one.

switch (isset($_GET['install'])) {

or

switch ((isset($_GET['install']) ? $_GET['install'] : null)) {

The first one works to clear the error. The other one I will look at again tomorrow.

Hotclutch · October 12, 2021

tep_get_products_name

tep_get_products_description

tep_get_products_url

  function tep_get_products_name($product_id, $language_id = 0) {
    global $languages_id;

    if ($language_id == 0) $language_id = $languages_id;
    $product_query = tep_db_query("select products_name from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
    $product = tep_db_fetch_array($product_query);

	return $product['products_name'] ?? '';
  }

  function tep_get_products_description($product_id, $language_id) {
    $product_query = tep_db_query("select products_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
    $product = tep_db_fetch_array($product_query);

	return $product['products_description'] ?? '';
  }

  function tep_get_products_url($product_id, $language_id) {
    $product_query = tep_db_query("select products_url from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
    $product = tep_db_fetch_array($product_query);


	return $product['products_url'] ?? '';
  }

I am starting to use ?? - null coalescing operator

https://www.tutorialspoint.com/php7/php7_coalescing_operator.htm

Which means the code is no longer compatible with php versions < 7.

Hotclutch · October 12, 2021

Updating fontawesome to V6.

https://cdnjs.cloudflare.com/ajax/libs/font-awesome/6.0.0-beta2/css/all.min.css

Hotclutch · October 13, 2021

Ajax Attribute Manager for W3-osCommerce

-> based on V2.8.14 https://apps.oscommerce.com/6E6Qw&ajax-attribute-manager

-> tested on php8

w3-1-min.png.4af7173f3865ffe9c330eba1564cfbfd.png

w3-2-min.png.14ad7a7c744d865600c5d3e0ced97877.png

w3-3-min.png.dcd76278541f7f0bc9aed73ec4b91cfd.png

Hotclutch · October 13, 2021

On 10/9/2021 at 11:21 AM, Hotclutch said:

https://www.dropbox.com/s/4kre1hbg36c8ao6/W3-osC Seo Meta Tags.zip?dl=0

-> Category & Manufacturer Descriptions.

-> Category, Manufacturer, Product Titles and Meta.

That completes SEO Meta Tags for W3-osC. Follow the instructions in the package.

There's an error in categories.php

              tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_viewed, products_seo_title, products_seo_description, products_seo_keywords) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0')");

Should be:

              tep_db_query("insert into " . TABLE_PRODUCTS_DESCRIPTION . " (products_id, language_id, products_name, products_description, products_url, products_viewed, products_seo_title, products_seo_description, products_seo_keywords) values ('" . (int)$dup_products_id . "', '" . (int)$description['language_id'] . "', '" . tep_db_input($description['products_name']) . "', '" . tep_db_input($description['products_description']) . "', '" . tep_db_input($description['products_url']) . "', '0', '" . tep_db_input($description['products_seo_title']) . "', '" . tep_db_input($description['products_seo_description']) . "', '" . tep_db_input($description['products_seo_keywords']) . "')");

Also the instruction for functions/general.php has been amended (for php8).

Step 5:

catalog/admin/includes/functions/general.php

Add before the closing ?>
// BOF SEO Meta Tags W3-osC
  function tep_get_category_description($category_id, $language_id) {
    $category_query = tep_db_query("select categories_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id . "'");
    $category = tep_db_fetch_array($category_query);

    return $category['categories_description'] ?? '';
  }
  
  function tep_get_manufacturer_description($manufacturer_id, $language_id) {
    $manufacturer_query = tep_db_query("select manufacturers_description from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$manufacturer_id . "' and languages_id = '" . (int)$language_id . "'");
    $manufacturer = tep_db_fetch_array($manufacturer_query);

    return $manufacturer['manufacturers_description'] ?? '';
  }
  
  function tep_get_category_seo_description($category_id, $language_id) {
    $category_query = tep_db_query("select categories_seo_description from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id . "'");
    $category = tep_db_fetch_array($category_query);

    return $category['categories_seo_description'] ?? '';
  }
  
  function tep_get_category_seo_keywords($category_id, $language_id) {
    $category_query = tep_db_query("select categories_seo_keywords from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id . "'");
    $category = tep_db_fetch_array($category_query);

    return $category['categories_seo_keywords'] ?? '';
  }
  
  function tep_get_category_seo_title($category_id, $language_id = 0) {
    global $languages_id;

    if ($language_id == 0) $language_id = $languages_id;
    $category_query = tep_db_query("select categories_seo_title from " . TABLE_CATEGORIES_DESCRIPTION . " where categories_id = '" . (int)$category_id . "' and language_id = '" . (int)$language_id . "'");
    $category = tep_db_fetch_array($category_query);

    return $category['categories_seo_title'] ?? '';
  }
  
  function tep_get_manufacturer_seo_description($manufacturer_id, $language_id) {
    $manufacturer_query = tep_db_query("select manufacturers_seo_description from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$manufacturer_id . "' and languages_id = '" . (int)$language_id . "'");
    $manufacturer = tep_db_fetch_array($manufacturer_query);

    return $manufacturer['manufacturers_seo_description'] ?? '';
  }
  
  function tep_get_manufacturer_seo_keywords($manufacturer_id, $language_id) {
    $manufacturer_query = tep_db_query("select manufacturers_seo_keywords from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$manufacturer_id . "' and languages_id = '" . (int)$language_id . "'");
    $manufacturer = tep_db_fetch_array($manufacturer_query);

    return $manufacturer['manufacturers_seo_keywords'] ?? '';
  }
  
  function tep_get_manufacturer_seo_title($manufacturer_id, $language_id) {
    $manufacturer_query = tep_db_query("select manufacturers_seo_title from " . TABLE_MANUFACTURERS_INFO . " where manufacturers_id = '" . (int)$manufacturer_id . "' and languages_id = '" . (int)$language_id . "'");
    $manufacturer = tep_db_fetch_array($manufacturer_query);

    return $manufacturer['manufacturers_seo_title'] ?? '';
  }
  function tep_get_products_seo_description($product_id, $language_id = 0) {
    global $languages_id;

    if ($language_id == 0) $language_id = $languages_id;
    $product_query = tep_db_query("select products_seo_description from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
    $product = tep_db_fetch_array($product_query);

    return $product['products_seo_description'] ?? '';
  }
  
  function tep_get_products_seo_keywords($product_id, $language_id = 0) {
    global $languages_id;

    if ($language_id == 0) $language_id = $languages_id;
    $product_query = tep_db_query("select products_seo_keywords from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
    $product = tep_db_fetch_array($product_query);

    return $product['products_seo_keywords'] ?? '';
  }
  
  function tep_get_products_seo_title($product_id, $language_id = 0) {
    global $languages_id;

    if ($language_id == 0) $language_id = $languages_id;
    $product_query = tep_db_query("select products_seo_title from " . TABLE_PRODUCTS_DESCRIPTION . " where products_id = '" . (int)$product_id . "' and language_id = '" . (int)$language_id . "'");
    $product = tep_db_fetch_array($product_query);

    return $product['products_seo_title'] ?? '';
  }
// EOF SEO Meta Tags W3-osC

Package updated.

Hotclutch · October 14, 2021

Message stack in Admin updated.

w3-1-min.png.e9da94a770a366d795d5e5b020f77844.png

Hotclutch · October 15, 2021

I installed KissIT Image Thumbnailer by the original author (14 July 2012), on php8, and everything appears to work fine.

https://apps.oscommerce.com/Get&39J0f

Hotclutch · October 16, 2021

Admin/invoice.php updated.

w3-1-min.png.261598031520fee099478be5d70b97d2.png

w3-2-min.png.c2f2fe407c32a9d5fe8ae99966c60a5b.png

Hotclutch · October 16, 2021

Packing Slip.

w3-1-min.png.8c82b6914fb5f41330167500b27ff883.png

Hotclutch · October 16, 2021

Special Expire Date:

https://apps.oscommerce.com/aLIAl&special-expire-date-in-product-page

w3-1-min.png.49c2fc3001c709af9bffd824a5dcbb69.png

w3-2-min.png.baf55a681bb0b87043baf6a0700a02ee.png

w3-3-min.png.3e6e45ee9b58dd0d21330a36ecba7e08.png

w3-4-min.png.34357435f15e6fec2e2d034d0634e9f1.png

Hotclutch · October 25, 2021

Wish List Added

w3-1-min.png.a3566b789c537deb313c3dc66c53fbed.png

w3-2-min.png.d657fc88cba97adb2e4e2f10924255a4.png

W3 osCommerce WIP

Recommended Posts

Link to comment

Share on other sites

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

Hotclutch

Hotclutch

Hotclutch

Posted Images

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Link to comment

Share on other sites

Join the conversation