Manufacturers All About Support

[dw08gm]

Upgrade Version 1.1 added to plugins.

Fixed layout issues in admin manufacturers page.
Added 3 new buttons to admin/includes/languages/english/images/buttons/: button_new_manufacturer.gif, button_manufacturer_options.gif and button_admin_options.gif.
Added ID, status and sort_order columns to admin manufacturers page.
Added facility to sort by ID, manufacturers_name, status and sort_order columns to admin manufacturers page.
Added additional admin switches to Admin > Configuration > Manufacturers All About.
Added extra language defines to admin/includes/languages/english/manufacturers.php
Added status function to admin/includes/functions/extra_functions/manufacturers_all_about_functions.php.
Added status function to includes/functions/extra_functions/manufacturers_all_about_functions.php.
Changed function zen_get_manufacturers_about to zen_get_manufacturers_info in includes/functions/extra_functions/manufacturers_all_about_functions.php.
Added extra language defines to includes/languages/english/ manufacturers_about.php and manufacturers_all.php.
Changed SHOW_CATEGORIES_BOX_MANUFACTURERS_ALL to MANUFACTURERS_ALL_ABOUT_CATEGORIES_BOX_LINK in admin options and in includes\templates\YOUR_TEMPLATE\sideboxes\tpl_categories.php.
Added status flags to manufacturers_all and manufacturers_about pages.
Added provision to display something in manufacturer_all and manufacturer_about pages when links to manufacturer_about and manufacturer_URL are left blank.
Added pagination code to tpl_manufacturers_all_default.php. BUT THIS NEEDS TO BE FIXED AS DOES NOT WORK WITH "SELECT DISTINCT" AND/OR $order_by IN $manufacturers_all_sql. This also impacts the admin switch "Maximum Display per Manufacturers All Page", where changing the value has no affect.
Added placeholders in admin/manufacturers.php for manufacturers_metatags mod by lat9.
Created new file includes/modules/manufacturers_all_listing_display_order.php to handle various manufacturers_all sort order display options.
Changed optional text in /admin/includes/modules/category_product_listing.php to reflect addition of ID column in admin manufacturers page.
Added option to display link in admin/manufacturers.php to Admin > Configuration > Manufacturers All About configuration options.
Added manufacturers_status and manufacturers_sort_order fields to install.sql.
Added upgrade.sql.

Cheers

[fjbern1943]

Using Zen Cart Version 1.54.

When I run the install.sql file I get these errors:

ERROR: Cannot insert configuration_key "" because it already exists- 12 times
ERROR: Cannot ADD column manufacturers_status because it already exists.
ERROR: Cannot ADD column manufacturers_sort_order because it already exists.
ERROR: Cannot ADD column manufacturers_about because it already exists.
ERROR: Cannot ADD column manufacturers_about because it already exists.
Note: 15 statements ignored. See "upgrade_exceptions" table for additional details.

Sideboxes are there.

Configuration/Manufacturers All About does not have any options????

Please help.

[dw08gm]

Seems like you ran the install sql more than once.

You could compare the manufacturers and admin_pages tables with the sql to see if the sql has loaded properly.

[fjbern1943]

Seems like you ran the install sql more than once.

You could compare the manufacturers and admin_pages tables with the sql to see if the sql has loaded properly.

I ran the install.sql and got these error messages the first time. I then ran the uninstall.sql and it worked fine and re-ran the install.sql again and got the same error messages. How about the fact that the configuration/manufacturers all about screen is blank except for the header information. No information below the header???? I will check the sql to the tables using myphpadmin and will report back.

[fjbern1943]

I ran the install.sql and got these error messages the first time. I then ran the uninstall.sql and it worked fine and re-ran the install.sql again and got the same error messages. How about the fact that the configuration/manufacturers all about screen is blank except for the header information. No information below the header???? I will check the sql to the tables using myphpadmin and will report back.

OK Here is my report so far.

I checked the database in phpmyadmin and did not find the Manufacturers All info in the configuration group table but did find the info in the manufacturers_info table. Ran the install.sql directly in phpmyadmin and got an error referring to the info already in the manufacturers_info table. I took out that part of the install.sql and ran it again successfully.

Went to admin/configuration/Manufacturers All About and the configuration information was there. All seemed to be fine. Checked the Layout box controller and checked if both the manufacturers and manufacturers_info boxes were turned on. They were, however, the Manufacturers_info box does not appear in the sideboxes on the site, the Manufacturers box does appear. ???????

Also in database the manufacturers ID in the manufacturers_info table were not right. They showed numbers like 550011 for two manufacturers and the right ID for one of the manufacturers. Changed two of the ID's to match the ID's in the manufacturer table and was now able to edit the manufacturers in the admin. Then I noticed that the Admin Options link in the top right corner of the Catalog/Manufacturers takes me to http://localhost/shop154r/adminyukat...on.php?gID=999 ????????

Last but not least All information on the Manufacturers All page appears twice. You can see it at http://christianstore.biz/index.php?...ufacturers_all ????????

This plugin needs some serious repair. If I can't fix it with your help I will have to abandon its use, which I really don't want to do.

Please reply!

[fjbern1943]

OK Here is my report so far.

I checked the database in phpmyadmin and did not find the Manufacturers All info in the configuration group table but did find the info in the manufacturers_info table. Ran the install.sql directly in phpmyadmin and got an error referring to the info already in the manufacturers_info table. I took out that part of the install.sql and ran it again successfully.

Went to admin/configuration/Manufacturers All About and the configuration information was there. All seemed to be fine. Checked the Layout box controller and checked if both the manufacturers and manufacturers_info boxes were turned on. They were, however, the Manufacturers_info box does not appear in the sideboxes on the site, the Manufacturers box does appear. ???????

Also in database the manufacturers ID in the manufacturers_info table were not right. They showed numbers like 550011 for two manufacturers and the right ID for one of the manufacturers. Changed two of the ID's to match the ID's in the manufacturer table and was now able to edit the manufacturers in the admin. Then I noticed that the Admin Options link in the top right corner of the Catalog/Manufacturers takes me to http://localhost/shop154r/adminyukat...on.php?gID=999 ????????

Last but not least All information on the Manufacturers All page appears twice. You can see it at http://christianstore.biz/index.php?...ufacturers_all ????????

This plugin needs some serious repair. If I can't fix it with your help I will have to abandon its use, which I really don't want to do.

Please reply!

OK I solved the manufacturers appearing twice on the Manufacturers all page by deleting the Spanish id in phpmyadmin for each manufacturer. Apparently the plugin is not setup for more than one language. Could this be fixed?????? Still no progress to get the manufacturers all sidebox to appear.

[dw08gm]

Seems to be working now, but what is the "\n" after the "Manufacturers All" link under your product listing?

Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link

[fjbern1943]

Seems to be working now, but what is the "\n" after the "Manufacturers All" link under your product listing?

Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link

The Manufacturers All link also had three periods which I got rid of by modifying the "tpl_categories.php file . I have no idea why the /n is there. As the mod author I thought maybe you could tell me.

Also your second comment "Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link", I ask how do I do that? I would certainly like to do that if I knew how.

Also no comments by you on the rest of my post??????

[dw08gm]

The Manufacturers All link also had three periods which I got rid of by modifying the "tpl_categories.php file . I have no idea why the /n is there. As the mod author I thought maybe you could tell me.

This is documented in the readme - optional edits #1a & 1b.

The place to edit the define CATEGORIES_BOX_HEADING_MANUFACTURERS_ALL is in your includes/languages/(YOUR_TEMPLATE)/english.php.

Also your second comment "Why not turn the "Manufacturers" sidebox heading also into a "Manufacturers All" link", I ask how do I do that? I would certainly like to do that if I knew how.

This is documented in the readme - optional edits #2.

Also no comments by you on the rest of my post??????

Because from what I saw of your site yesterday, you already seem to have the mod working as intended.

[webchills]

Apparently the plugin is not setup for more than one language. Could this be fixed??????

includes/modules/pages/manufacturers_all/header_php.php

Change from

if (!MANUFACTURERS_ALL_ABOUT_EMPTY_SHOW) { // only show manufacturers with products
  $manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about 
							  from (" . TABLE_MANUFACTURERS . " m
							  left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id
							  left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
							  where m.manufacturers_id = mi.manufacturers_id
							  and m.manufacturers_id = p.manufacturers_id
							  and m.manufacturers_status = 1
							  and (p.products_status = 1
							  and p.products_quantity > 0) " . 
							  $order_by;
} else { // show all manufacturers
  $manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about
    from (" . TABLE_MANUFACTURERS . " m
    left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
							  where m.manufacturers_id = mi.manufacturers_id
							  and m.manufacturers_status = 1 " . 
							  $order_by;
}

to

if (!MANUFACTURERS_ALL_ABOUT_EMPTY_SHOW) { // only show manufacturers with products
  $manufacturers_all_sql = "select distinct m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.languages_id, mi.manufacturers_url, mi.manufacturers_about 
							  from (" . TABLE_MANUFACTURERS . " m
							  left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id 
							  
							  left join " . TABLE_PRODUCTS . " p on m.manufacturers_id = p.manufacturers_id)
							  where m.manufacturers_id = mi.manufacturers_id
							  and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
							  and m.manufacturers_id = p.manufacturers_id
							  and m.manufacturers_status = 1
							  
							  and (p.products_status = 1
							  
							  and p.products_quantity > 0) " . 
							  $order_by;
} else { // show all manufacturers
  $manufacturers_all_sql = "select m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.manufacturers_sort_order, mi.languages_id, mi.manufacturers_url, mi.manufacturers_about
    from (" . TABLE_MANUFACTURERS . " m
    left join " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
							  where m.manufacturers_id = mi.manufacturers_id
							  and mi.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
							  and m.manufacturers_status = 1 " . 
							  $order_by;
}

To prevent the manufacturers from showing twice in admin

YOURADMIN/manufacturers.php

Change

// bof Manufacturers_All_About v1.1 also get manufacturers_info
//  $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
  $manufacturers_query_raw = "SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, m.manufacturers_status, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about 
                              FROM (" . TABLE_MANUFACTURERS . " m
                              LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
							  ORDER by $disp_order";
// eof Manufacturers_All_About v1.1 also get manufacturers_info

To

// bof Manufacturers_All_About v1.1 also get manufacturers_info
//  $manufacturers_query_raw = "select manufacturers_id, manufacturers_name, manufacturers_image, date_added, last_modified from " . TABLE_MANUFACTURERS . " order by manufacturers_name";
  $manufacturers_query_raw = "SELECT m.manufacturers_id, m.manufacturers_name, m.manufacturers_image, m.date_added, m.last_modified, m.manufacturers_status, m.manufacturers_sort_order, mi.manufacturers_url, mi.manufacturers_about 
                              FROM (" . TABLE_MANUFACTURERS . " m
                              LEFT JOIN " . TABLE_MANUFACTURERS_INFO . " mi on m.manufacturers_id = mi.manufacturers_id)
                              WHERE mi.languages_id = '" . (int)$_SESSION['languages_id'] . "' 
							  ORDER by $disp_order";
// eof Manufacturers_All_About v1.1 also get manufacturers_info