Quick Updates plugin [support]

[DivaVocals]

@DivaVocals, can you help me? Can you change this for a fee?

Sorry.. but I don't support any Zen Cart v1.3.9 stores or mods.. Wish I could be of help..

[DivaVocals]

Thanks for the new version. I've upgraded to 1.5.3 and installed this again, an upgrade from 2.06a. Only issue is the Configuration Menu for Quick Updates does not exist. I tried to Uninstall (using the button in the admin) but that does nothing. Quick Updates page just reloads.

My bad.. Looks like somehow the SQL I was using got lost.. I didn't even have a backup locally.. had to recreate it from my test store.. and haven't had time to test this.. It should work, but your mileage might vary....

SELECT @t4:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order, visible) VALUES 
('Quick Updates', 'Set Quick Updates Options', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('Display the Product ID','QUICKUPDATES_DISPLAY_ID','true','Enable/Disable displaying the Product ID <br /><br />(Default value = True)', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display the Product Thumbnail','QUICKUPDATES_DISPLAY_THUMBNAIL','true','Enable/Disable displaying the Product Thumbnail <br /><br />(Default value = True)', @t4, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Set Thumbnail Width','QUICKUPDATES_DISPLAY_THUMBNAIL_WIDTH','50','Enter the width for the product image thumbnail. DO NOT enter px or em. <br /><br />(Default value is 50)',@t4,15, NOW(), NOW(), NULL, NULL),
('Set Thumbnail Height','QUICKUPDATES_DISPLAY_THUMBNAIL_HEIGHT','50','Enter the height for the product image thumbnail. DO NOT enter px or em. <br /><br />(Default value is 50)',@t4,20, NOW(), NOW(), NULL, NULL),
('Display & Modify the Product Model Number','QUICKUPDATES_MODIFY_MODEL','true','Enable/Disable display and modifiying the Product Model <br /><br />(Default value = True)', @t4, 25, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Name','QUICKUPDATES_MODIFY_NAME','true','Enable/Disable display and modifiying the Product Name <br /><br />(Default value = True)', @t4, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Description','QUICKUPDATES_MODIFY_DESCRIPTION','true','Enable/Disable display and modifying the Product Description <br /><br />(Default value = True)',@t4,35,NULL,'2013-11-30 09:22:31',NULL,'zen_cfg_select_option(array(\"true\", \"false\"),','General'),
('Activate Product Description Popup Edit','QUICKUPDATES_MODIFY_DESCRIPTION_POPUP','false','Enable/Disable using popup edit link to edit product description. <br /><br />You MUST enable the product description display for this feature to work and display correctly. <br /><br />(Default value = False)',@t4,40,NULL,'2013-11-30 09:22:31',NULL,'zen_cfg_select_option(array(\"true\", \"false\"),','General'),
('Display & Modify the Product Status','QUICKUPDATES_MODIFY_STATUS','true','Enable/Disable display and modifying the Product Status <br /><br />(Default value = True)', @t4, 45, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Weight','QUICKUPDATES_MODIFY_WEIGHT','true','Enable/Disable display and modifiying the Product Weight <br /><br />(Default value = True)', @t4, 50, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Inventory Quantity','QUICKUPDATES_MODIFY_QUANTITY','true','Enable/Disable display and modifiying the Product Inventory Quantity <br /><br />(Default value = True)', @t4, 55, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Manufacturer','QUICKUPDATES_MODIFY_MANUFACTURER','false','Enable/Disable display and modifiying the Product Manufacturer <br /><br />(Default value = False)', @t4, 60, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Tax Class','QUICKUPDATES_MODIFY_TAX','false','Enable/Disable display and modifiying the Product Tax Class <br /><br />(Default value = False)', @t4,65 NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Category','QUICKUPDATES_MODIFY_CATEGORY','true','Enable/Disable display and modifiying the Product Category <br /><br />(Default value = True)',@t4, 70, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Sort Order','QUICKUPDATES_MODIFY_SORT_ORDER','true','Enable/Disable display and modifiying of the products sort order <br /><br />(Default value = True)',@t4, 75, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Activate Display of Product Price with Tax Included on Hover','QUICKUPDATES_DISPLAY_TVA_OVER','false','Enable/Disable the display of the product price with all tax included when you hover your mouse over a product <br /><br />(Default value = False)',@t4, 80, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display Link to Product Info Page','QUICKUPDATES_DISPLAY_PREVIEW','false','Enable/Disable the display of the link to the products info page. Product info page will open in a new window/tab. <br /><br />(Default value = False)', @t4, 85, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display Link to Product Edit Page','QUICKUPDATES_DISPLAY_EDIT','true','Enable/Disable the display of the link to the product edit page. Product edit page will open in a new window/tab. <br /><br />(Default value = True)', @t4, 90, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Activate/Deactivate Commercial Margin','QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN','true','Do you want that the commercial margin functions to be activated? <br /><br />(Default value = True)', @t4, 95, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT  into zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES 
('quick_updates_config','BOX_CONFIGURATION_QUICK_UPDATES','FILENAME_CONFIGURATION',CONCAT('gID=',@t4),'configuration','Y',104),
('quick_updates_catalog','BOX_CATALOG_QUICK_UPDATES','FILENAME_QUICK_UPDATES','','catalog','Y',105),
('quick_updates_popup_file_select','BOX_CATALOG_QUICK_UPDATES_POPUP_FS', 'FILENAME_POPUP_FILE_SELECT','', 'catalog', 'N',106),
('quick_updates_popup_text_edit','BOX_CATALOG_QUICK_UPDATES_POPUP_TE', 'FILENAME_POPUP_TEXT_EDIT','', 'catalog', 'N',107);

[DivaVocals]

Made a few changes since posting this.. Again I haven't tested it.. Should work, but your mileage may vary.. Please go to GitHub to get the latest..

My bad.. Looks like somehow the SQL I was using got lost.. I didn't even have a backup locally.. had to recreate it from my test store.. and haven't had time to test this.. It should work, but your mileage might vary....

SELECT @t4:=configuration_group_id 
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';
DELETE FROM configuration WHERE configuration_group_id = @t4;
DELETE FROM configuration_group WHERE configuration_group_id = @t4;

INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order, visible) VALUES 
('Quick Updates', 'Set Quick Updates Options', '1', '1');

UPDATE configuration_group SET sort_order = last_insert_id() WHERE configuration_group_id = last_insert_id();

SELECT @t4:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Quick Updates';

INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES
('Display the Product ID','QUICKUPDATES_DISPLAY_ID','true','Enable/Disable displaying the Product ID <br /><br />(Default value = True)', @t4, 5, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display the Product Thumbnail','QUICKUPDATES_DISPLAY_THUMBNAIL','true','Enable/Disable displaying the Product Thumbnail <br /><br />(Default value = True)', @t4, 10, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Set Thumbnail Width','QUICKUPDATES_DISPLAY_THUMBNAIL_WIDTH','50','Enter the width for the product image thumbnail. DO NOT enter px or em. <br /><br />(Default value is 50)',@t4,15, NOW(), NOW(), NULL, NULL),
('Set Thumbnail Height','QUICKUPDATES_DISPLAY_THUMBNAIL_HEIGHT','50','Enter the height for the product image thumbnail. DO NOT enter px or em. <br /><br />(Default value is 50)',@t4,20, NOW(), NOW(), NULL, NULL),
('Display & Modify the Product Model Number','QUICKUPDATES_MODIFY_MODEL','true','Enable/Disable display and modifiying the Product Model <br /><br />(Default value = True)', @t4, 25, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Name','QUICKUPDATES_MODIFY_NAME','true','Enable/Disable display and modifiying the Product Name <br /><br />(Default value = True)', @t4, 30, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Description','QUICKUPDATES_MODIFY_DESCRIPTION','true','Enable/Disable display and modifying the Product Description <br /><br />(Default value = True)',@t4,35,NULL,'2013-11-30 09:22:31',NULL,'zen_cfg_select_option(array(\"true\", \"false\"),','General'),
('Activate Product Description Popup Edit','QUICKUPDATES_MODIFY_DESCRIPTION_POPUP','false','Enable/Disable using popup edit link to edit product description. <br /><br />You MUST enable the product description display for this feature to work and display correctly. <br /><br />(Default value = False)',@t4,40,NULL,'2013-11-30 09:22:31',NULL,'zen_cfg_select_option(array(\"true\", \"false\"),','General'),
('Display & Modify the Product Status','QUICKUPDATES_MODIFY_STATUS','true','Enable/Disable display and modifying the Product Status <br /><br />(Default value = True)', @t4, 45, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Weight','QUICKUPDATES_MODIFY_WEIGHT','true','Enable/Disable display and modifiying the Product Weight <br /><br />(Default value = True)', @t4, 50, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Inventory Quantity','QUICKUPDATES_MODIFY_QUANTITY','true','Enable/Disable display and modifiying the Product Inventory Quantity <br /><br />(Default value = True)', @t4, 55, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Manufacturer','QUICKUPDATES_MODIFY_MANUFACTURER','false','Enable/Disable display and modifiying the Product Manufacturer <br /><br />(Default value = False)', @t4, 60, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Tax Class','QUICKUPDATES_MODIFY_TAX','false','Enable/Disable display and modifiying the Product Tax Class <br /><br />(Default value = False)', @t4,65 NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Category','QUICKUPDATES_MODIFY_CATEGORY','true','Enable/Disable display and modifiying the Product Category <br /><br />(Default value = True)',@t4, 70, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display & Modify the Product Sort Order','QUICKUPDATES_MODIFY_SORT_ORDER','true','Enable/Disable display and modifiying of the products sort order <br /><br />(Default value = True)',@t4, 75, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Activate Display of Product Price with Tax Included on Hover','QUICKUPDATES_DISPLAY_TVA_OVER','false','Enable/Disable the display of the product price with all tax included when you hover your mouse over a product <br /><br />(Default value = False)',@t4, 80, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display Link to Product Info Page','QUICKUPDATES_DISPLAY_PREVIEW','false','Enable/Disable the display of the link to the products info page. Product info page will open in a new window/tab. <br /><br />(Default value = False)', @t4, 85, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Display Link to Product Edit Page','QUICKUPDATES_DISPLAY_EDIT','true','Enable/Disable the display of the link to the product edit page. Product edit page will open in a new window/tab. <br /><br />(Default value = True)', @t4, 90, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),'),
('Activate/Deactivate Commercial Margin','QUICKUPDATES_ACTIVATE_COMMERCIAL_MARGIN','true','Do you want that the commercial margin functions to be activated? <br /><br />(Default value = True)', @t4, 95, NOW(), NOW(), NULL, 'zen_cfg_select_option(array(''true'', ''false''),');

INSERT  into zen_admin_pages (page_key,language_key,main_page,page_params,menu_key,display_on_menu,sort_order) VALUES 
('quick_updates_config','BOX_CONFIGURATION_QUICK_UPDATES','FILENAME_CONFIGURATION',CONCAT('gID=',@t4),'configuration','Y',104),
('quick_updates_catalog','BOX_CATALOG_QUICK_UPDATES','FILENAME_QUICK_UPDATES','','catalog','Y',105),
('quick_updates_popup_file_select','BOX_CATALOG_QUICK_UPDATES_POPUP_FS', 'FILENAME_POPUP_FILE_SELECT','', 'catalog', 'N',106),
('quick_updates_popup_text_edit','BOX_CATALOG_QUICK_UPDATES_POPUP_TE', 'FILENAME_POPUP_TEXT_EDIT','', 'catalog', 'N',107);

[jeking]

Thanks for posting, however I get 'WARNING: An Error occurred, please refresh the page and try again.' Here's the log:

[10-Jul-2014 07:58:00 America/Chicago] PHP Warning: mysql_query(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/miashop/public_html/zencart/xxxxx/includes/functions/extra_functions/quick_updates_functions.php on line 48

I also see the opening and closing php tags are missing in reg_quick_updates.php causing the comment to appear at the top of the admin.

[DivaVocals]

Thanks for posting, however I get 'WARNING: An Error occurred, please refresh the page and try again.' Here's the log:

[10-Jul-2014 07:58:00 America/Chicago] PHP Warning: mysql_query(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/miashop/public_html/zencart/xxxxx/includes/functions/extra_functions/quick_updates_functions.php on line 48

I also see the opening and closing php tags are missing in reg_quick_updates.php causing the comment to appear at the top of the admin.

Getting ready for vacation.. Not going to be able to mess with this.. If you read the contents of reg_quick_updates.php you'll see it's an OBSOLETE FILE.. so you can either:

1. Delete it
2. Add the missing opening and closing tags

Suggest seeing if doing either one solves the issue..

Did you take a look at line 48 of the quick_updates_functions.php file??

I won't be able to look at this personally until I get back from vacation..

[DivaVocals]

Getting ready for vacation.. Not going to be able to mess with this.. If you read the contents of reg_quick_updates.php you'll see it's an OBSOLETE FILE.. so you can either:

1. Delete it
2. Add the missing opening and closing tags

Suggest seeing if doing either one solves the issue..

Did you take a look at line 48 of the quick_updates_functions.php file??

I won't be able to look at this personally until I get back from vacation..

Okay took a VERY FAST look at it.. download the latest.. replace your reg_quick_updates.php & quick_updates_functions.php files..

Won't be able to do anything more until after the 20th.. If this doesn't work for you, I encourage you to fork the repo and contribute a fix which I'll be happy to merge into the master.. I haven't submitted this to the downloads yet because there are still flaws in this module which I outline here on this support thread and in the readme..

[jeking]

I wasn't clear about reg_quick_updates.php, I did add the missing php tags.

However, I was not able to resolve the sql error, even with your updated file. I'll help and test any changes once you get back and can take a look.

[DivaVocals]

Thanks for posting, however I get 'WARNING: An Error occurred, please refresh the page and try again.' Here's the log:

[10-Jul-2014 07:58:00 America/Chicago] PHP Warning: mysql_query(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/miashop/public_html/zencart/xxxxx/includes/functions/extra_functions/quick_updates_functions.php on line 48

I also see the opening and closing php tags are missing in reg_quick_updates.php causing the comment to appear at the top of the admin.

includes/functions/extra_functions/quick_updates_functions.php had an extra semi-colon at line 48 (hence the error)
I do not see missing opening and closing php tags in includes/functions/extra_functions/reg_quick_updates.php

I am not sure why you can't get v2.07 to work.. I have it working fine on the test store I installed this on.. It's a Zen Cart v1.5.1 store so that may be the issue for you if you are using v1.5.3. That said I did make some clean-up changes to the file in Github repo to make it clear that several original module files have been rendered obsolete.. (changes/updates to definition files, but mostly removing all of the files that supported that silly pop-up edit crap) So you might want to take another looksee..

https://github.com/DivaVocals/zen_QuickUpdates

[jeking]

I am using 1.5.3 and that does seem to be the issue. When installing the configuration keys, I get:

[21-Jul-2014 09:54:23 America/Chicago] PHP Warning: mysql_insert_id(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/miashop/public_html/zencart/ADMIN_NAME/includes/functions/extra_functions/quick_updates_functions.php on line 16

[DivaVocals]

I am using 1.5.3 and that does seem to be the issue. When installing the configuration keys, I get:

[21-Jul-2014 09:54:23 America/Chicago] PHP Warning: mysql_insert_id(): Access denied for user 'nobody'@'localhost' (using password: NO) in /home/miashop/public_html/zencart/ADMIN_NAME/includes/functions/extra_functions/quick_updates_functions.php on line 16

Yep this is a mysqli thing, and I am not sure of the correct replacement for mysql_insert_id. You can try mysqli_insert_id and see if that works.. but I am not sure if an additional change is needed as well..