The Arcive of Official vBulletin Modifications Site.

[APM] Advanced Product Management 2.0.4 · **Released**: 09-05-2005

[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

Boofo · #12 09-06-2005, 07:44 PM

Quote:

Originally Posted by mtha

I didnt try the code, but x means you dont have any setting for the coresponding product. I will come back with a new code tonight though

What I'm saying is there is a blank line with no product name at all. It just has 11 and x in it.

mtha · #13 09-06-2005, 09:05 PM

Quote:

Originally Posted by Boofo

What I'm saying is there is a blank line with no product name at all. It just has 11 and x in it.

Quote:

Hi!
I have upload both files to the right place.
Refresh the side, but I don?t have the Advanced Manage Product in the Plugin System.
(RC1)

What?s wrong?

If you uploaded the xml file to /includes/xml folder, you should see the link in Plugin menu, after refreshing browser.
If you still dont see it, I think there's a "How-To" thread showing you how to work around on AdminCP menu.

Quote:

What I'm saying is there is a blank line with no product name at all. It just has 11 and x in it.

Boofo, hehe, I got the same problem, with 4 plugins. I look at the database and find out that I have some plugins that have "product name" but doesnt actually have a product for it. that's why.

Maybe, adding someing like "Un-assigned product" on that line would help

, or building a product list and just count in the list

Boofo · #14 09-06-2005, 09:20 PM

Quote:

Originally Posted by mtha

Boofo, hehe, I got the same problem, with 4 plugins. I look at the database and find out that I have some plugins that have "product name" but doesnt actually have a product for it. that's why.

Maybe, adding someing like "Un-assigned product" on that line would help

, or building a product list and just count in the list

But that never showed up in the regular product listing. This is the first time I have seen it.

Is there a way to do the product listing alphabetically like it was originally?

mtha · #15 09-06-2005, 10:27 PM

Quote:

Originally Posted by Boofo

But that never showed up in the regular product listing. This is the first time I have seen it.

well, because it doesnt have a real product. it's like when you add a plugin, or phrase, or something to database, and just give it some product name. This name doesnt actually exist in product table, => not listed in product listing.

Quote:

Is there a way to do the product listing alphabetically like it was originally?

Query fixed and sorted. Updated on the attachment

I modify alitle bit on KirbyDE code, adding the product list to counting queries.

PHP Code:


			
    $productq = $db->query_read("
        SELECT * 
        FROM " . TABLE_PREFIX . "product
        ORDER BY title");

   while ($product = $db->fetch_array($productq))
    {
        $products["$product[productid]"] = $product;
        $products["$product[productid]"]['plugin'] = 0;
        $products["$product[productid]"]['phrase'] = 0;
        $products["$product[productid]"]['template'] = 0;
        $products["$product[productid]"]['setting'] = 0;
    }
    ksort($products);
    $productlist = "'". implode('\',\'',array_keys($products)) ."'";

 $pluginq = $db->query_read("SELECT product, COUNT(pluginid) AS plugin FROM " . TABLE_PREFIX . "plugin WHERE product IN ($productlist) GROUP BY product");
    while ($plugin = $db->fetch_array($pluginq))
    {
        $products["$plugin[product]"]['plugin'] = $plugin['plugin'];
    }

 $phraseq = $db->query_read("SELECT product, COUNT(phraseid) AS phrase FROM " . TABLE_PREFIX . "phrase WHERE languageid=-1 AND product IN ($productlist) GROUP BY product");
    while ($phrase = $db->fetch_array($phraseq))
    {
        $products["$phrase[product]"]['phrase'] = $phrase['phrase'];
    }

 $templateq = $db->query_read("SELECT product, COUNT(templateid) AS template FROM " . TABLE_PREFIX . "template WHERE styleid=-1 AND product IN ($productlist) GROUP BY product");
    while ($template = $db->fetch_array($templateq))
    {
        $products["$template[product]"]['template'] = $template['template'];
    }
    
$settingq = $db->query_read("SELECT product, COUNT(varname) AS setting FROM " . TABLE_PREFIX . "setting WHERE product IN ($productlist) GROUP BY product");
    while ($setting = $db->fetch_array($settingq))
    {
        $products["$setting[product]"]['setting'] = $setting['setting'];
    }

Boofo · #16 09-06-2005, 10:44 PM

Quote:

Originally Posted by mtha

well, because it doesnt have a real product. it's like when you add a plugin, or phrase, or something to database, and just give it some product name. This name doesnt actually exist in product table, => not listed in product listing.

Then it shouldn't show up in this listing either, right?

Boofo · #17 09-06-2005, 10:51 PM

Ok, with the update, my problem has been fixed. The blank line is no longer there. But there is a new problem. The beginning of the line has the actual product file name and not the title. Shouldn't it have the title there instead like it did in the old one?

mtha · #18 09-07-2005, 03:35 AM

download the file again, and you get what you want

Boofo · #19 09-07-2005, 03:45 AM

Quote:

Originally Posted by mtha

download the file again, and you get what you want

Thank you, sir, but they are still not in alphabetical order. Close though.

mtha · #20 09-07-2005, 06:18 AM

Quote:

Originally Posted by Boofo

Thank you, sir, but they are still not in alphabetical order. Close though.

Agrrr, you are fooling me around :>

It was sorted by title, but I shows the productid for testing, then I force it to resort by productid, and display title

)

now you have the product list sorted by title

and you have the product's details collapsible

have fun. I will do the "come back after editting" later

Boofo · #21 09-07-2005, 06:32 AM

No, sir, I'm not fooling with you. See the attached.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.05764 seconds Memory Usage 2,348KB Queries Executed 25 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_php (10)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!