[APM] Advanced Product Management 2.0.4

[APM] Advanced Product Management 2.0.4

/*================================================* \
|| ########################################## ||
|| # Advanced Product Management [APM] v2.0.3 ? by HacNho
|| # Copyright (C) 2005 by HacNho, All rights reserved.
|| # ----------------------------------------------------------
|| # For use with vBulletin Version 3.5.1 and later
|| # http://www.vbulletin.com | http://www.vbulletin.com/license.html
|| # Discussion and support available at
|| # https://vborg.vbsupport.ru/showthread.php?t=95741
|| ########################################## ||
\*================================================ =*/

Hack Version: 2.0.3.051105
Compatible vB version: 3.5.1 (and later)
Support: https://vborg.vbsupport.ru/showthread.php?t=95741
Translated Versions:
http://www.vbhacks-germany.com/forum...ead.php?t=1971

NOTE: This release is to fix few function name changes in vB 3.5.1
if you have vB 3.5.0, please DONOT upgrade to this version
For vB version later than 3.5.1, you can use the version for 3.5.1 (was named for 3.5.1 only) without problem.

Beta release for vB 3.6.0 RC2 is AVAILABLE here:
https://vborg.vbsupport.ru/showthread.php?t=121792

DESCRIPTION:

A center product area which allow you to manage all codes/plugins/templates/phrases/settings for any product.
It also add some additional fields to the product, just to save more information with a product
Release Date
Product Author
Related URL
Extra Information

The extra information is only available if you install APM, and use APM to export/import other product.
It does not have any conflict with original product. You still can use APM to import standard product, or use standard product tool to import APM's product files.

CHANGES/MODIFICATION:

- Query: 1 (ADD 5 additional fields to product table)
- Files to add: 5
- Product to import: 1

INSTALL:
(2005.10.06: for safer installation, please do step 2 (import the product) first, then upload the files.)

2. Import XML product product-adv_product_management.xml using vBulletin standard product import tool.
1. Upload all files in UPLOAD folder to your server
3. Refresh menu panel to display Advanced Product Management link in Plugin System section

{optional} - Re-import product-adv_product_management.xml using APM import product tool, with Allow Overwrite = Yes
This step is inserting more information into the product.
* CAUTION: DONOT use APM to import product-adv_product_management.xml BEFORE step 2.


SCREENSHOT:
Included


HISTORY:
v1.0: Initial release
v1.1: Improve count queries, thanks to KirbyDE, some bugs fix
v1.2: Add collapsible blocks into product detail
2005.10.02: version 2.0: Alot of improvement. More product information fields. Better product's component adding/editting
2005.10.03: version 2.0.1: FIX bug on updateactive plugins in one product that de-active all other plugins. upgrade is recommended for the function to work right
2005.10.06: v2.0.2 Fix post #41 bug when debug mod is on

2005.11.05: v2.0.3 Fix bug on post #48 for vBulletin 3.5.1
{NOTE: This release is to fix few function name changes in vB 3.5.1
if you have vB 3.5.0, please DONOT upgrade to this version}

2006.03.20: v. 2.0.4 fix bug on post #64

2006.07.21: v. 3.0.0
Beta release for vB 3.6.0 RC2 is AVAILABLE here:
https://vborg.vbsupport.ru/showthread.php?t=121792

[CMX_CMGSCCC]

I get this error when I goto Advanced Edit on a plugin.

Database error in vBulletin 3.5.0:

Invalid SQL:

			SELECT setting.*, settinggroup.grouptitle
			FROM forums_settinggroup AS settinggroup
			LEFT JOIN forums_setting AS setting USING(grouptitle)
			WHERE settinggroup.displayorder <> 0
			WHERE settinggroup.product = 'active_link_security'
			OR setting.product = 'active_link_security'
			ORDER BY settinggroup.displayorder, setting.displayorder;

MySQL Error  : You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE settinggroup.product = 'active_link_security'
			OR setti

Looks like "WHERE" is in there twice thats causing the problem.

-CMX

[csidlernet]

/installs

[Kurisu]

And I get this error when trying to import the product:

Invalid SQL:

		INSERT INTO forum_product
			(productid, title, description, version, active, apm_releasedate, apm_author, apm_relatedurl, apm_extrainfo, apm_extraedit)
		VALUES
			('adv_product_management',
			'Advanced Product Management',
			'A powerful tool to manage product. All (codes/plugins/templates/phrases/settings) in one!',
			'2.0',
			1,
			'1128232800',
			'HacNho',
			'https://vborg.vbsupport.ru/showthread.php?t=95741',
			'Install\r\n\r\n- Upload files in UPLOAD folder to your server\r\n- Import XML Product (using vBulletin\'s standard Product Import tool)',
			''
			);

[mtha]

Originally Posted by Kurisu

And I get this error when trying to import the product:

Invalid SQL:

		INSERT INTO forum_product
			(productid, title, description, version, active, apm_releasedate, apm_author, apm_relatedurl, apm_extrainfo, apm_extraedit)
		VALUES
			('adv_product_management',
			'Advanced Product Management',
			'A powerful tool to manage product. All (codes/plugins/templates/phrases/settings) in one!',
			'2.0',
			1,
			'1128232800',
			'HacNho',
			'https://vborg.vbsupport.ru/showthread.php?t=95741',
			'Install\r\n\r\n- Upload files in UPLOAD folder to your server\r\n- Import XML Product (using vBulletin\'s standard Product Import tool)',
			''
			);

please read the install instruction:


INSTALL:

1. Upload all files in UPLOAD folder to your server
2. Import XML product product-adv_product_management.xml using vBulletin standard product import tool.
3. Refresh menu panel to display Advanced Product Management link in Plugin System section

{optional} - Re-import product-adv_product_management.xml using APM import product tool, with Allow Overwrite = Yes
This step is inserting more information into the product.
* CAUTION: DONOT use APM to import product-adv_product_management.xml BEFORE step 2.

[mtha]

Originally Posted by CMX_CMGSCCC

I get this error when I goto Advanced Edit on a plugin.

Database error in vBulletin 3.5.0:

Invalid SQL:
			WHERE settinggroup.displayorder <> 0
			WHERE settinggroup.product = 'active_link_security'

Looks like "WHERE" is in there twice thats causing the problem.

-CMX

You can just delete line # 2698:

" . iif($vbulletin->debug, '', 'WHERE settinggroup.displayorder <> 0') . "

I will update in the file. Thanks

[Omranic]

I'm lovin' it!
Very Very Good Work
It Must Be Merged to vBulletin Default Features
Thanks alot for your work

[Valter]

Nice work. Thanks.

Installed.

[Omranic]

after upgrading to 3.5.1 & trying to uminstall a product I got the following Error ::

Fatal error: Call to undefined function: fetchtableinfo() in /hsphere/local/home/phpkd/phpkd.com/vb/admincp/apm_product.php on line 1117

this error repeated to any product uninstallation & the product doesn't uninstalled

[mtha]

Originally Posted by SolidSnake@GTI

after upgrading to 3.5.1 & trying to uminstall a product I got the following Error ::


Fatal error: Call to undefined function: fetchtableinfo() in /hsphere/local/home/phpkd/phpkd.com/vb/admincp/apm_product.php on line 1117


this error repeated to any product uninstallation & the product doesn't uninstalled

There was few changes in function names for vB 3.5.1.

Version 2.0.3 is released to fix the problem

Please upload the new files.
(reimport XML product is recommended for hack version update)

[akanevsky]

Wow... This needs be HOTM, matey. Keep up the good work
Nice coding style, too. I'll definitely install later.