joe122joe

Hello, I have Modular Product Page (Bootstrap) installed, and I would like to install Header Tags SEO addon by @Jack_mcs. and on the Header Tags SEO addon installation doc need changes in product_info.php file. and i cant find where is the code for calling the database .. find $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['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); REPLACE WITH: /*** Begin Header Tags SEO ***/ $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pd.products_head_sub_text from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['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); $product_info['products_name'] = $header_tags_array['title_alt']; /*** End Header Tags SEO ***/ Thank you in advance, Joe

Hello @Jack_mcs.. Thank you for this addon.. I would like to ask you, I am trying to install it on osc 2.3 bs Edge. I have Modular Product Page (Bootstrap) installed.. so the product_info.php so different ,I found almost all the changing code but still one change I didn't find it , Do you have any idea where I can change or add this code : FIND: $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['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); REPLACE WITH: /*** Begin Header Tags SEO ***/ $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id, pd.products_head_sub_text from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = '" . (int)$HTTP_GET_VARS['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); $product_info['products_name'] = $header_tags_array['title_alt']; /*** End Header Tags SEO ***/ Joe

By deleting SEO URLs SQL Rows from configuration Table, and opening the shop in browser will recreate new SEO URLs SQL Rows ,, and that was fix my issue. Thank you @@Jack_mcs. Joe

@@Jack_mcs when I want to check the admin->Configuration->SEO URLs it log me out from the admin and it go to admin login page!!! :shifty:

Hello @@Jack_mcs, How I can remove ?osCsid=xxxxx" from every url end .. I tried this define('HTTP_COOKIE_DOMAIN', '.www.domain.com'); define('HTTPS_COOKIE_DOMAIN', '.www.domain.com'); but url still have the osCsid Joe

Hello everyone. I noticed that, on same browsers when chose category or any page (contact us, shipping , etc ) the whole page reload, but on another browser just the index reloading. the boxes, nav, footer . etc .. not reloading. I think it should be like that. is it something to do with CSS or what? any help plz Joe

Thank you @@kymation includes/classes/hooks.php it was there.. now its working after re-backup osc.

thank you @@LeeFoster its working now after re-backup the Osc

Thank you @@Jack_mcs Do you have any idea why if I add this require(DIR_FS_CATALOG . 'includes/classes/hooks.php'); I get a blank page on the whole site.. I fixed the DIR_FS_CATALOG definition, but still same.. Joe

@@Jack_mcs Thank you Where i can get the full path? Can I find it on Admin -- Tools--- Server Info? Joe

Hello I would like to know how to setup DIR_FS_CATALOG definition, I have it like this define('DIR_FS_CATALOG', dirname($HTTP_SERVER_VARS['SCRIPT_FILENAME']) . '/'); Is it wrong definition? if it is wrong what it should be? Joe

@@raiwa Thank you for your time have nice day.

After I got the error I used a file comparing program to be sure as you said on QTPro Documentation

@@raiwa on your QTPro Documentation its say // hooks require(DIR_FS_CATALOG . 'includes/classes/hooks.php'); $OSCOM_Hooks = new hooks('shop'); and on your /Modified files for 2.3.4 BS/includes/application_top.php it show the lines like this // hooks require('includes/classes/hooks.php'); $OSCOM_Hooks = new hooks('shop');

@@raiwa thank you for your patience. :blush: I got the error if I follow the step from QTPro Documentation.. it say add this line to // hooks require(DIR_FS_CATALOG . 'includes/classes/hooks.php'); $OSCOM_Hooks = new hooks('shop'); when I add it I got the error .. but when I add the line like this // hooks require('includes/classes/hooks.php'); $OSCOM_Hooks = new hooks('shop'); the shop work but still subtracting just from the main stock of the product